Experienced Elementalist
- Joined
- Dec 19, 2015
- Messages
- 247
- Reaction score
- 69
If you want to add a item to any player on your server, you just need to go to database , open a new query , copy this code and execute it :
INSERT INTO Game.TblPcMailEx(cPcNo, cMailType, cFromPcName, cSubject, cContent, cItemId, cStackCount)
VALUES ("Character ID", 1, 1, 1, 1, "ITEM ID", "quantity")
RETURN
And its done .
Obs : Dont need to restart server or sql , player dont need to logout( he just gotta check his mailbox and it will be on his cash pocket), you can execute alot of times ( no error) .
Major Obs : ITS ITEM ID, not Product ID , if you want Product ID , change "cItemId" to "cProductId".
"Dont need to change 1, 1, 1, 1, , leave it as it is" .
Doubts : You can find Character Id on Database/C9World/Game.TblPcBase , its (cPcNo)
end : Without quotes(".") please ...
INSERT INTO Game.TblPcMailEx(cPcNo, cMailType, cFromPcName, cSubject, cContent, cItemId, cStackCount)
VALUES ("Character ID", 1, 1, 1, 1, "ITEM ID", "quantity")
RETURN
And its done .
Obs : Dont need to restart server or sql , player dont need to logout( he just gotta check his mailbox and it will be on his cash pocket), you can execute alot of times ( no error) .
Major Obs : ITS ITEM ID, not Product ID , if you want Product ID , change "cItemId" to "cProductId".
"Dont need to change 1, 1, 1, 1, , leave it as it is" .
Doubts : You can find Character Id on Database/C9World/Game.TblPcBase , its (cPcNo)
end : Without quotes(".") please ...