MYSQL Querys needed !!! REP++ For Helper

[jo31_99]

[11/07/2013 11:53:02] Rook Sample has logged out.
[11/07/2013 11:53:02] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 11 - MYSQL ERROR: Table 'swev.player_depotitems' doesn't exist (1146)
[11/07/2013 11:53:03] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 11 - MYSQL ERROR: Table 'swev.player_depotitems' doesn't exist (1146)
[11/07/2013 11:53:03] mysql_real_query(): DELETE FROM `player_depotitems` WHERE `player_id` = 11 - MYSQL ERROR: Table 'swev.player_depotitems' doesn't exist (1146)
[11/07/2013 11:53:03] Error while saving player: Rook Sample.


















[11/07/2013 11:52:57] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:57] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373536377 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:58] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:59] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 2 AND `type` = 3 AND `active` = 1 AND (`expires` > 1373536378 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:59] mysql_real_query(): SELECT * FROM `bans` WHERE `value` = 268440513 AND `param` = 3 AND `type` = 2 AND `active` = 1 AND (`expires` > 1373536379 OR `expires` <= 0) LIMIT 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:59] mysql_real_query(): SELECT `id` FROM `bans` WHERE `type` = 2 AND `value` = 3 AND `param` = 2 AND `active` = 1 LIMIT 1 - MYSQL ERROR: Table 'swev.bans' doesn't exist (1146)
[11/07/2013 11:52:59] mysql_real_query(): SELECT `pid`, `sid`, `itemtype`, `count`, `attributes` FROM `player_depotitems` WHERE `player_id` = 3 ORDER BY `sid` DESC - MYSQL ERROR: Table 'swev.player_depotitems' doesn't exist (1146)







im getting those errors when people login/out

 

[Mikii]

Execute This Sqls Tables.

-- ----------------------------
-- Table structure for `bans`
-- ----------------------------
DROP TABLE IF EXISTS `bans`;
CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',
  `value` int(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number',
  `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `expires` int(11) NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `admin_id` int(10) unsigned NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL DEFAULT '0',
  `action` int(10) unsigned NOT NULL DEFAULT '0',
  `statement` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `type` (`type`,`value`),
  KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of bans
-- ----------------------------


-- ----------------------------
-- Table structure for `player_depotitems`
-- ----------------------------
DROP TABLE IF EXISTS `player_depotitems`;
CREATE TABLE `player_depotitems` (
  `player_id` int(11) NOT NULL,
  `sid` int(11) NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
  `pid` int(11) NOT NULL DEFAULT '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `player_id_2` (`player_id`,`sid`),
  KEY `player_id` (`player_id`),
  CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of player_depotitems
-- ----------------------------

 

[dchampag]

beat me to it xD