get.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172
  1. <?php
  2. //
  3. require_once "../config.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../ucenter/function.php';
  6. require_once '../share/function.php';
  7. if(!isset($_COOKIE["userid"])){
  8. echo json_encode(array(), JSON_UNESCAPED_UNICODE);
  9. exit;
  10. }
  11. /*
  12. # 找我加入的群
  13. PDO_Connect(""._FILE_DB_GROUP_);
  14. $query = "SELECT group_id from group_member where user_id = ? limit 0,100";
  15. $my_group = PDO_FetchAll($query,array($_COOKIE["userid"]));
  16. $userList = array();
  17. $userList[] = $_COOKIE["userid"];
  18. foreach ($my_group as $key => $value) {
  19. # code...
  20. $userList[]=$value["group_id"];
  21. }
  22. */
  23. #查重复
  24. $channelList = array();
  25. //找自己的
  26. PDO_Connect(_FILE_DB_CHANNAL_,_DB_USERNAME_,_DB_PASSWORD_);
  27. $query = "SELECT uid,owner_uid,name,status,lang FROM "._TABLE_CHANNEL_." WHERE owner_uid = ? LIMIT 100";
  28. $Fetch_my = PDO_FetchAll($query,array($_COOKIE["user_uid"]));
  29. #去掉重复的
  30. foreach ($Fetch_my as $key => $value) {
  31. # code...
  32. $channelList[$value["uid"]]=array("uid"=>$value["uid"],"owner_uid"=>$value["owner_uid"],"name"=>$value["name"],"power"=>30,"status"=>$value["status"],"lang"=>$value["lang"]);
  33. }
  34. # 找协作的
  35. $coop_channal = share_res_list_get($_COOKIE["user_uid"],2);
  36. foreach ($coop_channal as $key => $value) {
  37. # return res_id,res_type,power res_title res_owner_id
  38. if(isset($channelList[$value["res_id"]])){
  39. if($channelList[$value["res_id"]]["power"]<(int)$value["power"]){
  40. $channelList[$value["res_id"]]["power"]=(int)$value["power"];
  41. }
  42. }
  43. else{
  44. $channelList[$value["res_id"]]=array("uid"=>$value["res_id"],"owner_uid"=>$value["res_owner_id"],"name"=>$value["res_title"],"power"=>(int)$value["power"],"status"=>(int)$value["status"],"lang"=>(int)$value["lang"]);
  45. }
  46. }
  47. $_userinfo = new UserInfo();
  48. $output = array();
  49. foreach ($channelList as $key => $value) {
  50. # code...
  51. $new = $value;
  52. $name = $_userinfo->getName($value["owner_uid"]);
  53. $new["username"] = $name["username"];
  54. $new["nickname"] = $name["nickname"];
  55. $new["count"] = 0;
  56. $new["all"] = 1;
  57. $new["owner"] = $value["owner_uid"];
  58. $output[]=$new;
  59. }
  60. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  61. ?>