Crate Error :!
#3

Quote:
Originally Posted by EiresJason
View Post
Try this:
pawn Code:
#define         MAX_CRATES                  50
enum crateInfo
{
    crActive,
    crObject,
    Float: crX,
    Float: crY,
    Float: crZ,
    GunQuantity,
    InVehicle,
    Text3D: crLabel,
}

new CrateInfo[MAX_CRATES][crateInfo];
Error in gameserver:
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 Crate in Database
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;
Reply


Messages In This Thread
Crate Error :! - by nguyenquynh - 06.10.2013, 13:38
Re: Crate Error :! - by EiresJason - 06.10.2013, 13:42
Re: Crate Error :! - by nguyenquynh - 06.10.2013, 13:46
Re: Crate Error :! - by EiresJason - 06.10.2013, 13:51
Re: Crate Error :! - by nguyenquynh - 06.10.2013, 13:57
Re: Crate Error :! - by EiresJason - 06.10.2013, 14:07
Re: Crate Error :! - by nguyenquynh - 06.10.2013, 15:02
Re: Crate Error :! - by EiresJason - 06.10.2013, 15:16

Forum Jump:


Users browsing this thread: 2 Guest(s)