448 lines
7.0 KiB
PHP
448 lines
7.0 KiB
PHP
|
|
<?php header('Content-type: application/json');
|
||
|
|
|
||
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/cmeter/');
|
||
|
|
|
||
|
|
include(PATHTOINCLUDES."base.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}" ) );
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$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=$database->database_query($sql) or $em=$em.$database->database_error();
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$sql2="SELECT count(`community_wall`.`wid`) AS cwid FROM `community_wall` ORDER BY
|
||
|
|
|
||
|
|
`community_wall`.`datecreated` DESC LIMIT 100 OFFSET 0";
|
||
|
|
|
||
|
|
$rcount=$database->database_query($sql2);
|
||
|
|
|
||
|
|
$thecount = $database->database_result($rcount,0);
|
||
|
|
|
||
|
|
$thecount = 100;
|
||
|
|
|
||
|
|
$database->database_free_result($rcount);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$rownum=0;
|
||
|
|
|
||
|
|
$thewall="";
|
||
|
|
|
||
|
|
while ($row = $database->database_fetch_assoc($result)) {
|
||
|
|
|
||
|
|
$rownum=$rownum+1;
|
||
|
|
|
||
|
|
if($rownum % 2 != 0){$rc="#333";} else{$rc="#000";}
|
||
|
|
|
||
|
|
$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='<div class="wall-msg firstrow" id="wall_post_0">
|
||
|
|
|
||
|
|
<div class="wall-msg-pad">
|
||
|
|
|
||
|
|
<a href="http://bateworld.com/profile.php?user='.stripslashes($row['displayname']).'" target="_community"><img src="'.$uimage.'" width="50" /></a>
|
||
|
|
|
||
|
|
<div>
|
||
|
|
|
||
|
|
<span class="from_msg">Posted by <a href="http://bateworld.com/profile.php?user="'.stripslashes($row["displayname"]).'" target="_community">'.stripslashes($row["displayname"]).'</a></span>
|
||
|
|
|
||
|
|
<span class="date_msg">Most Recent Post '.$ug.'</span>
|
||
|
|
|
||
|
|
<div class="wall-clear-right"> </div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="wmsg">'.stripslashes($row["msg"]).'</div>
|
||
|
|
|
||
|
|
<div class="wall-clear"> </div>
|
||
|
|
|
||
|
|
</div>';
|
||
|
|
|
||
|
|
if(isset($_SESSION["cp_userid"])){
|
||
|
|
|
||
|
|
if($_SESSION["cp_userid"]==21092 || $_SESSION["cp_userid"]==7653 || $_SESSION["cp_userid"]==6286 || $_SESSION["cp_userid"]==8 || $_SESSION["cp_userid"]==58188){
|
||
|
|
|
||
|
|
$firstrow=$firstrow.'<input type="button" value="D" class="bl_delbutton" onclick="del_wall_post(\''.$row["wid"].'\',\'0\')" />';
|
||
|
|
|
||
|
|
}}
|
||
|
|
|
||
|
|
$firstrow=$firstrow."</div>";
|
||
|
|
|
||
|
|
$wid=$row["wid"];
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
else {
|
||
|
|
|
||
|
|
$thewall=$thewall.'<div class="wall-msg" id="wall_post_'.$rownum.'" style="background:'.$rc.';">
|
||
|
|
|
||
|
|
<div class="wall-msg-pad">
|
||
|
|
|
||
|
|
<a href="http://bateworld.com/profile.php?user='.stripslashes($row['displayname']).'" target="_community"><img src="'.$uimage.'" width="50" /></a>
|
||
|
|
|
||
|
|
<div>
|
||
|
|
|
||
|
|
<span class="from_msg">Posted by <a href="http://bateworld.com/profile.php?user='.stripslashes($row['displayname']).'" target="_community">'.stripslashes($row['displayname']).'</a></span>
|
||
|
|
|
||
|
|
<span class="date_msg">'.$ug.'</span>
|
||
|
|
|
||
|
|
<div class="wall-clear-right"> </div>
|
||
|
|
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="wmsg">'.stripslashes($row['msg']).'</div>
|
||
|
|
|
||
|
|
<div class="wall-clear"> </div>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
</div>';
|
||
|
|
|
||
|
|
if(isset($_SESSION["cp_userid"])){
|
||
|
|
|
||
|
|
if($_SESSION["cp_userid"]==21092 || $_SESSION["cp_userid"]==7653 || $_SESSION["cp_userid"]==6286 || $_SESSION["cp_userid"]==8){
|
||
|
|
|
||
|
|
$thewall=$thewall."<input type=\"button\" value=\"D\" class=\"bl_delbutton\" onclick=\"del_wall_post('".$row["wid"]."','0')\" />";
|
||
|
|
|
||
|
|
$thewall=$thewall."<input type=\"button\" value=\"E\" class=\"bl_delbutton\" onclick=\"edit_wall_post('".$row["wid"]."','0')\" />";
|
||
|
|
|
||
|
|
}}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$thewall=$thewall."</div>";
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
if($offset==""){$offset=0;}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
$limit=4;
|
||
|
|
|
||
|
|
$container="wall_posts";
|
||
|
|
|
||
|
|
$page_url="/js/act/wall_rs_act.php";
|
||
|
|
|
||
|
|
$navaid=recordsetNav($thecount,$page_url,$container,$offset,$limit,1);
|
||
|
|
|
||
|
|
$navaid="<div id=\"navaid\" style=\"\">".$navaid."</div>";
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
if($thecount > 5)
|
||
|
|
|
||
|
|
{
|
||
|
|
|
||
|
|
$thewall=$thewall.$navaid;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
$arr = array ('error' => $em, 'firstrow'=> $firstrow, 'thewall'=> $thewall, 'wid'=> $wid);
|
||
|
|
|
||
|
|
echo json_encode($arr);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
?>
|
||
|
|
|