Page 2 of 3
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 5:49 pm
by Lighted Shadows
Assuming password field is hashed as it is in EQEmu you can't just plug in a password like in my EQEmu to make a new accout I have to insert into the account table a row with the "sha(Password)"
I tried to put in the field manualy and I get password rejected message
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 5:58 pm
by Lighted Shadows
TY for the op code table it worked as far as inserting an account
Code: Select all
insert into account set name='Account Name', passwd=md5('Password')
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 6:16 pm
by Lighted Shadows
Well one hurdle at a time I think I am done for the day. TY all for your help
I was able to login to my server build created a character.
When I zoned into the game I had no character model like I was invisable.
Then I got what seams to be auto camped back to character select.
@ character select my model I picked changed to a bald female
I logged back in and still no model chat box said I was camping and I could not move.
back to character select again
then the World server crashed with a shit ton of op code errors
I assume its because I am useing the live client I will try again when I get my DoV box that cost me $30 for a game that is now free
Code: Select all
20:12:33 I Zone: Loading new Zone 'FrostfangSea'
20:12:33 I Spawn: Loaded for zone 'FrostfangSea' (470):
1800 NPC(s), 1238 Object(s), 59 Widget(s)
81 Sign(s), 1920 Ground Spawn(s), 1828 Spawn Group(s)
1164 Spawn Group Association(s), 0 Spawn Group Chance(s)
20:12:34 W Client: No character skills found!
20:12:34 E DBCore: #1452: Cannot add or update a child row: a foreign key constraint fails (`eq2local`.`character_skills`, CONSTRAINT `FK_skills_character` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
Query:
INSERT IGNORE INTO character_skills (char_id, skill_id, current_val, max_val) SELECT 1, skill_id, current_val, max_val FROM starting_skills WHERE class_id IN (21, 28, 29, 255) AND race_id IN (8, 255)
20:12:34 W World: No MOTD set. Sending generic message...
20:13:54 I Zone: Scheduling client 'Lighted' for removal.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 6:21 pm
by thefoof
I'll post a full world DB sometime tonight for you so that should get you running tomorrow, on the character create issue we literally fixed that yesterday. The structs I packaged with the exe I sent you should have fixed that issue as well if you're using them.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 6:28 pm
by Lighted Shadows
WEll it all started when I couldn't source in the eq2 database because it kept erroring out and not creating all the tables. I used the SVN dump and literally sourced in every table 1 by 1. I may have goofed something up. I can source a file but when it gives me 40 errors and stops 1/2 way thru I don't know howto fix that.
as far as file I will double check and make sure I used those
Keep in mind I am attempting to use a live client downloaded last night. DoV will be here some time this week had to get it off Amazon because no local stores still have box sets for a free game that has a streaming client lol
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 7:43 pm
by thefoof
Source this into an empty DB. It's the current spawns on DB Project with our old Milestone 1 spells.
http://up.ht/1azx5Ev
Let us know if you have more problems, but that should source in error free.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:01 pm
by Lighted Shadows
Media file will not let me download that file for some reason. bahhhh
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:08 pm
by thefoof
Lighted Shadows wrote:Media file will not let me download that file for some reason. bahhhh
I'll reupload...are you jinxed or something?
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:11 pm
by Lighted Shadows
Man if you knew me in person you would understand. I have bad Irish luck. I click media file download it says downloading the says file not downloading try again lol.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:16 pm
by Lighted Shadows
but anyway I got most of the missing tables in there not sure if they have the required data I can't add the missing groundspawns_items because it is referanced from anouther key and I dont know where. i'll wait on your file if I can ever get it.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:17 pm
by thefoof
Fixed the link.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:23 pm
by Lighted Shadows
OMG that was the most Add ridden tricky download site ever lol it was worse that trying to download a movie off some free TV site lol sourceing it in now.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:24 pm
by thefoof
LOL sorry about that, was the only one I could think of off the top of my head that didn't need an account
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:29 pm
by Lighted Shadows
I woulda paid a sub to a download site to get shit @ this point. while im @ it the GM commands for the game once im in are avalable Via the Commands table?
in EQEmu ingame you can just type
#help
what they all do I can figure out.
Re: Having trouble getting started...
Posted: Sun Nov 10, 2013 8:33 pm
by thefoof