Merhaba arkadaşlar elimde 1 adet script var bunu düzenliyorum fakat bir sorun var duyurular kısmına admin panelinden blog giriyorum ama üyelerin görebildiği indexte sadece 1 tane gösteriyor ve en son girileni gösteriyor nasıl düzeltebilirim bunu
aşağıda resimler mevcut
elimdeki script blog ile alakalı kodları:
BLOG.PHP
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
mysql_select_db($database_ok_kisisel, $ok_kisisel);
$query_blgg = "SELECT * FROM blog ORDER BY id DESC";
$blgg = mysql_query($query_blgg, $ok_kisisel) or die(mysql_error());
$row_blgg = mysql_fetch_assoc($blgg);
$totalRows_blgg = mysql_num_rows($blgg);
?>
Pixmania - Premium HTML Template
mysql_free_result($blgg);
?>
BLOG-OKU.PHP
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "diger")) {
$updateSQL = sprintf("UPDATE blog SET tarih=%s, baslik=%s, icerik=%s WHERE id=%s",
GetSQLValueString($_POST['tarih'], "text"),
GetSQLValueString($_POST['baslik'], "text"),
GetSQLValueString($_POST['icerik'], "text"),
GetSQLValueString($_POST['id'], "int"));
mysql_select_db($database_ok_kisisel, $ok_kisisel);
$Result1 = mysql_query($updateSQL, $ok_kisisel) or die(mysql_error());
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "resim")) {
$updateSQL = sprintf("UPDATE blog SET resim=%s WHERE id=%s",
GetSQLValueString($_name_, "text"),
GetSQLValueString($_POST['resid'], "int"));
mysql_select_db($database_ok_kisisel, $ok_kisisel);
$Result1 = mysql_query($updateSQL, $ok_kisisel) or die(mysql_error());
}
$colname_about = "-1";
if (isset($_GET['id'])) {
$colname_about = $_GET['id'];
}
mysql_select_db($database_ok_kisisel, $ok_kisisel);
$query_about = sprintf("SELECT * FROM blog WHERE id = %s", GetSQLValueString($colname_about, "int"));
$about = mysql_query($query_about, $ok_kisisel) or die(mysql_error());
$row_about = mysql_fetch_assoc($about);
$totalRows_about = mysql_num_rows($about);
?>
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
o-kolay scripti bu, ben bu scriptle epey uğraştım bir çok sorunu var aslında, epey de editlemiştim bir ara gönderirim sana editlemiş olduğum şekli şu site http://biriufukmudedi.url.ph
