<?
// form başka yerdden
if (!$okmu) {
echo "Olmadı (:";
}
else {
//form bilgisi eksikse
$vthost =@$HTTP_POST_VARS["dbhost"];
$vtkullanici =@$HTTP_POST_VARS["dbuser"];
$vtsifre =@$HTTP_POST_VARS["dbpass"];
$vtadi =@$HTTP_POST_VARS["dbname"];
if ($dbhost == "" or $dbuser == "" or $dbpass == "" or $dbname == "") {
include "ust.php";
echo "
Lütfen eksik kısımları doldurarak tekrar deneyiniz.";
include "alt.php";
exit;
}
$dbcon = mysql_connect($dbhost, $dbuser, $dbpass);
if (!$dbcon) {
   die('<font face="tahoma" size="2"><b>Mysql bilgileriniz yanlis.</b><br>
   Dogru mysql bilgilerini edindikten sonra<br>
   Tekrar deneyiniz.');
mysql_select_db($dbname);
exit;
}

$islem = fopen("../ayar/baglan.php","w+");
if(!$islem) die("Dosya yaratilamadi.Chmod ayarlarinizi kontrol edin. baglan.php");
$icerik = "<?\n" . "\$vtkullanici = '$_POST[dbuser]'; \n" . "\$vtsifre = '$_POST[dbpass]'; \n" . "\$vtadi = '$_POST[dbname]'; \n". "\$vthost= '$_POST[dbhost]'; \n" . "\$connection = mysql_connect(\$vthost,\$vtkullanici,\$vtsifre) or die (mysql_error());  \n" . "\$database = mysql_select_db(\$vtadi,\$connection) or die (mysql_error());  \n" . "\$dil = mysql_query(\"SET NAMES 'latin5'\");  \n ?>";
fwrite($islem,$icerik);
fclose($islem);
$dbcon = mysql_connect($vthost, $vtkullanici, $vtsifre);
mysql_select_db($vtadi);
$sorgu = "
CREATE TABLE `uyeler` (
  `uyeno` int(10) unsigned NOT NULL auto_increment,
  `uyeadi` char(25) collate utf8_unicode_ci NOT NULL,
  `sifre` char(50) collate utf8_unicode_ci NOT NULL,
  `pin` char(50) collate utf8_unicode_ci NOT NULL,
  `websifre` char(50) collate utf8_unicode_ci NOT NULL,
  `adsoyad` char(50) collate utf8_unicode_ci NOT NULL,
  `kayitmail` char(150) collate utf8_unicode_ci NOT NULL,
  `email` char(150) collate utf8_unicode_ci NOT NULL,
  `yer` char(150) collate utf8_unicode_ci NOT NULL,
  `durum` text NOT NULL,
  `yetki` text NOT NULL,
  `kayittarihi` datetime NOT NULL default '0000-00-00 00:00:00',
  `onaykodu` char(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`uyeno`),
  UNIQUE KEY `uyeadi_2` (`uyeadi`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
";
mysql_query($sorgu);
$sorgu2 = "
CREATE TABLE `yonetim` (
  `ayarlar` mediumint(1) NOT NULL default '1',
  `sunucuadi` char(100) collate utf8_unicode_ci NOT NULL default '',
  `siteadresi` char(100) collate utf8_unicode_ci NOT NULL default '',
  `siteadresi2` char(100) collate utf8_unicode_ci NOT NULL default '',
  `sunucuadresi` char(100) collate utf8_unicode_ci NOT NULL default '',
  `sunucueposta` char(100) collate utf8_unicode_ci NOT NULL default '',
  `sistem` char(100) collate utf8_unicode_ci NOT NULL default '',
  `yol` char(100) collate utf8_unicode_ci NOT NULL default '',
  `ftpkullanici` char(100) collate utf8_unicode_ci NOT NULL default '',
  `ftpsifre` char(100) collate utf8_unicode_ci NOT NULL default '',
  `ftpip` char(100) collate utf8_unicode_ci NOT NULL default '',
  `sitetema` char(200) collate utf8_unicode_ci NOT NULL default 'tema1',
  `uyelikonayi` enum('Evet','Hayir') collate utf8_unicode_ci NOT NULL default 'Evet',
  `uyekayitkapat` enum('Evet','Hayir') collate utf8_unicode_ci NOT NULL default 'Hayir',
  `pin` enum('Evet','Hayir') collate utf8_unicode_ci NOT NULL default 'Hayir',
  PRIMARY KEY  (`ayarlar`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
";
mysql_query($sorgu2);
include "ust.php";
echo"Database dogrulandi ve tablolar sisteme yüklendi. Simdi Admin hesabi acmak icin yönlendiriliyorsunuz.
<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"2;URL=admin.php\">
";
include "alt.php";
}


?>