Esempio n. 1
0
function getAllNews()
{
    $SqlText = "select NewsId,newsHeader,NewsPreview,NewsText,tags,publishdate from news ORDER BY publishdate DESC";
    return GetQueryResult($SqlText);
}
Esempio n. 2
0
 if (count($_GET) == 1) {
     echo "<embed src=\"images/swordblk.wav\" hidden=\"true\" autostart=\"true\" loop=\"false\" />";
     $PageTitle = "Weapons Preview & Selection";
     echo $SpecIncludes . '<title>' . $PageTitle . '</title>';
     echo '<center><table class="itemedit"><tr><td class="itemtd"><center>';
     echo '<br><h1>Narrow Search Criteria...</h1> (Results Vary)<hr>';
     echo '<table><tr><td><select onchange="GetITFileResult(this.value);"><option value="" >Select...</option>';
     foreach ($WeaponTypes as $key => $value) {
         echo '<option value="' . $key . '">' . $key . ': ' . $value . ' </option>';
     }
     echo '</select></td></tr></table>';
     echo '<br><br>';
     echo '<div id="ITFileResult">';
 }
 if ($_GET['WeaponType']) {
     $query_result = GetQueryResult('SELECT items.id, replace(items.idfile, "IT", "") AS WeaponList, items.icon FROM items WHERE itemtype = ' . $_GET['WeaponType'] . '  GROUP BY `idfile` ORDER BY `WeaponList` ASC;');
     while ($row = mysql_fetch_array($query_result)) {
         if (file_exists($weapons_dir . "/" . $row['WeaponList'] . ".jpg")) {
             echo '<div class="image" style="display:inline">' . "<a href='javascript:;' class='btn btn-default' onClick='FinishIDFile(" . $row['WeaponList'] . ")'>\n                                <span class='image-wrap'>\n                                    <img src='" . $weapons_url . $row['WeaponList'] . ".jpg' title='IT" . $row['WeaponList'] . "' width='120' height='180' class='cut-out'/>\n                                    <span class='image_label badge badge-danger'>IT" . $row['WeaponList'] . "</span>\n                                </span>\n                            </a>\n                        </div>";
         }
     }
 } else {
     for ($i = 1; $i < 100000; $i++) {
         if ($i == 1) {
             echo '<h1> EQ Classic </h1><hr>';
         }
         if ($i == 104) {
             echo '<h1> Kunark </h1><hr>';
         }
         if ($i == 161) {
             echo '<h1> Velious </h1><hr>';