Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
OpenSim/OpenSearch
[
Front page
]
[ ]
Start:
** OpenSearch Module for OpenSim
*** DB
**** search_allparcels
MariaDB [opensim_op]> show columns from search_allparcels;
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | MUL | ...
| parcelname | varchar(255) | NO | | ...
| owneruuid | varchar(36) | NO | | 00000000-00...
| groupuuid | varchar(36) | NO | | 00000000-00...
| landingpoint | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | 00000000-00...
| infouuid | varchar(36) | NO | | 00000000-00...
| parcelarea | bigint(11) | NO | | NULL ...
+--------------+--------------+------+-----+------------...
8 rows in set (0.00 sec)
**** search_events
MariaDB [opensim_op]> show columns from search_events;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| uid | int(8) | NO | | 0 | ...
| owneruuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| eventid | bigint(11) | NO | PRI | NULL | ...
| creatoruuid | varchar(36) | NO | | | ...
| category | tinyint(2) | NO | | NULL | ...
| description | longtext | NO | | NULL | ...
| dateutc | bigint(10) | NO | | NULL | ...
| duration | bigint(10) | NO | | NULL | ...
| covercharge | bigint(10) | NO | | NULL | ...
| coveramount | bigint(10) | NO | | NULL | ...
| simname | varchar(255) | NO | | | ...
| globalpos | varchar(255) | NO | | | ...
| eventflags | tinyint(1) | NO | | NULL | ...
+-------------+--------------+------+-----+---------+---...
14 rows in set (0.00 sec)
**** search_hostsregister
MariaDB [opensim_op]> show columns from search_hostsregi...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| host | varchar(255) | NO | PRI | | ...
| port | mediumint(5) | NO | PRI | NULL | ...
| register | bigint(10) | NO | | NULL | ...
| nextcheck | bigint(10) | NO | | NULL | ...
| checked | tinyint(1) | NO | | NULL | ...
| failcounter | bigint(10) | NO | | NULL | ...
+-------------+--------------+------+-----+---------+---...
6 rows in set (0.00 sec)
**** search_objects
MariaDB [opensim_op]> show columns from search_objects;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| objectuuid | varchar(36) | NO | PRI | | ...
| parceluuid | varchar(36) | NO | PRI | | ...
| location | varchar(255) | NO | | | ...
| name | varchar(255) | NO | | | ...
| description | varchar(255) | NO | | | ...
| regionuuid | varchar(36) | NO | | | ...
+-------------+--------------+------+-----+---------+---...
6 rows in set (0.00 sec)
**** search_parcels
MariaDB [opensim_op]> show columns from search_parcels;
+----------------+----------------------+------+-----+--...
| Field | Type | Null | Key | D...
+----------------+----------------------+------+-----+--...
| regionuuid | varchar(36) | NO | PRI | ...
| parcelname | varchar(255) | NO | MUL | ...
| parceluuid | varchar(36) | NO | PRI | ...
| landingpoint | varchar(255) | NO | | ...
| description | varchar(255) | NO | MUL | ...
| searchcategory | varchar(50) | NO | MUL | ...
| build | enum('true','false') | NO | | f...
| script | enum('true','false') | NO | | f...
| public | enum('true','false') | NO | | f...
| dwell | decimal(20,8) | NO | MUL | N...
| infouuid | varchar(36) | NO | | ...
| mature | varchar(10) | NO | | P...
+----------------+----------------------+------+-----+--...
12 rows in set (0.00 sec)
**** search_parcelsales
MariaDB [opensim_op]> show columns from search_parcelsal...
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | PRI | ...
| parcelname | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | ...
| area | mediumint(6) | NO | | NULL ...
| saleprice | bigint(11) | NO | | NULL ...
| landingpoint | varchar(255) | NO | | ...
| infouuid | varchar(36) | NO | | 00000000-00...
| dwell | bigint(11) | NO | | NULL ...
| parentestate | bigint(11) | NO | | 1 ...
| mature | varchar(10) | NO | | PG ...
+--------------+--------------+------+-----+------------...
10 rows in set (0.00 sec)
**** search_popularplaces
MariaDB [opensim_op]> show columns from search_popularpl...
+-------------+---------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+-------------+---------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| regionuuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| dwell | decimal(20,8) | NO | | NULL | ...
| infouuid | varchar(32) | NO | | | ...
| has_picture | smallint(4) | NO | | NULL | ...
| mature | smallint(4) | NO | | NULL | ...
+-------------+---------------+------+-----+---------+--...
7 rows in set (0.00 sec)
**** search_regions
MariaDB [opensim_op]> show columns from search_regions;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| regionname | varchar(255) | NO | | | ...
| regionuuid | varchar(36) | NO | PRI | | ...
| regionhandle | varchar(255) | NO | | | ...
| url | varchar(255) | NO | | | ...
| owner | varchar(255) | NO | | | ...
| owneruuid | varchar(36) | NO | | | ...
+--------------+--------------+------+-----+---------+--...
6 rows in set (0.00 sec)
End:
** OpenSearch Module for OpenSim
*** DB
**** search_allparcels
MariaDB [opensim_op]> show columns from search_allparcels;
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | MUL | ...
| parcelname | varchar(255) | NO | | ...
| owneruuid | varchar(36) | NO | | 00000000-00...
| groupuuid | varchar(36) | NO | | 00000000-00...
| landingpoint | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | 00000000-00...
| infouuid | varchar(36) | NO | | 00000000-00...
| parcelarea | bigint(11) | NO | | NULL ...
+--------------+--------------+------+-----+------------...
8 rows in set (0.00 sec)
**** search_events
MariaDB [opensim_op]> show columns from search_events;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| uid | int(8) | NO | | 0 | ...
| owneruuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| eventid | bigint(11) | NO | PRI | NULL | ...
| creatoruuid | varchar(36) | NO | | | ...
| category | tinyint(2) | NO | | NULL | ...
| description | longtext | NO | | NULL | ...
| dateutc | bigint(10) | NO | | NULL | ...
| duration | bigint(10) | NO | | NULL | ...
| covercharge | bigint(10) | NO | | NULL | ...
| coveramount | bigint(10) | NO | | NULL | ...
| simname | varchar(255) | NO | | | ...
| globalpos | varchar(255) | NO | | | ...
| eventflags | tinyint(1) | NO | | NULL | ...
+-------------+--------------+------+-----+---------+---...
14 rows in set (0.00 sec)
**** search_hostsregister
MariaDB [opensim_op]> show columns from search_hostsregi...
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| host | varchar(255) | NO | PRI | | ...
| port | mediumint(5) | NO | PRI | NULL | ...
| register | bigint(10) | NO | | NULL | ...
| nextcheck | bigint(10) | NO | | NULL | ...
| checked | tinyint(1) | NO | | NULL | ...
| failcounter | bigint(10) | NO | | NULL | ...
+-------------+--------------+------+-----+---------+---...
6 rows in set (0.00 sec)
**** search_objects
MariaDB [opensim_op]> show columns from search_objects;
+-------------+--------------+------+-----+---------+---...
| Field | Type | Null | Key | Default | Ex...
+-------------+--------------+------+-----+---------+---...
| objectuuid | varchar(36) | NO | PRI | | ...
| parceluuid | varchar(36) | NO | PRI | | ...
| location | varchar(255) | NO | | | ...
| name | varchar(255) | NO | | | ...
| description | varchar(255) | NO | | | ...
| regionuuid | varchar(36) | NO | | | ...
+-------------+--------------+------+-----+---------+---...
6 rows in set (0.00 sec)
**** search_parcels
MariaDB [opensim_op]> show columns from search_parcels;
+----------------+----------------------+------+-----+--...
| Field | Type | Null | Key | D...
+----------------+----------------------+------+-----+--...
| regionuuid | varchar(36) | NO | PRI | ...
| parcelname | varchar(255) | NO | MUL | ...
| parceluuid | varchar(36) | NO | PRI | ...
| landingpoint | varchar(255) | NO | | ...
| description | varchar(255) | NO | MUL | ...
| searchcategory | varchar(50) | NO | MUL | ...
| build | enum('true','false') | NO | | f...
| script | enum('true','false') | NO | | f...
| public | enum('true','false') | NO | | f...
| dwell | decimal(20,8) | NO | MUL | N...
| infouuid | varchar(36) | NO | | ...
| mature | varchar(10) | NO | | P...
+----------------+----------------------+------+-----+--...
12 rows in set (0.00 sec)
**** search_parcelsales
MariaDB [opensim_op]> show columns from search_parcelsal...
+--------------+--------------+------+-----+------------...
| Field | Type | Null | Key | Default ...
+--------------+--------------+------+-----+------------...
| regionuuid | varchar(36) | NO | PRI | ...
| parcelname | varchar(255) | NO | | ...
| parceluuid | varchar(36) | NO | PRI | ...
| area | mediumint(6) | NO | | NULL ...
| saleprice | bigint(11) | NO | | NULL ...
| landingpoint | varchar(255) | NO | | ...
| infouuid | varchar(36) | NO | | 00000000-00...
| dwell | bigint(11) | NO | | NULL ...
| parentestate | bigint(11) | NO | | 1 ...
| mature | varchar(10) | NO | | PG ...
+--------------+--------------+------+-----+------------...
10 rows in set (0.00 sec)
**** search_popularplaces
MariaDB [opensim_op]> show columns from search_popularpl...
+-------------+---------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+-------------+---------------+------+-----+---------+--...
| id | bigint(10) | NO | PRI | NULL | a...
| regionuuid | varchar(36) | NO | | | ...
| name | varchar(255) | NO | | | ...
| dwell | decimal(20,8) | NO | | NULL | ...
| infouuid | varchar(32) | NO | | | ...
| has_picture | smallint(4) | NO | | NULL | ...
| mature | smallint(4) | NO | | NULL | ...
+-------------+---------------+------+-----+---------+--...
7 rows in set (0.00 sec)
**** search_regions
MariaDB [opensim_op]> show columns from search_regions;
+--------------+--------------+------+-----+---------+--...
| Field | Type | Null | Key | Default | E...
+--------------+--------------+------+-----+---------+--...
| regionname | varchar(255) | NO | | | ...
| regionuuid | varchar(36) | NO | PRI | | ...
| regionhandle | varchar(255) | NO | | | ...
| url | varchar(255) | NO | | | ...
| owner | varchar(255) | NO | | | ...
| owneruuid | varchar(36) | NO | | | ...
+--------------+--------------+------+-----+---------+--...
6 rows in set (0.00 sec)
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2025
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today
Who's Online
111 user(s) are online (8 user(s) are browsing xpwiki)
Members: 0
Guests: 111
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com