include("myCon.ini");
include("myCode.php");
include("chkTxt.php");
include("iLog.php");
include("cCount.php");
$bShow =5;
$sqlCheckSub="select * from member where iSub='$iSub'";
$querySqlCheckSub=mysql_query($sqlCheckSub);
$numSqlCheckSub=mysql_num_rows($querySqlCheckSub);
$sqlTitle="select * from ititle where iSub='$iSub'";
$querySqlTitle=mysql_query($sqlTitle);
$iTitle="";
$numTitle=mysql_num_rows($querySqlTitle);
if($numTitle>0)
{
$tolTitle=mysql_fetch_array($querySqlTitle);
$iTitle=$tolTitle['titleName'];
}
if($numSqlCheckSub==0)
{
$ID1=$iSub."0001";
$sqlInAdmin="insert into member(IDMember,myName,surname,uName,uPass,iSub,confirm,status) values('$ID1','yoot','yoot','admin','admin','$iSub',9,1)";
$querySqlInAdmin=mysql_query($sqlInAdmin);
if(!$querySqlInAdmin)
{
echo "เพิ่มข้อมูลพื้นฐานไม่ได้";
}else{
$sqlStatus1="insert into status(status,nameStatus,iSub) values('1','Admin','$iSub')";
$queryStatus1=mysql_query($sqlStatus1);
$sqlInMenu1="insert into menu(status,formatMenu,myLink,iStatus,iSub) values('1','เพิ่มกลุ่มในระบบ','myGroup.php',0,'$iSub')";
$querySqlInMenu1=mysql_query($sqlInMenu1);
$sqlInMenu3="insert into menu(status,formatMenu,myLink,iStatus,iSub) values('1','จัดการระบบสมาชิก','aEdit.php',0,'$iSub')";
$querySqlInMenu3=mysql_query($sqlInMenu3);
$sqlStatus2="insert into status(status,nameStatus,iSub) values('2','Guest','$iSub')";
$queryStatus2=mysql_query($sqlStatus2);
$sqlInMenu2="insert into menu(status,formatMenu,myLink,iStatus,iSub) values('2','แก้ไขข้อมูลส่วนตัว','uEdit.php',0,'$iSub')";
$querySqlInMenu2=mysql_query($sqlInMenu2);
}
}
// menu
$sqlMenu="select * from aleftmain where iSub='$iSub' order by IDaLeftMain ASC";
$queryMenu=mysql_query($sqlMenu);
$numMenu=mysql_num_rows($queryMenu);
//จบการ load menu
// load youtube
$sqlYou="select * from youtube where iSub='$iSub' and jShow=1";
$queryYou=mysql_query($sqlYou);
$numYou=mysql_num_rows($queryYou);
//end
// bannerRight
$sqlBanRight="select * from bannerright where iSub='$iSub' order by ID desc";
$queryBanRight=mysql_query($sqlBanRight);
$numBanRight=mysql_num_rows($queryBanRight);
// end
?>
echo $iTitle;?>