cotonti.com : XSAffiliates, show more then 1 random image in index.tpl

Xerora

Mon, 31 Aug 2009 11:18:32 -0000

ooops looked over it too quick :p

DemptD

Mon, 31 Aug 2009 09:55:45 -0000

changed it to:

{XSAFF_IMAGES}

didnt work..

And with Xerora's modification the index wouldnt load

Kilandor

Mon, 31 Aug 2009 06:54:23 -0000

Th block shoulda been XSAFF not AFF Mine was fine => is only for when your using an array

Xerora

Mon, 31 Aug 2009 06:42:13 -0000

$sqlxsaff = sed_sql_query("SELECT * FROM $db_xsaff_aff WHERE aff_active='1' ORDER BY RAND() LIMIT 0,3");
while($rowxsaff = sed_sql_fetcharray($sqlxsaff))
{
	$t->assign("XSAFF_IMAGES" => "");
	$t->parse("MAIN.XSAFF");
}

Try that.

XSAFF_IMAGES wasn't getting assigned to anything in the previous post.

DemptD

Mon, 31 Aug 2009 04:08:10 -0000

i changed the number to 3 and did it like this in index.tpl:


{XSAFF_IMAGES}

Is that right? it didnt work, nothing showed up then.

Kilandor

Mon, 31 Aug 2009 03:28:05 -0000

$sqlxsaff = sed_sql_query("SELECT * FROM $db_xsaff_aff WHERE aff_active='1' ORDER BY RAND() LIMIT 0,NUM_YOU_WANT_TO_SHOW");
while($rowxsaff = sed_sql_fetcharray($sqlxsaff))
{
	$t->assign("XSAFF_IMAGES", "");
	$t->parse("MAIN.XSAFF");
}

Just change NUM_YOU_WANT_TO_SHOW to how many you want to see, and add a new block(begin/end) around the tag called XSAFF

DemptD

Sun, 30 Aug 2009 22:04:34 -0000

How can i do that?

Heres xsaff.index.php:

if (!defined('SED_CODE')) { die('Wrong URL.'); }
$sqlxsaff = sed_sql_query("SELECT * FROM $db_xsaff_aff WHERE aff_active='1' ORDER BY RAND() LIMIT 0,1");
$rowxsaff = sed_sql_fetcharray($sqlxsaff);

$t->assign("XSAFF_IMAGES", "");

?>