Custura

Untitled

Apr 8th, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.12 KB | None | 0 0
  1. A meu:
  2. forward LoadTurfs();
  3. public LoadTurfs()
  4. {
  5. new
  6. query[384],
  7. i;
  8.  
  9. format(query, sizeof(query), "UPDATE `turfs` SET `ID` = '%d', `Owned` = '%s', `MinX` = '%.4f', `MinY` = '%.4f', `MaxX` = '%.4f', `MaxY` = '%.4f'",
  10. TurfInfo[i][zID],
  11. TurfInfo[i][zOwned],
  12. TurfInfo[i][zTime],
  13. TurfInfo[i][zMinX],
  14. TurfInfo[i][zMinY],
  15. TurfInfo[i][zMaxX],
  16. TurfInfo[i][zMaxY]
  17. );
  18. return mysql_tquery(g_iHandle, query);
  19. }
  20.  
  21. A lui:
  22. public LoadTurfs()
  23. {
  24. new result[100],index = 0;
  25. mysql_query(SQL,"SELECT * FROM `turfs` ORDER BY `turfs`.`ID` ASC");
  26. mysql_store_result();
  27. while(mysql_retrieve_row())
  28. {
  29. index++;
  30. new i = index;
  31. mysql_get_field("ID", result); TurfInfo[i][zID] = strval(result);
  32. mysql_get_field("Owned", result); TurfInfo[i][zOwned] = strval(result);
  33. mysql_get_field("Time", result); TurfInfo[i][zTime] = strval(result);
  34. mysql_get_field("MinX", result); TurfInfo[i][zMinX] = floatstr(result);
  35. mysql_get_field("MinY", result); TurfInfo[i][zMinY] = floatstr(result);
  36. mysql_get_field("MaxX", result); TurfInfo[i][zMaxX] = floatstr(result);
  37. mysql_get_field("MaxY", result); TurfInfo[i][zMaxY] = floatstr(result);
  38. }
  39. mysql_free_result();
  40. printf("[MySQL Turfs]: %d", index);
  41. return 1;
  42. }
  43.  
  44.  
  45. --
  46. -- Structura de tabel pentru tabelul `turfs`
  47. --
  48.  
  49. CREATE TABLE `turfs` (
  50. `ID` int(11) NOT NULL,
  51. `Owned` int(11) NOT NULL,
  52. `MinX` float NOT NULL,
  53. `MinY` float NOT NULL,
  54. `MaxX` float NOT NULL,
  55. `MaxY` float NOT NULL
  56. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  57.  
  58. --
  59. -- Salvarea datelor din tabel `turfs`
  60. --
  61.  
  62. INSERT INTO `turfs` (`ID`, `Owned`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
  63. (1, 6, 114.21, -1364.93, 506.54, -912.91),
  64. (2, 6, 506.54, -1364.93, 899.25, -912.91),
  65. (3, 6, 899.25, -1313.7, 1313.58, -912.91),
  66. (4, 6, 1313.58, -1364.93, 1727.49, -912.91),
  67. (5, 6, 1727.49, -1364.93, 2108.13, -912.91),
  68. (6, 5, 2108.13, -1364.93, 2499.38, -912.91),
  69. (7, 5, 2499.38, -1313.7, 2916.17, -912.91),
  70. (8, 6, 114.21, -1821.03, 506.54, -1364.93),
  71. (9, 6, 506.54, -1821.03, 899.25, -1364.93),
  72. (10, 6, 899.25, -1721.9, 1313.58, -1313.7),
  73. (11, 6, 1313.58, -1821.03, 1727.49, -1364.93),
  74. (12, 5, 1727.49, -1821.03, 2108.13, -1364.93),
  75. (13, 5, 2108.13, -1821.03, 2499.38, -1364.93),
  76. (14, 5, 2499.38, -1737.65, 2916.17, -1313.7),
  77. (15, 6, 899.25, -2131.32, 1313.58, -1721.9),
  78. (16, 6, 899.25, -2489.99, 1313.58, -2131.32),
  79. (17, 6, 1313.58, -2250.92, 1727.49, -1821.03),
  80. (18, 5, 1727.49, -2250.92, 2108.13, -1821.03),
  81. (19, 5, 2108.13, -2250.92, 2499.38, -1821.03),
  82. (20, 5, 2499.38, -2172.41, 2916.17, -1737.65),
  83. (21, 5, 1313.58, -2690.47, 1727.49, -2250.92),
  84. (22, 5, 1727.49, -2690.47, 2108.13, -2250.92),
  85. (23, 5, 2108.13, -2690.47, 2499.38, -2250.92),
  86. (24, 5, 2499.38, -2567.91, 2916.17, -2172.41),
  87. (25, 4, 1114.47, 2444.49, 1478.16, 2901.03),
  88. (26, 4, 1478.16, 2444.49, 1828.16, 2901.03),
  89. (27, 4, 2150.16, 2444.49, 2528.16, 2901.03),
  90. (28, 4, 1828.16, 2444.49, 2150.16, 2901.03),
  91. (29, 4, 2528.16, 2444.49, 2878.16, 2901.03),
  92. (30, 4, 901.16, 1980.34, 1307.16, 2444.49),
  93. (31, 4, 1307.16, 1980.34, 1677.16, 2444.49),
  94. (32, 4, 1677.16, 1980.34, 2076.16, 2444.49),
  95. (33, 4, 2076.16, 1980.34, 2482, 2444.49),
  96. (34, 4, 2482, 1980.34, 2878.16, 2444.49),
  97. (35, 4, 901.16, 1528.09, 1307.16, 1980.34),
  98. (36, 4, 1307.16, 1528.09, 1677.16, 1980.34),
  99. (37, 10, 1677.16, 1528.09, 2076.16, 1980.34),
  100. (38, 10, 2076.16, 1528.09, 2482, 1980.34),
  101. (39, 10, 2482, 1528.09, 2878.16, 1980.34),
  102. (40, 10, 901.16, 1074.9, 1307.16, 1528.09),
  103. (41, 10, 1307.16, 1074.9, 1677.16, 1528.09),
  104. (42, 10, 1677.16, 1074.9, 2076.16, 1528.09),
  105. (43, 10, 2076.16, 1074.9, 2482, 1528.09),
  106. (44, 10, 2482, 1074.9, 2878.16, 1528.09),
  107. (45, 10, 1307.16, 663.83, 1677.16, 1074.9),
  108. (46, 10, 1677.16, 663.83, 2076.16, 1074.9),
  109. (47, 10, 2076.16, 663.83, 2482, 1074.9),
  110. (48, 10, 2482, 663.83, 2878.16, 1074.9);
  111.  
  112. -- --------------------------------------------------------
  113.  
  114.  
  115. --
  116. -- Indexes for table `turfs`
  117. --
  118. ALTER TABLE `turfs`
  119. ADD PRIMARY KEY (`ID`);
  120.  
  121. --
  122. -- AUTO_INCREMENT for table `turfs`
  123. --
  124. ALTER TABLE `turfs`
  125. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
Advertisement
Add Comment
Please, Sign In to add comment