SHARE
TWEET

Untitled

a guest Nov 18th, 2019 89 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Server:CheckPlayerVerified(playerid)
  2. {
  3.     new
  4.         query[90];
  5.  
  6.     SetPlayerCamera(playerid);
  7.  
  8.     mysql_format(m_Handlezero, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '0' LIMIT 1");
  9.     mysql_tquery(m_Handlezero, query, "SQL_CheckPlayerVerified", "i", playerid);
  10.    
  11.     mysql_format(m_Handleone, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '1' LIMIT 1");
  12.     mysql_tquery(m_Handleone, query, "SQL_CheckPlayerVerified", "i", playerid);
  13.    
  14.     mysql_format(m_Handletwo, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '2' LIMIT 1");
  15.     mysql_tquery(m_Handletwo, query, "SQL_CheckPlayerVerified", "i", playerid);
  16.  
  17.     return true;
  18. }
  19.  
  20. Server:SQL_CheckPlayerVerified(playerid)
  21. {
  22.  
  23.     if (cache_num_rows(m_Handlezero) == '1')
  24.     {
  25.     SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but isn't verified. Check {8CF00C}www.sunrise-rp.com {F27373}frequently");
  26.     SendClientMessage(playerid, COLOR_ADM, "{F27373}to know when it's verfiied. For more information, email {8CF00C}admin@sunrise-rp.com");
  27.     KickEx(playerid);
  28.     } elseif (cache_num_rows(m_Handletwo) == '1')
  29.     {
  30.     SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but has been declined.");
  31.     KickEx(playerid);
  32.     } elseif (cache_num_rows(m_Handleone) == '1')
  33.     {
  34.     ShowLoginDialog(playerid, "");
  35.     } else {
  36.     SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account was not found.");
  37.     KickEx(playerid);
  38.     }
  39.     return true;
  40. }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top