evilwhynot

In order to undo this change you must: 1. Go to SQLYog (or whatever similar program you are using). 2. Find, under mangos, the table "creature_template". 3. Right click, "Alter table...". 4. Select one of the new columns (PowerType, spell 5, spell 6, spell 7, spell 8, VehicleId) and click "Delete" at the bottom. 5. When you have finished with all six columns, click on "Alter". Anyway, I'm still trying to figure out how to make this patch work. If I find the answer, I'll post it for others with the same problem. Lol no, in the mangos-git in the scripts I am trying to find out how I can make more columns somewhere, because when ever you try and start it up it will give you that error about to many columns

Its cool, I still cant get that dam patch to work and what I am trying to figure out is how to change the columns in the creature_template and also for other tables

Actually no I have not found a solution for this problem

I just looked it up and this is the following which I have:::::::::::: const char CreatureInfosrcfmt[]="iiiiiiiiiisssiiiiiiiiiiifffiffiifiiiiiiiiiiffiiiiiiiiiiiiiiiiiiisiiffliiiiiiiliiiiis"; const char CreatureInfodstfmt[]="iiiiiiiiiisssiiiiiiiiiiifffiffiifiiiiiiiiiiffiiiiiiiiiiiiiiiiiiisiiffliiiiiiiliiiiii"; const char CreatureDataAddonInfofmt[]="iiibbiis"; const char CreatureModelfmt[]="iffbii"; const char CreatureInfoAddonInfofmt[]="iiibbiis"; And there is more I just copied the lines that you have listed

Do you have msn yahoo aim or something where we can talk faster?

I have applied everything it is up-to-date, I am trying to get the vehicles working correctly but am not sure how to really even do it. Don't give me that link on here where they have the vehicles and you have to merge the files because I dont know how to do that ether. I can compile the server, run it and it will start up fine its just I added colu. to the creature template to try and get the vehicles working

Hello I am having trouble figuring out how to change the total sql fields. When ever I start mangos.exe it will load perfect all the way upto creature_template the following error occurs... 2011-01-04 16:57:45 Loading Creature templates... 2011-01-04 16:57:46 ERROR:Error in creature_template table, probably sql file format was updated (there should be 84 fields in sql). Let me pretty much sum this up for you, I wanna try and figure out where in the mangos-git folder where you can change the creature_template fields from 84 to 90. 90 because thats how many fields I have. I am pretty sure you can edit this somewhere but I have no idea where can someone please help?