How to add item on mssql?
Printable View
How to add item on mssql?
http://forum.ragezone.com/f460/manua...reator-928060/
I think you use the Cash DB and execute the provided mssql script.
TransNo no idea exactly,.. transactions number/ID?, leave it as it is
ItemIdx is for binding and upgrades
ItemOpt is for slots
ServerIdx check your world_xx_xx.ini if in doubt
UserNum is user number, your account
ctrl+c (copy)
ctrl+v (paste)
very easy
You mean you need a query script to send item to an account?Quote:
Originally Posted by fantazjusz
exec up_AddMyCashItemByItem 'ACCOUNTID','0','SERVERID','ITEMID','ITEMOPTION','DURATIONID'
example:
exec up_AddMyCashItemByItem '1','0','1','1','0','31'
Where to enter this code?
Use your database and create a new query, then copy paste it.Quote:
Originally Posted by fantazjusz
You should inform yourself about itemOption, itemID, durationID and the basic stuff about SQL Server or you will have trouble with fixing oder implementing the easiest things you need to.
If you want to send items to other players maybe my tool helps! You can create the itemIDs and send it via mail tool. Could be easier if you don't want to use sql queries on your own.
http://forum.ragezone.com/f459/bega-admin-tool-917567/
screenSHU - The fastest screen capture ever.
What you need to enter in the Item ID and Item name? (sry google translate)
sql querly add there the code
Things you need to do:Quote:
Originally Posted by fantazjusz
1. Unpack the cabal_msg.enc in order to get all itemIDs or use search function here for the default EP8 item IDs.
2. Use the item creation module of Bega Admin tool to generate/create an itemidx and its corresponding option code.
3. Use also the mail system then input the item and option codes. (get 1st the characterIDx in the basic function of the tool)
P.S. Study first the Bega Admin Tool functions.