|
SQL Bot Notes for SDK Users (Sdk)
SQL Bot Notes for SDK Users // Sdk
Feb 7, 1999, 9:05pm
Lucio,
Great job....I think this should get woven into the SDK work.
Jim Fleming
UNIR, COM and UNETY worlds in the AW galaxy
[View Quote]Lucio wrote in message <36be13dd.0 at homer>...
>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
>
>
>
>
>
|
|
