htacces seo 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.article_snippet,A.article_category_id,C.category_name 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_title,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_id,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_title,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_title,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_title,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_title,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,password,user_type,user_hear,user_role,user_daily_email)values('".pdbfx("first_name")."','".pdbfx("last_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)values('".pdbfx("article_author")."','".pdbfx("article_snippet")."','".pdbfx("article_summary")."','".pdbfx("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_daily_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");
}

}
?>