Ok fixed it now it wont give u 62 days when u do 1 month :busted_co
Code:
function GiveHC($user_id, $months){
$sql = mysql_query("SELECT * FROM users_club WHERE userid = '".$user_id."' LIMIT 1") or die(mysql_error());
$valid = mysql_num_rows($sql);
if($valid > 0){
mysql_query("UPDATE users SET rank = '2' WHERE rank = '1' AND id = '".$user_id."' LIMIT 1") or die(mysql_error());
mysql_query("UPDATE users_club SET months_left = months_left + ".$months." WHERE userid = '".$user_id."' LIMIT 1") or die(mysql_error());
$check = mysql_query("SELECT * FROM users_badges WHERE badgeid = 'HC1' AND userid = '".$user_id."' LIMIT 1") or die(mysql_error());
$found = mysql_num_rows($check);
if($found !== 1){ // No badge. Poor thing.
mysql_query("UPDATE users SET badge_status = '0' WHERE id = '".$user_id."' LIMIT 1") or die(mysql_error());
mysql_query("UPDATE users_badges SET iscurrent = '0' WHERE userid = '".$user_id."'") or die(mysql_error());
mysql_query("INSERT INTO users_badges (userid,badgeid,iscurrent) VALUES ('".$user_id."','HC1','1')") or die(mysql_error());
}
} else {
$m = date('m');
$d = date('d');
$Y = date('Y');
$date = date('d-m-Y', mktime($m,$d,$Y));
mysql_query("INSERT INTO users_club (userid,date_monthstarted,months_expired,months_left) VALUES ('".$user_id."','".$date."','0','0')") or die(mysql_error());
GiveHC($user_id, $months);
}
if(function_exists(SendMUSData) !== true){ include('includes/mus.php'); }
@SendMUSData('UPRS' . $user_id);
}