Konu Linki : http://www.seditio-tr.com/son322.....ml#bottom
Konu :
-----------------
Selam arkada?lar ben aran?zda yeniyim, ?ok eskilerden bir arkada??m?n sitesinden alm?? oldu?um offline php ad?nda bir dosya vard?
Bu dosya yanl?? hat?rlam?yorsam SQL ba?lant?s? kurulamad??? zaman devreye giriyordu, yani site admini config.php ye bilgileri yanl?? yazarsa veya SQL ba?lant?s? zaman a??m?na u?rar ise bu dosya otomatik olarak ?al???yordu..
Lakin bu dosylar ?uan elimde mevcut, Sorunum ise ne yapt?msa ?al??t?ramad?m
zaten ?ok profesyonel de?ilim bu i?lerde, yard?mlar?n?z i?in ?imdiden hepinize ?ok te?ekk?r ederim
offline.php
Kod:
<?php
// LDU offline mode addon
// ver 0.4
// by _KaszpiR_ http://nvt.prv.pl
// config here
// obey system skin the one set in datas/config.php $cfg['defaultskin']
//if the skins/default_skin/offline.tpl is missing the ldu_root/offline.tpl will be used
$offline_skin = 1;
// admin mode, when querying a offline.php?a=1 it will show sql error reason
//you may want to set it to zero ti disable error displaying even in admin mode (security reason)
$offline_adm = 1;
// edit the offline.tpl
//skinning cvars that can be used - all from the datas/config.php from $cfg array
// use below ones
/*
ADMINEMAIL
AUTHMODE
CACHE
COMPATIBILITY600
DEFAULTLANG
DEFAULTSKIN
DEVMODE
ENABLESECURITYKEY
GZIP
MAINTITLE
MAINURL
MYSQLDB
MYSQLUSER
REDIRMODE
SQLDB
SUBTITLE
XMLCLIENT
*/
// end of config
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////
function offline_mode(){
global $cfg,$offline_skin,$offline_adm;
ob_clean();
if($offline_skin && is_readable("skins/".$cfg['defaultskin']."/offline.tpl"))
{
$t = new Xtemplate("skins/".$cfg['defaultskin']."/offline.tpl");
}
else
{
$t = new Xtemplate("offline.tpl");
}
$cfg['mysqlpassword'] = "**PROTECTED**";//security
foreach ($cfg as $key => $val) //exporting skin variables
$t->assign(array(
strtoupper($key) => htmlentities($val)
));
$t->parse("MAIN");
$t->out("MAIN");
// echo "<pre><code>";
// print_r($cfg);
// echo "</code></pre>";
if(!@$_GET["a"] || $offline_adm == 0 ) {
error_reporting("E_NONE");
exit;
}
};
// end of file
?>
// LDU offline mode addon
// ver 0.4
// by _KaszpiR_ http://nvt.prv.pl
// config here
// obey system skin the one set in datas/config.php $cfg['defaultskin']
//if the skins/default_skin/offline.tpl is missing the ldu_root/offline.tpl will be used
$offline_skin = 1;
// admin mode, when querying a offline.php?a=1 it will show sql error reason
//you may want to set it to zero ti disable error displaying even in admin mode (security reason)
$offline_adm = 1;
// edit the offline.tpl
//skinning cvars that can be used - all from the datas/config.php from $cfg array
// use below ones
/*
ADMINEMAIL
AUTHMODE
CACHE
COMPATIBILITY600
DEFAULTLANG
DEFAULTSKIN
DEVMODE
ENABLESECURITYKEY
GZIP
MAINTITLE
MAINURL
MYSQLDB
MYSQLUSER
REDIRMODE
SQLDB
SUBTITLE
XMLCLIENT
*/
// end of config
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////
function offline_mode(){
global $cfg,$offline_skin,$offline_adm;
ob_clean();
if($offline_skin && is_readable("skins/".$cfg['defaultskin']."/offline.tpl"))
{
$t = new Xtemplate("skins/".$cfg['defaultskin']."/offline.tpl");
}
else
{
$t = new Xtemplate("offline.tpl");
}
$cfg['mysqlpassword'] = "**PROTECTED**";//security
foreach ($cfg as $key => $val) //exporting skin variables
$t->assign(array(
strtoupper($key) => htmlentities($val)
));
$t->parse("MAIN");
$t->out("MAIN");
// echo "<pre><code>";
// print_r($cfg);
// echo "</code></pre>";
if(!@$_GET["a"] || $offline_adm == 0 ) {
error_reporting("E_NONE");
exit;
}
};
// end of file
?>
offline.tpl
-------------------
Kod:
<!-- BEGIN: MAIN -->
<html>
<head>
<title>{MAINTITLE}</title>
<link href="skins/{DEFAULTSKIN}/{DEFAULTSKIN}.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style17 {font-size: 18px}
.style21 {font-size: 18px; color: #006600; }
.style25 {color: #990000}
-->
</style>
</head>
<body bgcolor="#333333" text="#CCCCCC" link="#666666" vlink="#999999" alink="#FFFFFF">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back1"><div align="center"><span class="text2b">[ Site Bakýmda]
</span></div></td>
</tr>
<tr>
<td class="back2"><div align="center"><span class="style17"><font class="normal">Ge?ici S?reli?ine Eri?im Durdurulmu?tur ! </font></span> </div>
<div> </div>
<div>
<div align="left" class="maintenance_reason"><span class="style21"><span class="style25">Bakým
Modu: </span> SQL baglantýsý kurulamadý L?tfen
daha sonra tekrar deneyin</span></div>
</div>
<font class="normal"> </font>
<div class="maintenance_com"> </div>
<div class="maintenance_reason">
<div align="center">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back2"><div class="maintenance_reason">
<div class="maintenance_com">
<div align="center"></div>
</div>
<div class="maintenance_info">
<div align="center">
<p> </p>
</div>
</div>
</div></td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
<div class="maintenance_com"> </div>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back1"><div align="center"><span class="text2b">Bilgi i?in:
[ hayrig?ng?r@msn.com] </span></div></td>
</tr>
</table>
</body>
</html>
<!-- END: MAIN -->
<html>
<head>
<title>{MAINTITLE}</title>
<link href="skins/{DEFAULTSKIN}/{DEFAULTSKIN}.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style17 {font-size: 18px}
.style21 {font-size: 18px; color: #006600; }
.style25 {color: #990000}
-->
</style>
</head>
<body bgcolor="#333333" text="#CCCCCC" link="#666666" vlink="#999999" alink="#FFFFFF">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back1"><div align="center"><span class="text2b">[ Site Bakýmda]
</span></div></td>
</tr>
<tr>
<td class="back2"><div align="center"><span class="style17"><font class="normal">Ge?ici S?reli?ine Eri?im Durdurulmu?tur ! </font></span> </div>
<div> </div>
<div>
<div align="left" class="maintenance_reason"><span class="style21"><span class="style25">Bakým
Modu: </span> SQL baglantýsý kurulamadý L?tfen
daha sonra tekrar deneyin</span></div>
</div>
<font class="normal"> </font>
<div class="maintenance_com"> </div>
<div class="maintenance_reason">
<div align="center">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back2"><div class="maintenance_reason">
<div class="maintenance_com">
<div align="center"></div>
</div>
<div class="maintenance_info">
<div align="center">
<p> </p>
</div>
</div>
</div></td>
</tr>
</table>
</div>
</div></td>
</tr>
</table>
<div class="maintenance_com"> </div>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<tr>
<td class="back1"><div align="center"><span class="text2b">Bilgi i?in:
[ hayrig?ng?r@msn.com] </span></div></td>
</tr>
</table>
</body>
</html>
<!-- END: MAIN -->
Yard?mlar?n?z i?in ?imdiden hepinize te?ekk?r ederim
.
Sql ye baglanmazsa hata veriyor zaten ?uanki s?r?mler ayr?ca seditio 151 de benim ekledi?im bak?m modu ?zelli?i mevcut Admin panelden gerekli ayarlar yap?l?yor.
K?saca b?yle bir ?eye ihtiyac?n yok art?k.
Ba?ka bir sorununuz varsa yazabilirsiniz.
1 sorum daha olucak ;
Ben Seditio V.121 kullan?yorum, bulundu?um sunucuda biraz problem var san?r?m, bir ?ok kez bilet att?m olumlu bir cevap alamad?m
Sunucu bak?m? veya tas?mas? art?k sorun her ne ise s?rekli bu hatay? al?yorum
Kod:
2011-03-14 18:35
Fatal error : Could not connect to database !
Please check your settings in the file datas/config.php
MySQL error : Access denied for user 'ceyhunbel'@'localhost' (using password: YES)
Fatal error : Could not connect to database !
Please check your settings in the file datas/config.php
MySQL error : Access denied for user 'ceyhunbel'@'localhost' (using password: YES)
Yani kaan bey ben bu sayfay? g?rmek istemiyorum, sunucu bak?m? oldu?u zaman Database ba?lant?s? kurulamad??? zaman bu sayfa yerine ba?ka bir sayfay? g?sterme ?ans?m?z varm? ?
Mesela bu hata yerine, yeni bir sayfaya y?nlendirme olabilirmi y?nlendirece?imiz sayfada ise "?uanda sunucudan kaynaklanan bir aksakl?ktan dolay? ba?lant? kurulam?yor L?tfen daha sonra tekrar deneyin" gibi bir yaz? olmas?n? istiyorum
Ben config.php yi yanl?? yazm?? olsam bile yukar?daki bahsi gecen sayfay? a?t?rma ?ans?m?z varm?, b?ylebir kodlama m?mk?nm? ?
Yard?mlar?n?z i?in tekrar te?ekk?r ederim..
Kod:
function sed_sql_connect($host, $user, $pass, $db)
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
$select = @mysql_select_db($db, $connection) or sed_diefatal('Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
return(TRUE);
}
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
$select = @mysql_select_db($db, $connection) or sed_diefatal('Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
return(TRUE);
}
Buraya
Kod:
Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error()
ve buraya
Kod:
Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error()
Bir y?nlendirme kodu eklersen istedi?in sayfaya gidebilir.
Yada ??yle yapabilrsin.
Kod:
header("Location: gideceksayfa.html");
exit;
exit;
?eklinde bir y?nlendirme yapabilirsin.
Not: yukar?da i?lemler test edilmemi?tir.
son mesaj 2 dakika ?nce
Ayr?ca belirtmi? oldugun yaz? yerinide de?i?tirebilirsin benim vermi? oldugum kodlar?n i?inde mevcut hata verdi?i yer.
Kod:
header("Location: yonlendir/bakimda.html");
exit;
exit;
bu kodu system/database.mysql.php de nereye ve nas?l ekliyecem ba?lant? kurulamad??? zaman bu y?nlendirmenin ?al??mas?n? nas?l sa?layaca??m
Sizin kadar PHP bilgisine sahip de?ilim
fused zahmet veriyorum ?z?r dilerimDaha detayl? ve uygulamal? bir anlat?m yapabilirmisiniz ...
Kod:
function sed_sql_connect($host, $user, $pass, $db)
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
$select = @mysql_select_db($db, $connection) or sed_diefatal('Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
return(TRUE);
}
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('Could not connect to database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
$select = @mysql_select_db($db, $connection) or sed_diefatal('Could not select the database !<br />Please check your settings in the file datas/config.php<br />'.'MySQL error : '.sed_sql_error());
return(TRUE);
}
Alttaki ile de?i?tir.
Kod:
function sed_sql_connect($host, $user, $pass, $db)
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('<meta http-equiv="refresh" content="0;URL=yonlendir/bakimda.html">');
$select = @mysql_select_db($db, $connection) or sed_diefatal('<meta http-equiv="refresh" content="0;URL=yonlendir/bakimda.html">');
return($connection);
}
{
$connection = @mysql_connect($host, $user, $pass) or sed_diefatal('<meta http-equiv="refresh" content="0;URL=yonlendir/bakimda.html">');
$select = @mysql_select_db($db, $connection) or sed_diefatal('<meta http-equiv="refresh" content="0;URL=yonlendir/bakimda.html">');
return($connection);
}
??lem Tamamd?r istedi?in sayfaya y?nlendirebilirsin test edilmi?tir..