Point System

[Lamez]

I am trying to make a point system, but every attempt fails miserably, could someone help me?

 

I pull the points for the user from the DB, then I pull the point values from the DB as well.

Then I pull the winners, and the user picks from the database as well.

 

Now I take the information and create a IF statement I say

if $userpick === $winnner{

$total = $value + $rnd1;

}else{

do not add and continue to the next pick.

 

There are 32 chances to earn points, but it does not work at all.

 

Also I have multiple users on the website, so would I have to do a loop? I want this to run after the admin makes the selection for the winners.

 

Could just someone give me an example code?

 

-Thanks

[cunoodle2]

Please post the existing code you have thus far and we will work with you to get it in better working order.

[Lamez]

Oh ya that would be a good idea

 

in the first IF statment, if the winner does not equal userpick, it does not add the points for the next if statment.

 

<?php
include("style/include/session.php");
include ("style/include/cons/head.php");
echo '<div class="box">';
if($session->logged_in){
$user = $session->username;

   /*Pull Winners for Round 1*/
  $q = mysql_query("Select * from `rnd1_win`");
  $win=mysql_fetch_array($q);
   
  /*Pull User Picks for Round 1*/
  $q = mysql_query("Select * from `rnd1`");
  $pick=mysql_fetch_array($q);
  
  /*Pull Point Values for Round 1*/
  $q = mysql_query("Select * from `points`");
  $point=mysql_fetch_array($q);
  $value = $point['0'];
  
  /*Pull User Points for Round 1*/
  $q = mysql_query("Select * from `userpoints`");
  $usrpoint=mysql_fetch_array($q);
  $total = $usrpoint['total'];
  $rnd1 = $usrpoint['1'];
  
  
  
  if ($win['0'] === ($pick['a1'])){
   $total = $value + $total;
   $rnd1 = $value + $rnd1;
   $q = "UPDATE `userpoints` SET `total`=$total WHERE `username`='$user'";
       mysql_query($q);
   $q = "UPDATE `userpoints` SET `1`=$rnd1 WHERE `username`='$user'";
       mysql_query($q);
   }else{
   
  if ($win['1'] === ($pick['a2'])){
   $total = $value + $total;
   $rnd1 = $value + $rnd1;
   $q = "UPDATE `userpoints` SET `total`=$total WHERE `username`='$user'";
       mysql_query($q);
   $q = "UPDATE `userpoints` SET `2`=$rnd1 WHERE `username`='$user'";
       mysql_query($q);
   }
   
   
   echo "<h2>Point Test</h2>";
   echo "<p>Your Total: $total<br>";
   echo "Your Round 1: $rnd1</p>";
  }
  
}else{
include ("style/include/cons/member.php");
}
print '</div>';
include ("style/include/cons/foot.php");
  
?>

[Lamez]

also, I need this to work after I have selected the winners, and update ever user in the system point values.

 

Do I need  loop? If so how?

[Lamez]

bump for the night

[Lamez]

am I doing the IF statement right?

[Chris92]

if ( $win['0'] == $pick['a1'] )
{
    $total = $value + $total;
    $rnd1 = $value + $rnd1;
    mysql_query("UPDATE `userpoints` SET `total`='$total', `1`='$rnd1' WHERE `username`='$user'");

} else if ( $win['1'] == $pick['a2'] )
{
    $total = $value + $total;
    $rnd1 = $value + $rnd1;
    mysql_query("UPDATE `userpoints` SET `total`='$total', `2`='$rnd1' WHERE `username`='$user'");
}

[aschk]

You do realise that doing

/*Pull Winners for Round 1*/
  $q = mysql_query("Select * from `rnd1_win`");
  $win=mysql_fetch_array($q);
[code]

You are selecting ALL the rows from the table rnd1_win, with NO ordering, and thus you cannot guarantee which result you are pulling out using mysql_fetch_array. You are pulling the top one that MySQL presents to you (which is unknown). I suggest you work out what your SQL statements should be because this could well be a big flaw in the data you think you're pulling.

[/code]

[Lamez]

well noted.

 

I think I have it down now, I am not sure, but how do I do a loop? I know I would have to pull the user names from user table, I would have to make the loop run for ever user in the user table, but how?