Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- A meu:
- forward LoadTurfs();
- public LoadTurfs()
- {
- new
- query[384],
- i;
- format(query, sizeof(query), "UPDATE `turfs` SET `ID` = '%d', `Owned` = '%s', `MinX` = '%.4f', `MinY` = '%.4f', `MaxX` = '%.4f', `MaxY` = '%.4f'",
- TurfInfo[i][zID],
- TurfInfo[i][zOwned],
- TurfInfo[i][zTime],
- TurfInfo[i][zMinX],
- TurfInfo[i][zMinY],
- TurfInfo[i][zMaxX],
- TurfInfo[i][zMaxY]
- );
- return mysql_tquery(g_iHandle, query);
- }
- A lui:
- public LoadTurfs()
- {
- new result[100],index = 0;
- mysql_query(SQL,"SELECT * FROM `turfs` ORDER BY `turfs`.`ID` ASC");
- mysql_store_result();
- while(mysql_retrieve_row())
- {
- index++;
- new i = index;
- mysql_get_field("ID", result); TurfInfo[i][zID] = strval(result);
- mysql_get_field("Owned", result); TurfInfo[i][zOwned] = strval(result);
- mysql_get_field("Time", result); TurfInfo[i][zTime] = strval(result);
- mysql_get_field("MinX", result); TurfInfo[i][zMinX] = floatstr(result);
- mysql_get_field("MinY", result); TurfInfo[i][zMinY] = floatstr(result);
- mysql_get_field("MaxX", result); TurfInfo[i][zMaxX] = floatstr(result);
- mysql_get_field("MaxY", result); TurfInfo[i][zMaxY] = floatstr(result);
- }
- mysql_free_result();
- printf("[MySQL Turfs]: %d", index);
- return 1;
- }
- --
- -- Structura de tabel pentru tabelul `turfs`
- --
- CREATE TABLE `turfs` (
- `ID` int(11) NOT NULL,
- `Owned` int(11) NOT NULL,
- `MinX` float NOT NULL,
- `MinY` float NOT NULL,
- `MaxX` float NOT NULL,
- `MaxY` float NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Salvarea datelor din tabel `turfs`
- --
- INSERT INTO `turfs` (`ID`, `Owned`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
- (1, 6, 114.21, -1364.93, 506.54, -912.91),
- (2, 6, 506.54, -1364.93, 899.25, -912.91),
- (3, 6, 899.25, -1313.7, 1313.58, -912.91),
- (4, 6, 1313.58, -1364.93, 1727.49, -912.91),
- (5, 6, 1727.49, -1364.93, 2108.13, -912.91),
- (6, 5, 2108.13, -1364.93, 2499.38, -912.91),
- (7, 5, 2499.38, -1313.7, 2916.17, -912.91),
- (8, 6, 114.21, -1821.03, 506.54, -1364.93),
- (9, 6, 506.54, -1821.03, 899.25, -1364.93),
- (10, 6, 899.25, -1721.9, 1313.58, -1313.7),
- (11, 6, 1313.58, -1821.03, 1727.49, -1364.93),
- (12, 5, 1727.49, -1821.03, 2108.13, -1364.93),
- (13, 5, 2108.13, -1821.03, 2499.38, -1364.93),
- (14, 5, 2499.38, -1737.65, 2916.17, -1313.7),
- (15, 6, 899.25, -2131.32, 1313.58, -1721.9),
- (16, 6, 899.25, -2489.99, 1313.58, -2131.32),
- (17, 6, 1313.58, -2250.92, 1727.49, -1821.03),
- (18, 5, 1727.49, -2250.92, 2108.13, -1821.03),
- (19, 5, 2108.13, -2250.92, 2499.38, -1821.03),
- (20, 5, 2499.38, -2172.41, 2916.17, -1737.65),
- (21, 5, 1313.58, -2690.47, 1727.49, -2250.92),
- (22, 5, 1727.49, -2690.47, 2108.13, -2250.92),
- (23, 5, 2108.13, -2690.47, 2499.38, -2250.92),
- (24, 5, 2499.38, -2567.91, 2916.17, -2172.41),
- (25, 4, 1114.47, 2444.49, 1478.16, 2901.03),
- (26, 4, 1478.16, 2444.49, 1828.16, 2901.03),
- (27, 4, 2150.16, 2444.49, 2528.16, 2901.03),
- (28, 4, 1828.16, 2444.49, 2150.16, 2901.03),
- (29, 4, 2528.16, 2444.49, 2878.16, 2901.03),
- (30, 4, 901.16, 1980.34, 1307.16, 2444.49),
- (31, 4, 1307.16, 1980.34, 1677.16, 2444.49),
- (32, 4, 1677.16, 1980.34, 2076.16, 2444.49),
- (33, 4, 2076.16, 1980.34, 2482, 2444.49),
- (34, 4, 2482, 1980.34, 2878.16, 2444.49),
- (35, 4, 901.16, 1528.09, 1307.16, 1980.34),
- (36, 4, 1307.16, 1528.09, 1677.16, 1980.34),
- (37, 10, 1677.16, 1528.09, 2076.16, 1980.34),
- (38, 10, 2076.16, 1528.09, 2482, 1980.34),
- (39, 10, 2482, 1528.09, 2878.16, 1980.34),
- (40, 10, 901.16, 1074.9, 1307.16, 1528.09),
- (41, 10, 1307.16, 1074.9, 1677.16, 1528.09),
- (42, 10, 1677.16, 1074.9, 2076.16, 1528.09),
- (43, 10, 2076.16, 1074.9, 2482, 1528.09),
- (44, 10, 2482, 1074.9, 2878.16, 1528.09),
- (45, 10, 1307.16, 663.83, 1677.16, 1074.9),
- (46, 10, 1677.16, 663.83, 2076.16, 1074.9),
- (47, 10, 2076.16, 663.83, 2482, 1074.9),
- (48, 10, 2482, 663.83, 2878.16, 1074.9);
- -- --------------------------------------------------------
- --
- -- Indexes for table `turfs`
- --
- ALTER TABLE `turfs`
- ADD PRIMARY KEY (`ID`);
- --
- -- AUTO_INCREMENT for table `turfs`
- --
- ALTER TABLE `turfs`
- MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
Advertisement
Add Comment
Please, Sign In to add comment