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!

[webhost]

JOEYMOSES1@HOME.COM

[webhost]

tubedogg please help

Will you probably know by now how everything has chnaged with the new
version of vb 2.0.3, now alot of stuff got moved from the showthread.php file to the functions.php file.
Your hack still works in the member profile section but does not in the showthread page, it does not show up at all. Can you tell me what I need to do to fix this.

Joey

[Tarion]

only in the Threadpage, not in the Memberlist. V2.0.3 has to much changes and so the Hack dosen't work. I've must change many things in function.php, all my hard work to get the sings in member.php aren't worked.

[webhost]

tubedogg

Did you give up trying to get this to work?

Tubedogg

Sorry to bother yer! Just wondered are you planning on doing an updated version of this hack as I would LOVE to install it on my board

[Alien]

Anyone have this working on 2.0.3, and if so what has changed so it will go in without a problem? The last 2 pages of this thread don't persuade me to continue without asking...

Thanks.

[cyrus]

Im using 2.0.3 too, everything was fine but in showthread.php

seems stuff has changed since the hack was made

any one got a FIX for this to make this hack work ??? I LOVE THIS !!!!!!!!

thanks

[webhost]

Man I have tried moving the stuff to functions.php, tried putting information in both files including showthread.php and just put in showthread.php by itself . I have beat my head against this thing for to long, maybe Tubedogg,Firefly, or Madman can come with a fix. I tried all kinds of stuff but not the right one.

[AJR]

I am using vBulletin 2.0.3 with vBPortal 2.0.1 and a list of other hacks, and I have the Astrological hack working fine (except for the Virgo?!? sign not showing for the dates).

Make sure if you have other hacks installed like the Stars, Country Flag, vBPortal, etc that you verify the $DB_site->query lines! I changed nothing in showthread.php, only admin/functions.php. Here is what I had to edit:

Files:
member.php
register.php
admin/functions.php
admin/misc.php

Templates:
postbit
added postbit_sign

Ran this query in phpMyAdmin:
ALTER TABLE user ADD sign VARCHAR(25) not null


In the member.php and register.php files, I had to add the {} brackets to these lines:
if (($year>1901) and ($year<date("Y"))) {
.....
} else {
....
}

Otherwise the script would get a parse error.

After I installed everything above, I ran the 'Update Counters' for 'Update Users' in the Admin CP. I then went into phpMyAdmin and did a replacement:

UPDATE user SET sign = "virgo" WHERE birthday > 0000-00-00 AND sign = ""

With the exception of a few stragglers, most of the user records where the user entered their birthday but the sign field is still empty at this point (after updating counters) means they should be a Virgo!

Other than the above, that was it! You can see my board at http://www.vpforums.com

[webhost]

What did you put in functions.php and where?