function incrUserDeckStat($stat, $dkN, $vstyle, $userId) { include 'config.php'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql'); mysql_select_db($dbname); $userDeckStat = getUserDeckStat($stat, $dkN, $vstyle, $userId); $userDeckStat++; $query = sprintf("UPDATE user_decks SET stats_correct = '%s' WHERE deck_id = (SELECT id FROM decks WHERE short_name = '%s' OR display_name = '%s') AND vstyle_id = (SELECT id FROM vstyles WHERE vstyle_description ='%s' OR vstyle='%s') AND user_id = '%s'", mysql_real_escape_string($userDeckStat), mysql_real_escape_string($dkN), mysql_real_escape_string($dkN), mysql_real_escape_string($vstyle), mysql_real_escape_string($vstyle), mysql_real_escape_string($userId)); $result = mysql_query($query); }
<tr class="info"> <th class="text-center" style="vertical-align:middle;">Deck</th> <th class="text-center">Get Kanji+Reading, Guess English<br /><span class="label label-primary">Easy</span></th> <th class="text-center">Get Kanji, Guess English<br /><span class="label label-warning">Med</span></th> <th class="text-center">Get Kanji, Guess Reading<br /><span class="label label-danger">Hard</span></th> <th class="text-center" style="vertical-align:middle;">Total</th> </tr><?php foreach ($pDecksSrtAscArr as $key => $value) { //key=DkName; value=deckId //if(getOwnershipStatus($value, $pid)){//firefox needs this otherwise it displays unowned decks $kanjiRE = getUserDeckStat('stats_correct', $key, 'kanjiRE', $pid); $kanjiE = getUserDeckStat('stats_correct', $key, 'kanjiE', $pid); $kanjiH = getUserDeckStat('stats_correct', $key, 'kanjiH', $pid); $reCnt = getUserDeckStat('stats_correct', $key, 'kanjiRE', $pid); $eCnt = getUserDeckStat('stats_correct', $key, 'kanjiE', $pid); $hCnt = getUserDeckStat('stats_correct', $key, 'kanjiH', $pid); $total = $kanjiRE + $kanjiH + $kanjiE; ?> <tr class="text-center"> <td class="text-left"><?php echo $key; ?> </td> <td <?php if ($reCnt < 10) { echo "class='danger'"; } ?> > <?php echo $reCnt; ?>