Ibwf_users

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Ibwf_users

    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 ;

    #2
    insert this to your ibwf_chat

    `perm` varchar(10) NOT NULL default '0',
    Did I help you?
    You can help me too
    Your donations will help me finance my studies.

    Comment


      #3
      thankz sir. . I will try!

      Comment


        #4
        Originally posted by kei_ki7 View Post
        insert this to your ibwf_chat

        `perm` varchar(10) NOT NULL default '0',
        Sir, thankz, itz work, , ,

        Comment

        Working...
        X