[TYPO3-english] Run PHP code
sara_bets at hotmail.com
Tue Nov 19 20:23:43 CET 2013
I'm trying to do a self-made solution to deal with expiring usergroups (itypo_expiring_fe_groups) with some PHP code... I made some successful tests in XAMPP in a "normal" database, but when i tried to apply this to typo3, it was a big failure, as it does nothing.
Here it is my code ( used page_php_content extension to place it in one random page)
$exp_date = mysql_query("SELECT tx_itypoexpiringfegroups_groups, SUBSTRING(tx_itypoexpiringfegroups_groups,15,10) FROM fe_users WHERE uid=24702");
while($row = mysql_fetch_array($exp_date))
echo (strftime ( '%b-%d-%Y, %H:%M', $row ['SUBSTRING(tx_itypoexpiringfegroups_groups,15,10)'])). "<br />";
$teste = mysql_query("UPDATE fe_users SET usergroup='2' WHERE date(from_unixtime(SUBSTRING(tx_itypoexpiringfegroups_groups,15,10))) < date(now())");
If by this code is not very clear what i want to do, the main goal is to read the date of expiration of the membership (i used SUBSTRING because the field has other information like this "23|1383569880|1415105880*" and then compare it with the date of the server....If the server date is more recent than the expiration date, the usergroup must be changed.
Like i said before, i ran tests in Apache with a normal database and it worked perfectly, so maybe this is a wrong way to do what i need.
More information about the TYPO3-english