anybody know the name of the sp executed while getting reward on CTF (the tickets trophies)?
Printable View
anybody know the name of the sp executed while getting reward on CTF (the tickets trophies)?
The reward is hardcoded in GameServer :)
check addlogchar...
Check for the latest regionid update.. if is ctf then log the kills... that way u can grant items into the storage while ctf goes on.
= you can do anything as a reward.. silk,items,sp,exp,level.. the list goes on
i dont need the reward or to set a diff one, its just while getting the tickets , u get it on a real-time basis,i assumed its a sp and that what i want. (i dont care about the reward nor the CTF itself lol)
Oh lol. You want to know the name of the stored procedure that add an item to the inventory?
the name is: _ADD_ITEM_EXTERN
in the shard..
However, it's not that the procedure adds it in real-time, rather it's that the gameserver REQUESTS it to be added and the GAMESERVER then sends the data to the client to to visulize it in real time.
If you add it db sidedly... how is the gameserver suppose to know u added something? It's not like it's checking the inventory slots every 5 seconds... its not a plug and play USB stick.
You can execute the procedure, but you'l have to relog or teleport in ordner for it to appear. Also, if u add an item and the person buy something from anywhere.. he will get instant dced.
Why?
Simple, cause the gs will try to put the new item into the free slot.. however db sidedly the slot isn't free => Error => Disconnect.
Therefore, if you want to add rewards or anything hook it to the logoff. Or it might be possible to put it into the chest in "realtime" (as long as its not opened at that specific moment...)