lecails

i can use with the problem fixed

Where have you see the problem is fixed ?

At last I understood what was in conflict with Dual-spec

this is a patch of 'tester20' 'some fix for ramm spells'

or patch of Anti for vehicle energy, power, steam etc.

remove the patches and Dual-spec will works!

Edit:

now I'm seek to resolve the problem. I want patches to stay and not to conflict with Dual-spec

Oki thanks trapi ! Im waiting your patch . Add your fix too (drake,occulus and other ..)

I think there is a easy way for this , change this

QueryResult *result = CharacterDatabase.PQuery("SELECT guid,name,race,class,gender,level,zone,guild FROM fake_characters WHERE online=1 order by level");

to

 QueryResult *result = CharacterDatabase.PQuery("SELECT guid,name,race,class,gender,level,zone,guild FROM characters WHERE online=1 AND online=2 order by level");

now you just need modify online in database to "2" and you dnt need to create fake characters . But maybe this modification need improvment (login phase check,logout phase).

OR

 QueryResult *result = CharacterDatabase.PQuery("SELECT guid,name,race,class,gender,level,zone,guild FROM characters WHERE online!=0 order by level");

But with this solution you just need modify sql query and database .

thanks przemratajczak, patch works fine, I just had to fix some little details.

Has you fixed duel bug ?

My web developer made a complete mail index via php that connects the ids of the items to the mail but any who moving on from that.

Im surprised no one has figured out why you have to relog, im beginning to think its just not updating the session to the player.. The other external mail patch let you receive mail while logged in so something must be missing to update the player and say "hey you gots mail" sad thing is i haven't looked at it hard enough to see why it isn't pushing to the player unless they relog and it reloads all there mail, and other junk.

You need to modify the mail function , I think maybe he check mail that the player send just a login in . You need analyse the code for auction house because the mail that is sent when the player buy is immediat.

Analyse the auction house(the part for mail item send) code if you need absolutly receive mail when you is logged .

ok so you say this can't be done with the code that exists right now ?

You need add sql query(in c++) in function which check latency.

i need to edit the core and the database so i can add latency?

Yes you can add latency stats but database need modification , add a field in characters or create new table .

isn't there another way?

I dnt think because you need to store latency for use .

there were a website that had the latency thing, minimanager i think it was called, but can't find it and not shore if that was the website.

Minimanager can't modify mangos core or database,because latency its not stored precisely in database minimanager cant return player latency .

Thanks i need Send Item or Money to the TABLE mail_external and mail_external_items

To Send Item or money :

