i have a chatroom, but when im trying to post message, it does'nt appear, then i check ibwf user, here's the table, tell what's wrong and which column that i put the 'pid'
--
-- Table structure for table `ibwf_users`
--
CREATE TABLE `ibwf_users` (
`id` int(6) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(60) NOT NULL default '',
`pass2` varchar(50) NOT NULL default '',
`birthday` varchar(11) NOT NULL default '',
`sex` char(1) NOT NULL default '',
`location` varchar(30) NOT NULL default '',
`perm` char(1) NOT NULL default '0',
`posts` int(6) NOT NULL default '0',
`totin` int(100) NOT NULL default '0',
`totout` int(100) NOT NULL default '0',
`buds` int(100) NOT NULL default '0',
`plusses` int(10) NOT NULL default '50',
`reps` int(10) NOT NULL default '0',
`signature` varchar(255) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`lastact` int(20) NOT NULL default '0',
`regdate` int(20) NOT NULL default '0',
`chmsgs` int(3) NOT NULL default '0',
`chmood` int(5) NOT NULL default '0',
`shield` char(1) NOT NULL default '0',
`gplus` int(100) NOT NULL default '0',
`budmsg` varchar(30) NOT NULL default '',
`lastpnreas` varchar(255) NOT NULL default '',
`lastplreas` varchar(100) NOT NULL default '',
`shouts` int(100) NOT NULL default '0',
`pollid` int(100) NOT NULL default '0',
`rbcid` varchar(255) NOT NULL default '',
`lastvst` int(20) NOT NULL default '0',
`battlep` int(20) NOT NULL default '0',
`likes` blob NOT NULL,
`hates` blob NOT NULL,
`ms` char(1) NOT NULL default 'S',
`rname` varchar(40) NOT NULL default '',
`ppp` int(3) NOT NULL default '10',
`alert` int(1) NOT NULL default '0',
`profvws` int(100) NOT NULL default '0',
`tottimeonl` int(100) NOT NULL default '0',
`hidden` int(1) NOT NULL default '0',
`forumb` int(1) default '0',
`shoutb` int(1) default '0',
`inboxb` int(1) default '0',
`visit` varchar(255) NOT NULL default '0',
`ua` varchar(150) NOT NULL default '',
`ip` varchar(40) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`fontsize` tinyint(1) NOT NULL default '2',
`tttw` int(11) NOT NULL default '0',
`tttl` int(11) NOT NULL default '0',
`emailon` char(1) NOT NULL default '',
`icons` varchar(11) NOT NULL default '',
`imgon` tinyint(1) NOT NULL default '0',
`emlalerton` int(1) NOT NULL default '0',
`galon` int(1) NOT NULL default '1',
`bdayon` int(1) NOT NULL default '1',
`tusron` int(1) NOT NULL default '1',
`sboxon` int(1) NOT NULL default '1',
`haveon` int(1) NOT NULL default '1',
`lateston` int(1) NOT NULL default '1',
`tz` int(2) NOT NULL default '1',
`shoutsize` int(1) NOT NULL default '0',
`dead` varchar(255) NOT NULL default '1',
`killer` varchar(255) NOT NULL default '',
`numberattck` bigint(20) NOT NULL default '0',
`justattacked` int(4) NOT NULL default '0',
`honor` int(11) NOT NULL default '0',
`lastreg` bigint(3) NOT NULL default '0',
`gold` bigint(20) NOT NULL default '0',
`land` bigint(20) NOT NULL default '0',
`offarmy` bigint(20) NOT NULL default '0',
`dffarmy` bigint(6) NOT NULL default '0',
`numturns` bigint(1) NOT NULL default '0',
`tsgone` bigint(20) NOT NULL default '0',
`oldtime` bigint(20) NOT NULL default '0',
`lastime` bigint(20) NOT NULL default '0',
`txtstyle` bigint(15) NOT NULL default '0',
`navstyle` varchar(30) NOT NULL default 'full',
`netinfo` blob NOT NULL,
`postalert` tinyint(1) NOT NULL default '1',
`pmpreviews` tinyint(1) NOT NULL default '1',
`validkey` varchar(255) NOT NULL default '',
`lastaction` bigint(20) NOT NULL default '0',
`language` int(1) NOT NULL default '0',
`spinned` varchar(10) NOT NULL default '0',
`hit` varchar(5) NOT NULL default '',
`health` varchar(5) NOT NULL default '',
`accept` varchar(5) NOT NULL default '',
`activate` char(2) NOT NULL default '',
`spintime` varchar(10) character set latin1 collate latin1_general_ci NOT NULL default '',
`validated` char(1) NOT NULL default '0',
`hvia` varchar(20) NOT NULL default '',
`bank` int(11) NOT NULL default '0',
`onlinedone` int(100) NOT NULL default '0',
`resetime` int(100) NOT NULL default '0',
`onlinetime` int(100) NOT NULL default '0',
`cards` varchar(10) NOT NULL default '',
`otime` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Table structure for table `ibwf_users`
--
CREATE TABLE `ibwf_users` (
`id` int(6) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pass` varchar(60) NOT NULL default '',
`pass2` varchar(50) NOT NULL default '',
`birthday` varchar(11) NOT NULL default '',
`sex` char(1) NOT NULL default '',
`location` varchar(30) NOT NULL default '',
`perm` char(1) NOT NULL default '0',
`posts` int(6) NOT NULL default '0',
`totin` int(100) NOT NULL default '0',
`totout` int(100) NOT NULL default '0',
`buds` int(100) NOT NULL default '0',
`plusses` int(10) NOT NULL default '50',
`reps` int(10) NOT NULL default '0',
`signature` varchar(255) NOT NULL default '',
`avatar` varchar(100) NOT NULL default '',
`lastact` int(20) NOT NULL default '0',
`regdate` int(20) NOT NULL default '0',
`chmsgs` int(3) NOT NULL default '0',
`chmood` int(5) NOT NULL default '0',
`shield` char(1) NOT NULL default '0',
`gplus` int(100) NOT NULL default '0',
`budmsg` varchar(30) NOT NULL default '',
`lastpnreas` varchar(255) NOT NULL default '',
`lastplreas` varchar(100) NOT NULL default '',
`shouts` int(100) NOT NULL default '0',
`pollid` int(100) NOT NULL default '0',
`rbcid` varchar(255) NOT NULL default '',
`lastvst` int(20) NOT NULL default '0',
`battlep` int(20) NOT NULL default '0',
`likes` blob NOT NULL,
`hates` blob NOT NULL,
`ms` char(1) NOT NULL default 'S',
`rname` varchar(40) NOT NULL default '',
`ppp` int(3) NOT NULL default '10',
`alert` int(1) NOT NULL default '0',
`profvws` int(100) NOT NULL default '0',
`tottimeonl` int(100) NOT NULL default '0',
`hidden` int(1) NOT NULL default '0',
`forumb` int(1) default '0',
`shoutb` int(1) default '0',
`inboxb` int(1) default '0',
`visit` varchar(255) NOT NULL default '0',
`ua` varchar(150) NOT NULL default '',
`ip` varchar(40) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`fontsize` tinyint(1) NOT NULL default '2',
`tttw` int(11) NOT NULL default '0',
`tttl` int(11) NOT NULL default '0',
`emailon` char(1) NOT NULL default '',
`icons` varchar(11) NOT NULL default '',
`imgon` tinyint(1) NOT NULL default '0',
`emlalerton` int(1) NOT NULL default '0',
`galon` int(1) NOT NULL default '1',
`bdayon` int(1) NOT NULL default '1',
`tusron` int(1) NOT NULL default '1',
`sboxon` int(1) NOT NULL default '1',
`haveon` int(1) NOT NULL default '1',
`lateston` int(1) NOT NULL default '1',
`tz` int(2) NOT NULL default '1',
`shoutsize` int(1) NOT NULL default '0',
`dead` varchar(255) NOT NULL default '1',
`killer` varchar(255) NOT NULL default '',
`numberattck` bigint(20) NOT NULL default '0',
`justattacked` int(4) NOT NULL default '0',
`honor` int(11) NOT NULL default '0',
`lastreg` bigint(3) NOT NULL default '0',
`gold` bigint(20) NOT NULL default '0',
`land` bigint(20) NOT NULL default '0',
`offarmy` bigint(20) NOT NULL default '0',
`dffarmy` bigint(6) NOT NULL default '0',
`numturns` bigint(1) NOT NULL default '0',
`tsgone` bigint(20) NOT NULL default '0',
`oldtime` bigint(20) NOT NULL default '0',
`lastime` bigint(20) NOT NULL default '0',
`txtstyle` bigint(15) NOT NULL default '0',
`navstyle` varchar(30) NOT NULL default 'full',
`netinfo` blob NOT NULL,
`postalert` tinyint(1) NOT NULL default '1',
`pmpreviews` tinyint(1) NOT NULL default '1',
`validkey` varchar(255) NOT NULL default '',
`lastaction` bigint(20) NOT NULL default '0',
`language` int(1) NOT NULL default '0',
`spinned` varchar(10) NOT NULL default '0',
`hit` varchar(5) NOT NULL default '',
`health` varchar(5) NOT NULL default '',
`accept` varchar(5) NOT NULL default '',
`activate` char(2) NOT NULL default '',
`spintime` varchar(10) character set latin1 collate latin1_general_ci NOT NULL default '',
`validated` char(1) NOT NULL default '0',
`hvia` varchar(20) NOT NULL default '',
`bank` int(11) NOT NULL default '0',
`onlinedone` int(100) NOT NULL default '0',
`resetime` int(100) NOT NULL default '0',
`onlinetime` int(100) NOT NULL default '0',
`cards` varchar(10) NOT NULL default '',
`otime` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
Comment