New Feature "User Group" Expire

[MagNaMan]

Hmm. I would guess the best place to check for auto-expiring would be during the login, where the username and password is entered. Also would need during cookie lookup, if user is using cookies.

[ryancooper]

03-31-03 at 03:59 PM trafix said this in Post #6
I was thinking more along the line of a premium paid usergroup, when the 12 month period has expired then they will be automaticly downgraded to a lower level (admin set) usergroup. that way i dont have to keep checking manually....maybe an auto pm to member and admin informing them of the downgrade would also be an advantage.

I can use this as well! :banana:

[nhlrat]

Could use here as well.

[trafix]

OK OK, I have not had time to look into this any further, however Since i realy need this hack, it look like im going to have to force myself to learn more to build the hack..... give me a week or so as i have other projects to complete

[N!ck]

I have this running once a month with a cronjob in case you want some inspiration:

PHP Code:

<?php
if ($action=="renew") {
  header("Location: [url]https://www.paypal.com/xclick/business=lebeldc%40yahoo.com&item_name=V-Driveboat.com+Insider+Renewal+-+1+year+-+[/url]".$user."&item_number=01005&amount=15.00&no_note=1&currency_code=USD");
  exit;
}
mysql_connect("localhost","******","******");
mysql_select_db("******");
mysql_query("UPDATE user SET usergroupid='2', iexpire='0' WHERE usergroupid='8' AND iexpire < ".time());
$month=time()+2592000;
$renewusers=mysql_query("SELECT * FROM user WHERE usergroupid='8' AND iexpire < $month");
while ($user=mysql_fetch_array($renewusers)) {
  $email=stripslashes($user[username]).",\n\n";
  $email.="Your V-Driveboat.com Insider subscription is going to expire in approximately one month.  To ensure uninterrupted access, please renew your subscription as soon as possible.  You can instantly renew with a credit card by going to the following address:\n\n";
  $email.="http://www.v-drivebooat.com/imanage.php?action=renew&user=".urlencode(stripslashes($user[username]))."\n\n";
  $email.="If you prefer, you are also welcome to mail your $15.00 renewal fee (be sure to include your username) to:\n";
  $email.="V-Driveboat.com Insider\n";
  $email.="P.O. Box 1576\n";
  $email.="Lake Havasu City, AZ 86405-1576\n\n";
  $email.="Thank you for your continued support of V-Driveboat.com, the web's first and leading v-drive enthusiast community.\n\n";
  $email.="Regards,\n";
  $email.="Nick Saunders\n";
  $email.="nick@v-driveboat.com";
  mail($user[email],"Your subscription is almost expired",$email,"From: \"V-Driveboat.com Insider\" <insider@v-driveboat.com>");
  if ($show=="y") {
    echo $month."<br>";
    echo stripslashes($user[username])."<br>";
  }
}
mysql_close();
echo "<br>Done.";  
?>

All you need to do is use mktime() in admin/user.php and add 365.26 days (or 31558464 seconds) to the timestamp, then add the iexpire field to the user table.

[trafix]

Nick, I need all the inspriation that i can get .... lol

looking at the code, Ihis is now an automated process ????

I presume that you have to activate it via a link in the admin panel.

If i added similar code to the admin/user.php, this will check the paid members current status each time they view a page or visit the site. I spost that it would add an extra quriy for paid membeers , this would not be so bad. i would have to add a second column to the user table so when the expired membersship code is activated, it sets the value to "1" that tells the script next time around that the email has already been sent.

Will that work??

[trafix]

sorry the code would have to go in the admin/functions.php.........right???

[N!ck]

Actually, mine's just in the root vB folder (doesn't pose a security threat), and it simply runs via a cronjob once per month.

[JeffyJoe]

any progress on a full hack for this yet?

[Neo]

there can be security holes in cron jobs, make sure the script has security measures.