Board ArchivesSite FeaturesActiveworlds SupportHistoric Archives |
lucio // User Search
lucio // User SearchSQL Bot NotesFeb 7, 1999, 4:24pm
This is a multi-part message in MIME format.
------=_NextPart_000_0048_01BE52CF.822F5300 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0049_01BE52CF.822F5300" ------=_NextPart_001_0049_01BE52CF.822F5300 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have an SQL bot running... it works both ways between a World and = SQLserver. I am converting it to work with ODBC. LP [View Quote] ------=_NextPart_001_0049_01BE52CF.822F5300 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN"> <HTML> <HEAD> <META content=3Dtext/html;charset=3Diso-8859-1 = http-equiv=3DContent-Type><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 = HTML//EN"><BASE=20 href=3Dfile://C:\PROGRA~1\COMMON~1\MICROS~1\Stationery\> <STYLE> <!-- body, PRE, BLOCKQUOTE, a, MENU, dd, UL, DT, dir, ADDRESS, h1, h2, h3, = h4, h5, h6, HR { font-family: "Arial"; font-size: 12pt; color: 000000; } --> </STYLE> <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR> </HEAD> <BODY background=3Dcid:003f01be52c7$1fe4a400$0201010a at client = bgColor=3D#ffffff> <DIV><FONT color=3D#000000 size=3D2>I have an SQL bot running... it = works both ways=20 between a World and SQLserver. I am converting it to work with=20 ODBC.</FONT></DIV> <DIV><FONT color=3D#000000 size=3D2></FONT> </DIV> <DIV><FONT size=3D2>LP</FONT></DIV> <BLOCKQUOTE=20 style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px"> [View Quote] ------=_NextPart_001_0049_01BE52CF.822F5300-- ------=_NextPart_000_0048_01BE52CF.822F5300 Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <003f01be52c7$1fe4a400$0201010a at client> R0lGODlhFAAUAPcAAP//////zP//mf//Zv//M///AP/M///MzP/Mmf/MZv/MM//MAP+Z//+ZzP+Z mf+ZZv+ZM/+ZAP9m//9mzP9mmf9mZv9mM/9mAP8z//8zzP8zmf8zZv8zM/8zAP8A//8AzP8Amf8A Zv8AM/8AAMz//8z/zMz/mcz/Zsz/M8z/AMzM/8zMzMzMmczMZszMM8zMAMyZ/8yZzMyZmcyZZsyZ M8yZAMxm/8xmzMxmmcxmZsxmM8xmAMwz/8wzzMwzmcwzZswzM8wzAMwA/8wAzMwAmcwAZswAM8wA AJn//5n/zJn/mZn/Zpn/M5n/AJnM/5nMzJnMmZnMZpnMM5nMAJmZ/5mZzJmZmZmZZpmZM5mZAJlm /5lmzJlmmZlmZplmM5lmAJkz/5kzzJkzmZkzZpkzM5kzAJkA/5kAzJkAmZkAZpkAM5kAAGb//2b/ zGb/mWb/Zmb/M2b/AGbM/2bMzGbMmWbMZmbMM2bMAGaZ/2aZzGaZmWaZZmaZM2aZAGZm/2ZmzGZm mWZmZmZmM2ZmAGYz/2YzzGYzmWYzZmYzM2YzAGYA/2YAzGYAmWYAZmYAM2YAADP//zP/zDP/mTP/ ZjP/MzP/ADPM/zPMzDPMmTPMZjPMMzPMADOZ/zOZzDOZmTOZZjOZMzOZADNm/zNmzDNmmTNmZjNm MzNmADMz/zMzzDMzmTMzZjMzMzMzADMA/zMAzDMAmTMAZjMAMzMAAAD//wD/zAD/mQD/ZgD/MwD/ AADM/wDMzADMmQDMZgDMMwDMAACZ/wCZzACZmQCZZgCZMwCZAABm/wBmzABmmQBmZgBmMwBmAAAz /wAzzAAzmQAzZgAzMwAzAAAA/wAAzAAAmQAAZgAAMwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAFAAUAEAIQwBJCBxI sKBBAAgTKlyYUCDDhwsdQpwoceLDihYjksh4cSNHjR9BhmzocSQAjCFRflTJkWVGlxZhUiw5UiZE gzhzBgQAOw== ------=_NextPart_000_0048_01BE52CF.822F5300-- SQL Bot NotesFeb 7, 1999, 8:32pm
I've been working with the AW_QUERY of the sdk. I would suggest starting
from that to understand the process. My bot scans through all zones repetitively and keeps the relative sequence numbers updated on table. When ever a CELL_BEGIN message is received it deletes all objects in that cell and refreshes the DB the CELL_OBJECT events received. To manage the reverse sync I have an extra flag in the objects database that indicates if the object is in sync (s) or is to be (a)dded, (c)hange or (d)eleted. On the basis of this I execute the appropriate sdk instructions. The prog alternates between a sync and a build phase constantly. To build I just append objects with the (a)dd flag. To delete or modify I run an update query and change the flag to (d)elete or (c)change. Right now I have it working directly with Microsoft SQL Server using the SQL libraries directly. I am working on a generic ODBC version that will work with any DB and as soon as I have it working I will post it. Lucio aw_queryNov 6, 1998, 6:01pm
A couple of questions to whoever can help:
1) aw_query requires the int x_sector and int z_sector parameters. Are these real AW coordinates (i.e. 32N, 5W) or are they the reference to the sector in the zone ? 2) I have noticed that aw_object_number occasionaly returns some large and sometime negative number. The following is part of a dump of values retrieved from Virtualy which has about 65,000 objects. 57837,286443,905945912,-9500,2500,9000,900,v5012.rwx,, 57838,286443,905945912,-10000,2600,9000,1800,v5231.rwx,, 1622163995,188537,909781012,-9200,3000,9100,0,col10m02.rwx,, 926433427,188537,909781016,-9200,3000,9350,0,col10m02.rwx,, 2043787557,188537,909781038,-9200,2050,9350,0,col10m02.rwx,, The first number is the aw_object_number which makes sense in the first two lines. Is this normal ? What do the negative numbers mean ? Thanks for for your help. Lucio & Emanuele aw_queryNov 6, 1998, 7:30pm
On the same issue, and just to clarify question 1), how would I query
objects at say 15s 12e ? Thanks. LP aw_queryNov 9, 1998, 1:42pm
Thanks to both.
I had looked at the Property section of the Docs but was confused on the specific aw_query parameters I asked about. One reason I got confused is because I thought the ZONE was always referenced with respect to the position of the bot... thinking back I don't know how I got that idea. My objective is to build a bot that will keep the world synchronized with an SQL database. I am the builder of "Virtualy", a world entirely covered with a modular surface. The fact that the entire surface is covered with objects makes it impossible to use the traditional registry-based building control. To overcome this I have developed an SQL database structure (for the moment in MS-Access) which is periodically fed by a propdump. I have a set of queries and SQL scripts that allow me to monitor and do "bulk" maintenance on the world (For example: assign all objects in an area to a citizen so he can modify the ground and remove trees). The current problem is that changes made to the world by other citizens between the propdump and propload phases are lost. I believe an on-line SDK bot would eliminate this problem. I also think such a sync process should be fairly straight forward and similar to what the browser normaly does with the local cell.dat cache. My next step would be to build a reverse process that builds in the world from new records in the SQL database. This would eliminate the need for builder bot scripts (used in the beginning to create Virtualy) or the merge and propload which I currently use. In practice what I am aming at is an ODBC interface to the World Database :))) Comments on this idea ? Lucio aw_queryNov 9, 1998, 3:14pm
>The bots can only query one Zone at a time, and live input mode is good
only for >that Zone. Will you have your bot move around from Zone to Zone to detect new >construction? Yes :) The bot would constantly move between zones and refresh the DB both ways, with the world being primary in case of conflict. > >By the way, Virtualy is a beautiful place. All the trouble you took to build >with so many landscape objects was worth it. Thanks :) But the are relatively few objects in Virtualy as the idea was to mazimise object re-use. I will be teaching the technique at AWUniv at 21:00 VRT this coming saturday . LP Support for Nvidia Stereo DriversJun 18, 2002, 8:35pm
Now that 3.3 is DX8 compatible would it be possible to make it compatible
with the Nvidia Stereo drivers ? I have them and they work fine in progs like FS2002. Is it the lack of fullscreen mode ? |
