big_boy3100 Posted March 10, 2009 Share Posted March 10, 2009 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 Link to comment Share on other sites More sharing options...
Francisko Posted March 11, 2009 Share Posted March 11, 2009 OMG!!!! TY FOR THIS SQL UPDATES!! ^^ Link to comment Share on other sites More sharing options...
GoDofAdeN Posted March 11, 2009 Share Posted March 11, 2009 very cool share :) thanks. hopefully this will be improoved with more usefull sql codes :) Link to comment Share on other sites More sharing options...
Zaan Posted July 27, 2009 Share Posted July 27, 2009 wow ;) Rly nice share:P Link to comment Share on other sites More sharing options...
soulriver Posted August 7, 2009 Share Posted August 7, 2009 i think thouse update were on l2jdot timeline but were needed to evreyone i think Nc job mate Link to comment Share on other sites More sharing options...
zeenith Posted August 9, 2009 Share Posted August 9, 2009 nice share thnks Link to comment Share on other sites More sharing options...
paparas21 Posted August 9, 2009 Share Posted August 9, 2009 Make mobs stronger doesn't works you can fix it? Link to comment Share on other sites More sharing options...
hoangnhan Posted August 10, 2009 Share Posted August 10, 2009 NIce guide sql, thank you Link to comment Share on other sites More sharing options...
samadielka Posted August 10, 2009 Share Posted August 10, 2009 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? Link to comment Share on other sites More sharing options...
hoangnhan Posted August 10, 2009 Share Posted August 10, 2009 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 Link to comment Share on other sites More sharing options...
DragonHunter Posted August 10, 2009 Author Share Posted August 10, 2009 Topic is locked... its a half year ago I've been posting this Link to comment Share on other sites More sharing options...
Recommended Posts