[DONE1.5 for 1.5.4] Zodiac Signs Mod1.5

[Aquilo]

Ok I finaly got this thing done...

I thought I was in for it tonight when I noticed that this
mod didn't like Capricorn's
well not to bad I worked around it!

anywho this will display the users Zodiac Sign under there age and there Zodiac Sign Image under the userpic/text in Profile.php

new in version BETA 1.5 the users zodiac sign is now kept in there member profile database and is updated when the user updates there birthdate.
also a new script was added to auto link every users zodiac sign to there birthdate to make this mod seamless and not necessary for them to update there profile to set there zodiac sign.

if you have 1.0 installed you need to first uninstall and then install 1.5 because just about everything has changed with this mod, however you can leave the current zodiac_db and run the new one over it - this will give you errors telling you that everything it duplicated but at the end is where the alter query is to make db_prefix_members.zodiac


You can see a working example Here

hopfully with input this may be usefull/expand to more then just the user profiles page!

Download link for 1.5


[/edit]

[1979Z28]

Code Select Expand


yabbse_calendar_zodiac Instalation Utility
Connecting to the database....
Error Creating yabbse_calendar_zodiac Table. SQL Error: You have an error in your SQL syntax near '; ' at line 3
Inserting yabbse_calendar_zodiac Data...
Error Adding Aries data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Taurus data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Gemini data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Cancer data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Leo data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Virgo data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Libra data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Scorpio data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Sagittarius data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Capricorn data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Aquarius data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Error Adding Pisces data toyabbse_calendar_zodiac Database. SQL Error: Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
Data was not successfully added to yabbse_calendar_zodiac Database!

13 errors accured to yabbse_calendar_zodiac Database instalation!


Uh.. looks like there's a typo in the dbmod file..

[Aquilo]

  I just tested it!

I'll look at it real quick!

[1979Z28]

Okie. I'll be waiting Can't wait until I can get this to work, I've been wanting this for a while!

[Aquilo]

Connecting to the database....
xcalendar_zodiac Table created!
Inserting xcalendar_zodiac Data...
Aries data successfully added!
Taurus data successfully added!
Gemini data successfully added!
Cancer data successfully added!
Leo data successfully added!
Virgo data successfully added!
Libra data successfully added!
Scorpio data successfully added!
Sagittarius data successfully added!
Capricorn data successfully added!
Aquarius data successfully added!
Pisces data successfully added!
All Data successfully added toxcalendar_zodiac Database!

I've tryed with a prefix and with out and it's ok!
can you post the few lines after:
/* Creating {$db_prefix}calendar_zodiac Table */
to see if they look like:

Code Select Expand


$sql1 = mysql_query("CREATE TABLE {$db_prefix}calendar_zodiac (id int(10) NOT NULL auto_increment, SIGN char(15) NOT NULL default '',
sMO tinyint(3) NOT NULL default '0', sDA tinyint(3) NOT NULL default '0', eMO tinyint(3) NOT NULL default '0',
eDA tinyint(3) NOT NULL default '0', PRIMARY KEY  (id), KEY SIGN (SIGN)) TYPE = MyISAM COMMENT = 'Zodiac Signs YaBBSE 1.5.3 version, By Aquilo.us'; ");


duh I could just download it!

[1979Z28]

Code Select Expand


$sql1 = mysql_query("CREATE TABLE {$db_prefix}calendar_zodiac (id int(10) NOT NULL auto_increment, SIGN char(15) NOT NULL default '',
sMO tinyint(3) NOT NULL default '0', sDA tinyint(3) NOT NULL default '0', eMO tinyint(3) NOT NULL default '0',
eDA tinyint(3) NOT NULL default '0', PRIMARY KEY  (id), KEY SIGN (SIGN)) TYPE = MyISAM COMMENT = 'Zodiac Signs YaBBSE 1.5.3 version, By Aquilo.us'; ");


[1979Z28]

Neh, lemme re-download it and try it again. Gimme a sec.

EDIT:

Downloaded it again, uploaded it to the directory with my settings.php, and I still get the same errors.

My database name is: ufbaforum
Tables Prefix is: yabbse_

Wonder if that's what some of the problem is.. hrm

[Aquilo]

I removed the hyphen and it still works so that may have fixed it.

I ziped up an update for the database file so you don't have to download the hole thing

zodiac_db_update.zip

Aquilo

[1979Z28]

Ok, that db change fixed the problem.. but now I think that same change needs to be applied to the rest of the mod, because I got this error in Profile.php, when i tried to view someone's profile.

Code Select Expand


Table 'ufbaforum.yabbse_calendar_zodiac' doesn't exist
File: /usr/local/etc/httpd/vhosts/ufba.org/forum/Sources/Profile.php
Line: 921


[Aquilo]

redownload the update I left my $db_prefix="y"; line in there in a hury and that's what is meessing it up!

Sorry

[1979Z28]

Edit:

Ok, I got it all fixed now. Removed that line you were talking about in the above post, and reapplied the dbmod, and it works now.

Sweetness!  Cool mod. Thanks for the help too

[Aquilo]

No problem! sorry it was a headacke to start with!

If you have phpmyadmin I'd go in and remove the table
that don't look right "the one with a y someplace"!

Aquilo

[1979Z28]

I'll have my assistant webmaster do it. I'm too lazy

[Aquilo]

1979Z28 quick question? I just noticed GhostZ's profile and is age is there but not the zodiac could you pm or post here the birth date he has. I had thought I tested every Capricorn date to see that it worked and am woundering where the problem date is!

Aquilo

[edit]
I think I figured it out you don't have to put months and days  in your birth date to get your age this year. eg: 00/00/1975 = 28

[1979Z28]

lol, yea. I noticed that when his wasn't showing. If somebody doesn't have the month/day they were born, it won't show a zodiac sign. Guess I shoulda posted here with that earlier, Ah well. It works