Facebook
From Innocent Bat, 4 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 217
  1. public OnPlayerConnect(playerid)
  2. {
  3.     new Cache:result, query[256];
  4.     result = mysql_query(m_sql, sprintf("SELECT COUNT(player_uid) AS total_rows FROM players WHERE player_name = '%s'", PlayerName(playerid)));
  5.        
  6.     if(cache_get_rows() > 0) {
  7.         format(query, sizeof(query), "UPDATE `players` SET `player_name` = '%s', `player_cash` = '%s'", PlayerName(playerid), pInfo[playerid][player_cash]);
  8.     } else {
  9.         format(query, sizeof(query), "INSERT INTO `players` (player_uid, player_name, player_cash) VALUES (null, '%s', '%s')", PlayerName(playerid), pInfo[playerid][player_cash]);
  10.     }
  11.  
  12.     cache_delete(result);
  13.        
  14.         mysql_query(m_sql, query);
  15.        
  16.     return 1;
  17. }