OK well first off, this is a part of the code put into a plugin. Does anyone know WHY it won't work? And how to fix it?
Code:
{
// Set 'username' in mYSQL
new uName[64], uSteam[64], uQuery[256], uQuery_2[256]
get_user_name(id, uName, 63)
get_user_authid(id, uSteam, 63)
format(uQuery,255,"SELECT username FROM money WHERE steamid='%s'", uSteam)
result = dbi_query(dbc, uQuery)
if( result == RESULT_NONE ) {
server_print( "[Bleh] No Username Found In mySQL!" )
server_print( "[Bleh] Debug Info: uName: %s - uSteam: %s", uName, uSteam )
} else if( result <= RESULT_FAILED ) {
server_print( "[Bleh] Setting Username In mySQL . . . FAILED !" )
server_print( "[Bleh] Debug Info: uName: %s - uSteam: %s", uName, uSteam )
} else {
format(uQuery_2,255,"UPDATE money SET username='%' WHERE steamid='%'", uName, uSteam)
result = dbi_query(dbc, uQuery_2)
server_print( "[Bleh] Setting Username In mySQL. . . COMPLETE!" )
server_print( "[Bleh] Debug Info: uName: %s - uSteam: %s", uName, uSteam )
}
dbi_free_result(result)
return PLUGIN_HANDLED
}
}
Any ideas?