This is not a big mod, but i want to sharing with you,hopefully helps somebody and if somebody give me suggestions to better this. This is a block that i had made with deanos tool to show users with Birthdays.
this is the PHP code:
$oDb = new BxDolDb();
$sSQLQuery = "SELECT * FROM `Profiles` WHERE MONTH(`DateOfBirth`) = MONTH(CURDATE()) AND DAY(`DateOfBirth`) = DAY(CURDATE())";
$sProfile= $oDb->getColumn($sSQLQuery);
echo'<div style="width: 275px;height:160px; overflow: auto; padding: 15px">';
for($i=0;$i<count($sProfile);$i++){
$iId = $sProfile[$i];
$name=getNickName($iId);
$Thumbnail = get_member_thumbnail($iId, 'none');
echo'<link rel="stylesheet" href="http://Mysite.com/social/templates/base/css/general.css" type="text/css" media="screen" />';
echo "<div><table class='tabla'><tr><td>$Thumbnail</td><td><p>Happy Birthday $name</p></td></tr></table></div>";
}
echo'</div>';
CSS code on general.css:
.tabla{
background: #fff6bf url(../images/icons/bx_ecards.png) center no-repeat;
background-position: 15px 50%; /* x-pos y-pos */
text-align: left;
padding: 5px 20px 5px 45px;
border-top: 2px solid #ffd324;
border-bottom: 2px solid #ffd324;
color:#000000;
}
.tabla p:hover {
border: 1px solid #333333;
background-color: #9DA0A1;
}
This is simple. How i can better this? I working on it. I hope any suggestion.
regards