you are big guy working!!
you are big guy working!!
but how to fix connection timeout?
sorry i forgot about image
I think you may have to change the passwords in the .conf files, (LogonServer.RemotePassword = password) in Logonserver.conf, and antrix.conf :) ((Make sure they match))
sorry for that question i know where is problem solved.thx againOriginally Posted by omnislife
which one core version is for wow 2.1.1 6739 realese
Becouse he talk client version is wrong.
291 I think is the latest core.
Whats wrong? :P
i check all all working but need to change in cfg
MinClientBuild = 6739
MaxClientBuild = 6739
I'm not danish i'm afraid :P Can't understand it ^^
And Dade22, change it to the lowest and highest builds of which will be connecting to your server. If you dont know them, just put something like... 6000 - 7000
It just says that something is wrong with that appcombat.txt file. What should I do?
ok i check all working but how to turn on gm mode need some change in table like gm=3???
GM = az, And i havn't got a clue whats wrong Claes :( Never had anything like that.
version suppourt ?
Using core 291 + Rev 4 (wow 2.1.1 6739)
If i try to join Kara i get the Error:
You tried to join an invalide Instance (10 on map 532). Repopping on Exit battleground.
If i try to join Naxx i get the Error:
You tried to join an invalide Instance (xx on map xxx). Repopping on Exit battleground.
I was in a Raid Group. :/ any solution?
those incompatibility errors means you need to upgrade or install .NEt 1.1 and/or 2.0
Ok guys i managed to make 2 server run on same server one its server mangos one its server antrix .Both made by me you can see in here how its the terradb OldSchool PrOjEcT: The Burning Crusade - Map of Outland i didnt had time to put Portals because im so sleppie guys i must sleep.
just a correction herer, the tables removed are the "accounts and character" tables NOT the creatures table LOL
Thx for the tip, but still not working. Still getting the same errors. :/
Ok i managed to make this work .. prety c00L ...from what i managed to try everything works soo sweet, nice job ..to bad that i had to give up at all old characters :punch: i had such a nice warlock :D . Still if i try to use any other core version newer than 275 it just crashes my antrix.exe and yes i have executed that query wich was supposed to make my DB compatible with 290:scratch: . But i don't give up :P i'll make it work ... :construct .. i won't give up soo easy :D ! Any ideeas would be much appreciated.
PS: today i tryed even the last release 301 and the same problmen ..man.. i'm soo angry x(((
I wnat Vendors on my server ......can someone put me a pack with Tier 6 vendors...and wepons....Pls
Oh man i can stop from laughing =)))) lol I FIXED IT yupey .. I'm soo good :P ..soo my problem was that i didn't noticed that when i execute a query when it reaches a ; it stops ..lol i am down with my sql :P this is the first time i used SQL .. soo what i did was press F5 in front of every query looking for the ; again moving the cursor and F5 again ,,and soo on ..doh i realy need to read some more about sql :d .. Thing is that now my server WORKS soo i'm HAppy !!
Here is an example for those out there like me { I use SQLyoung } :
Or you could just press SHIFT+F5 at the begining of the first query and relax :D ..now i seen that :Ppress F5 UPDATE totemspells SET spellToCast1= 8349 WHERE spellId=1535;
press F5 UPDATE totemspells SET spellToCast1= 8502 WHERE spellId=8498;
press F5 UPDATE totemspells SET spellToCast1= 8503 WHERE spellId=8499;
press F5 UPDATE totemspells SET spellToCast1= 11306 WHERE spellId=11314;
press F5 UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=11315;
press F5 UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=27623;
press F5 UPDATE totemspells SET spellToCast1= 8187 WHERE spellId=8190;
press F5 UPDATE totemspells SET spellToCast1= 10579 WHERE spellId=10585;
press F5 UPDATE totemspells SET spellToCast1= 10580 WHERE spellId=10586;
press F5 UPDATE totemspells SET spellToCast1= 10581 WHERE spellId=10587;
press F5 DROP TABLE IF EXISTS `reputation_creature_onkill`;
press F5 CREATE TABLE `reputation_creature_onkill` (
`creature_id` int(30) NOT NULL,
`faction_change_alliance` int(30) NOT NULL,
`change_deltamin_alliance` int(30) NOT NULL,
`change_deltamax_alliance` int(30) NOT NULL,
`faction_change_horde` int(30) NOT NULL,
`change_deltamin_horde` int(30) NOT NULL,
`change_deltamax_horde` int(30) NOT NULL,
KEY `index` (`creature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
press F5 DROP TABLE IF EXISTS `reputation_faction_onkill`;
press F5 CREATE TABLE `reputation_faction_onkill` (
`faction_id` int(30) NOT NULL,
`change_factionid_alliance` int(30) NOT NULL,
`change_deltamin_alliance` int(30) NOT NULL,
`change_deltamax_alliance` int(30) NOT NULL,
`change_factionid_horde` int(30) NOT NULL,
`change_deltamin_horde` int(30) NOT NULL,
`change_deltamax_horde` int(30) NOT NULL,
KEY `factindex` (`faction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
press F5 DROP TABLE IF EXISTS `npc_monstersay`;
press F5 CREATE TABLE `npc_monstersay` (
`entry` int(11) NOT NULL,
`event` int(11) NOT NULL,
`chance` float NOT NULL,
`language` int(11) NOT NULL,
`type` int(11) NOT NULL,
`monstername` longtext,
`text0` longtext,
`text1` longtext,
`text2` longtext,
`text3` longtext,
`text4` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*
MySQL Data Transfer
Source Host: localhost
Source Database: antrixdevelop
Target Host: localhost
Target Database: antrixdevelop
Date: 6/7/2007 9:48:35 PM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for accounts
-- ----------------------------
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(28) NOT NULL default '',
`gm` varchar(27) NOT NULL default '',
`banned` int(30) NOT NULL default '0',
`lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
`lastip` varchar(15) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`flags` int(11) NOT NULL default '8',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for auctions
-- ----------------------------
CREATE TABLE `auctions` (
`auctionId` int(32) NOT NULL auto_increment,
`auctionhouse` int(32) default NULL,
`item` bigint(10) default NULL,
`owner` bigint(10) default NULL,
`buyout` int(32) default NULL,
`time` int(32) default NULL,
`bidder` bigint(10) default NULL,
`bid` int(32) default NULL,
`deposit` int(32) default NULL,
PRIMARY KEY (`auctionId`)
) ENGINE=MyISAM AUTO_INCREMENT=11384 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for bids
-- ----------------------------
CREATE TABLE `bids` (
`bidder` bigint(10) NOT NULL default '0',
`Id` int(32) NOT NULL default '0',
`auctionhouse` int(16) NOT NULL default '0',
`amt` int(32) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`guid` int(6) unsigned NOT NULL default '0',
`acct` int(20) unsigned NOT NULL default '0',
`name` varchar(21) NOT NULL,
`race` smallint(3) unsigned NOT NULL,
`class` smallint(3) unsigned NOT NULL,
`gender` tinyint(1) unsigned NOT NULL,
`level` int(3) unsigned NOT NULL,
`xp` int(30) unsigned NOT NULL,
`exploration_data` longtext NOT NULL,
`skills` longtext NOT NULL,
`watched_faction_index` bigint(40) unsigned NOT NULL,
`selected_pvp_title` int(30) unsigned NOT NULL,
`available_pvp_titles` int(30) unsigned NOT NULL,
`gold` int(30) unsigned NOT NULL,
`ammo_id` int(30) unsigned NOT NULL,
`available_prof_points` int(30) unsigned NOT NULL,
`available_talent_points` int(30) unsigned NOT NULL,
`current_hp` int(30) unsigned NOT NULL,
`current_power` int(30) unsigned NOT NULL,
`pvprank` int(30) unsigned NOT NULL,
`bytes` int(30) unsigned NOT NULL,
`bytes2` int(30) unsigned NOT NULL,
`player_flags` int(30) unsigned NOT NULL,
`player_bytes` int(30) unsigned NOT NULL,
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`mapId` int(8) unsigned NOT NULL default '0',
`zoneId` int(8) unsigned NOT NULL default '0',
`taximask` longtext NOT NULL,
`banned` int(6) unsigned NOT NULL default '0',
`bannedReason` varchar(255) default NULL,
`timestamp` text,
`online` int(11) default NULL,
`bindpositionX` float NOT NULL default '0',
`bindpositionY` float NOT NULL default '0',
`bindpositionZ` float NOT NULL default '0',
`bindmapId` int(8) unsigned NOT NULL default '0',
`bindzoneId` int(8) unsigned NOT NULL default '0',
`isResting` int(3) NOT NULL default '0',
`restState` int(5) NOT NULL default '0',
`restTime` int(5) NOT NULL default '0',
`playedtime` text NOT NULL,
`deathstate` int(5) NOT NULL default '0',
`TalentResetTimes` int(5) NOT NULL default '0',
`first_login` tinyint(1) NOT NULL default '0',
`forced_rename_pending` int(30) NOT NULL,
`publicNote` varchar(32) NOT NULL default '',
`officerNote` varchar(32) NOT NULL default '',
`guildid` int(10) unsigned NOT NULL default '0',
`guildRank` int(10) unsigned NOT NULL default '0',
`charterId` int(30) unsigned NOT NULL,
`totalstableslots` int(10) unsigned NOT NULL default '0',
`instance_id` int(10) NOT NULL,
`entrypointmap` int(10) NOT NULL,
`entrypointx` float NOT NULL,
`entrypointy` float NOT NULL,
`entrypointz` float NOT NULL,
`entrypointo` float NOT NULL,
`entrypointinstance` int(10) NOT NULL,
`taxi_path` int(10) NOT NULL,
`taxi_lastnode` int(10) NOT NULL,
`taxi_mountid` int(10) NOT NULL,
`transporter` int(10) NOT NULL,
`transporter_xdiff` float NOT NULL,
`transporter_ydiff` float NOT NULL,
`transporter_zdiff` float NOT NULL,
`spells` longtext NOT NULL,
`deleted_spells` longtext NOT NULL,
`reputation` longtext NOT NULL,
`actions` longtext NOT NULL,
`auras` longtext NOT NULL,
`finished_quests` longtext NOT NULL,
`lastDailyReset` int(30) unsigned NOT NULL,
`killsToday` int(10) NOT NULL default '0',
`killsYesterday` int(10) NOT NULL default '0',
`killsLifeTime` int(10) default '0',
`honorToday` int(10) NOT NULL default '0',
`honorYesterday` int(10) NOT NULL default '0',
`honorPoints` int(10) NOT NULL default '0',
`difficulty` int(4) NOT NULL default '0',
UNIQUE KEY `guid` (`guid`),
KEY `acct` (`acct`),
KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for charters
-- ----------------------------
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`charterId`),
UNIQUE KEY `leaderGuid` (`leaderGuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for clientaddons
-- ----------------------------
CREATE TABLE `clientaddons` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(50) default NULL,
`crc` bigint(50) default NULL,
`banned` int(1) NOT NULL default '0',
`showinlist` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=153 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for corpses
-- ----------------------------
CREATE TABLE `corpses` (
`guid` bigint(20) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`zoneId` int(11) NOT NULL default '38',
`mapId` int(11) NOT NULL default '0',
`instanceId` int(11) NOT NULL default '0',
`data` longtext NOT NULL,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for finished_quests
-- ----------------------------
CREATE TABLE `finished_quests` (
`player_guid` bigint(20) unsigned NOT NULL default '0',
`quest_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`player_guid`,`quest_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for gm_tickets
-- ----------------------------
CREATE TABLE `gm_tickets` (
`guid` int(6) NOT NULL default '0',
`name` varchar(200) NOT NULL default '',
`level` int(6) NOT NULL default '0',
`type` int(2) NOT NULL default '0',
`posX` float NOT NULL default '0',
`posY` float NOT NULL default '0',
`posZ` float NOT NULL default '0',
`message` text NOT NULL,
`timestamp` text,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guild_ranks
-- ----------------------------
CREATE TABLE `guild_ranks` (
`guildId` int(6) unsigned NOT NULL default '0',
`rankId` int(1) NOT NULL default '0',
`rankName` varchar(255) NOT NULL default '',
`rankRights` int(3) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for guilds
-- ----------------------------
CREATE TABLE `guilds` (
`guildId` bigint(20) NOT NULL auto_increment,
`guildName` varchar(32) NOT NULL default '',
`leaderGuid` bigint(20) NOT NULL default '0',
`emblemStyle` int(10) NOT NULL default '0',
`emblemColor` int(10) NOT NULL default '0',
`borderStyle` int(10) NOT NULL default '0',
`borderColor` int(10) NOT NULL default '0',
`backgroundColor` int(10) NOT NULL default '0',
`guildInfo` varchar(100) NOT NULL default '',
`motd` varchar(100) NOT NULL default '',
`createdate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`guildId`),
UNIQUE KEY `guildId` (`guildId`)
) ENGINE=MyISAM AUTO_INCREMENT=387 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for instances
-- ----------------------------
CREATE TABLE `instances` (
`instanceid` int(11) NOT NULL default '0',
`mapid` int(11) NOT NULL default '0',
`npc_data` longtext NOT NULL,
`player_data` longtext NOT NULL,
`creation` int(15) NOT NULL default '0',
`expire` int(15) NOT NULL default '0',
`difficulty` int(11) NOT NULL default '0',
PRIMARY KEY (`instanceid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for ipbans
-- ----------------------------
CREATE TABLE `ipbans` (
`ip` varchar(32) NOT NULL,
`expire` int(16) NOT NULL default '0',
UNIQUE KEY `UniqueIp` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playercooldownitems
-- ----------------------------
CREATE TABLE `playercooldownitems` (
`OwnerGuid` bigint(10) NOT NULL default '0',
`ItemEntry` int(10) NOT NULL default '0',
`SpellID` int(10) NOT NULL default '0',
`SpellCategory` int(10) NOT NULL default '0',
`CooldownTimeStamp` int(11) NOT NULL default '0',
`Cooldown` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playercooldownsecurity
-- ----------------------------
CREATE TABLE `playercooldownsecurity` (
`OwnerGuid` bigint(10) NOT NULL default '0',
`SpellID` int(10) NOT NULL default '0',
`TimeStamp` int(10) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 123904 kB; InnoDB free: 123904 kB';
-- ----------------------------
-- Table structure for playeritems
-- ----------------------------
CREATE TABLE `playeritems` (
`ownerguid` int(10) unsigned NOT NULL default '0',
`guid` bigint(10) unsigned NOT NULL default '0',
`entry` int(10) unsigned NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`count` int(10) unsigned NOT NULL default '0',
`charges` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`randomprop` int(10) unsigned NOT NULL default '0',
`itemtext` int(10) unsigned NOT NULL default '0',
`durability` int(10) unsigned NOT NULL default '0',
`containerslot` int(11) default '-1',
`slot` int(10) NOT NULL default '0',
`enchantments` longtext NOT NULL,
PRIMARY KEY (`guid`),
UNIQUE KEY `guid` (`guid`),
KEY `ownerguid` (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playerpets
-- ----------------------------
CREATE TABLE `playerpets` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(11) NOT NULL default '0',
`name` varchar(21) NOT NULL default '',
`entryid` bigint(20) NOT NULL default '0',
`data` longtext NOT NULL,
`xp` int(11) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`loyalty` int(11) NOT NULL default '0',
`actionbar` varchar(200) NOT NULL default '',
`nextloyaltyupdate` int(11) NOT NULL default '0',
`summon` int(11) NOT NULL default '0',
`autocastspell` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playerpetspells
-- ----------------------------
CREATE TABLE `playerpetspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`petnumber` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0',
`flags` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for playersummonspells
-- ----------------------------
CREATE TABLE `playersummonspells` (
`ownerguid` bigint(20) NOT NULL default '0',
`entryid` int(4) NOT NULL default '0',
`spellid` int(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for questlog
-- ----------------------------
CREATE TABLE `questlog` (
`index` bigint(20) unsigned NOT NULL auto_increment,
`player_guid` bigint(20) unsigned NOT NULL default '0',
`quest_id` bigint(20) unsigned NOT NULL default '0',
`slot` int(20) unsigned NOT NULL default '0',
`time_left` bigint(20) NOT NULL default '0',
`explored_area1` bigint(20) unsigned NOT NULL default '0',
`explored_area2` bigint(20) unsigned NOT NULL default '0',
`explored_area3` bigint(20) unsigned NOT NULL default '0',
`explored_area4` bigint(20) unsigned NOT NULL default '0',
`mob_kill1` bigint(20) NOT NULL default '0',
`mob_kill2` bigint(20) NOT NULL default '0',
`mob_kill3` bigint(20) NOT NULL default '0',
`mob_kill4` bigint(20) NOT NULL default '0',
PRIMARY KEY (`index`),
KEY `index` (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=6075180 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for social
-- ----------------------------
CREATE TABLE `social` (
`guid` int(6) NOT NULL default '0',
`socialguid` int(6) NOT NULL default '0',
`flags` varchar(21) NOT NULL default '',
`noticed` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`guid`,`socialguid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for tutorials
-- ----------------------------
CREATE TABLE `tutorials` (
`playerId` bigint(20) unsigned NOT NULL default '0',
`tut0` bigint(20) unsigned NOT NULL default '0',
`tut1` bigint(20) unsigned NOT NULL default '0',
`tut2` bigint(20) unsigned NOT NULL default '0',
`tut3` bigint(20) unsigned NOT NULL default '0',
`tut4` bigint(20) unsigned NOT NULL default '0',
`tut5` bigint(20) unsigned NOT NULL default '0',
`tut6` bigint(20) unsigned NOT NULL default '0',
`tut7` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`playerId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
just create a sql file of all of the above and import into your database.
Wtf this database does not containes the T6 armours ?
It looks like that when i try to add an item set it does not work ..thats valable for all the sets i tryed so far ..if i try a normal .lookupitem still does not shows-up. Only tried for items contained in T sets.. Any ideeas ?
PS: I bellive that i will need a long rest-time after i make this server work .. :|
Hmm.. I get the realmlist loop. What to do? :P
I have forwarded every port needed.
3306
5000
8129
3724
8093
Man i had that error or whatever you want to call and after i used rev301 it worked again , take a look here for last rev Index of /antrix
Reply With Quote
