index.php

日程 BosDates v4.5 Copyright ?2004-2005 BosDev

						$orderCount = 1;
						$result = query("SELECT category_id FROM {$class_prefix}categories WHERE category_parent=$parent $sortBy",$class_link);
						while(list($catID) = mysql_fetch_row($result)) {
							$result2 = query("UPDATE {$class_prefix}categories SET category_order=$orderCount WHERE category_id=$catID",$class_link);
							$orderCount++;
							}
						}
					}
				}




		//No break so the categories will relist



	case "categories":
		if($userData['admin'] != 2) { header("Location: index.php?action=logout"); die(); }

		//Load ad types
		$adTypes = array();
		$result = query("SELECT type_id,type_title FROM {$class_prefix}ad_types",$class_link);
		while(list($typeID,$typeTitle) = mysql_fetch_row($result)) {
			$typeTitle = stripslashes($typeTitle);
			$adTypes[$typeID] = $typeTitle;
			$categoryGlobals .=<<<ENDGLOBALS
			<tr>
			 <td width="50" align="center"><input type="checkbox" name="adType{$typeID}" value="$typeID"></td>
			 <td>$typeTitle</td>
			 <td width="50"><input style="width:50px;" type="text" name="adPrice{$typeID}" value="0.00"></td>
			</tr>
ENDGLOBALS;
			}

		//Check for parent, set if needed
		if(!isset($parent) || $parent == "") { $parent = 0; }
			else {
				$parent = intval(protect($parent));
				$result = query("SELECT category_title,category_parent FROM {$class_prefix}categories WHERE category_id=$parent",$class_link);
				list($upTitle,$upParent) = mysql_fetch_row($result);
				$uptitle = stripslashes($upTitle);
				}

		//Build list
		$counter = 0;
		$result = query("SELECT category_id,category_title,category_ad_types,category_parent,category_subs FROM {$class_prefix}categories WHERE category_parent=$parent ORDER BY category_order",$class_link);
		while(list($catID,$catTitle,$catTypes,$categoryParent,$categorySubs) = mysql_fetch_row($result)) {
			$catTitle = stripslashes($catTitle);
			$typesArray = explode(",",$catTypes);
			$catTypes = "";
			while(list(,$val) = each($typesArray)) {
				if($val != "") {
					if($catTypes != "") { $catTypes .= ","; }
					$catTypes .= "{$adTypes[$val]}";
					}
				}
			if($counter%2 != 0) { $class = "class=\"alttd\""; }
				else { $class = ""; }

			$catList.=<<<ENDLIST
			<tr>
			 <td $class><a href="index.php?action=categories&parent=$catID">$catTitle</a> ($categorySubs)<br><span style="font-size:8pt; font-style:italic;">$catTypes</span></td>
			 <td width="75" $class align="center"><a href="index.php?action=categoriesEdit&category=$catID">{$Languages['admin']['cateditlink']}</a><br><a href="index.php?action=categoriesDelete&category=$catID">{$Languages['admin']['catdellink']}</a></td>
			 <td width="75" $class align="center"><a href="index.php?action=categoriesMove&move=$catID&dir=up">{$Languages['admin']['catup']}</a><br><a href="index.php?action=categoriesMove&move=$catID&dir=down">{$Languages['admin']['catdown']}</a></td>
			</tr>
ENDLIST;
			$counter++;
			}
		if($counter == 0) {
			$catList=<<<ENDLIST
			<tr>
			 <td colspan="3" align="center">{$Languages['admin']['catnone']}</td>
			</tr>
ENDLIST;
			}

		if($upParent != "") {
			$moveMsg=<<<ENDMSG
			<tr>
			 <td colspan="3">
			  {$Languages['admin']['catsubof']} $upTitle<br>
			  <a href="index.php?action=categories&parent=$upParent">{$Languages['admin']['catgoup']}</a>
			 </td>
			</tr>
ENDMSG;
			}

		$displayData =<<<ENDDATA
		<script language="Javascript">
		function checkForm(form) {
			if(trim(form.newCategory.value) == "") { return false; }
			form.newCategory.focus();
			return true;
			}
		</script>
		<div id="generalBox">
		<table width="100%" border="0" cellspacing="1" cellpadding="3">
		 <tr>
		  <td class="headtd">{$Languages['admin']['menucategories']}</td>
		 </tr>
		 <tr>
		  <td>

		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		   <form method="post" action="index.php" onSubmit="return checkForm(this);">
		   <input type="hidden" name="action" value="categoriesAdd">
		   <input type="hidden" name="parent" value="$parent">
		    <tr>
		     <td class="headtd">{$Languages['admin']['cataddnew']}</td>
		    </tr>
		    <tr>
		     <td>
		      {$Languages['admin']['cataddnewins']}<br>
		      <input type="text" name="newCategory"><input type="submit" value="{$Languages['admin']['process']}">
		     </td>
		    </tr>
		   </form>
		   </table>

		   <br>

		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		    <tr>
		     <td colspan="3" class="headtd">{$Languages['admin']['catcur']}</td>
		    </tr>
		    $moveMsg
		    <tr>
		     <td class="headtd">{$Languages['admin']['catname']}</td>
		     <td class="headtd" width="75" align="center">{$Languages['admin']['catactions']}</td>
		     <td class="headtd" width="75" align="center">{$Languages['admin']['catmove']}</td>
		    </tr>
		    $catList
		   </table>
		   </div>
