Beiträge von Der_Drucker27

savePlayer(playerid)
{
if(sInfo[playerid][eingeloggt]==0)return 1;
//Speichern level,money
new query[256];
format(query,sizeof(query),"UPDATE user SET level='%i',Money='%i',alevel='%i',fraktion='%i',rang='%i',spawnchange='%i',Payday='%i',PaydayTime='%i',rollerschein='%i',autoschein='%i',premiumSys='%i' WHERE id='%i'",sInfo[playerid][level],
GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][rang],sInfo[playerid][spawnchange],sInfo[playerid][Payday],sInfo[playerid][PaydayTime],sInfo[playerid][rollerschein],sInfo[playerid][autoschein],sInfo[playerid][premiumSys],sInfo[playerid][db_id]);
mysql_function_query(dbhandle,query,false,"","");
printf("savePlayer Wurde aufgerufen");
printf("Level = %i, Money = %i,alevel = %i, fraktion=%i, ID %i,Payday='%i',PaydayTime='%i' ",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][alevel],sInfo[playerid][fraktion],sInfo[playerid][db_id],sInfo[playerid][Payday],sInfo[playerid][PaydayTime]);
return 1;
}

public OnPasswordResponse(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,dbhandle);
if(num_rows==1)
{
//passwort richtig
sInfo[playerid][eingeloggt] = 1;
SendClientMessage(playerid,CLGREEN,"Du hast dich erfolgreich eingeloggt");
sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
SetPlayerScore(playerid,sInfo[playerid][level]);


SetPlayerMoney(playerid,cache_get_field_content_int(0,"Money",dbhandle));

sInfo[playerid][alevel] = cache_get_field_content_int(0,"alevel",dbhandle);
sInfo[playerid][rang] = cache_get_field_content_int(0,"rang",dbhandle) ;
sInfo[playerid][fraktion] = cache_get_field_content_int(0,"fraktion",dbhandle) ;
sInfo[playerid][Payday] = cache_get_field_content_int(0,"Payday",dbhandle);
sInfo[playerid][PaydayTime] = cache_get_field_content_int(0,"PaydayTime",dbhandle);
sInfo[playerid][db_id] = cache_get_field_content_int(0,"id",dbhandle);
sInfo[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",dbhandle);
sInfo[playerid][rollerschein] = cache_get_field_content_int(0,"rollerschein",dbhandle);
sInfo[playerid][autoschein] = cache_get_field_content_int(0,"autoschein",dbhandle);
sInfo[playerid][premiumSys] = cache_get_field_content_int(0, "PremSys", dbhandle);
sInfo[playerid][premiumzeit] = cache_get_field_content_int(0, "premiumzeit", dbhandle);

//auslesen aus der datenbank
printf("Es wurden alle Daten geladen");
loadPlayerCars(playerid);
TextDrawHideForPlayer(playerid, Textdraw0);
TextDrawHideForPlayer(playerid, Textdraw1);
TextDrawHideForPlayer(playerid, Textdraw2);
TextDrawHideForPlayer(playerid, Textdraw3);
TextDrawHideForPlayer(playerid, Textdraw3_1);
TextDrawHideForPlayer(playerid, Textdraw4);
TextDrawHideForPlayer(playerid, Textdraw5);
TextDrawHideForPlayer(playerid, Textdraw6);
TextDrawHideForPlayer(playerid, Textdraw7);
TextDrawHideForPlayer(playerid, Textdraw8);
TogglePlayerSpectating(playerid, 0);
CancelSelectTextDraw(playerid);
new query[128];
mysql_escape_string(getPlayerName(playerid), getPlayerName(playerid));
format(query, sizeof(query), "SELECT * FROM gebannt WHERE Name='%s'", getPlayerName(playerid));
mysql_function_query(dbhandle, query, true, "BanCheck", "i", playerid);
SetSpawnInfo(playerid, 0, 0, 861.1640,-1663.8556,13.5469,272.6934,0,0,0,0,0,0);
SpawnPlayer(playerid);
}
else
{
//Passwort falsch
SendClientMessage(playerid,RED,"Das eingegebene Passwort ist falsch!");
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gib bitte dein Passwort ein","Login","Abbruch");

}
return 1;
}

ocmd:setpremium(playerid,params[])
{
new id, days, std, mins, premlevel, sys, premzeit=0;
if(!isAdmin(playerid, 8))return 1; //premlevel //"Benutzung: /setpremium [Name / ID] [Premiumlevel] [Tage] [Stunden] [Minuten]"
if(sscanf(params, "uiiii", id, sys, days, std, mins))return SendClientMessage(playerid, -1, "Benutzung: /setpremium [Name / ID] [0=Onlinezeit | 1=Serverzeit] [Tage] [Stunden] [Minuten]");
if(sInfo[id][premiumzeit] > gettime())premzeit = sInfo[id][premiumzeit] - gettime();
if(sInfo[id][premiumSys]==1&&sys!=1)premzeit=sInfo[id][premiumzeit]-gettime();
else if(sInfo[id][premiumSys]==0&&sys!=0)premzeit=sInfo[id][premiumzeit]+gettime();
sInfo[id][premiumSys]=sys;
new premdays = days * 60 * 60 * 24;
new premstds = std * 60 * 60;
new premmins = mins * 60;
new premgestime = premdays+premstds+premmins;
if(sys==1)
{
if(sInfo[id][premiumzeit] > gettime())premgestime+=premzeit;
premgestime+=gettime();
new string[128];
format(string, sizeof(string) ,"Der Admin %s hat deine Premiumzeit auf %i Tage, %i Stunden und %i Minuten gesetzt/erweitert.", getPlayerName(playerid),days, std, mins);
SendClientMessage(id, -1, string);
format(string, sizeof(string), "Du hast die Premiumzeit des Spielers %s auf %i Tage. %i Stunden und %i Minuten gesetzt/erweitert.", getPlayerName(id), days, std, mins);
SendClientMessage(playerid, -1, string);
}
else
{
if(sInfo[id][premiumzeit] > 0)premgestime+=premzeit;
new string[128];
format(string, sizeof(string) ,"Der Admin %s hat deine Premiumzeit auf %i Tage, %i Stunden und %i Minuten gesetzt/erweitert.", getPlayerName(playerid),days, std, mins);
SendClientMessage(id, -1, string);
format(string, sizeof(string), "Du hast die Premiumzeit des Spielers %s auf %i Tage. %i Stunden und %i Minuten gesetzt/erweitert.", getPlayerName(id), days, std, mins);
SendClientMessage(playerid, -1, string);
}
sInfo[id][premiumzeit] = premgestime;
sInfo[id][premiumlevel] = premlevel;
format(sInfo[id][premiumGivenBy], MAX_PLAYER_NAME, "%s", getPlayerName(playerid));
sInfo[id][premiumGivenTS] = gettime();
return 1;
}