Samp SQLite script problem.
#1

Oke, more information will follow.

new DB:rtplay;

#endif

public OnGameModeInit()
{
rtplay = db_open("RTPlay.db");
db_free_result(db_query(rtplay, "CREATE TABLE IF NOT EXISTS `players` (`username`, `money`)"));

return 1;
}



public OnPlayerConnect(playerid)
{
new PlayerName[MAX_PLAYER_NAME], check[256], cash[256], player[256], money[256], money_save[256];
new DBResult: result_check, DBResult: result_cash;

GetPlayerName(playerid, PlayerName, sizeof(PlayerName));
format(check, sizeof(check), "SELECT 'username' FROM 'players' WHERE 'username' = '%s'", PlayerName);
result_check = db_query(rtplay, check);

if(!db_num_rows(result_check))
{
format(cash, sizeof(cash), "SELECT 'money' FROM 'players' WHERE 'username' = '%s'", PlayerName);
result_cash = db_query(rtplay, cash);
db_get_field_assoc(result_cash, "money" ,money,256);

format(money_save, sizeof(money_save), "Added: %d Money!", strval(money));

SendClientMessage(playerid, 0xFFFFFFFF, money_save);
SendClientMessage(playerid, 0xFFFFFFFF, "Welcome back!");
}
else{
format(player, sizeof(player), "INSERT INTO 'players' ('username', 'money') VALUES('%s', '%d')", PlayerName, 500);
db_free_result(db_query(rtplay, player));
SendClientMessage(playerid, 0xFFFFFFFF, "Your account have been greated!");
}
db_free_result(result_check);

CarInfo[playerid][CarState] = 1;
return 1;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)