General YPN >> How can I get points
Posted by Mickey on 19:56:00 10-02-2003
I am a newbie at programming and I don't understand how to get points to get in the hall of fame could someone let me in on the secret!!!
Posted by DInsane on 06:14:00 10-03-2003
First of all, if you were thinking about hacking in to it, shame on you.

Second of all, that system measures the tutorials and links and other things you've posted, not the board posts.

Third of all, that system is messed up, and we've been having problems with it for a while. [addsig]
Posted by fsvara on 06:21:00 10-11-2003
Quote:
On 2003-10-03 06:14, DInsane wrote:
Third of all, that system is messed up, and we've been having problems with it for a while.


Hehe, that's probably because I "invented" that formula ... Well, it never really worked, I guess we were to lazy to fix it. I tried to remember how the "formula" worked but I just can't recall ... The "Sum of Points" should be the sum of all single ratings given for all single submissions (except links, I suppose). That works for ^pixel in the hall of fame, but not for most other people The numbers are usually somewhere near to each other, but not the same ... Well, somebody would need to check the source for that.
Posted by dxprog on 06:32:00 10-11-2003
fsvara?! My gosh! I haven't seen you in forever! Here's the code for the HOF which I dug out of my copy of sasqII:

if($tutsnum && $votsnum)
{
$rank= $points/$votsnum+ $tutsnum/10;
}
elseif ($tutsnum) {
$rank=$tutsnum/10;
}
else
{
$rank=0; //Just a very high number to garantuee that user is at the end
} [addsig]
Posted by fsvara on 06:52:00 10-11-2003
Yeah, that (.1 * tutsnum) i remembered .. but how are the points calculated?
Posted by dxprog on 08:42:00 10-11-2003
Whoops, sorry.

function UserPoints($uname)
{
$result=mysql_query("SELECT points, docID FROM sasq_votes WHERE who='$uname'");
if(mysql_num_rows($result)!=0)
{
$points=0;

while($row=mysql_fetch_array($result))
{
$result2=mysql_query("SELECT type FROM sasq_docs WHERE ID ='$row[docID]'");
$row2=mysql_fetch_array($result2);
$result2=mysql_query("SELECT counts FROM sasq_doctype WHERE doctype='$row2[type]'");
$row2=mysql_fetch_array($result2);

$points+= $row[points]*$row2[counts] ;
}
return $points;
}
else
{
return 0;
}
} [addsig]
Posted by DInsane on 11:47:00 10-11-2003
I'm not sure how the rest of that script is, but that last code you entered, if it is used a certain way, would give a user a point for everything entered (one for each). I'm sure that's not how it is, though. Did you fix that in YPNgine? If not, I'll take a look at it. (I haven't been doing anything on Partyfish, due to CVS troubles). [addsig]
Posted by dxprog on 12:18:00 10-11-2003
We decided not to do the Hall of Fame thing in YPNgine (or partyfish). Too many problems. [addsig]
Posted by DInsane on 09:26:00 10-13-2003
We could always do it manually, only with a different purpose. Once or twice a year we'd induct one or a couple people into the Hall of Fame for what they have done and how they've helped the YPN. Then we'd have a page for an explanation and more info on that person. Then they could get a special tag, or title, saying they're a Hall of Fame inductee, then we could..... poof. I ran out of ideas. [addsig]
Posted by benbread on 01:50:00 10-14-2003
why do you call it a "Formula" ? i thought it was either a function or an alogrithm (however you spell it)
Posted by cowsarenotevil on 05:25:00 10-14-2003
Um, they can all be synonymouse... a formula is just when some variable is equal to other variables that are plugged in.