quest_globals.sql ??

[cofruben]

Hello all,I was wandering where can I get that sql file to use in my perl quests because my global variables doesnt work...also I use 5.5 version.Thanks

[Scorpious2k]

Here it is:

DROP TABLE IF EXISTS quest_globals;
CREATE TABLE quest_globals (
  id int(11) NOT NULL auto_increment,
  charid int(11) NOT NULL default 0,
  npcid int(11) NOT NULL default 0,
  zoneid int(11) NOT NULL default 0,
  name varchar(65) NOT NULL,
  value varchar(65) NOT NULL default "?",
  expdate int(11) NOT NULL default 0,
  PRIMARY KEY  (id),
  UNIQUE KEY qname (name,charid,npcid,zoneid)
) TYPE=MyISAM;

alter table npc_types add qglobal int(2) unsigned default '0';