Player Online Item Insert Script

[jademaster]

I have seen this in action 2 years ago.. but cant find it in search. anyone knows about this? it basically only inserts items to who are online.. thanks

 

[likertuban]

there's a lot of query to check who is online,
after that you just need query to insert item,
but the accuracy of who online query is questionable :
as for me, i would rather integrating such a feature to module, because my module can detect who is currently online in the game (not included in lobby)
more accurately...
insert item is in tbl_itemcharge if i'm not wrong,
as for who online, that is the real challenge, look for yourself, but i'm pretty much sure that query in sql for checking who is online is not accurate (CMIIW)
and if you insert item using query in itemcharge, the player need to relog before they get the item...

 

[jademaster]

thanks liker yes i have seen that back then. you need to relog before you see the item.. have any idea if there are game cp shared here that includes that kind of script?

Edit:

Use RF_WORLD




DECLARE KodeItem INT


DECLARE @JumlahItem bigint


DECLARE @UpgradeItem int


DECLARE namaPenerima int














SET namaPenerima = (Select Serial From dbo.tbl_base where Name='fahrultest')


SET KodeItem = (Select SQLcode From ItemCode.dbo.tbl_master_item where item_code='iubws56')


Set @JumlahItem = '1'


Set @UpgradeItem = '1879048192'








INSERT INTO dbo.tbl_ItemCharge


(nAvatorSerial, nItemCode_K, nItemCode_D, nItemCode_U)


VALUES namaPenerima KodeItem,@JumlahItem,@UpgradeItem)

Now i only need to convert it so that it only gives items to those who are online

 

[cristalninja]

thanks liker yes i have seen that back then. you need to relog before you see the item.. have any idea if there are game cp shared here that includes that kind of script?

Edit:

Use RF_WORLD




DECLARE KodeItem INT


DECLARE @JumlahItem bigint


DECLARE @UpgradeItem int


DECLARE namaPenerima int














SET namaPenerima = (Select Serial From dbo.tbl_base where Name='fahrultest')


SET KodeItem = (Select SQLcode From ItemCode.dbo.tbl_master_item where item_code='iubws56')


Set @JumlahItem = '1'


Set @UpgradeItem = '1879048192'








INSERT INTO dbo.tbl_ItemCharge


(nAvatorSerial, nItemCode_K, nItemCode_D, nItemCode_U)


VALUES namaPenerima KodeItem,@JumlahItem,@UpgradeItem)

Now i only need to convert it so that it only gives items to those who are online

Hi, maybe there is an error in this line:

VALUES namaPenerima KodeItem,@JumlahItem,@UpgradeItem)

It should be:

VALUES ( namaPenerima, KodeItem,@JumlahItem,@UpgradeItem)

One more thing, i don't have dbo.tbl_master_item in my RF_wolrd, so where i should get the item id i want to give?

 

[likertuban]

Hi, maybe there is an error in this line:

VALUES @namaPenerima @KodeItem,@JumlahItem,@UpgradeItem)

It should be:

VALUES ( @namaPenerima, @KodeItem,@JumlahItem,@UpgradeItem)

One more thing, i don't have dbo.tbl_master_item in my RF_wolrd, so where i should get the item id i want to give?

tbl_master_item only exist in gamecp, not sure which gamecp,
it's just checking catalog, you still need to manually insert the item code and the catalog, because in the database, sql code for an item is like : 132608
not 'iwswb65'
if you dont want the headache, just use control panel/manage tools to give item

 

[cristalninja]

tbl_master_item only exist in gamecp, not sure which gamecp,
it's just checking catalog, you still need to manually insert the item code and the catalog, because in the database, sql code for an item is like : 132608
not 'iwswb65'
if you dont want the headache, just use control panel/manage tools to give item

Thanks, can you give DL link for manage tool? Or could you upload yours?

 

[likertuban]

Thanks, can you give DL link for manage tool? Or could you upload yours?

search on the forum or google, or else, download a server files which include manage tools/controlserver,
most of server files here include it, i forgot which one, so try one by one :
there's also tutorial in here on how to use it, please dont ask how...
you could also messing around with it yourself

 

[jademaster]

actually i had the game cp it was all in russian and took a lot of time to translate them.. though i changed my mind on using them.. coz the script that comes with it does give the items to all players online including those who are not too and the worst part is it send the item to the first slot of your bag thus if that slot is not vacant it replaces it resulting to item lost.