[bogushas]

PHP код:

      mysql_format(dbHandle, g_szBuffer, 120, "SELECT * FROM `"MySQL_PLAYERS_TABLE"` WHERE `pName` = '%s'", getPlayerName(playerid));
      new rows, fields;
    cache_get_data(rows, fields, dbHandle);
      if(rows)
      {
          cache_get_field_content(0, "pPw", player[playerid][pPw], dbHandle, 130);
          loginPlayer(playerid);
      }
      else
      {
          registerPlayer(playerid);
      } 


I think the code should work good but when I connect with the exsisting account I still get register dialog, not login.

[CodeStyle175]

PHP код:

mysql_format(dbHandle,query,sizeof(query),"SELECT pPw FROM "MySQL_PLAYERS_TABLE" WHERE pName='%e' LIMIT 0,1",
GetPlayerName(playerid));
new Cache:cquery=mysql_query(dbHandle,query);
if(cache_num_rows()){
     cache_get_field_content(0, "pPw", player[playerid][pPw], dbHandle, 130); 
     loginPlayer(playerid); 
}else{
     registerPlayer(playerid);
}
cache_delete(cquery);