[dfc005]

I'm trying to use query_read to get a users birthday to display it to them in a custom page. But for some reason, it's always blank when it's returned.

I tried using birthday_search as well, it also comes back blank.

Any ideas?

[HyperActiv]

Have you tried:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

[dfc005]

Yup. Returns one row but that row has no value for birthday.....

[JamesC70]

If you're already including the vBulletin framework in your custom page, then $userinfo[birthday] will contain the user's birthdate.

[dfc005]

I assume as much but it's not returning anything either.

When I do a print_r on userinfo, I get the following....

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

Both birthday and birthday_search are blank. Is this a vB setting some where?

[JamesC70]

Are you testing with an account that's unalterable (per your config file)?

The only account in my database with no birthdate and a birthday_search of 0000-00-00 is my admin account, user #1.

If you look in your database through phpMyAdmin or similar, what's in the birthdate field for user #8?

[dfc005]

It's an admin account and it's unalterable but it certainly has a birthdate and birthday_search as I've checked the table using phpMyAdmin.

--------------- Added 01 Nov 2010 at 01:46 ---------------

Tried accessing a different userid which isn't an admin and isn't locked and it has the same problem.

--------------- Added 01 Nov 2010 at 04:48 ---------------

OK, after further testing, it seems to only be a problem on my development server. No idea how to fix it though.

[HyperActiv]

Originally Posted by dfc005

Yup. Returns one row but that row has no value for birthday.....

What do you mean row has no value for birthday?

In some of the cases you'll need to use PHP function

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

to get logical date, and not the unix time.

[dfc005]

The row was simply blank, no value. Not sure why it wasn't working on my development server but I reinstalled a fresh copy of vBulletin and it all seems to be fine now.