View Single Post
  #41  
Old 04-12-2004, 01:34 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

FOrgot to add, you should consider writing your updates in sql format, ie:

Code:
UPDATE lootdrop_entries set item_id = ##### where lootdrop_id = ##### and item_id = ##### LIMIT 1;
So in the example above, you would write:

Code:
UPDATE lootdrop_entries set item_id = 13073 where lootdrop_id = 118 and item_id = 12694 LIMIT 1;
This is good for 2 reasons, the first is if you re-source an update of mine, you can simply re-source your sql and the changes are done...no need to do the work again. The second and more important feature is you can post these updates for everyone to use
Reply With Quote