UserOnline Counter v5095

-- ----------------------------
-- 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;

-- ----------------------------

INSERT INTO `cq_action` VALUES ('96542208', '96542209', '0000', '0127', '0', 'IF ((SELECT COUNT(*) FROM user_online) =30)');