Hi,
I've tried everything I can think of to get this to work, but no go. No one seems to have posted this on the forum either. What I'm doing is trying to update a user value on profile view.
switch($tid)
{
case $data->{recent_games}[1]->tid:
//$resultDate = strtotime($data->{recent_games}[1]->last_played);
$user->cb_lastactive = $data->{recent_games}[1]->last_played;
$user->store();
$user->cb_lastplayeddate = $data->{recent_games}[1]->last_played;
$user->store();
break;
The first field, cb_lastactive is a DATE field.
The second field, cb_lastplayeddate is a TEXT field.
when the code runs as is, cb_lastactive displays 22/20/9 for the date. cb_lastplayeddate displays 9/22/2011.
variable $data->{recent_games}[1]->last_played is a string, which is why I tried
$resultDate = strtotime($data->{recent_games}[1]->last_played); which will allow the field to be updated in the BROWSER, but the $user->store(); doesn't work. I can't get anything into that date field using that function. HELP!
figured it out, for anyone else that may run in to this issue. For whatever reason, a date STRING is in the wrong order for CB to accept it into a DATE FIELD. So you have to explode it first, then reconstruct it in a format CB will take.
Code:
//String is contained in an array, in MM/DD/YYYY format ie 09/22/2011
// exploding puts the string into an array, [0] is 09, [1] is 22, [2] is 2011
$date = explode("/", $data->{recent_games}[1]->last_played);
// Rearrange them to CB liking
$dateformat= ($date[2]."/"."0".$date[0]."/".$date[1]);
//This part posts the properly formatted string to the date field
$user->cb_lastactive = $dateformat;
$user->store();
My apologies. if you read the first post you see that I was trying to send a string to a CB date field from some code I had modified in a cb plugin, and I couldn't get it right. I could get the field on the tab to show up, but the DATE field wouldn't save until I added that code in the second post. After a lot of trial and error I finally got it to go in there but I had to jack it around to do it. I have no idea why, so I posted my solution to the problem.
busterocaps wrote: My apologies. if you read the first post you see that I was trying to send a string to a CB date field from some code I had modified in a cb plugin, and I couldn't get it right. I could get the field on the tab to show up, but the DATE field wouldn't save until I added that code in the second post. After a lot of trial and error I finally got it to go in there but I had to jack it around to do it. I have no idea why, so I posted my solution to the problem.
Thanks for posting.
I was confused because you posted in the potential bug area of CB.
nant