htacces yardim

merhaba arkadaslar bir script buldum derledim toplarladim derken karsima kucuk bir sorun cikdi ve bunun altindan kalkamadim örnekli sekilde sorunumu anlatacagim bana bir akil verecek arkadasa minnetdar kalacagim


konu icerikleri su sekil cikiyor xxx.xxx.dot/articles.html

bu sekilde degilde

xxx.ccc.dot/konu_adi_selam_kelam.html olarak cikmasini istiyorum


ceken kod ise bu


<a href="article<?=$rshome["article_id"];?>.html" class="bodylinks"><strong><?=$rshome["article_title"];?>

-------------------------------------------------------
headerin üzerindeki baglanti kodlari


<?if ($metatitle!='')
$metatitle.=" ".getsettings(2,"",2);
else
$metatitle=getsettings(2,"",2);
if ($_GET["pagedb"]!='')
$metatitle=$_GET["pagedb"]." ".$metatitle;
?>
----------------------------------------------------------


birde soyle bir dosya var




<?
if ($_GET["page"]=='home' || $_GET["page"]=='')
{
$sql="SELECT A.article_id,A.article_title,A.article_author,A.ar ticle_snippet,A.article_category_id,C.category_nam e FROM article_master A,category_master C where A.article_home_page=1 and A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 order by C.category_name asc,A.article_title asc";
$cmdhome = mysql_query($sql);
}
$sql="SELECT C.category_name,C.category_id FROM category_master C where C.category_status=1 and C.category_id<>1 order by C.category_articles_count desc,C.category_name asc limit 0,15";
$cmdcategory = mysql_query($sql);

if ($_GET["page"]=='category' && $_GET["category_id"]!='')
{
$sql="SELECT C.category_description,C.category_name,A.article_t itle,A.article_author,A.article_snippet,A.article_ category_id,A.article_id,A.article_views FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and C.category_id=".$_GET["category_id"]." order by A.article_title asc";


$pg = new paging;
$pg->setpages("SELECT count(*) FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and C.category_id=".$_GET["category_id"]);
$sql .=$pg->getlimit();
$cmdartcat = mysql_query($sql);

$sql="SELECT C.category_description,C.category_name,C.category_ id FROM category_master C where C.category_status=1 and C.category_id=".$_GET["category_id"];
$cmdartcat1 = mysql_query($sql);
$rshome1 = mysql_fetch_array($cmdartcat1);
$metatitle=$rshome1["category_name"];
}

if ($_GET["page"]=='article' && $_GET["article_id"]!='')
{
$sql="SELECT C.category_name,A.article_title,A.article_author,A .article_snippet,A.article_category_id,A.article_i d,A.article_summary,A.article_date,A.article_views FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and A.article_id=".$_GET["article_id"];
$cmdarticle = mysql_query($sql);
$rshome = mysql_fetch_array($cmdarticle);
$metatitle=$rshome["article_title"];
$countwords=split(" ",$rshome["article_summary"]);
$countwords=count($countwords);


$sql="update article_master set article_views=article_views+1 where article_status=1 and article_id=".$_GET["article_id"];
mysql_query($sql);

}

if ($_GET["page"]=='mostpopulararticles')
{

$sql="SELECT C.category_description,C.category_name,A.article_t itle,A.article_author,A.article_snippet,A.article_ category_id,A.article_id,A.article_views FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and A.article_views >0 order by A.article_views desc";

$cmdartcat = mysql_query($sql);

$metatitle="Most Popular Article";


}
if ($_GET["page"]=='search')
{
$sql="SELECT C.category_description,C.category_name,A.article_t itle,A.article_author,A.article_snippet,A.article_ category_id,A.article_id,A.article_views FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and (A.article_title like '%".$_GET["q"]."%' OR A.article_snippet like '%".$_GET["q"]."%' OR A.article_summary like '%".$_GET["q"]."%')order by A.article_views desc";
$cmdartcat = mysql_query($sql);
$metatitle="Search Results For ".$_GET["q"];

}
if ($_GET["page"]=='author' && $_GET["author_name"]!='')
{
$sql="SELECT C.category_description,C.category_name,A.article_t itle,A.article_author,A.article_snippet,A.article_ category_id,A.article_id,A.article_views FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_status=1 and A.article_author ='".$_GET["author_name"]."' order by A.article_title asc";
$cmdartcat = mysql_query($sql);
$metatitle="Articles By Author ".$_GET["author_name"];

}

