Latest Ascent Core+Database

Hi all,

First time setting up ascent and I'm running 1539 using NCDB. Everything seems to be working fine except I can't seem to buy particular items from vendor NPCs. It just says "Item was not found". Would appreciate any help on this. Thanks in advance.

It says arena working in rev 1524+

I cannot talk to BG masters using NCDB..

so, ive been slowly reading up on this a bit, and afew others, after getting stuck on mangos with a realmloop, i decided to trash everythin and start fresh with something else, so i started with this, everythings up to max rev, tnsp8 etc. and still get a realm loop. only get 1 error durring loading and thats with the creature_proto <42/36> not enough data, ive also read about adding maxversion to 9999 which i tried, and still get a realm loop. so slowly into getting most of these but its comming to me..

ascent1539? when i downloaded it says 1549 :>

oops sorry :P

I would really appreciate if you could add a changelog in the new releases :D

Well I used rev 1549 and Ascent CRASH!! Its loading... after 3-4seconds CRASH!!!>...< I`m using other rev atm and working FINE whats the problem whit that one?? Why dosent work???

Thanx alot 4 your releases :D ... just 1 thing ... the creature proto's arewnt loading :o ... and my mounts dont work ... could u plzplzplz either post the changelog here or add it with the next realeases PLZ

U OWN!!!

creature_proto is not loading so all the creature are gone when i join the server

Once I get home I will give you the execute query for that fix, Dannstah.

Ye got same problem and after that crash :) and one more where i get the new new DBC'S? :( thanks... thanks for your help.

any idea on that realm loop?

Code:

---

-- Run this query only if you are using rev 1542 or newer!
ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

---

t4k

well all is working fine just that warsong gulch don't work! when I enter it crash and I get a critical error
I use NCDB database and newest ascent 1549

Yea same problem here dosent work :( .... getting the same problem whit that to... and a ascent crash after 2hour's... exactly 2 hours...

And if someone can give me the X,Y,Z coordonate's for Shatt Because I change whitout to save them :).. thanks

YAY! *THANX* !!! +Rep titus4k (if there was somethin like that here :p) ... just 1 question ...Whered u get that? ... coz I checked the changelog (in the svn) and it dint show that :( plz post that here :D ...

THANX!!

If u have problem with pvp arena input this

CREATE TABLE `arenateams` (
`id` int(30) NOT NULL,
`type` int(30) NOT NULL,
`leader` int(30) NOT NULL,
`name` varchar(150) NOT NULL,
`emblemstyle` int(40) NOT NULL,
`emblemcolour` bigint(40) NOT NULL,
`borderstyle` int(40) NOT NULL,
`bordercolour` bigint(40) NOT NULL,
`backgroundcolour` bigint(40) NOT NULL,
`rating` int(30) NOT NULL,
`data` varchar(150) NOT NULL,
`ranking` int(30) NOT NULL,
`player_data1` varchar(60) NOT NULL,
`player_data2` varchar(60) NOT NULL,
`player_data3` varchar(60) NOT NULL,
`player_data4` varchar(60) NOT NULL,
`player_data5` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `charters` (
`charterId` int(30) NOT NULL,
`charterType` int(30) NOT NULL default '0',
`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`)

Got it from AscentEmu.com - Ascent Emulator user Burlex

Quote:

---

Originally Posted by titus4k

Code:

---

-- Run this query only if you are using rev 1542 or newer!
ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

---

t4k

---

i tried this, but i still get a server crash on start (dosent even load) or a few secs later using any rev past 1500+

i am using 1492 atm

are there any more queries i can run?

is the new ascent1549 requires a new NCDB database?? because im experiencing something like "not enough data in creature_proto to proceed" liek that...

WTF!?????>.....< Guess what?? I changed REV AND!??? now..... all players got no items and if they buy..loot any items they ARE GONE after RELOG!! WTF IS THIS!?

eeey have a question :P when i try to .add an item like an rare bag it stands "adds a guardentry to the zonetables DB and reloads" so is there any sort of item list i can add so i got all the items in the game or what do i have to do!

speedy:

Code:

---

alter table playeritems drop column guid;
alter table playeritems add column guid bigint(10) NOT NULL auto_increment primary key after ownerguid;

---

this might get trouble, if you have items in the mails or in auctionhouse. so get working ascent (older one) move all items into your players inventar. and apply the patch.

t4k

all these query came from svn history. most are posted not with the revision, they got changed. same with last creature_proto. it was announced by Zack a couple revs earlier.
since they change svn structure, there is only change-log from 1522 to latest. very bad move. (at least if you donwload trunk and not branches).

t4k

Quote:

---

Originally Posted by livingbones

i tried this, but i still get a server crash on start (dosent even load) or a few secs later using any rev past 1500+
i am using 1492 atm
are there any more queries i can run?

---

watch the whole ascent window, scroll up, and look, if you can find some strange reports/error messages. post the errors here.

t4k

Quote:

---

Originally Posted by wa113

eeey have a question :P when i try to .add an item like an rare bag it stands "adds a guardentry to the zonetables DB and reloads" so is there any sort of item list i can add so i got all the items in the game or what do i have to do!

---

use .additem