IM SCRIPT GIBT ES DAS MIT MD5:
#include <md5>
cache_get_data(rows,fields);
if(rows)
{
if(passwortstate == 1)
{
cache_get_field_content(0,"Passwort",result);
if(!strcmp(MD5_Hash(pass),result,true))//MD5HASH DA
{
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0);
return 1;
}//PENIS!
format(query,sizeof(query),"{FEFEFE}Dein {009BFF}Account{FEFEFE} wurde in unserer Datenbank, gefunden bitte gebe nun dein Passwort ein und logge dich somit ein.");
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login",query,"Login","Abbrechen");
return 1;
}
stock CreateAccount(playerid)
{
new query[256];
format(query,sizeof(query),"INSERT INTO "#DATENBANKTAG"_account_main (Name,Passwort,Email,Geschlecht) VALUES ('%s','%s','%s','%i')",SpielerName(playerid),MD5_Hash(Spieler[playerid][pPassword]),Spieler[playerid][pEmail],Spieler[playerid][pSex]);//MD5HASH
mysql_function_query(MySqlConnection,query,false,"","");
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name='%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountWeapons","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name='%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountFish","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name='%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountKoffer","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountBlacklists","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountInventar","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountLicenses","i",playerid);
format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid));
mysql_function_query(MySqlConnection,query,true,"LoadAccountBankSafe","i",playerid);
return 1;
}
case _SQL_CHANGEPASSWORT_QUERY:
{
cache_get_data(rows,fields);
if(!rows)
{
SendClientMessage(extraid,GRAU,"Angegebener Spieler ist nicht registriert.");
return 1;
}
format(query,sizeof(query),"Du hast des Passwort von %s zu %s umbenannt!",index,index2);
SendClientMessage(extraid,GELB,query);
format(query,sizeof(query),"UPDATE "#DATENBANKTAG"_account_main SET Passwort='%s' WHERE Name='%s'",MD5_Hash(index2),index);//MD5 HASH
mysql_function_query(MySqlConnection,query,false,"","");
return 1;
}
Kan mir die zeilen jemand schicken wie es aussehen muss ohne md5 ?
weil habe einfach md_5hash rausgezoggen dann auf server geladen xD
dann konnte man sich egal wie einloggen egal was man eingibt^^
