Beiträge von YoSohai

stock OnCheckFraktionCars()
{
//new query[128];
//format(query,sizeof(query),"SELECT * FROM `fraktioncars`");
mysql_function_query(sqlcon,"SELECT * FROM `fraktioncars`",true,"OnLoadFraktionCars","");
}

public OnLoadFraktionCars()
{
new num_rows, num_fields;
cache_get_data(num_rows, num_fields);
if(!num_rows)return 1;
for(new idx =0; idx < MAX_FRAKCARS; idx ++)
{
new output[32];
cache_get_field_content(0,"SQLid",output);
fInfo[idx][fSQLid] = strval(output);

cache_get_field_content(0,"Model",output);
fInfo[idx][fModelID] = strval(output);

cache_get_field_content(0,"FraktionsID",output);
fInfo[idx][fFrakID] = strval(output);

cache_get_field_content(0,"PosX",output);
fInfo[idx][f_X] = floatstr(output);

cache_get_field_content(0,"PosY",output);
fInfo[idx][f_Y] = floatstr(output);

cache_get_field_content(0,"PosZ",output);
fInfo[idx][f_Z] = floatstr(output);

cache_get_field_content(0,"PosR",output);
fInfo[idx][f_R] = floatstr(output);

cache_get_field_content(0,"Color",output);
fInfo[idx][fColor][0] = strval(output);

cache_get_field_content(0,"Color2",output);
fInfo[idx][fColor][1] = strval(output);

cache_get_field_content(0,"Tank",output);
fInfo[idx][Tank] = strval(output);

cache_get_field_content(0,"UmParken",output);
fInfo[idx][UmParken] = strval(output);
if(fInfo[idx][fModelID] >= 400 && fInfo[idx][fModelID] <= 611)
{
fInfo[idx][fCarid] = CreateVehicle(fInfo[idx][fModelID],fInfo[idx][f_X],fInfo[idx][f_Y],fInfo[idx][f_Z],fInfo[idx][f_R],fInfo[idx][fColor][0],fInfo[idx][fColor][1], -1);
Benzin[fInfo[idx][fCarid]] = fInfo[idx][Tank];
printf("Fahrzeug %d geladen!",idx);
}
}
return 1;
}

public LoadFractionCars()
{
new val[200],query[256], idx;
format(query, sizeof(query), "SELECT * FROM `fraktioncars`");
mysql_query(query);
mysql_store_result();
if(mysql_retrieve_row())
{
mysql_fetch_field_row(val,"Modelid");
FraktionCars[idx][ModelID] = strval(val);

mysql_fetch_field_row(val,"Pos_X");
FraktionCars[idx][POS_X] = strval(val);

mysql_fetch_field_row(val,"Pos_Y");
FraktionCars[idx][POS_Y] = strval(val);

mysql_fetch_field_row(val,"Pos_Z");
FraktionCars[idx][POS_Z] = strval(val);

mysql_fetch_field_row(val,"Pos_A");
FraktionCars[idx][POS_A] = strval(val);

mysql_fetch_field_row(val,"Color1");
FraktionCars[idx][Color1] = strval(val);

mysql_fetch_field_row(val,"Color2");
FraktionCars[idx][Color2] = strval(val);

mysql_fetch_field_row(val,"Frakid");
FraktionCars[idx][FrakID] = strval(val);

mysql_fetch_field_row(val,"Tank");
FraktionCars[idx][Tank] = strval(val);
print("Tank");

mysql_fetch_field_row(val,"Abgeschleppt");
FraktionCars[idx][Abgeschleppt] = strval(val);

mysql_fetch_field_row(val,"Kilometerstand");
FraktionCars[idx][Kilometerstand] = strval(val);
}
mysql_free_result();
if(FraktionCars[idx][ModelID] >= 400 && FraktionCars[idx][ModelID] <= 611)
{
print("ERSTELLT");
FraktionCars[idx][fCarid] = CreateVehicle(FraktionCars[idx][ModelID],FraktionCars[idx][POS_X],FraktionCars[idx][POS_Y],FraktionCars[idx][POS_Z],FraktionCars[idx][POS_A],FraktionCars[idx][Color1],FraktionCars[idx][Color2], -1);
SetVehicleToRespawn(FraktionCars[idx][fCarid]);
FraktionCars[idx][Tank] = Benzin[FraktionCars[idx][fCarid]];
FraktionCars[idx][fLock] = true;
printf("Benzin: %d",Benzin[FraktionCars[idx][fCarid]]);
}
idx++;
}

