Posted my index code, have a look see if you can see a prob
<?php
require_once('../../mainfile.php');
include_once ('../../header.php');
global $xoopsUser, $xoopsDB;
$tpl = new XoopsTpl();
if(!is_object($xoopsUser)) {
redirect_header(XOOPS_URL, 0, _NOPERM);
}
$sql = $xoopsDB->query("SELECT groupid FROM ".$xoopsDB->prefix('groups')." WHERE name='Affiliate'");
list($groupid) = $xoopsDB->fetchRow($sql);
$uid = $xoopsUser->getVar("uid");
$uname = $xoopsUser->getVar("uname");
$sql = $xoopsDB->query("SELECT payment FROM ".$xoopsDB->prefix('affiliate_perc')." WHERE payid=1");
list($payment) = $xoopsDB->fetchRow($sql);
$linkurl = substr(md5(uniqid(mt_rand(), 1)),0 ,8);
$tpl->append('affs', array(
'uid'=>$uid,
'uname'=>$uname,
'linkurl'=>$linkurl,
'payment'=>$payment,
'groupid'=>$groupid));
$tpl->display(XOOPS_ROOT_PATH . "/modules/affiliate/templates/affiliate_index.html");
include "../../footer.php";
Can you tell anything from this.
all permissions to the module have been set correctly
im using XOOPS 2.0.15 with the new form.php uploaded.
Thanks
Dave