REALM: Total War Repack v1.6

[Gastricpenguin]

Run these queries, and your problems will be fixed.

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for professiondiscoveries
-- ----------------------------
CREATE TABLE `professiondiscoveries` (
  `SpellId` int(10) unsigned NOT NULL default '0',
  `SpellToDiscover` int(10) unsigned NOT NULL default '0',
  `SkillValue` int(10) unsigned NOT NULL default '0',
  `Chance` float NOT NULL default '0',
  PRIMARY KEY  (`SpellId`,`SpellToDiscover`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `instance_bosses` CHANGE COLUMN `creatureid` `spawnid` INT(11) UNSIGNED NOT NULL DEFAULT '0';

[treeko11]

Thank you so much Gastric, have some rep, even though you dont need it

Oh! It seems i dont have the column 'creatureid' in my instance_bosses table, can i have a Query for that as well please?

[gavin1]

nice share!

[EmiloZ]

Gastric, i ran the sql you posted and still getting :

[Erase]

Nice repack.

[TristinD]

It give that crashdumb because there are some things writed in worldfilter_chat if you delete all the things in that table you dont get crash well i dont get crash

[Etna]

Dude is the ics from you'r Own server ? beacuse i wanna play onit and +rep x2 for a nice Release of a NICE Repack.

[Gastricpenguin]

Run this query if you do not have the creature_id column at all. EmiloZ, just delete the content in Wordfilter_chat.

DROP TABLE IF EXISTS `instance_bosses`;

CREATE TABLE `instance_bosses` (
  `mapid` int(11) unsigned NOT NULL default '0',
  `creatureid` int(11) unsigned NOT NULL default '0',
  `trash` text NOT NULL,
  `trash_respawn_override` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`mapid`,`creatureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Instance Boss Definitions';

[Wolverine77]

Gastric, how hard would it be to "merge" your PVP realm with an existing server?

[AzolexX]

you would need a Sources of Core and Database is Easy to marge.

[runemaster]

The only spawned content are areas that are readily available to players. Meaning: Av, starting zones, moonglade, gadgetzan, etc. There are no spawns in other regions so the server can run faster and provide better pvp

cool i like this alot

but wheres the npcs in gadgetzhan? O.~?

nothing there at alll

[Gastricpenguin]

Look at the notes for version 2 on the first post.

[fastelf]

I get the same problem as Emiloz.

Dude

If your gonna release a repack, make sure you have the proper DLL's to actually start the server.. thats probably half the problem.

You can't expect everyone to have it, nor have to get them because a repack should contain it, end of story.

Also, what OS are you compiling this under?

[Gastricpenguin]

Fastelf, maybe you should do a little research, then you would find out the modules in the parent directory are OPTIONAL. Compiled on Windows.

Besides, I will have a small update to version 1.4 tonight or tomorrow.

[fastelf]

I wasn't talking about those DLL's. I was on about the libmySQL & libeay32 DLL's that are used to run the actual server.

With the new version, will it support the latest patch? (I'm fairly sure a new patch came out..)