okay, i have successfully modified my fields and forms and can proceed with listing, however, i am stuck with the rating portion as
the rating is not working for me
include "header.php";
include_once XOOPS_ROOT_PATH."/class/module.errorhandler.php";
$myts =& MyTextSanitizer::getInstance(); // MyTextSanitizer object
if (!empty($HTTP_POST_VARS['submit'])) {
$eh = new ErrorHandler; //ErrorHandler object
if(empty($xoopsUser)){
$ratinguser = 0;
}else{
$ratinguser = $xoopsUser->getVar('uid');
}
//Make sure only 1 anonymous from an IP in a single day.
$anonwaitdays = 1;
$ip = getenv("REMOTE_ADDR");
$lid = intval($HTTP_POST_VARS['lid']);
$cid = intval($HTTP_POST_VARS['cid']);
$rating = intval($HTTP_POST_VARS['rating']);
// Check if Rating is Null
if ($rating=="--") {
redirect_header("ratelink.php?cid=".$cid."&lid=".$lid."",4,_MD_NORATING);
exit();
}
// Check if Link POSTER is voting (UNLESS Anonymous users allowed to post)
if ($ratinguser != 0) {
$result=$xoopsDB->query("select submitter from ".$xoopsDB->prefix("xdir_links")." where lid=$lid");
while(list($ratinguserDB) = $xoopsDB->fetchRow($result)) {
if ($ratinguserDB == $ratinguser) {
redirect_header("index.php",4,_MD_CANTVOTEOWN);
exit();
}
}
// Check if REG user is trying to vote twice.
$result=$xoopsDB->query("select ratinguser from ".$xoopsDB->prefix("xdir_votedata")." where lid=$lid");
while(list($ratinguserDB) = $xoopsDB->fetchRow($result)) {
if ($ratinguserDB == $ratinguser) {
redirect_header("index.php",4,_MD_VOTEONCE2);
exit();
}
}
} else {
// Check if ANONYMOUS user is trying to vote more than once per day.
$yesterday = (time()-(86400 * $anonwaitdays));
$result=$xoopsDB->query("select count(*) FROM ".$xoopsDB->prefix("xdir_votedata")." WHERE lid=$lid AND ratinguser=0 AND ratinghostname = '$ip' AND ratingtimestamp > $yesterday");
list($anonvotecount) = $xoopsDB->fetchRow($result);
if ($anonvotecount > 0) {
redirect_header("index.php",4,_MD_VOTEONCE2);
exit();
}
}
if($rating > 10){
$rating = 10;
}
//All is well. Add to Line Item Rate to DB.
$newid = $xoopsDB->genId($xoopsDB->prefix("xdir_votedata")."_ratingid_seq");
$datetime = time();
$sql = sprintf("INSERT INTO %s (ratingid, lid, ratinguser, rating, ratinghostname, ratingtimestamp) VALUES (%u, %u, %u, %u, '%s', %u)", $xoopsDB->prefix("xdir_votedata"), $newid, $lid, $ratinguser, $rating, $ip, $datetime);
$xoopsDB->query($sql) or $eh->show("0013");
//All is well. Calculate Score & Add to Summary (for quick retrieval & sorting) to DB.
updaterating($lid);
$ratemessage = _MD_VOTEAPPRE."".sprintf(_MD_THANKURATE,$xoopsConfig[sitename]);
redirect_header("index.php",2,$ratemessage);
exit();
} else {
$xoopsOption['template_main'] = 'xdir_ratelink.html';
include XOOPS_ROOT_PATH."/header.php";
$lid = intval($_GET['lid']);
$cid = intval($_GET['cid']);
$result=$xoopsDB->query("select title from ".$xoopsDB->prefix("xdir_links")." where lid=$lid");
list($title) = $xoopsDB->fetchRow($result);
$xoopsTpl->assign('link', array('id' => $lid, 'cid' => $cid, 'title' => $myts->htmlSpecialChars($title)));
$xoopsTpl->assign('lang_voteonce', _MD_VOTEONCE);
$xoopsTpl->assign('lang_ratingscale', _MD_RATINGSCALE);
$xoopsTpl->assign('lang_beobjective', _MD_BEOBJECTIVE);
$xoopsTpl->assign('lang_donotvote', _MD_DONOTVOTE);
$xoopsTpl->assign('lang_rateit', _MD_RATEIT);
$xoopsTpl->assign('lang_cancel', _CANCEL);
//Smarty directory autodetect
$smartydir = $xoopsModule->getVar('dirname');
$xoopsTpl->assign('smartydir', $smartydir);
include XOOPS_ROOT_PATH.'/footer.php';
}
?>
may i know which code to change as the values are not added to db after i click rate!
