[DEV] SyncCMS

<?php


class Community
{
  private $config;
  private $connection;


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


  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->config     = null;
    $this->connection = null;
  }
}


?>

<?php


class Home
{
  public $err = '';
  public $err2 = '';
  public $success = false;
  public $success2 = false;
  private $user;
  private $config;
  private $connection;


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


  public function Voting($user)
  {
    $query = $this->connection->prepare('SELECT voter FROM sync_usersvoting WHERE voter = :voter LIMIT 1');
    $query->execute([':voter' => $this->user->data['id']]);


    if($query->rowCount()) {
      $this->err2 = 'Du hast bereits Teilgenommen.';
    } else {
      if(empty($user)) {
        $this->err2 = 'Gib ein Username ein.';
      } else {
        $query = $this->connection->prepare('SELECT id FROM users WHERE username = :username LIMIT 1');
        $query->execute([':username' => $user]);


        if($query->rowCount()) {
          $r = $query->fetchObject();


          $query = $this->connection->prepare('INSERT INTO sync_usersvoting (id, voter) VALUES (:id, :voter)');
          $query->execute([
            ':id' => $r->id,
            ':voter' => $this->user->data['id']
          ]);


          $this->success2 = true;
        } else {
          $this->err2 = 'Dieser User existiert nicht.';
        }
      }
    }
  }


  public function Polls($var)
  {
    $query = $this->connection->prepare('SELECT id FROM sync_polls WHERE id = :id LIMIT 1');
    $query->execute([':id' => $this->user->data['id']]);


    if($query->rowCount()) {
      $this->err = 'Du hast bereits Teilgenommen.';
    } else {
      if($var == 'good') {
        $query = $this->connection->prepare('INSERT INTO sync_polls (id, poll) VALUES (:id, :poll)');
        $query->execute([
          ':id'   => $this->user->data['id'],
          ':poll' => 'good'
        ]);


        $this->success = true;
      } else {
        $query = $this->connection->prepare('INSERT INTO sync_polls (id, poll) VALUES (:id, :poll)');
        $query->execute([
          ':id'   => $this->user->data['id'],
          ':poll' => 'bad'
        ]);


        $this->success = true;
      }
    }
  }


  public function getPollQuestion()
  {
    $query = $this->connection->prepare('SELECT question FROM sync_polls_questions LIMIT 1');
    $query->execute();


    if($query->rowCount()) {
      $r = $query->fetchObject();


      return $r->question;
    }
  }


  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 getCampaigns()
  {
    $query = $this->connection->prepare('SELECT * FROM sync_campaigns');
    $query->execute();


    if($query->rowCount()) {
      while($r = $query->fetchObject()) {
        echo '<li>
          <img src="' . $this->config['website']['url'] . '/Public/Images/Campaign/Image_' . $r->id . '.gif">
          <div class="desc">
            <div class="title">' . $r->title . '</div>
            <div class="content">' . $r->content . '</div>
          </div>
        </li>';
      }
    }
  }


  public function __destruct()
  {
    $this->err        = null;
    $this->err2       = null;
    $this->user       = null;
    $this->config     = null;
    $this->success    = null;
    $this->success2   = null;
    $this->connection = null;
  }
}


?>