[DEV] SyncCMS

<?php


class Community
{
  public $err = '';
  public $success = false;
  public $result = '';
  private $imager;
  private $config;
  private $connection;


  public function __construct($config, $connection, $url)
  {
    $this->imager     = new Imager($config, $connection);
    $this->config     = $config;
    $this->connection = $connection;
  }


  public function getUpdates()
  {
    $query = $this->connection->prepare('SELECT * FROM sync_updates WHERE name = :name');
    $query->execute([':name' => 'SYNC-BUILD' . $this->config['app']['build'] . '-' . $this->config['app']['version']]);


    if($query->rowCount()) {
      while($r = $query->fetchObject()) {
        echo '<li>' . $r->update . '</li>';
      }
    }
  }


  public function getNewest()
  {
    $query = $this->connection->prepare('SELECT username, account_created FROM users ORDER BY account_created DESC LIMIT 6');
    $query->execute();


    if($query->rowCount()) {
      $i = 1;


      while($r = $query->fetchObject()) {
        if($i % 4 == 1) {
          $class = ' class="no-left-margin"';
        } else {
          $class = '';
        }


        echo '<li' . $class . '><a href="' . $this->config['website']['url'] . '/profile/' . $r->username . '">
          <div class="avatar">' . $this->imager->Generate('user=' . $r->username) . '</div>
          <div class="info">
            <div class="name">' . $r->username . '</div>
            <div class="motto">' . date('d.m.Y - H:i', $r->account_created) . '.</div>
          </div>
        </a></li>';
      }
    }
  }


  public function getUsers()
  {
    $query = $this->connection->prepare('SELECT username FROM users');
    $query->execute();


    if($query->rowCount()) {
      return $query->rowCount();
    } else {
      return 0;
    }
  }


  public function getRooms()
  {
    $query = $this->connection->prepare('SELECT id FROM rooms_data');
    $query->execute();


    if($query->rowCount()) {
      return $query->rowCount();
    } else {
      return 0;
    }
  }


  public function getItems()
  {
    $query = $this->connection->prepare('SELECT id FROM catalog_items');
    $query->execute();


    if($query->rowCount()) {
      return $query->rowCount();
    } else {
      return 0;
    }
  }


  public function getBadges()
  {
    $query = $this->connection->prepare('SELECT badge_id FROM users_badges');
    $query->execute();


    if($query->rowCount()) {
      return $query->rowCount();
    } else {
      return 0;
    }
  }


  public function getBans()
  {
    $query = $this->connection->prepare('SELECT id FROM bans');
    $query->execute();


    if($query->rowCount()) {
      return $query->rowCount();
    } else {
      return 0;
    }
  }


  public function SearchUser($user)
  {
    if(empty($user)) {
      $this->err = 'Gib die Anfangsbuchstaben ein.';
    } else {
      $query = $this->connection->prepare('SELECT username, motto FROM users WHERE username LIKE :user');
      $query->execute([':user' => '%' . $user . '%']);


      if($query->rowCount()) {
        while($r = $query->fetchObject()) {
          $this->result .= '<li><a href="' . $this->config['website']['url'] . '/profile/' . $r->username . '">
            <div class="avatar">' . $this->imager->Generate('user=' . $r->username) . '</div>
            <div class="info">
              <div class="name">' . $r->username . '</div>
              <div class="motto">' . $r->motto . '</div>
            </div>
          </a></li>';
        }
      } else {
        $this->err = 'Keine Users gefunden.';
      }
    }
  }


  public function getActiveRooms()
  {
    $query = $this->connection->prepare('SELECT id, caption, description, users_now FROM rooms_data WHERE users_now > :users_now ORDER BY users_now DESC');
    $query->execute([':users_now' => 0]);


    if($query->rowCount()) {
      while($r = $query->fetchObject()) {
        if(empty($r->description)) {
          $description = 'Keine Beschreibung verfügbar';
        } else {
          $description = $r->description;
        }


        if($r->id > 3) {
          $img = '';
        } else {
          $img = '<img src="' . $this->config['website']['url'] . '/Public/Images/Room.gif">';
        }


        echo '<li>
          <a href="' . $this->config['website']['url'] . '/client" target="_blank">
            ' . $img .'
            <div class="content">
              <div class="name">' . $r->caption . '</div>
              <div class="desc">' . $description . '</div>
              <span>' . $r->users_now . '</span><div class="online"></div>
            </div>
          </a>
        </li>';
      }
    } else {
      echo '<li>
        <a href="' . $this->config['website']['url'] . '/client" target="_blank">
          <img src="' . $this->config['website']['url'] . '/Public/Images/Room.gif">
          <div class="content">
            <div class="name">Keine Räume gefunden.</div>
            <div class="desc">Keine Beschreibung verfügbar.</div>
            <span>0</span><div class="online"></div>
          </div>
        </a>
      </li>';
    }
  }


  public function getEvents()
  {
    $query = $this->connection->prepare('SELECT id, title, time, room FROM sync_events WHERE time > :time ORDER BY time DESC');
    $query->execute([':time' => time()]);


    if($query->rowCount()) {
      while($r = $query->fetchObject()) {
        if($r->id > 3) {
          $img = '';
        } else {
          $img = '<img src="' . $this->config['website']['url'] . '/Public/Images/Clock.png">';
        }


        echo '<li>
          <a href="' . $this->config['website']['url'] . '/client" target="_blank">
            ' . $img .'
            <div class="content">
              <div class="name">' . $r->title . '</div>
              <div class="desc">Um ' . date('H:i', $r->time) . ' Uhr, im Raum: ' . $r->room . '</div>
            </div>
          </a>
        </li>';
      }
    } else {
      echo '<li>
        <a href="' . $this->config['website']['url'] . '/client" target="_blank">
          <img src="' . $this->config['website']['url'] . '/Public/Images/Clock.png">
          <div class="content">
            <div class="name">Keine Events gefunden.</div>
            <div class="desc">Keine Uhrzeit verfügbar.</div>
          </div>
        </a>
      </li>';
    }
  }


  public function __destruct()
  {
    $this->err        = null;
    $this->imager     = null;
    $this->config     = null;
    $this->result     = null;
    $this->success    = null;
    $this->connection = null;
  }
}


?>