[Release] Mangos WotLK Core 3.0.2.8905

[looker]

right well i checked the version and its 9038 im rerunning the ad.exe... again. dont know if its gonna fix anything.

EDIT: yay it fixed that problem... but now i got a new one

Error in item_template table, probably sql file format was updated (there should
be 142 fields in sql).

i tried updating the sqlyog thing but there are so many freaking files... which ones do i use?

as noted above *about 5 or 6 posts up from here...),

It has actually been answered 200 times in this thread alone

you are going to update the mangos database (there are databases named characters, mangos, realmd, scriptdev2 - you want to select the one named..... - thats the database named mangos that you created when you setup your server...

then copy and paste the following 2 lines as querys and run them.... scroll up about 4 or 5 posts for another response to this exact question


ALTER TABLE `item_template` ADD COLUMN `unk_flag1` mediumint(10) unsigned NOT NULL default '0' AFTER stat_value10;
ALTER TABLE `item_template` ADD COLUMN `unk_flag2` mediumint(10) unsigned NOT NULL default '0' AFTER unk_flag1;

execute these 2 queries into your mangos db

[lordsarr]

nvm i worked my problem out someone said here that you need to add something to character_tutorials but he dint say it needs to be at start of the table and there was spelling error in acount (should be account i guess)

[chrismon9]

hey, i have a question, what if you got accepted into the wotlf beta test and so be able to already have the client, or... game, and what do i do? just not install it and use the pack, or is there a good or better or A way to do it? i need sum help...

EDIT: well, i have not done the pack download yet, and i just want ppl to not think this is a stupid quiestion, but ill download it now....

[lordsarr]

there is and error with shadowstep but not in the dtb (make sthe game crash)

[Ravencroft]

You need to download .NET Framework 3.5 in order to run the logonserver etc.
In order to get .NET Framwork 3.5, you will need to download Windows Installer 3.1 first. Here are the links:

http://www.microsoft.com/downloads/d...displaylang=en - Windows Installer 3.1

http://www.microsoft.com/downloads/d...displaylang=en - .NET Framework 3.5

Also, if you cannot log in to your own server, you may need to delete the "Cache" folder in your WoTLK directory.

---
Thank you for this Repack. :-)

[Deathtrooper]

1st post updated!!


Still not error free, but at least the new vehicles shouldn't crash client! Compilied with patch 19.3 w/ some help from Tom_Rus!

Most Importantly u shouldn't have to change the max build anymore...it's actually for 9061!!


IF U GET ANY ERRORS PLEASE READ THROUGH THE ENTIRE THREAD! UR QUESTION HAS PROBABLY BEEN ANSWERED ALREADY!!

[ScDK]

EDIT: ooops, i forgot to see one of the words from the first post...soooo...yeah...
*recreates the databases he deleted a few minutes ago* oh well...let's test

EDIT2: Nothing, the new downloaded files can't neither be used as standa-lone, nor to update the old DB entries...i always get errors about the mysql.<tablename> (where <tablename> is one of the tables that should be in the characters, mangos, realmd and scriptdev2 DBs)

EDIT3: oh, figured it out...something wrong with MySQL, i removed the TIMESTAMP and access rights, and it worked.

[Kaijs14]

Tell me please now the realmilst :@

[yeaimdatdude]

ok im on 9061 using the new 9061 19.3 thing but i try to run mangosd.exe and i stumble upon this

Class 6 Level 1 does not have health/mana data!

how do i fix this, i looked at previous posts where people said to use the old database but when i use the old one it says something like outaded files, so then which database am i supposed to use? and which of the sql files am i supposed to add? can some1 like post exactly which ones they used? there are so many files and most of them i run em and they error.

this is so annoying

[Razorspine]

ok im on 9061 using the new 9061 19.3 thing but i try to run mangosd.exe and i stumble upon this

Class 6 Level 1 does not have health/mana data!

how do i fix this, i looked at previous posts where people said to use the old database but when i use the old one it says something like outaded files, so then which database am i supposed to use? and which of the sql files am i supposed to add? can some1 like post exactly which ones they used? there are so many files and most of them i run em and they error.

this is so annoying

Well u could try this,ripped out levelstats for class 6

insert into `player_classlevelstats`(`class`,`level`,`basehp`,`basemana`) values (6,1,20,0),(6,2,29,0),(6,3,38,0),(6,4,47,0),(6,5,56,0),(6,6,65,0),(6,7,74,0),(6, 8,83,0),(6,9,92,0),(6,10,101,0),(6,11,105,0),(6,12,109,0),(6,13,118,0),(6,14,128 ,0),(6,15,139,0),(6,16,151,0),(6,17,154,0),(6,18,166,0),(6,19,183,0),(6,20,199,0 ),(6,21,206,0),(6,22,226,0),(6,23,243,0),(6,24,253,0),(6,25,274,0),(6,26,296,0), (6,27,309,0),(6,28,333,0),(6,29,348,0),(6,30,374,0),(6,31,401,0),(6,32,419,0),(6 ,33,448,0),(6,34,468,0),(6,35,499,0),(6,36,521,0),(6,37,545,0),(6,38,581,0),(6,3 9,609,0),(6,40,649,0),(6,41,681,0),(6,42,715,0),(6,43,761,0),(6,44,799,0),(6,45, 839,0),(6,46,881,0),(6,47,935,0),(6,48,981,0),(6,49,1029,0),(6,50,1079,0),(6,51, 1131,0),(6,52,1185,0),(6,53,1241,0),(6,54,1299,0),(6,55,1359,0),(6,56,1421,0),(6 ,57,1485,0),(6,58,1551,0),(6,59,1619,0),(6,60,1689,0),(6,61,1902,0),(6,62,2129,0 ),(6,63,2357,0),(6,64,2612,0),(6,65,2883,0),(6,66,3169,0),(6,67,3455,0),(6,68,37 74,0),(6,69,4109,0),(6,70,4444,0);

[yeaimdatdude]

Well u could try this,ripped out levelstats for class 6

insert into `player_classlevelstats`(`class`,`level`,`basehp`,`basemana`) values (6,1,20,0),(6,2,29,0),(6,3,38,0),(6,4,47,0),(6,5,56,0),(6,6,65,0),(6,7,74,0),(6, 8,83,0),(6,9,92,0),(6,10,101,0),(6,11,105,0),(6,12,109,0),(6,13,118,0),(6,14,128 ,0),(6,15,139,0),(6,16,151,0),(6,17,154,0),(6,18,166,0),(6,19,183,0),(6,20,199,0 ),(6,21,206,0),(6,22,226,0),(6,23,243,0),(6,24,253,0),(6,25,274,0),(6,26,296,0), (6,27,309,0),(6,28,333,0),(6,29,348,0),(6,30,374,0),(6,31,401,0),(6,32,419,0),(6 ,33,448,0),(6,34,468,0),(6,35,499,0),(6,36,521,0),(6,37,545,0),(6,38,581,0),(6,3 9,609,0),(6,40,649,0),(6,41,681,0),(6,42,715,0),(6,43,761,0),(6,44,799,0),(6,45, 839,0),(6,46,881,0),(6,47,935,0),(6,48,981,0),(6,49,1029,0),(6,50,1079,0),(6,51, 1131,0),(6,52,1185,0),(6,53,1241,0),(6,54,1299,0),(6,55,1359,0),(6,56,1421,0),(6 ,57,1485,0),(6,58,1551,0),(6,59,1619,0),(6,60,1689,0),(6,61,1902,0),(6,62,2129,0 ),(6,63,2357,0),(6,64,2612,0),(6,65,2883,0),(6,66,3169,0),(6,67,3455,0),(6,68,37 74,0),(6,69,4109,0),(6,70,4444,0);

doesnt work i get this error when i try to run it

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9,609,0),(6,40,649,0),(6,41,681,0),(6,42,715,0),(6,43,761,0),(6,44,799,0),(6,45 ,' at line 1
(0 ms taken)

screw this im just gonna wait for the actual game to come out and if i want my own server ill get it from someone that doesnt have 50000 files where 30000 of them dont even work, or atleast tell me which ones to use

[Deathtrooper]

If u r getting errors of any kind, u have to update ur DB with the updates provided in the download! Remember to use the appropriate path with each one... if it says characters in it then it's for ur characters DB, and if it says mangos then it's for ur mangos DB!

screw this im just gonna wait for the actual game to come out and if i want my own server ill get it from someone that doesnt have 50000 files where 30000 of them dont even work, or atleast tell me which ones to use

It's ur own fault if u can't get it to work not mine! I'm providing cores here not simple "one click" private servers for all u leechers out there! Yes u have to put in some effort... this world has definitely gotten too damn lazy over the years!

[Razorspine]

doesnt work i get this error when i try to run it

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '9,609,0),(6,40,649,0),(6,41,681,0),(6,42,715,0),(6,43,761,0),(6,44,799,0),(6,45 ,' at line 1
(0 ms taken)

screw this im just gonna wait for the actual game to come out and if i want my own server ill get it from someone that doesnt have 50000 files where 30000 of them dont even work, or atleast tell me which ones to use

It gives that error because your running it as a 9 line query, u add the entire thing as 1 line query.
Updating the db as Death said using the supplied update sql's is still the most important thing if u want this to work.
Last but not least, my 5 cents, this isnt a release of a full and working WotLK server , for that you'll have to wait untill a few months after its actually released, this is a great way to get a feel of what the upcoming games gonna be like.
Thanx Death for yer excellent releases, keep em coming

[predattak]

If u r getting errors of any kind, u have to update ur DB with the updates provided in the download! Remember to use the appropriate path with each one... if it says characters in it then it's for ur characters DB, and if it says mangos then it's for ur mangos DB!





It's ur own fault if u can't get it to work not mine! I'm providing cores here not simple "one click" private servers for all u leechers out there! Yes u have to put in some effort... this world has definitely gotten too damn lazy over the years!

ure right death

[kainmcloud]

+Rep When I Can Thanks!