The Arcive of Official vBulletin Modifications Site.

CoffeeLovesYou · #1 03-25-2013, 08:52 AM

Hello
I am currently using this code as a plugin hooked to global_start and calling it in the NAVBAR template with it's variable;

PHP Code:


			
ob_start();
?>
<center>
<html>
<body>
 
<?php

$sql = mysql_query("select count(*) from songrequests where req_status <= 1");
$row = mysql_fetch_row($sql);
if($row)
if ($row[0] == 1) {
echo "<a href='SongRequests.php'>There is $row[0] Song Request Waiting</a>"; 
} elseif ($row[0] > 1) {
echo "<a href='SongRequests.php'>There are $row[0] Song Requests Waiting</a>";
}

?>
</html></center>
<?php
   $countsr = ob_get_contents();
ob_end_clean();

How can I just make the notification show up in the Notifications dropdown?
Thank you

kh99 · #2 03-25-2013, 11:35 AM

In place of your plugin, you could create a plugin using hook notifications_list and code like:

Code:

$sql = mysql_query("select count(*) from songrequests where req_status <= 1");
$row = mysql_fetch_row($sql);
if($row)
{
if ($row[0] == 1) {
$msg = "There is $row[0] Song Request Waiting"; 
} elseif ($row[0] > 1) {
$msg = "There are $row[0] Song Requests Waiting";
}
$notifications['countsr'] = array(
				'phrase' => $msg,
				'link'   => 'SongRequests.php',
				'order'  => 20
			);
$vbulletin->userinfo['countsr'] = $row[0];
}

CoffeeLovesYou · #3 03-25-2013, 07:20 PM

Ty works perfect

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03420 seconds Memory Usage 2,183KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (3)post_thanks_box (3)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (3)post_thanks_postbit_info (3)postbit (3)postbit_onlinestatus (3)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!