showing by birthday date

[laskos]

hi
can anyway tell me a way where i can display images on my fornt page by birth date ? for example when people  upload there images in the front page it will disply say 5 members whos birthday is today ??

[Nibbler]

Do you already have the birthday information in the database ?

[havoc615]

Or do you have it bridged with a forum?

[laskos]

hi
i already have a database at the moment as i am using a ecard script. what i am looking for is to install the coppermine gallery to use this members database and then when people sign up on the site it will also allow them to post on the gallery.

[havoc615]

Lol well thats slightly more complex then just the birthday thing I doubt it, but do you happen to have a sessions table setup?

We might be able to work it another way too.

Ok I think this might work 

Open up include/init.inc.php and find

Code Select Expand

$CONFIG['TABLE_USERS']                = $CONFIG['TABLE_PREFIX']."users";
Now...your gonna want to make a user_lastvisit and user_active column in your members table, actaully the best thing you could do would be to match the column names of coppermine and your thing, if you have additional fields thats ok. So long as the structre of the Coppermine users is the same as yours. Then you can tweak this little column to be.

Code Select Expand


$CONFIG['TABLE_USERS']                = "Your DB"."Your User Table";


Now I HIGHLY DOUBT, that this will work unless you match the fields to coppermine. Once you do that, we can add birthday stuff, etc. anything you'd want done with those auxillary columns.