John help and Bug issue.

[Sylaei]

John,
I tried to get into the content DB Editor and get the same error I got when you first set me up. Something about local.
Here is the error:

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Sylaei'@'eq2dev.mmoemulators.local' (using password: YES) in /home/eq2dev/public_html/eq2db/class/mysql4.php on line 50

And, I have been looking into bug #527 - Sprint initiates combat. The code executes a sql script that is looking for a column in the spell_tiers table named 'friendly_spell'. There is no such column in my database. I tried to get into the content DB Editor to see what was there but (John this is where you come in) I wasn't able to. I also noticed a bug where harvesting starts an attack. Could be we just need to add this column and set each spell as a 0 or 1.

I may attempt to change my db and see what happens.

[Sylaei]

Ok, adding the column didn't work. I keep looking at it.

[emulates]

Have you granted the user access and verified password is up to date? Looks like you may have forgotten to give the user permission using that particular hostname.

[Sylaei]

emulates,
This happened right after he gave me permission the first time. It has something to do with the way John saved something when he was making changes, if I remember right. It is all kind of hazy now.

No hurry John.

[ilythor]

Don't cross your fingers for John to come swooping in Gentlemen.

He stated a little while ago he is quite busy with real life stuff, this might be something you guys will have to solve on your own by the sounds of it.

FWIW it's nice to see your still trying to figure out how to do it! Don't give up!

[emulates]

I didn't realize there was something he had worked out previously to get you originally connected. I don't have any access to the db directly other than accessing Tess and just as a standard account. I'm currently working with the db that came in the Server Pack 1.2 and most likely coding with hopes of not making to many changes.
We'll keep our fingers crossed he gets back soon.

[Zcoretri]

John,
I tried to get into the content DB Editor and get the same error I got when you first set me up. Something about local.
Here is the error:

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Sylaei'@'eq2dev.mmoemulators.local' (using password: YES) in /home/eq2dev/public_html/eq2db/class/mysql4.php on line 50

And, I have been looking into bug #527 - Sprint initiates combat. The code executes a sql script that is looking for a column in the spell_tiers table named 'friendly_spell'. There is no such column in my database. I tried to get into the content DB Editor to see what was there but (John this is where you come in) I wasn't able to. I also noticed a bug where harvesting starts an attack. Could be we just need to add this column and set each spell as a 0 or 1.

I may attempt to change my db and see what happens.

Can you tell me where in the code you are looking at? I may be able to shed some light here.

The column 'friendly_spell' is in the 'spells' table only.

[Sylaei]

Well damn. Thanks Zcoretri.

I should have double checked before posting. The place where we were loading that field is in WorldDatabase::LoadSpells() in the WorldDatabase.cpp file. I noticed tonight that the sql statement does pull from both spells and spell_tiers.

I have the field in my spells table. For sprint 'friendly_spell' was set to 0. Setting it to 1 solved the attack issue.

I'll check the other bugs that are similar, like harvesting, and if they work right I'll fix them after John fixes me up.


Thanks, again Zcoretri, it made me read tonight. And I did sleep so maybe I couldn't see the forest for the trees?

[Zcoretri]

Glad I could help

[John Adams]

John,
I tried to get into the content DB Editor and get the same error I got when you first set me up. Something about local.
Here is the error:

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Sylaei'@'eq2dev.mmoemulators.local' (using password: YES) in /home/eq2dev/public_html/eq2db/class/mysql4.php on line 50

Sylaei,

I just logged into the editor fine using your name "Sylaei" and the password I PM'd you just now. PM me if it still doesn't work, as I get an email notification via PM - and will "swoop in" as quickly as I can

Tom, good to see you again.

[Sylaei]

John,
I was able to login. I guess I must have been smokin something the other day. If I was it was good enough to make me forget I was smokin it.



Thanks.