Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function LoadFactions() {
- new result[100],index = 0;
- mysql_query(SQL,"SELECT * FROM `factions` ORDER BY `factions`.`ID` ASC");
- mysql_store_result();
- new label[128];
- while(mysql_retrieve_row()) {
- index++;
- new i = index;
- mysql_get_field("ID", result); DynamicFactions[i][fID] = strval(result);
- mysql_get_field("Name", result); strmid(DynamicFactions[i][fName], result, 0, 100, 100);
- mysql_get_field("IntX", result); DynamicFactions[i][fcX] = floatstr(result);
- mysql_get_field("IntY", result); DynamicFactions[i][fcY] = floatstr(result);
- mysql_get_field("IntZ", result); DynamicFactions[i][fcZ] = floatstr(result);
- mysql_get_field("X", result); DynamicFactions[i][extX] = floatstr(result);
- mysql_get_field("Y", result); DynamicFactions[i][extY] = floatstr(result);
- mysql_get_field("Z", result); DynamicFactions[i][extZ] = floatstr(result);
- mysql_get_field("VW", result); DynamicFactions[i][fVW] = strval(result);
- mysql_get_field("Interior", result); DynamicFactions[i][fInterior] = strval(result);
- mysql_get_field("Mats", result); DynamicFactions[i][fMats] = strval(result);
- mysql_get_field("Drugs", result); DynamicFactions[i][fDrugs] = strval(result);
- mysql_get_field("Bank", result); DynamicFactions[i][fBank] = strval(result);
- mysql_get_field("Anunt", result); strmid(DynamicFactions[i][fAnn], result, 0, 100, 100);
- mysql_get_field("App", result); DynamicFactions[i][fApp] = strval(result);
- mysql_get_field("Lock", result); DynamicFactions[i][fLock] = strval(result);
- mysql_get_field("Name1", result); strmid(fRankNames[i][0], result, 0, 100, 100);
- mysql_get_field("Name2", result); strmid(fRankNames[i][1], result, 0, 100, 100);
- mysql_get_field("Name3", result); strmid(fRankNames[i][2], result, 0, 100, 100);
- mysql_get_field("Name4", result); strmid(fRankNames[i][3], result, 0, 100, 100);
- mysql_get_field("Name5", result); strmid(fRankNames[i][4], result, 0, 100, 100);
- mysql_get_field("Name6", result); strmid(fRankNames[i][5], result, 0, 100, 100);
- mysql_get_field("Name7", result); strmid(fRankNames[i][6], result, 0, 100, 100);
- new x = i;
- if(DynamicFactions[i][fLock] == 0) format(label, sizeof(label), "%s's HQ\n(locked)", DynamicFactions[i][fName]);
- else format(label, sizeof(label), "%s's HQ\n(unlocked)", DynamicFactions[i][fName]);
- DynamicFactions[i][fLabel] = Create3DTextLabel(label,-1,DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],20.0, 0, 1);
- if(x == 1 || x == 2 || x == 3) CreatePickup(1247, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
- else if(x == 4 || x == 5 || x == 6 || x == 10) CreatePickup(1313, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
- else CreatePickup(1314, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
- if(x == 4) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],62,0,0,0,-1,500.0);
- if(x == 5) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],58,0,0,0,-1,500.0);
- if(x == 6) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],60,0,0,0,-1,500.0);
- if(x == 10) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],59,0,0,0,-1,500.0);
- }
- mysql_free_result();
- printf("[LOADING] %d factions", index);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement