vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   My VBulletin is screwy! Help! (https://vborg.vbsupport.ru/showthread.php?t=60919)

NinjaBen 01-29-2004 02:42 PM
My VBulletin is screwy! Help!
 
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 01-29-2004 02:57 PM
so u uprgaded ? that means re installing hacks mate

NinjaBen 01-29-2004 02:59 PM
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 01-29-2004 03:04 PM
Oh, and I installed the quick reply hack.

Lesane 01-29-2004 04:11 PM
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 01-29-2004 04:19 PM
1 Attachment(s)
I attatched an image of what the results were. . . I wasn't sure what you needed.

Lesane 01-29-2004 04:27 PM
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 01-29-2004 04:38 PM
Well, i have all three of those blocks, all of them are the same as the ones you posted.

NinjaBen 01-29-2004 04:43 PM
Just below the last bit I have this, does that matter?
PHP Code:
      $threadid=$DB_site->insert_id(); 

Lesane 01-29-2004 04:53 PM
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.


All times are GMT. The time now is 02:39 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01439 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete