[share] Handy SQL Updates

[big_boy3100]

well in my opinion the only thing thtat seemed important was the part about deleting an item from a characters account the rest is easy and can be done pretty simple ;D

[Francisko]

OMG!!!! TY FOR THIS SQL UPDATES!! ^^

 

 

 

[GoDofAdeN]

very cool share :) thanks.

 

hopefully this will be improoved with more usefull sql codes :)

[Zaan]

wow ;) Rly nice share:P

[soulriver]

i think thouse update were on l2jdot timeline but were needed to evreyone i think Nc job mate

[zeenith]

nice share thnks

[paparas21]

Make mobs stronger doesn't works you can fix it?

 

[hoangnhan]

NIce guide sql, thank you

[samadielka]

Delete an Item from the players inventory:

Code:

 

-- Only use this when something realy wrong is going on because in every inventory this item will be deleted!

DELETE FROM items WHERE item_id = 'ITEM ID';

 

 

So u cant delete one item only from one char?

[hoangnhan]

Only use this when something realy wrong is going on because in every inventory this item will be deleted

 

I think use ID Item from  log for delete

not item ID SQL.

 

if using DELETE FROM items WHERE item_id = 'ITEM ID'; delete all char inventory

 

 

[DragonHunter]

Topic is locked... its a half year ago I've been posting this