get.php 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788
  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"]) || !isset($_COOKIE["user_uid"])){
  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,type FROM "._TABLE_CHANNEL_." WHERE owner_uid = ? order by updated_at DESC LIMIT 200";
  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(
  33. "uid"=>$value["uid"],
  34. "owner_uid"=>$value["owner_uid"],
  35. "name"=>$value["name"],
  36. "power"=>30,
  37. "type"=>$value["type"],
  38. "status"=>$value["status"],
  39. "lang"=>$value["lang"]
  40. );
  41. }
  42. # 找协作的
  43. $coop_channal = share_res_list_get($_COOKIE["user_uid"],2);
  44. foreach ($coop_channal as $key => $value) {
  45. # return res_id,res_type,power res_title res_owner_id
  46. if(isset($channelList[$value["res_id"]])){
  47. if($channelList[$value["res_id"]]["power"]<(int)$value["power"]){
  48. $channelList[$value["res_id"]]["power"]=(int)$value["power"];
  49. }
  50. }
  51. else{
  52. $channelList[$value["res_id"]]=array(
  53. "uid"=>$value["res_id"],
  54. "owner_uid"=>$value["res_owner_id"],
  55. "name"=>$value["res_title"],
  56. "power"=>(int)$value["power"],
  57. "type"=>(int)$value["type"],
  58. "status"=>(int)$value["status"],
  59. "lang"=>(int)$value["lang"]
  60. );
  61. }
  62. }
  63. $_userinfo = new UserInfo();
  64. $output = array();
  65. foreach ($channelList as $key => $value) {
  66. # code...
  67. $new = $value;
  68. $name = $_userinfo->getName($value["owner_uid"]);
  69. $new["username"] = $name["username"];
  70. $new["nickname"] = $name["nickname"];
  71. $new["count"] = 0;
  72. $new["all"] = 1;
  73. $new["owner"] = $value["owner_uid"];
  74. $output[]=$new;
  75. }
  76. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  77. ?>