function topdownload_data($form, $ordre) { global $NPDS_Prefix; global $top, $long_chain; if (!$long_chain) { $long_chain = 13; } settype($top, 'integer'); $result = sql_query("SELECT did, dcounter, dfilename, dcategory, ddate, perms FROM " . $NPDS_Prefix . "downloads ORDER BY {$ordre} DESC LIMIT 0,{$top}"); $lugar = 1; $ibid = ''; while (list($did, $dcounter, $dfilename, $dcategory, $ddate, $dperm) = sql_fetch_row($result)) { if ($dcounter > 0) { $okfile = autorisation($dperm); if ($ordre == 'dcounter') { $dd = wrh($dcounter); } if ($ordre == 'ddate') { $dd = translate("dateinternal"); $day = substr($ddate, 8, 2); $month = substr($ddate, 5, 2); $year = substr($ddate, 0, 4); $dd = str_replace('d', $day, $dd); $dd = str_replace('m', $month, $dd); $dd = str_replace('Y', $year, $dd); $dd = str_replace("H:i", "", $dd); } $ori_dfilename = $dfilename; if (strlen($dfilename) > $long_chain) { $dfilename = substr($dfilename, 0, $long_chain) . " ..."; } if ($form == 'short') { if ($okfile) { $ibid .= '<li class="list-group-item list-group-item-action">' . $lugar . ' <a href="download.php?op=geninfo&did=' . $did . '" title="' . $ori_dfilename . ' ' . $dd . '" >' . $dfilename . '</a><span class="tag tag-default float-xs-right">' . $dd . '</span></li>'; } } else { if ($okfile) { $ibid .= '<li class=""><a href="download.php?op=geninfo&did=' . $did . '" >' . $dfilename . '</a> (' . translate("Category") . ' : ' . aff_langue(stripslashes($dcategory)) . ') <span class="tag tag-default float-xs-right">' . wrh($dcounter) . '</span></li>'; } } if ($okfile) { $lugar++; } } } sql_free_result($result); return $ibid; }
if ($ibid = theme_image("stats/sections.png")) { $imgtmpS = $ibid; } else { $imgtmpS = "images/admin/sections.png"; } echo ' <li class="list-group-item"><img src="' . $imgtmpS . '" alt="" /> ' . translate("Special Sections: ") . ' <span class="tag tag-default float-xs-right">' . wrh($secnum) . ' </span></li>'; if ($ibid = theme_image("stats/sections.png")) { $imgtmp = $ibid; } else { $imgtmp = "images/admin/sections.png"; } echo ' <li class="list-group-item"><img src="' . $imgtmp . '" alt="" /> ' . translate("Articles in Sections: ") . ' <span class="tag tag-default float-xs-right">' . wrh($secanum) . ' </span></li>'; echo ' <li class="list-group-item"><i class="fa fa-link fa-2x text-muted"></i> ' . translate("Links in Web Links: ") . ' <span class="tag tag-default float-xs-right">' . wrh($links) . ' </span></li> <li class="list-group-item"><i class="fa fa-link fa-2x text-muted"></i> ' . translate("Categories in Web Links: ") . ' <span class="tag tag-default float-xs-right">' . wrh($cat) . ' </span></li>'; if ($ibid = theme_image("stats/submissions.png")) { $imgtmp = $ibid; } else { $imgtmp = "images/admin/submissions.png"; } echo ' <li class="list-group-item"><img src="' . $imgtmp . '" alt="" /> ' . translate("News Waiting to be Published: ") . ' <span class="tag tag-default float-xs-right">' . wrh($subnum) . ' </span></li> <li class="list-group-item"><i class="fa fa-cogs fa-2x text-muted"></i> Version Num <span class="tag tag-danger float-xs-right">' . $Version_Num . '</span></li> <li class="list-group-item"><i class="fa fa-cogs fa-2x text-muted"></i> Version Id <span class="tag tag-danger float-xs-right">' . $Version_Id . '</span></li> <li class="list-group-item"><i class="fa fa-cogs fa-2x text-muted"></i> Version Sub <span class="tag tag-danger float-xs-right">' . $Version_Sub . '</span></li> </ul> <br /> <p align="center"><a href="http://www.npds.org" >http://www.npds.org</a> - French Portal Generator Gnu/Gpl Licence</p><br />'; include "footer.php";
function listdownloads($dcategory, $sortby, $sortorder) { global $perpage, $page, $download_cat, $user; global $NPDS_Prefix; if ($dcategory == "") { $dcategory = addslashes($download_cat); } if (!$sortby) { $sortby = "dfilename"; } if ($sortorder != "ASC" && $sortorder != "DESC") { $sortorder = "ASC"; } echo '<p class="lead">'; echo translate("Display filtered with") . " <i>"; if ($dcategory == translate("All")) { echo translate("All"); } else { echo aff_langue(stripslashes($dcategory)); } echo "</i> " . translate("sorted by") . " "; // Shiney SQL Injection 11/2011 $sortby2 = ""; if ($sortby == 'dfilename') { $sortby2 = translate("Name") . ""; } if ($sortby == 'dfilesize') { $sortby2 = translate("File Size") . ""; } if ($sortby == 'dcategory') { $sortby2 = translate("Category") . ""; } if ($sortby == 'ddate') { $sortby2 = translate("Creation Date") . ""; } if ($sortby == 'dver') { $sortby2 = translate("Version") . ""; } if ($sortby == 'dcounter') { $sortby2 = translate("Downloads") . ""; } // Shiney SQL Injection 11/2011 if ($sortby2 == '') { $sortby = 'dfilename'; } echo ' ' . translate("of") . ' <i>' . $sortby2 . '</i> </p>'; echo '<table class="table table-hover" id ="lst_downlo" data-toggle="table" data-striped="true" data-search="true" data-show-toggle="true" data-mobile-responsive="true" data-icons-prefix="fa" data-icons="icons">'; sortlinks($dcategory, $sortby); echo '<tbody>'; if ($dcategory == translate("All")) { $sql = "SELECT COUNT(*) FROM " . $NPDS_Prefix . "downloads"; } else { $sql = "SELECT COUNT(*) FROM " . $NPDS_Prefix . "downloads WHERE dcategory='" . addslashes($dcategory) . "'"; } $result = sql_query($sql); list($total) = sql_fetch_row($result); if ($total > $perpage) { $pages = ceil($total / $perpage); if ($page > $pages) { $page = $pages; } if (!$page) { $page = 1; } $offset = ($page - 1) * $perpage; } else { $offset = 0; $pages = 1; $page = 1; } settype($offset, "integer"); settype($perpage, "integer"); if ($dcategory == translate("All")) { $sql = "SELECT * FROM " . $NPDS_Prefix . "downloads ORDER BY {$sortby} {$sortorder} LIMIT {$offset},{$perpage}"; } else { $sql = "SELECT * FROM " . $NPDS_Prefix . "downloads WHERE dcategory='" . addslashes($dcategory) . "' ORDER BY {$sortby} {$sortorder} LIMIT {$offset},{$perpage}"; } $result = sql_query($sql); while (list($did, $dcounter, $durl, $dfilename, $dfilesize, $ddate, $dweb, $duser, $dver, $dcat, $ddescription, $dperm) = sql_fetch_row($result)) { $Fichier = new File($durl); // keep for extension $FichX = new FileManagement(); // essai class $okfile = autorisation($dperm); echo ' <tr> <td class="text-xs-center">'; if ($okfile == true) { echo popuploader($did, $ddescription, $dcounter, $dfilename, true); } else { echo popuploader($did, $ddescription, $dcounter, $dfilename, false); echo '<span class="text-warning">' . translate("Private") . '</span>'; } echo "</td><td class=\"text-xs-center\"><img src=\"" . $Fichier->Affiche_Extention() . "\" alt=\"" . $Fichier->Affiche_Extention() . "\" border=\"0\" /></td>\n <td>"; if ($okfile == true) { echo "<a href=\"download.php?op=mydown&did={$did}\" target=\"_blank\">{$dfilename}</a>"; } else { echo '...'; } echo '</td> <td>'; if ($dfilesize != 0) { // echo $Fichier->Pretty_Size($dfilesize); echo $FichX->file_size_auto($durl, 2); } else { // echo $Fichier->Affiche_Size(); echo $FichX->file_size_auto($durl, 2); } echo '</td> <td>' . aff_langue(stripslashes($dcat)) . '</td> <td>' . convertdate($ddate) . '</td> <td class="text-xs-center">' . $dver . '</td> <td class="text-xs-center">' . wrh($dcounter) . '</td> <td>'; if ($okfile == true and $user) { echo "<a href=\"download.php?op=broken&did={$did}\" title=\"" . translate("Report Broken Link") . "\"><i class=\"fa fa-lg fa-chain-broken\"></i></a>"; } echo ' </td> </tr>'; } echo ' </tbody> </table>'; $dcategory = StripSlashes($dcategory); echo '<ul class="pagination pagination-sm">'; if ($pages > 1) { $pcnt = 1; if ($page > 1) { echo ' <li class="page-item"> <a class="page-link" href="download.php?dcategory=' . $dcategory . '&sortby=' . $sortby . '&sortorder=' . $sortorder . '&page=' . ($page - 1) . '" aria-label="Previous" title="' . translate("Previous Page") . '"> <span aria-hidden="true">«</span> <span class="sr-only">Previous</span> </a> </li>'; } while ($pcnt < $page) { echo "<li class=\"page-item\"><a class=\"page-link\" href=\"download.php?dcategory={$dcategory}&sortby={$sortby}&sortorder={$sortorder}&page={$pcnt}\">{$pcnt}</a></li>"; $pcnt++; } echo '<li class="page-item active"><a class="page-link" href="#">' . $page . '</a></li>'; $pcnt++; while ($pcnt <= $pages) { echo "<li class=\"page-item\"><a class=\"page-link\" href=\"download.php?dcategory={$dcategory}&sortby={$sortby}&sortorder={$sortorder}&page={$pcnt}\">{$pcnt}</a></li>"; $pcnt++; } if ($page < $pages) { echo "<li class=\"page-item\">\n <a class=\"page-link\" href=\"download.php?dcategory={$dcategory}&sortby={$sortby}&sortorder={$sortorder}&page=" . ($page + 1) . "\" aria-label=\"Next\" title=\"" . translate("Next Page") . "\">\n <span aria-hidden=\"true\">»</span>\n <span class=\"sr-only\">Next</span>\n </a>\n </li>\n"; } } echo '</ul>'; }
function pollResults($pollID) { global $NPDS_Prefix, $maxOptions, $setCookies; if (!isset($pollID) or empty($pollID)) { $pollID = 1; } $result = sql_query("SELECT pollID, pollTitle, timeStamp FROM " . $NPDS_Prefix . "poll_desc WHERE pollID='{$pollID}'"); list(, $pollTitle) = sql_fetch_row($result); echo ' <h3 class="mb-1">' . $pollTitle . '</h3>'; $result = sql_query("SELECT SUM(optionCount) AS SUM FROM " . $NPDS_Prefix . "poll_data WHERE pollID='{$pollID}'"); list($sum) = sql_fetch_row($result); echo ' <h4><span class="tag tag-default">' . $sum . '</span> ' . translate("Results") . '</h4>'; for ($i = 1; $i <= $maxOptions; $i++) { $result = sql_query("SELECT optionText, optionCount, voteID FROM " . $NPDS_Prefix . "poll_data WHERE (pollID='{$pollID}') AND (voteID='{$i}')"); $object = sql_fetch_assoc($result); $optionText = $object['optionText']; $optionCount = $object['optionCount']; if ($optionText != "") { if ($sum) { $percent = 100 * $optionCount / $sum; $percentInt = (int) $percent; } else { $percentInt = 0; } echo ' <div class="row"> <div class="col-sm-5">' . aff_langue($optionText) . '</div> <div class="col-sm-7"> <span class="tag tag-default text-xs-right">' . wrh($optionCount) . '</span> <progress class="progress progress-striped" value="' . $percentInt . '" max="100" title="' . $percentInt . '%" data-toggle="tooltip"> <div class="progress"> <span class="progress-bar" role="progressbar" aria-valuenow="' . $percentInt . '%" aria-valuemin="0" aria-valuemax="100" style="width:' . $percentInt . '%;" ></span> </div> </progress> </div> </div>'; } } echo '<br />'; echo '<p class="text-xs-center"><b>' . translate("Total Votes: ") . ' ' . $sum . '</b></p><br />'; if ($setCookies > 0) { echo '<p class="text-danger">' . translate("We allow just one vote per poll.") . '</p>'; } }
echo "<span class=\"text-success\">+"; } elseif ($totalb < $xtotalb) { echo "<span class=\"text-danger\">"; } else { echo "<span>"; } echo wrh($totalb - $xtotalb) . "</span>)</td></tr>"; echo "<tr><td>" . translate("Nb Outside Users for LNL") . " : </td><td>" . wrh($totalnl) . " ("; if ($totalnl > $xtotalnl) { echo "<span class=\"text-success\">+"; } elseif ($totalnl < $xtotalnl) { echo "<span class=\"text-danger\">"; } else { echo "<span>"; } echo wrh($totalnl - $xtotalnl) . "</span>)</td></tr>"; $xfile = "<?php\n"; $xfile .= "\$xdate = " . time() . ";\n"; $xfile .= "\$xtotalz = {$totalz};\n"; $xfile .= "\$xmembres = {$membres};\n"; $xfile .= "\$xtotala = {$totala};\n"; $xfile .= "\$xtotalc = {$totalc};\n"; $xfile .= "\$xtotald = {$totald};\n"; $xfile .= "\$xtotalb = {$totalb};\n"; $xfile .= "\$xtotalnl = {$totalnl};\n"; echo "</tbody></table><br />\n"; echo "<table class=\"table table-bordered\"><thead><tr class=\"info\"><th colspan=\"2\">" . translate("Download Stats") . "</th></tr></thead>"; $num_dow = 0; $result = sql_query("SELECT dcounter, dfilename FROM " . $NPDS_Prefix . "downloads"); while (list($dcounter, $dfilename) = sql_fetch_row($result)) { $num_dow++;
$imgtmpS = $ibid; } else { $imgtmpS = "images/stats/sections.gif"; } echo "<tr><td><img src=\"{$imgtmpS}\" border=\"0\" alt=\"\" /> " . translate("Special Sections: ") . "</td><td width=\"60%\" align=\"center\"><b>" . wrh($secnum) . "</b></td></tr>\n"; if ($ibid = theme_image("stats/articles.gif")) { $imgtmp = $ibid; } else { $imgtmp = "images/stats/articles.gif"; } echo "<tr><td><img src=\"{$imgtmp}\" border=\"0\" alt=\"\" /> " . translate("Articles in Sections: ") . "</td><td width=\"60%\" align=\"center\"><b>" . wrh($secanum) . "</b></td></tr>\n"; if ($ibid = theme_image("stats/topics.gif")) { $imgtmp = $ibid; } else { $imgtmp = "images/stats/topics.gif"; } echo "<tr><td><img src=\"{$imgtmp}\" border=\"0\" alt=\"\" /> " . translate("Links in Web Links: ") . "</td><td width=\"60%\" align=\"center\"><b>" . wrh($links) . "</b></td></tr>\n"; echo "<tr><td><img src=\"{$imgtmpS}\" border=\"0\" alt=\"\" /> " . translate("Categories in Web Links: ") . "</td><td width=\"60%\" align=\"center\"><b>" . wrh($cat) . "</b></td></tr>\n"; if ($ibid = theme_image("stats/waiting.gif")) { $imgtmp = $ibid; } else { $imgtmp = "images/stats/waiting.gif"; } echo "<tr><td><img src=\"{$imgtmp}\" border=\"0\" alt=\"\" /> " . translate("News Waiting to be Published: ") . "</td><td width=\"60%\" align=\"center\"><b>" . wrh($subnum) . "</b></td></tr>\n"; echo "<tr><td><img src=\"{$imgtmpS}\" border=\"0\" alt=\"\" /> Version Num : </td><td width=\"60%\" align=\"center\"><b>{$Version_Num}</b></td></tr>\n"; echo "<tr><td><img src=\"{$imgtmpS}\" border=\"0\" alt=\"\" /> Version Id : </td><td width=\"60%\" align=\"center\"><b>{$Version_Id}</b></td></tr>\n"; echo "<tr><td><img src=\"{$imgtmpS}\" border=\"0\" alt=\"\" /> Version Sub : </td><td width=\"60%\" align=\"center\"><b>{$Version_Sub}</b></td></tr>\n"; echo "</table>"; echo "<br /><p align=\"center\"><a href=\"http://www.npds.org\" class=\"noir\">http://www.npds.org</a> - French Portal Generator Gnu/Gpl Licence</p><br />"; closetable(); include "footer.php";
function topdownload_data($form, $ordre) { global $NPDS_Prefix; global $top, $long_chain; if (!$long_chain) { $long_chain = 13; } settype($top, "integer"); $result = sql_query("SELECT did, dcounter, dfilename, dcategory, ddate, perms FROM " . $NPDS_Prefix . "downloads ORDER BY '{$ordre}' DESC LIMIT 0,{$top}"); $lugar = 1; $ibid = ""; while (list($did, $dcounter, $dfilename, $dcategory, $ddate, $dperm) = sql_fetch_row($result)) { $rowcolor = tablos(); if ($dcounter > 0) { $okfile = autorisation($dperm); if ($ordre == "dcounter") { $dd = "( " . wrh($dcounter) . " )"; } if ($ordre == "ddate") { $dd = translate("dateinternal"); $day = substr($ddate, 8, 2); $month = substr($ddate, 5, 2); $year = substr($ddate, 0, 4); $dd = str_replace("d", $day, $dd); $dd = str_replace("m", $month, $dd); $dd = str_replace("Y", $year, $dd); $dd = "(" . str_replace("H:i", "", $dd) . ")"; } $ori_dfilename = $dfilename; if (strlen($dfilename) > $long_chain) { $dfilename = substr($dfilename, 0, $long_chain) . " ..."; } if ($form == "short") { if ($okfile) { $ibid .= "" . $lugar . " <a href=\"download.php?op=geninfo&did={$did}\" title=\"" . $ori_dfilename . " " . $dd . "\" >" . $dfilename . "</a><br />"; } } else { if ($okfile) { $ibid .= "<tr " . $rowcolor . "><td>" . $lugar . ": <a href=\"download.php?op=geninfo&did={$did}\" class=\"noir\">" . $dfilename . "</a> (" . translate("Category") . " : " . aff_langue(stripslashes($dcategory)) . ")</td><td align=\"right\">" . wrh($dcounter) . "<br /></td></tr>"; } } if ($okfile) { $lugar++; } } } sql_free_result($result); return $ibid; }