[NEW] EMU Expert Question/request/FAQ thread, QUESTIONS HERE!

[Gastricpenguin]

Doesnt matter, it will save as a .sql regardless.
Thats the beauty of notepad.
LRN2SAVE before telling me whats what.

[Messawood]

Hmm i have recently learned a skill from http://www.mmowned.com/forums/emulat...gm-spells.html
but when i try to cast the skill it says skill is not availble to you id there anyway to fix that?
this skill is called drop heavy bomb code 33836 to anyone who played the real game it was the quest at level 60 that you drop the area 52 bombs and they casue this big explosion but it does not work in the real game on the round but i wanted to try it in a privite server i wonder if thats why i cant cast it time to try

[Gastricpenguin]

Run this query in the world database

DELETE FROM `spell_disable` WHERE (`spellid`='33836') AND (`replacement_spellid`='0');

[Messawood]

yay but where do i do that in the game with commands or in my database so far i think it is database hmm where is that

[Gastricpenguin]

You have to take the spell out of the "Spell_Disable" table in your database.
Then restart the server and it will work again.

[Messawood]

ok i figured out how to do it thanks i hope it works time to test it after it works ill tell you and give you rep 2 secs later... wow you read ths forum alot thanks alot that meansw you answered my question in 3 mins but i figured it out too oh well 1MIN LATER after restarting SWEET (spam) jk thankyou again +repreprerperp

[mayogargler]

dann and latruwski, thank you heaps.

[~Jagris]

Hey two things one if the mods are having trouble this is a program I found someone post on the forums y'all can help him from your omp and tell him hwat is happening CrossLoop - Download

And I need a program that I cna draw pretty much the walls chose the object to make it your of and then the GOBJECT code and spawn it where I want ( like a maze =P)

And just add some people might like a program that lets them make quest even chains like the sipex thing works that will help people

[**Sweeny**]

Ok :S having another problem now.. when i use logon.exe everything is fine.. no errors at all.. then when i start up ascent.exeit says sql:main database initilaztion failed.existing. *sigh* pretty sure it will have something too do with my logon.CONF so ill post em.. Oh and im using norwegian v4.0 database /w WoW version 2.3.2 <LogonDatabase Hostname = "localhost"
Username = "root"
Password = "root"
Name = "ascent"
Port = "3306"
Type = "1">
<Listen Host = "0.0.0.0"
ISHost = "0.0.0.0"
RealmListPort = "3724"
ServerPort = "8093">
<Client MinBuild = "6739"
MaxBuild = "9999">

and ascent just too be sure.

<WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "ascent" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "ascent" Port = "3306" Type = "1">
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">

[Clain]

Do you use a logon database and ascent or just one. If you use both then set the name of the characterdatabase to logon. then change it in the logon.conf

[Gastricpenguin]

Hey two things one if the mods are having trouble this is a program I found someone post on the forums y'all can help him from your omp and tell him hwat is happening CrossLoop - Download

And I need a program that I cna draw pretty much the walls chose the object to make it your of and then the GOBJECT code and spawn it where I want ( like a maze =P)

And just add some people might like a program that lets them make quest even chains like the sipex thing works that will help people

This isnt a request thread : /
This is for people who are having troubles or problems.

[**Sweeny**]

Do you use a logon database and ascent or just one. If you use both then set the name of the characterdatabase to logon. then change it in the logon.conf

im using just 1 "ascent" checked my CONF. files many times pretty sure everything is right, just posted them just too make sure I did everything rite. gotten up these servers before just having a little trouble with this 1. did everything rite aswell.

[dann462]

yes... the core is not compatible with the structure of the mailbox table in your database...
you said you were using 3.5 stable... delete the mailbox table from your DB and run this query:


and test if it works then...

grtz

Well thanks, but the problem is the same

[latruwski]

Well thanks latruwski +rep, but I have a problem now.
So when ppl send a mail to their other char it fail. I got this report in the ascent.exe:
Sql query failed due to [Column count doesn't match value count at row 1], Query: [REPLACE INTO mailbox VALUES <4,0,55,11,"Mail","test",0,' ',0,41,1204461960,1201869960,0,0,0>]

Any idea?

did u run these updates:

alter table mailbox add column external_attached_item_guid bigint(20) not null default 0 after attached_item_guid;

and

alter table mailbox drop column external_attached_item_guid;
alter table mailbox change column attached_item_guid attached_item_guids varchar(200) not null default "";
drop table playeritems_external;

...try that...

grtz

[dann462]

Thank you Latruwski finally it works