Advertisement
Guest User

Untitled

a guest
Dec 14th, 2018
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. function LoadBizz() {
  2. new result[100],index = 0;
  3. mysql_query(SQL,"SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
  4. mysql_store_result();
  5. while(mysql_retrieve_row())
  6. {
  7. bussines++;
  8. index++;
  9. new i = index;
  10. mysql_get_field("ID", result); BizzInfo[i][bID] = strval(result);
  11. mysql_get_field("Owned", result); BizzInfo[i][bOwned] = strval(result);
  12. mysql_get_field("Owner", result); strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
  13. mysql_get_field("Message", result); strmid(BizzInfo[i][bMessage], result, 0, 100, 100);
  14. mysql_get_field("EntranceX", result); BizzInfo[i][bEntranceX] = floatstr(result);
  15. mysql_get_field("EntranceY", result); BizzInfo[i][bEntranceY] = floatstr(result);
  16. mysql_get_field("EntranceZ", result); BizzInfo[i][bEntranceZ] = floatstr(result);
  17. mysql_get_field("ExitX", result); BizzInfo[i][bExitX] = floatstr(result);
  18. mysql_get_field("ExitY", result); BizzInfo[i][bExitY] = floatstr(result);
  19. mysql_get_field("ExitZ", result); BizzInfo[i][bExitZ] = floatstr(result);
  20. mysql_get_field("LevelNeeded", result); BizzInfo[i][bLevelNeeded] = strval(result);
  21. mysql_get_field("BuyPrice", result); BizzInfo[i][bBuyPrice] = strval(result);
  22. mysql_get_field("EntranceCost", result); BizzInfo[i][bEntranceCost] = strval(result);
  23. mysql_get_field("Till", result); BizzInfo[i][bTill] = strval(result);
  24. mysql_get_field("Locked", result); BizzInfo[i][bLocked] = strval(result);
  25. mysql_get_field("Interior", result); BizzInfo[i][bInterior] = strval(result);
  26. mysql_get_field("Products", result); BizzInfo[i][bProducts] = strval(result);
  27. mysql_get_field("MaxProducts", result); BizzInfo[i][bMaxProducts] = strval(result);
  28. mysql_get_field("PriceProd", result); BizzInfo[i][bPriceProd] = strval(result);
  29. mysql_get_field("Virtual", result); BizzInfo[i][bVirtual] = strval(result);
  30. mysql_get_field("Radio", result); BizzInfo[i][bRadio] = strval(result);
  31. }
  32. mysql_free_result();
  33. printf("Bussines: %d", index);
  34. return 1;
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement