cleck673
10-20-2006, 03:37 PM
I am clueless on this. I have a program that I run along side vBulletin that I have integrated commenting into the forums for. This uses ezSQL to pass the data from one db to another.
What I need is to add this to my header:
<?php
// Include ezSQL in order to use it..
include_once '/home/mobility/domain.com/ez_sql.php';
$vb_db_prefix = '<MTVBDBPrefix>';
$vb_reply_abc = '<MTVBForumURL>'.'showthread.php?t=';
$vb_reply_xyz = '&goto=newpost';
?>
And this where I need it displayed in my template.
<?php
$vb_thread_id = <MTVBThreadID>;
$vb_reply_cnt = $db->get_var("SELECT count(*)-1 FROM {$vb_db_prefix}post WHERE threadid = '$vb_thread_id'");
$vb_reply_url = $vb_reply_abc.$vb_thread_id.$vb_reply_xyz;
?>
and
<?php
$vb_thread_id = <MTVBThreadID>;
$vb_reply_cnt = $db->get_var("SELECT count(*)-1 FROM {$vb_db_prefix}post WHERE threadid = '$vb_thread_id'");
$vb_reply_url = $vb_reply_abc.$vb_thread_id.$vb_reply_xyz;
if ($vb_thread_id) {
?>
| <a href="<?php echo $vb_reply_url; ?>">Comments (<?php echo $vb_reply_cnt; ?>)</a>
<?php
} else {
?>
<MTIfCommentsActive>| <a href="<$MTEntryPermalink$>#comments">Comments (<$MTEntryCommentCount$></a></MTIfCommentsActive>
<?php
}
?>
This works great on the static pages that I build with the application.
What is happening if I add these to the header and templates now is the code is shown with some stuff stripped.
Signed,
Clueless
What I need is to add this to my header:
<?php
// Include ezSQL in order to use it..
include_once '/home/mobility/domain.com/ez_sql.php';
$vb_db_prefix = '<MTVBDBPrefix>';
$vb_reply_abc = '<MTVBForumURL>'.'showthread.php?t=';
$vb_reply_xyz = '&goto=newpost';
?>
And this where I need it displayed in my template.
<?php
$vb_thread_id = <MTVBThreadID>;
$vb_reply_cnt = $db->get_var("SELECT count(*)-1 FROM {$vb_db_prefix}post WHERE threadid = '$vb_thread_id'");
$vb_reply_url = $vb_reply_abc.$vb_thread_id.$vb_reply_xyz;
?>
and
<?php
$vb_thread_id = <MTVBThreadID>;
$vb_reply_cnt = $db->get_var("SELECT count(*)-1 FROM {$vb_db_prefix}post WHERE threadid = '$vb_thread_id'");
$vb_reply_url = $vb_reply_abc.$vb_thread_id.$vb_reply_xyz;
if ($vb_thread_id) {
?>
| <a href="<?php echo $vb_reply_url; ?>">Comments (<?php echo $vb_reply_cnt; ?>)</a>
<?php
} else {
?>
<MTIfCommentsActive>| <a href="<$MTEntryPermalink$>#comments">Comments (<$MTEntryCommentCount$></a></MTIfCommentsActive>
<?php
}
?>
This works great on the static pages that I build with the application.
What is happening if I add these to the header and templates now is the code is shown with some stuff stripped.
Signed,
Clueless