Princess

+10000

nice work! I suggest rename the table to "character_hidden_ratin" or "character_arena_hratin"

maybe something wrong in your mangos.conf? detectpostcollision?

Is absorb: -Warrior - druid charge. - Mass dispell without destroy himself -dots without destroy himself ids: 100,20252,49376,16979 It don't absorb hex, polimorf... I have mangos 11100

There are custom script made by this user's forum... I use linux, so I do.... cat *mangos*.sql > final_mangos.sql --> this will create a unique file with all the patchs for mangos DB cat *scriptdev2*.sql > final_scriptdev2.sql The characters updates I recommend you apply manually in the correct order.

It seems that your mangos DB is really broke! Try with a clean YTDB and apply de /addition sqls of RSA

what are the .cpp of the DB querys? maybe has a wrong sql query to update the pj...

I'll try it. Thanks again for your help PD: grantableLevels is for the patch Refer a friend but I don't use it...

http://www.assembla.com/wiki/show/ytdbase

The easy way to do this is...Go to YTBD webpage and download the correct version o DB that you need.

when you say pdump? is all the data of the character in the db?

INSERT INTO `characters` (`guid`, `account`, `name`, `race`, `class`, `gender`, `level`, `xp`, `money`, `playerBytes`, `playerBytes2`, `playerFlags`, `position_x`, `position_y`, `position_z`, `map`, `dungeon_difficulty`, `orientation`, `taximask`, `online`, `cinematic`, `totaltime`, `leveltime`, `logout_time`, `is_logout_resting`, `rest_bonus`, `resettalents_cost`, `resettalents_time`, `trans_x`, `trans_y`, `trans_z`, `trans_o`, `transguid`, `extra_flags`, `stable_slots`, `at_login`, `zone`, `death_expire_time`, `taxi_path`, `arenaPoints`, `totalHonorPoints`, `todayHonorPoints`, `yesterdayHonorPoints`, `totalKills`, `todayKills`, `yesterdayKills`, `chosenTitle`, `knownCurrencies`, `watchedFaction`, `drunk`, `health`, `power1`, `power2`, `power3`, `power4`, `power5`, `power6`, `power7`, `specCount`, `activeSpec`, `exploredZones`, `equipmentCache`, `ammoId`, `knownTitles`, `actionBars`, `grantableLevels`, `deleteInfos_Account`, `deleteInfos_Name`, `deleteDate`) VALUES (150181114, 1000133513, 'Censored', 4, 1, 0, 66, 282329, 4113624, 67634693, 17039360, 3072, 962.42, -3935.37, 20.5718, 1, 0, 2.25341, '3456411898 2684949841 805356355 2337275928 1049121 4456544 4 1048576 0 0 0 1073741824 0 0 ', 0, 1, 746147, 37621, 1300219468, 0, 395250, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 14, 1299077877, '', 0, 4732, 0, 0, 182, 0, 0, 2, 0, 4294967295, 0, 7489, 0, 0, 0, 100, 0, 0, 0, 2, 0, '1608175231 2843592151 2712522759 4119068610 3858756383 4293923727 4294704895 1375731774 143436 1206714606 4292784127 2894006015 2113448671 1829895173 4294885372 1019273215 4291529470 1466626931 2080303053 2172086266 252706728 1777647 4294688524 1631583807 3296588256 4238868567 1611089663 1862831040 2145386496 1926233917 2172717570 2059559040 643075 528512 1114112 2143289344 1069481728 2749366244 1677465430 2165498903 1343676416 16951811 1526727690 16891648 4288150528 172490781 15731968 973584424 134221856 276829314 114688 268443648 2048 2147549440 512 0 0 0 0 0 0 0 0 0 0 0 0 0 512 0 0 0 0 0 0 0 0 0 0 285212672 0 0 0 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ', '30856 0 25919 0 25715 0 6795 0 23489 15 15709 0 25979 15 28069 0 24941 0 25478 0 20907 0 25485 0 10418 0 25787 0 25489 0 25987 0 0 0 28062 0 5976 0 ', 28053, '4 0 0 0 0 0 ', 7, 0, NULL, NULL, NULL); You can see that Taxy_path = ''

Don't work. The player has taxy_patch="" and still flying to the same taxy each relog...Any idea?

for compression what is the best? Actually I have "6", but somebody tells me that "1" is the best...

i'll try, Thx!

any way to clean this char?

nop, flying in the same taxi flight, but permanent in each relog. Ej. .tele player dalaran. The player relog and he start flying in dalaran to the taxi patch...

He want to know how to create a .diff/.patch.

Yes, they continue and finish the fly but when relog apear flying again... Is there any form to fix this by bd?

hello guys I have a problem. sometimes when the server crash any players who was flying in a "taxi" keep permanent flying. They relog and when they logging into server continue flying...Any help?

I have this: restarter: screen -A -m -d -S mangos_restarter ./restarter-bin restarter-bin #! /bin/bash while true do PID1=$(pidof mangos-worldd) if (( PID1 < 1 )) then ./startw fi PID2=$(pidof mangos-realmd) if (( PID2 < 1 )) then ./startl fi sleep 20 done startl: screen -A -m -d -S mangos-realmd ./mangos-realmd startw: screen -A -m -d -S mangos-worldd ./mangos-worldd ulimit -c unlimited could it works with mtmaps?

I have dks with more than 71 talents points....

Hi guys, I'm new on Mangos. Anibody know the sql query to get the total talents points of each character by each spec?

checking for ACE... yes checking ace/Stack_Trace.h usability... yes checking ace/Stack_Trace.h presence... yes checking for ace/Stack_Trace.h... yes and when I compile... Making all in realmd make[3]: se ingresa al directorio `/home/kero/mangos/objdir/src/realmd' CXX AuthSocket.o CXX BufferedSocket.o CXX Main.o CXX RealmList.o CXX PatchHandler.o CXXLD mangos-realmd ../shared/libmangosshared.a(Threading.o): In function `ACE_Thread::keycreate(unsigned int*, void (*)(void*), void*)': /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' ../shared/libmangosshared.a(Threading.o): In function `~ACE_TSS': /usr/local/include/ace/TSS_T.cpp:35: undefined reference to `ACE_OS::thr_key_detach(unsigned int, void*)' /usr/local/include/ace/TSS_T.cpp:35: undefined reference to `ACE_OS::thr_key_detach(unsigned int, void*)' ../shared/libmangosshared.a(Util.o): In function `ACE_Thread::keycreate(unsigned int*, void (*)(void*), void*)': /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' /usr/local/include/ace/Thread.inl:23: undefined reference to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' ../shared/libmangosshared.a(Util.o):/usr/local/include/ace/Thread.inl:23: more undefined references to `ACE_OS::thr_keycreate(unsigned int*, void (*)(void*), void*)' follow ../shared/libmangosshared.a(Util.o): In function `~ACE_TSS': /usr/local/include/ace/TSS_T.cpp:35: undefined reference to `ACE_OS::thr_key_detach(unsigned int, void*)' /usr/local/include/ace/TSS_T.cpp:35: undefined reference to `ACE_OS::thr_key_detach(unsigned int, void*)' collect2: ld returned 1 exit status make[3]: *** [mangos-realmd] Error 1 make[3]: se sale del directorio `/home/kero/mangos/objdir/src/realmd' make[2]: *** [all-recursive] Error 1 make[2]: se sale del directorio `/home/kero/mangos/objdir/src' make[1]: *** [all-recursive] Error 1 make[1]: se sale del directorio `/home/kero/mangos/objdir' make: *** [all] Error 2 Any help?

any news about this? some hack to temporaly fix?