UserOnline Counter v5095

[mohaga00]

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

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

I wanna calculate how many players are there !

Is there anyTable having field That counting?

How about using this

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

Is it gonna work !?!

What is 2013 datatype used for ?!

Sorry For my English

[Spirited]

Aren't TQ binaries dead? There are so many exploitation tools out there now that completely break the servers. Can't we just let them die?

[mohaga00]

Originally Posted by Spirited

Aren't TQ binaries dead? There are so many exploitation tools out there now that completely break the servers. Can't we just let them die?

No I can't Still Like it !

and thank u

you Made my Day

[Spirited]

Well, I'm just saying. TQ binaries are very illegal to use, people have made multiple tools that actually crash the servers (or something similar). There are all kinds of bots that break gameplay... just let them die already. We don't need TQ Binary servers. Don't you agree?

[mohaga00]

yup !
i was just upset cuz i Was Learning SQL !
But
cuz of u i now Learn C#

as Software Engineer What's ur advice !

to be good Programmer

i Finished Learning basics ! C# , C++ !

Exactly I joined ComputerScience (First year !)