<?php
//Variable
$receiver="The guid of character";
$subject="Subject of mail";
$message="The content mail whithout special char";
$money="The money that you want send (copper coin) , put 0 if you send just item ";  
$item_id="Your item id that you want send";
$count="The number of item , if you put 2 for example there is 2 x the same item ";
//Sql query
$database = mysql_connect('ip_server', 'login', 'password'); 
mysql_select_db('database name where the table are.',$database);
mysql_query('INSERT INTO mail_external (`receiver`, `subject`, `message`, `money`) VALUES
('$receiver', '$subject', '$message', '$money')');
$mail_id = mysql_insert_id();
mysql_query('INSERT INTO mail_external_items (`mail_id`, `item`, `count`) VALUES
('$mail_id', '$item_id', '$count')');
mysql_close();
?>

Its just the base for send mail , you can improve the code whith dynamic data (and other ) for this you need use form (GET or POST) .

You can add line in player_xp_for_level table for choice which xp player need for next level .

@Andy200877 and @Biali

the database has no relevance in this case and decision is here:

UPDATE quest_template SET ReqSpellCast1 = 51859, ReqSpellCast2 = 51859, 
ReqSpellCast3 = 51859, ReqSpellCast4 = 51859 WHERE entry = 12641;

Edit:

I do not know why 'tester20' deleted this important part for the database mangos.

It's simple and true .

INSERT INTO spell_script_target (`entry`, `type`, `targetEntry`) VALUES 
(51858,1,28525),
(51858,1,28542),
(51858,1,28543),
(51858,1,28544),
(51859,1,28525),
(51859,1,28542),
(51859,1,28543),
(51859,1,28544); 

I think maybe this is now wrong , check if creature entry exist in creature table : 28525, 28542, 28543, 28544 , if 2/4 are working two exist and two other are removed .

I've testet UDB and can't complete the quest. Only 2/4 are working...

I've testet both DB's... UDB and YTDB and i can't complete the quest...

What is your UDB rev ?, its a sql code bug what are the two structure which complete quest ?

So, I am using last mangos and last ytdb as well. I've applied this v2.1 patch and its patch's patch.

Is there any way to avoid the server's crash? I was looking for that solution where people leave eye immortal. It would be enough.

Is this change made in the database? how? where? please help.

And that thing Andy is reporting... about partially complete the quest... Using UDB things works better?

I've changed from UDB to YTDB because of another problem (i cant remember well, I think it was because of graveyard_zones or something like that).

UDB > YTDB?

Sorry, I am just starting. I hope you can help me.

Thank you in advance.

The easiest solution is changed DB , whith UDB you will not problem , eye die its not possible because there arn't mobs on grid () and for complete quest its work properly because sql script has been maked for UDB .

can someone please make this a php script?

Yes i can make but what php script you want ?

../../../src/game/SkillHandler.cpp: In member function âvoid WorldSession::HandleMirrorImageDataRequest(WorldPa cket&)â:

../../../src/game/SkillHandler.cpp:100: error: âObjectAccessorâ has not been declared

../../../src/game/SkillHandler.cpp:105: error: âObjectAccessorâ has not been declared

Why SkillHandler.cpp ? The patch not affect SkillHandler.cpp but rather SpellHandler.cpp, has you patch manualy ?

What is the utility ?

Its not stored in the DB so you need make a code in mangos for store in DB then make a while in php whith Fetch query .

I also had the problem that you need to relog with the original patch I wrote, any idea why that happens ?

You need to modify the mail function , I think maybe he check mail that the player send just a login in . You need analyse the code for auction house because the mail that is sent when the player buy is immediat.

I have a problem compiling in on linux, on windows no problem but on my ubuntu:

Please could someone help me? Thanks in advance ^^

What is the script which you used ?

where exactly is the difference from v2.0 and 2.1?

I see no difference . Maybe a cleanup code .

nope... with this patch i've the same problem. when the eye die the server crash.

The server crash because he need to remove charm and posses when the eye is die however you cant revive the eye whith a basic resurrection (go to corpse and push revive), it's a creature not a player.

[quote name=Andy200877;112230

nope... with this patch i've the same problem. when the eye die the server crash. mangos rev 9651 / YTDB R54

UPDATE...

With Last UDB self Problem.

With both DB's :

When i explore the Forge' date=' it complete Scarlet Hold

When i explore the Town Hall, it complete the Chapel

By exploring the Scarlet Hold and Chapel, nothing apear.

So you can complete by this quest only 2/4 :-(

I've used the eye_of_acherus_reworked_v2 files. (Mangos-Core / SD2 / Database)

Where is my Problem and how can i fix ist ?[/quote]

Its a DB problem, for another DB modify sql query .

The UDB database not support entirely Quest Poi.

I seeked the flag which is set and I found PLAYER_DUEL_TEAM or PLAYER_DUEL_ARBITER . So we need to check if it set .

We can make a new function IsDueling() which check GetUInt32Value(PLAYER_DUEL_TEAM) and GetUInt64Value(PLAYER_DUEL_ARBITER) .

Great work ! I analyse duel system now .

$mail_id_num = mysql_query("SELECT id FROM mail_external WHERE receiver='$guid'") or die("ERREUR SQL!!");    

You don't need use SELECT query , use this php function is the best way : mysql_insert_id

mysql_query("INSERT INTO mail_external_items (`id`, `mail_id`, `item`, `count`) VALUES
('', '$mail_id_num', 29434, 10)");

However the problem is here, you insert a SELECT result . You need a variable whith mysql_result. exemple : $mail_id_num_2 = mysql_result($mail_id_num,0); and add variable in mysql_query : mysql_query("INSERT INTO mail_external_items (`id`, `mail_id`, `item`, `count`) VALUES

('', '$mail_id_num_2', 29434, 10)"); but whith mysql_insert_id it's better.

I have my hacky idea , somebody know how can i check if creator is in duel example if(creator->Isdueling), for change faction of clone . Else we can use creator->GetargetGuid(uint 64..) for choose target of clone ?

Small bug when you logout , the aura http://www.wowhead.com/spell=51852 is not removed