ThreadBoard ArchivesSite FeaturesActiveworlds SupportHistoric Archives |
SQL Bot Notes (Bots)
SQL Bot Notes // Botsjim flemingFeb 4, 1999, 4:35pm
This is a multi-part message in MIME format.
------=_NextPart_000_01A5_01BE503A.D951E220 Content-Type: multipart/alternative; boundary="----=_NextPart_001_01A6_01BE503A.D951E220" ------=_NextPart_001_01A6_01BE503A.D951E220 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Here are some SQL Bot notes... 1.. Observes the creation of objects and makes updates in the data = base. 2.. Looks over someone's shoulder to keep database in synch with = world. 3.. Queries data base and creates objects. 4.. No change should be required to the existing AW servers. 5.. A round-trip test is needed from the AW Browser to the AW server = with a parallel link to the database server and then back to a web = browser with web feedback into the AW Browser. 6.. mSQL seems like a natural given people's interest in open source = projects. 7.. See also http://www.objectshare.com Jim Fleming Unir Corporation UNIR, COM, and UNETY worlds in AW ------=_NextPart_001_01A6_01BE503A.D951E220 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><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:019c01be506d$23e4b100$e10a9cd1 at technocat = bgColor=3D#ffffff> <DIV>Here are some SQL Bot notes...</DIV> <DIV> </DIV> <OL> <LI>Observes the creation of objects and makes updates in the data=20 base.</LI> <LI>Looks over someone's shoulder to keep database in synch with = world.</LI> <LI>Queries data base and creates objects.</LI> <LI>No change should be required to the existing AW servers.</LI> <LI>A round-trip test is needed from the AW Browser to the AW server = with a=20 parallel link to the database server and then back to a web browser = with web=20 feedback into the AW Browser.</LI> <LI>mSQL seems like a natural given people's interest in open source = projects.</LI> <LI>See also <A=20 = href=3D"http://www.objectshare.com">http://www.objectshare.com</A></LI></= OL> <DIV> </DIV> <DIV>Jim Fleming</DIV> <DIV>Unir Corporation</DIV> <DIV>UNIR, COM, and UNETY worlds in AW</DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_001_01A6_01BE503A.D951E220-- ------=_NextPart_000_01A5_01BE503A.D951E220 Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <019c01be506d$23e4b100$e10a9cd1 at technocat> 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_01A5_01BE503A.D951E220-- lucioFeb 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-- andras sarkozyFeb 7, 1999, 4:52pm
--------------0310382DCBA5EC532BB75B5C
Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Do you access the cell.dat and the cell.idx files while the world server is running? I could use this knowledge :) Andras [View Quote] > 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] --------------0310382DCBA5EC532BB75B5C Content-Type: multipart/related; boundary="------------14ED9A44647C81780C23ABDA" --------------14ED9A44647C81780C23ABDA Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> <body bgcolor="#FFFFFF" background="cid:part1.36BDE109.F3EA1376 at mail.storage.co.hu"> Do you access the cell.dat and the cell.idx files while the world server is running? I could use this knowledge :) <br>Andras <br> [View Quote] <li> Looks over someone's shoulder to keep database in synch with world.</li> <li> Queries data base and creates objects.</li> <li> No change should be required to the existing AW servers.</li> <li> A round-trip test is needed from the AW Browser to the AW server with a parallel link to the database server and then back to a web browser with web feedback into the AW Browser.</li> <li> mSQL seems like a natural given people's interest in open source projects.</li> <li> See also <a href="http://www.objectshare.com">http://www.objectshare.com</a></li> </ol> Jim FlemingUnir CorporationUNIR, COM, and UNETY worlds in AW </blockquote> </blockquote> </body> </html> --------------14ED9A44647C81780C23ABDA Content-Type: image/gif Content-ID: <part1.36BDE109.F3EA1376 at mail.storage.co.hu> Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="D:\TEMP\nsmailS6.gif" R0lGODlhFAAUAPcAAP//////zP//mf//Zv//M///AP/M///MzP/Mmf/MZv/MM//MAP+Z//+Z zP+Zmf+ZZv+ZM/+ZAP9m//9mzP9mmf9mZv9mM/9mAP8z//8zzP8zmf8zZv8zM/8zAP8A//8A zP8Amf8AZv8AM/8AAMz//8z/zMz/mcz/Zsz/M8z/AMzM/8zMzMzMmczMZszMM8zMAMyZ/8yZ zMyZmcyZZsyZM8yZAMxm/8xmzMxmmcxmZsxmM8xmAMwz/8wzzMwzmcwzZswzM8wzAMwA/8wA zMwAmcwAZswAM8wAAJn//5n/zJn/mZn/Zpn/M5n/AJnM/5nMzJnMmZnMZpnMM5nMAJmZ/5mZ zJmZmZmZZpmZM5mZAJlm/5lmzJlmmZlmZplmM5lmAJkz/5kzzJkzmZkzZpkzM5kzAJkA/5kA zJkAmZkAZpkAM5kAAGb//2b/zGb/mWb/Zmb/M2b/AGbM/2bMzGbMmWbMZmbMM2bMAGaZ/2aZ zGaZmWaZZmaZM2aZAGZm/2ZmzGZmmWZmZmZmM2ZmAGYz/2YzzGYzmWYzZmYzM2YzAGYA/2YA zGYAmWYAZmYAM2YAADP//zP/zDP/mTP/ZjP/MzP/ADPM/zPMzDPMmTPMZjPMMzPMADOZ/zOZ zDOZmTOZZjOZMzOZADNm/zNmzDNmmTNmZjNmMzNmADMz/zMzzDMzmTMzZjMzMzMzADMA/zMA zDMAmTMAZjMAMzMAAAD//wD/zAD/mQD/ZgD/MwD/AADM/wDMzADMmQDMZgDMMwDMAACZ/wCZ zACZmQCZZgCZMwCZAABm/wBmzABmmQBmZgBmMwBmAAAz/wAzzAAzmQAzZgAzMwAzAAAA/wAA zAAAmQAAZgAAMwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAFAAUAEAIQwBJCBxIsKBBAAgTKlyYUCDD hwsdQpwoceLDihYjksh4cSNHjR9BhmzocSQAjCFRflTJkWVGlxZhUiw5UiZEgzhzBgQAOw== --------------14ED9A44647C81780C23ABDA-- --------------0310382DCBA5EC532BB75B5C-- jim flemingFeb 7, 1999, 5:59pm
Great....!!!!!!
Can you give more details on the development environment and how other people can help with the evolution ? JF [View Quote] LP [View Quote] 1.. Observes the creation of objects and makes updates in the data base. 2.. Looks over someone's shoulder to keep database in synch with world. 3.. Queries data base and creates objects. 4.. No change should be required to the existing AW servers. 5.. A round-trip test is needed from the AW Browser to the AW server with a parallel link to the database server and then back to a web browser with web feedback into the AW Browser. 6.. mSQL seems like a natural given people's interest in open source projects. 7.. See also http://www.objectshare.com Jim Fleming Unir Corporation UNIR, COM, and UNETY worlds in AW lucioFeb 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 |