[Help]problem with VIP monsters

05/28/2011 02:18 WolvesMaster#1
hey guys iam here with new problem :D
as i said before that iam working on Candy DB,Client and iam using this code to make autoEPs system in vip maps

Code:
delete from cq_generator where id >= 0113 and id <= 0128;

INSERT INTO `cq_generator` VALUES ('0113', '8900', '0062', '0033', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0114', '8900', '0072', '0037', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0115', '8900', '0081', '0033', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0116', '8900', '0062', '0033', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0121', '8900', '0084', '0118', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0122', '8900', '0098', '0121', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');

INSERT INTO `cq_generator` VALUES ('0117', '8900', '0029', '0072', '0045', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0118', '8900', '0056', '0083', '0045', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0119', '8900', '0071', '0107', '0045', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0120', '8900', '0092', '0098', '0045', '0045', '0010', '0025', '005', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0123', '8900', '0108', '0098', '0045', '0045', '0010', '0025', '0010', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0124', '8900', '0115', '0075', '0045', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0125', '8900', '0087', '0060', '0045', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0126', '8900', '0075', '0057', '0053', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0127', '8900', '0049', '0054', '0053', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0128', '8900', '0030', '0056', '0053', '0045', '0010', '0025', '0036', '21036', '0000', '0000', '0000', '0000', '0000');

delete from cq_generator where id >= 0150 and id <= 0220;
delete from cq_generator where id >= 0160 and id <= 0160;
delete from cq_generator where id >= 0161 and id <= 0161;
delete from cq_generator where id >= 0162 and id <= 0162;
delete from cq_generator where id >= 0163 and id <= 0163;
delete from cq_generator where id >= 0164 and id <= 0164;

INSERT INTO `cq_generator` VALUES ('0150', '1917', '0128', '0092', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0151', '1917', '0107', '0070', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0152', '1917', '0090', '0067', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0153', '1917', '0082', '0084', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0154', '1917', '0093', '0106', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0155', '1917', '0116', '0114', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0156', '1917', '0096', '0053', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0157', '1917', '0088', '0036', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0158', '1917', '0077', '0053', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0159', '1917', '0192', '0231', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0160', '1917', '0208', '0240', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0161', '1917', '0199', '0246', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0162', '1917', '0187', '0238', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0163', '1917', '0198', '0263', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0164', '1917', '0217', '0264', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0201', '1917', '0120', '0115', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0202', '1917', '0130', '0100', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0203', '1917', '0126', '0087', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0204', '1917', '0113', '0069', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0205', '1917', '0103', '0066', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0206', '1917', '0092', '0068', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0207', '1917', '0083', '0090', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0208', '1917', '0083', '0056', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0209', '1917', '0091', '0054', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0210', '1917', '0094', '0044', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0211', '1917', '0198', '0265', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0212', '1917', '0204', '0279', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0213', '1917', '0211', '0276', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0214', '1917', '0216', '0268', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0215', '1917', '0206', '0256', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0216', '1917', '0222', '0253', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0217', '1917', '0199', '0239', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0218', '1917', '0203', '0232', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0219', '1917', '0193', '0228', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0220', '1917', '0191', '0234', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');

INSERT INTO `cq_generator` VALUES ('0165', '1917', '0119', '0196', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0166', '1917', '0091', '0172', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0167', '1917', '0069', '0150', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0168', '1917', '0045', '0125', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0169', '1917', '0025', '0106', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0170', '1917', '0041', '0091', '0023', '0045', '0010', '0025', '0030', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0171', '1917', '0054', '0104', '0023', '0045', '0010', '0025', '0030', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0172', '1917', '0073', '0123', '0023', '0045', '0010', '0025', '0020', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0173', '1917', '0041', '0093', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0174', '1917', '0114', '0164', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0175', '1917', '0133', '0182', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0176', '1917', '0160', '0209', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0177', '1917', '0176', '0217', '0023', '0045', '0010', '0025', '0005', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0178', '1917', '0232', '0239', '0023', '0045', '0010', '0025', '0002', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0179', '1917', '0210', '0214', '0023', '0045', '0010', '0025', '0005', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0180', '1917', '0187', '0191', '0023', '0045', '0010', '0025', '0010', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0181', '1917', '0163', '0168', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0182', '1917', '0136', '0141', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0183', '1917', '0113', '0133', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0184', '1917', '0072', '0101', '0023', '0045', '0010', '0025', '0002', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0185', '1917', '0061', '0073', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0186', '1917', '0064', '0056', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0187', '1917', '0094', '0026', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0188', '1917', '0124', '0124', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0189', '1917', '0160', '0081', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0190', '1917', '0175', '0096', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0191', '1917', '0192', '0113', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0192', '1917', '0213', '0136', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0193', '1917', '0234', '0157', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0194', '1917', '0253', '0177', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0195', '1917', '0271', '0197', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0196', '1917', '0254', '0209', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0197', '1917', '0238', '0226', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0198', '1917', '0187', '0191', '0023', '0045', '0010', '0025', '0010', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0199', '1917', '0223', '0200', '0023', '0045', '0010', '0025', '0015', '21038', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0200', '1917', '0235', '0186', '0023', '0045', '0010', '0025', '0036', '21038', '0000', '0000', '0000', '0000', '0000');

delete from cq_generator where id >= 0221 and id <= 0296;

INSERT INTO `cq_generator` VALUES ('0221', '1918', '0128', '0092', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0222', '1918', '0107', '0070', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0223', '1918', '0090', '0067', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0224', '1918', '0082', '0084', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0225', '1918', '0093', '0106', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0226', '1918', '0116', '0114', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0227', '1918', '0096', '0053', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0228', '1918', '0088', '0036', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0229', '1918', '0077', '0053', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0230', '1918', '0192', '0231', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0231', '1918', '0208', '0240', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0232', '1918', '0199', '0246', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0233', '1918', '0187', '0238', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0234', '1918', '0198', '0263', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0235', '1918', '0217', '0264', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0236', '1918', '0192', '0231', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0237', '1918', '0120', '0115', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0238', '1918', '0130', '0100', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0239', '1918', '0126', '0087', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0240', '1918', '0113', '0069', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0241', '1918', '0103', '0066', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0242', '1918', '0092', '0068', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0243', '1918', '0083', '0090', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0244', '1918', '0083', '0056', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0245', '1918', '0091', '0054', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0246', '1918', '0094', '0044', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0247', '1918', '0198', '0265', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0248', '1918', '0204', '0279', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0249', '1918', '0211', '0276', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0250', '1918', '0216', '0268', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0251', '1918', '0206', '0256', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0252', '1918', '0222', '0253', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0253', '1918', '0199', '0239', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0254', '1918', '0203', '0232', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0255', '1918', '0193', '0228', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0256', '1918', '0191', '0234', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');

INSERT INTO `cq_generator` VALUES ('0257', '1918', '0194', '0273', '0023', '0045', '0010', '0025', '0005', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0258', '1918', '0174', '0253', '0023', '0045', '0010', '0025', '0010', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0259', '1918', '0160', '0240', '0023', '0045', '0010', '0025', '0005', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0260', '1918', '0141', '0222', '0023', '0045', '0010', '0025', '0020', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0261', '1918', '0119', '0196', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0262', '1918', '0091', '0172', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0263', '1918', '0069', '0150', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0264', '1918', '0045', '0125', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0265', '1918', '0025', '0106', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0266', '1918', '0041', '0091', '0023', '0045', '0010', '0025', '0030', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0267', '1918', '0054', '0104', '0023', '0045', '0010', '0025', '0030', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0268', '1918', '0073', '0123', '0023', '0045', '0010', '0025', '0020', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0269', '1918', '0041', '0093', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0270', '1918', '0114', '0164', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0271', '1918', '0133', '0182', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0272', '1918', '0160', '0209', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0273', '1918', '0176', '0217', '0023', '0045', '0010', '0025', '0005', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0274', '1918', '0232', '0239', '0023', '0045', '0010', '0025', '0002', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0275', '1918', '0210', '0214', '0023', '0045', '0010', '0025', '0005', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0276', '1918', '0187', '0191', '0023', '0045', '0010', '0025', '0010', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0277', '1918', '0163', '0168', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0278', '1918', '0136', '0141', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0279', '1918', '0113', '0133', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0280', '1918', '0072', '0101', '0023', '0045', '0010', '0025', '0002', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0281', '1918', '0061', '0073', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0282', '1918', '0064', '0056', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0283', '1918', '0094', '0026', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0284', '1918', '0124', '0124', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0285', '1918', '0160', '0081', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0286', '1918', '0175', '0096', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0287', '1918', '0192', '0113', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0288', '1918', '0213', '0136', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0289', '1918', '0234', '0157', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0290', '1918', '0253', '0177', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0291', '1918', '0271', '0197', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0292', '1918', '0254', '0209', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0293', '1918', '0238', '0226', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0294', '1918', '0187', '0191', '0023', '0045', '0010', '0025', '0010', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0295', '1918', '0223', '0200', '0023', '0045', '0010', '0025', '0015', '21039', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0296', '1918', '0235', '0186', '0023', '0045', '0010', '0025', '0036', '21039', '0000', '0000', '0000', '0000', '0000');

delete from cq_generator where id >= 0129 and id <= 0149;

INSERT INTO `cq_generator` VALUES ('0129', '1902', '0067', '0040', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0131', '1902', '0078', '0041', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0143', '1902', '0085', '0036', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0144', '1902', '0094', '0031', '0001', '0001', '0001', '0025', '0001', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0145', '1902', '0032', '0058', '0001', '0001', '0001', '0025', '0000', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0148', '1902', '0135', '0095', '0001', '0001', '0001', '0025', '0000', '0110', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0149', '1902', '0074', '0038', '0001', '0001', '0001', '0025', '0000', '0110', '0000', '0000', '0000', '0000', '0000');

INSERT INTO `cq_generator` VALUES ('0130', '1902', '0126', '0103', '0053', '0045', '0010', '0025', '0005', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0132', '1902', '0119', '0064', '0053', '0045', '0010', '0025', '0010', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0133', '1902', '0096', '0074', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0134', '1902', '0099', '0102', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0135', '1902', '0116', '0118', '0053', '0045', '0010', '0025', '0010', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0136', '1902', '0092', '0141', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0137', '1902', '0071', '0115', '0053', '0045', '0010', '0025', '0025', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0138', '1902', '0091', '0093', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0139', '1902', '0095', '0046', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0140', '1902', '0076', '0065', '0053', '0045', '0010', '0025', '0013', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0141', '1902', '0062', '0079', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0142', '1902', '0048', '0093', '0053', '0045', '0010', '0025', '0025', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0146', '1902', '0055', '0054', '0053', '0045', '0010', '0025', '0020', '21037', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_generator` VALUES ('0147', '1902', '0076', '0049', '0053', '0045', '0010', '0025', '0022', '21037', '0000', '0000', '0000', '0000', '0000');

delete from cq_monstertype where id >= 21036 and id <= 21039;
delete from cq_action where id >= 0145 and id <= 0152;

INSERT INTO `cq_monstertype` VALUES ('21036', 'VipMonster4', '0277', '0441', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0145', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21036', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21037', 'VipMonster5', '0277', '0551', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0147', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21037', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21038', 'VipMonster6', '0277', '0550', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0149', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21038', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21039', 'VipMonster7', '0277', '0549', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0151', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21039', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `cq_action` VALUES ('0145', '0146', '0000', '1001', '0', 'e_money += MonsterVIP4');
INSERT INTO `cq_action` VALUES ('0146', '0000', '0000', '1010', '2005', 'You found 1000 EudemonPoints from MonsterVIP4');
INSERT INTO `cq_action` VALUES ('0147', '0148', '0000', '1001', '0', 'e_money += MonsterVIP5');
INSERT INTO `cq_action` VALUES ('0148', '0000', '0000', '1010', '2005', 'You found 1500 EudemonPoints from MonsterVIP5!');
INSERT INTO `cq_action` VALUES ('0149', '0150', '0000', '1001', '0', 'e_money += MonsterVIP6');
INSERT INTO `cq_action` VALUES ('0150', '0000', '0000', '1010', '2005', 'You found 2000 EudemonPoints from MonsterVIP6!');
INSERT INTO `cq_action` VALUES ('0151', '0152', '0000', '1001', '0', 'e_money += MonsterVIP7');
INSERT INTO `cq_action` VALUES ('0152', '0000', '0000', '1010', '2005', 'You found 3000 EudemonPoints from MonsterVIP7!');
but when i go there i kill monsters and it tells me under my pic that ''You found 3000 EudemonPoints from MonsterVIP7!'' and in the param too
but i don't get the EPs and when i collect a 2700 EPsCard i get the 2700 EPs in my inventory plz help me
05/28/2011 15:39 alaaemad#2
Use This

Code:
delete from cq_monstertype where id >= 21036 and id <= 21039;
delete from cq_action where id >= 0145 and id <= 0152;

INSERT INTO `cq_monstertype` VALUES ('21036', 'VipMonster4', '0277', '0441', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0145', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21036', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21037', 'VipMonster5', '0277', '0551', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0147', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21037', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21038', 'VipMonster6', '0277', '0550', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0149', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21038', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_monstertype` VALUES ('21039', 'VipMonster7', '0277', '0549', '0', '0', '65535', '00', '3420', '3420', '2134', '0500', '0073', '0000', '0000', '0000', '0000', '0001', '0015', '0000', '1000', '0000', '0110', '32771', '1000', '1000000', '0003', '0151', '0000', '099', '099', '099', '099', '099', '099', '099', '5000', '7000', '0000', '1049', '0000', '0070', '0000', '0639', '1000', '1000', '1500', '21039', '000', '0000000000', '0000000000', '0000000000', '0000000000', '12', '500', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `cq_action` VALUES ('0145', '0146', '0000', '1001', '0', 'e_money += 100');
INSERT INTO `cq_action` VALUES ('0146', '0000', '0000', '1010', '2005', 'You found 100 EudemonPoints from MonsterVip4');
INSERT INTO `cq_action` VALUES ('0147', '0148', '0000', '1001', '0', 'e_money += 150');
INSERT INTO `cq_action` VALUES ('0148', '0000', '0000', '1010', '2005', 'You found 150 EudemonPoints from MonsterVip5!');
INSERT INTO `cq_action` VALUES ('0149', '0150', '0000', '1001', '0', 'e_money += 200');
INSERT INTO `cq_action` VALUES ('0150', '0000', '0000', '1010', '2005', 'You found 200 EudemonPoints from MonsterVip6!');
INSERT INTO `cq_action` VALUES ('0151', '0152', '0000', '1001', '0', 'e_money +=250');
INSERT INTO `cq_action` VALUES ('0152', '0000', '0000', '1010', '2005', 'You found 250 EudemonPoints from MonsterVip7!');
05/28/2011 18:26 WolvesMaster#3
i used ur query and it's still the same problem writing that i get the EPs but no effect any other help ?
05/28/2011 18:43 Jack Sparrow#4
Quote:
Originally Posted by WolvesMaster View Post
i used ur query and it's still the same problem writing that i get the EPs but no effect any other help ?
Have u done a maint after running the query by alaaemad ? because it looks very fine
run it then do a maint or just use this command on your [PM] char
/reloadaction 0
05/29/2011 01:33 WolvesMaster#5
thx all but iam gonna buy a very nice client&DB in 2 days so i hope no more problems :D
05/29/2011 11:27 I Am Murtah#6
Your problem is Server sided, not Client sided :| So a new Client wont fix your problem lol But your problem is this bit,
INSERT INTO `cq_action` VALUES ('0145', '0146', '0000', '1001', '0', 'e_money += MonsterVIP4');
INSERT INTO `cq_action` VALUES ('0146', '0000', '0000', '1010', '2005', 'You found 1000 EudemonPoints from MonsterVIP4');
INSERT INTO `cq_action` VALUES ('0147', '0148', '0000', '1001', '0', 'e_money += MonsterVIP5');
INSERT INTO `cq_action` VALUES ('0148', '0000', '0000', '1010', '2005', 'You found 1500 EudemonPoints from MonsterVIP5!');
INSERT INTO `cq_action` VALUES ('0149', '0150', '0000', '1001', '0', 'e_money += MonsterVIP6');
INSERT INTO `cq_action` VALUES ('0150', '0000', '0000', '1010', '2005', 'You found 2000 EudemonPoints from MonsterVIP6!');
INSERT INTO `cq_action` VALUES ('0151', '0152', '0000', '1001', '0', 'e_money += MonsterVIP7');
INSERT INTO `cq_action` VALUES ('0152', '0000', '0000', '1010', '2005', 'You found 3000 EudemonPoints from MonsterVIP7!');

You need to have 'e_money += MonsterVIP7' And such, as a Number(The amount of Eps) Like, an example would be 'e_money += 3000'
05/29/2011 14:22 WolvesMaster#7
thx bro for ur help it works fine :)