Herleybob - Ascent 2.3.0 Server Setup

[cman12]

Everything worked btw great guide but after i startup logonserver and ascent after it loads it says "sql failed due to [Table 'ascent.server_settings' doesnt exist], Query: REPLACE INTO server_settings VALUES<"last_honor_update_time", 1195614881"

its says that over and over again and sumtimes says last_arena_update_time instead of honor, and i cant login with any acounts i made? how do i fix this? plz respond it took we awhile to copy and i finaly finished and i hope this works,
email me at chgach @ gmail . com or comment here thnx!!

[BlackChaosAngel]

Alright, I can now access Importer.exe, ascent.conf, and loginserver.conf.. BUT. I make my account, put a simple name/pass, Az in GM to be a gm, 8 in flags, and save it. I go to log into the server, and it says it's wrong. Help please?

[shindaustin]

Dude i luv your guides. Made a server off of it when i couldnt give rep.
But step dad deleted it. Now my dads getting new comp that ima put a server on it. So i can't wait 2 use it. + rep for last guide!

[BlackChaosAngel]

Nevermind. I solved the problem. I have to make an exception to Port 8093 in my firewall. xD

Awesome guide, though.

[cman12]

i log in and when i make a character it doesnt appear in my character list...what do i do

[Turkeyman]

i need help when i run ascent.exe it says
one or more of the wow paramators were missing from the worldofwarcraft database

and then if i try to login it doesnt show any realms...

also can my friends on other comps join?

[davjer]

eeh can sombody zip/rar a repack for this and make it online !

[Oldwolf]

good guide
+Rep

[BYSCUIT]

hey when i try to log it its says this invalid name or passwor help

[Zunz]

Hey nice guide.

I did everything you said and when I activated the Ascent.exe(after Logonserv.exe) I couldn't connect..
It kept on saying "Authenticatin..authentication failed"

Please help

please help

[stray123]

it says ascent.characters does not exist

[BYSCUIT]

ok i did every thing i make ascent and accounts and run tools.exe and type w and hit enter and it says this .
(the system cannot find specified path) like 20 times
plz help

[BYSCUIT]

i fix it sorry about double posting

[strikefast]

Ok i have said this many times in this thread.... people need to read!

For these fix's to work you must go into SQLJOG and click on ur World Database (ascent if u followed the guide) and copy + paste these in there and highlight them all and press F5 that will execute there query.

I am still working on a fix for the guild master. if any one finds it please do post it up.

if you are still having problems with your npc's then you MUST be doing some thing wrong, because it has worked for alot of ppl.


the No Npc fix is this

Alter table creature_names add column mouseFlags int(30) not null default 0 after subname;

Npc talk/vendor/banks ect fix is

UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
-- UPDATE creature_proto SET npcflags = 262145 WHERE npcflags = 1537;
-- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
-- UPDATE creature_proto SET npcflags = ??? WHERE npcflags = 64;
UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;

Hate to bug you about this but exactly how do you get this info into sqlyog to fix the vendor issues? Thank you for all your time and effort with helping us.

[strikefast]

Ok NVM, I got it to work after playing around with it in SqlYog. Thanks for all the effort and guideance.