0){
while ($row=mysql_fetch_array($result)){
if($row["password"]!=md5($_POST["txtPassword"])){
$loginmessage="Invalid Login! Please retry.";
}else{
/* check plan is active.otherwise set free plan as user current active plam*/
$sql1="select dateofexpiry < now() as expired from ".$tableprefix."userplans where userplanid='".$row["currentuserplanid"]."'";
$result2=mysql_query($sql1) or die(mysql_error());
$row2=mysql_fetch_array($result2);
if($row2['expired']=="1"){ //plan expired
$sql3="update ".$tableprefix."userplans set planstatus='I' where userplanid='".$row["currentuserplanid"]."'";
mysql_query($sql3) or die(mysql_error());
$sql4=" update ".$tableprefix."userplans set planstatus='A' where plantype='F' and userid='".$row["userid"]."'";
mysql_query($sql4) or die(mysql_error());
$sql5="select userplanid from ".$tableprefix."userplans where plantype='F' and userid='".$row["userid"]."'";
$result3=mysql_query($sql5) or die(mysql_error());
$row3=mysql_fetch_array($result3);
$sql6="update ".$tableprefix."users set currentuserplanid='".$row3['userplanid']."' where userid='".$row["userid"]."'";
mysql_query($sql6) or die(mysql_error());
}
$userid=$row["userid"];
$sql=" SELECT count(DISTINCT(a.albumid)) as 'albumcount',
count(i.albumid) as 'totalimagecount',
sum(i.size) as 'totalimagesize',
u.username,
u.userid ,
CASE u.accountstatus
WHEN 'A' THEN 'Active'
WHEN 'P' THEN 'Pending'
WHEN 'R' THEN 'Registered'
WHEN 'I' THEN 'Inactive'
ELSE NULL
END AS accountstatus ,
up.planname,
up.maximages as imagesallowed,
up.allotedspace as allotedspace,
up.watermark as allowwatermark,
up.allowzip as allowzip,
up.allowhotlinking as allowhotlinking,
up.maxalbums as albumsallowed
FROM ".$tableprefix."albums a RIGHT JOIN ".$tableprefix."users u on a.userid = u.userid
LEFT JOIN ".$tableprefix."images i on a.albumid = i.albumid
LEFT JOIN ".$tableprefix."userplans up ON u.currentuserplanid = up.userplanid
" . $qryopt . " where u.userid ='$userid' group by u.userid";
$userplandetails=mysql_query($sql);
$row=mysql_fetch_array($userplandetails);
$_SESSION['sesstotalalbumcount']=$row['albumcount'];
$_SESSION['sesstotalimagecount']=$row['totalimagecount'];
$_SESSION['sesstotalimagesize']=$row['totalimagesize'];
$_SESSION['sessusername']=$row['username'];
$_SESSION['sessuserid']=$row['userid'];
$_SESSION['sessaccountstatus']=$row['accountstatus'];
$_SESSION['sessplanname']=$row['planname'];
$_SESSION['sessimagesallowed']=$row['imagesallowed'];
$_SESSION['sessallotedspace']=$row['allotedspace'];
$_SESSION['sessallowwatermark']=$row['allowwatermark'];
$_SESSION['sessallowzip']=$row['allowzip'];
$_SESSION['sessallowhotlinking']=$row['allowhotlinking'];
$_SESSION['sessalbumsallowed']=$row['albumsallowed'];
mysql_free_result($userplandetails);
echo "";
}
}
}else{
$loginmessage="Invalid Login! Please retry.";
}
}
?>
Now you can host your modeling portfolio photos on Modellifestyle.com's server!
This site comes with a host of image mangement and editing tools
to maximize your photo management experience.
Easy Uploading
