Hi to all, i will add to my site one page with one scrip for the payment by sms like i did on my old D6.1.6
But that works on d6.1.6 doesn't work for D7 :
$data_curenta = date("Y-m-d H:i",time());
$timp_30_zile = time() + (30 * 24 * 60 * 60);
$data_exp = date("Y-m-d H:i", $timp_30_zile);
$sql = mysql_query("SELECT * FROM sys_acl_levels_members WHERE IDMember='$memberID'"); (this work on D6.1.6)
if(mysql_num_rows($sql)==1)
{
db_res("
UPDATE `sys_acl_levels_members` SET `IDLevel` = '5' WHERE `sys_acl_levels_members`.`IDMember` =$memberID") ;
db_res("
UPDATE `sys_acl_levels_members` SET `DateStarts` = '$data_curenta' WHERE `sys_acl_levels_members`.`IDMember` =$memberID") ;
db_res("
UPDATE `sys_acl_levels_members` SET `DateExpires` = if(DateExpires >= now(), DateExpires + interval 30 day, now() + interval 30 day)
WHERE `sys_acl_levels_members`.`IDMember` = $memberID") ;
}
else
{
db_res("
INSERT sys_acl_levels_members (IDMember, IDLevel, DateStarts, DateExpires)
VALUES ('$memberID', '5', '$data_curenta', '$data_exp' )");
}