Astrological Signs

[tubedogg]

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! :D). 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! :D 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!

hey i like this one :D thanks

isnt it better to create a chunk of code thatll calculate the sign on the fly, instead of adding a field to the user table? i mean, its not a big deal to process the code anyway. dunno about php substrings functions though.

I hate it! ITS HORRIBLE!
HA HA HA HA! j/k j/k

The hack is great when ya read the instrusction and install correctly, ooops my bad! HA HA HA! I hate my icons, Im gunna change them and I will add there here.

I added a small pop-up window when you click the sign, and the name of the sign in the user profile if anyone would like it just ask.

My forums are here www.form-kaos.com/forum with all sorts of hacks on it.

snyx

Originally posted by Dream
isnt it better to create a chunk of code thatll calculate the sign on the fly, instead of adding a field to the user table?

I was going back and forth about that. I think, since it won't change (unless the user changes his/her birthday, and I've made an allowance for that), it makes more sense to have it stored, that way it only needs to determine it once, and from there it doesn't add anything - user.* is already in the query that gets pulled for showthread.php, so there's no additional queries, and the only thing added is the little bit of code to find out if the user's sign is blank in the DB.

Could go either way. :)

but how I can change it to run on my board, it is still vb115, and I dont want to convert it to vb2 until the final release of it.

v1.1.5 didn't do birthdays, did it? I don't think it did, and this relies on birthdays.

Also, you should upgrade to 1.1.6 - there is a huge security hole in 1.1.5!

I installed birthday hack on my board. so can I do it????

IMPORTANT NOTE! For those that installed this hack during the day today, you MUST upgrade as stated in the first post in this thread. I fixed a major bug and now everything should be working correctly.

Thanks for using my hack! :)

I have never worked with v1.1.5 or 1.1.6, nor have i seen the birthday hack. Therefore I cannot tell you if it would work, nor can I tell you how to modify the code to make it work. If you would like to point me towards the code for the birthday hack, I can get a copy and of 1.1.5 and look at it.

this is the birthday hack which iam using.

Originally posted by tubedogg
IMPORTANT NOTE! For those that installed this hack during the day today, you MUST upgrade as stated in the first post in this thread. I fixed a major bug and now everything should be working correctly.


Oh man.......thanks!

i was thinking that i did some mistakes installing it

'-_-

} else { $zay = "yaz"; }



in fact,this part didn't make any sense to me.. :?

Yeah I know. :) Coding at that hour of the morning (when you haven't been to bed yet) shouldn't be allowed! ;)

:)

i have another prob.
i'm virgo, and it properly detects my sign.....

any clues?

Huh? If it's right, what's the problem?

i don't sleep at all :P

dunno what's wrong, it ignores virgo signs, doesn't add anything in the sign field.....

im trying to debug that..

I have updated the zip file to reflect this change, so if you have not installed the hack yet, just download the zip file and follow the instructions in it.

If you have installed the hack, then you need to follow the instructions in the first post in this thread to upgrade.

of course, i've already made the necessary changes, as you state. :)


also run mysqlnew.php

but i still have this little prob..

No way....

i can't find why the script doesn't update user sign if a user is virgo.. it resets the field in the "sign" column.

No error, it simply ignores it.

This applies to all users..

Any clue, tube?

I have no idea, marl. At least it reads all the other signs right...I went through a period during testing where it would pick signs at random! So who knows. I'm still not quite sure exactly how it works...j/k. I'm sorry, I have no idea.

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 ;)

[almighty one]

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)

[almighty one]

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.

[almighty one]

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.

[tubedogg]

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

[Balbanes]

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_birthdayfield")."\");");
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

[webhost]

Tubedogg,
I had a member on the board that was a virgo, sign not showing up. I went to my mysql database in went to his sign field and typed in virgo for his sign and went back and looked at his profile and it is now showing up, so somehow the virgo sign info, is not getting sent to the database.

Joey

[webhost]

Can you help me? I am still working on this zodaic hack from hell thing, now having trouble with the register.php file which is keeping people from registering on my board. here is the problem area.
1- getbirthdays();
2- }
3- }
4- else
5- $birthday = 0;
6- }

