Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = 'localhost';
- $dbuser = 'godcraft_xen';
- $dbpass = 'xxxxxxxxx';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- $dbname = 'godcraft_xen';
- mysql_select_db($dbname);
- $q = mysql_query('SELECT u.username as username, up.user_upgrade_id as group_id
- FROM xf_user u, xf_user_upgrade_active up
- WHERE up.user_id = u.user_id
- AND (up.user_upgrade_id = 3 OR up.user_upgrade_id = 4 OR up.user_upgrade_id = 5)
- ORDER BY u.username asc') or die(mysql_error());
- $q2 = mysql_query('SELECT u.username AS username FROM xf_user u, xf_user_upgrade_active up WHERE up.user_id = u.user_id AND up.user_upgrade_id = 2') or die(mysql_error());
- $excludedPeople = array("sniper3","sounas")
- while($row2 = mysql_fetch_array($q2))
- {
- $name = strtolower($row2['username']);
- $canWrite = 1;
- for ($i = 0; $i < (count($excludedPeople))-1; $i++) {
- if($name == $excludedPeople[$i]){
- $canWrite = 0;
- break;
- }
- }
- if($canWrite == 1){
- $names .= " $name:<br /> group:<br /> permissions:<br /> - stargate.world.pvpworld<br />";
- }
- }
- while($row = mysql_fetch_array($q))
- {
- $name = strtolower($row['username']);
- $canWrite = 1;
- for ($i = 0; $i < count($excludedPeople); $i++) {
- if($name == $excludedPeople[$i]){
- $canWrite = 0;
- break;
- }
- }
- if($canWrite == 1){
- $group_id = $row['group_id'];
- if($group_id == 3) $group = "VIP1";
- else if($group_id == 4) $group = "VIP2";
- else if($group_id == 5) $group = "VIP3";
- if($group){
- $names .= " $name:<br /> group: $group<br /> permissions:<br />";
- $q2 = mysql_query("SELECT u.username AS username FROM xf_user u, xf_user_upgrade_active up WHERE up.user_id = u.user_id AND username = '$name' AND up.user_upgrade_id = 2") or die(mysql_error());
- if(mysql_num_rows($q2) > 0){
- $names .= " - stargate.world.pvpworld<br />";
- }
- }
- }
- }
- echo $names;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement