Es esta:
Código PHP:
--
-- Estructura de tabla para la tabla `guild`
--
CREATE TABLE IF NOT EXISTS `guild` (
`guild_id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(24) NOT NULL default '',
`char_id` int(11) unsigned NOT NULL default '0',
`master` varchar(24) NOT NULL default '',
`guild_lv` tinyint(6) unsigned NOT NULL default '0',
`connect_member` tinyint(6) unsigned NOT NULL default '0',
`max_member` tinyint(6) unsigned NOT NULL default '0',
`average_lv` smallint(6) unsigned NOT NULL default '1',
`exp` int(11) unsigned NOT NULL default '0',
`next_exp` int(11) unsigned NOT NULL default '0',
`skill_point` tinyint(11) unsigned NOT NULL default '0',
`mes1` varchar(60) NOT NULL default '',
`mes2` varchar(120) NOT NULL default '',
`emblem_len` int(11) unsigned NOT NULL default '0',
`emblem_id` int(11) unsigned NOT NULL default '0',
`emblem_data` blob,
PRIMARY KEY (`guild_id`,`char_id`),
UNIQUE KEY `guild_id` (`guild_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
Bueno lo que quiero que a partir del
castle_id se sepa el
name de la
guild_id que tiene ese
castle_id.
Los
castle_id son, 0 para el castle 1, 13 para el caslte 2 y 17 para el castle 3.