Description:
Does under your server players cant use anymore Friend Exp?? They have max level but firiend Exp still rising and rising...
well there is an way out - you can make an even for them - for instance: once per week you can exchange this gathered friend exp of all players from certain group and give them for it EP..
HOW?
Code:
update cq_user set Friend_share = 23998212 where Friend_share > 23998212;
you can for example change this limit to 1millep so it will be
23998212/2 = 11999106
or make it 5 mill = 11999106*5 = 59995530
I hope you catch this limit
If you dont wanna limit it - just dont run this query never .. BUt if you want - always run it before this next one
Code:
update cq_user set Friend_share = Friend_share*0.16668 where level = 255; update cq_user set Friend_share = Friend_share/2 where level = 255; update cq_user set emoney = emoney + Friend_share where level = 255; update cq_user set Friend_share = 0 where level = 255;
** All this codes you must use while maintenance (to be sure that no characters are online so it will 100% work)
** first code you can use in query to limit max ep that players will receive after using next query...
** this second query that has 4 actions will:
-> convert their exp into certain number that will correspond to this that is visible under client (in percent) (since in DB this number isnt same)
-> will divide this number into 2
-> will grow certain player ep amount for additional number from this exp convertion
-> will reset all players friend share to 0
AND all this is set here only for players who have 255 lvl (I believe most server has 255lvl peak - so from this time friend exp is useless)
OK more info about this feature can be read under our web:
I know its hand work - but it takes seconds to do it - but many players can benefit and feelll happy
Regards