Guest User

Untitled

a guest
May 26th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. id | signature
  2. 1 | 1
  3. 2 | 1
  4. 3 | 1
  5.  
  6. id | support_id | admin_file_id
  7. 1 | 2 | 1
  8. 2 | 2 | 2
  9. 3 | 2 | 3
  10.  
  11. function signature($id){
  12. global $connection;
  13. $query = "SELECT COUNT(*) as kol FROM admin_files WHERE signature = 1 ";
  14. $res = mysqli_query($connection, $query);
  15. $row = mysqli_fetch_assoc($res);
  16. $kol = $row["kol"];
  17. $query = "SELECT a.* FROM admin_files a JOIN support_files s ON s.admin_file_id = a.id WHERE a.signature= 1 AND s.support_id='$id'";
  18. $res = mysqli_query($connection, $query);
  19. if(mysqli_num_rows($res) == $kol){
  20. return;
  21. }else{
  22. $query = "SELECT a.* FROM admin_files a JOIN support_files s ON s.admin_file_id != a.id WHERE a.signature= 1 AND s.support_id='$id'";
  23. $res = mysqli_query($connection, $query);
  24. if(mysqli_num_rows($res) > 0){
  25. $signature = array();
  26. while($row = mysqli_fetch_assoc($res)){
  27. $signature[$row['id']] = $row;
  28. }
  29. return $signature;
  30. }else{
  31. $query = "SELECT * FROM admin_files WHERE signature = 1 ORDER BY id DESC ";
  32. $res = mysqli_query($connection, $query);
  33. $signature = array();
  34. while($row = mysqli_fetch_assoc($res)){
  35. $signature[$row['id']] = $row;
  36. }
  37. return $signature;
  38. }
  39. }
  40. }
Add Comment
Please, Sign In to add comment