Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. for(new facid = 1; facid < MAX_FACTIONS; facid++)
  2. {
  3. new DBResult:query, string[256];
  4. new fValue[256];
  5. format(string, sizeof(string), "SELECT * FROM `FACTIONS` WHERE `FACTIONID`='%i'", facid);
  6. query = db_query(Factions, string);
  7. db_get_field_assoc(query, "FACTIONBANK", fValue, sizeof(fValue));
  8. FactionInfo[facid][FactionBank] = strval(fValue);
  9. db_get_field_assoc(query, "FTYPE", fValue, sizeof(fValue));
  10. FactionInfo[facid][FactionType] = strval(fValue);
  11. db_get_field_assoc(query, "FPAYCHECK", fValue, sizeof(fValue));
  12. FactionInfo[facid][FactionPay] = strval(fValue);
  13. db_get_field_assoc(query, "RANKS", fValue, sizeof(fValue));
  14. FactionInfo[facid][Ranks] = strval(fValue);
  15. db_get_field_assoc(query, "FMOTD" , fValue, sizeof(fValue));
  16. format(FactionInfo[facid][fMOTD], 256, "%s", fValue);
  17. db_get_field_assoc(query, "FSPAWNINT", fValue, sizeof(fValue));
  18. FactionInfo[facid][FactionSpawnInt] = strval(fValue);
  19. db_get_field_assoc(query, "FSPAWNVIR", fValue, sizeof(fValue));
  20. FactionInfo[facid][FactionSpawnVir] = strval(fValue);
  21. db_get_field_assoc(query, "FSPAWNX", fValue, sizeof(fValue));
  22. FactionInfo[facid][FactionSpawnX] = floatstr(fValue);
  23. db_get_field_assoc(query, "FSPAWNY", fValue, sizeof(fValue));
  24. FactionInfo[facid][FactionSpawnY] = floatstr(fValue);
  25. db_get_field_assoc(query, "FSPAWNZ", fValue, sizeof(fValue));
  26. FactionInfo[facid][FactionSpawnZ] = floatstr(fValue);
  27. db_get_field_assoc(query, "FSKINX", fValue, sizeof(fValue));
  28. FactionInfo[facid][fSkinX] = floatstr(fValue);
  29. db_get_field_assoc(query, "FSKINY", fValue, sizeof(fValue));
  30. FactionInfo[facid][fSkinY] = floatstr(fValue);
  31. db_get_field_assoc(query, "FSKINZ", fValue, sizeof(fValue));
  32. FactionInfo[facid][fSkinZ] = floatstr(fValue);
  33. if(FactionInfo[facid][fSkinX] != 0)
  34. {
  35. FactionInfo[facid][fSkinPickup] = CreateDynamicPickup(1239, 1, FactionInfo[facid][fSkinX], FactionInfo[facid][fSkinY], FactionInfo[facid][fSkinZ], 0, 0);
  36. }
  37. db_free_result(query);
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement