Code: Select all
get_user_ip(id, IP, charsmax(IP), 1) get_user_authid(id, AUTH, charsmax(AUTH)) get_user_name(id, NAME, charsmax(NAME)) get_time("%d-%m-%y %H:%M:%S", DATE, charsmax(DATE)) // if more results than 0 if (SQL_MoreResults(query) > 0) { new result_ip[16], result_auth[32], result_name[64] new result_id = SQL_ReadResult(query, 0) SQL_ReadResult(query, 1, result_ip, charsmax(result_ip)) SQL_ReadResult(query, 2, result_name, charsmax(result_name)) SQL_ReadResult(query, 3, result_auth, charsmax(result_auth)) server_print("CORE: recieved %i %s %s %s", result_id, result_ip, result_auth, result_name) if (result_name[id] != NAME[id]) { server_print("CORE: database has found nickname %s and its != %s", result_name[id], NAME[id]) // TODO } /* else if(result_auth[id] != AUTH[id]) { server_print("CORE: client auth is not logged in database") } */ // We have got results SQL_NextRow(query) }
CORE: recieved 2 000.222.52.000 bahh STEAM_0:0:59688539
CORE: database has found nickname EAM_0:0:59688539 and its != hh
2 line outputo fail'as, manau del indexing, realiai turetu buti
CORE: database has found nickname bahh and its != hhab
edit: dar viena nesamone, result_name apkeiciau su result_auth pagaliau gavau name is duomenu bazes, bet keista jeigu pirmam outpute raso pagal kintamaji result_name tikra nick kaip ir turetu, o su salyga sokineja per duomenu bazes columns..
sis kodas veikia, bet ne su tuo kintamuoju su kuriuo turetu, result_auth[id] printina tik 2 paskutinius char'us gautus....
Code: Select all
if (result_auth[id] != NAME[id]) { server_print("CORE: database has found nickname %s and its != %s", result_auth[id], NAME[id]) // TODO }