rating.php

[montyash]

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

[03laceys]

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

[montyash]

Re: rating.php

nope still dnt work

[03laceys]

Re: rating.php

post your rating.phpif you didnt but it.

[montyash]

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();

?>

[03laceys]

Re: rating.php

ALTER TABLE `users` ADD `rating` INT( 11 ) NOT NULL ;

[montyash]

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

[03laceys]

Re: rating.php

make a new thread, post the problem,

and i or someone else will help ;)