Проблем с качването на новини

Gamerz · 27 Юни 2011

Здравейте, имам проблем след като прехвърлих сайта си от една хостинг компания на друга, не мога да ъпдейтвам информация. Като напиша новиниа попринцип и я публикувам изписва "done", но сега ми дава само страницата на която трябва да изпише done и нищо не пише на нея. Някой има ли някаква идея каква може да е причината за това. Същото се случва и при опит да направя друго обновяване по сайта посредством админ панела. Имах подобен проблем преди, но човека който го поправи не си спомня какво точно е било и няма време да се занимава в момента.

smoke · 27 Юни 2011

дай кода да видим

Gamerz · 27 Юни 2011

Ами проблема едвали е в кода, тъй като той си е същия и преди прехвърлянето и след това...

PHP:

<?php
//======================================================================

// News Management
//======================================================================

defined('_VALID_INCLUDE') or die('<font color=red><strong>Direct access to this file not allowed.</font></strong>');
defined('_VALID_CRINC') or die();

include "../FCKEditor/fckeditor_admin.php";

//===============================================================
//	CHECK FOR ACCESS
//---------------------------------------------------------------------------------
if ($access_news == '1') {
?>
<table class="blanktable" cellpadding="4" cellspacing="0" border="0" width="100%">
<tr>
	<td width="26%" style="padding-left: 5px;" valign="top"><div class="divsmall"><?include "left.php"?></td>
	<td width="74%" valign="top">
<?
//===============================================================
//	NO OPERATIONS REQUESTED
//---------------------------------------------------------------------------------
	if (!$_REQUEST[op]) {
?>
		<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_news"?></span></div>
		<div style="padding: 5px; width: 484px;">

			<table cellpadding="0" cellspacing="0" border="0" width="100%">
			<tr>
				<td valign="top" width="1%"><img hspace="5" align="absmiddle" src="images/a.jpg"></td>
				<td valign="top" width="99%"><DIV class="reg_text"><strong><?echo "$lang_a_select_op"?></strong><br />

				<a class="reg_text" href="?page=News&op=News&action=Add"><?echo "$lang_a_addnews"?></a><br />
				<a class="reg_text" href="?page=News&op=News"><?echo "$lang_a_newsman"?></a><br />
				<a class="reg_text" href="?page=News&op=Comments"><?echo "$lang_a_comments"?></a><br />

				</DIV></td>
			</tr>
			<tr>
				<td colspan="2" height="15"></td>
			</tr>
			</table>
		</div>
<?
	// Disable the descriptions in the config file
	if ($descriptions_enabled == "1") {
?>
		<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_desc_deschead"?></span></div>
		<div style="padding: 5px; width: 484px;">

		<table cellpadding="0" cellspacing="0" border="0" width="100%">
		<tr>
			<td valign="top" width="1%"><img hspace="5" align="absmiddle" src="images/a.jpg"></td>
			<td valign="top" width="99%"><DIV class="reg_text"><strong><?echo "$lang_a_addnews"?></strong><br />

			<SPAN class="reg_text"><?echo "$lang_a_desc_addnews"?></SPAN>

			</DIV></td>
		</tr>
		<tr>
			<td colspan="2" height="15"></td>
		</tr>
		<tr>
			<td valign="top" width="1%"><img hspace="5" align="absmiddle" src="images/a.jpg"></td>
			<td valign="top" width="99%"><DIV class="reg_text"><strong><?echo "$lang_a_newsman"?></strong><br />

			<SPAN class="reg_text"><?echo "$lang_a_desc_news"?></SPAN>

			</DIV></td>
		</tr>
		<tr>
			<td colspan="2" height="15"></td>
		</tr>
		<tr>
			<td valign="top" width="1%"><img hspace="5" align="absmiddle" src="images/a.jpg"></td>
			<td valign="top" width="99%"><DIV class="reg_text"><strong><?echo "$lang_a_comments"?></strong><br />

			<SPAN class="reg_text"><?echo "$lang_a_desc_comments"?></SPAN>

			</DIV></td>
		</tr>
		<tr>
			<td colspan="2" height="15"></td>
		</tr>
		</table>
		</div>
<?
	}
} // Op

//============================================================================================================
//	NEWS MANAGEMENT
//-------------------------------------------------------------------------------------------------------------------------------------------
if ($_REQUEST[op] == "News") {
?>
	<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_news"?></span></div>
	<div style="padding: 5px; width: 484px;">
<?
//===============================================================
//	NO ACTION - DEFAULT NEWS MANAGEMENT PAGE
//---------------------------------------------------------------------------------

	if (!$_REQUEST[action]) {

echo "	<table align=\"center\" width=\"100%\" $tablereg>
	<tr>
		<td width=\"100%\" $tdreg3><SPAN class=\"head_text\"><strong> $lang_a_newsearch</td>
	</tr>
	<tr>
		<td width=\"100%\">

		<table width=\"100%\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\">
			<td><div class=\"reg_text\">

			<form method=\"post\" action=\"index.php?page=News&op=News&exec=search&search_method=name\">

			<SPAN class=\"reg_text\">$lang_a_searchbytitle: <input type=text name=\"search\" size=\"30\" class=\"input\">

			<input type=\"submit\" name=\"Search\" value=\"$lang_a_search\" class=\"submit\">
			</form>
			</td>
		</table>

	</td>
	</table>";

//===============================================================
//	NEWS SEARCH
//---------------------------------------------------------------------------------

		if (isset($_POST[search])) {
?>
		</div>

		<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_results"?></span></div>
		<div style="padding: 5px; width: 484px;">
<?
			$srch = "%$_POST[search]%";
			$search_term = "$_POST[search]";

			$query = "select * from ccms_news WHERE title LIKE '$srch'";
			$result = mysql_query($query);
			$count_news = mysql_num_rows($result);

			if ($count_news < 1) {

echo "		<table align=\"center\" width=\"100%\" $tablereg>
		<tr>
			<td width=\"100%\" $tdreg colspan=2><SPAN class=\"reg_text\"><center>$lang_a_nores</td>
		</tr>
		</table>";

			} else {

echo "			<table width=\"100%\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\">
				<td><SPAN class=\"reg_text\">$lang_a_results_for <strong>$search_term</strong>:</td>
			</table>

			<table align=\"center\" width=\"100%\" $tablereg>
			<tr>
				<td width=\"45%\" $tdreg3><SPAN class=\"nav_text\"> $lang_a_newstitle</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_dateposted</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_author</td>
				<td width=\"15%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_views</td>
			</tr>";

				while ($r = mysql_fetch_assoc($result)) {

echo "			<tr>
				<td width=\"45%\" $tdreg><SPAN class=\"reg_text\"><DIV class=\"reg_text\"><img hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\"><a class=\"reg_text\" href=\"index.php?page=News&op=News&action=edit&id=$r[id]\">";

				if (!$r[title]) {
					echo "No Title!";
				} else {
					echo "$r[title]";
				}

echo "				</a></td>
				<td width=\"20%\" $tdreg><SPAN class=\"reg_text\">";

					if ($r[timestamp] == "0" || !$r[timestamp]) {

						echo "$r[date]";

					} else {
						echo date("d/m/Y", $r[timestamp]);
					}

				echo "</SPAN></td>
				<td width=\"20%\" $tdreg><a href=\"index.php?page=Users&op=User Management&action=edit&user=$r[author]\" class=\"reg_text\">$r[author]</a></td>
				<td width=\"15%\" $tdreg><SPAN class=\"reg_text\">";

				echo number_format($r[views]);

echo "				</td>
			</tr>";
				}
echo "			</table>";

			}

		} else {

//===============================================================
//	NO SEARCH - DISPLAY LAST 10 POSTS
//---------------------------------------------------------------------------------
?>
		</div>

		<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_latest"?></span></div>
		<div style="padding: 5px; width: 484px;">
<?
			$query = "select * from ccms_news ORDER BY id desc limit 10";
			$result = mysql_query($query);

echo "			<table align=\"center\" width=\"100%\" $tablereg>
			<tr>
				<td width=\"45%\" $tdreg3><SPAN class=\"nav_text\"> $lang_a_newstitle</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_dateposted</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_author</td>
				<td width=\"15%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_views</td>
			</tr>";

				while ($r = mysql_fetch_assoc($result)) {
echo "			<tr>
				<td width=\"45%\" $tdreg><SPAN class=\"reg_text\"><DIV class=\"reg_text\"><img hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\"><a class=\"reg_text\" href=\"index.php?page=News&op=News&action=edit&id=$r[id]\">";

				if (!$r[title]) {
					echo "No Title!";
				} else {
					echo "$r[title]";
				}

echo "				</a></td>
				<td width=\"20%\" $tdreg><SPAN class=\"reg_text\">";

					if ($r[timestamp] == "0" || !$r[timestamp]) {

						echo "$r[date]";

					} else {
						echo date("d/m/Y", $r[timestamp]);
					}

				echo "</SPAN></td>
				<td width=\"20%\" $tdreg><a href=\"index.php?page=Users&op=User Management&action=edit&user=$r[author]\" class=\"reg_text\">$r[author]</a></td>
				<td width=\"15%\" $tdreg><SPAN class=\"reg_text\">";

				echo number_format($r[views]);

echo "				</td>
			</tr>\n";
				}
echo "			</table>\n";
?>
		</div>

		<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_submittednews"?></span></div>
		<div style="padding: 5px; width: 484px;">
<?
//===============================================================
//	DISPLAY SUBMITTED NEWS ITEMS
//---------------------------------------------------------------------------------

		if (!$_POST[delete]) {
		} else {

			$count_num = count($HTTP_POST_VARS[checkbox]);

			for ($i=0;$i<$count_num;$i++){
				$del_id = $HTTP_POST_VARS[checkbox][$i];
				$sql = "DELETE FROM ccms_news_submit WHERE id='$del_id'";
				mysql_query($sql);
			}
		}

		$query = "SELECT * from ccms_news_submit order by id asc";
		$result = mysql_query($query);
		$count = mysql_num_rows($result);

echo "			<table align=\"center\" width=\"100%\" $tablereg>
			<form name=\"remove\" method=\"post\" action=\"\">
			<tr>
				<td width=\"45%\" $tdreg3><SPAN class=\"nav_text\"> $lang_a_newstitle</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_author</td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_actions</td>
				<td width=\"15%\" $tdreg3 colspan=\"2\"><SPAN class=\"nav_text\">$lang_a_remove</td>
			</tr>\n";

			while ($r = mysql_fetch_assoc($result)) {
echo "			<tr>
				<td width=\"45%\" $tdreg><SPAN class=\"reg_text\"><DIV class=\"reg_text\"><img hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\"><a class=\"reg_text\" href=\"index.php?page=News&op=News&action=approve&id=$r[id]\">";

				if (!$r[title]) {
					echo "No Title!";
				} else {
					echo "$r[title]";
				}

echo "				</a></td>
				<td width=\"20%\" $tdreg><a href=\"index.php?page=Users&op=User Management&action=edit&user=$r[author]\" class=\"reg_text\">$r[author]</a></td>
				<td width=\"20%\" $tdreg><a href=\"index.php?page=News&op=News&action=approve&id=$r[id]\" class=\"reg_text\">$lang_a_review</a></td>
			      	<td width=\"15%\" $tdreg><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$r[id]\"></td>
			</tr>\n";

			}

			if ($count < 1) {
echo "			<tr>
				<td width=\"100%\" colspan=\"4\" $tdreg><SPAN class=\"reg_text\"><img hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\">$lang_a_nosubmitted</SPAN></td></td>
			</tr>\n";

			} else {

echo "			<tr>
				<td width=\"100%\" colspan=\"4\" $tdreg2><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"$lang_a_remove\" class=\"submit\"></td>
			</tr>
			</table>\n";

			}

echo "			</form>
			</table>\n\n";

		}

	} // <-- No action, news management

//===============================================================
//	ADD NEWS
//---------------------------------------------------------------------------------

	if ($_REQUEST[action] == "Add") {

		if (!$_POST[SUBMIT]) {
		} else {

			$platforms = $HTTP_POST_VARS['platform_selected'];
			for ($i = 0; $i < count($platforms); $i++) {

			$pform = $platforms[$i];

				if ($_POST[featured] == "1") {

					if ($i == "0") {
						$featured_ins = 1;
					} else {
						$featured_ins = 0;
					}
				}

				if (!$_POST[image_input]) {

					if (!$_FILES[image][name]) {
					} else {
						$time = date("Ymd");

						$filenamea = str_replace("?", "", $_FILES[image][name]);
						$filenameb = str_replace(":", "", $filenamea);
						$filenamec = str_replace(" ", "", $filenameb);

						$add = "../images/uploads/$time" . "_" . "$filenamec";
						copy($_FILES[image][tmp_name], $add);
						chmod("$add",0777);
						$add_url = str_replace('../','', $add);
					}

				} else {
					$add_url = $_POST[image_input];
				}

				$title = str_replace("'", "’", $_POST[title]);
				$news = str_replace("'", "’", $_POST[news]);
				$news2 = str_replace("'", "’", $_POST[news2]);
				$preview = str_replace("'", "’", $_POST[preview]);

				if (!$_POST[gametyped] || $_POST[gametyped] == "Type in title") {
					$game = "$_POST[game]";
				} else {
					$game = "$_POST[gametyped]";
				}

				$timestamp = time();

				mysql_query("INSERT INTO ccms_news SET allow_rating='$_POST[ratings]', allow_comments='$_POST[comments]', title='$title', tag='$_POST[tag]', date='$_POST[date_inp]', author='$_POST[author]', prev_news='$preview', archive_month='$_POST[archive_month]', game=\"$game\", platform='$pform', featured='$featured_ins', image='$add_url', link='$_POST[link]', source='$_POST[source]', news='$news', news2='$news2', timestamp='$timestamp'");

echo "				<SPAN class=\"reg_text\"><strong>$lang_a_done</strong></SPAN><br />
				<meta http-equiv=\"refresh\" content=\"1; url=index.php?page=News&op=News\">\n";
			}
		}

		if (!$_POST[SUBMIT]) {

			$date = date("$time_an");	// Static date
			$month = date("F Y");	// Archive month

echo "		<table align=\"center\" width=\"100%\" $tablereg>
		<form action=\"index.php?page=News&op=News&action=Add\" method=\"post\" enctype=\"multipart/form-data\">
		<input type=\"hidden\" name=\"date_inp\" value=\"$date\">
		<input type=\"hidden\" name=\"archive_month\" value=\"$month\">
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg3><SPAN class=\"head_text\"><strong> $lang_a_addnews</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_tag</strong></td>
			<td width=\"45%\" $tdreg><input name=\"tag\" size=\"30\" class=\"input\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_title</strong></td>
			<td width=\"45%\" $tdreg><input name=\"title\" size=\"30\" class=\"input\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_image</strong></td>
			<td width=\"45%\" $tdreg><input type=\"file\" name=\"image\" size=\"18\" class=\"input\"><br />
			<input name=\"image_input\" size=\"30\" class=\"input\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_author</strong></td>
			<td width=\"45%\" $tdreg><input name=\"author\" size=\"30\" value=\"$username\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_sourceurl</strong></td>
			<td width=\"45%\" $tdreg><input name=\"source\" size=\"30\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"100%\" $tdreg2 colspan=\"3\"><SPAN class=\"nav_text\"> $lang_a_preview</td>
		</tr>
		<tr>
			<td width=\"100%\"  colspan=\"3\" $tdreg2><textarea name=\"preview\" rows=\"4\" style=\"width: 100%;\" class=\"textbox\"></textarea></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_platform</strong><br />
			<SPAN class=\"nav_text\">$lang_a_platdrag</td>
			<td width=\"45%\" $tdreg><select name=\"platform_selected[]\" MULTIPLE multiple=\"yes\" size=\"5\" class=\"dropdown\">

			<option value=\"\" SELECTED>$lang_a_nps</option>\n";

   			$platforms = mysql_query("SELECT * from ccms_platform order by name asc");
			while ($row = mysql_fetch_assoc($platforms)) {
echo "				<option value=\"$row[icon]\">$row[name]</option>\n";
			}
	
echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_game</strong></td>
			<td width=\"45%\" $tdreg><input type=\"text\" size=\"30\" name=\"gametyped\" class=\"input\" value=\"Type in title\" onfocus=\"this.value=''\"><br />

			<select name=\"game\" class=\"input\">
			<option value=\"\" SELECTED>$lang_a_ngs</option>\n";

			$games = mysql_query("SELECT DISTINCT title from ccms_gameindex order by title asc");

			while ($row = mysql_fetch_assoc($games)) {
echo "				<option value=\"$row[title]\">$row[title]</option>\n";
			}

echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

			$oFCKeditor = new FCKeditor('news') ;
			$oFCKeditor->BasePath = "$fck_basepath";
			$oFCKeditor->Value = "";
			$oFCKeditor->Create() ;

 echo "			</td> 
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

			$oFCKeditor = new FCKeditor('news2') ;
			$oFCKeditor->BasePath = "$fck_basepath";
			$oFCKeditor->Value = "";
			$oFCKeditor->Create();

 echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_homepageq</strong><br />
			<SPAN class=\"nav_text\">$lang_a_featuresdesc</td>
		             <td width=\"45%\" $tdreg>

				<table><td><input checked type=\"radio\" name=\"featured\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"featured\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>

			</td>
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_ratings</strong><br />
			<SPAN class=\"nav_text\">$lang_a_ratingsdesc</td>
		             <td width=\"45%\" $tdreg>

				<table><td><input checked type=\"radio\" name=\"ratings\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"ratings\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>

			</td>
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_comments</strong><br />
			<SPAN class=\"nav_text\">$lang_a_commentsdesc</td>
		             <td width=\"45%\" $tdreg>

				<table><td><input checked type=\"radio\" name=\"comments\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"comments\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>

			</td>
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg2><input type=\"SUBMIT\" name=\"SUBMIT\" value=\"$lang_a_submit\" class=\"submit\"></td>
		</tr>
		</form>
		</table>\n";

		}
	}

//===============================================================
//	EDIT NEWS POST
//---------------------------------------------------------------------------------

	if ($_REQUEST[action] == "edit") {

		if ($_REQUEST[edit] == "delete") {

			mysql_query("DELETE FROM ccms_news where id='$_REQUEST[id]'");

echo "			<SPAN class=\"reg_text\"><strong>$lang_a_done</strong><br />
			<meta http-equiv=\"refresh\" content=\"1; url=index.php?page=News&op=News\">\n";
		}

		if ($_REQUEST[edit] == "do") {

			if (!$_POST[gametyped] || $_POST[gametyped] == "Type in title") {
				$game = "$_POST[game]";
			} else {
				$game = "$_POST[gametyped]";
			}

			if (!$_FILES[image][name]) {

				$add_url = "$_POST[oimage]";

			} else {
				$time = date("Ymd");
				$filenamea = str_replace("?", "", $_FILES[image][name]);
				$filenameb = str_replace(":", "", $filenamea);
				$filenamec = str_replace(" ", "", $filenameb);

				$add = "../images/uploads/$time" . "_" . "$filenamec";
				copy($_FILES[image][tmp_name], $add);
				chmod("$add",0777);
				$add_url = str_replace("../", "", $add);
			}

			$title = str_replace("'", "’", $_POST[title]);
			$news = str_replace("'", "’", $_POST[news]);
			$news2 = str_replace("'", "’", $_POST[news2]);
			$preview = str_replace("'", "’", $_POST[preview]);

			if (!$_POST[gametyped] || $_POST[gametyped] == "Type in title") {
				$game = "$_POST[game]";
			} else {
				$game = "$_POST[gametyped]";
			}

			mysql_query("UPDATE ccms_news SET allow_rating='$_POST[ratings]', allow_comments='$_POST[comments]', title='$title', tag='$_POST[tag]', author='$_POST[author]', prev_news='$preview', game=\"$game\", platform='$_POST[platform]', featured='$_POST[featured]', image='$add_url', link='$_POST[link]', source='$_POST[source]', news='$news', news2='$news2' where id='$_REQUEST[id]'");

echo "				<SPAN class=\"reg_text\"><strong>$lang_a_done</strong><br />
				<meta http-equiv=\"refresh\" content=\"1; url=index.php?page=News&op=News\">\n";

		} else {

			$news_info = mysql_query("SELECT * FROM ccms_news where id='$_REQUEST[id]'");
			while ($ccms = mysql_fetch_assoc($news_info)) {

echo "		<a class=\"reg_text\" href=\"index.php?page=News&op=News&action=edit&id=$_REQUEST[id]&edit=delete\"><img border=\"0\" hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\"><strong>$lang_a_delete</strong></a></SPAN><br /><br />";

echo "		<table align=\"center\" width=\"100%\" $tablereg>
		<form action=\"index.php?page=News&op=News&action=edit&id=$_REQUEST[id]&edit=do\" method=\"post\" enctype=\"multipart/form-data\">
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg3><SPAN class=\"head_text\"><strong> $lang_a_enews</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_tag</strong></td>
			<td width=\"45%\" $tdreg><input name=\"tag\" size=\"30\" class=\"input\" value=\"$ccms[tag]\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_title</strong></td>
			<td width=\"45%\" $tdreg><input name=\"title\" size=\"30\" class=\"input\" value=\"$ccms[title]\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_image</strong>\n";

			if ($ccms[image] == NULL) {
			} else {
echo "				- <a class=\"reg_text\" href=\"removeimage.php?url=$ccms[image]\" target=\"_new\">$lang_a_delete</a>";
			}

			echo "</SPAN></td>
			<td width=\"45%\" $tdreg2><input name=\"oimage\" value=\"$ccms[image]\" size=\"30\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_newimg</strong></SPAN></td>
			<td width=\"45%\" $tdreg2><input type=\"file\" name=\"image\" size=\"18\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_author</strong></td>
			<td width=\"45%\" $tdreg><input name=\"author\" size=\"30\" value=\"$ccms[author]\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_sourceurl</strong></td>
			<td width=\"45%\" $tdreg><input name=\"source\" size=\"30\" class=\"input\" value=\"$ccms[source]\"></td>
		</tr>
		<tr>
			<td width=\"100%\" $tdreg2 colspan=\"3\"><SPAN class=\"nav_text\"> $lang_a_preview</td>
		</tr>
		<tr>
			<td width=\"100%\"  colspan=\"3\" $tdreg2><textarea name=\"preview\" rows=\"4\" style=\"width: 100%;\" class=\"textbox\">$ccms[prev_news]</textarea></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_platform</strong></td>
			<td width=\"45%\" $tdreg><select name=\"platform\" class=\"dropdown\">

			<option value=\"\">$lang_a_nps</option>\n";

   			$platforms = mysql_query("SELECT * from ccms_platform order by name asc");
			while ($row = mysql_fetch_assoc($platforms)) {

				if ($ccms[platform] == "$row[icon]") {
echo "					<option SELECTED value=\"$row[icon]\">$row[name]</option>\n";
				} else {
echo "					<option value=\"$row[icon]\">$row[name]</option>\n";
				}
			}
	
echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_game</strong></td>
			<td width=\"45%\" $tdreg><input type=\"text\" size=\"30\" name=\"gametyped\" class=\"input\" value=\"\" onfocus=\"this.value=''\"><br />

			<select name=\"game\" class=\"input\">
			<option value=\"\">$lang_a_ngs</option>\n";

			$games = mysql_query("SELECT DISTINCT title from ccms_gameindex order by title asc");

			while ($row = mysql_fetch_assoc($games)) {

				if ($ccms[game] == "$row[title]") {
echo "					<option SELECTED value=\"$row[title]\">$row[title]</option>\n";
				} else {
echo "					<option value=\"$row[title]\">$row[title]</option>\n";
				}
			}

echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

			$oFCKeditor = new FCKeditor('news') ;
			$oFCKeditor->BasePath = "$fck_basepath";
			$oFCKeditor->Value = "$ccms[news]";
			$oFCKeditor->Create() ;

 echo "			</td> 
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

			$oFCKeditor = new FCKeditor('news2') ;
			$oFCKeditor->BasePath = "$fck_basepath";
			$oFCKeditor->Value = "$ccms[news2]";
			$oFCKeditor->Create();

 echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_homepageq</strong><br />
			<SPAN class=\"nav_text\">$lang_a_featuresdesc</span></DIV></td>
		             <td width=\"45%\" $tdreg>\n";

			if ($ccms[featured] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"featured\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"featured\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			} else {
echo "				<table><td><input type=\"radio\" name=\"featured\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"featured\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_ratings</strong><br />
			<SPAN class=\"nav_text\">$lang_a_ratingsdesc</td>
		             <td width=\"45%\" $tdreg>\n";

			if ($ccms[allow_rating] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"ratings\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"ratings\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			} else {
echo "				<table><td><input type=\"radio\" name=\"ratings\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"ratings\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_comments</strong><br />
			<SPAN class=\"nav_text\">$lang_a_commentsdesc</td>
		             <td width=\"45%\" $tdreg>\n";

			if ($ccms[allow_comments] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"comments\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"comments\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			} else {
echo "				<table><td><input type=\"radio\" name=\"comments\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"comments\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
			}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg2><input type=\"SUBMIT\" name=\"SUBMIT\" value=\"$lang_a_update\" class=\"submit\"></td>
		</tr>
		</form>
		</table>\n";

		}
	}

}

//===============================================================
//	APPROVE SUBMITTED NEWS
//---------------------------------------------------------------------------------

	if ($_REQUEST[action] == "approve") {

		if ($_REQUEST[edit] == "delete") {

			mysql_query("DELETE FROM ccms_news_submit where id='$_REQUEST[id]'");

echo "			<SPAN class=\"reg_text\"><strong>$lang_a_done</strong><br />
			<meta http-equiv=\"refresh\" content=\"1; url=index.php?page=News&op=News\">\n";
		}

		if ($_REQUEST[app] == "do") {

			if (!$_POST[gametyped] || $_POST[gametyped] == "Type in title") {
				$game = "$_POST[game]";
			} else {
				$game = "$_POST[gametyped]";
			}

			if (!$_FILES[image][name]) {

				$add_url = "$_POST[oimage]";

			} else {
				$time = date("Ymd");
				$filenamea = str_replace("?", "", $_FILES[image][name]);
				$filenameb = str_replace(":", "", $filenamea);
				$filenamec = str_replace(" ", "", $filenameb);

				$add = "../images/uploads/$time" . "_" . "$filenamec";
				copy($_FILES[image][tmp_name], $add);
				chmod("$add",0777);
				$add_url = str_replace("../", "", $add);
			}

			$title = str_replace("'", "’", $_POST[title]);
			$news = str_replace("'", "’", $_POST[news]);
			$news2 = str_replace("'", "’", $_POST[news2]);
			$preview = str_replace("'", "’", $_POST[preview]);

			if (!$_POST[gametyped] || $_POST[gametyped] == "Type in title") {
				$game = "$_POST[game]";
			} else {
				$game = "$_POST[gametyped]";
			}

			mysql_query("INSERT INTO ccms_news SET date='$_POST[date_inp]', archive_minth='$_POST[archive_month]', allow_rating='$_POST[ratings]', allow_comments='$_POST[comments]', title='$title', tag='$_POST[tag]', author='$_POST[author]', prev_news='$preview', game=\"$game\", platform='$_POST[platform]', featured='$_POST[featured]', image='$add_url', link='$_POST[link]', source='$_POST[source]', news='$news', news2='$news2', timestamp='$timestamp'");
			mysql_query("DELETE FROM ccms_news_submit where id='$_REQUEST[id]'");

echo "				<SPAN class=\"reg_text\"><strong>$lang_a_done</strong><br />
				<meta http-equiv=\"refresh\" content=\"1; url=index.php?page=News&op=News\">\n";

		} else {

			$news_info = mysql_query("SELECT * FROM ccms_news_submit where id='$_REQUEST[id]'");
			while ($ccms = mysql_fetch_assoc($news_info)) {

				$date = date("$time_an");	// Static date
				$month = date("F Y");	// Archive month

echo "		<a class=\"reg_text\" href=\"index.php?page=News&op=News&action=approve&id=$_REQUEST[id]&edit=delete\"><img border=\"0\" hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\"><strong>$lang_a_delete</strong></a></SPAN><br /><br />";

echo "		<table align=\"center\" width=\"100%\" $tablereg>
		<form action=\"index.php?page=News&op=News&action=approve&id=$_REQUEST[id]&app=do\" method=\"post\" enctype=\"multipart/form-data\">
		<input type=\"hidden\" name=\"date_inp\" value=\"$date\">
		<input type=\"hidden\" name=\"archive_month\" value=\"$month\">
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg3><SPAN class=\"head_text\"><strong> $lang_a_enews</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_tag</strong></td>
			<td width=\"45%\" $tdreg><input name=\"tag\" size=\"30\" class=\"input\" value=\"$ccms[tag]\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_title</strong></td>
			<td width=\"45%\" $tdreg><input name=\"title\" size=\"30\" class=\"input\" value=\"$ccms[title]\"></td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_image</strong>\n";

				if ($ccms[image] == NULL) {
				} else {
echo "				- <a class=\"reg_text\" href=\"removeimage.php?url=$ccms[image]\" target=\"_new\">$lang_a_delete</a>\n";
				}

			echo "</SPAN></td>
			<td width=\"45%\" $tdreg2><input name=\"oimage\" value=\"$ccms[image]\" size=\"30\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_newimg</strong></SPAN></td>
			<td width=\"45%\" $tdreg2><input type=\"file\" name=\"image\" size=\"18\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_author</strong></td>
			<td width=\"45%\" $tdreg><input name=\"author\" size=\"30\" value=\"$ccms[author]\" class=\"input\"></td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"center\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_sourceurl</strong></td>
			<td width=\"45%\" $tdreg><input name=\"source\" size=\"30\" class=\"input\" value=\"$ccms[source]\"></td>
		</tr>
		<tr>
			<td width=\"100%\" $tdreg2 colspan=\"3\"><SPAN class=\"nav_text\"> $lang_a_preview</td>
		</tr>
		<tr>
			<td width=\"100%\"  colspan=\"3\" $tdreg2><textarea name=\"preview\" rows=\"4\" style=\"width: 100%;\" class=\"textbox\">$ccms[prev_news]</textarea></td> 
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_platform</strong></td>
			<td width=\"45%\" $tdreg><select name=\"platform\" class=\"dropdown\">

			<option value=\"\">$lang_a_nps</option>\n";

   				$platforms = mysql_query("SELECT * from ccms_platform order by name asc");
				while ($row = mysql_fetch_assoc($platforms)) {

					if ($ccms[platform] == "$row[icon]") {
echo "						<option SELECTED value=\"$row[icon]\">$row[name]</option>\n";
					} else {
echo "						<option value=\"$row[icon]\">$row[name]</option>\n";
					}
				}
	
echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"1%\" valign=\"top\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
			<td width=\"54%\" $tdreg2 valign=\"top\"><SPAN class=\"reg_text\"><strong>$lang_a_game</strong></td>
			<td width=\"45%\" $tdreg><input type=\"text\" size=\"30\" name=\"gametyped\" class=\"input\" value=\"\" onfocus=\"this.value=''\"><br />

			<select name=\"game\" class=\"input\">
			<option value=\"\">$lang_a_ngs</option>\n";

				$games = mysql_query("SELECT DISTINCT title from ccms_gameindex order by title asc");
				while ($row = mysql_fetch_assoc($games)) {

					if ($ccms[game] == "$row[title]") {
echo "						<option SELECTED value=\"$row[title]\">$row[title]</option>\n";
					} else {
echo "						<option value=\"$row[title]\">$row[title]</option>\n";
					}
				}

echo "			</select>
			</td>
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

				$oFCKeditor = new FCKeditor('news') ;
				$oFCKeditor->BasePath = "$fck_basepath";
				$oFCKeditor->Value = "$ccms[news]";
				$oFCKeditor->Create() ;
	
 echo "			</td> 
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" style=\"width: 100%;\" $tdreg2>\n";

				$oFCKeditor = new FCKeditor('news2') ;
				$oFCKeditor->BasePath = "$fck_basepath";
				$oFCKeditor->Value = "$ccms[news2]";
				$oFCKeditor->Create();

 echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_homepageq</strong><br />
			<SPAN class=\"nav_text\">$lang_a_featuresdesc</span></DIV></td>
		             <td width=\"45%\" $tdreg>\n";

				if ($ccms[featured] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"featured\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"featured\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				} else {
echo "				<table><td><input type=\"radio\" name=\"featured\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"featured\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_ratings</strong><br />
			<SPAN class=\"nav_text\">$lang_a_ratingsdesc</td>
		             <td width=\"45%\" $tdreg>\n";

				if ($ccms[allow_rating] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"ratings\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"ratings\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				} else {
echo "				<table><td><input type=\"radio\" name=\"ratings\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"ratings\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"1%\" $tdreg2><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"></td>
		             <td width=\"54%\" $tdreg2><SPAN class=\"reg_text\"><strong>$lang_a_comments</strong><br />
			<SPAN class=\"nav_text\">$lang_a_commentsdesc</td>
		             <td width=\"45%\" $tdreg>\n";

				if ($ccms[allow_comments] == '1') {
echo "				<table><td><input checked type=\"radio\" name=\"comments\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"comments\" value=\"0\"></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				} else {
echo "				<table><td><input type=\"radio\" name=\"comments\" value=\"1\"></td><td><SPAN class=\"reg_text\">$lang_a_yes</td><td><input type=\"radio\" name=\"comments\" value=\"0\" checked></td><td><SPAN class=\"reg_text\">$lang_a_no</td></table>";
				}

echo "			</td> 
		</tr>
		<tr>
			<td width=\"100%\" colspan=\"3\" $tdreg2><input type=\"SUBMIT\" name=\"SUBMIT\" value=\"$lang_a_submit\" class=\"submit\"></td>
		</tr>
		</form>
		</table>\n";

			}
		}
	}
}

//============================================================================================================
//	COMMENT MANAGEMENT
//-------------------------------------------------------------------------------------------------------------------------------------------
if ($_REQUEST[op] == "Comments") {
?>
	<div class="divlarge"><span class="divsmall_text2">  <?echo "$lang_a_comments"?></span></div>
	<div style="padding: 5px; width: 484px;">
<?
//===============================================================
//	NO ACTION - COMMENT MANAGEMENT PAGE
//---------------------------------------------------------------------------------

	if (!$_REQUEST[action]) {

		if (!$_POST[delete]) {
		} else {

			$count_num = count($HTTP_POST_VARS[checkbox]);

			for ($i=0;$i<$count_num;$i++){
				$del_id = $HTTP_POST_VARS[checkbox][$i];
				$sql = "DELETE FROM ccms_news_comments WHERE id='$del_id'";
				mysql_query($sql);
			}
		}

		$nav = isset($_REQUEST['nav']) ? $_REQUEST['nav'] : 1;
		$max_results = "30";
		$start = (($nav * $max_results) - $max_results);

		$query = "SELECT * from ccms_news_comments order by id desc LIMIT $start, $max_results";
		$result = mysql_query($query);
		$count = mysql_num_rows($result);

		$query_total = "SELECT * from ccms_news_comments";
		$result_total = mysql_query($query_total);
		$count_total = mysql_num_rows($result_total);

echo "			<table align=\"center\" width=\"100%\" $tablereg>
			<form name=\"remove\" method=\"post\" action=\"\">
			<tr>
				<td width=\"15%\" $tdreg3><SPAN class=\"nav_text\">ID</SPAN></td>
				<td width=\"20%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_author</SPAN></td>
				<td width=\"28%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_article</SPAN></td>
				<td width=\"34%\" $tdreg3><SPAN class=\"nav_text\">$lang_a_dateposted</SPAN></td>
				<td width=\"5%\" $tdreg3><SPAN class=\"nav_text\"><center>$lang_a_remove</SPAN></td>
			</tr>\n";

		while ($r = mysql_fetch_assoc($result)) {

			$article_info = mysql_query("SELECT * FROM ccms_news where id='$r[w_id]'");
			while ($ccms = mysql_fetch_assoc($article_info)) {

				$article_title = $ccms[title];

				$articlet = preg_replace('/[^a-zA-Z0-9 *]/', '', $ccms[title]); 
				$articlet2 = str_replace(' ', '-', $articlet);
				$articlet3 = strtolower("$articlet2");
			}

			$id = number_format($r[id]);

			if ($r[flagged] == "1") {

echo "			<tr>
				<td width=\"15%\" $tdreg><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"><a class=\"reg_text\" href=\"index.php?page=News&op=Comments&action=edit&id=$r[id]\">$id</a></td>
				<td width=\"20%\" $tdreg><SPAN class=\"reg_text\"><a href=\"index.php?page=Users&op=User Management&action=edit&user=$r[name]\" class=\"reg_text\">$r[name]</a></SPAN></td>
				<td width=\"28%\" $tdreg><a href=\"$siteurl"; echo "/story-$r[w_id]-$articlet3.html#comment$r[id]\" target=\"_new\" class=\"reg_text\">$article_title</a></SPAN></td>
				<td width=\"34%\" $tdreg><SPAN class=\"reg_text\">$r[date]</SPAN></td>
			      	<td width=\"5%\" $tdreg4><center><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$r[id]\"></td>
			</tr>\n";

			} else {

echo "			<tr>
				<td width=\"15%\" $tdreg><img hspace=\"5\" align=\"absmiddle\" src=\"images/a.jpg\"><a class=\"reg_text\" href=\"index.php?page=News&op=Comments&action=edit&id=$r[id]\">$id</a></td>
				<td width=\"20%\" $tdreg><SPAN class=\"reg_text\"><a href=\"index.php?page=Users&op=User Management&action=edit&user=$r[name]\" class=\"reg_text\">$r[name]</a></SPAN></td>
				<td width=\"28%\" $tdreg><a href=\"$siteurl"; echo "/story-$r[w_id]-$articlet3.html#comment$r[id]\" target=\"_new\" class=\"reg_text\">$article_title</a></SPAN></td>
				<td width=\"34%\" $tdreg><SPAN class=\"reg_text\">$r[date]</SPAN></td>
			      	<td width=\"5%\" $tdreg><center><input name=\"checkbox[]\" type=\"checkbox\" id=\"checkbox[]\" value=\"$r[id]\"></td>
			</tr>\n";

			}

			if ($r[flagged] == "1") {
echo "			<tr>
				<td width=\"100%\" colspan=\"5\" $tdreg4><img alt=\"Post flagged by $r[flagged_by]\" style=\"float: left;\" hpsace=\"2\" vspace=\"2\" src=\"images/redflag.gif\"><SPAN class=\"nav_text\"><div class=\"padding10\"><i>"; echo strip_tags($r[comment], ''); echo "</div></i></td>
			</tr>\n";

			} else {
echo "			<tr>
				<td width=\"100%\" colspan=\"5\" $tdreg><SPAN class=\"nav_text\"><div class=\"padding10\"><i>"; echo strip_tags($r[comment], ''); echo "</div></i></td>
			</tr>\n";

			}
		}

		if ($count < 1) {

echo "			<tr>
				<td width=\"100%\" colspan=\"5\" $tdreg><SPAN class=\"reg_text\"><img hspace=\"4\" align=\"absmiddle\" src=\"images/p.jpg\">-</SPAN></td></td>
			</tr>\n";

		} else {

echo "			<tr>
				<td width=\"100%\" colspan=\"5\" $tdreg2><input name=\"delete\" type=\"submit\" id=\"delete\" value=\"$lang_a_remove\" class=\"submit\"></td>
			</tr>\n";
		}

		$total_pages = ceil($count_total / $max_results);
		$mrf = $max_results;

NewGuy · 27 Юни 2011

На хостинга от cpanel-а задал ли си на таза база данни тези права?

Gamerz · 27 Юни 2011

Ползвам VPS и нямам cpanel. Може би трябва да стане от phpmyadmin??

Проблем с качването на новини

Gamerz

Registered

smoke

Registered

Gamerz

Registered

NewGuy

Registered

Gamerz

Registered