Sql Code plz

[liora]

what is the code to give somone boosters (with quary analyzer) ?

and does anyone know how can i chack whos chars online ?

(not ACCOUNT online . CHARS online)

 

[scgodz]

Player online is TblOccupiedGameID1.
For the code, just make a char that has every booster and copy over the code.

 

[liora]

but there isnt such table .

there is tblOccupiedBillID (BILL ID = ACCOUNTS)
there isnt such table TblOccupiedGameID1

any help ?

 

[scgodz]

There is supposed to be a table like that in every database of RM. Seeing as this is how most online pages work. TblOccoupiedGameID, TblOccoupiedGameID1 and TblOccoupiedGameID8 if I'm not mistaking.

 

[4nntt]

but there isnt such table .

there is tblOccupiedBillID (BILL ID = ACCOUNTS)
there isnt such table TblOccupiedGameID1

any help ?

You are correct. The 3.x server versions do not have the tblOccupiedGameID tables like the 4.x servers, only the tblOccupiedBillID table.

To work around this, I added a column to the billID table to hold a gameID and created a trigger on tblGameID to update the billID table whenever tblGameID is updated.

You can find more information on this work-around for the problem in this thread:

http://forum.ragezone.com/f112/just-idea-120769/