10.10.2012, 08:28
pawn Код:
forward LoadTeritorii();
public LoadTeritorii()
{
new teritorii=0;
for(new idx = 1; idx < 50; idx++)
{
new Query[255];
format(Query, sizeof(Query), "SELECT * FROM teritorii WHERE id= %d",idx);
mysql_query(Query); // Querys the "Query" Variable.
mysql_store_result(); // Stores the result from Query
if(mysql_num_rows()) // Checks if theres anyrow.
if(mysql_fetch_row_format(Query,"|")) // Splits the row
{
sscanf(Query, "p<|>e<is[256]iifffffff>",TeritoriuData[idx]);
teritorii++;
}
new ttext[10];
if(TeritoriuData[idx][tOwned] == 11)
{
ttext = "Sadoveanu";
}
else if(TeritoriuData[idx][tOwned] == 12)
{
ttext = "Capone";
}
else if(TeritoriuData[idx][tOwned] == 13)
{
ttext = "Duduianu";
}
else if(TeritoriuData[idx][tOwned] == 14)
{
ttext = "Corsicanu";
}
else if(TeritoriuData[idx][tOwned] == 15)
{
ttext = "Tobosaru";
}
else if(TeritoriuData[idx][tOwned] == 16)
{
ttext = "Camataru";
}
new string[MAX_STRING];
format(string, sizeof(string), "Acest teritoriu apartine\n {FF0000} Clanului %s",ttext);
//printf("Teritoriu id: %d tId %d tOwner %s tPozZ3 %f",idx,TeritoriuData[idx][tId],TeritoriuData[idx][tOwner],TeritoriuData[idx][tPozZ3]);
CreateDynamicPickup(1239,23,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], -1, -1,-1,100.0);
if(TeritoriuData[idx][tOwned] == 11)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0x40863CFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
else if(TeritoriuData[idx][tOwned] == 12)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0xD900D9FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
else if(TeritoriuData[idx][tOwned] == 13)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0xFD7E00FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
else if(TeritoriuData[idx][tOwned] == 14)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0x6A4444FF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
else if(TeritoriuData[idx][tOwned] == 15)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0x98B1ACFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
else if(TeritoriuData[idx][tOwned] == 16)
{
Turfidd[idx] = CreateDynamic3DTextLabel(string,0x2F2F2FFF,TeritoriuData[idx][tPozX3],TeritoriuData[idx][tPozY3],TeritoriuData[idx][tPozZ3], 20.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
}
}
printf("-Teritorii citite: %d", teritorii);
return 1;
}