[ManGoS] Compiled Mangos Rev. 3580 (TBC-2.0.12)+ScriptDev2-Rev. 40

[mpompos]

Mangos Rev. 3580 (TBC-2.0.12)
ScriptDev2-Rev. 40
FULL SDB 0.6.5-Rev. 176+SQL PATCHES
Core Patches


Core Patches:

1) Hunter/Warlock patch(Really thanks influenza!)
2) Sql Cleaning At Startup(thanks sanaell.)
3) Warsong Gulch Start (thanks zeus.)
4) Vmap Support (Really thanks Ralf!)

Includes compiled vmapextractor and assembler.
Includes Alex/AT's patch for Vmap TBC Support. Thanks a lot Alex!

Mangos Rev. 3580-ScriptDev2-Rev. 40-Vmapextractor-Assembler

FULL SDB 0.6.5-Rev. 176

If you need help let me know.

[MentaL]

[DwightD]

There is a thread for posting binaries and sdb. You are of course welcome to post your release there. :) http://forum.ragezone.com/f114/mango...-files-166402/

[mpompos]

I posted the binaries there and here just to avoid replies there and try to keep the thread clean.

greets

[dade22]

I using mysql 5.1+navicate2007or mysql+sqlyog and have problem with some sql if i exucute some database i have problem

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'
Error occured at:2007-05-04 11:31:43
Line no.:21
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists
....
Error occured at:2007-05-04 11:35:29
Line no.:478
Error Code: 2006 - MySQL server has gone away
Some data working correctly but some have this problem i change all sql version,navicate,sqlyog removing all database from computer unnistalling all program restarting...
database: SDB_0.6.4FULL+REV_176+FIXES+PATCHES.rar
core: Mangos 3580+ScriptDev2rev.40+Patches+vmapextractor-assembler
Program execute but stopped.

any suggestion with using program or patch any???

[dade22]

any help??

[DwightD]

any help??

How can somebody help if you don't tell us what you imported!

SQL are messy things. Hate it. Everything works and the next seconds all the files you use are unusable for some strange reason. I have a problem with a 49.sql from a wow website and im the only one on this planet that can't import this god damn file. I have use SQLyog, Navicat and PhPMyAdmin wich is supposed to be the best but gives me more error then all others lol and nothing works! I have change my diskw tried a shitload of different binaries, tried redownloading it with tortoisesvn to make sure its not corrupt and it still doesn't work. In the end i just gave up.

[jahputih]

2007-05-04 20:36:39 SQL: SELECT `creature_id`,`RewOnKillRepFaction1`,`RewOnKillRepFaction2`,`IsTeamAward1`,`MaxStanding1`,`RewOnKillRepValue1`,`IsTeamAward2`,`MaxStanding2`,`RewOnKillRepValue2`,`TeamDependent` FROM `creature_onkill_reputation`
2007-05-04 20:36:39 query ERROR: Unknown column 'TeamDependent' in 'field list'
2007-05-04 20:36:39 >> Loaded 0 creature award reputation definitions. DB table `creature_onkill_reputation` is empty.
2007-05-04 20:36:39 `quest_template` table is empty!

i got this dberror after run the server.

i got same problem as dade22 also after execute FULL SDB 0.6.5-Rev. 176 to sql server

[mpompos]

2007-05-04 20:36:39 SQL: SELECT `creature_id`,`RewOnKillRepFaction1`,`RewOnKillRepFaction2`,`IsTeamAward1`,`MaxStanding1`,`RewOnKillRepValue1`,`IsTeamAward2`,`MaxStanding2`,`RewOnKillRepValue2`,`TeamDependent` FROM `creature_onkill_reputation`
2007-05-04 20:36:39 query ERROR: Unknown column 'TeamDependent' in 'field list'
2007-05-04 20:36:39 >> Loaded 0 creature award reputation definitions. DB table `creature_onkill_reputation` is empty.
2007-05-04 20:36:39 `quest_template` table is empty!

i got this dberror after run the server.

i got same problem as dade22 also after execute FULL SDB 0.6.5-Rev. 176 to sql server

Open my.ini in "C:\Program Files\MySQL\MySQL Server 5.0" and add at the bottom : set-variable=max_allowed_packet=500M

I using mysql 5.1+navicate2007or mysql+sqlyog and have problem with some sql if i exucute some database i have problem

Query:
CREATE TABLE `areatrigger_involvedrelation` (
`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
`quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'
Error occured at:2007-05-04 11:31:43
Line no.:21
Error Code: 1050 - Table 'areatrigger_involvedrelation' already exists
....
Error occured at:2007-05-04 11:35:29
Line no.:478
Error Code: 2006 - MySQL server has gone away
Some data working correctly but some have this problem i change all sql version,navicate,sqlyog removing all database from computer unnistalling all program restarting...
database: SDB_0.6.4FULL+REV_176+FIXES+PATCHES.rar
core: Mangos 3580+ScriptDev2rev.40+Patches+vmapextractor-assembler
Program execute but stopped.

any suggestion with using program or patch any???

Sorry forgot to apply a patch:

ALTER TABLE `creature_onkill_reputation` 
  CHANGE COLUMN `MaxStanding1` `MaxStanding1` tinyint(1) default '0',
  CHANGE COLUMN `IsTeamAward1` `IsTeamAward1` tinyint(1) default '0',
  CHANGE COLUMN `MaxStanding2` `MaxStanding2` tinyint(1) default '0',
  CHANGE COLUMN `IsTeamAward2` `IsTeamAward2` tinyint(1) default '0',
  ADD COLUMN `TeamDependent` tinyint(1) unsigned NOT NULL default '0' AFTER `RewOnKillRepValue2`;

Tomorrow I will make a new compilation including Students1 magnificent Rogue patch (apart from other updates and the patches of this compilation. You will find it at this topic.)