- Fixed problems in Popular Places query:
o Use supplied text and query start position when building SQL query
o Don't include search of 'description' field as it doesn't exist
README
- Corrected format for globalPos data in events table
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@177 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Added support for Event mapitem queries
webroot/query.php
- Fixed parsing of search string and handling of UTC offset
- Include region and landing point in returned data
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@176 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Restrict classifieds search based on supplied text (if any)
- Tidied up generation of SQL query for classifieds
- Cleaned up generation of WHERE clauses in SQL queries for:
popular places, land, events, and classifieds
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@174 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Search event name and description for the text string from the viewer.
(Based on a patch by Michelle Argus)
- Adjust local time to UTC when doing date based search
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@173 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Use enum value instead of hard-coded number for land sales
webroot/sql/ossearch.sql
- Changed dateUTC and covercharge fields in events table.
webroot/sql/update-events-classifieds.sql
webroot/sql/update-hostregister.sql
webroot/sql/update-parcelsales.sql - Deleted these files
webroot/sql/ossearch-migrations.sql
- Added this file which lists all search database migrations organized by
SVN version. This makes it much easier to see what has changed from one
version of code to the next.
webroot/query.php
- Search by date now works when looking for current and upcoming events, or
when searching for dates on a given day.
- Provide a default value for category when returning event info to avoid a
PHP error about use of uninitialized variable.
README
- Added comments about event listings and events database table.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@172 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Don't report no data for classified as we might be creating a new ad
- In MapItemRequest(), get out of foreach once we find a match to the
parcel uuid as only one X/Y location is added for each parcel.
- Added the '*256' multiplier to the X/Y parcel location that was missing
from the previous commit. This allows $ icons appear on the map for land
sales. NOTE: This only seems to work when 0.6.9 is running standalone.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@165 109abde3-1f22-4c10-b5d7-b6b0135cd00c
Added a README file and removed the OpenSimSearch/OpenSim-addition.ini.example
file as the information it contained is now in the new README file.
webroot/query.php:
The previous commit should have stated that results of a search of classifieds
are now returned in descending order based on the listing price.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@161 109abde3-1f22-4c10-b5d7-b6b0135cd00c
the "Unable to search" message when opening map. Fixed land sales search when
land type is set to "All types".
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@155 109abde3-1f22-4c10-b5d7-b6b0135cd00c
webroot/sql/ossearch.sql:
- Added default value to 'mature' column.
webroot/sql/update-parcelsales.sql:
- Fixed syntax of SQL command that adds 'mature' column.
webroot/parser.php:
- Save region category in parcels table.
webroot/query.php:
- Fixed generation of SQL query used to search to parcels table.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@153 109abde3-1f22-4c10-b5d7-b6b0135cd00c
Handle region type for classifieds, events, land sales, and places.
Generation of SQL queries now handle cases where OR expressions
are used to select one of several values for a column based on
flags in addition to AND expressions in WHERE.
Corrected the size of several columns in the database schema.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@149 109abde3-1f22-4c10-b5d7-b6b0135cd00c
r141:
OpenSimSearch/Modules/SearchModule/OpenSearch.cs:
- Added comments about the origin of some of the constants used.
OpenSimSearch/OpenSim-addition.ini.example:
- Added note about extra lines to add to Modules section of OpenSim.ini file.
r140:
Eliminated the need to call fsockopen() to check if host is online.
r139:
Renamed lastcheck to nextcheck in hostsregister table to better reflect
its usage. Removed HTML tag from parser.php that got left in by mistake.
In register.php, reset nextcheck and checked when a host registers.
r138:
The data parser was getting stuck on a single entry in hostsregister table.
The lastcheck time wasn't enough to determine the next host to contact.
A column was added to hostsregister to track which hosts have been checked.
A host will not be checked again until all others have been checked.
CheckHost() routine was cleaned up. Always update hostsregister. GetURL()
now waits up to 10 seconds for connection and up to 30 seconds for data.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@142 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Don't try and parse XML if the load operation failed
- Capitalized SQL keywords
webroot/register.php:
- Reset failcounter when a region re-registers
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@135 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Check that XML has region data before trying to parse it.
- Code clean ups (possible memory leak, removed dead code, de-tabified file).
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@133 109abde3-1f22-4c10-b5d7-b6b0135cd00c
- Capitalize keywords in SQL queries.
webroot/sql/ossearch.sql:
- Change default for mature column of parcelsales table to PG.
webroot/sql/update-parcelsales.sql:
- Added this file to update existing an parcelsales table.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@126 109abde3-1f22-4c10-b5d7-b6b0135cd00c
when no classifieds exist in search database.
- In webroot/parser.php
o Save estate ID and region category in parcelsales table.
o Save object location in objects table.
o Minor formatting changes
- Trivial format change to one line of webroot/wiredux/README.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@124 109abde3-1f22-4c10-b5d7-b6b0135cd00c
kcozens