Herleybob - Ascent 2.3.0 Server Setup

[shazarn]

when you create your account.

at the end of the collum you should see "flags" put an 8 in there.

thanks, thought it may be something to do with that!
and if anyone could get back to me here or PM me about the LAN serv that would be awesome
thanks

[FearMe]

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;

where do i do the update creature_ptoro set npcflags?
i cant find it

[GAmstah]

When i try connect to my SQLyog i get just this message "Acces denied for user 'root'@'localhost' (using password: YES)" Yesterday that connect work nicely.Thats why i hope some help :/ (this is my first time when i do server:weepy

[karal007]

costum shop t1 t7 all vendor 2.3.0 download link pls

[lesane44]

repack link dosent work plzz help

[Jatak]

Repack link is broke :'<

[FearMe]

Repack.zip - FileFront.com

heres a link on filefront as i promised

[gabbetorres14232]

well how to crwaTE VENDORs u cant find it at WoWApprentice.com - Guides

[hafastr]

Im workin on some custom vendors myself, if i get it done before anyone else i'll post it.

I use Developers Playground in tanaris more than GM island though, it has more room to play around.

wow-v doesnt have the right revision for their scripts for this DB ive been doing em by hand.

[Shaak]

I fixed the NPC bug.
But i cant figured out how to fix the graveyard bug.
Spawning new graveyards would'nt work, and there are some bugs with
talking with the NPC's.
Like: If you talk with bankers they say:
''Hello, how are you''?
And they dont let you see the bank.

The graveyard bug is only at Easterns Kingdoms, not on Outland and Kalimidor
So i say: if you want to make a server public, dont use this repack.
- Want it for own use USE THIS REPACK!
Because only that are the bugs, and other things works fine!
If i figured out how to fix this bugs, i will say it!

[GAmstah]

My database doesn't have account.sql brogram... i cant eny accounts do before i get that : /

[GAmstah]

Never mind :P (sry douple post :S)

[Shaak]

Herleybob, i dont know how i did it.
But i did it, i made the Graveyards working.
And i can spawn new graveyards and they work to.
Thanks for this great repack!
Keep it up +Rep

I fixed the NPC bug.
But i cant figured out how to fix the graveyard bug.
Spawning new graveyards would'nt work, and there are some bugs with
talking with the NPC's.
Like: If you talk with bankers they say:
''Hello, how are you''?
And they dont let you see the bank.

The graveyard bug is only at Easterns Kingdoms, not on Outland and Kalimidor
So i say: if you want to make a server public, dont use this repack.
- Want it for own use USE THIS REPACK!
Because only that are the bugs, and other things works fine!
If i figured out how to fix this bugs, i will say it!

[wiseguyxp]

Can you help me get the server online? It works locally and I got a no-ip (No-IP - Dynamic DNS, Static DNS for Your Dynamic IP) but that just goes to my router so I need some help setting up forwarding I think, plus when I add No-IP - Dynamic DNS, Static DNS for Your Dynamic IP into the realms.conf etc I get connection failed to MySQL.

I'm using WAMP5 and have the server Online.

Thanks

Go to PortForward.com - Free Help Setting up Your Router or Firewall to find out how to forward ports. Herleybob lists these ports to forward:

3724 - 3724
80 - 80 <--- only for a web server
3306 - 3306
8129 - 8129
8093 - 8093
6112 - 6112
6881 - 6999
3036 - 3036
8050 - 8050

To make your server public with your no-ip account, navigate to c:\windows\system32\drivers\etc and open up your hosts file with notepad. Under the few IP addresses listed there, type:

127.0.0.1 <tab> <your servegame address>

Change the IP addresses in your .conf files from 127.0.0.1 to your servegame address and change your realmlist.wtf to:

set realmlist <your servegame address>

If you have problems authenticating to your mysql server, I know there's a way to configure your mysql to let you authenticate from an address other than 127.0.0.1, but I don't know it off of the top of my head.

[Whiteninja547]

Now when I create a charecter, I cannot see the charecter I made. Please help!

Thanks for the help so far

I still have this problem... I dont know why :O