if ($_GET["page"]=='userarticles' && $_SESSION["user"]!='')
{
$sql="SELECT C.category_description,C.category_name,A.article_t itle,A.article_author,A.article_snippet,A.article_ category_id,A.article_id,A.article_views,A.article _status FROM article_master A,category_master C where A.article_category_id=C.category_id and C.category_status=1 and A.article_user_id=".$_SESSION["user_id"]." order by A.article_title asc";
$cmdartcat = mysql_query($sql);


}
if ($_POST["submitregister"]!='')
{
$_SESSION["errmsg"]='';
if ($_POST["first_name"]=='')
$_SESSION["errmsg"]="@First Name Should not be blank";
if ($_POST["last_name"]=='')
$_SESSION["errmsg"].="@Last Name Should not be blank";
if ($_POST["email"]=='')
$_SESSION["errmsg"].="@Email Address Should not be blank";
if (!eregi('^[a-zA-Z0-9._-]+@[a-zA-Z0-9._-]+\.([a-zA-Z]{2,4})$',$_POST["email"]) && $_POST["email"]!='')
$_SESSION["errmsg"].="@Email Address does not looks like valid.";
if ($_SESSION["errmsg"]=='')
{
$sql="select email from user_master where user_name='".pdbfx("email")."'";
$cmd = mysql_query($sql);
$rs = mysql_fetch_array($cmd);

if ($rs["email"]!='')
$_SESSION["errmsg"].="@This email address is already in use and can not be registered again.";

}

if ($_SESSION["errmsg"]=='')
{
$user_daily_email=0;
if (pdbfx("user_daily_email")!='')
$user_daily_email=1;
$password=genpasswordnum(6);
$sql="insert into user_master(first_name,last_name,email,user_name,p assword,user_type,user_hear,user_role,user_daily_e mail)values('".pdbfx("first_name")."','".pdbfx("la st_name")."','".pdbfx("email")."','".pdbfx("email" )."','".$password."',3,'".pdbfx("user_hear")."', '" .pdbfx("user_role")."',".$user_daily_email.")";
mysql_query($sql);
$msg="Your password is email to to you.Please Check your email.";
$body="Dear ".$_POST["first_name"].",<br>";
$body.="Thank you for your registration at <a href=".getsettingssingle(3)." target=_blank>".getsettingssingle(2)."</a>";
$body.="<br><br>Your Login password is ";
$body.="<br><font color=blue><b>".$password."</b></font><br><br>Thanks,<br>Webmaster";
$subject=$_POST["first_name"]." Your Password for ".getsettingssingle(2);
$headers = "From: ".getsettingssingle(1)." \nContent-Type: text/html";
mail($_POST["email"],$subject,$body,$headers);
$_SESSION["msg"]="";
$_SESSION["msg"]="@Your registration is complete now,you password is email to you.";
$_SESSION["msg"].="@Email with password should arrive to you in few seconds.";
redirect("index.php?page=message");
}
}
if ($_POST["submitlogin"]!='') {
$_SESSION["errmsg"]="";
$sql="select * from user_master where active=1 and user_type=3 and user_name='".pdbfx("user_name")."'";
$cmd = mysql_query($sql);
$rs = mysql_fetch_array($cmd);
if (cmpfx($rs["user_name"], $_POST["user_name"]) && cmpfx($rs["password"], $_POST["password"])) {
$_SESSION["user"] = $_POST["user_name"];
$_SESSION["user_id"] =$rs["user_id"];
redirect("index.php");
}
else {
$_SESSION["errmsg"]="@Invalid Username / Password";
redirect("index.php?page=login");
}
}
if ($_GET["page"]=='submitarticle' && empty($_SESSION["user_id"]))
{
$_SESSION["errmsg"]="@You must be login to submit the articles.";
$_SESSION["errmsg"].="@<a href='index.php?page=register' class='heading'><u>Click Here</u> to signup if you are a new user</a>";
redirect("index.php?page=login");
}
if ($_GET["page"]=='forgetpassword')
{
$_SESSION["errmsg"]="";
}
if ($_GET["page"]=='register' && $_POST["submitregister"]=='' )
{
$_SESSION["errmsg"]="";
}
if ($_GET["page"]=='submitarticle' && $_SESSION["user_id"]!='')
{
$_SESSION["errmsg"]="";
}
//submit An Article
if ($_POST["submitarticle"]!='')
{
$_SESSION["errmsg"]='';
if ($_POST["article_title"]=='')
$_SESSION["errmsg"]="@Article Title Should not be blank";
if ($_POST["article_author"]=='')
$_SESSION["errmsg"].="@Article Author Should not be blank";
if ($_POST["article_snippet"]=='')
$_SESSION["errmsg"].="@Article Snippet Should not be blank";
if ($_POST["article_summary"]=='')
$_SESSION["errmsg"].="@Article Should not be blank";
if ($_SESSION["user_id"]=='')
{
$_SESSION["errmsg"].="@Your session has been expired.";
redirect("index.php?page=login");
}

if ($_SESSION["errmsg"]=='')
{
if (getsettings(5,"",2)==1)
$article_status=0;
else
$article_status=1;
$listing_date=date("Y-m-d");
$sql="insert into article_master(article_author,article_snippet ,article_summary,article_title,article_category_id ,article_user_id,article_status,article_date)value s('".pdbfx("article_author")."','".pdbfx("article _ snippet")."','".pdbfx("article_summary")."','".pdb fx("article_title")."','".pdbfx("article_category _ id")."',".$_SESSION["user_id"].",".$article_status.",'".$listing_date."')";
mysql_query($sql);

$_SESSION["msg"]="";
$_SESSION["msg"]="@Your article is submitted.";
$_SESSION["msg"].="@Once approved you can see it on the website in next 24-72 hours.";
redirect("index.php?page=message");
}
}
if ($_GET["page"]=='personal' && $_SESSION["user_id"]!='')
{
$sql="SELECT * from user_master where user_id=".$_SESSION["user_id"]." and active=1";
$cmd = mysql_query($sql);
$rs = mysql_fetch_array($cmd);

}

