Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public OnGameModeInit()
- {
- mysql_debug(1);
- ConnectMySQL();
- DisableInteriorEnterExits();
- AllowInteriorWeapons(true);
- EnableStuntBonusForAll(false);
- AllowAdminTeleport(false);
- SetGameModeText("ParUni 4.0.0");
- AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
- SetTimer("CheckMySQL", 30000, true); // Check MySQL Connection every 30 seconds.
- return 1;
- }
- public OnGameModeExit()
- {
- mysql_close();
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- new Query[200], Pname[24], escpname[24];\
- GetPlayerName(playerid, Pname, 24);
- mysql_real_escape_string(Pname, escpname);
- format(Query, sizeof(Query), "SELECT * FROM `Players` WHERE `user` = '%s'", escpname);
- mysql_query(Query);
- mysql_store_result();
- if(mysql_num_rows() <= 0)
- {
- AccountExists[playerid] = 0; // NOT REGISTERED
- }
- else
- {
- AccountExists[playerid] = 1; //REGISTERED
- }
- mysql_free_result();
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- SaveAccount(playerid);
- LoggedIn[playerid] = 0;
- return 1;
- }
- publicf ConnectMySQL()
- {
- if(mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DB,MYSQL_PASS))
- {
- print("[MySQL] MySQL database successfully loaded.");
- }
- else
- {
- print("[MySQL] MySQL database failed to load.");
- }
- }
- publicf CreateAccount(playername, password[])
- {
- new query[128];
- format(query, sizeof(query), "INSERT INTO Players (Username, Password) VALUES ('%s', '%s')", playername, password);
- mysql_query(query);
- return 1;
- }
- publicf CheckMySQL()
- {
- if(mysql_ping() == -1)
- {
- return 0;
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment