Кирилицата проблем

STaNiMiR · 22 Септември 2006

Здравей те! Имам малък проблем с кирилицата когато вкарам в базата дании кирилица и е гледам с phpadmina е наред но когато ми е показва заявката в експлорара вместо кирилица има ????. Направил съм таблиците да са с cp1251_bulgarian_ci..

Admin · 22 Септември 2006

След connect-а сложи един ред:

mysql_connect(localhost,$dbuser,$dbpasswd);
@mysql_select_db($dbname) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
$query="SELECT * from ..................

STaNiMiR · 22 Септември 2006

admin каза:
След connect-а сложи един ред:

mysql_connect(localhost,$dbuser,$dbpasswd);
@mysql_select_db($dbname) or die( "Unable to select database");
$chars="SET CHARACTER SET cp1251";mysql_query($chars);
$query="SELECT * from ..................

Мерси

Noxy · 26 Септември 2006

И аз имам същия проблем...само че имам готов скрипт и незнам как да го преработя... може ли да покажеш как става ?
<?php
// Start PHP
$Mesg = (isset($_GET['Mesg']) ? $_GET['Mesg'] : 'None'); // Check language
$Action = (isset($_GET['Action']) ? $_GET['Action'] : 'Show'); // Check Action
$Type = (isset($_GET['Type']) ? $_GET['Type'] : 'public'); // Check Action
$Offset = (isset($_GET['Offset']) ? $_GET['Offset'] : 0); // Check Action
$Order = (isset($_GET['Order']) ? $_GET['Order'] : 'newsstamp'); // Check Action
$sort = (isset($_GET['Sort']) ? $_GET['Sort'] : 'Default'); // Check Action

// Do includes
include "../Config/mysql.php";
// end includes

// Connect to mysql DB
$dbl = @mysql_connect($hn,$un,$pw) // Connect to mysql dbase
or die ("
<html>
<head>
<title>K2News Management | Administration Control Panel</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1251\">
<link href=\"Templates/template.css\" rel=\"stylesheet\" type=\"text/css\">

</head>

<body bgcolor=\"#e4eaed\" leftmargin=\"0\" topmargin=\"0\" marginwidth=\"0\" marginheight=\"0\">
<Br><BR><BR>
<table width=\"40%\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\" bgcolor=\"415263\" align=center valign=middle>
<tr>
<td class=\"formtop\">
<font color=\"FFFFFF\">Mysql Error</font>
</td>
</tr>
<tr>
<td valign=\"top\">
<table width=\"100%\" border=\"0\" cellpadding=\"4\" cellspacing=\"0\" bgcolor=\"FFFFFF\">
<tr>
<td class=\"row1\"><b><img src='Images/error.gif' border=0></b> <font color=red><b>There has been an error connecting to the mySQL database. Please check your mysql.php file and make sure all the details are correct.</font></b><br></td>
</tr>
</table>
</td>
</tr>
</table>

</body>
");
mysql_select_db($db);
// End connecting

// Do another Include
include "ad_functions.php";
// process language file
$sqlss = mysql_query_err("SELECT * FROM " . $tprefix . "settings WHERE setname='deflang'");
if ($sqlss)
{
while($row = mysql_fetch_array($sqlss))
{
$Lang = $row['setvalue'];
}
}

// End Another Include

// Do Session

session_start();
header("Cache-control: private");

if (!session_is_registered('k2news_isloggedin')) {
header("Location: index.php?Mesg=Session&Type=SessionCheck");
exit;
}

// Get settings
$sqlab = mysql_query_err("SELECT * FROM " . $tprefix . "settings");
if ($sqlab)
{
while($row = mysql_fetch_array($sqlab))
{
$$row['setname'] = $row['setvalue'];
}
}// Check if user can access this section
$sqlss = mysql_query_err("SELECT * FROM " . $tprefix . "users WHERE username='" . $_SESSION['username'] . "'");
if ($sqlss)
{
while($row = mysql_fetch_array($sqlss))
{
$username = $row['username'];
$selfid = $row['id'];
$level = $row['level'];
$wysiwyg = $row['wysiwyg'];
$posts = $row['postcount'];
$userlang = $row['lang'];
$lastposttime = $row['lastpost'];
}
}

$sqlss = mysql_query_err("SELECT * FROM " . $tprefix . "usergroups WHERE grouplevel='$level'");
if ($sqlss)
{
while($row = mysql_fetch_array($sqlss))
{
$reqneeded = $row['postauthneeded'];
$canauth = $row['canauthorize'];
$modtype = $row['modnewstype'];
$canmod = $row['canmodnews'];
$canadd = $row['canaddnews'];
$candel = $row['candelnews'];
$restrict = $row['restrictposting'];

}
}
if ($canauth !== "yes")
{
$Type = "public";
}
// end check

// Get settings
$sqlab = mysql_query_err("SELECT * FROM " . $tprefix . "settings");
if ($sqlab)
{
while($row = mysql_fetch_array($sqlab))
{
$$row['setname'] = $row['setvalue'];
}
}
// end get
// Check language and load right lang file
if ($userlang == "default" || $userlang == "")
{
include "Lang/" . $Lang . ".php"; // include language file
$flang = $Lang;
}
else
{
if (!file_exists("Lang/" . $userlang . ".php"))
{
$userlang = "en";
}
include "Lang/" . $userlang . ".php"; // include language file
$flang = $userlang;
}
// End lang check

function TimeZone($tz,$stamp)
{
// Start Sub Function
if ($tz == "t14"){ return $stamp + 3600; }
elseif ($tz == "t15") { return $stamp + 7200; }
elseif ($tz == "t16") { return $stamp + 10800; }
elseif ($tz == "t17") { return $stamp + 14400; }
elseif ($tz == "t18") { return $stamp + 18000; }
elseif ($tz == "t19") { return $stamp + 21600; }
elseif ($tz == "t20") { return $stamp + 25200; }
elseif ($tz == "t21") { return $stamp + 28800; }
elseif ($tz == "t22") { return $stamp + 32400; }
elseif ($tz == "t23") { return $stamp + 36000; }
elseif ($tz == "t24") { return $stamp + 39600; }
elseif ($tz == "t25") { return $stamp + 43200; }
elseif ($tz == "t26") { return $stamp + 46800; }
elseif ($tz == "t12") { return $stamp - 3600; }
elseif ($tz == "t11") { return $stamp - 7200; }
elseif ($tz == "t10") { return $stamp - 10800; }
elseif ($tz == "t9") { return $stamp - 14400; }
elseif ($tz == "t8") { return $stamp - 18000; }
elseif ($tz == "t7") { return $stamp - 21600; }
elseif ($tz == "t6") { return $stamp - 25200; }
elseif ($tz == "t5") { return $stamp - 28800; }
elseif ($tz == "t4") { return $stamp - 32400; }
elseif ($tz == "t3") { return $stamp - 36000; }
elseif ($tz == "t2") { return $stamp - 39600; }
elseif ($tz == "t1") { return $stamp - 43200; }
else { return $stamp; }
// End Sub Function
}

if ($Action == "ProcessForm")
{
$hour = $_POST['hour'];

if ($_POST['timetype'] == "pm")
{
switch ($hour)
{
case 12:
$hour = 12;
break;
case 1:
$hour = 13;
break;
case 2:
$hour = 14;
break;
case 3:
$hour = 15;
break;
case 4:
$hour = 16;
break;
case 5:
$hour = 17;
break;
case 6:
$hour = 18;
break;
case 7:
$hour = 19;
break;
case 8:
$hour = 20;
break;
case 9:
$hour = 21;
break;
case 10:
$hour = 22;
break;
case 11:
$hour = 23;
break;
}
}
if ($_POST['timetype'] == "am")
{
if ($hour == 12)
{
$hour = 0;
}
}
$newsstamp = mktime($hour, $_POST['minute'], '0', $_POST['month'], $_POST['day'], $_POST['year']);

// mod form
if ($canmod !== "yes")
{
header("Location: ad_main.php?Mesg=NoPerm");
exit;
}

$id = $_POST['newsid'];
$dowhat = $_POST['dowhat'];
if ($dowhat == "save")
{
if ($reqneeded == "yes")
{
$status = "unval";
}
else
{
$status = "public";
}

}
elseif ($dowhat == "preview")
{
// -----------------------------------------
$status = "preview";
// -----------------------------------------
}
elseif ($dowhat == "unpreview")
{
// -----------------------------------------
if ($reqneeded == "yes")
{
$status = "unval";
}
else
{
$status = "public";
}
// -----------------------------------------
}
elseif ($dowhat == "auth")
{
if ($canauth == "yes")
{
$status = "public";
}
else
{
$status = "unval";
}
}
elseif ($dowhat == "unstick")
{
$stickstr = "sticky='no',";
}
else
{
$stickstr = NULL;
$status = $_POST['status'];
}

$values = NULL;
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "newsfields ORDER BY addorder ASC");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
if ($row['fieldtype'] == "knews2_subject")
{
$values .= "," . $row['intname'] . "='" . addslashes($_POST['' . $row['intname'] . '']) . "'";
}
elseif ($row['fieldtype'] == "knews2_news")
{
if ($ahtml !== "yes")
{
$values .= "," . $row['intname'] . "='" . strip_tags(addslashes($_POST['' . $row['intname'] . ''])) . "'";
}
else
{
$values .= "," . $row['intname'] . "='" . addslashes($_POST['' . $row['intname'] . '']) . "'";
}
}
else
{
$values .= "," . $row['intname'] . "='" . $_POST['' . $row['intname'] . ''] . "'";
}
}
}
mysql_query_err("UPDATE " . $tprefix . "news SET " . $stickstr . "newsstamp='$newsstamp', status='$status'$values WHERE id='" . $id . "'");

