Event searches for a given day now take timezone into account to get
to start of day. Updated README with mention of the timezone usage.
Updated database structure, migration file, and the pre-compiled DLL.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@202 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
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
- 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
Please update your database with the update-hostregister.sql for this to work
(BETA test, do NOT use this in production systems)
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@98 109abde3-1f22-4c10-b5d7-b6b0135cd00c
Kevin Cozens