vb.org Archive - vBindex v2.1

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vBindex v2.1 (https://vborg.vbsupport.ru/showthread.php?t=41916)

I uninstalled vbindex today and now I get this error when making new posts. Would it be related? please help!

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE thread SET tpostid='24040' WHERE threadid='1097'
mysql error: Unknown column 'tpostid' in 'field list'

mysql error number: 1054

Date: Saturday 04th of January 2003 01:30:26 AM
Script: http://www.limpkinw.com/forums/forums/newthread.php
Referer: http://www.limpkinw.com/forums/newth...read&forumid=1

Hi is it possible to include these variables in the index?

i tried just inserting them as i have here but nothing is displayed apart from the time variable.

thnx for any help :D

$numbermembers

$newusername

$totalthreads

$totalposts

$timenow (this one is working)

Quote:

Originally posted by Limpkinw
I uninstalled vbindex today and now I get this error when making new posts. Would it be related? please help![/url]

You haven't uninstalled it properly, you need to do the reverse of all the changes you made whilst installing, the uninstaller can't do the changes you made.

Quote:

Originally posted by colicab-d
Hi is it possible to include these variables in the index?

i tried just inserting them as i have here but nothing is displayed apart from the time variable.

Yes, you just need to include the code that generates the contents for them, they look like they all come from index.php, just add the code at the top around // posts info

I cannot get the text of the news post to display... i tried updating the counters but it did not work..

PHP Code:


		
			
// get total posts

$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');

$totalposts=number_format($countposts['posts']);



$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');

$totalthreads=number_format($countthreads['threads']);



// get newest member

$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");

$newusername=$getnewestusers['username'];

$newuserid=$getnewestusers['userid'];

im guessing thats the code for a few of them, but where would i insert this?

Quote:

Originally posted by NTLDR
just add the code at the top around // posts info

hey ntldr... me again.
:nervous:

listen, new quirk.
as you no doubt remember, you've helped me change the news bit quite a bit for my pages, so i'm going to quote all of it (cause it's nowhere near the default anymore).
the problem is that if anyone other than me posts and uses bbcode (like color), it doesn't display the color (just the text bbcode... like [ color=blue ]this[ /color ] ... without the obvious spaces).
part of this is no doubt cause we set it up so i could post html without anyone else having that ability, but in so doing, they can't post bbcode now.
i think it's the 'else' tag, but i don't know what it should be.
any help, as always, is greatly appreciated.

PHP Code:


		
			
// news (based on code by TECK)

// -------------------------

if ($newsonoff!=0) {

$newsquery=$newsquery=$DB_site->query("SELECT thread.*,threadpost.pagetext AS pagetext FROM thread LEFT JOIN post AS threadpost ON (thread.tpostid = threadpost.postid) WHERE forumid = '$newsforum' AND thread.visible='1' ORDER BY thread.dateline DESC LIMIT $newsposts");

while ($news=$DB_site->fetch_array($newsquery)) {

  $newsthreadid=$news[threadid];

  $newstitle=$news[title];

  $newstime=vbdate($timeformat,$news[dateline]);

  $newsdate=vbdate($dateformat,$news[dateline]);

  $newsusername=$news[postusername];

  $newsuserid=$news[postuserid];

  $comments=$news[replycount];

if ($news[postuserid]==1) {



  $newstext=bbcodeparse2($news[pagetext],1,1,1,1);



  } else {



  $newstext=bbcodeparse($news[pagetext],0,1);



}

  $newstext=str_replace("Quote:", "", $newstext);

  $icon=$news[iconid];

  // uncomment out next line to remove line breaks in the news

  //$newstext=str_replace("<br />","",$newstext);

  // max news chars

  if ($maxnewschars!=0) {

     if (strlen($newstext) > $maxnewschars) {

        $newstext = substr($newstext,0,$maxnewschars);

        $newstext .= "...";

     }

   $readmore="<a href=\"$bburl/showthread.php?threadid=$newsthreadid\">Read Full Post</a> - ";

  }

  // end max newschars

  eval("\$newsbits .= \"".gettemplate('home_newsbit')."\";");

}

eval("\$news = \"".gettemplate('home_news')."\";");

}

// -------------------------

// end news

thanks.

Thanks to your assistance, I have created a custom template that I call into your home template. Works great! :classic:

After reviewing my custom layout of the vbindex.php page, I decided that the new template really belongs in the left column (and therefore in your left template), but when I call it into that template, nothing from it displays.

I have a feeling that it has something to do with the order of the templates, but I am outta my depth here still.

Any suggestions?

Quote:

Originally posted by Buddha
the problem is that if anyone other than me posts and uses bbcode (like color), it doesn't display the color (just the text bbcode... like [ color=blue ]this[ /color ] ... without the obvious spaces).

It take it that vBcode is enabled for that forum that the user is posting too? The code seems to be correct, if you do have vBcode enabled then I'll take a look further into this.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02438 seconds Memory Usage 1,771KB 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 (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (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
Messages: