ob_start();
include("classes/Connection2.php");
$sql_connect=new Connection("DBNAME","USERNAME","PASSWORD","SERVER");
$set=0;
session_start();
if(isset($_POST['submit']))
{
if($_POST['type']=="user")
{
$select_query="SELECT * FROM users where user_login LIKE BINARY '".$_POST['username']."' and password LIKE BINARY '".$_POST['password']."' and status='active'";
//echo $select_query;
$result_query=mysql_query($select_query);
$mysql_rows=mysql_fetch_array($result_query);
if($mysql_rows)
{

$_SESSION['login_user']=$_POST['username'];
$_SESSION['login_type']="user";
header("Location:users_magazine/index.php");
}else
{
$error="Invalid Username or Password";
}

}else
{
$select_query="SELECT * FROM publisher where publisher_login LIKE BINARY '".$_POST['username']."' and password LIKE BINARY '".$_POST['password']."'";

$result_query=mysql_query($select_query);
$mysql_rows=mysql_fetch_array($result_query);
if($mysql_rows)
{
/* */
$q="select * from publisher_account where publisher_login ='".$_POST['username']."'";
$q1=mysql_query($q);
$row=mysql_fetch_array($q1);
if(($mysql_rows['status']=="deactive") && ($row['type']=="pay"))
{

$_SESSION['login_main']=$_POST['username'];
$_SESSION['login_type']="deactive";
header("Location:users/index.php");
}elseif($mysql_rows['status']=="active")
{

$_SESSION['login_main']=$_POST['username'];
$_SESSION['login_type']="active";
header("Location:users/index.php");
}else
{
$error="Please activate your account";
}
}
else
{
$error="Invalid Username or Password";
}
}
}

ob_end_flush();
?>