Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.22 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost';
  3. $dbuser = 'xxxxxxxx';
  4. $dbpass = 'xxxxxxxx';
  5. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  6. $dbname = 'godcraft_site';
  7. mysql_select_db($dbname);
  8. $q = mysql_query('SELECT u.username as username, up.user_upgrade_id as group_id
  9. FROM xf_user u, xf_user_upgrade_active up
  10. WHERE up.user_id = u.user_id
  11. AND (up.user_upgrade_id = 3 OR up.user_upgrade_id = 4 OR up.user_upgrade_id = 5 OR up.user_upgrade_id = 2 OR up.user_upgrade_id = 6)
  12. ORDER BY u.username asc') or die(mysql_error());
  13. $excludedPeople = array("kane_hart","cypher_code","sniper3","confuzzledyma","zach00123","quizzbee","sounas","madcat1030","bodydrag","electrobot4");
  14. $groupUsers = array();
  15. $groupNameIndex = array();
  16. while($row2 = mysql_fetch_array($q)){
  17. $name = strtolower($row2['username']);
  18. $canWrite = 1;
  19. $existingEntry = 0;
  20. for ($i = 0; $i < (count($excludedPeople)); $i++) {
  21. if($name == $excludedPeople[$i]){
  22. $canWrite = 0;
  23. break;
  24. }
  25. }
  26. for($i = 0; $i < (count($groupNameIndex)); $i++){
  27. if($groupNameIndex[$i] == $name){
  28. $existingEntry = 1;
  29. break;
  30. }
  31. }
  32. if($existingEntry == 0 && $canWrite == 1){
  33. $groupNameIndex[count($groupNameIndex)+1] = $name;
  34. }
  35. if($canWrite == 1){
  36. $group_id = $row2['group_id'];
  37. $groupUsers[$name] .= ",".$group_id;
  38. }
  39. }
  40. echo count($groupNameIndex)."&nbsp".count($groupUsers);
  41. for($i = 0; $i < count($groupUsers); $i++){
  42. if(strstr($groupUsers[$groupNameIndex[$i]],"5")){
  43. $group = "VIP3";
  44. }else if(strstr($groupUsers[$groupNameIndex[$i]],"4")){
  45. $group = "VIP2";
  46. }else if(strstr($groupUsers[$groupNameIndex[$i]],"3")){
  47. $group = "VIP1";
  48. }
  49. echo "&nbsp;&nbsp;&nbsp;&nbsp;$groupNameIndex[$i]:</br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;groups:<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- $group<br/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;permissions:<br/>";
  50. if(strstr($groupUsers[$groupNameIndex[$i]],"2") || $group == "VIP3"){
  51. echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- stargate.network.PVP-NET<br />";
  52. }
  53. if(strstr($groupUsers[$groupNameIndex[$i]],"6") || $group == "VIP3"){
  54. echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;- stargate.network.Nether<br />";
  55. }
  56.  
  57. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement