Thread

SQL Bot Notes (Bots)

SQL Bot Notes // Bots

1  |  

jim fleming

Feb 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>&nbsp;</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>&nbsp;</DIV>
<DIV>Jim Fleming</DIV>
<DIV>Unir Corporation</DIV>
<DIV>UNIR, COM, and UNETY worlds in AW</DIV>
<DIV>&nbsp;</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--

lucio

Feb 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>&nbsp;</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 sarkozy

Feb 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>&nbsp;
[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>
&nbsp;Jim FlemingUnir CorporationUNIR, COM, and UNETY worlds in AW&nbsp;</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 fleming

Feb 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

lucio

Feb 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

1  |  
Awportals.com is a privately held community resource website dedicated to Active Worlds.
Copyright (c) Mark Randall 2006 - 2021. All Rights Reserved.
Awportals.com   ·   ProLibraries Live   ·   Twitter   ·   LinkedIn