This has been bugging me for a good hour or two now. Finally thought I'd ask...
// rv scores
$rv_gp1 = $_POST['rv_gp1']; // submitted '100'
$rv_gp2 = $_POST['rv_gp2']; // submitted '100'
$rv_gp3 = $_POST['rv_gp3']; // submitted '100'
$rv_3gps = $rv_gp1 + $rv_gp2 + $rv_gp3; // db entry = '300' (correct)
$rv_penalties = $_POST['rv_penalties']; // submitted '50'
$rv_score = $rv_3gps - $rv_penalties; // db entry = '100' (incorrect, should be '250'. '100' is the $op_score (see below))
// opponent gp scores
$op_gp1 = $_POST['op_gp1']; // submitted '50'
$op_gp2 = $_POST['op_gp2']; // submitted '50'
$op_gp3 = $_POST['op_gp3']; // submitted '50'
$op_3gps = $op_gp1 + $op_gp2 + $op_gp3; // db entry = '150' (correct)
$op_penalties = $_POST['op_penalties']; // submitted '50'
$op_score = $op_3gps - $op_penalties; // db entry = '100' (correct)
// difference
$difference = $rv_score - $op_score; // db entry = '150' (correct)
// outcome tag
if ($rv_score > $op_score) $win = '1'; // db entry = '1' (correct)
if ($rv_score = $op_score) $draw = '1'; // db entry = '1' (incorrect, should be '')
if ($rv_score < $op_score) $loss = '1'; // db entry = '' (correct)
Can anyone please tell me why $rv_score is being entered into the db as the $op_score?
Just in case:
safe_query("INSERT INTO ".PREFIX."clanwars ( date, squad, game, league, leaguehp, opponent, opptag, oppcountry, opphp, oppID, rv_gp1, rv_gp2, rv_gp3, rv_3gps, rv_penalties, rv_score, op_gp1, op_gp2, op_gp3, op_3gps, op_penalties, op_score, difference, win, draw, loss, player1, player2, player3, player4, player5, player6, player7, player1_gp1, player1_gp2, player1_gp3, player2_gp1, player2_gp2, player2_gp3, player3_gp1, player3_gp2, player3_gp3, player4_gp1, player4_gp2, player4_gp3, player5_gp1, player5_gp2, player5_gp3, player6_gp1, player6_gp2, player6_gp3, player7_gp1, player7_gp2, player7_gp3, report, comments, linkpage)
VALUES( '$date', '$squad', '$game', '".$league."', '$leaguehp', '".$opponent."', '".$opptag."', '$oppcountry', '$opphp', '".$oppID."', '".$rv_gp1."', '".$rv_gp2."', '".$rv_gp3."', '$rv_3gps', '".$rv_penalties."', '$rv_score', '".$op_gp1."', '".$op_gp2."', '".$op_gp3."', '$op_3gps', '".$op_penalties."', '$op_score', '$difference', '$win', '$draw', '$loss', '".$player1."', '".$player2."', '".$player3."', '".$player4."', '".$player5."', '".$player6."', '".$player7."', '".$player1_gp1."', '".$player1_gp2."', '".$player1_gp3."', '".$player2_gp1."', '".$player2_gp2."', '".$player2_gp3."', '".$player3_gp1."', '".$player3_gp2."', '".$player3_gp3."', '".$player4_gp1."', '".$player4_gp2."', '".$player4_gp3."', '".$player5_gp1."', '".$player5_gp2."', '".$player5_gp3."', '".$player6_gp1."', '".$player6_gp2."', '".$player6_gp3."', '".$player7_gp1."', '".$player7_gp2."', '".$player7_gp3."', '".$report."', '$comments', '$linkpage' ) ");
HTML:
<tr>
<td class="tablerow" style="float: left; width: 60px; margin-bottom: 3px;">GP1</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="rv_gp1" id="rv_gp1" value="$rv_gp1" maxlength="3" size="5" style="text-align: center;">
</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="op_gp1" id="op_gp1" value="$op_gp1" maxlength="3" size="5" style="text-align: center;">
</td>
</tr>
<tr>
<td class="tablerow" style="float: left; width: 60px; margin-bottom: 3px;">GP2</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="rv_gp2" id="rv_gp2" value="$rv_gp2" maxlength="3" size="5" style="text-align: center;">
</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="op_gp2" id="op_gp2" value="$op_gp2" maxlength="3" size="5" style="text-align: center;">
</td>
</tr>
<tr>
<td class="tablerow" style="float: left; width: 60px; margin-bottom: 3px;">GP3</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="rv_gp3" id="rv_gp3" value="$rv_gp3" maxlength="3" size="5" style="text-align: center;">
</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="op_gp3" id="op_gp3" value="$op_gp3" maxlength="3" size="5" style="text-align: center;">
</td>
</tr>
<tr>
<td class="tablerow" style="float: left; width: 60px; margin-bottom: 3px;">Penalties</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="rv_penalties" id="rv_penalties" value="$rv_penalties" maxlength="3" size="5" style="text-align: center;">
</td>
<td class="tablerow" style="float: left; width: 75px; margin-bottom: 3px; text-align: center;">
<input type="text" name="op_penalties" id="op_penalties" value="$op_penalties" maxlength="3" size="5" style="text-align: center;">
</td>
</tr>
Thanks in advance 🙂
