How to change post structure and some problems with birth dates

[VoSK]

YaBB SE Version: 1.5.4
Link to Forum: http://forum.theprodigy.ru/

Problem Description:
Hi! We've just upgraded our forum to the YabbSE.
First question is how to change the structure of the posts? We want user's Sex and Number Of Posts to be shown UNDER avatar, but not above it.
Secondly, we have some troubles with users' birth dates, after the convertion all the users that did not have their birth dated in profiles were automatically assigned today's day as birthday, how can we fix it?
Thanks much!

p.s. Great forum!

[Peter Duggan]

Hi! We've just upgraded our forum to the YabbSE.
First question is how to change the structure of the posts? We want user's Sex and Number Of Posts to be shown UNDER avatar, but not above it.

Search Display.php for:

Code Select Expand

      if ($muserID != '-1')
      {
         $userinfo .= '
                  ' . $star . '<br /><br />
                  ' . $online . '
                  ' . $userprofile[$mname]['gender'] . '
                  ' . $postinfo . '
                  ' . $userprofile[$mname]['avatar'] . '
                  ' . $userprofile[$mname]['personalText'] . '
                  ' . $userprofile[$mname]['ICQ'] . ' ' . $icq. ' ' . $msn . ' ' . $yim . ' ' . $userprofile[$mname]['AIM'] . '<br />
                  ' . implode($menusep, $profileButtons);
      }

And replace with:

Code Select Expand

      if ($muserID != '-1')
      {
         $userinfo .= '
                  ' . $star . '<br /><br />
                  ' . $online . '
                  ' . $userprofile[$mname]['avatar'] . '
                  ' . $userprofile[$mname]['gender'] . '
                  ' . $postinfo . '
                  ' . $userprofile[$mname]['personalText'] . '
                  ' . $userprofile[$mname]['ICQ'] . ' ' . $icq. ' ' . $msn . ' ' . $yim . ' ' . $userprofile[$mname]['AIM'] . '<br />
                  ' . implode($menusep, $profileButtons);
      }

Secondly, we have some troubles with users' birth dates, after the convertion all the users that did not have their birth dated in profiles were automatically assigned today's day as birthday, how can we fix it?

Should be a simple MySQL query, but I'll need to take a look and get back to you on that one!

[Peter Duggan]

Secondly, we have some troubles with users' birth dates, after the convertion all the users that did not have their birth dated in profiles were automatically assigned today's day as birthday, how can we fix it?

Should be a simple MySQL query, but I'll need to take a look and get back to you on that one!

Code Select Expand

UPDATE members SET birthdate = '0000-00-00' WHERE birthdate = 'xxxx-xx-xx';

NB xxxx-xx-xx should be whatever your problem date is eg. 2003-12-19 for today!

[VoSK]

thank you very much
if we get any other problems we'll post them here later
thanks one more time....