vb.org Archive - Table On Forumhome -- Filling it with PHP/SQL Data

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

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

- - Table On Forumhome -- Filling it with PHP/SQL Data (https://vborg.vbsupport.ru/showthread.php?t=175777)

Table On Forumhome -- Filling it with PHP/SQL Data

Hey guys. After trying to make this work in the header of my site, I have given up. It is making for a ton of alignment and sizing issues.

What I want to do now is have the PHP code make a new table and place it on the ForumHome page in line with the actual forums. Here is a mockup of what I am talking about:

http://img232.imageshack.us/img232/3503/examplewo0.jpg

The new table needs to have a column span of 2 because I want to seperate the loot winner and the actual name of the loot.

Here is my current code. I am using this as a plugin at the moment.

PHP Code:


		
			
$link = mysql_connect('localhost', '****', '****') or die('Could not connect: ' . mysql_error());



mysql_select_db('****') or die('Could not select database');



$query = 'SELECT item_buyer, item_name FROM eqdkp_items ORDER BY raid_id DESC LIMIT 0,7';



$result = mysql_query($query) or die('Query failed: ' . mysql_error());



echo "<table width=400px align=right>";

echo "<tr><th colspan=1 align=center><b><u>Latest Loots</u></b></th></tr>";



while (list($buyer, $item_name) = mysql_fetch_row($result)) {



$item_link = "[item]".$item_name."[/item]";



$myMessage = itemstats_parse($item_link);



echo ("<tr><td align=right>".$myMessage." <b>".$buyer."</b></td></tr>");



}



echo "</table>";



mysql_free_result($result);



mysql_close($link);

Any help would be appreciated.

Thanks.

If you can, give the mysql vb user access to your eqdkp_items table, you won't need to create another connection to your database.

Don't echo anything in your plugin. You should just use the template system.
So, put a variable in your FORUMHOME template, where you want your table to appear; let's call it $winners.

HTML Code:

<if condition="!empty($winners)">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tr><th colspan="2">Latest loot</th></tr>

$winners

</table>

</if>

Then, your plugin should look like this:

PHP Code:


		
			
$winners="";
$result = $vbulletin->db->query("SELECT item_buyer, item_name FROM YOUR_DB.eqdkp_items     ORDER BY raid_id DESC LIMIT 0,7")
while( list($buyer, $item_name) = $vbulletin->db->fetch_row($result) ){
    $item_link = "[item]".$item_name."[/item]";
    $myMessage = itemstats_parse($item_link); // want to parse bbcode ?
    $winners .= "<tr><td>".$buyer."</td><td>".$myMessage."</td></tr>";
}

Hook: forumhome_complete

$winners will be replace by its value during fetch_template('FORUMHOME') in index.php

Quote:

Originally Posted by lithrel (Post 1488373)

If you can, give the mysql vb user access to your eqdkp_items table, you won't need to create another connection to your database.

How do I go about this?

Thank you very much for your help.

On phpmyadmin, privileges => edit the user used by your forum
see 'Database-specific privileges'
Select the database that contain your eqdkp_items table, and give SELECT right on the database or the table.

edit: just added YOUR_DB before the table name in the sql query, don't forget to change it

If the table is in the same database as your vbulletin, you don't need to worry about giving the MySQL user access to the table.

X vBulletin 3.8.12 by vBS Debug 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_html_printable (2)bbcode_php_printable (1)bbcode_quote_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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01177 seconds Memory Usage 1,739KB 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_html_printable (2)bbcode_php_printable (1)bbcode_quote_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: