user_info['user_id']; $_SESSION["pagename"]="Community Page"; $_SESSION["nickname"]=$user->user_info['user_username']; $_SESSION["blocklist"]=$user->user_info['user_blocklist']; $_SESSION["invisible"]=$user->user_info['user_invisible']; $_SESSION["userphoto"]=$user->user_photo("./images/nophoto.png",true); $_SESSION["cp_useremail"]=$user->user_info['user_email']; $_SESSION["cp_userlevel"]=$user->user_info['user_level_id']; //if(!isset($_SESSION["newvisit"])) // { include(PATHTOINCLUDES."setstate2.php"); // } include(PATHTOINCLUDES."recordset.php"); date_default_timezone_set('America/Phoenix'); function get_timespan_string($older, $newer) { $Y1 = $older->format('Y'); $Y2 = $newer->format('Y'); $Y = $Y2 - $Y1; $m1 = $older->format('m'); $m2 = $newer->format('m'); $m = $m2 - $m1; $d1 = $older->format('d'); $d2 = $newer->format('d'); $d = $d2 - $d1; $H1 = $older->format('H'); $H2 = $newer->format('H'); $H = $H2 - $H1; $i1 = $older->format('i'); $i2 = $newer->format('i'); $i = $i2 - $i1; $s1 = $older->format('s'); $s2 = $newer->format('s'); $s = $s2 - $s1; if($s < 0) { $i = $i -1; $s = $s + 60; } if($i < 0) { $H = $H - 1; $i = $i + 60; } if($H < 0) { $d = $d - 1; $H = $H + 24; } if($d < 0) { $m = $m - 1; $d = $d + get_days_for_previous_month($m2, $Y2); } if($m < 0) { $Y = $Y - 1; $m = $m + 12; } $timespan_string = create_timespan_string($Y, $m, $d, $H, $i, $s); return $timespan_string; } function get_days_for_previous_month($current_month, $current_year) { $previous_month = $current_month - 1; if($current_month == 1) { $current_year = $current_year - 1; //going from January to previous December $previous_month = 12; } if($previous_month == 11 || $previous_month == 9 || $previous_month == 6 || $previous_month == 4) { return 30; } else if($previous_month == 2) { if(($current_year % 4) == 0) { //remainder 0 for leap years return 29; } else { return 28; } } else { return 31; } } function create_timespan_string($Y, $m, $d, $H, $i, $s) { $timespan_string = ''; $found_first_diff = false; if($Y >= 1) { $found_first_diff = true; $timespan_string .= pluralize($Y, 'Y').' '; } if($m >= 1 || $found_first_diff) { $found_first_diff = true; $timespan_string .= pluralize($m, 'M').' '; } if($d >= 1 || $found_first_diff) { $found_first_diff = true; $timespan_string .= pluralize($d, 'D').' '; } if($H >= 1 || $found_first_diff) { $found_first_diff = true; $timespan_string .= pluralize($H, 'H').' '; } if($i >= 1 || $found_first_diff) { $found_first_diff = true; // $timespan_string .= pluralize($i, 'minute').' '; } if($found_first_diff) { //$timespan_string .= 'and '; } //$timespan_string .= pluralize($s, 'second'); return $timespan_string; } function pluralize( $count, $text ) { return $count . ( ( $count == 1 ) ? ( "$text" ) : ( "${text}" ) ); } $wid=0; $sql="SELECT `community_wall`.`wid`, `community_wall`.`userid`, `community_wall`.`msg`, `community_wall`.`datecreated`, `community_wall`.`displayname`, `community_wall`.`photo`, `se_users`.`user_enabled` FROM `community_wall` Left Outer Join `se_users` ON `se_users`.`user_id` = `community_wall`.`userid` WHERE `se_users`.`user_enabled` = 1 ORDER BY `community_wall`.`datecreated` DESC LIMIT 5 OFFSET 0"; $result=mysql_query($sql) or $em=$em.mysql_error(); $sql2="SELECT count(`community_wall`.`wid`) AS cwid FROM `community_wall` ORDER BY `community_wall`.`datecreated` DESC LIMIT 100 OFFSET 0"; $rcount=mysql_query($sql2); $thecount = mysql_result($rcount,0); mysql_free_result($rcount); $rownum=0; $thewall=""; while ($row = mysql_fetch_assoc($result)) { $rownum=$rownum+1; if($rownum % 2 != 0){$rc="#000";} else{$rc="#333";} $number = (((int)($row['userid']/1000))*1000)+1000; if($row['photo']=="") { $uimage="/images/nophoto.png"; } else { $uimage="/uploads_user/".$number."/".$row['userid']."/".$row['photo']; } $now = time(); $dc=$row['datecreated']; $cdate = $dc; $ndate = date('Y-m-d H:i:s',$now); $datetime1 = date_create($dc); $datetime2 = date_create($ndate); $ug=get_timespan_string($datetime1, $datetime2); if($ug==""){$ug="< 1H";} if($rownum==1) { $firstrow="