Problem is on line number 4 above getting parse error on this line

Joey

[ztsky]

tubedogg:
I download the neweset hack zip and done everything,but
Parse error: parse error in /home/realweb/public_html/forums/member.php on line 423

why?
I think it's a bug here.

[webhost]

ztsky



use this in your member.php instead had the same problem this week end. Register.php fix at the bottom. Only Bug I still have is virgo sign not showing up. I am working on that.
=========member.php--------------

// Birthday Stuff...
if ($calbirthday == 1) {
if ( ($day == -1 and $month != -1) or ($day !=-1 and $month == -1) ) {
eval("standarderror(\"".gettemplate("error_birthdayfield")."\");");
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 > 20 and $month == 03) xor ($day < 20 and $month == 04)) { $sign = "aries"; }
elesif (($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;}

-------register.php---------------

// Birthday Stuff...
if ($calbirthday == 1) {
if ( ($day == -1 and $month != -1) or ($day !=-1 and $month == -1) ) {
eval("standarderror(\"".gettemplate("error_birthdayfield")."\");");
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 > 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 = 0;}


if ($showbirthdays) {

Joey

[snyx]

what versions are you all using this on?

[webhost]

vb2.0.1

[snyx]

and it works for you?

[webhost]

Only probelm I have is the virgo gif will not show up but I am working on that now. But if you look back a couple of posts you will see that I had to change some script to make it work.

Joey

[snyx]

I see, I see, plus I reg. and my picses sign didnt come up, check, we had the same problem running it on tha beta.

[webhost]

I looked when you registered on my board and you did have a
picses sign by your birthday
Joey

[snyx]

LOL! Your right it works, but ya see, THIS is the pisces sign http://forums.realwebhost.net/images/sign/cancer.gif

[snyx]

plus inform me when ya get that virgo sign working

[webhost]

Corrected below

Joey

[webhost]

Did you get the rest of the hack working? I was able to go into my database table and insert virgo and it showed up on the board. I 'll let you know when I have it working.

Joey

[webhost]

Snyx go here and look at the symbol for Pisces. I believe it matchs what I have.
Look on the left side torwards the top. Here is the link.
http://www.astrology.com/

Joey

[snyx]

I stand corrected. I made the icons too, I really should know. LOL, anyways did you ever get the hack 100% working? (sorry if im slow)

[webhost]

This is the latest I have done with this hack, with the help of tubedogg I have all working except the virgo sign, it still will not show up. I am using vb 2.0.1

Joey

[daydreamer]

Hello all,

I am getting:

Parse error: parse error in /home2/kicks/gardenkicks-www/member.php on line 426

Any ideas? Thanks

[webhost]

Which file did you use? If you used mind the one right above your post send me your member.php file and I will look at it. If you did not download my zip and compare the changes I made to the ones you made.

[daydreamer]

I used the one just above...

How do I send it to you?

Thanks

[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?

[Matt*is*thick]

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?

[AJR]

Here's the code I replaced. There was one line I couldn't place that was supposed to go in admin/functions:

$templatesused .= ",postbit_sign";

But it seems to work fine without it!

[tkhjosh]

Parse error: parse error in /home/httpd/www/forums/member.php on line 438

[AJR]

Make sure the // Birthday Stuff looks like this:

// Birthday Stuff...
if ($calbirthday == 1) {
if ( ($day == -1 and $month != -1) or ($day !=-1 and $month == -1) ) {
eval("standarderror(\"".gettemplate("error_birthdayfield")."\");");
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;
}



After the last } the script should continue with the following line:
if ($verifyemail and $email!=$bbuserinfo['email'] and $bbuserinfo['usergroupid']==2) {

[tkhjosh]

yup i got that right

[tkhjosh]

Parse error: parse error in /home/tcclan/www/forums/member.php on line 1213

now i get this

[TheComputerGuy]

Anyword or any ideas on some of the changes for 2.2.1 cause that would be so awesome if it would work...