<?php

  $db_host = $db_info['ip'];
  $db_name = $db_info['db_name'];
  $db_user = $db_info['user'];
  $db_pass = $db_info['pass'];

  try {
    $conn = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_pass);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->query("SET NAMES 'utf8'");
  }
  catch(PDOException  $e) {
    echo "Connection failed: " . $e->getMessage();
  }

  //SQLs
  $sql_auth = "SELECT * FROM accounts WHERE login=:login AND password=:password";
  $online_players = "SELECT COUNT(*) FROM characters WHERE online='1'";

  $gamserver = @fsockopen($server_config['server_ip'], 7777, $errno, $errstr);
  $loginserver = @fsockopen($server_config['server_ip'], 2106, $errno, $errstr);

  if ($gamserver) {
    $game_status = 'online';
    $game_display = 'Online';
  }
  else {
    $game_status = 'offline';
    $game_display = 'Offline';
  }



  if ($loginserver) {
    $login_status = 'online';
    $login_display = 'Online';
  }
  else {
    $login_status = 'offline';
    $login_display = 'Offline';
  }


  $game_status =  '<div class="'.$game_status.'">'.$game_display.'</div>';
  $login_status =  '<div class="'.$login_status.'">'.$login_display.'</div>';

  $online_players = $conn->prepare($online_players);
    $online_players->execute();
  $online = $online_players->fetchColumn();
  $online = $online + $web_config['fake_players'];

  $total_pvp = 0;
  $total_pvp_sql   = "SELECT pvpkills FROM characters WHERE pvpkills > 0";
  $total_pvp_query = $conn-> prepare($total_pvp_sql);
  $total_pvp_query-> execute();

    while($total_pvp_data = $total_pvp_query-> fetchColumn()) {
        $total_pvp =  $total_pvp_data + $total_pvp;
    }


  $paypal = 'https://www.paypal.com/cgi-bin/webscr';
  $admin_paypal = $web_config['paypal_email'];

  $points_per_euro = $web_config['donate_points'];
?>