latest blocks on right columns

Thanks!

latest blocks on right columns

$block_downloads .= "- <a href="https://www.contentteller.com/download.php?det=$insert[download_id]">$insert[download_title]</a><br />"; 

should be:

$block_downloads .= "- <a href="https://www.contentteller.com/download.php?det=$data[download_id]">$data[download_title]</a><br />"; 

latest blocks on right columns

Hi. I'm trying to set up a top 10 downloads in the left side column using info from this thread. my site_header template looks like this,

<?php
global $insert;
dbconnect();
$block_downloads = "";
$result = DBQuery("SELECT * FROM esselbach_st_downloads WHERE download_hook = '0' LIMIT 10");
while ($data = mysql_fetch_array($result))
{
$block_downloads .= "- <a href="https://www.contentteller.com/download.php?det=$insert[download_id]">$insert[download_title]</a><br />";
}
$EST_TEMPLATE = <<<TEMPLATE
<!-- Template site_header -->

and i added $block_downloads to the html section of site_header where i want it be but all that is showing up is the individual dashes for the listings. what am i doing wrong here? thanks

latest blocks on right columns

For the forums try the following:

$block_forums = "";

$bbdata = BBGetTopics();

                for($t = 0; $t < count($bbdata); $t++)

                {

                    $datasplit = explode("||~||", $bbdata[$t]);

$block_forums .= "- <a href="https://www.contentteller.com/$datasplit[0]">$datasplit[1]</a><br />"; 

                }

                dbconnect();

and $block_forums in the HTML part.

latest blocks on right columns

Perfect!!

latest blocks on right columns

Here an example for reviews, news and downloads. Forums will follow later.

Add in the PHP part of site_footer the following:

dbconnect();

$block_review = "";

$result = DBQuery("SELECT * FROM esselbach_st_review WHERE review_hook = '0' AND review_page = '1' LIMIT 10");

while ($data = mysql_fetch_array($result))

{

$block_review .= "- <a href="https://www.contentteller.com/review.php?id=$data[review_id]">$data[review_title]</a><br />";

}



$block_news = "";

$result = DBQuery("SELECT * FROM esselbach_st_stories WHERE story_hook = '0' LIMIT 10");

while ($data = mysql_fetch_array($result))

{

$block_news .= "- <a href="https://www.contentteller.com/story.php?id=$data[story_id]">$data[story_title]</a><br />";

}



$block_downloads = "";

$result = DBQuery("SELECT * FROM esselbach_st_downloads WHERE download_hook = '0' LIMIT 10");

while ($data = mysql_fetch_array($result))

{

$block_downloads .= "- <a href="https://www.contentteller.com/download.php?det=$insert[download_id]">$insert[download_title]</a><br />";

}

Now you can use $block_review, $block_news, and $block_downloads in the HTML part of the template.

latest blocks on right columns

forum, reviews, news and downloads

latest blocks on right columns

Yes, everything is possible. Which block like you display on the right side?

latest blocks on right columns

is possible to do that?

latest blocks on right columns

Not without some heavy modifications.