vb.org Archive - VB database pulls on nonvb pages

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

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

- - VB database pulls on nonvb pages (https://vborg.vbsupport.ru/showthread.php?t=97727)

TheCaver

10-06-2005 03:12 PM

VB database pulls on nonvb pages

In 3.0.x, I used this code to pull calendar events...it no longer works in 3.5....Any ideas? I have several pages on my site broken for this same reason I suspect. Just not sure what changed :

PHP Code:


		
			
<?

$events = $DB_site->query("select * from event order by dateline DESC limit 3");



if ($DB_site->num_rows($events))

{

        while ($ev = $DB_site->fetch_array($events))

        {

             $news="";

             $new_date = vbdate('m-d-Y', $ev['dateline'], false, false);

             $news .= "<B>".$new_date."</B><BR>";

             $news .= $ev['title']."<BR>";



echo "<A class='text-9white' HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>";



        }

}



?>

THANKS !!!

JC

jugo	10-06-2005 03:17 PM

$DB_ is now $db_

noppid

10-06-2005 03:19 PM

I think changing $DB_site->query to $db->query_read will do it.

TheCaver

10-06-2005 03:27 PM

Hmm, that didn't seem to do it....Thanks for the suggestions though!

JC

Blaine0002

10-06-2005 04:25 PM

Code:

<?

$events = $db->query("select * from event order by dateline DESC limit 3");



if ($db->num_rows($events))

{

        while ($ev = $db->fetch_array($events))

        {

             $news="";

             $new_date = vbdate('m-d-Y', $ev['dateline'], false, false);

             $news .= "<B>".$new_date."</B><BR>";

             $news .= $ev['title']."<BR>";



echo "<A class='text-9white' HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>";



        }

}



?>

try this.

All times are GMT. The time now is 12:39 AM.

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