new query[256];
format(query,sizeof(query),"SELECT `SQLid` FROM `spieler` WHERE `Benutzer`='%s'",PlayerName(playerid));
mysql_query(query);
mysql_store_result();
if(mysql_num_rows()!= 0)gPlayerAccount[playerid] = 1;
else gPlayerAccount[playerid] = 0;
mysql_free_result();

enum TextdrawS {
Text:Top,
Text:Down,
Text:Name,
Text:Welcome,
Text:Auf,
Text:Moto,
Text:Strich,
Text:Login,
Text:Register,
Text:News,
Text:Info
};
new TextDrawInfo[10][TextdrawS];

Bei ongamemodeInite:

for(new i = 0; i > sizeof(TextDrawInfo); i++) {
TextDrawInfo[i][Top] = TextDrawCreate(780.000000, -10.000000, "Oben");
TextDrawBackgroundColor(TextDrawInfo[i][Top], 255);
TextDrawFont(TextDrawInfo[i][Top], 1);
TextDrawLetterSize(TextDrawInfo[i][Top], 0.500000, 13.000000);
TextDrawColor(TextDrawInfo[i][Top], -1);
TextDrawSetOutline(TextDrawInfo[i][Top], 0);
TextDrawSetProportional(TextDrawInfo[i][Top], 1);
TextDrawSetShadow(TextDrawInfo[i][Top], 1);
TextDrawUseBox(TextDrawInfo[i][Top], 1);
TextDrawBoxColor(TextDrawInfo[i][Top], 731);
TextDrawTextSize(TextDrawInfo[i][Top], -61.000000, -12.000000);

TextDrawInfo[i][Down] = TextDrawCreate(780.000000, 320.000000, "Unten");
TextDrawBackgroundColor(TextDrawInfo[i][Down], 255);
TextDrawFont(TextDrawInfo[i][Down], 1);
TextDrawLetterSize(TextDrawInfo[i][Down], 0.500000, 19.000000);
TextDrawColor(TextDrawInfo[i][Down], -1);
TextDrawSetOutline(TextDrawInfo[i][Down], 0);
TextDrawSetProportional(TextDrawInfo[i][Down], 1);
TextDrawSetShadow(TextDrawInfo[i][Down], 1);
TextDrawUseBox(TextDrawInfo[i][Down], 1);
TextDrawBoxColor(TextDrawInfo[i][Down], 187);
TextDrawTextSize(TextDrawInfo[i][Down], -61.000000, -12.000000);

TextDrawInfo[i][Name] = TextDrawCreate(287.000000, 140.000000, "Los Santos - City Roleplay");
TextDrawBackgroundColor(TextDrawInfo[i][Name], 65535);
TextDrawFont(TextDrawInfo[i][Name], 0);
TextDrawLetterSize(TextDrawInfo[i][Name], 0.500000, 2.000000);
TextDrawColor(TextDrawInfo[i][Name], 7602175);
TextDrawSetOutline(TextDrawInfo[i][Name], 1);
TextDrawSetProportional(TextDrawInfo[i][Name], 1);

TextDrawInfo[i][Welcome] = TextDrawCreate(231.000000, 112.000000, "Willkommen");
TextDrawBackgroundColor(TextDrawInfo[i][Welcome], 65535);
TextDrawFont(TextDrawInfo[i][Welcome], 0);
TextDrawLetterSize(TextDrawInfo[i][Welcome], 0.600000, 2.000000);
TextDrawColor(TextDrawInfo[i][Welcome], 7602175);
TextDrawSetOutline(TextDrawInfo[i][Welcome], 1);
TextDrawSetProportional(TextDrawInfo[i][Welcome], 1);

TextDrawInfo[i][Auf] = TextDrawCreate(319.000000, 122.000000, "auf");
TextDrawBackgroundColor(TextDrawInfo[i][Auf], 255);
TextDrawFont(TextDrawInfo[i][Auf], 0);
TextDrawLetterSize(TextDrawInfo[i][Auf], 0.599999, 1.600000);
TextDrawColor(TextDrawInfo[i][Auf], -1);
TextDrawSetOutline(TextDrawInfo[i][Auf], 0);
TextDrawSetProportional(TextDrawInfo[i][Auf], 1);
TextDrawSetShadow(TextDrawInfo[i][Auf], 1);

TextDrawInfo[i][Moto] = TextDrawCreate(321.000000, 164.000000, "WE ARE PURP ROLEPLAY");
TextDrawBackgroundColor(TextDrawInfo[i][Moto], 255);
TextDrawFont(TextDrawInfo[i][Moto], 0);
TextDrawLetterSize(TextDrawInfo[i][Moto], 0.399999, 1.600000);
TextDrawColor(TextDrawInfo[i][Moto], -1);
TextDrawSetOutline(TextDrawInfo[i][Moto], 0);
TextDrawSetProportional(TextDrawInfo[i][Moto], 1);
TextDrawSetShadow(TextDrawInfo[i][Moto], 1);

TextDrawInfo[i][Strich] = TextDrawCreate(204.000000, 32.000000, "l");
TextDrawBackgroundColor(TextDrawInfo[i][Strich], 255);
TextDrawFont(TextDrawInfo[i][Strich], 1);
TextDrawLetterSize(TextDrawInfo[i][Strich], 0.500000, 37.000000);
TextDrawColor(TextDrawInfo[i][Strich], -1);
TextDrawSetOutline(TextDrawInfo[i][Strich], 0);
TextDrawSetProportional(TextDrawInfo[i][Strich], 1);
TextDrawSetShadow(TextDrawInfo[i][Strich], 1);

TextDrawInfo[i][Login] = TextDrawCreate(63.000000, 125.000000, "Einloggen");
TextDrawAlignment(TextDrawInfo[i][Login], 2);
TextDrawBackgroundColor(TextDrawInfo[i][Login], 255);
TextDrawFont(TextDrawInfo[i][Login], 1);
TextDrawLetterSize(TextDrawInfo[i][Login], 0.500000, 2.000000);
TextDrawColor(TextDrawInfo[i][Login], 16711877);
TextDrawSetOutline(TextDrawInfo[i][Login], 0);
TextDrawSetProportional(TextDrawInfo[i][Login], 1);
TextDrawSetShadow(TextDrawInfo[i][Login], 1);
TextDrawSetSelectable(TextDrawInfo[i][Login], 1);

TextDrawInfo[i][Register] = TextDrawCreate(25.000000, 151.000000, "Registrieren");
TextDrawBackgroundColor(TextDrawInfo[i][Register], 255);
TextDrawFont(TextDrawInfo[i][Register], 1);
TextDrawLetterSize(TextDrawInfo[i][Register], 0.500000, 2.000000);
TextDrawColor(TextDrawInfo[i][Register], -16777019);
TextDrawSetOutline(TextDrawInfo[i][Register], 0);
TextDrawSetProportional(TextDrawInfo[i][Register], 1);
TextDrawSetShadow(TextDrawInfo[i][Register], 1);
TextDrawSetSelectable(TextDrawInfo[i][Register], 1);

TextDrawInfo[i][News] = TextDrawCreate(72.000000, 178.000000, "Neuigkeiten");
TextDrawAlignment(TextDrawInfo[i][News], 2);
TextDrawBackgroundColor(TextDrawInfo[i][News], 255);
TextDrawFont(TextDrawInfo[i][News], 1);
TextDrawLetterSize(TextDrawInfo[i][News], 0.500000, 2.000000);
TextDrawColor(TextDrawInfo[i][News], 16711877);
TextDrawSetOutline(TextDrawInfo[i][News], 0);
TextDrawSetProportional(TextDrawInfo[i][News], 1);
TextDrawSetShadow(TextDrawInfo[i][News], 1);
TextDrawSetSelectable(TextDrawInfo[i][News], 1);

TextDrawInfo[i][Info] = TextDrawCreate(67.000000, 202.000000, "Serverinfo");
TextDrawAlignment(TextDrawInfo[i][Info], 2);
TextDrawBackgroundColor(TextDrawInfo[i][Info], 255);
TextDrawFont(TextDrawInfo[i][Info], 1);
TextDrawLetterSize(TextDrawInfo[i][Info], 0.500000, 2.000000);
TextDrawColor(TextDrawInfo[i][Info], 16711877);
TextDrawSetOutline(TextDrawInfo[i][Info], 0);
TextDrawSetProportional(TextDrawInfo[i][Info], 1);
TextDrawSetShadow(TextDrawInfo[i][Info], 1);
TextDrawSetSelectable(TextDrawInfo[i][Info], 1);
}

bei OnPlayerConnect:

for(new i = 0; i > sizeof(TextDrawInfo); i++) {
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Info]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][News]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Register]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Login]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Strich]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Moto]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Auf]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Welcome]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Name]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Down]);
TextDrawShowForPlayer(playerid, TextDrawInfo[i][Top]);
}