Hi, don't judge me too mutch, i'm new to sourcepawn and i got a problem.
There is a player managment script that i'm creating, it involves SQL database, yet i'm getting an error and after a lot of research and no luck i come here.
The error i'm getting is:
Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
My Code:
PHP Code:
public Show_Vip_SMS(client)
{
//db_connection_settings
new Handle:kv = CreateKeyValues("sql");
KvSetString(kv, "driver", "default");
KvSetString(kv, "host", "localhost");
KvSetString(kv, "port", "3306");
KvSetString(kv, "database", "cache");
KvSetString(kv, "user", "Zylius2");
KvSetString(kv, "pass", "xxxx");
decl String:error[255];
new Handle:hDatabase = SQL_ConnectCustom(kv, error, sizeof(error), true);
CloseHandle(kv);
//db_connection_settings_end
//insert_new_user
if (hDatabase == INVALID_HANDLE)
{
LogError("SQL Connection Failed: %s", error);
return;
}
decl String:query[255];
decl String:gIp[64];
decl String:gName[64];
GetClientIP(client,gIp,sizeof(gIp));
GetClientName( client, gName, MAX_NAME_LENGTH );
Format(query, sizeof(query), "INSERT INTO `cache`.`147` (`IP`, `Nick`) VALUES ('%s', '%s');", gIp, gName);
new Handle:hQuery = SQL_Query(hDatabase, query);
CloseHandle(hQuery);
//insert_new_user_end
//get_his_nick_from_db
new String:Nick[65];
decl String:query2[255];
Format(query2, sizeof(query2), "SELECT FROM `cache`.`147` WHERE IP = '%s'", gIp);
new Handle:hQuery2 = SQL_Query(hDatabase, query2);
while (SQL_FetchRow(hQuery2))
{
SQL_FetchString(hQuery2, 1, Nick, sizeof(Nick))
PrintToChat(client, "Your nick %s", Nick);
}
CloseHandle(hQuery2);
//get_his_nick_from_db_end
}
The Player's info is inserted intho the DB perfectly, thoe i cannot get his Nick name back :/.