function getRandomImage($db_handle, $db_found) { require 'getTotalVotes.php'; if ($db_found) { $SQL_stmt = "SELECT * FROM files ORDER BY RAND() LIMIT 2"; $query_result = mysqli_query($db_handle, $SQL_stmt); if ($query_result) { $num_rows = mysqli_num_rows($query_result); if ($num_rows > 0) { //echoing some html echo "<table>"; while ($row = mysqli_fetch_assoc($query_result)) { //sets the image id to the file id, which is unique echo "<img src='data:image/jpeg;base64," . base64_encode($row['fdata']) . "' height='350' id=" . $row['fid'] . " class='the_image'/> <br>\n\t\t\t\t\t <div id='" . $row['fid'] . "_text' class='the_image_text'>" . getTotalVotes($db_handle, $row['fid']) . "</div>"; } echo "</table>"; } else { $func_message = "No files found"; } } else { echo "Error querying database"; } mysqli_close($db_handle); } else { echo "Error connecting to database"; } }
$query_result = mysqli_multi_query($db_handle, $SQL_stmt); if ($query_result) { $message = getTotalVotes($db_handle, $image_id); } else { $message = "Voting error"; } } else { $fusers_voted = $fusers_voted . $modified_username; $images_voted = $images_voted . $modified_image_id; //multi query was going out of sync here $SQL_stmt = "UPDATE files SET fusers_voted = '{$fusers_voted}', fvote_total = fvote_total + 1 WHERE fid = '{$image_id}'"; $query_result = mysqli_query($db_handle, $SQL_stmt); $SQL_stmt = "UPDATE users SET images_voted = '{$images_voted}' WHERE uid = '{$uid}';"; $query_result = mysqli_query($db_handle, $SQL_stmt); if ($query_result) { $message = getTotalVotes($db_handle, $image_id); } else { $message = "Voting error"; } } mysqli_close($db_handle); } } function checkVoted($voted, $user) { $voted = explode(',', $voted); if (in_array($user, $voted)) { return true; } else { return false; }
* substitute goods or services; loss of use, data, or profits; or business * * interruption) however caused and on any theory of liability, whether in * * contract, strict liability, or tort (including negligence or otherwise) * * arising in any way out of the use of this software, even if advised of the * * possibility of such damage. * * * ********************************************************************************/ include_once $_SERVER['DOCUMENT_ROOT'] . '/config.php'; include_once $HUB_FLM->getCodeDirPath("ui/headerstats.php"); global $CFG, $LNG; $sort = optional_param("sort", "vote", PARAM_ALPHANUM); $oldsort = optional_param("lastsort", "", PARAM_ALPHANUM); $direction = optional_param("lastdir", "DESC", PARAM_ALPHANUM); $totalsItems = getTotalItemVotes(); $totalsConns = getTotalConnectionVotes(); $totals = getTotalVotes(); $topVotedNodes = getTotalTopVotes(10); $topVotedForNodes = getTopNodeForVotes(10); $topVotedAgainstNodes = getTopNodeAgainstVotes(10); $topVoters = getTopVoters(10); $topVotersFor = getTopForVoters(10); $topVotersAgainst = getTopAgainstVoters(10); $allNodeVotes = getAllVoting($direction, $sort, $oldsort); ?> <h3 style="margin-top:0px;"><?php echo $LNG->STATS_GLOBAL_VOTES_MENU_TITLE; ?> </h3> <table width="160" style="float:left;margin-right:50px;">