14.12.2016, 20:16
PHP код:
forward LoadRooftop();
public LoadRooftop()
{
queryresult = db_query(Database, "SELECT * FROM `ROOFTOP`");
new count = db_num_rows(queryresult);
if(count > 0)
{
new id, ftd[30];
for (new x=0; x<count; x++)
{
db_get_field_assoc(queryresult, "RID", ftd, 26);
id = strval(ftd);
db_get_field_assoc(queryresult, "EnterX", ftd, 30);
Rooftop[id][EnterPos][0] = floatstr(ftd);
db_get_field_assoc(queryresult, "EnterY", ftd, 30);
Rooftop[id][EnterPos][1] = floatstr(ftd);
db_get_field_assoc(queryresult, "EnterZ", ftd, 30);
Rooftop[id][EnterPos][2] = floatstr(ftd);
db_get_field_assoc(queryresult, "ExitX", ftd, 30);
Rooftop[id][TelePos][0] = floatstr(ftd);
db_get_field_assoc(queryresult, "ExitY", ftd, 30);
Rooftop[id][TelePos][1] = floatstr(ftd);
db_get_field_assoc(queryresult, "ExitZ", ftd, 30);
Rooftop[id][TelePos][2] = floatstr(ftd);
Rooftop[id][checkpointidx][0] = CreateDynamicCP(Rooftop[id][EnterPos][0], Rooftop[id][EnterPos][1], Rooftop[id][EnterPos][2], 1.5, 0, -1, -1, 50.0);
Rooftop[id][checkpointidx][1] = CreateDynamicCP(Rooftop[id][TelePos][0], Rooftop[id][TelePos][1], Rooftop[id][TelePos][2], 1.5, 0, -1, -1, 50.0);
Rooftop[id][textid][0] = CreateDynamic3DTextLabel("[ROOFTOP]", COLOR_VIP, Rooftop[id][EnterPos][0], Rooftop[id][EnterPos][1], Rooftop[id][EnterPos][2], 15.0);
Rooftop[id][textid][1] = CreateDynamic3DTextLabel("[Exit]", COLOR_VIP, Rooftop[id][TelePos][0], Rooftop[id][TelePos][1], Rooftop[id][TelePos][2], 15.0);
db_next_row(queryresult);
}
}
roofid = count;
new string[60];
format(string,sizeof(string),"%d rooftop loaded.", count);
printf(string);
db_free_result(queryresult);
return 1;
}