execute em seu banco de dados essa query!

CREATE TABLE IF NOT EXISTS 'pkr.players_online' (
  `player_id` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL DEFAULT '0',
  `p` int(11) NOT NULL DEFAULT '0',
  `g` int(11) NOT NULL DEFAULT '0',
  `guild_id` int(11) NOT NULL DEFAULT '0',
  `guilds` int(11) NOT NULL DEFAULT '0',
  `guild_membership` int(11) NOT NULL DEFAULT '0',
  `name` int(11) NOT NULL DEFAULT '0',
  `gname` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `vocation` int(11) NOT NULL DEFAULT '0',
  `players_online` int(11) NOT NULL DEFAULT '0',
  `gm` int(11) NOT NULL DEFAULT '0',
  `attributes` blob NOT NULL );

Obrigado... mas você errou o certo séria:

CREATE TABLE IF NOT EXISTS players_online (
  `player_id` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL DEFAULT '0',
  `p` int(11) NOT NULL DEFAULT '0',
  `g` int(11) NOT NULL DEFAULT '0',
  `guild_id` int(11) NOT NULL DEFAULT '0',
  `guilds` int(11) NOT NULL DEFAULT '0',
  `guild_membership` int(11) NOT NULL DEFAULT '0',
  `name` int(11) NOT NULL DEFAULT '0',
  `gname` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '0',
  `vocation` int(11) NOT NULL DEFAULT '0',
  `players_online` int(11) NOT NULL DEFAULT '0',
  `gm` int(11) NOT NULL DEFAULT '0',
  `attributes` blob NOT NULL );

Mano agora eu to precisando da guild_membership:

 

string(337) "SELECT `o`.`player_id` AS `id`, `p`.`name` as `name`, `p`.`level` as `level`, `p`.`vocation` as `vocation`, `g`.`name` as `gname` FROM `players_online` as `o` INNER JOIN `players` as `p` ON `o`.`player_id` = `p`.`id` LEFT JOIN `guild_membership` gm ON `o`.`player_id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id`" 

(query - SQL error) 
Type: select_multi (select multiple rows from database)

Table 'pkr.guild_membership' doesn't exist

Editado Dezembro 20, 2014 10 anos por GabrielSapient (veja o histórico de edições)