Codezwiz >> Forums >> General PHP Nuke Help >> MS-Analysis1.php - need a little help with this block please

Register

Hi,

I've been trying to create a scrolling block based on MS-Analysis1.php (the block that displays the countries).

I have it working, but can't get the FLAGS to display - sure I'm missing something really stupid, but I can't see it.

Here's the block:

<<< Begin block >>>
<?php
$maxshow = 24; // # of Countries

if (eregi("block-ScrollCountries.php",$_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $db;
$show = "";
$a = 1;
$result = $db->sql_query( "select domain, description, hits from $prefix"._msanalysis_countries." order by hits DESC LIMIT 0,$maxshow");
$flag = "modules/$module_name/images/flags/$domain".".gif";
while(list($lid, $title, $hits, $flag) = $db->sql_fetchrow($result)) {
$title2 = ereg_replace("_", " ", $title);
$show .= "$domain$title2</a><br> Visits $hits<br>";
//$show .="$flag".".gif";
$a++;
}
$content = "<A name= \"scrollingCountries\"></A>\n";
$content .= "<MARQUEE behavior= \"scroll\" align=\"right\" direction= \"down\" height=\"320\" scrollamount= \"3\" scrolldelay= \"90\" onmouseover='this.stop()' onmouseout='this.start()'>\n";
$content .= "$show";
$content .= "</marquee>\n";

?>

<<< end block >>>>

If someone could take a peek and maybe get the flags to display BEFORE the country's name, I'd appreciate it.

Forgot - If you look at the block - would you mind ADDING a line for a BACKGROUND color? My default block background is white, and that causes many .GIFs to "wash out".

Thanks again -

Theres a few things I see

1. $module_name -- needs to be added to the globals.
2. while(list($lid, $title, $hits, $flag) -- You have to define $domain in this as well so something like-- while(list($lid, $domain, $title, $hits, $flag)
3. Move the $flag= "modules/$module_name/images/flags/$domain".".gif"; to under the while(list
4. $show = ""; cant use that twice.
5. select domain, description, hits your selecting this but listing this-- list($lid, $domain, $title, $hits, $flag

Can you attach a copy of the structure for
_msanalysis_countries.

Register

I think I followed your instructions.

The complete path to the FLAGS:
mindvacant.com/php/html/modules/MS_Analysis/images/flags/*.gif

I'm know I'm doing something wrong with the $FLAG variable, because I can get the others to scroll by removing one then another.

Thanks for your time,

FIle after applying Telli's tips:

<?php
$maxshow = 200; // # of Countries

if (eregi("block-ScrollCountriesTest.php",$_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $db, $domain, $flag;
$show = "";
$a = 1;
$result = $db->sql_query( "select domain, description, hits from $prefix"._msanalysis_countries." order by hits DESC LIMIT 0,$maxshow");
//while(list($lid,$domain,$title,$hits,$flag) = $db->sql_fetchrow($result)) {
while(list($lid,$title,$domain,$flag) = $db->sql_fetchrow($result)) {
$flag = "modules/$module_name/images/flags/$domain".".gif";
// $flag = "modules/MS_Analysis/images/flags/$domain".".gif";
$title2 = ereg_replace("_", " ",$title);
$show .= "$title2</a><br>";
$a++;
}
$content = "<A name= \"scrollingCountries\"></A>\n";
$content .= "<MARQUEE behavior= \"scroll\" align=\"right\" direction= \"up\" height=\"320\" scrollamount= \"3\" scrolldelay= \"90\" onmouseover='this.stop()' onmouseout='this.start()'>\n";
$content .= "$show";
$content .= "</marquee>\n";

?>

$result = $db->sql_query( "select domain, description, hits from $prefix"._msanalysis_countries." order by hits DESC LIMIT 0,$maxshow"

Should be

$result = $db->sql_query( "select lid, domain, title, hits from $prefix"._msanalysis_countries." order by hits DESC LIMIT 0,$maxshow"

You should use something like this for the flags.

// Determine Location for Flag image
$FlagResult = sql_query( "select flag from $prefix"._msanalysis_countries." order by hits DESC LIMIT 0,$maxshow";
$FlagInfo = sql_fetch_array( $FlagResult, $dbi );
$FlagPathFile = $FlagPath.$FlagInfo;