Hi all,
ive been reading for a few days and still feel way out of my depth,

Need:
when user becomes member populate profile field with date(+1 year),
i then want the expiry displayed in a views page

completed:
trigger for on member event,
views page,

problem:
(member date +1 year) --> profile_member_expiry

any comments appreciated including if im going about it the wrong way
many thanks in advance
Steve

Comments

canzi’s picture

canzi commented 
$day = date('j');
$month = date('n');
$year = date('Y', strtotime('+1 year'));
$convert = array('day' => $day, 'month' => $month, 'year' => $year);
$sldata = serialize($convert);
$sql = "insert into profile_values (fid, uid, value) values(13, $account, '%s')";

db_query("DELETE FROM profile_values WHERE fid = 13 AND uid = $account");
db_query($sql, $sldata);
canzi’s picture

canzi commented
Issue summary: View changes

update

tr’s picture

tr commented
Issue summary: View changes
Status: Active » Closed (outdated)

If you still have this problem in Drupal 7 or Drupal 8, please open a new issue with details.