nanounico

yeah, whatever

Well patman, i dont know much about c++, this patch is from trinity, maybe you can see the patch and understand how this work!

i thinks is a good option!

Hi, i try do this work with mangos, but i cant, please somebody help me, i really need this. Add Mail from an external source (such as PHP webpage) diff -r cd8712e64211 sql/updates/XXX_characters_extmail.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/sql/updates/XXX_characters_extmail.sql Tue Apr 07 09:02:36 2009 -0400 @@ -0,0 +1,21 @@ +DROP TABLE IF EXISTS `mail_external`; + +CREATE TABLE `mail_external` ( + `id` bigint(20) NOT NULL, + `sender` bigint(20) default NULL, + `receiver` bigint(20) default NULL, + `subject` varchar(200) collate latin1_general_ci default NULL, + `message` varchar(500) collate latin1_general_ci default NULL, + `money` bigint(20) default NULL, + `stationery` int(10) default '41', + `sent` tinyint(4) default '0', +PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; + +DROP TABLE IF EXISTS `mail_external_items`; + +CREATE TABLE `mail_external_items` ( + `mail_id` bigint(20) default NULL, + `item` bigint(20) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; + diff -r cd8712e64211 src/game/Mail.cpp --- a/src/game/Mail.cpp Tue Apr 07 14:33:41 2009 +0200 +++ b/src/game/Mail.cpp Tue Apr 07 09:02:36 2009 -0400 @@ -771,6 +771,59 @@ SendPacket(&data); } +void WorldSession::SendExternalMails() +{ + sLog.outString("Load External mails..."); + QueryResult *result = CharacterDatabase.Query("SELECT id,sender,receiver,subject,message,money,stationery FROM mail_external WHERE sent=0"); + if(!result) + { + sLog.outString("...No New Mails..."); + delete result; + return; + }else{ + do{ + Field *fields = result->Fetch(); + uint32 id = fields[0].GetUInt32(); + sLog.outString("Working Mail #%u",id); + uint32 senderGUID = fields[1].GetUInt32(); + uint32 receiverGUID = fields[2].GetUInt32(); + char const* subject = fields[3].GetString(); + char const* message = fields[4].GetString(); + uint32 money = fields[5].GetUInt32(); + uint8 stationery = fields[6].GetUInt8(); + Player* Receiver=objmgr.GetPlayer(receiverGUID); + uint32 NewItemTextID=objmgr.CreateItemText(message); + + MailItemsInfo MailItems; + + QueryResult *result2 = CharacterDatabase.PQuery("SELECT item FROM mail_external_items WHERE mail_id=%u",id); + if (result2) + { + sLog.outString("Mail has Items..."); + do{ + Field *itemfields = result2->Fetch(); + uint32 ItemID=itemfields[0].GetUInt32(); + Item* ToMailItem=Item::CreateItem(ItemID,1,Receiver); + ToMailItem->SaveToDB(); + MailItems.AddItem(ToMailItem->GetGUIDLow(),ToMailItem->GetEntry(),ToMailItem); + sLog.outString("Generated Item:%u, GUID:%u",ItemID,ToMailItem->GetGUID()); + }while(result2->NextRow()); + sLog.outString("..Done Items"); + } + + delete result2; + sLog.outString("...Send Mail #%u, Stationery #%u...",id,stationery); + WorldSession::SendMailTo(Receiver,MAIL_NORMAL,stationery ,senderGUID,Receiver->GetGUIDLow(),subject,NewItemTextID,&MailItems,money,0,MAIL_CHECK_MASK_RETURNED); + + sLog.outString("...Update Mail #%u to sent...",id); + CharacterDatabase.PExecute("UPDATE mail_external SET sent=1 WHERE id=%u",id); + sLog.outString("...Done Mail #%u...",id); + }while(result->NextRow()); + } + delete result; + sLog.outString("...End Load External mails"); +} + void WorldSession::SendMailTo(Player* receiver, uint8 messageType, uint8 stationery, uint32 sender_guidlow_or_entry, uint32 receiver_guidlow, std::string subject, uint32 itemTextId, MailItemsInfo* mi, uint32 money, uint32 COD, uint32 checked, uint32 deliver_delay, uint16 mailTemplateId) { if (receiver_guidlow == AHBplayerGUID) diff -r cd8712e64211 src/game/World.cpp --- a/src/game/World.cpp Tue Apr 07 14:33:41 2009 +0200 +++ b/src/game/World.cpp Tue Apr 07 09:02:36 2009 -0400 @@ -1523,6 +1523,7 @@ { mail_timer = 0; objmgr.ReturnOrDeleteOldMails(true); + WorldSession::SendExternalMails(); } ///-Handle expired auctions auctionmgr.Update(); diff -r cd8712e64211 src/game/WorldSession.h --- a/src/game/WorldSession.h Tue Apr 07 14:33:41 2009 +0200 +++ b/src/game/WorldSession.h Tue Apr 07 09:02:36 2009 -0400 @@ -157,6 +157,7 @@ //used with item_page table bool SendItemInfo( uint32 itemid, WorldPacket data ); static void SendReturnToSender(uint8 messageType, uint32 sender_acc, uint32 sender_guid, uint32 receiver_guid, const std::string& subject, uint32 itemTextId, MailItemsInfo *mi, uint32 money, uint16 mailTemplateId = 0); + static void SendExternalMails(); static void SendMailTo(Player* receiver, uint8 messageType, uint8 stationery, uint32 sender_guidlow_or_entry, uint32 received_guidlow, std::string subject, uint32 itemTextId, MailItemsInfo* mi, uint32 money, uint32 COD, uint32 checked, uint32 deliver_delay = 0, uint16 mailTemplateId = 0); //auction

Try reading.. lol

False.Genesis, when you post the patch? but please, for apply automatic

Core:[8379] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-18_11-35-12.log

Core:[8379] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-17_11-30-56.log

Core:[8379] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-17_06-01-47.log

Core:[8372] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-16_17-36-27.log

Core:[8372] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-16_11-43-04.log

Core:[8372] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-15_15-57-08.log

Core:[8369] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-15_09-54-32.log

Core:[8369] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-15_06-30-03.log Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. [New process 12815] [New process 12822] [New process 12821] [New process 12820] [New process 12819] [New process 12818] [New process 12817] [New process 12816] [New process 12812] [New process 12811] [New process 12810] [New process 12809] #0 0x000000348c230215 in raise () from /lib64/libc.so.6 #0 0x000000348c230215 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x000000348c231cc0 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x000000348c229696 in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000006a1513 in Player::BuildPlayerRepop (this=0x2aab56971940) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:4065 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0, _wpos = 4, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x2aab4956c5f0 "\\a¬{\\002«*", _M_finish = 0x2aab4956c5f4 "«*", _M_end_of_storage = 0x2aab4956c5f9 "^HN«*"}}, <No data fields>}}, m_opcode = 1172} corpse = <value optimized out> __PRETTY_FUNCTION__ = "void Player::BuildPlayerRepop()" #4 0x000000000078939b in WorldSession::LogoutPlayer (this=0x2aee5d90, Save=true) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:256 guild = <value optimized out> data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0, _wpos = 0, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x0, _M_finish = 0x2aab00000000 " ", _M_end_of_storage = 0x0}}, <No data fields>}}, m_opcode = 34} #5 0x00000000007899a6 in WorldSession::Update (this=0x2aee5d90) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:229 currTime = 6 #6 0x00000000007827f2 in World::UpdateSessions (this=0x2aaaac019680, diff=71) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2003 No locals. #7 0x0000000000783012 in World::Update (this=0x2aaaac019680, diff=71) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1550 No locals. #8 0x00000000004c340d in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 71 realCurrTime = 500306867 realPrevTime = <value optimized out> prevSleepTime = 61 #9 0x0000000000837c15 in ACE_Based::Thread::ThreadTask (param=0x3209) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = (class ACE_Based::Runnable *) 0x2aaac9958e50 #10 0x000000348ce06367 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x000000348c2d2f7d in clone () from /lib64/libc.so.6 No symbol table info available.

Core:[8369] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-14_18-16-46.log Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. [New process 632] [New process 639] [New process 638] [New process 637] [New process 636] [New process 635] [New process 634] [New process 633] [New process 626] [New process 624] [New process 623] [New process 622] #0 0x000000348c230215 in raise () from /lib64/libc.so.6 #0 0x000000348c230215 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x000000348c231cc0 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x000000348c229696 in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000006a1513 in Player::BuildPlayerRepop (this=0x2aab88cc2ce0) at /root/Desktop/Mangos/Sources/src/game/Player.cpp:4065 data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0, _wpos = 4, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x2aabb40ebfe0 "\\a¬{\\002", _M_finish = 0x2aabb40ebfe4 "", _M_end_of_storage = 0x2aabb40ebfe9 "ûJµ«*"}}, <No data fields>}}, m_opcode = 1172} corpse = <value optimized out> __PRETTY_FUNCTION__ = "void Player::BuildPlayerRepop()" #4 0x000000000078939b in WorldSession::LogoutPlayer (this=0x3474ca60, Save=true) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:256 guild = <value optimized out> data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 46912518516048, _wpos = 880069216, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x3474cb70 "", _M_finish = 0x348c27590c "\\203=Õõ-", _M_end_of_storage = 0x2aaba9a5b650 "àp\\025Ü«*"}}, <No data fields>}}, m_opcode = 22422} #5 0x00000000007899a6 in WorldSession::Update (this=0x3474ca60) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:229 currTime = 6 #6 0x00000000007827f2 in World::UpdateSessions (this=0x2aaaac006c90, diff=417) at /root/Desktop/Mangos/Sources/src/game/World.cpp:2003 No locals. #7 0x0000000000783012 in World::Update (this=0x2aaaac006c90, diff=417) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1550 No locals. #8 0x00000000004c340d in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 417 realCurrTime = 456306052 realPrevTime = <value optimized out> prevSleepTime = 0 #9 0x0000000000837c15 in ACE_Based::Thread::ThreadTask (param=0x26e) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = (class ACE_Based::Runnable *) 0x2aaaacad9990 #10 0x000000348ce06367 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #11 0x000000348c2d2f7d in clone () from /lib64/libc.so.6 No symbol table info available.

can some one, update this patch?

Core:[8365] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-13_13-29-13.log Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. [New process 20788] [New process 20795] [New process 20794] [New process 20793] [New process 20792] [New process 20791] [New process 20790] [New process 20789] [New process 20784] [New process 20783] [New process 20782] [New process 20781] #0 0x000000348c230215 in raise () from /lib64/libc.so.6 #0 0x000000348c230215 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x000000348c231cc0 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x000000348c229696 in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000007f1699 in WorldSession::HandleMovementOpcodes (this=0xe8d4500, recv_data=@0x2aab6ec75240) at /root/Desktop/Mangos/Sources/src/game/Object.h:480 opcode = <value optimized out> mover = <value optimized out> plMover = (class Player *) 0x0 movementInfo = {flags = 268435456, unk1 = 0, time = 41887039, x = 1029.14001, y = 1387.48999, z = 340.835999, o = 0.0892342702, t_guid = 0, t_x = 0, t_y = 0, t_z = 0, t_o = 0, t_time = 0, t_seat = 0 '\\0', s_pitch = 0, fallTime = 0, j_unk = 0, j_sinAngle = 0, j_cosAngle = 0, j_xyspeed = 0, u_unk1 = 0} data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0, _wpos = 36, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x34a567d0 "\\217µ\\017ì\\t@", _M_finish = 0x34a567f4 "", _M_end_of_storage = 0x34a567f7 "ñ!"}}, <No data fields>}}, m_opcode = 201} #4 0x00000000007886b5 in WorldSession::Update (this=0xe8d4500) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:206 packet = (WorldPacket *) 0x2aab6ec75240 currTime = <value optimized out> #5 0x0000000000781612 in World::UpdateSessions (this=0xd312720, diff=210) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1986 No locals. #6 0x0000000000781e32 in World::Update (this=0xd312720, diff=210) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1533 No locals. #7 0x00000000004c333d in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 210 realCurrTime = 352656693 realPrevTime = <value optimized out> prevSleepTime = 78 #8 0x0000000000836a95 in ACE_Based::Thread::ThreadTask (param=0x512d) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = (class ACE_Based::Runnable *) 0x2aaac99b9f20 #9 0x000000348ce06367 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #10 0x000000348c2d2f7d in clone () from /lib64/libc.so.6 No symbol table info available.

Core:[8363] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-13_12-43-46.log Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. [New process 20587] [New process 20594] [New process 20593] [New process 20592] [New process 20591] [New process 20590] [New process 20589] [New process 20588] [New process 20581] [New process 20580] [New process 20579] [New process 20578] #0 0x000000348c230215 in raise () from /lib64/libc.so.6 #0 0x000000348c230215 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x000000348c231cc0 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x000000349ecbec44 in __gnu_cxx::__verbose_terminate_handler () from /usr/lib64/libstdc++.so.6 No symbol table info available. #3 0x000000349ecbcdb6 in ?? () from /usr/lib64/libstdc++.so.6 No symbol table info available. #4 0x000000349ecbcde3 in std::terminate () from /usr/lib64/libstdc++.so.6 No symbol table info available. #5 0x000000349ecbceca in __cxa_throw () from /usr/lib64/libstdc++.so.6 No symbol table info available. #6 0x000000349ecbd1d9 in operator new () from /usr/lib64/libstdc++.so.6 No symbol table info available. #7 0x00000000004cde6c in std::vector<unsigned char, std::allocator<unsigned char> >::reserve (this=0x42dc2ed0, __n=20587) at /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../include/c++/4.1.2/ext/new_allocator.h:88 __old_size = 0 __tmp = <value optimized out> #8 0x00000000007f0f7d in WorldSession::HandleMovementOpcodes ( this=0x2aaafaf4c970, recv_data=@0x2aab722447f0) at /root/Desktop/Mangos/Sources/src/game/../shared/ByteBuffer.h:41 opcode = <value optimized out> mover = <value optimized out> plMover = (class Player *) 0x0 movementInfo = {flags = 268435456, unk1 = 0, time = 16009343, x = -7190.94922, y = -3944.65234, z = 9.22739124, o = 2.09358406, t_guid = 0, t_x = 0, t_y = 0, t_z = 0, t_o = 0, t_time = 0, t_seat = -85 '«', s_pitch = 0, fallTime = 0, j_unk = 0, j_sinAngle = 0, j_cosAngle = 0, j_xyspeed = 0, u_unk1 = 0} data = {<ByteBuffer> = {static DEFAULT_SIZE = 4096, _rpos = 0, _wpos = 0, _storage = {<std::_Vector_base<unsigned char,std::allocator<unsigned char> >> = { _M_impl = {<std::allocator<unsigned char>> = {<__gnu_cxx::new_allocator<unsigned char>> = {<No data fields>}, <No data fields>}, _M_start = 0x0, _M_finish = 0x0, _M_end_of_storage = 0x0}}, <No data fields>}}, m_opcode = 51888} #9 0x00000000007886b5 in WorldSession::Update (this=0x2aaafaf4c970) at /root/Desktop/Mangos/Sources/src/game/WorldSession.cpp:206 packet = (WorldPacket *) 0x2aab722447f0 currTime = <value optimized out> #10 0x0000000000781612 in World::UpdateSessions (this=0x11887700, diff=174) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1986 No locals. #11 0x0000000000781e32 in World::Update (this=0x11887700, diff=174) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1533 No locals. #12 0x00000000004c333d in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:65 diff = 174 realCurrTime = 349926390 realPrevTime = <value optimized out> prevSleepTime = 0 #13 0x0000000000836a95 in ACE_Based::Thread::ThreadTask (param=0x5062) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:182 _task = (class ACE_Based::Runnable *) 0x12341dc0 #14 0x000000348ce06367 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #15 0x000000348c2d2f7d in clone () from /lib64/libc.so.6 No symbol table info available.

Core: [8358] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-13_05-41-24.log

Core: [8358] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-13_03-45-39.log

Core: [8358] SD2: Latest YTDB: 503 ACID: 31 Patches: NONE crash_log_2009-08-12_16-37-32.log

8349 Latest Scriptdev2 YTDB 503 Patches NONE Centos 5.3 crash_log_2009-08-11_17-52-43.log

8349 Latest Scriptdev2 YTDB 503 Patches NONE Centos 5.3 crash_log_2009-08-11_17-09-18.log

8349 Latest Scriptdev2 YTDB 503 Patches NONE Centos 5.3 crash_log_2009-08-11_13-45-49.log

8349 Latest Scriptdev2 YTDB 503 Patches NONE Centos 5.3 crash_log_2009-08-11_13-43-17.log