Unnamed

UPDATE l2jz_items SET drp_flag=0,rcp_flag=0,sll_flag=0 WHERE id>0;

UPDATE
  l2jz_items AS Z,
  l2jz_recipes AS R
SET Z.rcp_flag=1
WHERE R.item_id=Z.id;

UPDATE 
  l2jz_items AS Z,
  droplist AS D
SET Z.drp_flag=1 
WHERE D.itemId=Z.id;

UPDATE 
  l2jz_items AS Z,     
  merchant_buylists AS M,
  merchant_shopids AS S
SET Z.sll_flag=1
WHERE Z.id=M.item_id AND S.shop_id = M.shop_id AND S.npc_id!='gm';

DROP TABLE IF EXISTS l2jz_variables;
CREATE TABLE l2jz_variables (
  timedate timestamp NOT NULL,
  type varchar(32) NOT NULL default '',
  var1 int(11) default '0',
  var2 int(11) default '0',
  var3 int(11) default '0',
  text varchar(255) NOT NULL default '',
  KEY timedate (timedate)
);
INSERT INTO l2jz_variables VALUES("2006-01-16 14:58:42", "restart", "0", "0", "0", "");