lecails

Where have you see the problem is fixed ?

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 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 .

Has you fixed duel bug ?

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

You need add sql query(in c++) in function which check latency. Yes you can add latency stats but database need modification , add a field in characters or create new table . I dnt think because you need to store latency for use . Minimanager can't modify mangos core or database,because latency its not stored precisely in database minimanager cant return player latency .

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 .

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 .

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

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 .

Yes i can make but what php script you want ?

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 .

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.

What is the script which you used ?

I see no difference . Maybe a cleanup code . 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 .

You don't need use SELECT query , use this php function is the best way : mysql_insert_id 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