if (isset($_POST['postedby']))
{
if ($_POST['postedby'] !== NULL)
{
mysql_query_err("UPDATE " . $tprefix . "news SET authorid='" . $_POST['postedby'] . "' WHERE id='" . $id . "'");
}
}
// Do log
if ($username !== "root")
{
$logip = $_SERVER['REMOTE_ADDR'];
$logpath = $_SERVER['PHP_SELF'];
$logtime = $now = strtotime(gmdate("F d Y H:i:s"));
$logtime = GetTimeZone($timezone,$logtime);
mysql_query_err("INSERT INTO ". $tprefix ."log VALUES('','$logip','$logtime','$logpath','Modified News Item (ID: " . $id . ")','$username')");
}
//end log
include "../Classes/news.class.php";

if ($status == "unval")
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Mesg=ItemAuthorized&Type=unval");
}
elseif ($status == "saved")
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Mesg=ItemMoved&Type=saved");
}
elseif ($status == "preview")
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Action=ModForm&id=" . $id);
}
else
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Mesg=NewsModded");
}
exit;
// process mod form
}
elseif ($Action == "ProcessAddForm")
{
// process form
if ($canadd !== "yes")
{
header("Location: ad_main.php?Mesg=NoPerm");
exit;
}

$hour = $_POST['hour'];

if ($_POST['timetype'] == "pm")
{
switch ($hour)
{
case 12:
$hour = 12;
break;
case 1:
$hour = 13;
break;
case 2:
$hour = 14;
break;
case 3:
$hour = 15;
break;
case 4:
$hour = 16;
break;
case 5:
$hour = 17;
break;
case 6:
$hour = 18;
break;
case 7:
$hour = 19;
break;
case 8:
$hour = 20;
break;
case 9:
$hour = 21;
break;
case 10:
$hour = 22;
break;
case 11:
$hour = 23;
break;
}
}
if ($_POST['timetype'] == "am")
{
if ($hour == 12)
{
$hour = 0;
}
}
$newsstamp = mktime($hour, $_POST['minute'], '0', $_POST['month'], $_POST['day'], $_POST['year']);

$posted = $selfid;
$posts++;
$dowhat = $_POST['dowhat'];
if ($dowhat == "mpost")
{
$myposts = "yes";
$sticky = "no";
$preview = "no";
}
elseif ($dowhat == "sticky")
{
$myposts = "no";
$sticky = "yes";
$preview = "no";
}
elseif ($dowhat == "preview")
{
$myposts = "no";
$sticky = "no";
$preview = "yes";
}
else
{
$myposts = "no";
$sticky = "no";
$preview = "no";
}
$additem = (isset($_POST['additem']) ? true : false);

if ($myposts == "yes")
{
$action = "NewsSaved";
$status = "saved";

}
elseif ($preview == "yes")
{
$status = "preview";
}
else
{
if ($reqneeded == "yes")
{
$action = "NewsAddedVal";
$status = "unval";
}
else
{
$action = "NewsAdded";
$status = "public";
}

}
$values = NULL;
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "newsfields ORDER BY addorder ASC");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
if ($row['fieldtype'] == "knews2_subject")
{
$values .= ",'" . addslashes($_POST['' . $row['intname'] . '']) . "'";
}
elseif ($row['fieldtype'] == "knews2_news")
{
if ($ahtml !== "yes")
{
$values .= ",'" . strip_tags(addslashes($_POST['' . $row['intname'] . ''])) . "'";
}
else
{
$values .= ",'" . addslashes($_POST['' . $row['intname'] . '']) . "'";
}
}
else
{
$values .= ",'" . $_POST['' . $row['intname'] . ''] . "'";
}
}
}

mysql_query_err("INSERT INTO " . $tprefix . "news VALUES('','$newsstamp','$posted','$sticky','$status','0','0','0'$values)");

$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "news WHERE newsstamp='$newsstamp'");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
$NewsID = $row['id'];
}

}
$news_temp = GetTemplate("Newsletter.tpl");
$news_temp_subject = GetTemplate("Newsletter-Subject.tpl");
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "newsletter");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
$news_temp = str_replace("{Username}", $row['name'], $news_temp);
$news_temp = str_replace("{Email}", $row['email'], $news_temp);

$news_temp = addslashes($news_temp);
eval("\$news_temp = \"$news_temp\";");
$news_temp = stripslashes($news_temp);

$news_temp_subject = str_replace("{Username}", $row['name'], $news_temp_subject);
$news_temp_subject = str_replace("{Email}", $row['email'], $news_temp_subject);

$news_temp_subject = addslashes($news_temp_subject);
eval("\$news_temp_subject = \"$news_temp_subject\";");
$news_temp_subject = stripslashes($news_temp_subject);

$semail = $row['email'];
mail($semail, $news_temp_subject, $news_temp, "From: <" . $contact . ">\n". "Reply-To: <" . $contact . ">\n");
}
}

$posttime = $now = strtotime(gmdate("F d Y H:i:s"));
$posttime = GetTimeZone($timezone,$posttime);
mysql_query_err("UPDATE " . $tprefix . "users SET postcount='$posts' WHERE id='$selfid'");
mysql_query_err("UPDATE " . $tprefix . "users SET lastpost='$posttime' WHERE id='$selfid'");

// Do log
if ($username !== "root")
{
$logip = $_SERVER['REMOTE_ADDR'];
$logpath = $_SERVER['PHP_SELF'];
$logtime = $now = strtotime(gmdate("F d Y H:i:s"));
$logtime = GetTimeZone($timezone,$logtime);
mysql_query_err("INSERT INTO ". $tprefix ."log VALUES('','$logip','$logtime','$logpath','Added News Item','$username')");
}
//end log
if ($additem)
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Action=AddNews");
}
elseif ($preview == "yes")
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Action=ModForm&id=" . $NewsID);
}
else
{
header("Location: " . $_SERVER['PHP_SELF'] . "?Mesg=" . $action . "&Type=" . $status);
}
exit;
// end process
}
elseif ($Action == "DoDelete")
{
if ($candel !== "yes")
{
header("Location: ad_main.php?Mesg=NoPerm");
exit;
}
// process deletes
$done = "false";
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "news");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
$catid = $row['id'];
$What = (isset($_POST['what']) ? 'authdel' : 'None'); // Check Action
$didauth = false;
if ($What == "authdel")
{
if ($_POST['do_' . $catid] == "del")
{
mysql_query_err("DELETE FROM " . $tprefix . "news WHERE id='$catid'");
}
elseif($_POST['do_' . $catid] == "auth")
{
$didauth = true;
mysql_query_err("UPDATE " . $tprefix . "news SET status='public' WHERE id='$catid'");
}
}
else
{
$chid_text = 'news_' . $catid;
if (isset($_POST[$chid_text])) {
$chid = $_POST[$chid_text];
if ($chid == "yes")
{
$done = "true";
mysql_query_err("DELETE FROM " . $tprefix . "news WHERE id='$catid'");
}
else { continue; }
}
else { continue; }
}
}
}

if ($done == "true")
{
// Do log
if ($username !== "root")
{
$logip = $_SERVER['REMOTE_ADDR'];
$logpath = $_SERVER['PHP_SELF'];
$logtime = $now = strtotime(gmdate("F d Y H:i:s"));
$logtime = GetTimeZone($timezone,$logtime);
mysql_query_err("INSERT INTO ". $tprefix ."log VALUES('','$logip','$logtime','$logpath','Deleted News Item(s)','$username')");
}
//end log
header("location: " . $_SERVER['PHP_SELF'] . "?Mesg=NewsDeleted");
exit;
}
elseif ($didauth)
{
// Do log
if ($username !== "root")
{
$logip = $_SERVER['REMOTE_ADDR'];
$logpath = $_SERVER['PHP_SELF'];
$logtime = $now = strtotime(gmdate("F d Y H:i:s"));
$logtime = GetTimeZone($timezone,$logtime);
mysql_query_err("INSERT INTO ". $tprefix ."log VALUES('','$logip','$logtime','$logpath','Authorized News Item(s)','$username')");
}
//end log
header("location: " . $_SERVER['PHP_SELF'] . "?Mesg=NewsAuthorized");
exit;
}
else
{
header("location: " . $_SERVER['PHP_SELF']);
exit;
}
// end that process
}
elseif ($Action == "AddNews")
{
// Do add cat form
if ($canadd !== "yes")
{
header("Location: ad_main.php?Mesg=NoPerm");
exit;
}
echo GetTemplate("Admin-Header.tpl");
echo GetTemplate("Admin-TopBar.tpl");
echo GetTemplate("Admin-NavBar.tpl");

$currenttime = $now = strtotime(gmdate("F d Y H:i:s"));
$currenttime = GetTimeZone($timezone,$currenttime);

if ($enableflood == "yes")
{
if ($currenttime <= ($lastposttime + 30))
{

echo GetTemplate("Admin-MidTableTop.tpl",$lang['FloodTitle']);
echo GetTemplate("Admin-MidTableCellTop2.tpl");
// -----------------------------------------------
echo $lang['FloodText'];
// -----------------------------------------------
echo GetTemplate("Admin-MidTableCellBottom2.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo GetTemplate("Admin-Footer.tpl");
exit;

}
}
//else
//{
echo "<form action='" . $_SERVER['PHP_SELF'] . "?Action=ProcessAddForm' name='name' method='POST' onSubmit=\"return validateForm(this,bConfirm=true);\" onFocusOut=\"clearStyle(event.srcElement)\">";

$countun = 0;
echo GetTemplate("Admin-MidTableTop.tpl", $lang['AddItemTitle']);
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "newsfields ORDER BY disporder ASC");
if ($sqlgn)
{
while($row = mysql_fetch_array($sqlgn))
{
$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}
if ($row['fieldtype'] == "knews2_icon")
{
////////////////////////////////////////////////

$temp = "<input type='radio' SELECTED value='None.gif' checked name=" . $row['intname'] . ">  None<br>";

$count = 0;
//starting directory
$startDir = "../Images/Icons";
//open directory
// Silently to error Trap - TSL
if ($openDir = @opendir($startDir))
{
while($path = readdir($openDir))
{
//gets the base name of file i.e instead of /home/canivour/html/index.html its index.html
$file = basename($path);
//makes sure we dont we read the . and .. direcotry (current directory and parent directory)
if($file!="." && $file!="..")
{
//if its not a directory print out the stats (can be changed for your needs)
if(!is_dir($startDir."/".$file))
{
$fullDir = $startDir."/".$file; //full directory path of file
$statCheck = stat($fullDir); //keeps info on files
$count++;
if ($count == "6")
{
$temp .= "<br>";
$count = 1;
}
if ($file == "None.gif")
{
$count--;
// This is bad from to leave this open like this
// Using continue the code will go back to start of the loop faster - TSL
continue;
}
elseif ($file == "Thumbs.db")
{
$count--;
}
else
{
$imgsize = getimagesize("../Images/Icons/" . $file);
$imgwidth = NULL;
$imgheight = NULL;

if ($imgsize[0] > $lang['IconWidth'])
{
$imgwidth = "width='" . $lang['IconWidth'] . "' ";
}

if ($imgsize[1] > $lang['IconHeight'])
{
$imgheight = "height='" . $lang['IconHeight'] . "' ";
}

$temp .= "<input type='radio' value=\"" . $file . "\" name=" . $row['intname'] . "> <img " . $imgwidth . $imgheight . " src=\"../Images/Icons/" . $file . "\" >  ";

}
}
}
}
}
else
{
printf("Unable to read the directory %s",$startDir);
}
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");

//////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_category")
{
///////////////////////////////////////////////////
$temp = "<select name=\"" . $row['intname'] . "\">";

if ($restrict == NULL)
{
$thesql = "SELECT * FROM " . $tprefix . "category WHERE Owner='None' OR Owner='' ORDER BY catname ASC";
}
else
{
$thesql = "SELECT * FROM " . $tprefix . "category WHERE keyword='" . $restrict . "' AND Owner='None' OR Owner='' ORDER BY catname ASC";
}
$sqlgc = mysql_query($thesql);
if ($sqlgc)
{
while($row3 = mysql_fetch_array($sqlgc))
{
// Printf() so much cleaner
$temp .= "<option value=\"" . $row3['id'] . "\">- " . stripslashes($row3['catname']) . "</option>";
// -- print sub cats
// Put this all on one line - TSL
// Removed loose variable - TSL
if ($sqlgco = mysql_query("SELECT * FROM " . $tprefix . "category WHERE Owner='$row3[id]' ORDER BY catname"))
{
while($row2 = mysql_fetch_array($sqlgco))
{
$temp .= "<option value=\"" . $row2['id'] . "\">    - " . stripslashes($row2['catname']) . "</option>";
}
}
}
}
$temp .= "</select>";
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");
//////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_subject")
{
///////////////////////////////////////////
if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['ItemSubjectError'] . "\"";
}
else
{
$valstring = NULL;
}
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>","<input type=\"text\" name=\"". $row['intname'] . "\" size=\"" . $row['size'] . "\" " . $valstring . ">","25%","75%");
//////////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_news")
{
//////////////////////////////////////////////////////////
if ($wysiwyg == "yes")
{
$temp = GetTemplate("Admin-bbedit.tpl");
}
else
{
$temp = NULL;
}

if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['ItemNewsError'] . "\"";
}
else
{
$valstring = NULL;
}

$temp .= "<textarea name=\"" . $row['intname'] . "\" cols=\"" . $row['cols'] . "\" rows=\"" . $row['rows'] . "\" " . $valstring . "></textarea>";
$user_browser = browser_detection('browser');

if ($asmilies == "yes")
{

if ($user_browser == 'msie') {

$temp .= "<br>";
// Single Line - TSL
if ($sqlgco = mysql_query_err("SELECT * FROM " . $tprefix . "smilies LIMIT 10"))
{
while($rowsmi = mysql_fetch_array($sqlgco))
{
// Touched it up - TSL
$smi = (isset($rowsmi['theimage']) ? $rowsmi['theimage'] : 'None');
if ($smi !== "None")
{
$temp .= "<a href=\"javascript: document.getElementById('$row[intname]').value=document.getElementById('$row[intname]').value + ' $rowsmi[thesmile] '; document.name.$row[intname].focus();\" border=0><img src='../Images/Smilies/" . $rowsmi['theimage'] . "' border=0></a>  ";
}
}
}

} else {
//$temp .= "<br />[ Quick smilies disabled on non IE Browsers ]";
}
}

if ($user_browser == 'msie') {
$cont = "<script src=\"js_func.js\"></script><br><img src=\"Images/increase.gif\" height=\"16\" width=\"16\" onclick=\"increaseNotesHeight(document.getElementById('" . $row['intname'] . "'), 2);\" class=\"hand\" alt=\"" . $lang['NewsExpand'] . "\" title=\"" . $lang['NewsExpand'] . "\"><img src=\"Images/decrease.gif\" height=\"16\" width=\"16\" onclick=\"decreaseNotesHeight(document.getElementById('" . $row['intname'] . "'), 2);\" class=\"hand\" alt=\"" . $lang['NewsUnExpand'] . "\" title=\"" . $lang['NewsUnExpand'] . "\">";
} else { $cont = NULL; }
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>" . $cont,$temp,"25%","75%");
//////////////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "textarea")
{
if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['FieldError'] . "\"";
}
else
{
$valstring = NULL;
}

$temp = "<textarea name=\"" . $row['intname'] . "\" cols=\"" . $row['cols'] . "\" rows=\"" . $row['rows'] . "\" " . $valstring . "></textarea>";
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");
}
else
{
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>","<input type=\"" . $row['fieldtype'] . "\" name=\"". $row['intname'] . "\" size=\"" . $row['size'] . "\" " . $valstring . ">","25%","75%");
}
}
}

