My VBulletin is screwy! Help!

[NinjaBen]

Hello i installed VBulletin 2.3.2 on to my server which is detailed as an:

Apache/1.3.29 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.3 FrontPage/5.0.2.2634 mod_ssl/2.8.16 OpenSSL/0.9.7a

We us CPanel for our server and we run MySQL version 4.0.15-standard.

I have installed multiple hacks from here including: Store 3.0 by lesane, Physical Iten Add on by Churchmedia, Stats by Afterburner, and Stats by Bane.

The problem is relatively new. The probelm is that SOME member's names do not show up in our second forum "Junk in the Trunk" Their Username does not show up on the "Thread Starter" column or the "Last Post" column (both with in the Forum and on the main page showing both forums). The odd part is that only a 2 member's names have not shown up so far, but some still do.

The problem can be found here:
http://board.weekendninja.com/forumd...p?s=&forumid=3

Thank you in advance for your help!

[corsacrazy]

so u uprgaded ? that means re installing hacks mate

[NinjaBen]

No I didn't upgrade at all and all the hacks work fine. And to the best of MY knowledge the hacks never touched the forum that is all screwy. . .

[NinjaBen]

Oh, and I installed the quick reply hack.

[Lesane]

Weird problem, let's first check if the name of the author is stored in the table, execute the following query and post the result here:

[sql]
select postusername,postuserid,threadid from thread where threadid='146'
[/sql]

[NinjaBen]

I attatched an image of what the results were. . . I wasn't sure what you needed.

[Lesane]

It shows us that the username of the author is not stored in the table, so there is maybe something wrong in the file newthread.php, let's check that, open newthread.php and find:

Around line 131, your code can be different but post a block code that looks like this:

PHP Code:

      if ($userinfo=$DB_site->query_first("
              SELECT user.*,userfield.*
              FROM user,userfield
              WHERE     (username='".addslashes(htmlspecialchars($username))."' OR
                      username='".addslashes(eregi_replace("[^A-Za-z0-9]","",$username))."') AND
                      user.userid=userfield.userid")) {
        if (!$password) {
          eval("standarderror(\"".gettemplate("error_usernametaken")."\");");
        } elseif (md5($password)!=$userinfo['password']) {
          eval("standarderror(\"".gettemplate("error_wrongpassword")."\");");
        } else {
          $bbuserinfo = $userinfo;
          $postusername = $bbuserinfo['username'];

          if ($user['cookieuser']==1) {
            vbsetcookie("bbuserid",$user['userid']);
            vbsetcookie("bbpassword",$user['password']);
          }
          $DB_site->query("UPDATE session SET userid='$bbuserinfo[userid]' WHERE sessionhash='".addslashes($session['dbsessionhash'])."'");
        }
      } else {
        $postusername = htmlspecialchars($username);
      }
    } else {
      $postusername = $bbuserinfo['username'];
    } 


Let us know how your block looks like.

Then, find:

PHP Code:

//create new thread
      if ($postpoll) {
         $visible = 0;
      } 


There is a query code under that, something like this:

PHP Code:

      $DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,postuserid,lastposter,dateline,iconid,visible,attach) VALUES (NULL,'".addslashes(htmlspecialchars($subject))."','".time()."','$forumid','1','0','".addslashes($postusername)."','$bbuserinfo[userid]','".addslashes($postusername)."','".time()."','$iconid','$visible','$attachcount')"); 


Let us know wich line you have.

[NinjaBen]

Well, i have all three of those blocks, all of them are the same as the ones you posted.

[NinjaBen]

Just below the last bit I have this, does that matter?

PHP Code:

      $threadid=$DB_site->insert_id(); 


[Lesane]

hmm, can you give me the result of this query?

[sql]
select username from post where threadid='146'
[/sql]

And no, that doesn't matter.. the code belongs there.