if ($_POST["submitregisterupdate"]!='')
{

$_SESSION["errmsg"]='';
if ($_POST["first_name"]=='')
$_SESSION["errmsg"]="@First Name Should not be blank";
if ($_POST["last_name"]=='')
$_SESSION["errmsg"].="@Last Name Should not be blank";
if ($_POST["password"]=='')
$_SESSION["errmsg"].="@Password Should not be blank";
if ($_SESSION["user_id"]=='')
{
$_SESSION["errmsg"].="@Your session has been expired.";
redirect("index.php?page=login");
}
if (strlen($_POST["password"])<='4' && $_POST["password"]!='')
$_SESSION["errmsg"].="@Password should be atleast 6 characters long";

if ($_SESSION["errmsg"]=='')
{
$user_daily_email=0;
if (pdbfx("user_daily_email")!='')
$user_daily_email=1;

$sql="update user_master set first_name='".pdbfx("first_name")."',last_name='". pdbfx("last_name")."',password='".pdbfx("password" )."',user_role='".pdbfx("user_role")."',user_dai ly _email=".$user_daily_email." where user_id=".$_SESSION["user_id"];
mysql_query($sql);
$_SESSION["msg"]="";
$_SESSION["msg"]="@Your Personal info is now updated.";
redirect("index.php?page=message");
}
}
if ($_POST["submitforget"]!='') {

$_SESSION["errmsg"]="";
$sql="select * from user_master where active=1 and user_type=3 and user_name='".pdbfx("user_name")."'";
$cmd = mysql_query($sql);
$rs = mysql_fetch_array($cmd);
if ($rs["user_name"]!='')
{
$body="Dear ".$rs["first_name"].",<br>";
$body.="<br><br>Your Login password is ";
$body.="<br><font color=blue><b>".$rs["password"]."</b></font><br><br>Thanks,<br>Webmaster";
$subject=$rs["first_name"]." Your Password for ".getsettingssingle(2);
$headers = "From: ".getsettingssingle(1)." \nContent-Type: text/html";
mail($_POST["user_name"],$subject,$body,$headers);
$_SESSION["msg"]="";
$_SESSION["msg"]="@Your password is email to to you.Please Check your email.";
$_SESSION["msg"].="@Email with password should arrive to you in few seconds.";
redirect("index.php?page=message");
}
else
{
$_SESSION["msg"]="";
$_SESSION["msg"]="@We don't have any record for this email address.";
redirect("index.php?page=message");
}

}
?>
-----------------------------------------------------------------------
<a href="konu<?=$rshome["article_title"];?>-<?=$rshome["article_id"];?>.html bu sekilde yaptim

