Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Server:CheckPlayerVerified(playerid)
- {
- new
- query[90];
- SetPlayerCamera(playerid);
- mysql_format(m_Handlezero, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '0' LIMIT 1");
- mysql_tquery(m_Handlezero, query, "SQL_CheckPlayerVerified", "i", playerid);
- mysql_format(m_Handleone, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '1' LIMIT 1");
- mysql_tquery(m_Handleone, query, "SQL_CheckPlayerVerified", "i", playerid);
- mysql_format(m_Handletwo, query, sizeof(query), "SELECT id FROM players WHERE Name = '%e' AND verified = '2' LIMIT 1");
- mysql_tquery(m_Handletwo, query, "SQL_CheckPlayerVerified", "i", playerid);
- return true;
- }
- Server:SQL_CheckPlayerVerified(playerid)
- {
- if (cache_num_rows(m_Handlezero) == '1')
- {
- SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but isn't verified. Check {8CF00C}www.sunrise-rp.com {F27373}frequently");
- SendClientMessage(playerid, COLOR_ADM, "{F27373}to know when it's verfiied. For more information, email {8CF00C}admin@sunrise-rp.com");
- KickEx(playerid);
- } elseif (cache_num_rows(m_Handletwo) == '1')
- {
- SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account exists in our database but has been declined.");
- KickEx(playerid);
- } elseif (cache_num_rows(m_Handleone) == '1')
- {
- ShowLoginDialog(playerid, "");
- } else {
- SendClientMessage(playerid, COLOR_ADM, "{F27373}Your account was not found.");
- KickEx(playerid);
- }
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement