06.10.2013, 13:46
Quote:
Try this:
pawn Code:
|
Code:
[20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 0 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 1 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 2 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 3 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 4 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 5 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 6 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 7 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 8 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 9 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 10 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 11 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 12 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 13 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 14 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 15 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 16 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 17 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 18 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '65535' WHERE id = 19 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 20 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 21 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 22 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 23 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 24 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 25 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 26 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 27 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 28 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 29 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 30 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 31 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 32 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 33 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 34 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 35 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 36 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 37 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 38 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 39 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 40 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 41 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 42 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 43 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 44 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 45 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 46 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 47 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 48 [20:52:31] UPDATE `crates` SET `Active` = '0', `CrateX` = '0.00', `CrateY` = '0.00', `CrateZ` = '0.00', `GunQuantity` = '0', `InVehicle` = '0' WHERE id = 49
Code:
-- ---------------------------- -- Table structure for crates -- ---------------------------- DROP TABLE IF EXISTS `crates`; CREATE TABLE `crates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Active` int(11) NOT NULL DEFAULT '0', `CrateX` float NOT NULL DEFAULT '0', `CrateY` float NOT NULL DEFAULT '0', `CrateZ` float NOT NULL DEFAULT '0', `GunQuantity` int(11) NOT NULL DEFAULT '50', `InVehicle` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;