istedigim gibi cikiyor fakat sayfadaki icerik cikmiyor
,
xxx.com/konuselam-1.html
----------------------------------------------

htacces dosyasida su sekilde


# -FrontPage-
IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*
RewriteEngine on
RewriteRule ^category(.*).html$ index.php?page=category&category_id=$1 [L]
RewriteRule ^konu(.*).html$ index.php?page=article&article_id=$1 [L]
RewriteRule ^page_(.*).html$ index.php?pagedb=$1 [L]
RewriteRule ^index.html$ index.php
<Limit GET POST>
order deny,allow
deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>

bu satiri
RewriteRule ^konu(.*).html$ index.php?page=article&article_id=$1 [L]
bu sekilde
RewriteRule ^konu-(.*).html$ index.php?page=article&article_id=$1 [L]
yapip dener misin?

olmadi be kardes malesef sayfa goruntulenemiyor diyor

yardim edebilirsen msn aklermisin alper(at) vatanlar.dot

pardon yanlis gormusum su sekilde dener misin?

konu<?=$rshome["article_title"];?>
burayi bu sekilde
konu-<?=$rshome["article_title"];?>
burayida
RewriteRule ^konu(.*).html$ index.php?page=article&article_id=$1 [L]
bu sekilde
RewriteRule ^konu-(.*)-(.*).html$ index.php?page=article&article_id=$2 [L]

kardesim allah razi olsun olduda su karakter sorunlari cikdi bunlari düzeltebilirmiyiz

konu-erkekler%20sesde%20ne%20ister-2.html


reple cosdurdum seni

Sagol sendende razi olsun.

Bunu sayfanin en basina koy

$asd=trim(eregi_replace('[^abcçdefghiıjklmnöopqrşstuüvwxyzABCÇDEFGĞHIıİJKLMNOÖPQRSŞTUÜVWXYZ0123456789]','-',$asd));
$asd=strtolower($asd);
$f=array("ş","ö","ü","ı","ğ");
$r=array("s","o","u","i","g");
$asd=strtolower(str_replace($f,$r,$asd));
$asd=str_replace("---","--",$asd);
$asd=str_replace("--","-",$asd);
return $asd;
}

bunu

 konu-<?=$rshome["article_title"];?>

bununla

 konu-<?=permalink($rshome["article_title"]);?>

degistir bakalim calisacak mi?

bu kodu sayfanin en basina koydugum zaman sayfayi acdiginda kod oldugu gibi cikiyor kardes nedense <php icinemi almamiz gerek

evet php tagları içine al yada <? kod ?> gibi yap.

<?php
$asd=trim(eregi_replace('[^abcçdefghiıjklmnöopqrşstuüvwxyzABCÇDEFGĞHIıİJKLMNOÖPQRSŞTUÜVWXYZ0123456789]','-',$asd));
$asd=strtolower($asd);
$f=array("ş","ö","ü","ı","ğ");
$r=array("s","o","u","i","g");
$asd=strtolower(str_replace($f,$r,$asd));
$asd=str_replace("---","--",$asd);
$asd=str_replace("--","-",$asd);
return $asd;
}  
?>

ya da hersayfaya include edilen funcktion yada db veya config gibi php sayfaların içinede çaksan olur.

<?
global $_cn;
global $dbserver;
global $db;
global $dbuser;
global $dbpass;

//mysql database server,login,password & Database name
$dbserver ="localhost";
$database_connect="makale";
$dbuser ="makses";
$dbpass ="asdsad";

$connect = mysql_connect($dbserver, $dbuser, $dbpass)
or die("Couldn't connect to MySQL");
mysql_select_db($database_connect, $connect);

?>

<?php
$asd=trim(eregi_replace('[^abcçdefghiıjklmnöopqrşstuüvwxyzABCÇDEFGĞHIıİJKLMN OÖPQRSŞTUÜVWXYZ0123456789]','-',$asd));
$asd=strtolower($asd);
$f=array("ş","ö","ü","ı","ğ");
$r=array("s","o","u","i","g");
$asd=strtolower(str_replace($f,$r,$asd));
$asd=str_replace("---","--",$asd);
$asd=str_replace("--","-",$asd);
return $asd;
}
?>

su sekilde yaptim ama sayfa acilmiyor yapdigim zamanda