View Single Post
  #10  
Old 03-15-2003, 03:42 AM
rockocool
Sarnak
 
Join Date: Mar 2003
Location: california
Posts: 63
Default

41to42fix.sql can be find at end of this post,
http://forums.eqemu.net/viewtopic.php?t=5240
or to save time for you, i copied it at end of this post. you need to add the 5 resist column.

as of why it doesnt work for you using the telmet db.sql and addon, The only guess I could make is you are using an older version of telmet's files, I think he updated them recently. try redownload them from his website, I was using the latest download to test it, which works. I dont know if his earlier version works or not, since only yesterday I gave telmet files a try:
http://www.darkangel.net/eqemunews/
I rebuilt my db exactly like what i suggested in my last reply, and it worked without any problem.


here is 41to42fix.sql:


-- Update EQEmu 4.1 DB to a 4.2 compatable DB

ALTER TABLE `account` CHANGE `password` `password` VARCHAR(50) NOT NULL;

ALTER TABLE `npc_types` CHANGE `npcspecialattks` `npcspecialattks` varchar(36) default '' NOT NULL;
ALTER TABLE `npc_types` ADD `MR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `CR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `DR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `FR` SMALLINT(5) DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `PR` SMALLINT(5) DEFAULT "0" NOT NULL;


ALTER TABLE `variables` ADD `ts` timestamp;

INSERT INTO variables VALUES ('AILevel','0','');
INSERT INTO variables VALUES ('ZSPassword', 'EQEMu', '');
Reply With Quote