ENDDATA;

		if($parent == 0) {
		$displayData .=<<<ENDDATA
		   <br>

		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		   <form method="post" action="index.php">
		   <input type="hidden" name="action" value="categoriesMove">
		    <tr>
		     <td class="headtd">{$Languages['admin']['catsort']}</td>
		    </tr>
		    <tr>
		     <td>
		      {$Languages['admin']['catsortby']} <select name="autoBy"><option value=""></option><option value="0">{$Languages['admin']['catsortname']}</option><option value="1">{$Languages['admin']['catsortads']}</option></select><input type="submit" value="{$Languages['admin']['process']}">
		     </td>
		    </tr>
		   </form>
		   </table>

		   <br>

		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		   <form method="post" action="index.php">
		   <input type="hidden" name="action" value="categoriesGlobal">
		    <tr>
		     <td class="headtd" colspan="3">{$Languages['admin']['catglobal']}</td>
		    </tr>
	    <tr>
		     <td class="alttd" width="50" align="center">{$Languages['admin']['catglobalallow']}</td>
		     <td class="alttd">{$Languages['admin']['catglobaltype']}</td>
		     <td class="alttd" width="50">{$Languages['admin']['catglobalprice']}</td>
		    </tr>
		    $categoryGlobals
		    <tr>
		     <td colspan="3"><input type="submit" value="{$Languages['admin']['process']}"></td>
		    </tr>
		   </form>
		   </table>
ENDDATA;
		}

		$displayData.=<<<ENDDATA
		  </td>
		 </tr>
		</table>
		</div>
ENDDATA;
		break;

	case "categoriesGlobal":
		if($userData['admin'] != 2) { header("Location: index.php?action=logout"); die(); }

		$adTypes = "";
		$adPrices = "";
		while(list($key,$val) = each($_POST)) {
			if(substr($key,0,6) == "adType") {
				${"adPrice".$val} = formatPrice(${"adPrice".$val},0);
				$adTypes .= "$val,";
				$adPrices .= ${"adPrice".$val}.",";
				}
			}
		$result = query("UPDATE {$class_prefix}categories SET category_ad_types='$adTypes',category_ad_prices='$adPrices'",$class_link);

		$displayData =<<<ENDDATA
		<div id="generalBox">
		<table width="100%" border="0" cellspacing="1" cellpadding="3">
		 <tr>
		  <td class="headtd">{$Languages['admin']['menucategories']}</td>
		 </tr>
		 <tr>
		  <td>
		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		    <tr>
		     <td class="headtd">{$Languages['admin']['catglobalallow']}</td>
		    </tr>
		    <tr>
		     <td>{$Languages['admin']['catglobalconfirm']}</td>
		    </tr>
		   </table>
		  </td>
		 </tr>
		</table>
		</div>
		<META HTTP-EQUIV="refresh" CONTENT=2;URL="index.php?action=categories">
ENDDATA;

		break;

	case "categoriesAdd":
		if($userData['admin'] != 2) { header("Location: index.php?action=logout"); die(); }

		//Protect input
		$newCategory = protect($newCategory);
		$parent = intval(protect($parent));

		//Get current count for the order
		$result = query("SELECT COUNT(category_id) FROM {$class_prefix}categories WHERE category_parent=$parent",$class_link);
		list($count) = mysql_fetch_row($result);

		//Insert new record
		$order = $count + 1;
		$result = query("INSERT INTO {$class_prefix}categories (category_id,category_order,category_parent,category_title) VALUES (NULL,$order,$parent,'$newCategory')",$class_link);

		//Recount cats/subs
		updateCounts();

		$displayData =<<<ENDDATA
		<div id="generalBox">
		<table width="100%" border="0" cellspacing="1" cellpadding="3">
		 <tr>
		  <td class="headtd">{$Languages['admin']['menucategories']}</td>
		 </tr>
		 <tr>
		  <td>
		   <table width="100%" border="0" cellspacing="1" cellpadding="3">
		    <tr>
		     <td class="headtd">{$Languages['admin']['cataddnew']}</td>
		    </tr>
		    <tr>
		     <td>{$Languages['admin']['cataddconfirm']}</td>
		    </tr>
		   </table>
		  </td>
		 </tr>
		</table>
		</div>
		<META HTTP-EQUIV="refresh" CONTENT=2;URL="index.php?action=categories&parent=$parent">
ENDDATA;
		break;

	case "categoriesEdit":
		if($userData['admin'] != 2) { header("Location: index.php?action=logout"); die(); }

		$category = protect($category);

		$result = query("SELECT category_title,category_desc,category_img,category_ad_types,category_ad_prices,category_optional_1,category_optional_1_def,category_optional_2,category_optional_2_def,category_optional_3,category_optional_3_def,category_optional_4,category_optional_4_def,category_optional_5,category_optional_5_def,banner_top,banner_bottom FROM {$class_prefix}categories WHERE category_id=$category",$class_link);
		list($categoryTitle,$categoryDesc,$categoryImg,$categoryAdTypes,$categoryAdPrices,$categoryOptional1,$categoryOptional1Def,$categoryOptional2,$categoryOptional2Def,$categoryOptional3,$categoryOptional3Def,$categoryOptional4,$categoryOptional4Def,$categoryOptional5,$categoryOptional5Def,$bannerTop,$bannerBottom) = mysql_fetch_row($result);

		$categoryTitle = toEdit($categoryTitle);
		$categoryDesc = toEdit($categoryDesc);
		$categoryOptional1 = toEdit($categoryOptional1);