1
hi guys,
i've got a notifications hack which doesn't work giving a blank page. here is the part of it:
//notifications hack
...
$uids = array();
$sql = "SELECT DISTINCT uid FROM ".$xoopsDB->prefix("groups_users_link")." WHERE groupid = 6";
$result = $xoopsDB->query($sql);
while($row = $xoopsDB->fetchArray($result)) {
$uids[] = $row['uid'];
}
...
the debug says
Notice: Undefined variable: xoopsDB in file /modules/catads/admin/adsmod.php line 159
the 159 line is
$sql = "SELECT DISTINCT uid FROM ".$xoopsDB->prefix("groups_users_link")." WHERE groupid = 6";
$result = $xoopsDB->query($sql);
any idea how to fix this?
thanks in advance!
Mind anchors