//Includes #include #include //enums enum playerInfo { Eingeloggt, Level } //Globale Variablen new dbhandle; new sInfo[MAX_PLAYERS][playerInfo]; //MySQL #define db_host "127.0.0.1" #define db_user "SAMP" #define db_pass "marvingta1" #define db_db "SAMP" //Forwards forward OnUserCheck(playerid); forward OnPasswordResponse(playerid); //Dialoge #define DIALOG_REGISTER 1 #define DIALOG_LOGIN 2 //Farben #define FARBE_WEISS 0xFFFFFF public OnGameModeInit() { SetGameModeText("Marvin Test"); AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0); //MySQL dbhandle = mysql_connect(db_host,db_user,db_db,db_pass); return 1; } public OnGameModeExit() { mysql_close(dbhandle); return 1; } public OnPlayerRequestClass(playerid, classid) { return 1; } public OnUserCheck(playerid) { new num_rows,num_fields; cache_get_data(num_rows,num_fields,dbhandle); if(num_rows==0) { //register ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Registrierung","Wähle dein gewünschtes Passwort:","Okay","Abbrechen"); } else { //login ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib bitte dein Passwort ein:","Okay","Abbrechen"); } return 1; } public OnPlayerConnect(playerid) { //Login/Register new name[MAX_PLAYER_NAME],query[128]; GetPlayerName(playerid,name,sizeof(name)); format(query,sizeof(query),"SELECT id FROM User WHERE Username='%s'",name); mysql_function_query(dbhandle,query,true,"OnUserCheck","i",playerid); return 1; } public OnPlayerDisconnect(playerid, reason) { return 1; } public OnPlayerSpawn(playerid) { return 1; } public OnPlayerDeath(playerid, killerid, reason) { return 1; } public OnVehicleSpawn(vehicleid) { return 1; } public OnVehicleDeath(vehicleid, killerid) { return 1; } public OnPlayerText(playerid, text[]) { return 1; } public OnPlayerCommandText(playerid, cmdtext[]) { if (strcmp("/mycommand", cmdtext, true, 10) == 0) { // Do something here return 1; } return 0; } public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger) { return 1; } public OnPlayerExitVehicle(playerid, vehicleid) { return 1; } public OnPlayerStateChange(playerid, newstate, oldstate) { return 1; } public OnPlayerEnterCheckpoint(playerid) { return 1; } public OnPlayerLeaveCheckpoint(playerid) { return 1; } public OnPlayerEnterRaceCheckpoint(playerid) { return 1; } public OnPlayerLeaveRaceCheckpoint(playerid) { return 1; } public OnRconCommand(cmd[]) { return 1; } public OnPlayerRequestSpawn(playerid) { return 1; } public OnObjectMoved(objectid) { return 1; } public OnPlayerObjectMoved(playerid, objectid) { return 1; } public OnPlayerPickUpPickup(playerid, pickupid) { return 1; } public OnVehicleMod(playerid, vehicleid, componentid) { return 1; } public OnVehiclePaintjob(playerid, vehicleid, paintjobid) { return 1; } public OnVehicleRespray(playerid, vehicleid, color1, color2) { return 1; } public OnPlayerSelectedMenuRow(playerid, row) { return 1; } public OnPlayerExitedMenu(playerid) { return 1; } public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid) { return 1; } public OnPlayerKeyStateChange(playerid, newkeys, oldkeys) { return 1; } public OnRconLoginAttempt(ip[], password[], success) { return 1; } public OnPlayerUpdate(playerid) { return 1; } public OnPlayerStreamIn(playerid, forplayerid) { return 1; } public OnPlayerStreamOut(playerid, forplayerid) { return 1; } public OnVehicleStreamIn(vehicleid, forplayerid) { return 1; } public OnVehicleStreamOut(vehicleid, forplayerid) { return 1; } public OnPasswordResponse(playerid) { new num_fields,num_rows; cache_get_data(num_rows,num_fields,dbhandle); if(num_fields==1) { //Passwort richtig sInfo[playerid][Eingeloggt] = 1; sInfo[playerid][Level] = cache_get_field_content_int(0,"Level",dbhandle); printf("playerid: %i hat das Level: %",playerid,sInfo[playerid][Level]); } else { //Passwort falsch SendClientMessage(playerid,FARBE_WEISS,"Dein eingegebenes Passwort ist Falsch"); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib bitte dein Passwort ein:","Okay","Abbrechen"); } return 1; } public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { if(dialogid==DIALOG_LOGIN) { if(response) { new name[MAX_PLAYER_NAME],query[128],passwort[100]; GetPlayerName(playerid,name,sizeof(name)); if(strlen(inputtext)>0) { mysql_escape_string(inputtext,passwort,dbhandle); format(query,sizeof(query),"SELECT * FROM User WHERE Username='%s' AND passwort='%s'",name,passwort); mysql_function_query(dbhandle,query,true,"OnPasswordResponse","i",playerid); } else { //keine Eingabe SendClientMessage(playerid,FARBE_WEISS,"Gib bitte dein passwort ein."); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib bitte dein Passwort ein:","Okay","Abbrechen"); } } else { Kick(playerid); } return 1; } if(dialogid==DIALOG_REGISTER) { if(response) { new name[MAX_PLAYER_NAME],query[128],passwort[100]; GetPlayerName(playerid,name,sizeof(name)); if(strlen(inputtext)>5) { //Registrieren mysql_escape_string(inputtext,passwort,dbhandle); format(query,sizeof(query),"INSERT INTO User (Username,Passwort) VALUES ('%s','%S')",name,passwort); mysql_function_query(dbhandle,query,false,"",""); } else { //Zu Kurzes Passwort SendClientMessage(playerid,FARBE_WEISS,"Dein Passwort war zu kurz."); ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Registrierung","Wähle dein gewünschtes Passwort:","Okay","Abbrechen"); } } else { Kick(playerid); } return 1; } return 1; } public OnPlayerClickPlayer(playerid, clickedplayerid, source) { return 1; }