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!

[tubedogg]

Just download the updated file, now rewritten for v2.0.1. It should work fine.

Ya know, this could be taken to the next level with monthly horoscopes.

Maybe you could assign someone axcess to a mini-horoscope-CP and let them assign predictions to every zodiac. They could be the forum astrologist!

[webhost]

Loaded the hack today. Went to admin/mysql.php and ran file.
It came back and requested my username and password. I put it in hit login and got this error.

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.

Looked in mysql database and sign was not added.

Any idea's I had to remove from board because it stopped board from loading. I followed your directions to the T. Changes to member.php,register.php, and showthread.php in the root, and misc.php in the admin directory. I also added a folder under images called sign. Then made changes to templates modified postbit and added postbit_sign, I then uploaded files and then ran mysql,php when the above error came up.

I like the hack would like some way to get it to run, any help would be appreciated.

I also got this error via my email

Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user DROP sign
mysql error: Can't DROP 'sign'. Check that column/key exists
mysql error number: 1091
Date: Saturday 30th of June 2001 03:01:51 PM
Script: /admin/mysql.php?
Referer:

Joey

[tubedogg]

Try downloading the zip file and running mysql.php again. I've changed it slightly.

[webhost]

ok downloaded zip file again and uploaded my files again the only I did this time was to upload new mysql.php file in zip and run it this is the error I get now.

Parse error: parse error in /home/realweb/public_html/forums/admin/mysql.php on line 5

Joey

I didn't change any files I just ran your new version of mysql,php

Joey

[tubedogg]

Hmm...try again. I changed it.

[webhost]

ok getting closer, I was able to get through the setup this time and updated users. When I click on a uername in the forum to look at there profile I get this error in member.php

Parse error: parse error in /home/realweb/public_html/forums/member.php on line 423

elseif (($day > 18 and $month == 02) xor ($day < 20 and $month == 03)) { $sign = "pisces"; }
else { $sign == ""; }
**line 423** else
$birthday = "0000" . "-" . $month . "-" . $day;
elseif (($day > 19 and $month == 04) xor ($day < 21 and $month == 05)) { $sign = "taurus"; }

[webhost]

Tubedogg, got it work by changing this part of the script in the member.php file if you look this does differ from yours. All works now. I am using vb 2.0.1

// Birthday Stuff...
if ($calbirthday == 1) {
if ( ($day == -1 and $month != -1) or ($day !=-1 and $month == -1) ) {
eval("standarderror(\"".gettemplate("error_birthda yfield")."\");");
exit;
}
elseif (($day == -1) and ($month==-1)) {$birthday = 0;}
else {
if (($year>1901) and ($year<date("Y"))) {
$birthday = $year . "-" . $month . "-" . $day;
if (($day > 20 and $month == 03) xor ($day < 20 and $month == 04)) { $sign = "aries"; }
elseif (($day > 19 and $month == 04) xor ($day < 21 and $month == 05)) { $sign = "taurus"; }
elseif (($day > 20 and $month == 05) xor ($day < 22 and $month == 06)) { $sign = "gemini"; }
elseif (($day > 21 and $month == 06) xor ($day < 23 and $month == 07)) { $sign = "cancer"; }
elseif (($day > 22 and $month == 07) xor ($day < 23 and $month == 08)) { $sign = "leo"; }
elseif (($day > 22 and $month == 08) xor ($day < 23 and $month == 09)) { $sign = "virgo"; }
elseif (($day > 22 and $month == 09) xor ($day < 24 and $month == 10)) { $sign = "libra"; }
elseif (($day > 23 and $month == 10) xor ($day < 22 and $month == 11)) { $sign = "scorpio"; }
elseif (($day > 21 and $month == 11) xor ($day < 22 and $month == 12)) { $sign = "saggittarius"; }
elseif (($day > 21 and $month == 12) xor ($day < 20 and $month == 01)) { $sign = "capricorn"; }
elseif (($day > 19 and $month == 01) xor ($day < 19 and $month == 02)) { $sign = "aquarius"; }
elseif (($day > 18 and $month == 02) xor ($day < 20 and $month == 03)) { $sign = "pisces"; }
else { $sign == ""; }
}
else {
$birthday = "0000" . "-" . $month . "-" . $day;
if (($day > 19 and $month == 04) xor ($day < 21 and $month == 05)) { $sign = "taurus"; }
elseif (($day > 20 and $month == 05) xor ($day < 22 and $month == 06)) { $sign = "gemini"; }
elseif (($day > 21 and $month == 06) xor ($day < 23 and $month == 07)) { $sign = "cancer"; }
elseif (($day > 22 and $month == 07) xor ($day < 23 and $month == 08)) { $sign = "leo"; }
elseif (($day > 22 and $month == 08) xor ($day < 23 and $month == 09)) { $sign = "virgo"; }
elseif (($day > 22 and $month == 09) xor ($day < 24 and $month == 10)) { $sign = "libra"; }
elseif (($day > 23 and $month == 10) xor ($day < 22 and $month == 11)) { $sign = "scorpio"; }
elseif (($day > 21 and $month == 11) xor ($day < 22 and $month == 12)) { $sign = "saggittarius"; }
elseif (($day > 21 and $month == 12) xor ($day < 20 and $month == 01)) { $sign = "capricorn"; }
elseif (($day > 19 and $month == 01) xor ($day < 19 and $month == 02)) { $sign = "aquarius"; }
elseif (($day > 18 and $month == 02) xor ($day < 20 and $month == 03)) { $sign = "pisces"; }
else { $sign == ""; }
}
}
}
else {$birthday = 0;}

Joey

[webhost]

Found one bug tubedogg, Virgo,gif will not show up anywhere, I just get the box, all others work fine, When I look at the member,php file when I have a members profile up and viewing it I select view source code. All others except virgo show the proper path to the gif say like images/sign/leo.gif but virgo shows this images/sign/.gif.
Please Tubedogg help me finish this thing out so close, just need the one bug fixed.

Any Idea's Joey

anybody

[webhost]

Maybe the gods are trying to tell us all something by not letting the virgo sign show up???????????

Sure am happy I am a horny goat and not a virgo.

Joey