Beiträge von EinfachMax

stock LoadPlayer(playerid)
{
GetPlayerName(playerid, uInfo[playerid][pName], MAX_PLAYER_NAME);
uInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", uInfo[playerid][pName]);
uInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", uInfo[playerid][pName]);
uInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", uInfo[playerid][pName]);
uInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", uInfo[playerid][pName]);
uInfo[playerid][pLeader] = mysql_GetInt("accounts", "Chef", "Name", uInfo[playerid][pName]);
uInfo[playerid][pMember] = mysql_GetInt("accounts", "Arbeiter", "Name", uInfo[playerid][pName]);
uInfo[playerid][pAdmin] = mysql_GetInt("accounts", "AdminLevel", "Name", uInfo[playerid][pName]);
return 1;
}

stock SavePlayer(playerid)
{
GetPlayerName(playerid, uInfo[playerid][pName], MAX_PLAYER_NAME);
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
mysql_SetInt("accounts", "Level", uInfo[playerid][pLevel], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "Geld", uInfo[playerid][pGeld], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "Kills", uInfo[playerid][pKills], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "Tode", uInfo[playerid][pTode], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "Chef", uInfo[playerid][pLeader], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "Arbeiter", uInfo[playerid][pMember], "Name", uInfo[playerid][pName]);
mysql_SetInt("accounts", "AdminLevel", uInfo[playerid][pAdmin], "Name", uInfo[playerid][pName]);
}
return 1;
}
stock mysql_GetString(Table[], Field[], Where[], Is[])
{
new query[128], Get[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get);
mysql_free_result();
return Get;
}
stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
new sqlint = mysql_fetch_int();
mysql_free_result();
return sqlint;
}
stock mysql_GetFloat(Table[], Field[], Where[], Is[])
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return sqlfloat;
}
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(To, To);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}