212 Commits

Author SHA1 Message Date
lickx c1b0d5d7ca Prefix tables with search
Except classifieds

This is to integrate search tables within the grid DB
2023-03-16 18:35:06 +01:00
Kevin Cozens b702986896 Don't enclose event coordinates with angle brackets
The event coordinates are expected to be a set of comma separated
numbers as stated in the README file.
2022-02-13 14:31:19 -05:00
Kevin Cozens 67644ca18b Fixed handling of maturity flags when searching for classified ads.
The code now handles the flags correct when dealing with old viewers
and old databases that may still be using the legacy PG and Mature bits.
2021-01-31 16:05:57 -05:00
Kevin Cozens b71681da0b Eliminated a compiler warning about duplicate Assembly. 2020-12-01 19:32:40 -05:00
Kevin Cozens ea3f06b489 Someone reported a problem with the module when SearchURL wasn't in quotes. 2019-01-08 16:38:38 -05:00
Kevin Cozens 69e69cf928 Fixed errors when compiled using msbuild. 2018-11-13 13:48:18 -05:00
Kevin Cozens 1612abd71d Require .NET 4.6 and updated pre-compiled binary.
Pre-compiled binary was built under Linux using the 5.12 version of mono.
2018-07-13 22:07:34 -04:00
Kevin Cozens b21c7adff1 Corrected schema and added migrations for the popularplaces table.
Region category returned by Datasnapshot module is a string and not an integer.
2018-05-14 15:41:08 -04:00
Kevin Cozens f9a7430e63 The popularplaces table was not being updated. This was an oversight. 2018-05-06 21:57:59 -04:00
Kevin Cozens 38d2af7146 Updated prebuild.xml to fix VS2015 build errors. Ordered Reference lines. 2017-05-11 23:49:39 -04:00
Kevin Cozens 064b845bb6 Added IF NOT EXISTS to CREATE TABLE statements in ossearch.sql (See issue #3) 2017-04-21 15:11:04 -04:00
Kevin Cozens 3a890f1b58 Fixed case error in references to regionUUID field in several tables 2017-04-21 14:45:54 -04:00
Kevin Cozens 583195154e Updated the pre-compiled DLL 2017-04-17 10:02:53 -04:00
Kevin Cozens b99c5d55a1 Converted the PHP files to use PDO as mysql_*() calls were removed in PHP 7 2017-04-16 17:51:29 -04:00
Kevin Cozens 63247aa640 Fixed RemoveRegion by removing event handler and removing scene inside a lock 2017-04-16 17:36:17 -04:00
Kevin Cozens a4254be915 Deleted call to m_log.Error routine. Modules should not say they're disabled. 2017-02-01 15:24:16 -05:00
Kevin Cozens d81faa31dc Fixed bad commit that was sending wrong day value to PHP for upcoming events.
Fixed dir_events_query in PHP file: always get current time in UTC, simplified
timezone handling, and include in-progress events when passed "u" for day number.
Updated pre-built OpenSimSearch.dll file.
2016-01-13 15:10:52 -05:00
kcozens e4864fceea Updated DLL for use with 0penSim 0.8.1-post-fixes.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@220 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2015-06-01 19:53:30 +00:00
kcozens ea70b5018c Changed name to avoid possible confusion with core modules of Open Simulator.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@219 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2015-06-01 03:26:13 +00:00
kcozens f54440fc00 Updated/added assembly statements required by OpenSimulator 0.8.1-post-fixes.
Bumped version number to "0.4".


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@218 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2015-06-01 03:22:31 +00:00
kcozens 9b020a5e93 Fixed calculation of start time used in event searches. Searches now include
events that are still in progress but started in a previous day. Updated README
about event date, duration, and landing point format. Updated pre-compiled DLL.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@216 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-05-13 23:39:49 +00:00
kcozens 7c824ceb10 Updated the pre-compiled DLL to remove some debug messages left in by mistake.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@215 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-05-13 15:11:54 +00:00
kcozens 74a209eb1b Updated the pre-compiled DLL.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@214 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-05-13 03:06:56 +00:00
kcozens cab8b033a8 DateEvents flag, not Events, is set when searching events with viewer Search.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@213 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-05-12 18:08:20 +00:00
kcozens 9ee7375660 Use '/' between the parts of event landing point coordinates. Updated README.
Allow 0 or -1 to be considered as the "Any" category for event listings.
Event markers are seen on the map again but still can't search for events.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@212 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-05-11 17:52:37 +00:00
kcozens 132254499f Updated the pre-compiled DLL.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@211 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-03-10 17:25:32 +00:00
kcozens ae57c23fa6 Removed code related to people and groups search to prevent duplicate results.
People and groups search is now handled via the core basic search module.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@210 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-03-10 17:17:41 +00:00
kcozens 4771cd90aa Added 'parcelUUID' field to events table.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@208 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-03-02 20:36:11 +00:00
kcozens 741c62175c Updated SQL file to create tables using UTF-8 charset and collation.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@207 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-03-01 00:01:39 +00:00
kcozens c520c5cd46 Updated to enable searching for groups in 0.7.6-post-fixes.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@206 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2014-01-18 04:17:09 +00:00
kcozens 22b1bd4fe3 Updated prebuild.xml file: removed path references, removed obsolete module
reference, and set frameworkVersion to 4_0 as .NET 4.0 is now default for OS.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@205 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-11-16 04:47:59 +00:00
kcozens 80c2e1a641 Updated the pre-compiled DLL.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@204 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-07-29 06:43:42 +00:00
kcozens 45480c288d Changes to allow event markers to appear on the world map.
Updated note in README about format for globalPos field in events table.
Don't need to search scene list for region data in OpenSearch.cs file.
Fixed passing of event_id to viewer.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@203 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-07-29 06:36:18 +00:00
kcozens 7aaa6f8dc5 Fixed time limits of event searches and include in-progress events.
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
2013-07-17 20:47:16 +00:00
kcozens 5d58ed32b0 Changed assembly name and bumped version. Fixed grammer of "ready" message.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@201 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-07-12 15:42:42 +00:00
kcozens f4c7f1e739 Updated SQL files to use char(36) for all UUID fields.
Corrected upgrade instructions in the README file.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@200 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-23 15:43:43 +00:00
kcozens 147012b8ab Updated the compilation and configuration information in the README file.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@199 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-23 03:16:03 +00:00
kcozens 5186ec068b Removed some obsolete information from the README file.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@198 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-23 01:59:02 +00:00
kcozens 0b56243e99 Trivial code clean up. Don't need else clause if execution gets that far.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@197 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-23 00:50:58 +00:00
kcozens d54733be77 Updated README with optional configuration line that specifies module name.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@196 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-23 00:44:07 +00:00
kcozens e2b4f0b60d Removed section from README about adding lines to [Modules] section.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@195 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-06-14 15:02:19 +00:00
melanie 3d7862d11a Add new ISearchModule interface member
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@194 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2013-01-15 21:25:59 +00:00
kcozens 4111378172 Use of $HTTP_RAW_POST_DATA is deprecated. Get data from php://input instead.
(See Forge bug #444)


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@193 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-12-24 18:46:58 +00:00
kcozens 917cb41436 Removed obsolete "Reference name" line from prebuild file. Updated DLL file.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@192 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-07-27 15:16:03 +00:00
kcozens 454e748a25 Use the text string to restrict results when searching classified ads.
This was previously fixed in revision 174 but got lost in some later commit.
The building of the SQL query in dir_classified_query() has been simplified.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@191 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-07-21 06:23:00 +00:00
kcozens 79bfe13c35 This commit properly fixes searching for classified ads regardless of type
(PG, Mature, or Adult). The previous commit didn't handle Adult rated ads.

NOTE: For searches of classified ads to work correctly you must use revision
106 of profile.php from the osprofile addon module. Any classifieds that were
created before using revision 106 of profile.php will need to be updated to
ensure that the PG bit is set in the classifiedflags field in the database.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@190 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-07-02 18:09:01 +00:00
kcozens 5da0311d08 Fix classifieds search when both PG and Mature results are being requested.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@189 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-07-01 06:12:36 +00:00
melanie 08e1f7172b Fix merge artefacts in the initialization code
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@188 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-06-05 11:30:19 +00:00
melanie 77bde11596 Replace the spammy init code with a cleaner version. Modules MUST NOT output
any messages when they are disabled.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@187 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-06-04 18:02:39 +00:00
kcozens 5488778731 Updated pre-compiled module DLL.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@186 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2012-02-02 07:32:22 +00:00