function getAllNews()
{
$SqlText = "select NewsId,newsHeader,NewsPreview,NewsText,tags,publishdate from news ORDER BY publishdate DESC";
return GetQueryResult($SqlText);
}
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>';