Advertisement
Guest User

Untitled

a guest
Mar 4th, 2020
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.58 KB | None | 0 0
  1. function LoadFactions() {
  2. new result[100],index = 0;
  3. mysql_query(SQL,"SELECT * FROM `factions` ORDER BY `factions`.`ID` ASC");
  4. mysql_store_result();
  5. new label[128];
  6. while(mysql_retrieve_row()) {
  7. index++;
  8. new i = index;
  9. mysql_get_field("ID", result); DynamicFactions[i][fID] = strval(result);
  10. mysql_get_field("Name", result); strmid(DynamicFactions[i][fName], result, 0, 100, 100);
  11. mysql_get_field("IntX", result); DynamicFactions[i][fcX] = floatstr(result);
  12. mysql_get_field("IntY", result); DynamicFactions[i][fcY] = floatstr(result);
  13. mysql_get_field("IntZ", result); DynamicFactions[i][fcZ] = floatstr(result);
  14. mysql_get_field("X", result); DynamicFactions[i][extX] = floatstr(result);
  15. mysql_get_field("Y", result); DynamicFactions[i][extY] = floatstr(result);
  16. mysql_get_field("Z", result); DynamicFactions[i][extZ] = floatstr(result);
  17. mysql_get_field("VW", result); DynamicFactions[i][fVW] = strval(result);
  18. mysql_get_field("Interior", result); DynamicFactions[i][fInterior] = strval(result);
  19. mysql_get_field("Mats", result); DynamicFactions[i][fMats] = strval(result);
  20. mysql_get_field("Drugs", result); DynamicFactions[i][fDrugs] = strval(result);
  21. mysql_get_field("Bank", result); DynamicFactions[i][fBank] = strval(result);
  22. mysql_get_field("Anunt", result); strmid(DynamicFactions[i][fAnn], result, 0, 100, 100);
  23. mysql_get_field("App", result); DynamicFactions[i][fApp] = strval(result);
  24. mysql_get_field("Lock", result); DynamicFactions[i][fLock] = strval(result);
  25.  
  26. mysql_get_field("Name1", result); strmid(fRankNames[i][0], result, 0, 100, 100);
  27. mysql_get_field("Name2", result); strmid(fRankNames[i][1], result, 0, 100, 100);
  28. mysql_get_field("Name3", result); strmid(fRankNames[i][2], result, 0, 100, 100);
  29. mysql_get_field("Name4", result); strmid(fRankNames[i][3], result, 0, 100, 100);
  30. mysql_get_field("Name5", result); strmid(fRankNames[i][4], result, 0, 100, 100);
  31. mysql_get_field("Name6", result); strmid(fRankNames[i][5], result, 0, 100, 100);
  32. mysql_get_field("Name7", result); strmid(fRankNames[i][6], result, 0, 100, 100);
  33.  
  34. new x = i;
  35.  
  36. if(DynamicFactions[i][fLock] == 0) format(label, sizeof(label), "%s's HQ\n(locked)", DynamicFactions[i][fName]);
  37. else format(label, sizeof(label), "%s's HQ\n(unlocked)", DynamicFactions[i][fName]);
  38. DynamicFactions[i][fLabel] = Create3DTextLabel(label,-1,DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],20.0, 0, 1);
  39.  
  40. if(x == 1 || x == 2 || x == 3) CreatePickup(1247, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
  41. else if(x == 4 || x == 5 || x == 6 || x == 10) CreatePickup(1313, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
  42. else CreatePickup(1314, 23, DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ]);
  43.  
  44.  
  45. if(x == 4) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],62,0,0,0,-1,500.0);
  46. if(x == 5) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],58,0,0,0,-1,500.0);
  47. if(x == 6) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],60,0,0,0,-1,500.0);
  48. if(x == 10) CreateDynamicMapIcon(DynamicFactions[x][extX], DynamicFactions[x][extY], DynamicFactions[x][extZ],59,0,0,0,-1,500.0);
  49. }
  50. mysql_free_result();
  51. printf("[LOADING] %d factions", index);
  52. return 1;
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement