Trinitycore 3.3.5 Fake Online Players in Who list Patch

[Apple]

Hmm... Everything applied fine using patch -p1 < patchname.patch... Compiled fine... I can see 49 fake players, but their names appear as numbers, and their 'class' returns unknown. Did you test this b4 releasing it?

if someone can fix this script without any editing then it will be awesome
but for temporary fix or you can say to make it working with current script's layout you will need to do following steps

Go to src/server/game/Entities/Player/Player.cpp
Find Line
CharacterDatabase.PExecute("UPDATE characters_fake SET zone = (FLOOR(50 * RAND()) + 1) WHERE online>1");
& Replace with
CharacterDatabase.PExecute("UPDATE characters_fake SET gender = (FLOOR(50 * RAND()) + 1) WHERE online>1");

then

Find line
CharacterDatabase.PExecute("UPDATE characters_fake SET level=level+1 WHERE online>1 AND level<5");
& Replace with
CharacterDatabase.PExecute("UPDATE characters_fake SET zone=zone+1 WHERE online>1 AND level<5");

& then you will need to execute this query in characters db, which has some with some annoying structure

SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for `characters_fake`
-- ----------------------------
DROP TABLE IF EXISTS `characters_fake`;
CREATE TABLE `characters_fake` (
  `race` varchar(36) NOT NULL,
  `name` mediumint(3) NOT NULL DEFAULT '0',
  `class` mediumint(3) NOT NULL DEFAULT '0',
  `level` mediumint(3) NOT NULL DEFAULT '0',
  `gender` mediumint(9) NOT NULL DEFAULT '0',
  `zone` mediumint(3) NOT NULL DEFAULT '0',
  `online` mediumint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`race`,`name`,`class`,`level`,`gender`,`zone`,`online`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of characters_fake
-- ----------------------------


INSERT INTO `characters_fake` VALUES ('Seventeem', '5', '9', '8', '39', '80', '2');
INSERT INTO `characters_fake` VALUES ('Siwftkim', '3', '7', '5', '6', '80', '2');
INSERT INTO `characters_fake` VALUES ('Stdchrtd', '8', '9', '2', '46', '80', '2');
INSERT INTO `characters_fake` VALUES ('Thefreakz', '8', '8', '8', '7', '80', '2');
INSERT INTO `characters_fake` VALUES ('Treaex', '5', '7', '2', '29', '80', '2');
INSERT INTO `characters_fake` VALUES ('Trillium', '4', '5', '5', '47', '80', '2');
INSERT INTO `characters_fake` VALUES ('Turtlae', '6', '5', '6', '33', '80', '2');
INSERT INTO `characters_fake` VALUES ('Uganhja', '5', '6', '1', '25', '80', '2');
INSERT INTO `characters_fake` VALUES ('Valmartend', '9', '2', '6', '1', '80', '2');
INSERT INTO `characters_fake` VALUES ('Vineth', '6', '5', '4', '26', '80', '2');
INSERT INTO `characters_fake` VALUES ('Walmortq', '3', '5', '3', '9', '80', '2');
INSERT INTO `characters_fake` VALUES ('Xonosek', '3', '3', '3', '40', '80', '2');
INSERT INTO `characters_fake` VALUES ('Youzuga', '7', '7', '7', '3', '80', '2');
INSERT INTO `characters_fake` VALUES ('Zauktaji', '5', '4', '3', '43', '80', '2');
INSERT INTO `characters_fake` VALUES ('Zebinar', '6', '2', '11', '44', '80', '2');

in this table

race = name
name = race?
class = ?
level = class
gender = zone
zone = level
online = online,

Special Thanks to Exonation for helping



its a really annoying solution for current layout of this patch. I hope a pro C++ developer will find what is wrong in Script & will make it working with normal/default "characters_fake" table structure

[Asbonia]

if someone can fix this script without any editing then it will be awesome
but for temporary fix or you can say to make it working with current script's layout you will need to do following steps

Go to src/server/game/Entities/Player/Player.cpp
Find Line
CharacterDatabase.PExecute("UPDATE characters_fake SET zone = (FLOOR(50 * RAND()) + 1) WHERE online>1");
& Replace with
CharacterDatabase.PExecute("UPDATE characters_fake SET gender = (FLOOR(50 * RAND()) + 1) WHERE online>1");

then

Find line
CharacterDatabase.PExecute("UPDATE characters_fake SET level=level+1 WHERE online>1 AND level<5");
& Replace with
CharacterDatabase.PExecute("UPDATE characters_fake SET zone=zone+1 WHERE online>1 AND level<5");

& then you will need to execute this query in characters db, which has some with some annoying structure

SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for `characters_fake`
-- ----------------------------
DROP TABLE IF EXISTS `characters_fake`;
CREATE TABLE `characters_fake` (
  `race` varchar(36) NOT NULL,
  `name` mediumint(3) NOT NULL DEFAULT '0',
  `class` mediumint(3) NOT NULL DEFAULT '0',
  `level` mediumint(3) NOT NULL DEFAULT '0',
  `gender` mediumint(9) NOT NULL DEFAULT '0',
  `zone` mediumint(3) NOT NULL DEFAULT '0',
  `online` mediumint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`race`,`name`,`class`,`level`,`gender`,`zone`,`online`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- ----------------------------
-- Records of characters_fake
-- ----------------------------


INSERT INTO `characters_fake` VALUES ('Seventeem', '5', '9', '8', '39', '80', '2');
INSERT INTO `characters_fake` VALUES ('Siwftkim', '3', '7', '5', '6', '80', '2');
INSERT INTO `characters_fake` VALUES ('Stdchrtd', '8', '9', '2', '46', '80', '2');
INSERT INTO `characters_fake` VALUES ('Thefreakz', '8', '8', '8', '7', '80', '2');
INSERT INTO `characters_fake` VALUES ('Treaex', '5', '7', '2', '29', '80', '2');
INSERT INTO `characters_fake` VALUES ('Trillium', '4', '5', '5', '47', '80', '2');
INSERT INTO `characters_fake` VALUES ('Turtlae', '6', '5', '6', '33', '80', '2');
INSERT INTO `characters_fake` VALUES ('Uganhja', '5', '6', '1', '25', '80', '2');
INSERT INTO `characters_fake` VALUES ('Valmartend', '9', '2', '6', '1', '80', '2');
INSERT INTO `characters_fake` VALUES ('Vineth', '6', '5', '4', '26', '80', '2');
INSERT INTO `characters_fake` VALUES ('Walmortq', '3', '5', '3', '9', '80', '2');
INSERT INTO `characters_fake` VALUES ('Xonosek', '3', '3', '3', '40', '80', '2');
INSERT INTO `characters_fake` VALUES ('Youzuga', '7', '7', '7', '3', '80', '2');
INSERT INTO `characters_fake` VALUES ('Zauktaji', '5', '4', '3', '43', '80', '2');
INSERT INTO `characters_fake` VALUES ('Zebinar', '6', '2', '11', '44', '80', '2');

in this table

race = name
name = race?
class = ?
level = class
gender = zone
zone = level
online = online,

Special Thanks to Exonation for helping

its a really annoying solution for current layout of this patch. I hope a pro C++ developer will find what is wrong in Script & will make it working with normal/default "characters_fake" table structure

Like this ^