[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[tabo89]

zepelins dont work to northrend. why? or how can i fix it?

[johnstone]

delet this post plz ans sorry u the man for got 2 look in 2 the config's my bad

[keazain]

hi all repack link is fixed, i was linkin to a upload failure, all pack is up sorry

[keazain]

Tabo89, you have to wait until arcemu team have fixed that

[vintvlad]

My db is idenitic what you showed there, but still give error

[vintvlad]

Instance_template has been updated. You should be able to find this by looking at the Mangos updates. I had this issue when workin with 7100 version to 7200 mangos respectively.

Here's a pic of what the extra field needs to be. The top pic most likely shows your configuration. The bottom shows the extra field added.

After maxPlayers add the field maxPlayersHeroic, tinyint, 3, unsigned, default 0, not null. Should fix that error.



Hope that helps!

Pryd's Development Server

My db is idenitic what you showed there, but still give error

[NitroMan]

when i start the server everything goes fine all is working i log in successfully and i create a character but normally in the fun db isnt there supposed to be t7 startergear ??? i mean all other rev versions had t7 start gear and this one doesnt ? then i created a character and as i said i was in bikini ... no items on me and when i spawned a vendors or sumthing it doesnt work ... so i rec p to sw and i wen to guild master and i noticed that conversation works , cuz i clicked on i want to create a guild crest and it worked but when i clicked on browse goods it didnt work . so practically every vendor wich i try to click doestn work ... for example i spawn the tier 7 vendor , i go to him , right click him and nothing happens . then i right click him again and nothing happens . thats what happens with all vendors so not only tier 7 and ur vendors but the normal vendors too . what could be wrong ?

and another thing about the logon database i executed that one in my nvicat logon database and when i click accounts it says sumthing bout :
" accounts does not have a primary key
updates to this table will be done by using the following pseudo statement :
UPDATE accounts SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1 "

what am i doing wrong or what is wrong please ill rep the one who helps.

[KrisBG]

OMG somebody to tell me what is the best rev,repack for blizzlike server. i want to work Zepelins and DK WORK northerland spawned inst and more or i need to back to mangos and trinity BTW

[badot]

nitroman

i have the same problem after i upgrade to 2118 all toon are in their underwear (oh i'm sure the bloodelf female has the best body hehe) i check the SQLyog the item is there but it doesnt appear on your character.

keazain my man whats the problem

i thought you will answer my previous question i'm still waiting

[zadarkangel]

Nitroman as for the missing index replace this in the logon sql batch

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `acct` double default NULL,
  `login` varchar(96) default NULL,
  `password` varchar(96) default NULL,
  `SessionKey` varchar(765) default NULL,
  `encrypted_password` varchar(126) default NULL,
  `gm` varchar(96) default NULL,
  `vip` varchar(96) default NULL,
  `banned` tinyint(3) default NULL,
  `lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `lastip` varchar(48) default NULL,
  `email` varchar(192) default NULL,
  `flags` tinyint(3) default NULL,
  `forceLanguage` varchar(15) default NULL,
  `muted` double default NULL,
  `banreason` varchar(765) default NULL
 Primary Key (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

or go to the accounts table and set login as primary key using ure navicat


Hope this help u.

[badot]

ok now i see the problem the upper part is from 2075 and the lower part is from the new rev 2118

CREATE TABLE `accounts` (
`acct` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
`login` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login username',
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login password',
`encrypted_password` varchar(42) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`gm` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Game permissions',
`banned` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Standing',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
`lastip` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Last remote address',
`email` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Contact e-mail address',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Client flags',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enUS',
`muted` int(30) NOT NULL DEFAULT '0',
`banreason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information';


CREATE TABLE `accounts` (
`acct` double default NULL,
`login` varchar(96) default NULL,
`password` varchar(96) default NULL,
`SessionKey` varchar(765) default NULL,
`encrypted_password` varchar(126) default NULL,
`gm` varchar(96) default NULL,
`vip` varchar(96) default NULL,
`banned` tinyint(3) default NULL,
`lastlogin` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`lastip` varchar(4 default NULL,
`email` varchar(192) default NULL,
`flags` tinyint(3) default NULL,
`forceLanguage` varchar(15) default NULL,
`muted` double default NULL,
`banreason` varchar(765) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

in 2075 there is no "sessionkey" and "vip" so keazain what value can we put in the slot so it can go. or still there is something wrong.

[badot]

zadarkangel
ok my post is late so what value numeric or text goes to the new column is it 0 or just leave it blank
my post always late hehe my internet connection is bad

[zadarkangel]

hmm dunno but that my post was regarding primary key. i will look and if i figure out i will let u know
and if i remember well this UNIQUE KEY `a` (`login`) must be add if not u will have accounts with same login

[westside92]

nice repack

[badot]

zadarkangel

and the PRIMARY KEY (`acct`), i will include this also or not anymore

ok i'll wait for your post