vb.org Archive - code optimize

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

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - code optimize (https://vborg.vbsupport.ru/showthread.php?t=285072)

this code is for show last active posts for non-vb page can you help me for optimize this code?

PHP Code:


		
			
<?php

## CUSTOMIZE SETTINGS FOR YOUR SITE ##

$db_host = "xxxx"; // Change this if your MySQL database host is different.

$db_name = 'xxxx'; // Change this to the name of your database.

$db_user = 'xxxxx'; // Change this to your database username.

$db_pw = 'xxxxx'; // Change this to your database password.

$db_pre = ""; // Tables prefix

$forum_url = "http://forum.xxxx.com/"; // Change this to reflect to your forum's URL.

$forum_id = ""; 

$limit = "20"; // Number of posts displayed.

$txtlimit = "120"; // This is the character limit.

#######################################



// Connecting to your database



mysql_connect($db_host, $db_user, $db_pw) 

OR die ("Cannot connect to your database user"); 

mysql_select_db($db_name) OR die("Cannot connect to your database"); 



if ($forum_id) {

    $forumid = "AND forumid=$forum_id";

}



if ($limit) {

    $limited = "LIMIT $limit";

}





$thread_sql = mysql_query("SELECT threadid, lastpost, lastposter, title FROM thread WHERE visible=1 AND open=1 AND forumid<>32 ORDER BY lastpost DESC LIMIT 0,5");

for($i = 0; $i<5; $i++)

{

  $tid = @mysql_result($thread_sql,$i,0);

  $lastpost = @mysql_result($thread_sql,$i,1);

  $lastposter = @mysql_result($thread_sql,$i,2);

//  $replaycount = @mysql_result($thread_sql,$i,9);

//  $views = @mysql_result($thread_sql,$i,17);

  $psql = mysql_query("SELECT postid FROM post WHERE threadid='$tid' ORDER BY postid DESC LIMIT 0,1");

  $pid = @mysql_result($psql,0,0);

  $title = @mysql_result($thread_sql,$i,3);

  $title = substr($title,0,$txtlimit);

$sitename = "http://forum.xxxxx.com/";

$sitelink = "showthread.php?t=$tid&p=$pid#post$pid";



?>

i use top code in a non-vb page

i dont want use database user and password in this file and connect directly to database

This is possible if you are in the same directory of the vbulletin site for example
This is the forums page: http://yoursite.com/forum.php
This is the script page: http://yoursite.com/script.php

PHP Code:


		
			
<?php
include 'includes/config.php';

## CUSTOMIZE SETTINGS FOR YOUR SITE ##
$db_host = $config['MasterServer']['servername'];
$db_name = $config['Database']['dbname'];
$db_user = $config['MasterServer']['username'] ;
$db_pw = $config['MasterServer']['password'];
$db_pre = $config['Database']['tableprefix'];
$forum_url = "http://forum.xxxx.com/"; // Change this to reflect to your forum's URL.
$forum_id = ""; 
$limit = "20"; // Number of posts displayed.
$txtlimit = "120"; // This is the character limit.

// Connecting to your database

mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database user"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

if ($forum_id) {
    $forumid = "AND forumid=$forum_id";
}

if ($limit) {
    $limited = "LIMIT $limit";
}


$thread_sql = mysql_query("SELECT threadid, lastpost, lastposter, title FROM thread WHERE visible=1 AND open=1 AND forumid<>32 ORDER BY lastpost DESC LIMIT 0,5");
for($i = 0; $i<5; $i++)
{
  $tid = @mysql_result($thread_sql,$i,0);
  $lastpost = @mysql_result($thread_sql,$i,1);
  $lastposter = @mysql_result($thread_sql,$i,2);
//  $replaycount = @mysql_result($thread_sql,$i,9);
//  $views = @mysql_result($thread_sql,$i,17);
  $psql = mysql_query("SELECT postid FROM post WHERE threadid='$tid' ORDER BY postid DESC LIMIT 0,1");
  $pid = @mysql_result($psql,0,0);
  $title = @mysql_result($thread_sql,$i,3);
  $title = substr($title,0,$txtlimit);
$sitename = "http://forum.xxxxx.com/";
$sitelink = "showthread.php?t=$tid&p=$pid#post$pid";

?>

This should work, for the forum url i don't know what you can do :/

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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 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.01102 seconds Memory Usage 1,753KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: