Merac Affinity Offer Disconnect

[darklord]

Hi all

 

 

While donations.. in game disconnected.. pls help me :/

[DamonA]

Look in the GameServer Log Output, there you will see a disconnected with more information.
In the most times your database dont match the client, so example export the affinity.lod from your database which run on the server.

[darklord]

2015-12-21 18:56:46,998 INFO [ Log.cpp : 148] - LOGIN REQ > steve : VERSION : 20141219 : MODE : 0 : IP : 127.0.0.1 : NATION : 9 : PROSITE :

2015-12-21 18:56:47,037 INFO [ Log.cpp : 148] - HANARO_EVENT > steve : PROSITE : LC : HAHARO_CODE :

2015-12-21 18:56:47,050 INFO [ mysqldb.cpp : 101] - no row : query[SELECT UNIX_TIMESTAMP(a_end_datetime) - UNIX_TIMESTAMP(NOW()) as remainTime, UNIX_TIMESTAMP(a_end_datetime) as endTime FROM t_extendcharslot WHERE a_user_index = 1]

2015-12-21 18:56:47,078 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_index FROM t_characters WHERE a_user_index=1 AND a_server=1 AND a_enable=1 AND a_deletedelay!=0 AND a_deletedelay<=UNIX_TIMESTAMP(NOW())]

2015-12-21 18:56:47,096 INFO [ mysqldb.cpp : 101] - no row : query[SELECT * FROM t_nscard WHERE a_user_index = 1]

2015-12-21 18:56:49,086 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET TOTAL KILL COUNT : 0

2015-12-21 18:56:49,093 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET TOTAL DEATH COUNT : 0

2015-12-21 18:56:49,100 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET WAR GROUND POINT : 0

2015-12-21 18:56:49,107 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET WAR GROUND ACC POINT : 0

2015-12-21 18:56:49,132 INFO [ PCList.cpp : 28] - Player Add Data : userIndex[1], charIndex[1] charName[sadas]

2015-12-21 18:56:53,778 INFO [ Log.cpp : 148] - JOIN > sadas : sadas : steve : 0 : 127.0.0.1

2015-12-21 18:56:53,786 INFO [ Log.cpp : 148] - CHAR_LOAD > steve : NAME : sadas : NICK : sadas : JOB : 0 : LEVEL : 185 : EXP : 0 : MONEY : 100

2015-12-21 18:56:53,786 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_index FROM t_express_system WHERE a_char_index=1 AND now() < a_expire_date LIMIT 1]

2015-12-21 18:56:53,797 INFO [ Log.cpp : 148] - ATTENDANCE EXP SYSTEM > sadas : sadas : steve : 1 : 0

2015-12-21 18:56:53,809 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_msg_type, a_item_index, a_item_count FROM t_tradeagent_after_sell_returned WHERE a_char_index = 1]

2015-12-21 18:57:20,361 ERROR [ doFuncAffinity.cpp : 271] - HACKING? : not equal point. clientPoint[350] serverPoint[7000]

2015-12-21 18:57:20,375 INFO [rnsocketioserviceTcp.cpp : 125] - bnf manual close - ip : 127.0.0.1 : unique id : 0000000005 : reason : not equal point

2015-12-21 18:57:20,385 INFO [rnsocketioserviceTcp.cpp : 689] - bnf closed - ip : 127.0.0.1 : unique id : 0000000005

[ZaTii]

2015-12-21 18:56:46,998 INFO [ Log.cpp : 148] - LOGIN REQ > steve : VERSION : 20141219 : MODE : 0 : IP : 127.0.0.1 : NATION : 9 : PROSITE :
2015-12-21 18:56:47,037 INFO [ Log.cpp : 148] - HANARO_EVENT > steve : PROSITE : LC : HAHARO_CODE :
2015-12-21 18:56:47,050 INFO [ mysqldb.cpp : 101] - no row : query[SELECT UNIX_TIMESTAMP(a_end_datetime) - UNIX_TIMESTAMP(NOW()) as remainTime, UNIX_TIMESTAMP(a_end_datetime) as endTime FROM t_extendcharslot WHERE a_user_index = 1]
2015-12-21 18:56:47,078 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_index FROM t_characters WHERE a_user_index=1 AND a_server=1 AND a_enable=1 AND a_deletedelay!=0 AND a_deletedelay<=UNIX_TIMESTAMP(NOW())]
2015-12-21 18:56:47,096 INFO [ mysqldb.cpp : 101] - no row : query[SELECT * FROM t_nscard WHERE a_user_index = 1]
2015-12-21 18:56:49,086 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET TOTAL KILL COUNT : 0
2015-12-21 18:56:49,093 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET TOTAL DEATH COUNT : 0
2015-12-21 18:56:49,100 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET WAR GROUND POINT : 0
2015-12-21 18:56:49,107 INFO [ Log.cpp : 148] - WAR GROUND > sadas : sadas : SET WAR GROUND ACC POINT : 0
2015-12-21 18:56:49,132 INFO [ PCList.cpp : 28] - Player Add Data : userIndex[1], charIndex[1] charName[sadas]
2015-12-21 18:56:53,778 INFO [ Log.cpp : 148] - JOIN > sadas : sadas : steve : 0 : 127.0.0.1
2015-12-21 18:56:53,786 INFO [ Log.cpp : 148] - CHAR_LOAD > steve : NAME : sadas : NICK : sadas : JOB : 0 : LEVEL : 185 : EXP : 0 : MONEY : 100
2015-12-21 18:56:53,786 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_index FROM t_express_system WHERE a_char_index=1 AND now() < a_expire_date LIMIT 1]
2015-12-21 18:56:53,797 INFO [ Log.cpp : 148] - ATTENDANCE EXP SYSTEM > sadas : sadas : steve : 1 : 0
2015-12-21 18:56:53,809 INFO [ mysqldb.cpp : 101] - no row : query[SELECT a_msg_type, a_item_index, a_item_count FROM t_tradeagent_after_sell_returned WHERE a_char_index = 1]
2015-12-21 18:57:20,361 ERROR [ doFuncAffinity.cpp : 271] - HACKING? : not equal point. clientPoint[350] serverPoint[7000]
2015-12-21 18:57:20,375 INFO [rnsocketioserviceTcp.cpp : 125] - bnf manual close - ip : 127.0.0.1 : unique id : 0000000005 : reason : not equal point
2015-12-21 18:57:20,385 INFO [rnsocketioserviceTcp.cpp : 689] - bnf closed - ip : 127.0.0.1 : unique id : 0000000005

2015-12-21 18:57:20,361 ERROR [ doFuncAffinity.cpp : 271] - HACKING? : not equal point. clientPoint[350] serverPoint[7000]

that cause the dc

if (packet->clientPoint != serverPoint)
{
LOG_ERROR("HACKING? : not equal point. clientPoint[%d] serverPoint[%d]", packet->clientPoint, serverPoint);
ch->m_desc->Close("not equal point");
return;
}

not that difficult to read the log carefully ?

[darklord]

difficult because no affinity editor okey thank you

[ZaTii]

difficult because no affinity editor okey thank you

 

database and export ? or just export as u already edited the db.

[darklord]

I tried but not work

[ZaTii]

I tried but not work

u are donating a item with the count of 2 = 700 points = 1 item = 350, but in database its says that 1 item = 7000. change db or update the client with the lod exported.

[WorldOfWars]

you need to export with export 2015, is really easy and fast...

[darklord]

Solvet pls close tpic..

I change t_affinity_work value.. work

 

thank you all