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

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

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

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

Hmm...try again. I changed it.

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"; }

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

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

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