fork download
copy 
  1. <?php
  2.  
  3.   include_once('header.php');
  4.   if(headers_sent()) die('Should not output data before json');
  5.   if(!isset($_SESSION['userid'])){
  6.     header('Content-type: application/json');
  7.     echo '{"success":"true","reirect":"1"}';
  8.     exit();
  9.   }
  10.   @ob_clean();
  11.   ob_start();
  12.  
  13.   $table=PREFIX.'connections';
  14.   $where="friend_id=".cleaninputfield($_SESSION['userid'])." AND status=0";
  15.   $friends=$db->count_records($table,$where);
  16.  
  17.   $table=PREFIX."users urs INNER JOIN ".PREFIX."club_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."clubs cb ON cb.id=perm.club_id ";
  18.   $where="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";
  19.   $records=$db->count_records($table,$where);
  20.  
  21.   $tables=PREFIX."users urs  INNER JOIN ".PREFIX."clubs cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."club_permissions perm ON cb.id=perm.club_id ";
  22.   $wheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  23.   $record=$db->count_records($tables,$wheres);
  24.  
  25. /*$grouptable=PREFIX."users urs INNER JOIN ".PREFIX."group_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."groups cb ON cb.id=perm.group_id ";
  26.   $groupwhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";*/
  27.  
  28.   $grouptable=PREFIX."users urs INNER JOIN ".PREFIX."group_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."groups cb ON cb.id=perm.group_id ";
  29.   $groupwhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";
  30.  
  31.   $grouprecords=$db->count_records($grouptable,$groupwhere,array('range'=>'distinct perm.id'));
  32.  
  33. /*$grouptables=PREFIX."users urs  INNER JOIN ".PREFIX."groups cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."group_permissions perm ON cb.id=perm.group_id ";
  34.   $groupwheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";*/
  35.  
  36.   $grouptables=PREFIX."users urs  INNER JOIN ".PREFIX."groups cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."group_permissions perm ON cb.id=perm.group_id ";
  37.   $groupwheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  38.   $grouprecord=$db->count_records($grouptables,$groupwheres);
  39.  
  40.   $tables=PREFIX."notifications";
  41.   $wheres="user_id=".cleaninputfield($_SESSION['userid'])." AND seen=0";
  42.   $notifications=$db->count_records($tables,$wheres);
  43.  
  44.   $table=PREFIX."events_invite invites INNER JOIN ".PREFIX."events eve ON invites.event_id=eve.id INNER JOIN ".PREFIX."schedules sch ON sch.id=eve.sch_id";
  45.   $wheres="invites.invitee=".cleaninputfield($_SESSION['userid'])." AND invites.status=0";
  46.   $events=$db->count_records($table,$wheres);
  47.  
  48.   $companytable=PREFIX."users urs INNER JOIN ".PREFIX."comp_permissions perm ON urs.id=perm.user_id INNER JOIN ".PREFIX."companies cb ON cb.id=perm.comp_id ";
  49.   $companywhere="cb.created_by=".cleaninputfield($_SESSION['userid'])." AND perm.status=0";
  50.   $companyrecords=$db->count_records($companytable,$companywhere);
  51.  
  52.  
  53.  
  54.   $companytables=PREFIX."users urs  INNER JOIN ".PREFIX."companies cb ON cb.created_by=urs.id INNER JOIN ".PREFIX."comp_permissions perm ON cb.id=perm.comp_id ";
  55.   $companywheres="perm.user_id=".cleaninputfield($_SESSION['userid'])." AND perm.status=1";
  56.   $companyrecord=$db->count_records($companytables,$companywheres);
  57.  
  58.  
  59.   $jsonResponse = new stdClass();
  60.   $jsonResponse->success = true;
  61.   $jsonResponse->friends = $record+$records+$friends+$events+$grouprecord+$grouprecords+$companyrecords+$companyrecord;
  62.   $jsonResponse->notifications = $notifications;
  63.   $jsonResponse->messages = 0;
  64.   $jsonResponse->reirect = 0;
  65.  
  66.   ob_end_clean();
  67.   header('Content-type: application/json');
  68.   echo json_encode($jsonResponse);
  69.   exit; 
  70.  
  71. ?>
Not running #stdin #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/h0yiNp
language:
PHP (php 7.3.5)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!