[fixed] Permanent fly

[Princess]

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?

[VladimirMangos]

what? they _must_ continue fly by taxi path at relogin, this is expected...

[Princess]

Yes, they continue and finish the fly but when relog apear flying again...

Is there any form to fix this by bd?

[darkstalker]

flying outside taxi flight?

[Princess]

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

[Princess]

any way to clean this char?

[VladimirMangos]

if this single char problem, in time when it offline replace taxipath field in characters table by empty string.

[Princess]

i'll try, Thx!

[Princess]

if this single char problem, in time when it offline replace taxipath field in characters table by empty string.

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

[VladimirMangos]

this is _impossible_. Then you look in wrong place/etc

[Princess]

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 = ''

[EARTHWALKER]

Does this have something to do with the fact you are spelling taxi as taxy? Just a thought.

[VladimirMangos]

can you make pdump of character and post it to me by PM?

[Princess]

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

[VladimirMangos]

pdump is console command that let save character data state or re-add back to character DB clone of saved character.

[VladimirMangos]

I test character from your pdump and it work fine for me. BUT i must note that you have custom fields in `characters` table

So maybe your chaarcter just not saved propertly and then at next time load prev. not saved state.

I drop redundent field when load your character from pdump data.

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

If loot in your previour qoute this is `grantableLevels` field. Possible you use some custom patch but now not use it. I seuggest (after do backpup) just drop this field from table and this with bit chnace will fix problem.

[Princess]

I'll try it. Thanks again for your help

PD: grantableLevels is for the patch Refer a friend but I don't use it...

[breakwater]

same problem on my server.

i have the refer friendsystem too+

only one char is infected

What i have make:

a long fly...

".save" on character

log out

log in

and then

a long fly...

any solutions?

[putka]

Happened to few ppl on our server aswell. Nothing worked even editing the taxi_path. Guy was still flying after every relog while char was totally fine when someone else was logging with it. Only solution came from the guy himself and here is what he said:

I fix it this way how i bugged it. Going flyghtmaster, use taxi, join bg, relog, leave bg wait to land and relog again. This way i bugged it and fixed it too -.-

[Princess]

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

[voidx]

Hi vlad, and all, the problem isnt grantableLevels, in clean mangos i have this problem.

Solve:

.pdump write x x

.char erase x

.pdump load x account

if you make this the problem solver.

I think the problem is related to character guid or something.

[VladimirMangos]

it can't be related guid: you will can't load character if guid will wrong.

And "something" not very good description ....

Maybe problematic characters have data in table 'character_battleground_data'. Can you check this for next problematic case?

[lillecarl]

I think they did not understand that after changing data in the database you must restart the server and then he can log in again and he CAN NOT fly, then he will be standing somewhere, like you said vladmir it is "impossible"

[Princess]

I'd restart my server always when I change something.

[rezinomed]

Hi, i was in the same trouble, and i resolved it looking into 'character_battleground_data'.

The troubled character had an entry with columns 'taxi_start' and 'taxi_end' filled with data. I put them both to 0 and voilà, the problem disappeared at next login.

Now, i think there's some broken mechanic when the server crashes and the characters is in a battleground, and entered the battleground while in flight.