1
why the hell isnt it working?
i want to realise a ignorelist for the pm system.
$ignore = $xoopsDB->query("SELECT * FROM ".$xoopsDB->prefix("users_ignore")." WHERE uid=$uid AND ignore_uid=".$row->from_userid);
if ($xoopsDB->getRowsNum($ignore) > 0) {
$delete = mysql_query("DELETE FROM ".$xoopsDB->prefix("priv_msgs")." WHERE msg_id=".$row->msg_id);
$update = $xoopsDB->query("SELECT msg_id FROM ".$xoopsDB->prefix("priv_msgs_backup")." WHERE from_userid=".$row->from_userid." AND to_userid=$uid AND msg_time=".$row->msg_time);
$updaterow = mysql_fetch_array($update);
$updatenow = mysql_query("UPDATE ".$xoopsDB->prefix("priv_msgs_backup")." SET ignore_msg=1 WHERE msg_id=".$updaterow->msg_id);
} else {
echo "openWithSelfMain('".XOOPS_URL."/modules/system/showpn.php?msg_id=".$row->msg_id."', 'showpn".$i."', 550, 400);";
$i++;
}
$updaterow->msg_id is allways '' but when i check the result with phpmyadmin there MUST be a result
