Code:
-- ---------------------------- -- Timer for Useronline list for binaries -- ---------------------------- INSERT INTO `cq_action` VALUES ('96542199', '96542200', '0000', '2013', '0', '1002 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542200', '96542201', '0000', '2013', '0', '1000 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542201', '96542202', '0000', '2013', '0', '1005 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542202', '96542203', '0000', '2013', '0', '1015 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542203', '96542204', '0000', '2013', '0', '1038 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542204', '96542205', '0000', '2013', '0', '1039 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542205', '96542206', '0000', '2013', '0', '6000 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542206', '96542207', '0000', '2013', '0', '1020 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542207', '0000', '0000', '2013', '0', '%user_map_id 96542208 -1'); INSERT INTO `cq_action` VALUES ('96542208', '96542209', '0000', '0127', '0', 'DELETE FROM user_online WHERE user_id =\"%user_id\"'); INSERT INTO `cq_action` VALUES ('96542209', '0000', '0000', '0127', '0', 'INSERT INTO user_online set name=\"%user_name\",level=\"%user_lev\",user_id=\"%user_id\",time=\"%iter_time\"'); INSERT INTO `cq_task` VALUES ('96542199', '96542199', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542200', '96542200', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542201', '96542201', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542202', '96542202', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542203', '96542203', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542204', '96542204', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542205', '96542205', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542206', '96542206', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542207', '96542207', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542208', '96542208', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); INSERT INTO `cq_task` VALUES ('96542209', '96542209', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0'); -- -------------------------- -- ---------------------------- -- Creating Table for Players to be stored -- ---------------------------- DROP TABLE IF EXISTS `user_online`; CREATE TABLE `user_online` ( `user_id` bigint(20) NOT NULL default '0', `time` varchar(20) NOT NULL default '', `rows` int(10) unsigned zerofill NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `level` int(3) NOT NULL default '0', PRIMARY KEY (`rows`) ) TYPE=MyISAM; -- ----------------------------
Is there anyTable having field That counting?
How about using this
Code:
INSERT INTO `cq_action` VALUES ('96542208', '96542209', '0000', '0127', '0', 'IF ((SELECT COUNT(*) FROM user_online) =30)');
What is 2013 datatype used for ?!
Sorry For my English