73
i'm trying to change the lykos randompartners block to do this... but it just isn't working... i don't know php and just tried to change everything as i thought was needed...
Here is what i have ->
function b_lykos_blocks_random_mydownloads_show(){
global $xoopsDB;
$myts =& MyTextSanitizer::getInstance();
$block = array();
$block['title'] = _MI_LYKOS_BLOCKS_B1_TITLE;
$result = $xoopsDB->query("SELECT lid, cid, title FROM ".$xoopsDB->prefix("mydownloads_downloads")." ORDER BY RAND()");
$block['content'] = "<div align=\"center\">";
while (list($lid,$title) = $xoopsDB->fetchRow($result)) {
$block['content'] .= "<a href='".XOOPS_URL."/modules/mydownloads/singlefile.php?lid=$num' target='_blank'>";
$block['content'] .= "$title">";
$block['content'] .= "</a><br />\n";
if ($options[0] == 1) {
$block['content'] .= "<br />\n";
}
break;
}
return $block;
}
?>
If anyone is able to help me... PLEEEEAAASE
thanks