$time = strtotime(gmdate("F d Y H:i:s",time()));

$time = TimeZone($timezone, $time);

// Do Hours
$temp2 = "<select name=\"hour\">";
for ($i = 1; $i <= 12; $i++) {

if ($i == date("g", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end hours

$temp2 .= " <b>:</b> ";

// Start minutes
$temp2 .= "<select name=\"minute\">";
for ($i = 0; $i <= 59; $i++) {

switch($i)
{
case 0:
$i2 = '00';
break;
case 1:
$i2 = '01';
break;
case 2:
$i2 = '02';
break;
case 3:
$i2 = '03';
break;
case 4:
$i2 = '04';
break;
case 5:
$i2 = '05';
break;
case 6:
$i2 = '06';
break;
case 7:
$i2 = '07';
break;
case 8:
$i2 = '08';
break;
case 9:
$i2 = '09';
break;
default:
$i2 = $i;
break;
}

if ($i == date("i", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i2 . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i2 . "</option>";
}
}
$temp2 .= "</select>";
// end minutes

$temp2 .= "  ";

$SELECTED1 = NULL;
$SELECTED2 = NULL;

if (date("a", $time) == "pm")
{
$SELECTED2 = "SELECTED";
}
else
{
$SELECTED1 = "SELECTED";
}

$temp2 .= "<select name=\"timetype\">";
$temp2 .= "<option value=am " . $SELECTED1 . ">AM</option>";
$temp2 .= "<option value=pm " . $SELECTED2 . ">PM</option>";
$temp2 .= "</select>";

$temp2 .= " On ";

// Start month
$temp2 .= "<select name=\"month\">";
for ($i = 1; $i <= 12; $i++) {

switch($i)
{
case 1:
$i2 = "January";
break;
case 2:
$i2 = "February";
break;
case 3:
$i2 = "March";
break;
case 4:
$i2 = "April";
break;
case 5:
$i2 = "May";
break;
case 6:
$i2 = "June";
break;
case 7:
$i2 = "July";
break;
case 8:
$i2 = "August";
break;
case 9:
$i2 = "September";
break;
case 10:
$i2 = "October";
break;
case 11:
$i2 = "November";
break;
case 12:
$i2 = "December";
break;
}

if ($i == date("n", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i2 . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i2 . "</option>";
}
}
$temp2 .= "</select>";
// end month

$temp2 .= "  ";

// Start day
$temp2 .= "<select name=\"day\">";
for ($i = 1; $i <= 31; $i++) {

if ($i == date("d", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end day

$temp2 .= "  ";

// Start year
$temp2 .= "<select name=\"year\">";
for ($i = 2002; $i <= 2015; $i++) {
$cyear = date("Y", $time);
if ($i == $cyear)
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end year

$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}

echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $lang['Schedule'] . ":</b>",$temp2,"25%","75%");

// ---

if ($ahtml == "yes")
{
$html = $lang['ItemOn'];
}
else
{
$html = $lang['ItemOff'];
}

if ($abbcode == "yes")
{
$bbcode = $lang['ItemOn'];
}
else
{
$bbcode = $lang['ItemOff'];
}
$temp = "
<a href=\"javascript

opuphelp('Lang/" . $flang . "-help.php?section=smilie','height=325,width=300,scrollbars=yes')\">" . $lang['ItemSmilies'] . "</a><Br>
" . $lang['HTML'] . " <b>" . $html . "</b><br>
<a href=\"javascript

opuphelp('Lang/" . $flang . "-help.php?section=bbcode','height=325,width=450,scrollbars=yes')\">" . $lang['BBCode'] . " <b>" . $bbcode . "</b></a><br>";

$temp .= "<a href=\"javascript

opuphelp('uploader.php','height=125,width=400,scrollbars=yes')\">" . $lang['UploadUtil'] . "</a><br>";

echo GetTemplate("Admin-Cell2TDNContent3.tpl","<b>" . $lang['ItemNotes'] . "</b>",$temp,"25%","75%");
$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}

$temp = "
<select name=\"dowhat\">
<option value=\"NA\" selected>" . $lang['Select1'] . "</option>
<option value=\"sticky\" >" . $lang['Select2'] . "</option>
<option value=\"mpost\" >" . $lang['Select3'] . "</option>
<option value=\"preview\" >" . $lang['Select4'] . "</option>
</select><br>
<input type=\"checkbox\" name=\"additem\" value=\"yes\"> " . $lang['Option1'] . "<Br>";
echo GetTemplate("Admin-Cell2TDNContent2.tpl","<b>" . $lang['Option2'] . "</b>",$temp,"25%","75%");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo "<br><BR>";

// actions
echo GetTemplate("Admin-MidTableTop.tpl",$lang['PerformActions']);
echo GetTemplate("Admin-MidTableCellTop2.tpl");
echo "<input type='Submit' Value='" . $lang['ItemAddButton'] . "' Name='Submit'>  <input type='button' value='" . $lang['CancelButton'] . "' onclick=\"location='ad_main.php'\">";
echo GetTemplate("Admin-MidTableCellBottom2.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");
//}

echo GetTemplate("Admin-Footer.tpl");
// end add form
//////////////////////////////////////////////////////////////////////////////
}
elseif ($Action == "ModForm")
{
////////////////////////////////////////////////////////////////////////////////
// start show
if ($canmod !== "yes")
{
header("Location: ad_main.php?Mesg=NoPerm");
exit;
}
$nid = $_GET['id'];

$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "news WHERE id='" . $nid . "' LIMIT 1");
if ($sqlgn)
{
while($rown = mysql_fetch_array($sqlgn))
{
$nstatus = $rown['status'];
$sticky = $rown['sticky'];
if ($modtype == "own")
{
if ($rown['authorid'] !== $selfid)
{
header("Location: " . $_SERVER['PHP_SELF']);
exit;
}
}
echo GetTemplate("Admin-Header.tpl");
echo GetTemplate("Admin-TopBar.tpl");
echo GetTemplate("Admin-NavBar.tpl");
echo "<form action='" . $_SERVER['PHP_SELF'] . "?Action=ProcessForm' name='name' method='POST' onSubmit=\"return validateForm(this,bConfirm=true);\" onFocusOut=\"clearStyle(event.srcElement)\">";
$countun = 0;
echo "<input type='hidden' name='status' value='" . $rown['status'] . "'>";
echo "<input type='hidden' name='newsid' value='" . $rown['id'] . "'>";

if ($nstatus == "preview")
{

echo GetTemplate("Admin-MidTableTop.tpl", $lang['PreviewTitle']);
echo GetTemplate("Admin-MidTableCellTop2.tpl");
echo "<b> :: " . $rown['subject'] . "</b><br>";
echo nl2br($rown['news']);
echo GetTemplate("Admin-MidTableCellBottom2.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo "<br><BR>";
}

echo GetTemplate("Admin-MidTableTop.tpl", $lang['ItemModButton']);

$sqlgf = mysql_query_err("SELECT * FROM " . $tprefix . "newsfields ORDER BY disporder ASC");
if ($sqlgf)
{
while($row = mysql_fetch_array($sqlgf))
{
$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}
if ($row['fieldtype'] == "knews2_icon")
{
////////////////////////////////////////////////
if ($rown['' . $row['intname'] . ''] == "None.gif")
{
$temp = "<input type='radio' value='None.gif' checked name=" . $row['intname'] . ">  None<br>";
}
else
{
$temp = "<input type='radio' value='None.gif' name=" . $row['intname'] . ">  None<br>";
}
$count = 0;
//starting directory
$startDir = "../Images/Icons";
//open directory
// Silently to error Trap - TSL
if ($openDir = @opendir($startDir))
{
while($path = readdir($openDir))
{
//gets the base name of file i.e instead of /home/canivour/html/index.html its index.html
$file = basename($path);
//makes sure we dont we read the . and .. direcotry (current directory and parent directory)
if($file!="." && $file!="..")
{
//if its not a directory print out the stats (can be changed for your needs)
if(!is_dir($startDir."/".$file))
{
$fullDir = $startDir."/".$file; //full directory path of file
$statCheck = stat($fullDir); //keeps info on files
$count++;
if ($count == "6")
{
$temp .= "<br>";
$count = 1;
}
if ($file == "None.gif")
{
$count--;
// This is bad from to leave this open like this
// Using continue the code will go back to start of the loop faster - TSL
continue;
}
elseif ($file == "Thumbs.db")
{
$count--;
}
else
{
$imgsize = getimagesize("../Images/Icons/" . $file);
$imgwidth = NULL;
$imgheight = NULL;

if ($imgsize[0] > $lang['IconWidth'])
{
$imgwidth = "width='" . $lang['IconWidth'] . "' ";
}

if ($imgsize[1] > $lang['IconHeight'])
{
$imgheight = "height='" . $lang['IconHeight'] . "' ";
}

if ($rown['' . $row['intname'] . ''] == $file)
{
$temp .= "<input type='radio' checked value=\"" . $file . "\" name=" . $row['intname'] . "> <img " . $imgwidth . $imgheight . " src=\"../Images/Icons/" . $file . "\" >  ";
}
else
{
$temp .= "<input type='radio' value=\"" . $file . "\" name=" . $row['intname'] . "> <img " . $imgwidth . $imgheight . " src=\"../Images/Icons/" . $file . "\" >  ";
}
}
}
}
}
}
else
{
printf("Unable to read the directory %s",$startDir);
}

echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");
//////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_category")
{
///////////////////////////////////////////////////
$temp = "<select name=\"" . $row['intname'] . "\">";

$sqlgc = mysql_query_err("SELECT * FROM " . $tprefix . "category WHERE keyword='" . $restrict . "'");
if ($sqlgc)
{
while($cat = mysql_fetch_array($sqlgc))
{
$rid = $cat['id'];
}
}

if ($restrict == NULL)
{
$thesql = "SELECT * FROM " . $tprefix . "category WHERE Owner='None' OR Owner='' ORDER BY catname ASC";
}
else
{
$thesql = "SELECT * FROM " . $tprefix . "category WHERE id='" . $rid . "' AND Owner='None' OR Owner='' ORDER BY catname ASC";
}

$sqlgc = mysql_query($thesql);
if ($sqlgc)
{
while($row3 = mysql_fetch_array($sqlgc))
{
// Printf() so much cleaner
if ($row3['id'] == $rown['category'])
{
$isselected = "SELECTED";
}
else
{
$isselected = NULL;
}
// Echo Select Option
$temp .= "<option " . $isselected . " value=\"" . $row3['id'] . "\">- " . stripslashes($row3['catname']) . "</option>";

// -- print sub cats
// Put this all on one line - TSL
// Removed loose variable - TSL
if ($sqlgco = mysql_query("SELECT * FROM " . $tprefix . "category WHERE Owner='$row3[id]'"))
{
while($row2 = mysql_fetch_array($sqlgco))
{
if ($row2['id'] == $rown['id'])
{
$selected = "SELECTED";
}
else
{
$selected = NULL;
}
$temp .= "<option " . $selected . " value=\"" . $row2['id'] . "\">    - " . stripslashes($row2['catname']) . "</option>";
}
}
}
}
$temp .= "</select>";
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");
//////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_subject")
{
///////////////////////////////////////////

if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['ItemSubjectError'] . "\"";
}
else
{
$valstring = NULL;
}
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>","<input type=\"text\" value=\"" . stripslashes($rown['' . $row['intname'] . '']) . "\" name=\"". $row['intname'] . "\" size=\"" . $row['size'] . "\" " . $valstring . ">","25%","75%");
//////////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "knews2_news")
{
//////////////////////////////////////////////////////////
if ($wysiwyg == "yes")
{
$temp = GetTemplate("Admin-bbedit.tpl");
}
else
{
$temp = NULL;
}

if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['ItemNewsError'] . "\"";
}
else
{
$valstring = NULL;
}

$temp .= "<textarea name=\"" . $row['intname'] . "\" cols=\"" . $row['cols'] . "\" rows=\"" . $row['rows'] . "\" " . $valstring . ">" . stripslashes($rown['' . $row['intname'] . '']) . "</textarea>";

if ($asmilies == "yes")
{
$temp .= "<Br>";
// Single Line - TSL
if ($sqlgco = mysql_query("SELECT * FROM " . $tprefix . "smilies LIMIT 10"))
{
while($rowsmi = mysql_fetch_array($sqlgco))
{
// Touched it up - TSL
$smi = (isset($rowsmi['theimage']) ? $rowsmi['theimage'] : 'None');
if ($smi !== "None")
{
$temp .= "<a href=\"javascript: document.getElementById('$row[intname]').value=document.getElementById('$row[intname]').value + ' $rowsmi[thesmile] '; document.name.$row[intname].focus();\" border=0><img src='../Images/Smilies/" . $rowsmi['theimage'] . "' border=0></a>  ";
}
}
}
}

$cont = "<script src=\"js_func.js\"></script><br><img src=\"Images/increase.gif\" height=\"16\" width=\"16\" onclick=\"increaseNotesHeight(document.getElementById('" . $row['intname'] . "'), 2);\" class=\"hand\" alt=\"" . $lang['NewsExpand'] . "\" title=\"" . $lang['NewsExpand'] . "\"><img src=\"Images/decrease.gif\" height=\"16\" width=\"16\" onclick=\"decreaseNotesHeight(document.getElementById('" . $row['intname'] . "'), 2);\" class=\"hand\" alt=\"" . $lang['NewsUnExpand'] . "\" title=\"" . $lang['NewsUnExpand'] . "\">";
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>" . $cont,$temp,"25%","75%");
//////////////////////////////////////////////////////////
}
elseif ($row['fieldtype'] == "textarea")
{
if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['FieldError'] . "\"";
}
else
{
$valstring = NULL;
}

$temp = "<textarea name=\"" . $row['intname'] . "\" cols=\"" . $row['cols'] . "\" rows=\"" . $row['rows'] . "\" " . $valstring . ">" . stripslashes($rown['' . $row['intname'] . '']) . "</textarea>";
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>",$temp,"25%","75%");
}
else
{
if ($row['isrequired'] == "yes")
{
$valstring = "alt=\"blank\" emsg=\"" . $lang['FieldError'] . "\"";
}
else
{
$valstring = NULL;
}
echo GetTemplate("Admin-Cell2TDNContent" . $colid . ".tpl","<b>" . $row['fielddescr'] . ":</b>","<input type=\"" . $row['fieldtype'] . "\" name=\"". $row['intname'] . "\" value=\"" . stripslashes($rown['' . $row['intname'] . '']) . "\" size=\"" . $row['size'] . "\" " . $valstring . ">","25%","75%");
}
}
}

$time = $rown['newsstamp'];
// Do Hours
$temp2 = "<select name=\"hour\">";
for ($i = 1; $i <= 12; $i++) {

if ($i == date("g", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end hours

$temp2 .= " <b>:</b> ";

// Start minutes
$temp2 .= "<select name=\"minute\">";
for ($i = 0; $i <= 59; $i++) {

if ($i == date("i", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end minutes

$temp2 .= "  ";

$SELECTED1 = NULL;
$SELECTED2 = NULL;

if (date("a", $time) == "pm")
{
$SELECTED2 = "SELECTED";
}
else
{
$SELECTED1 = "SELECTED";
}

$temp2 .= "<select name=\"timetype\">";
$temp2 .= "<option value=am " . $SELECTED1 . ">AM</option>";
$temp2 .= "<option value=pm " . $SELECTED2 . ">PM</option>";
$temp2 .= "</select>";

$temp2 .= " On ";

// Start month
$temp2 .= "<select name=\"month\">";
for ($i = 1; $i <= 12; $i++) {

switch($i)
{
case 1:
$i2 = "January";
break;
case 2:
$i2 = "February";
break;
case 3:
$i2 = "March";
break;
case 4:
$i2 = "April";
break;
case 5:
$i2 = "May";
break;
case 6:
$i2 = "June";
break;
case 7:
$i2 = "July";
break;
case 8:
$i2 = "August";
break;
case 9:
$i2 = "September";
break;
case 10:
$i2 = "October";
break;
case 11:
$i2 = "November";
break;
case 12:
$i2 = "December";
break;
}

if ($i == date("n", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i2 . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i2 . "</option>";
}
}
$temp2 .= "</select>";
// end month

$temp2 .= "  ";

// Start day
$temp2 .= "<select name=\"day\">";
for ($i = 1; $i <= 31; $i++) {

if ($i == date("d", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end day

$temp2 .= "  ";

// Start year
$temp2 .= "<select name=\"year\">";
for ($i = 2002; $i <= 2015; $i++) {
if ($i == date("Y", $time))
{
$temp2 .= "<option SELECTED value=\"" . $i . "\">" . $i . "</option>";
}
else
{
$temp2 .= "<option value=\"" . $i . "\">" . $i . "</option>";
}
}
$temp2 .= "</select>";
// end year

echo GetTemplate("Admin-Cell2TDNContent2.tpl","<b>" . $lang['Schedule'] . ":</b>",$temp2,"25%","75%");

if ($modtype == "all")
{
$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}

if ($modtype !== "own")
{
$temp = "<select name='postedby'>";
$sqlus = mysql_query_err("SELECT * FROM " . $tprefix . "users");
if ($sqlus)
{
while($rowus = mysql_fetch_array($sqlus))
{
// Touched it up - TSL
if ($rowus['id'] !== '2')
{
if ($rowus['id'] !== '1')
{
if ($rowus['id'] == $rown['authorid'])
{
$temp .= "<option SELECTED value='" . $rowus['id'] . "'>" . $rowus['username'] . "</option>";
}
else
{
$temp .= "<option value='" . $rowus['id'] . "'>" . $rowus['username'] . "</option>";
}
}
}
}
}
$temp .= "</select>";
echo GetTemplate("Admin-Cell2TDNContent3.tpl","<b>" . $lang['ModItemPoster'] . "</b>",$temp,"25%","75%");
}
}

$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}
if ($ahtml == "yes")
{
$html = $lang['ItemOn'];
}
else
{
$html = $lang['ItemOff'];
}

if ($abbcode == "yes")
{
$bbcode = $lang['ItemOn'];
}
else
{
$bbcode = $lang['ItemOff'];
}
$temp = "
<a href=\"javascript

opuphelp('Lang/" . $flang . "-help.php?section=smilie','height=325,width=300,scrollbars=yes')\">" . $lang['ItemSmilies'] . "</a><Br>
" . $lang['HTML'] . " <b>" . $html . "</b><br>
<a href=\"javascript

opuphelp('Lang/" . $flang . "-help.php?section=bbcode','height=325,width=450,scrollbars=yes')\">" . $lang['BBCode'] . " <b>" . $bbcode . "</b></a><br>";

$temp .= "<a href=\"javascript

opuphelp('uploader.php','height=125,width=400,scrollbars=yes')\">" . $lang['UploadUtil'] ."</a><br>";

echo GetTemplate("Admin-Cell2TDNContent2.tpl","<b>" . $lang['ItemNotes'] . "</b>",$temp,"25%","75%");
$countun++;
if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}

$temp = "
<select name=\"dowhat\">";
if ($nstatus !== "preview")
{
$temp .= "<option value=\"NA\" selected>" . $lang['Select1'] . "</option>";
}
if ($sticky == "yes")
{
$temp .= "<option value=\"unstick\">" . $lang['UnstickItem'] . "</option>";
}
if (($canauth == "yes") AND ($nstatus == "unval"))
{
$temp .= "<option value=\"auth\">" . $lang['AuthItem'] . "</option>";
}
$temp .= "<option value=\"preview\">" . $lang['Select4'] . "</option>";
if ($nstatus == "preview")
{
$temp .= "<option value=\"unpreview\" SELECTED>" . $lang['Select5'] . "</option>";
}
if ($nstatus == "saved")
{
$temp .= "<option value=\"save\">" . $lang['MoveItem'] . "</option>";
}
//<option value=\"mpost\" >Save This Post</option>
$temp .= "</select><br>
<input type=\"checkbox\" name=\"additem\" value=\"yes\"> " . $lang['Option1'] . "<Br>";

echo GetTemplate("Admin-Cell2TDNContent3.tpl","<b>" . $lang['Option2'] . "</b>",$temp,"25%","75%");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo "<br><BR>";
}
}

// actions
echo GetTemplate("Admin-MidTableTop.tpl",$lang['PerformActions']);
echo GetTemplate("Admin-MidTableCellTop2.tpl");
echo "<input type='Submit' Value='Modify This Item' Name='Submit'> <input type='button' value='" . $lang['CancelButton'] . "' onclick=\"location='ad_main.php'\">";
echo GetTemplate("Admin-MidTableCellBottom2.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");

echo GetTemplate("Admin-Footer.tpl");
// end show mod form
/////////////////////////////////////////////////////////////////////////
}
elseif ($Action == "Show")
{
//////////////////////////////////////////////////////////////////////////////
// show list
echo GetTemplate("Admin-Header.tpl");
echo GetTemplate("Admin-TopBar.tpl");
echo GetTemplate("Admin-NavBar.tpl");
echo "<form action='" . $_SERVER['PHP_SELF'] . "?Action=DoDelete' method='POST' onSubmit=\"return validateForm(this,bConfirm=true);\" onFocusOut=\"clearStyle(event.srcElement)\">";

if ($Mesg !== 'None')
{
if ($Mesg == "NewsAdded")
{
$warning = "<img src='Images/info.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgAdd'] . "</font></b>";
}
elseif ($Mesg == "NewsModded")
{
$warning = "<img src='Images/info.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgMod'] . "</font></b>";
}
elseif ($Mesg == "NewsDeleted")
{
$warning = "<img src='Images/delete.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgDel'] . "</font></b>";
}
elseif ($Mesg == "NewsAuthorized")
{
$warning = "<img src='Images/info.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgAuth'] . "</font></b>";
}
elseif ($Mesg == "NewsSaved")
{
$warning = "<img src='Images/info.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgSaved'] . "</font></b>";
}
elseif ($Mesg == "NewsMoved")
{
$warning = "<img src='Images/info.gif' border=0>";
$notice = "<font color=red><b>" . $lang['ItemMesgMoved'] . "</font></b>";
}
echo GetTemplate("Admin-MidTableTop.tpl", $lang['NoticeTitle']);
echo GetTemplate("Admin-MidTableCellTop.tpl");
echo "<b>" . $warning . "</b> " . $notice . "<br>";
echo GetTemplate("Admin-MidTableCellBottom.tpl");
echo GetTemplate("Admin-MidTableBottom.tpl");
echo "<br><BR>";
}

if ($Type == "saved")
{
$top = $lang['ItemSaveHead'];
$top2 = NULL;
}
elseif ($Type == "unval")
{
echo "<input type='hidden' value='authdel' name='what'>";
$top = $lang['ItemAuthHead'];
$top2 = "/" . $lang['ItemAuthHeadOption'];
}
else
{
$top = $lang['ItemModHead'];
$top2 = NULL;
}
echo GetTemplate("Admin-MidTableTop.tpl", $top);
echo GetTemplate("Admin-Cell2TDHeader.tpl",$lang['Delete'] . $top2,$lang['ItemHeader'] . "</b></td><td width=\"50%\" class=\"row1\">
<b>" . $lang['ItemDateHeader'],"16%","44%");

// Do listing
$Prev = $lang['Previous'];
$Next = $lang['Next'];
$limit=8;
$numresults=mysql_query_err("SELECT * FROM " . $tprefix . "news WHERE status='" . $Type . "'");
$numrows=mysql_num_rows($numresults);

// CHECK ORDER BY STUFF

if ($sort == "Default")
{
$Order = "newsstamp";
}
elseif ($sort == "Category")
{
$Order = "category";
}
elseif ($sort == "Views")
{
$Order = "views";
}
elseif ($sort == "Rating")
{
$Order = "rating";
}
elseif ($sort == "Author")
{
$Order = "authorid";
}

// END CHECK

$isempty = true;
if ($restrict == NULL)
{
$isempty = false;
}
if ($restrict == "")
{
$isempty = false;
}

if ($isempty)
{
$sqlln = mysql_query_err("SELECT * FROM " . $tprefix . "category WHERE keyword='" . $restrict . "'");
if ($sqlln)
{
while($row = mysql_fetch_array($sqlln))
{
$catid = $row['id'];
}
}
if ($Type == "public")
{
$thesql = "SELECT * FROM " . $tprefix . "news WHERE status='" . $Type . "' AND category='" . $catid . "' ORDER by " . $Order . " DESC LIMIT $Offset,$limit";
}
else
{
$thesql = "SELECT * FROM " . $tprefix . "news WHERE status='" . $Type . "' ORDER by " . $Order . " DESC LIMIT $Offset,$limit";
}
}
else
{
$thesql = "SELECT * FROM " . $tprefix . "news WHERE status='" . $Type . "' ORDER by " . $Order . " DESC LIMIT $Offset,$limit";
}

$sqlln = mysql_query_err($thesql);
$countun = 0;
if ($sqlln)
{
while($row = mysql_fetch_array($sqlln))
{
++$countun;
$maxTextLenght=35;
$aspace=" ";
if(strlen($row['subject']) > $maxTextLenght )
{
$t_array = word_wrap($row['subject'],$maxTextLenght);
$subject = $t_array[0] . '...';
}
else
{
$subject = $row['subject'];
}

$maxTextLenght2=35;
if(strlen($row['news']) > $maxTextLenght2 )
{
$t_array = word_wrap($row['news'],$maxTextLenght2);
$news = $t_array[0] . '...';
}
else
{
$news = $row['news'];
}

$userid = $row['authorid'];
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "users WHERE id='$userid'");
if ($sqlgn)
{
while($rowus = mysql_fetch_array($sqlgn))
{
$user = $rowus['username'];
}
}

$catid = $row['category'];
$sqlgn = mysql_query_err("SELECT * FROM " . $tprefix . "category WHERE id='$catid'");
if ($sqlgn)
{
while($rowus = mysql_fetch_array($sqlgn))
{
$catname = $rowus['catname'];
}
}

if (!isset($catname))
{
$catname = 'Unknown';
}

if ($countun % 2)
{
$colid = 2;
}
else
{
$colid = 3;
}

if ($acategory == "yes")
{
$catstring = "<br><b>" . $lang['ItemCatIn'] . "</b> " . $catname;
}
else
{
$catstring = NULL;
}
if ($Type == "unval")
{
$top3 = "<input type=\"radio\" name=\"do_" .$row['id'] ."\" value=\"del\"> <b>/</b> <input type=\"radio\" name=\"do_" .$row['id'] ."\" value=\"auth\">";
}
else
{
$top3 = "<input type=\"checkbox\" name=\"news_" .$row['id'] ."\" value=\"yes\">";
}
if ($row['id'] == "1")
{
$user = "Kreative Studios Team";
}

//echo $row['newsstamp'] . " - ";
$thisstamp = $row['newsstamp'];
//echo $thisstamp . "<br>";

$thisdate = date('M j Y, h:i A', $thisstamp);
$numresults=mysql_query_err("SELECT * FROM " . $tprefix . "comments WHERE newsid='" . $row['id'] . "'");
$commcount=mysql_num_rows($numresults);

echo GetTemplate("Admin-Cell2TDContent" . $colid . ".tpl",$top3,"<A href=\"" . $_SERVER['PHP_SELF'] . "?Action=ModForm&id=" . $row['id'] . "\">" . $subject . "</a></b><br>" . $news . "<br><b>" . $lang['ItemBy'] . "</b> " . $user . $catstring . "<br><b>" . $lang['CommentsCount'] . "</b> " . $commcount . "</td><td width=\"50%\" class=\"row" . $colid . "\">
" . $thisdate,"16%","44%");
}
}

if ($countun == "0"){
if ($Type == "unval")
{
$msg = $lang['NoAuthItems'];
}
elseif($Type == "saved")
{
$msg = $lang['NoSavedItems'];
}
else
{
$msg = $lang['NoItem'];
}
print("<tr><td width='25%' bgcolor='#F0F5F9' class='row3'></td><td colspan=2 class='row3' width='90%' bgcolor='#F0F5F9'>" . $msg . "</td></tr>");
}

print("<tr><td width='25%' align='left' class='row1'><script>
function doNow()
{
void(d=document);
void(el=d.getElementsByTagName('INPUT'));
for(i=0;i<el.length;i++)
void(el.checked=1)
}
</script>

<script>
function doNow2()
{
void(d=document);
void(el=d.getElementsByTagName('INPUT'));
for(i=0;i<el.length;i++)
void(el.checked=0)
}
</script>
<a href=\"#\" onclick=\"doNow()\">" . $lang['CheckAll'] . "</a> / <a href=\"#\" onclick=\"doNow2()\">" . $lang['UncheckAll'] . "</a></td><td colspan=2 width='75%' class='row1' align='right'>");

$pages=intval($numrows/$limit);
if ($numrows%$limit) {
$pages++;
}

for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
print "<a href=\"" . $_SERVER['PHP_SELF'] . "?Offset=$newoffset\">$i</a> \n";
}

if ($Offset>1) {
$prevoffset=$Offset-$limit;
print "<a href=\"" . $_SERVER['PHP_SELF'] . "?Offset=$prevoffset\">$Prev</a> \n";
}

if ($numrows>($Offset+$limit)) {
$nextoffset=$Offset+$limit;
print "<a href=\"" . $_SERVER['PHP_SELF'] . "?Offset=$nextoffset\">$Next</a><p>\n";
}

echo GetTemplate("Admin-MidTableBottom.tpl");

if ($sort == "Default")
{
$default = "<b>" . $lang['SortDefault'] . "</b>";

$category = "" . $lang['SortCategory'] . "";
$views = "" . $lang['SortViews'] . "";
$rating = "" . $lang['SortRating'] . "";
$comments = "" . $lang['SortAuthor'] . "";
}
elseif ($sort == "Category")
{
$default = "" . $lang['SortDefault'] . "";
$category = "<b>" . $lang['SortCategory'] . "</b>";
$views = "" . $lang['SortViews'] . "";
$rating = "" . $lang['SortRating'] . "";
$comments = "" . $lang['SortAuthor'] . "";
}
elseif ($sort == "Views")
{
$default = "" . $lang['SortDefault'] . "";
$category = "" . $lang['SortCategory'] . "";
$views = "<b>" . $lang['SortViews'] . "</b>";
$rating = "" . $lang['SortRating'] . "";
$comments = "" . $lang['SortAuthor'] . "";
}
elseif ($sort == "Rating")
{
$default = "" . $lang['SortDefault'] . "";
$category = "" . $lang['SortCategory'] . "";
$views = "" . $lang['SortViews'] . "";
$rating = "<b>" . $lang['SortRating'] . "</b>";
$comments = "" . $lang['SortAuthor'] . "";
}
elseif ($sort == "Author")
{
$default = "" . $lang['SortDefault'] . "";
$category = "" . $lang['SortCategory'] . "";
$views = "" . $lang['SortViews'] . "";
$rating = "" . $lang['SortRating'] . "";
$comments = "<b>" . $lang['SortAuthor'] . "</b>";
}
else
{
$default = "" . $lang['SortDefault'] . "";
$category = "" . $lang['SortCategory'] . "";
$views = "" . $lang['SortViews'] . "";
$rating = "" . $lang['SortRating'] . "";
$comments = "" . $lang['SortAuthor'] . "";
}

echo "<b>Sort By:</b> <A href=\"" . $_SERVER['PHP_SELF'] . "?Sort=D

nvidia · 26 Септември 2006

В кода който си дал намери този ред:

Код:

mysql_select_db($db);

и след него добави това което е дадено по-горе в червено.

Soul_Stealler · 26 Септември 2006

Не се обиждай, но тоя скрипт е просто ОГРОМЕН (2118 реда)и не вярвам някой да си направи труда целия да го разгледа. Просто направи една отделна заявка (тази която admin е дал

)

nvidia · 26 Септември 2006

Няма нужда да разглежда кода.
Просто трябва да направи това което му написах.
А самия енкодинг на страницата оправил ли си го?

Noxy · 27 Септември 2006

стана... 10x

това е друто:
забелязах че при работа с скрипта ми дава следната грешка...

mySQL Query: INSERT INTO k2news_news VALUES('','1159313100','3','no','public','0','0','0','None.gif','','','','','','','','','18','d','da','','','dddddddddd','dddddddda')
mySQL error: Column count doesn't match value count at row 1
mySQL error code: 1136
Date: 26th 2006f September 2006 9:25:51 PM

Dido_net · 1 Ноември 2006

Хора.. имам проблем с кирилицата.. инсъртвам в дата бейса текст и после го извеждам с скрипт.. сложил съм чарсета на дата бейса да е cp1251_bulgarian_ci, сложил съм и "$chars="SET CHARACTER SET cp1251";mysql_query($chars); " под кънекшъна с дата бейс.. само че като ми изкарва резултата - става ей такова нещо

тест на българскитест на български

как да го оправя?

Edit: проблема е отстранен с помощта на baf

Кирилицата проблем

STaNiMiR

Registered

Admin

Registered

STaNiMiR

Registered

Noxy

Registered

nvidia

Registered

Soul_Stealler

Registered

nvidia

Registered

Noxy

Registered

Dido_net

Registered