Support Forums - XOOPS Web Application System

Subject:* <
Name/Email:* <
Message Icon:* <
Select* <
Message:* <	xx-Small x-Small Small Medium Large x-Large xx-Large Arial Courier Georgia Helvetica Impact Verdana Haettenschweiler Black Blue Brown Green Grey Orange Paper Purple Red White Yellow Click the Preview to see the content in action.
Options:* <	Enable Smiley Enable Xoops Code
Confirmation Code* <	2 + 2 = ? Input the result from the expression Maximum attempts you can try: 10
* <

query("SELECT ratinguser FROM ".$xoopsDB->prefix("users_votedata")." WHERE uid=$uid"); while(list($ratinguserDB)=$xoopsDB->fetchRow($result)) { if ($ratinguserDB==$ratinguser) { redirect_header("userinfo.php?uid=$uid",4,_US_VOTEONCE); exit(); } } // Check if ANONYMOUS user is trying to vote more than once per day. if ($ratinguser==0){ $yesterday = (time()-(86400 * $anonwaitdays)); $result=$xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("users_votedata")." WHERE uid=$uid AND ratinguser=0 AND ratinghostname = '$ip' AND ratingtimestamp > $yesterday"); list($anonvotecount) = $xoopsDB->fetchRow($result); if ($anonvotecount >= 1) { redirect_header("userinfo.php?uid=$uid",4,_US_VOTEONCE); exit(); } } //All is well. Add to Line Item Rate to DB. $newid = $xoopsDB->genId("users_votedata_ratingid_seq"); $datetime = time(); $xoopsDB->query("INSERT INTO ".$xoopsDB->prefix("users_votedata")." (ratingid, uid, ratinguser, rating, ratinghostname, ratingtimestamp) VALUES ($newid, $uid, $ratinguser, $rating, '$ip', $datetime)") or $eh("0013"); //All is well. Calculate Score & Add to Summary (for quick retrieval & sorting) to DB. //updates rating data in itemtable for a given item $query = "select rating FROM ".$xoopsDB->prefix("users_votedata")." WHERE uid = $uid"; $voteresult = $xoopsDB->query($query); $votesDB = $xoopsDB->getRowsNum($voteresult); $totalrating = 0; while(list($rating)=$xoopsDB->fetchRow($voteresult)){ $totalrating += $rating; } $finalrating = $totalrating/$votesDB; $finalrating = number_format($finalrating, 4); $query = "UPDATE ".$xoopsDB->prefix("users")." SET rating=$finalrating, votes=$votesDB WHERE uid = $uid"; $xoopsDB->query($query); $ratemessage = _US_VOTEAPPRE."".sprintf(_US_THANKYOU,$xoopsConfig[sitename]); redirect_header("userinfo.php?uid=$uid",4,$ratemessage); exit(); } else { include(XOOPS_ROOT_PATH."/header.php"); OpenTable(); $result=$xoopsDB->query("SELECT uname FROM ".$xoopsDB->prefix("users")." WHERE uid=$uid"); list($uname) = $xoopsDB->fetchRow($result); $uname = $myts->makeTboxData4Show($uname); echo " $uname "._US_VOTEONCE." "._US_RATINGSCALE." "._US_BEOBJECTIVE." "._US_DONOTVOTE.""; echo " --"; for($i=10;$i>0;$i--){ echo "".$i."\n"; } echo ""; echo " \n"; echo ""; CloseTable(); } include XOOPS_ROOT_PATH."/footer.php"; ?> [/code] Create a newfiletexte ,paste all contents ,and rename it "user_rate.php" and send it in XOOPS racine (where is userinfo.php" 2 - Open userinfo.php and add this line just before "$gperm_handler" [code]//hack compteur de visite du profil $page = !empty($HTTP_GET_VARS['page']) ? trim($HTTP_GET_VARS['page']) : ''; if ($page != '') { $page = $HTTP_GET_VARS['page']; } else { $xoopsDB->queryF("update ".$xoopsDB->prefix("users")." set hits=hits+1 where uid=$uid "); } //fin du hack[/code] Add this both line after this line :$xoopsTpl->assign('lang_avatar', _US_AVATAR); [code]$xoopsTpl->assign('lang_ratethisuser', _US_RATETHISUSER); $xoopsTpl->assign('lang_votes', _US_VOTES); $xoopsTpl->assign('user_votes', $thisUser->getVar('votes')); $xoopsTpl->assign('lang_hits', _US_HITSC); $xoopsTpl->assign('user_hits', $thisUser->getVar('hits')); $rating = $thisUser->getVar("rating"); if (!empty($rating)) { $xoopsTpl->assign('user_rating', number_format($rating, 2)); } $xoopsTpl->assign('lang_ratingc', _US_RATINGC);[/code] 3 - Open kernel\user.php and add this 3 lines 108 [code] $this->initVar('votes', XOBJ_DTYPE_OTHER, null, false); $this->initVar('hits', XOBJ_DTYPE_OTHER, null, false); $this->initVar('rating', XOBJ_DTYPE_OTHER, null, false);[/code] 4 - Open language\english\user.php and add this lines at end [code]define("_US_VOTEAPPRE","Votre vote est apprécié."); define("_US_THANKYOU","Merci de prendre le temps pour votez pour un membre ici sur %s"); // %s is your site name define("_US_VOTEONCE","Merci de ne pas voter pour le même membre plus d'une fois."); define("_US_RATINGSCALE","L'échelle est 1 - 10, avec 1 étant faible et 10 étant excellent."); define("_US_BEOBJECTIVE","Merci d'être objectif, si tous reçoivent un 1 ou un 10, les notations ne sont pas très utiles."); define("_US_DONOTVOTE","Ne votez pas pour vous memes."); define("_US_RATEIT","Votez pour ce membre !"); define("_US_CANCEL","Annuler !"); define("_US_NORATING","Vous avez annuler le vote!");[/code] define in your language ,look in module mydownloads what is writting for example 5 - Open modules\system\template\system_userinfo.html and add this lines where you want this is vote button ,the best place is at beginning [code][/code] Remplace your table "statistics" by this table ,they will display usr visit statistics and user votes statistics now [code] [/code] 6 - The last operation ,before to beginning save your database ok go in your MySQL database ,click on "sql" and past this folder lines,and click on execute [code] ALTER TABLE `xoops_users` ADD `hits` int(11) NOT NULL default '0', ADD `rating` double(6,4) NOT NULL default '0.0000', ADD `votes` int(5) unsigned NOT NULL default '0', -- -- Structure de la table `xoops_users_votedata` -- CREATE TABLE `xoops_users_votedata` ( `ratingid` int(11) unsigned NOT NULL auto_increment, `uid` int(11) unsigned NOT NULL default '0', `ratinguser` int(11) NOT NULL default '0', `rating` tinyint(3) unsigned NOT NULL default '0', `ratinghostname` varchar(60) NOT NULL default '', `ratingtimestamp` int(10) NOT NULL default '0', PRIMARY KEY (`ratingid`), KEY `ratinguser` (`ratinguser`), KEY `ratinghostname` (`ratinghostname`), KEY `pid` (`uid`) ) ENGINE=MyISAM ; [/code] Don't forget to change prefix if your prefixe is not "xoops" :-D that's all,normally your hack work as well now best regards[/quote]" />