montyash Posted March 16, 2008 Posted March 16, 2008 with my rating it does not tell you how many you have so if i give someone a positive rating no number comes up in the middle so people can see it can anyone help Quote
03laceys Posted March 16, 2008 Posted March 16, 2008 Re: rating.php did you buy this mod from cronus? if so you are missing one query if not it still sounds like you are missing the query, i had the same problem when i bought it of him. insert into users rating int (11) NOT NULL default 0 Quote
03laceys Posted March 16, 2008 Posted March 16, 2008 Re: rating.php post your rating.phpif you didnt but it. Quote
montyash Posted March 16, 2008 Author Posted March 16, 2008 Re: rating.php <?php include "globals.php"; if($_GET['ID'] == $userid) { die("<center>You cannot rate yourself.</center>"); } if($_GET['change'] == 'up') { if($_GET['ID']) { $bumbums=mysql_query("SELECT * FROM rating WHERE rateD={$_GET['ID']} AND rateR=$userid",$c); $bumbum=mysql_fetch_array($bumbums); if($bumbum) { die("<center>You cannot do this more than once a day to a certain person.</center>"); } mysql_query("UPDATE users SET rating=rating+1 WHERE userid={$_GET['ID']}",$c); mysql_query("INSERT INTO rating VALUES ('','{$_GET['ID']}',$userid);",$c); die("<center>You have given this user a positive rating.</center>"); } die("<center>Invalid ID</center>"); } if($_GET['change'] == 'down') { if($_GET['ID'] && $_GET['ID']!=$userid) { $bumbums=mysql_query("SELECT * FROM rating WHERE rateD={$_GET['ID']} AND rateR=$userid",$c); $bumbum=mysql_fetch_array($bumbums); if($bumbum) { die("<center>You cannot do this more than once a day to a certain person.</center>"); } mysql_query("UPDATE users SET rating=rating-1 WHERE userid={$_GET['ID']} AND rating>0",$c); mysql_query("INSERT INTO rating VALUES ('','{$_GET['ID']}',$userid);",$c); die("<center>You have given this user a negative rating.</center>"); } die("<center>Invalid ID</center>"); } $h->endpage(); ?> Quote
03laceys Posted March 16, 2008 Posted March 16, 2008 Re: rating.php ALTER TABLE `users` ADD `rating` INT( 11 ) NOT NULL ; Quote
montyash Posted March 16, 2008 Author Posted March 16, 2008 Re: rating.php silly me thanx m8 do u no wats wrong with my profile sigs everything works but wen i put in wat i want it dont show up on my profile but wen i go to ? edit it its still there Quote
03laceys Posted March 16, 2008 Posted March 16, 2008 Re: rating.php make a new thread, post the problem, and i or someone else will help ;) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.