vb.org Archive - Create a page to show SQL Data

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

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

- - Create a page to show SQL Data (https://vborg.vbsupport.ru/showthread.php?t=142678)

cddw.ltd

03-21-2007 09:10 AM

Create a page to show SQL Data

I'd like to create a single PHP page, which returns either a 0 or 1.

I think what I need is -

SELECT 'value' FROM 'forum_setting' WHERE varname='bbactive'

What I basically want to do, is have a page show 0 when the forum is closed or a 1 when its open (or whicever way around it is) because I'm going to use this number in an if statement on a different domain...

Anyone able to help?

:)

sebbe

03-21-2007 09:46 AM

PHP Code:


		
			
require_once('./global.php');

$settings = $vbulletin->db->query_read("SELECT value FROM " . TABLE_PREFIX . "_setting WHERE varname = 'bbactive' LIMIT 1");

while($setting = $vbulletin->db->fetch_array($settings))
{
    $bbactive = $setting['value'];
}

echo $bbactive;

cddw.ltd

03-21-2007 09:55 AM

Slight error,

"_setting WHERE

Didn't need the _ before the setting, otherwise, worked perfectly :) Thanks

sebbe

03-21-2007 10:09 AM

Oops.. typo.

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

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