stock mysql_GetInttoo(Table[], Field[], Where[], check){
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
format(query, 128, "SELECT %s FROM %s WHERE %s = '%d'", Field, Table, Where, check);
mysql_query(query);
mysql_store_result();
new sqlint = mysql_fetch_int();
mysql_free_result();
return sqlint;
}
public LoadCoupons()
{
for(new i = 0; i < MAX_GUTSCHEINE; i++)
{
Gutschein[i][gOwner] = mysql_GetInttoo("gutscheine", "gOwner", "DatensatzID",i);
Gutschein[i][gCode] = mysql_GetInttoo("gutscheine", "gCode", "DatensatzID",i);
Gutschein[i][gUsed] = mysql_GetInttoo("gutscheine", "gUsed", "DatensatzID",i);
Gutschein[i][gUsedBy] = mysql_GetInttoo("gutscheine", "gUsedBy", "DatensatzID",i);
Gutschein[i][gAktion] = mysql_GetInttoo("gutscheine", "gAktion", "DatensatzID",i);
}
return 1;
}