L2 Donation Manager

Have you created a useful tool? or Do you want to get help building one? This is the right place!
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Stealth
Posts: 8
Joined: Mon Jul 06, 2009 8:43 am

L2 Donation Manager

Post by Stealth »

I am making a tool atm called L2 Donation Manager which will be an easy way to manage your donators , if you have donates.

But im stuck in this part: I cant find a way to insert an item to a player from database (SQL). If someone could provide me this sql query I would be gratefull.
User avatar
DrHouse
L2j Inner Circle
L2j Inner Circle
Posts: 912
Joined: Mon Jan 22, 2007 12:14 am
Location: Spain

Re: L2 Donation Manager

Post by DrHouse »

You had better using telnet for online players
Image

Leadership and management are not talk and talk, but talk and do

Proud of being a part of this project
User avatar
janiii
L2j Veteran
L2j Veteran
Posts: 4269
Joined: Wed May 28, 2008 3:15 pm
Location: Slovakia

Re: L2 Donation Manager

Post by janiii »

there is no sql command for giving an item to a player, because you have to create a unique object id which will not be used second time by the IdFactory. better use java code for creating/giving items for players.
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper
I don't give private support - PM will be ignored!
User avatar
denser
Posts: 1392
Joined: Wed May 30, 2007 9:13 pm
Location: Russia
Contact:

Re: L2 Donation Manager

Post by denser »

i suggest you to look at Michelle Dropcalc, it had a sql query to add item, as i know, items db has auto increment id. so you just need to solve default values.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
Post Reply