Astrological Signs

LAST UPDATED 6.30.01 1:05 AM Eastern
v0.2.0 Released - compatible with vBulletin 2.0.1
------------------------------------------------------------------------
This hack adds the astrological sign of any user who has provided at least the month and date of their birth. It can be updated retroactively for all your current board members, and it works automatically for any new users. It displays the sign next to the user's birthday in their public profile, and between the Online Status icon and the Profile button in every post they make.

This was requested and beta-tested by synx. It was in beta for approximately 5 minutes, which is what I think we should shoot for around here. (Before I get flamed, I'm JOKING! ). He also created the icons that are used in it. I can, however, assure you that I wrote all of the code, which is somewhat more than I can say for my star hack. Then I saw Marl's star hack, where he basically released Freddie's star hack as his, and I felt better, because I changed the code more than that. (Sorry, Marl, but I call em like I see em! )

If you installed my star hack, there are certain instructions in this that are different. Watch out for them, as it may mean the difference between it working and you posting here.

Without further ado, here it is. The instructions are, again, too long for posting, so they're in the zip file (sign.txt).

For version: 2.0.1

Files needed: mysql.php

Files to edit: member.php, register.php, showthread.php, admin/misc.php

Templates to create/edit: postbit_sign, postbit

Instructions are in the zip file.

Once again, PLEASE back everything up before installing this, as it does edit the user table.

PLEASE follow the directions exactly. There are some steps that, if they aren't followed in the right order, may screw up your board.

FEEDBACK WANTED! Likes/dislikes/modification requests all gladly accepted.

PLEASE DO NOT PM me or contact me via AIM or email me for help with this hack. I WILL see your post here and try to help you. Thanks!

Enjoy!

Ok, i'll keep debugging...

i hope it doesn't interfere with any other hack i have installed.

Thanks for your precious help, anyway.

cya

Good hack,but it's a crazy idea

[SilverBoy]

I wish u can do it to me.
I need it to run with 11x. plz

[SilverBoy]

I make some solution it is now show it if the user did update to his/her profile.
this modification on vb115, I did it tubedogg with my self

i dont know if it happened to anyone else but i added everything and a little icon box shows up but no icon if i do propetrties on the icon it shows the path to it but it doesnt show an icon name an anyone help me the path is as follows
images/sign/.gif

[tubedogg]

Did you run the Update Users function? (Admin CP > Update Counters > Update Users)

Originally posted by tubedogg
Did you run the Update Users function? (Admin CP > Update Counters > Update Users)

no i didnt but now i do and here i get an error never got this beforeUser ids:

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
i just recieved the email here it is can you help me fix thisDatabase error in vBulletin Control Panel: Invalid SQL: SELECT
userid,usertitle,usergroupid,customtitle,posts,bir thday,sign FROM user WHERE
userid>=0 AND userid<315 ORDER BY userid DESC
mysql error: Unknown column 'sign' in 'field list'
mysql error number: 1054
Date: Wednesday 25th of April 2001 04:17:48 PM
Script: /vbb/upload/admin/misc.php

[tubedogg]

Did you upload and run mysql.php that was in the zip file? You are missing the sign field in the user table according to that error and that would be an indicator that you did not run mysql.php.

Upload it to your admin directory, go to it in a web browser ( http://www.yoursite.com/forums/admin/mysql.php ) and then follow the link to your CP then run the Update Users function again.

i will refer here at a later time for now i removed the hack but will look into it soon thanx for your help
ps by saying run mysql.php you mean call on it in the browser?

[Amasov]

A great hack... but I'm still trying to integrate that one on my forum. Always gettin' an error in members.php (ParseError) and register.php (also ParseError).

I think the problem is, that your hack is searchin' for that:

*****find
        if (($year>1880) and ($year<2000)) {
           $birthday = $year . "-" . $month . "-" . $day;
        } else {
           $birthday = "2020" . "-" . $month . "-" . $day;
*****replace it with
        if (($year>1880) and ($year<2000)) {
           $birthday = $year . "-" . $month . "-" . $day;
             ..... etc.

but my register.php says that:

// Birthday Stuff...

..........

        if (($year>1901) and ($year<date("Y")))
           $birthday = $year . "-" . $month . "-" . $day;
        else
           $birthday = "0000" . "-" . $month . "-" . $day;
        if ($showbirthdays) {
          $todayneggmt = date("n-j",time()+(-12-$timeoffset)*3600);
          $todayposgmt = date("n-j",time()+(12-$timeoffset)*3600);
          if ($todayneggmt == "$month-$day" or $todayposgmt == "$month-$day")
            getbirthdays();

...........

I think that won't match at all, therefore it does'nt work!

Could you help me out of this situation??

Regards

Chris.