Last edited by Hatched; 04-10-07 at 01:46 AM. Reason: New Website
Life Database?
NICE TUT!
ezy to read and strait forward
I'll make one soon.. just need some time (I'll probably make it over the weekend).
Wooot!!! LOVELY!! No other way to explain it.. The guide is amazing.. So straight forward and easy to use... I completed whole guide and got my own server up and running for other people to go on to aswell without any errors or mistakes and people are actually connected. WOOT! Thanks alot!! :D!!!
Nice 1 ;D
Glad everyone appreciated it.
Anywho..
You don't have to use the database I provided in the tut, there are plenty more!
NCDB
TerraNet Rev 8 Sadly, they stopped the project.
Blazed Funserver Blazed Script Bin
ok.. everything worked but this one thing for me. I don't have any npc's or mobs, I did what you said in the tut with the executing querys but it still didn't work, i checked my DB and it shows that they should be spawning in the right spots but i still can't find them..
It says my account is invalid, and there in the database...
Don't keep your caps lock on, Matt. :)
Ok...First, thanks for your work...very much appreciated!! I've done everything outlined in this post but seem to have a problem logging on. I've checked and rechecked but to no avail. When i start up logonserver.exe I notice that the user name is correct but the password has 3 letters more than what I've put in all the password boxes. Why is that?..Although that appears to be wrong, 1 account is loaded and ready. Any help would be appreciated greatly....and thanks in advance.
Makoto
Same problem here, I successfully built my realm, logged into it, created a char, and entered the world... but no MOBS. I did step 11. no MOBs still.
I am a little confused with when and how to save what you're doing with SQLyog. Could that have something to do with it? after running that code in SQLyog are u supposed save it to one of the .sql files?
alright i found a kind of fix for it, I just used a different version of ascent lol (1463) idk why it works but i'm pretty happy :P, but i would like to know one thing.. how to I enable TBC?
its not the db thats the error -.-
Ok, uninstalled and reinstalled everything...done everything EXACTLY like the post says but when I start up wow.exe it says "disconnected from server" as soon as I enter my login:pass...Anyone have any ideas?
Hey nice guide but I have one problem:
when I start up logonserver all is fine, but when I run ascent it says:
connecting to 'Default Logon' on '127.0.0.1:8093'...ok
authenticating...
key: LOTTSSS OF NUMBERS DONT WANNA COPY ALL OF EM
result: failure.
then I changed the all '8093' ports in 'realms' to '8129' and now it says:
connecting to 'Default Logon' on '127.0.0.1:8093'...ok
authenticating...
key: LOTTSSS OF NUMBERS DONT WANNA COPY ALL OF EM
result: timeout.
at both cases I can log in on my server but there is no realm...
Hatched thank you for the great guide. I do have one issue though.
The NPC's and Mobs aren't showing up so I followed step 11 but still nothing. I did it again just in case still nothing.
When I execute the query i get these errors. This is the first time I've tried to set up a server so I'm not sure what to do. :confused_
Error Code : 1054
Unknown column 'health' in 'creature_proto'
(0 ms taken)
Error Code : 1060
Duplicate column name 'maxhealth'
(0 ms taken)
(0 row(s)affected)
(0 ms taken)
Error Code : 1054
Unknown column 'level' in 'creature_proto'
(0 ms taken)
Error Code : 1060
Duplicate column name 'maxlevel'
(0 ms taken)
(0 row(s)affected)
(0 ms taken)
Error Code : 1060
Duplicate column name 'invisibility_type'
(0 ms taken)
Error Code : 1060
Duplicate column name 'death_state'
(0 ms taken)
Error Code : 1060
Duplicate column name 'walk_speed'
(0 ms taken)
Error Code : 1060
Duplicate column name 'run_speed'
(0 ms taken)
This guide works perfect, but not with the new 1609, this is the same guide that was with 1595 and that works, for 1609 the npc tables are a little different, so therefore you will need a new query to execute, please just wait and I'm sure hatchet will figure something out, Thanks Hatch for this lovely guide!!!
Creating a new guide for Rev 1621 now. Please use rev 1595 for now, based this guide on that build.
Last edited by Hatched; 22-09-07 at 04:56 PM. Reason: Wrong edit.
its says logging in to gameserver and than i come's at The Realm selection. so i cant get in the server and can't make an account ... i tried to open the realmserver but then it says:
C:\Documents and Settings\Eigenaar\Bureaublad\Ascent>realmserver
19:51 N Server: ==============================================================
19:51 N Server: | Codename Ascent Cluster - Realm Server |
19:51 N Server: | Version 0.1, Revision 1510 |
19:51 N Server: ==============================================================
19:51 S Database: Interface Created.
19:51 S ClusterMgr: Interface Created
19:51 S ClientMgr: Interface Created
19:51 N Database: Connecting to database...
19:51 N Database: Connecting to MySQL on localhost with (moocow : *********)
sql: Connection failed. Reason was `Access denied for user 'moocow'@'localhost'
(using password: YES)`19:51 E Database: One or more errors occured while connect
ing to databases.
C:\Documents and Settings\Eigenaar\Bureaublad\Ascent>
and i dont have a Realmserver.conf or something... and my database isn't called moocow :l
the guide needs to be updated/fixed. First, in realms.conf u need to actualy put your IP there, not just leave it. that IP will also be the one you either put in your WTF or I use WOWscape Launcher for launching private servers.
to find your IP on windows XP/2000//ect go to start, run and in the box type 'CMD' (without Quotes, not case sensitive). This will open a comand line interface box for windows. Type 'IPCONFIG' (without Quotes, not case sensitive)
Secound, Step 11 is no good. It's usless, that's not the problem and the code is bad anyway. Thats why the error list.
Someone else posted that they were able to get it working with an earlier version of ascent on another thread, but didn't post a link of where to get it.
ok thank u but now i cant see theNpc's and mobs...