vb.org Archive - Converting code to 3.5

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Converting code to 3.5 (https://vborg.vbsupport.ru/showthread.php?t=93472)

Snake

08-02-2005 06:17 PM

Converting code to 3.5

Hey guys, I am using the following code for one of my custom hack so I would like it converted to 3.5 please. The current code is for 3.0 so it will not work on 3.5, according to Jake.

Quote:

// GET NUMBER OF NEW POSTS
$newposts = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline > '$bbuserinfo[lastvisit]'");

// DETERMINE IF "POSTS" IS SINGULAR OR PLURAL
if ($newposts[count] == 1)
{
$newposts[plural] = "";
}
else
{
$newposts[plural] = "s";
}

// GET NUMBER OF NEW THREADS
$newthreads = $DB_site->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "thread WHERE dateline > '$bbuserinfo[lastvisit]'");

// DETERMINE IF "THREADS" IS SINGULAR OR PLURAL
if ($newthreads[count] == 1)
{
$newthreads[plural] = "";
}
else
{
$newthreads[plural] = "s";
}

$getnews = $DB_site->query_first("SELECT threadid, title FROM ".TABLE_PREFIX."thread WHERE forumid=2 ORDER BY lastpost DESC LIMIT 1");

Andreas

08-02-2005 06:23 PM

PHP Code:


		
			
// GET NUMBER OF NEW POSTS

$newposts = $db->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "post WHERE dateline > " . $vbulletin->userinfo['lastvisit']);



// DETERMINE IF "POSTS" IS SINGULAR OR PLURAL

if ($newposts['count'] == 1)

{

    $newposts[plural] = "";

}

else

{

    $newposts[plural] = "s";

}



// GET NUMBER OF NEW THREADS

$newthreads = $db->query_first("SELECT count(*) AS count FROM " . TABLE_PREFIX . "thread WHERE dateline > " . $vbulletin->userinfo['lastvisit']);



// DETERMINE IF "THREADS" IS SINGULAR OR PLURAL

if ($newthreads[count] == 1)

{

    $newthreads[plural] = "";

}

else

{

    $newthreads[plural] = "s";

}



$getnews = $db->query_first("SELECT threadid, title FROM ".TABLE_PREFIX."thread WHERE forumid=2 ORDER BY lastpost DESC LIMIT 1");

... but you could have easily done this yourself by looking at Brads list of changed Varnames ;)

Snake

08-02-2005 06:29 PM

Hehe you're right but I'm a lazy type guy. :P Thanks anyways.

All times are GMT. The time now is 03:56 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01033 seconds Memory Usage 1,727KB 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 (1)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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: