[Release] Mangos WotLK Core 3.0.2.8905

[Deathtrooper]

Thanx grey69 for helping people out! Community help is always a great thing! +rep

[zackorion15]

I am gonna work on a package for people to make this process very very easy.

[grey69]

:wave:

By the way, client/core 9014 didn't fix the 1h+shield bug. Still using 2 handers/shield

I updated to 9014 and didn't have to rebuild from scratch, good since i don't have much time spare and i wanna release all my fixes in one package, soon.

Going back to Core 8982 since the updated one has no scriptdev2 functionality, even putting the missing scriptdev2.conf file doesn't work either.

Getting my repack ready for you guys :P

small hint: Godlike

haha

[minhtri]

Nice work Deathtrooper and grey69. Work like a charm

[Dacesilian]

Hi all,
please, is possible to provide last WotLK mangos SVN patch? I wish to compile mangos on linux and your package is only for windows: ) Thank you!

[googlexx]

it wont let me execute the mangos sql into the database i get an error... whats wrong?

[tippythop]

Hey just to answer you question. If your using navicat when executing tick the box continue on errors should be in that window somewhere like in the middle

If that works cool if it works and your server doesnt run right Id suggest you do a clean reexecute of all the sqls and try again Idk why the mangosd sql would be givin u an error though never gave me an error and Ive been through all the cores death has released along with the repacks by razz

[frohanss]

it wont let me execute the mangos sql into the database i get an error... whats wrong?

Having the same problem, it always stops after Querys executed 94.
Have deleted db, reinstalled mysql (and deleted sql folder), and it always gives same error. The previous version of this pack i can install without a single error.

Sqlyog.err (partial file, start and ending part)

Query:
/*Data for the table `creature_template` */
insert  into `creature_template`(`entry`,`heroic_entry`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`,`name`,`subname`,`IconName`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`scale`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`baseattacktime`,`rangeattacktime`,`flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`class`,`race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`flag1`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`RacialLeader`,`RegenHealth`,`equipment_id`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`) values (1,0,10045,10045,10045,10045,'Waypoint','(Only GM can see it)',NULL,1,1,100,100,0,0,0,35,35,0,0.91,1,0,0,0,0,0,2000,2200,4096,0,8,0,0,0,0,1,2,100,8,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,1,0,0,2,''),(3,0,987,987,987,987,'Flesh

And End of the sqlyog.err

(7664,0,10543,10543,10543,10543,'Razelikh the Defiler','',NULL,60,60,30000,30000,0,0,1,22,22,0,1.79,1,1,527,736,0,2210,1150,1265,0,0,0,0,0,0,0,61.732,84.8815,100,3,2,7664,0,0,0,0,0,0,0,240,0,0,0,0,0,1844,1844,'',0,1,0,1,0,0,0,'')

Error occured at:2008-10-03 12:45:45
Line no.:487
Error Code: 2006 - MySQL server has gone away

Just tested to pull out just the "insert into `creature_template`" lines from mangosd.sql and run it as query, and it gives the error 2006 code.

Last edit:

Just compared the prev mangos sql to this one:
Code from previous sql:

VALUES ('1', '0', '10045', '10045', '10045', '10045', 'Waypoint', '(Only GM can see it)', null, '1', '1', '100', '100', '0', '0', '0', '35', '35', '0', '0.91', '1', '0', '0', '0', '0', '0', '2000', '2200', '4096', '0', '8', '0', '0', '0', '0', '1', '2', '100', '8', '5242886', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '3', '0', '1', '0', '0', '2', '');

And the code from the new sql:

values (1,0,10045,10045,10045,10045,'Waypoint','(Only GM can see it)',NULL,1,1,100,100,0,0,0,35,35,0,0.91,1,0,0,0,0,0,2000,2200,4096,0,8,0,0,0,0, 1,2,100,8,5242886,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,1,0,0,2,'')

All the spaces and ' are not there in the new sql, but im totaly nab with sql so i have no idea of that is what gives the error.

[BrantX]

Will be using this to run around on northrend and stuff.
Hope i set it up right. Does this release have units spawned on Northrend?
If i set it up right and it works i'll rep.

[Shara]

These links dont seem to work properly.

Are there any alternative ways to get a working Wotlk server that is n00b friendly?

[Deathtrooper]

The links work fine! Mediafire just does routine maintinence which makes it seem as though it's not working!


EDIT** Repack redone again to reflect a friendly mangosd execution!

Are there any alternative ways to get a working Wotlk server that is n00b friendly?

The only way that it's gonna get any easier is if someone is actually willing to hold ur hand while u do everything!!

[Shara]

Ok, tried the big one for the file, but it seems to finish before its supposed to.....is it possible to do alternate links too, in case it doesnt work for others too, Rapidshare anyone?

[Deathtrooper]

Ok, tried the big one for the file, but it seems to finish before its supposed to.....is it possible to do alternate links too, in case it doesnt work for others too, Rapidshare anyone?

Ur the only one that complained about it not downloading right so that's a big NO!

I can view the download stats of that link and it seems to be working just fine.... just put it up and it's already been DLed 35 times!!

[slaxslux]

Hi i try that u say but it didn´t work. Do you have your sql files in the repack now? i think i need them for the server

[frohanss]

Thx for! Nice work, that last package fixed my problem. No error on importing mangos.sql now! Thx