cory_booth
01-21-2010, 12:20 AM
I am working on a widget.
The widget is based on several examples on the net that render a slideshow for articles.
The widget works like this site: http://demo.webdeveloperplus.com/featured-content-slider/
The problem I have is reading the data from the database. I am turning all parsing to false (no bbcode) but it leaves things like in the output.
If I render the HTML or BBCode, my output is uncontrollable - especially for the cut off where the cutoff could happen in the middle of a tag and cause errors.
Is there a method to remove the [ATTACH] [HTML] [IMG] tags when they are not rendered as BBCode? I was thinking kind along the lines as the email output and/or archive output.
Oh and any improvements to the code I would be gratefull!
<style>
#featured{
width:400px;
padding-right:150px;
position:relative;
border:5px solid #ccc;
height:250px;
background:#fff;
}
#featured ul.ui-tabs-nav{
position:absolute;
top:0; left:400px;
list-style:none;
padding:0; margin:0;
width:150px;
}
#featured ul.ui-tabs-nav li{
padding:1px 0; padding-left:13px;
font-size:12px;
color:#666;
}
#featured ul.ui-tabs-nav li img{
float:left; margin:2px 5px;
background:#fff;
padding:2px;
border:1px solid #eee;
}
#featured ul.ui-tabs-nav li span{
font-size:9px; font-family:Verdana;
line-height:18px;
}
#featured li.ui-tabs-nav-item a{
display:block;
height:60px;
color:#333; background:#fff;
line-height:20px;
}
#featured li.ui-tabs-nav-item a:hover{
background:#f2f2f2;
}
#featured li.ui-tabs-selected{
background:url('images/selected-item.gif') top left no-repeat;
}
#featured ul.ui-tabs-nav li.ui-tabs-selected a{
background:#ccc;
}
#featured .ui-tabs-panel{
width:400px;
height:250px;
background:#999; position:relative;
}
#featured .ui-tabs-panel .info{
position:absolute;
top:180px; left:0;
height:70px;
background: url('images/transparent-bg.png');
color:#fff;
}
#featured .info h2{
font-size:18px; font-family:Georgia, serif;
color:#fff; padding:5px; margin:0;
overflow:hidden;
}
#featured .info p{
margin:0 5px;
font-family:Verdana; font-size:11px;
line-height:15px; color:#f0f0f0;
}
#featured .info a{
text-decoration:none;
color:#fff;
}
#featured .info a:hover{
text-decoration:underline;
}
#featured .ui-tabs-hide{
display:none;
}
</style>
<!-- jQuery - Rotating Code -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.5.3/jquery-ui.min.js" ></script>
<!-- Rotating Code -->
<script type="text/javascript">
$(document).ready(function(){
$("#featured > ul").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
});
</script>
<!-- / Rotating Code -->
<?php
$curdir = getcwd ();
chdir('/home/xxxxx/public_html');
global $db,$vbulletin,$sess, $std, $INFO, $vboptions, $session, $bbcode;
// vBulletin: Parse BBCode
if (!is_object($bbcode_parser)){
require_once('http://xxxxx.com/includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
}
$forumid = array(184,149); // Set forum IDs here.
$limit = '2'; // Limit the displayed slides
$chars = 120; // Character limit for the slide text, e.g. 100 is 100 characters limit.
$words = 20; // Word limit for the slide text, e.g. 20 is 20 words limit
/* ------------------------------ NOTHING TO CHANGE BELOW THIS LINE ------------------------------ */
// Start loop
$forumid = implode(',',$forumid);
$getnews = $db->query_read("SELECT threadid from ".TABLE_PREFIX."thread WHERE attach !='0' AND forumid in($forumid) ORDER by sticky DESC, threadid DESC LIMIT $limit");
while ($news = $db->fetch_array($getnews)) {
$myid[]=$news['threadid'];
}
$tabhtml="";
$contenthtml="";
$div_id = 1;
if ($myid) {
foreach ($myid as $threadid) {
$getpics = $db->query_read("SELECT t.threadid as tid, t.title as title,t.replycount as rcount, p.pagetext as pagetext,a.attachmentid as attach,f.forumid as forumid,f.title as forum from ".TABLE_PREFIX."thread as t
LEFT JOIN ".TABLE_PREFIX."post as p on(t.firstpostid=p.postid)
LEFT JOIN ".TABLE_PREFIX."attachment as a on(a.contentid=p.postid)
LEFT JOIN ".TABLE_PREFIX."forum as f on(t.forumid=f.forumid)
where t.threadid='$threadid'
ORDER BY attach DESC
LIMIT 1");
while ($pic = $db->fetch_array($getpics)) {
$replies=$pic['rcount'];
if ($replies=='1') {
$update="- (1 update)";
} elseif ($replies>'1') {
$update="- ($replies updates)";
} else {
$update="";
}
$pic['pagetext'] = $bbcode_parser->do_parse($pic['pagetext'],false,false,false,false,false,false);
$link = "../showthread.php?t=".$threadid."";
$imagepath = "../attachment.php?attachmentid=".$pic['attach'];
$titleContent = ucwords($pic['title']);
$introtext = $pic['pagetext'];
// clean images
$introtext = preg_replace("/<img.+?>/", "", $introtext);
// HTML cleanup
if ($striptags) {
$introtext = strip_tags($introtext, $allowed_tags);
}
// if character limitation is defined
if ($chars) {
if(function_exists("mb_string")) {
$introtext = mb_substr($introtext, 0, $chars).'...';
} else {
$introtext = substr($introtext, 0, $chars).'...';
}
}
// if word limitation is defined
if ($words) {
$word_arr = str_word_count($introtext, 2);
$c = 0;
foreach ($word_arr AS $k => $v) {
if ($c == $words) {
if(function_exists("mb_string")) {
$introtext = mb_substr($introtext, 0, $k).'...';
} else {
$introtext = substr($introtext, 0, $k).'...';
}
break;
}
$c++;
}
}
$tabhtml .= "<li class='ui-tabs-nav-item' id='nav-fragment-".$div_id."'><a href='#fragment-".$div_id."'>";
$tabhtml .="<img src='".$imagepath."' height='25px' width='40px' alt='' />";
$tabhtml .="<span class=''>".$titleContent." ".$update."</span></a></li>";
$centerhtml .="<div id='fragment-".$div_id."' class='ui-tabs-panel' style=''>";
$centerhtml .="<img src='".$imagepath."' alt=''/>";
$centerhtml .="<div class='info'>";
$centerhtml .="<h2><a href='#'>".$titleContent."</a></h2>";
$centerhtml .="<p>".$introtext."</p></div></div>";
$div_id++;
}
}
$db->free_result($getpics);
unset($pic);
$db->free_result($getnews);
unset($news);
// End loop
$tabhtml = "<div id=\"featured\"><ul class=\"ui-tabs-nav\">".$tabhtml."</ul>";
echo $tabhtml.$centerhtml."</div>";
}
?>
The widget is based on several examples on the net that render a slideshow for articles.
The widget works like this site: http://demo.webdeveloperplus.com/featured-content-slider/
The problem I have is reading the data from the database. I am turning all parsing to false (no bbcode) but it leaves things like in the output.
If I render the HTML or BBCode, my output is uncontrollable - especially for the cut off where the cutoff could happen in the middle of a tag and cause errors.
Is there a method to remove the [ATTACH] [HTML] [IMG] tags when they are not rendered as BBCode? I was thinking kind along the lines as the email output and/or archive output.
Oh and any improvements to the code I would be gratefull!
<style>
#featured{
width:400px;
padding-right:150px;
position:relative;
border:5px solid #ccc;
height:250px;
background:#fff;
}
#featured ul.ui-tabs-nav{
position:absolute;
top:0; left:400px;
list-style:none;
padding:0; margin:0;
width:150px;
}
#featured ul.ui-tabs-nav li{
padding:1px 0; padding-left:13px;
font-size:12px;
color:#666;
}
#featured ul.ui-tabs-nav li img{
float:left; margin:2px 5px;
background:#fff;
padding:2px;
border:1px solid #eee;
}
#featured ul.ui-tabs-nav li span{
font-size:9px; font-family:Verdana;
line-height:18px;
}
#featured li.ui-tabs-nav-item a{
display:block;
height:60px;
color:#333; background:#fff;
line-height:20px;
}
#featured li.ui-tabs-nav-item a:hover{
background:#f2f2f2;
}
#featured li.ui-tabs-selected{
background:url('images/selected-item.gif') top left no-repeat;
}
#featured ul.ui-tabs-nav li.ui-tabs-selected a{
background:#ccc;
}
#featured .ui-tabs-panel{
width:400px;
height:250px;
background:#999; position:relative;
}
#featured .ui-tabs-panel .info{
position:absolute;
top:180px; left:0;
height:70px;
background: url('images/transparent-bg.png');
color:#fff;
}
#featured .info h2{
font-size:18px; font-family:Georgia, serif;
color:#fff; padding:5px; margin:0;
overflow:hidden;
}
#featured .info p{
margin:0 5px;
font-family:Verdana; font-size:11px;
line-height:15px; color:#f0f0f0;
}
#featured .info a{
text-decoration:none;
color:#fff;
}
#featured .info a:hover{
text-decoration:underline;
}
#featured .ui-tabs-hide{
display:none;
}
</style>
<!-- jQuery - Rotating Code -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.5.3/jquery-ui.min.js" ></script>
<!-- Rotating Code -->
<script type="text/javascript">
$(document).ready(function(){
$("#featured > ul").tabs({fx:{opacity: "toggle"}}).tabs("rotate", 5000, true);
});
</script>
<!-- / Rotating Code -->
<?php
$curdir = getcwd ();
chdir('/home/xxxxx/public_html');
global $db,$vbulletin,$sess, $std, $INFO, $vboptions, $session, $bbcode;
// vBulletin: Parse BBCode
if (!is_object($bbcode_parser)){
require_once('http://xxxxx.com/includes/class_bbcode.php');
$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
}
$forumid = array(184,149); // Set forum IDs here.
$limit = '2'; // Limit the displayed slides
$chars = 120; // Character limit for the slide text, e.g. 100 is 100 characters limit.
$words = 20; // Word limit for the slide text, e.g. 20 is 20 words limit
/* ------------------------------ NOTHING TO CHANGE BELOW THIS LINE ------------------------------ */
// Start loop
$forumid = implode(',',$forumid);
$getnews = $db->query_read("SELECT threadid from ".TABLE_PREFIX."thread WHERE attach !='0' AND forumid in($forumid) ORDER by sticky DESC, threadid DESC LIMIT $limit");
while ($news = $db->fetch_array($getnews)) {
$myid[]=$news['threadid'];
}
$tabhtml="";
$contenthtml="";
$div_id = 1;
if ($myid) {
foreach ($myid as $threadid) {
$getpics = $db->query_read("SELECT t.threadid as tid, t.title as title,t.replycount as rcount, p.pagetext as pagetext,a.attachmentid as attach,f.forumid as forumid,f.title as forum from ".TABLE_PREFIX."thread as t
LEFT JOIN ".TABLE_PREFIX."post as p on(t.firstpostid=p.postid)
LEFT JOIN ".TABLE_PREFIX."attachment as a on(a.contentid=p.postid)
LEFT JOIN ".TABLE_PREFIX."forum as f on(t.forumid=f.forumid)
where t.threadid='$threadid'
ORDER BY attach DESC
LIMIT 1");
while ($pic = $db->fetch_array($getpics)) {
$replies=$pic['rcount'];
if ($replies=='1') {
$update="- (1 update)";
} elseif ($replies>'1') {
$update="- ($replies updates)";
} else {
$update="";
}
$pic['pagetext'] = $bbcode_parser->do_parse($pic['pagetext'],false,false,false,false,false,false);
$link = "../showthread.php?t=".$threadid."";
$imagepath = "../attachment.php?attachmentid=".$pic['attach'];
$titleContent = ucwords($pic['title']);
$introtext = $pic['pagetext'];
// clean images
$introtext = preg_replace("/<img.+?>/", "", $introtext);
// HTML cleanup
if ($striptags) {
$introtext = strip_tags($introtext, $allowed_tags);
}
// if character limitation is defined
if ($chars) {
if(function_exists("mb_string")) {
$introtext = mb_substr($introtext, 0, $chars).'...';
} else {
$introtext = substr($introtext, 0, $chars).'...';
}
}
// if word limitation is defined
if ($words) {
$word_arr = str_word_count($introtext, 2);
$c = 0;
foreach ($word_arr AS $k => $v) {
if ($c == $words) {
if(function_exists("mb_string")) {
$introtext = mb_substr($introtext, 0, $k).'...';
} else {
$introtext = substr($introtext, 0, $k).'...';
}
break;
}
$c++;
}
}
$tabhtml .= "<li class='ui-tabs-nav-item' id='nav-fragment-".$div_id."'><a href='#fragment-".$div_id."'>";
$tabhtml .="<img src='".$imagepath."' height='25px' width='40px' alt='' />";
$tabhtml .="<span class=''>".$titleContent." ".$update."</span></a></li>";
$centerhtml .="<div id='fragment-".$div_id."' class='ui-tabs-panel' style=''>";
$centerhtml .="<img src='".$imagepath."' alt=''/>";
$centerhtml .="<div class='info'>";
$centerhtml .="<h2><a href='#'>".$titleContent."</a></h2>";
$centerhtml .="<p>".$introtext."</p></div></div>";
$div_id++;
}
}
$db->free_result($getpics);
unset($pic);
$db->free_result($getnews);
unset($news);
// End loop
$tabhtml = "<div id=\"featured\"><ul class=\"ui-tabs-nav\">".$tabhtml."</ul>";
echo $tabhtml.$centerhtml."</div>";
}
?>