<?
ini_set('display_errors',0);
// Start session to access Global variables
session_start();

if (!isset($type))	$type = "pandora";
if (!isset($allowaccess)) $allowaccess = 0;
if (!isset($getkeywords)) $getkeywords = "";
if (!isset($_COOKIE['remember_email'])) $_COOKIE['remember_email'] = "";
if (!isset($error)) $error = "";
if (!isset($found)) $found = false;
if (!isset($indexes)) $indexes[-1][1] = 0;
if (!isset($description)) $description = "";
if (!isset($searchkeywords)) $searchkeywords = "";
if (!isset($freevisitscount)) $freevisitscount = 0;
if (!isset($i)) $i = 0;
if (!isset($wordl)) $wordl = "";
if (!isset($getwords)) $getwords = "";
if (!isset($_SESSION["freevisitscount"])) $_SESSION["freevisitscount"] = 0;

$websitetype = "Pandora";
$title = "Pandorawordbox";

// Database Server
$serverhost = "localhost";

// Database Admin Username
$adminuser = "root";

// Database Admin Password
$adminpass = "ctEWqe1obHGAm1Zr";

// Data Base
$db_pandora = "pandorawordbox";
$db_medword = "pandorawordbox";
//$db_mw = "ibisbirt_medworddb";

// Root Document
$domain = "http://www.pandorawordbox.com";
$rootfolder = $domain."/";

$domainmedword = "http://www.medword.net";
$medwordrootfolder = $domainmedword."/";

// base path
$base_path ="/home/ibisbirt/public_html/";

$id_con=mysql_connect($serverhost, $adminuser, $adminpass);
mysql_select_db($db_pandora, $id_con);

$style = "pandora"; // default style
if (isset($_GET["setstyle"]))
  $style=$_GET["setstyle"];
else
{
  if ($websitetype=="medword") {
    if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Medword Style'")))
      $style=$confi["value"];
  } else {
    if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Style'")))
      $style=$confi["value"];
  }
}

include_once("styles/".$style."/style.php");

// Language
if (isset($_GET["language"]) && file_exists($rootfolder."lang/".$_GET["lang"].".php"))
  $lang=$_GET["lang"];
else
  if (isset($_COOKIE["lang"]) && file_exists($rootfolder."lang/".$_COOKIE["lang"].".php"))
    $lang=$_COOKIE["lang"];
  else	
    if (($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Language'"))) && file_exists($rootfolder."lang/".$confi["value"].".php"))
      $lang=$confi["value"];
	else
	  $lang="english";  
	  
// Secure areas
$secure_views = "1";
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Secure Views'")))
  $secure_views=$confi["value"];
  
$secure_searches = "1";
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Secure Searches'")))
  $secure_searches=$confi["value"];
  
$secure_rosters = "1";
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Secure Rosters'")))
  $secure_rosters=$confi["value"];
  
$secure_others = "0";
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Secure Others'")))
  $secure_others=$confi["value"];

$freevisits = 5; // default free visits
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Free visits'")))
  $freevisits=$confi["value"];
  
$currentpoll = 1; // default poll
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current Poll'")))
  $currentpoll=$confi["value"];

// Current Pandora Overview
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current Overview'")))
{
  $query="SELECT * FROM overviews WHERE id='$confi[value]'";
  $res=mysql_query($query);
  if (mysql_num_rows($res) > 0)
  {
    $currentoverview=$confi["value"];
  } else
  {
    $query="SELECT * FROM overviews ORDER BY dateadded DESC LIMIT 1";
    $res=mysql_query($query);
    if ($overview=mysql_fetch_array($res))
      $currentoverview=$overview["id"];
  }  
}

// Current Aphorism
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current Aphorism'")))
{
  $query="SELECT * FROM aphorisms WHERE id='$confi[value]'";
  $res=mysql_query($query);
  if (mysql_num_rows($res) > 0)
  {
    $currentaphorism=$confi["value"];
  } else
  {
    $query="SELECT * FROM aphorisms ORDER BY dateadded DESC LIMIT 1";
    $res=mysql_query($query);
    if ($aphorism=mysql_fetch_array($res))
      $currentaphorism=$aphorism["id"];
  }  
}

// Current Image
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current Image'")))
{
  $query="SELECT * FROM images WHERE id='$confi[value]'";
  $res=mysql_query($query);
  if (mysql_num_rows($res) > 0)
  {
    $currentimage=$confi["value"];
  } else
  {
    $query="SELECT * FROM images ORDER BY dateadded DESC LIMIT 1";
    $res=mysql_query($query);
    if ($image=mysql_fetch_array($res))
      $currentimage=$image["id"];
  }  
}

// Current MedImage
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current MedImage'")))
{
  $query="SELECT * FROM images WHERE id='$confi[value]'";
  $res=mysql_query($query);
  if (mysql_num_rows($res) > 0)
  {
    $currentmedimage=$confi["value"];
  } else
  {
    $query="SELECT * FROM images ORDER BY dateadded DESC LIMIT 1";
    $res=mysql_query($query);
    if ($image=mysql_fetch_array($res))
      $currentmedimage=$image["id"];
  }  
}

if ($websitetype=="medword")
{
// Current Medword Overview
if ($confi=mysql_fetch_array(mysql_query("SELECT * FROM config WHERE attribute = 'Current Medword'")))
{
  mysql_select_db($db_medword, $id_con);

  $query="SELECT * FROM medwords WHERE id='$confi[value]'";
  $res=mysql_query($query);
  if (mysql_num_rows($res) > 0)
  {
    $currentmedword=$confi["value"];
  } else
  {
    $query="SELECT * FROM medwords ORDER BY dateadded DESC LIMIT 1";
    $res=mysql_query($query);
    if ($medword=mysql_fetch_array($res))
      $currentmedword=$medword["id"];
  }  
}
}

// Select language
include("lang/".$lang.".php");
  $bdnetfolder = "http://www.birthdefects.net/";
?>