lickx
089e57e172
Merge branch 'lickx' of https://github.com/lickx/OpenSimSearch into lickx
2025-11-26 07:47:23 +01:00
lickx
a5269a9d5a
postgresql (untested) and use case insensitive search
2025-11-26 07:40:16 +01:00
lickx
ee0d538499
Remove a collation, add a 'purge' stored procedure
2025-11-26 07:39:16 +01:00
lickx
231437ade5
Cleanup *.sql's for table creation
2024-09-06 06:35:09 +02:00
lickx
98aa794b4f
Add parcel picture uuid
...
This obviously is a jpeg2k texture asset, so if you want to use it
in a website (for example a land sales page), it needs converting
to regular jpeg or png, after retrieving it from the asset server
2024-07-19 19:19:03 +02:00
lickx
605baca88d
.NET 8.0
2024-04-21 03:52:31 +02:00
lickx
931da38bd4
Use default mariadb collation
2023-08-26 02:56:54 +00:00
lickx
5ad11ae533
Mostly changes and suggestions from Tampa
2023-08-06 10:16:13 +00:00
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