ok i got that error fixed i didnt see it at the time but at the break above the code it was missing the ";"
but now i got it working i am trying to make a client account and it is saying i dont have the 10 posts for it so i am going to post what i have got made and see what you think about it
plus i will post the info for the database like how the username is set up the way to find the member id in the posts in the database
ok here is the code for the monthly check
Code:
case "fusion":
$n = 0;
$forumuser = $fuser;
$result = mysql_query("SELECT * FROM `{$prefix}users` WHERE user_name = '{$fuser}'", $this->con);
$mem = mysql_fetch_array($result);
$select = mysql_query("SELECT * FROM {$prefix}posts WHERE `post_author` = '{$mem['id']}'", $this->con);
while($data2 = mysql_fetch_array($select)) {
$date = explode(":", strftime("%m:%y" ,$data2['ptime']));
if($nmonth <= $date[0] && $nyear <= $date[1]) {
$n++;
}
}
break;
and then here is the code for for the check sign up
Code:
case "fusion":
$result = mysql_query("select * from `{$prefix}users` where user_name = '{$fuser}'", $this->con);
if(mysql_num_rows($result) == "0") {
return 3;
}
else {
$member = mysql_fetch_array($result);
if(md5(md5($fpass)) == $member['password']) {
if($member['posts'] >= $signup) {
return 1;
}
else {
return 0;
}
}
else {
return array('true' => '0', 'customerror' => '<h1>Error</h1>That forum password is incorrect!');
}
}
break;
here is a screen shot of the fusion_posts
here is a screen shot of the fusion_users