Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
  #1  
Old 10-24-2011, 12:55 AM
steven s's Avatar
steven s steven s is offline
 
Join Date: Aug 2004
Location: Greenville, SC
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default widget code to web page

I have a widget

PHP Code:
ob_start();

$output_bits '';

$today_m date('m');
$today_y date('Y');

$spacer $today_m;

$get_schedule vB::$db->query_read("
    SELECT *
    FROM " 
TABLE_PREFIX "thread
    WHERE prefixid IN('Chapter_Event', 'other')
    ORDER BY UNIX_TIMESTAMP(STR_TO_DATE(LEFT(title, 10), '%m/%d/%Y')) ASC
"
);

while (
$schedule vB::$db->fetch_array($get_schedule))
{
    if (
strtotime(substr($schedule['title'], 010)) < (TIMENOW 86400))
    {
        continue;
    }

    
$str substr($schedule['title'], 02); // get month of event to add space between months

    
if ($str == $spacer)
    {
        
$output_bits .= '<a target="_blank" href="showthread.php?t=' $schedule['threadid'] . '">' $schedule['title'] . '</a><br />';
    }
    else
    {
        
$output_bits .= '<hr><a target="_blank" href="showthread.php?t=' $schedule['threadid'] . '">' $schedule['title'] . '</a><br />';
    }
    
$spacer $str;
}

vB::$db->free_result($get_schedule);


$output $output_bits;

ob_end_clean(); 
which creates a calendar of events on http://www.nccbmwcca.org based on the date in the subject.
I need to be able to output this script to a simple standalone webpage.

Anyone whip it up for me? Please?
Reply With Quote
  #2  
Old 10-24-2011, 08:13 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What do you mean by standalone, exactly? Can it be a "vb powered" page? If so you can probably use this: https://vborg.vbsupport.ru/showthread.php?t=228112 . I don't think you need the ob_start/ob_end_clean calls. You may need a template with the header and footer if you want to include those things on the page.
Reply With Quote
  #3  
Old 10-24-2011, 09:58 PM
steven s's Avatar
steven s steven s is offline
 
Join Date: Aug 2004
Location: Greenville, SC
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kh99 View Post
What do you mean by standalone, exactly? Can it be a "vb powered" page? If so you can probably use this: https://vborg.vbsupport.ru/showthread.php?t=228112 . I don't think you need the ob_start/ob_end_clean calls. You may need a template with the header and footer if you want to include those things on the page.
I don't want it to be a vB powered page.
I simply need it to run as a webpage outside of vBulletin.
I want to use the query to insert into an email.
So the query needs to run and create a webpage.
Reply With Quote
  #4  
Old 10-25-2011, 11:28 PM
steven s's Avatar
steven s steven s is offline
 
Join Date: Aug 2004
Location: Greenville, SC
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have this so far.
PHP Code:
<?

$host = '';
$databasename ='';
$user = '';
$pass = '';

$output_bits = '';
$today_m = date('m');
$today_y = date('Y');
$spacer = $today_m;




$linkID = mysql_connect($host, $user, $pass) or die('Could not connect to host.');
mysql_select_db($databasename, $linkID) or die('Could not find database.');


$get_schedule = mysql_query("
    SELECT *
    FROM vb_thread
    WHERE prefixid IN('Chapter_Event', 'other')
    ORDER BY UNIX_TIMESTAMP(STR_TO_DATE(LEFT(title, 10), '%m/%d/%Y')) ASC
");

    while($row = mysql_fetch_array($get_schedule))
{

    echo '<a target="_blank" href="showthread.php?t=' . $row['threadid'] . '">' . $row['title'] . '</a><br />';
}
Currently it outputs the thread titles with the thread prefix Chapter_Event or other.
Sample -> http://forum.nccbmwcca.org/testscript.php

What I want is to only output titles beginning with today and beyond.

I'm guessing it has something to do with the original code in my widget
PHP Code:
(strtotime(substr($schedule['title'], 010)) < (TIMENOW 86400)) 
Then I need a <hr> when the month changes.
The widget code is in post 1.

--------------- Added [DATE]1319672786[/DATE] at [TIME]1319672786[/TIME] ---------------

Not purposely bumping my own thread.

I stumbled on how to add <hr> between months to work.
Now to figure how to display only those thread titles beginning with today's date (MM/DD/YYYY) and beyond..
PHP Code:
<?

$host = '';
$databasename ='';
$user = '';
$pass = '';

$output_bits = '';
$today_m = date('m');
$today_y = date('Y');
$spacer = $today_m;




$linkID = mysql_connect($host, $user, $pass) or die('Could not connect to host.');
mysql_select_db($databasename, $linkID) or die('Could not find database.');


$get_schedule = mysql_query("
    SELECT *
    FROM vb_thread
    WHERE prefixid IN('Chapter_Event', 'other')
    ORDER BY UNIX_TIMESTAMP(STR_TO_DATE(LEFT(title, 10), '%m/%d/%Y')) ASC
");

    while($row = mysql_fetch_array($get_schedule))
    
    
{
    if (strtotime(substr($row['title'], 0, 10)) < (TIMENOW - 86400))
    {
        continue;
    }

    $str = substr($row['title'], 0, 2); // get month of event to add space between months

    if ($str == $spacer)
    {
        echo '<a target="_blank" href="showthread.php?t=' . $row['threadid'] . '">' . $row['title'] . '</a><br />';
    }
    else
    {
        echo '<hr><a target="_blank" href="showthread.php?t=' . $row['threadid'] . '">' . $row['title'] . '</a><br />';
    }
    $spacer = $str;
}
--------------- Added [DATE]1319674807[/DATE] at [TIME]1319674807[/TIME] ---------------

I think I got it.

TIMENOW must be a vBulletin variable.
I substituted TIMENOW for TIME() and it appears to be working.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08189 seconds
  • Memory Usage 2,213KB
  • 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
  • (4)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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