Printable View
Ok, Got the server running, im not having a problem with the realm not showing up or anything. But what i am having a problem with is Creating a char. ill log in pick my server then create a char but it wont show up on my char screen.
So, i thought maybe its my user permissions on SQLYog so i check that are there all checked. Is anyone else getting this problem? if so, does anyone know how i might go about fixing it?
Might wanna put the revision you are using.
I am running rev1595 i had the same problem then i noticed in the ascent.config that i had
<WorldDatabase Hostname = "localhost" Username = "admin" Password = "****" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "admin" Password = "***" Name = "ascent" Port = "3306" Type = "1">
Then i changed it to
<WorldDatabase Hostname = "localhost" Username = "admin" Password = "****" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "admin" Password = "****" Name = "logon" Port = "3306" Type = "1">
Then my chars showed up. Don't know if that helps you.
Awesome, worked! thanks alot ofr that. Now i need to fix the no mobs/npc's problem. 1595 also BTW.
In Hatched's guide which you probly used he stated
Step 11. No NPCs?
If you don't have any NPCs/Mobs while inside the game, load up SQLyog.
Left click on the ascent database, and go over to your Query window.
Copy and paste this into it...
Code:
alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;
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;
Right click anywhere in the Query window, then Execute Query -> Execute All Queries.
Exit SQLyog and retry.
Congrats, you now have NPCs!
I was told this doesnt work so i ignored it. But ill try it anyways
worked great, shouldnt have ignored that step i geuss lol
#1 rule in following guides...
Don't skip steps. :)