Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page php/sql as the header
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2007, 10:41 AM
Hexelon Hexelon is offline
 
Join Date: Oct 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default php/sql as the header
I want to replace the standard header with a custom one, how would I get this to work in the header.

PHP Code:
<?php

 include ("config.php");

     $gi = mysql_query("SELECT * FROM `gameinfo`");
     while($gameinfo = mysql_fetch_object($gi)) {

echo"<div id='topstrip'>
<table class='sborder' cellpadding='4' cellspacing='0' width='965px'>

<tr>
<td height='20px' width='750px'></td>
<td height='20px' width='5px'></td>
<td height='20px' width='180px'></td>
<td height='20px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='maplineleft' width='5px'></td>
<td class='mapline' width='180px'>Map: $gameinfo->map</td>
<td class='maplineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='gdilineleft' width='5px'></td>
<td class='gdiline' width='180px'><a href='#'>GDI: $gameinfo->gdi - $gameinfo->gdiscore points</a></td>
<td class='gdilineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='nodlineleft' width='5px'></td>
<td class='nodline' width='180px'><a href='#'>Nod: $gameinfo->nod - $gameinfo->nodscore points</a></td>
<td class='nodlineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='infolineleft' width='5px'></td>
<td class='infoline' width='180px'>Time: $gameinfo->timeleft SFPS: $gameinfo->sfps</td>
<td class='infolineright' width='20px'></td>
</tr>
</table>
</div>";
}
?>
This is what I have tried so far with no luck:

I make a plugin called gameinfo

PHP Code:
include ("status.config.php");

     $gi = mysql_query("SELECT * FROM `gameinfo`");
     while($gameinfo = mysql_fetch_object($gi)) {
} 
I made a template called gameinfo_template

HTML Code:
<table class='sborder' cellpadding='4' cellspacing='0' width='965px'>

<tr>
<td height='20px' width='750px'></td>
<td height='20px' width='5px'></td>
<td height='20px' width='180px'></td>
<td height='20px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='maplineleft' width='5px'></td>
<td class='mapline' width='180px'>Map: $gameinfo->map</td>
<td class='maplineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='gdilineleft' width='5px'></td>
<td class='gdiline' width='180px'><a href='#'>GDI: $gameinfo->gdi - $gameinfo->gdiscore points</a></td>
<td class='gdilineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='nodlineleft' width='5px'></td>
<td class='nodline' width='180px'><a href='#'>Nod: $gameinfo->nod - $gameinfo->nodscore points</a></td>
<td class='nodlineright' width='20px'></td>
</tr>
<tr>
<td height='5px' width='750px'></td>
<td height='5px' width='5px'></td>
<td height='5px' width='180px'></td>
<td height='5px' width='20px'></td>
</tr>
<tr>
<td class='statusspacer' width='750px'></td>
<td class='infolineleft' width='5px'></td>
<td class='infoline' width='180px'>Time: $gameinfo->timeleft SFPS: $gameinfo->sfps</td>
<td class='infolineright' width='20px'></td>
</tr>
</table>
and in the header I put

HTML Code:
<div id='topstrip'>
$gameinfo_template
</div>
Reply With Quote
  #2  
Old 01-29-2007, 12:53 PM
Eric's Avatar
Eric Eric is offline
 
Join Date: May 2006
Location: Kentucky
Posts: 792
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Try

Plugin:
PHP Code:
include('./status.config.php');
//$gi = $db->query_read("SELECT * FROM gameinfo");
$gameinfo = $db->query_first("SELECT * FROM gameinfo");

eval('$gameinfo_template = "' . fetch_template('gameinfo_template') . '";'); 
gameinfo_template
HTML Code:
<table class='sborder' cellpadding='4' cellspacing='0' width='965px'>
<tbody>
<tr>
    <td height='20px' width='750px'></td>
    <td height='20px' width='5px'></td>
    <td height='20px' width='180px'></td>
    <td height='20px' width='20px'></td>
</tr>
<tr>
    <td class='statusspacer' width='750px'></td>
    <td class='maplineleft' width='5px'></td>
    <td class='mapline' width='180px'>Map: $gameinfo[map]</td>
    <td class='maplineright' width='20px'></td>
</tr>
<tr>
    <td height='5px' width='750px'></td>
    <td height='5px' width='5px'></td>
    <td height='5px' width='180px'></td>
    <td height='5px' width='20px'></td>
</tr>
<tr>
    <td class='statusspacer' width='750px'></td>
    <td class='gdilineleft' width='5px'></td>
    <td class='gdiline' width='180px'><a href='#'>GDI: $gameinfo[gdi] - $gameinfo[gdiscore] points</a></td>
    <td class='gdilineright' width='20px'></td>
</tr>
<tr>
    <td height='5px' width='750px'></td>
    <td height='5px' width='5px'></td>
    <td height='5px' width='180px'></td>
    <td height='5px' width='20px'></td>
</tr>
<tr>
    <td class='statusspacer' width='750px'></td>
    <td class='nodlineleft' width='5px'></td>
    <td class='nodline' width='180px'><a href='#'>Nod: $gameinfo[nod] - $gameinfo[nodscore] points</a></td>
    <td class='nodlineright' width='20px'></td>
</tr>
<tr>
    <td height='5px' width='750px'></td>
    <td height='5px' width='5px'></td>
    <td height='5px' width='180px'></td>
    <td height='5px' width='20px'></td>
</tr>
<tr>
    <td class='statusspacer' width='750px'></td>
    <td class='infolineleft' width='5px'></td>
    <td class='infoline' width='180px'>Time: $gameinfo[timeleft] SFPS: $gameinfo[sfps]</td>
    <td class='infolineright' width='20px'></td>
</tr>
</tbody>
</table>
Reply With Quote
  #3  
Old 01-29-2007, 08:30 PM
Hexelon Hexelon is offline
 
Join Date: Oct 2006
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thank you
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 07:24 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04645 seconds
  • Memory Usage 2,215KB
  • Queries Executed 11 (?)
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
  • (3)bbcode_html
  • (3)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_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