35 Commits
Author SHA1 Message Date
Kevin Cozens f9a7430e63 The popularplaces table was not being updated. This was an oversight. 2018-05-06 21:57:59 -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 b99c5d55a1 Converted the PHP files to use PDO as mysql_*() calls were removed in PHP 7 2017-04-16 17:51:29 -04:00
kcozens ca61f92e66 Stripped carriage returns from line endings.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@178 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2011-11-30 01:49:47 +00:00
kcozens 364e9869eb Replaced deprecated (as of PHP 5.3.0) function mysql_escape_string with
mysql_real_escape_string.


git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@168 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2011-10-28 16:05:33 +00:00
kcozens be52792f0c Changed "<?" to "<?php" for those not set to use short tags.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@167 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2011-10-28 15:57:08 +00:00
kcozens 04dc2778ac This commit fixes problems affecting Places search in a viewer.
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
2010-09-06 21:33:07 +00:00
kcozens 8d474acd04 Forward port of changes in versions 138 through 141 of the opensim_069 branch.
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
2010-08-30 02:04:39 +00:00
kcozens b436ad12a6 webroot/parser.php:
- 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
2010-08-23 06:52:03 +00:00
kcozens 62d45767fd - Check that CURL returned data before trying to parse it.
- 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
2010-08-23 04:54:45 +00:00
kcozens 47c00a0f35 webroot/parser.php:
- 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
2010-08-03 02:07:40 +00:00
kcozens 9805da5be5 Fixed copy/paste error in line that gets region category.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@125 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2010-07-14 18:52:36 +00:00
kcozens be17f7e1e3 - Changed alert message in OpenSimSearch/Modules/SearchModule/OpenSearch.cs
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
2010-07-14 18:01:58 +00:00
fly-man- 1c44864d04 [FIXED VERSION]
Added group support to the parser.php so we can safely parse group owned parcels as well

git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@116 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2009-04-28 01:36:55 +00:00
fly-man- d7db4c3ae6 [PATCH VERSION]
This might give lots of messaging on the console or webpage as error_logging is on to see where it goes wrong

git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@115 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2009-04-28 00:17:16 +00:00
fly-man- 03c87eda82 Clearing out a defunct version
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@114 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2009-04-28 00:16:21 +00:00
fly-man- e493645bf8 Sending the updated Parser as by default all local regions would be purged from the database.
Made it that it's optional. Read the parser.php comment

git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@103 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-12-23 01:11:41 +00:00
fly-man- f94e0415b2 Updated the Parser with internal ip control, deletes the internal ip address from the database.
Beware: If you run a local grid, comment out the lines 
$cleanquery1, $cleanquery2, $cleanquery3, $cleanquery4 to keep your internal regions safe.

git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@100 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-11-29 01:31:58 +00:00
fly-man- b1c2821c04 Update for the hostsregister table, making sure that a region doesn't make the file spit out messages.
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
2008-11-05 20:23:01 +00:00
fly-man- 8ccacdfb07 Updated svn
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@83 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-25 18:09:38 +00:00
melanie b3e20009fb Reintroduce lost changes, cleanup
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@68 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-18 14:53:44 +00:00
melanie a90ab7ec95 MySql and PHP update
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@38 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-11 08:45:02 +00:00
melanie 99119402f5 Adapt to latest DataSnapshot
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@31 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-11 01:30:13 +00:00
melanie 3d1235eae6 Update to new DataSnapshot module
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@30 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-11 00:36:36 +00:00
melanie 000709441a Add new infouuid field
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@22 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-05 16:42:36 +00:00
melanie 0f6c3ce258 Add processing of dwell to the parser
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@16 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-05 03:58:58 +00:00
melanie 14c283c7d7 Split estate user info into two fields
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@12 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-04 13:39:13 +00:00
melanie 67fe25e19d more refactoring for usablility in a real life situation
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@11 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-04 05:14:05 +00:00
melanie b0e4dcfcdb Add some more fields, rework code to preserve associaltions
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@10 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-04 04:59:41 +00:00
melanie 812c7dcd6e Complete and refactor parser
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@9 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-10-04 04:30:00 +00:00
fly-man- f7aa060543 Fixed some typo's in the parse, cron and register
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@8 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-09-25 20:38:12 +00:00
fly-man- 9a6cb46ce2 Fixed some typo's in the parse, cron and register
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@7 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-09-19 19:24:40 +00:00
fly-man- 16d2db22e6 Update to the Parser and made a basic CRON daemon that grabs 1 sim at a time and indexes it
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@6 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-09-19 19:05:06 +00:00
fly-man- d11ddc4d16 SVN updated with Parser that now checks for Host and Port that can be supplied by DB
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@5 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-09-18 19:56:47 +00:00
fly-man- db2acd3767 Initial Parser and database for parsing and putting into database.
git-svn-id: http://forge.opensimulator.org/svn/ossearch/trunk@4 109abde3-1f22-4c10-b5d7-b6b0135cd00c
2008-09-17 22:26:37 +00:00