run it in your sql, and guilds should work.
like if i helped you.
like if i helped you.
--
-- Definition of table `guilds`
--
DROP TABLE IF EXISTS `guilds`;
CREATE TABLE `guilds` (
`guildid` int(10) unsigned NOT NULL auto_increment,
`leader` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`GP` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`Logo` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`LogoColor` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`rank1title` varchar(45) NOT NULL default 'Master',
`rank2title` varchar(45) NOT NULL default 'Jr. Master',
`rank3title` varchar(45) NOT NULL default 'Member',
`rank4title` varchar(45) NOT NULL default 'Member',
`rank5title` varchar(45) NOT NULL default 'Member',
`capacity` varchar(45) character set latin1 collate latin1_bin NOT NULL default '10',
`logoBG` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`logoBGColor` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
`name` varchar(45) NOT NULL,
`notice` varchar(45) NOT NULL default '-',
`signature` varchar(45) NOT NULL default '0',
`alliance` varchar(45) character set latin1 collate latin1_bin NOT NULL default '0',
PRIMARY KEY (`guildid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `guilds`
--
/*!40000 ALTER TABLE `guilds` DISABLE KEYS */;
INSERT INTO `guilds` (`guildid`,`leader`,`GP`,`Logo`,`LogoColor`,`rank1title`,`rank2title`,`rank3title`,`rank4title`,`rank5title`,`capacity`,`logoBG`,`logoBGColor`,`name`,`notice`,`signature`,`alliance`) VALUES
(1,0x32,0x3138333030,0x34303138,0x36,'Master','Jr. Master','Member','Member','Member',0x3130,0x31303030,0x34,'JangoMS','0','1342961445',0x30);
/*!40000 ALTER TABLE `guilds` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;