Advertisement
Guest User

MYSQL problem

a guest
May 5th, 2010
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 0.70 KB | None | 0 0
  1. -- ServerSite :
  2. function OnGameModInit()
  3.  
  4. mysql_connect("127.0.0.1","Samp-Server","****","Sa-Mp Datenbank");
  5.  
  6.  
  7.  
  8. end
  9.  
  10. addEventHandler ( "onResourceStart", getRootElement(), OnGameModInit )
  11.  
  12. --Clientsite:
  13. function RegisterMYSQL()
  14. mysql_query("SELECT * FROM `benutzertabelle` WHERE `Serial`='"..getElementData(getLocalPlayer(),"PlayerSerial").."'")
  15.     if(mysql_num_rows() == 0) then
  16.     mysql_free_result();
  17.     mysql_query("INSERT INTO `benutzertabelle` (Serial) VALUES ('"..getElementData(getLocalPlayer(),"PlayerSerial").."')")
  18.     outputChatBox("Check 1")
  19.     else
  20.     mysql_free_result();
  21.     outputChatBox("Du hast an diesem Computer bereits einen Account registriert. \nBitte log dich mit diesen ein!")
  22.     end
  23. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement