";
}
if ($step == "3a") {
$db_host = $HTTP_POST_VARS['m_host'];
$db_user = $HTTP_POST_VARS['m_user'];
$db_pass = $HTTP_POST_VARS['m_pass'];
$db_name = $HTTP_POST_VARS['m_name'];
session_register('db_host');
session_register('db_user');
session_register('db_pass');
session_register('db_name');
if ($lang == "turkish") {
define ("W_WRONGDB", "Veritabani bilgileri yanlis. Lutfen tekrar deneyiniz.");
define ("W_DBERR", "Tablo yaratilamadi. Hata:");
define ("W_DBERR2", "Veri eklenmedi. Hata:");
} else {
define ("W_WRONGDB", "Wrong database information. Please try again");
define ("W_DBERR", "Can not create table. Error");
define ("W_DBERR2", "Can not add data. Error");
}
$conn = @mysql_connect($HTTP_POST_VARS['m_host'], $HTTP_POST_VARS['m_user'], $HTTP_POST_VARS['m_pass'])
or die(W_WRONGDB."");
$db = @mysql_select_db($HTTP_POST_VARS['m_name'], $conn)
or die(W_WRONGDB."");
$tables = array (
"dcp5_advertisers" => "CREATE TABLE dcp5_advertisers (
aid int(24) NOT NULL auto_increment,
username varchar(32) NOT NULL default '',
password varchar(32) NOT NULL default '',
name varchar(64) NOT NULL default '',
company varchar(64) default NULL,
email varchar(64) NOT NULL default '',
PRIMARY KEY (aid)
) TYPE=MyISAM;",
"dcp5_agenda" => "CREATE TABLE dcp5_agenda (
id int(12) NOT NULL auto_increment,
user_id int(12) NOT NULL default '0',
subject varchar(80) NOT NULL default '',
message longtext NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id)
) TYPE=MyISAM;",
"dcp5_annoucements" => "CREATE TABLE dcp5_annoucements (
id int(24) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
subject varchar(128) NOT NULL default '',
body longtext NOT NULL,
date date NOT NULL default '0000-00-00',
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;",
"dcp5_banned" => "CREATE TABLE dcp5_banned (
user_id int(24) NOT NULL default '0'
) TYPE=MyISAM;",
"dcp5_banners" => "CREATE TABLE dcp5_banners (
bid int(24) NOT NULL auto_increment,
name varchar(64) NOT NULL default '',
url varchar(128) NOT NULL default '',
gif varchar(128) NOT NULL default '',
hit int(12) NOT NULL default '0',
click int(12) NOT NULL default '0',
startdate date NOT NULL default '0000-00-00',
maxshow int(12) NOT NULL default '0',
maxclick int(12) NOT NULL default '0',
enddate date NOT NULL default '0000-00-00',
advid int(24) NOT NULL default '0',
html enum('0','1') NOT NULL default '0',
type enum('1','2','3') NOT NULL default '1',
PRIMARY KEY (bid)
) TYPE=MyISAM;",
"dcp5_cats" => "CREATE TABLE dcp5_cats (
id int(24) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
name varchar(64) NOT NULL default '',
icon varchar(255) NOT NULL default '',
sort int(24) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_comments" => "CREATE TABLE dcp5_comments (
comid int(24) NOT NULL auto_increment,
cid int(24) NOT NULL default '0',
user_id int(24) NOT NULL default '0',
comment varchar(255) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
active enum('0','1') NOT NULL default '1',
PRIMARY KEY (comid)
) TYPE=MyISAM;",
"dcp5_config" => "CREATE TABLE dcp5_config (
site_name varchar(64) NOT NULL default '',
admin_mail varchar(128) NOT NULL default '',
site_lang varchar(24) NOT NULL default '',
site_theme varchar(24) NOT NULL default '',
max_anns int(2) NOT NULL default '0',
max_content int(2) NOT NULL default '0',
max_news int(2) NOT NULL default '0',
index_cols tinyint(1) NOT NULL default '0',
max_links smallint(10) NOT NULL default '0',
max_forum smallint(2) NOT NULL default '0'
) TYPE=MyISAM;",
"dcp5_contents" => "CREATE TABLE dcp5_contents (
id tinyint(4) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
name varchar(255) NOT NULL default '',
content longtext NOT NULL,
writer varchar(255) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
hit int(24) NOT NULL default '0',
active tinyint(4) NOT NULL default '0',
KEY id (id)
) TYPE=MyISAM;",
"dcp5_doc_cats" => "CREATE TABLE dcp5_doc_cats (
dcid int(24) NOT NULL auto_increment,
name varchar(128) NOT NULL default '',
descr varchar(255) NOT NULL default '',
PRIMARY KEY (dcid)
) TYPE=MyISAM;",
"dcp5_docs" => "CREATE TABLE dcp5_docs (
did int(24) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
name varchar(255) NOT NULL default '',
descr varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
writer varchar(24) NOT NULL default '0',
size int(24) NOT NULL default '0',
version varchar(12) NOT NULL default '',
hit int(24) NOT NULL default '0',
date datetime NOT NULL default '0000-00-00 00:00:00',
last datetime NOT NULL default '0000-00-00 00:00:00',
active enum('0','1') NOT NULL default '0',
PRIMARY KEY (did)
) TYPE=MyISAM;",
"dcp5_faq" => "CREATE TABLE dcp5_faq (
id tinyint(4) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
name varchar(255) NOT NULL default '',
content longtext NOT NULL,
active tinyint(4) NOT NULL default '0',
KEY id (id)
) TYPE=MyISAM;",
"dcp5_faq_cats" => "CREATE TABLE dcp5_faq_cats (
id int(24) NOT NULL auto_increment,
name varchar(64) NOT NULL default '',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_file_cats" => "CREATE TABLE dcp5_file_cats (
id int(24) NOT NULL auto_increment,
pid int(24) default NULL,
p_cat_id int(24) NOT NULL default '0',
cat_id int(24) default '0',
name varchar(64) NOT NULL default '0',
sort int(3) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_forum_boards" => "CREATE TABLE dcp5_forum_boards (
fid int(12) NOT NULL auto_increment,
cat_id int(12) NOT NULL default '0',
name varchar(64) NOT NULL default '',
descr varchar(255) default NULL,
PRIMARY KEY (fid)
) TYPE=MyISAM;",
"dcp5_forum_cats" => "CREATE TABLE dcp5_forum_cats (
cid int(12) NOT NULL auto_increment,
name varchar(128) NOT NULL default '',
sort int(12) NOT NULL default '0',
PRIMARY KEY (cid)
) TYPE=MyISAM;",
"dcp5_forum_messages" => "CREATE TABLE dcp5_forum_messages (
tid int(24) NOT NULL auto_increment,
b_id int(24) NOT NULL default '0',
title varchar(128) NOT NULL default '',
body text NOT NULL,
msg_id int(24) NOT NULL default '0',
writer int(24) NOT NULL default '0',
date datetime NOT NULL default '0000-00-00 00:00:00',
active enum('0','1') NOT NULL default '1',
hits int(24) NOT NULL default '0',
PRIMARY KEY (tid)
) TYPE=MyISAM;",
"dcp5_isread" => "CREATE TABLE dcp5_isread (
msg_id int(24) NOT NULL default '0',
user_id int(24) NOT NULL default '0'
) TYPE=MyISAM;",
"dcp5_language" => "CREATE TABLE dcp5_language (
id int(24) NOT NULL auto_increment,
cid int(24) NOT NULL default '0',
subject varchar(64) default NULL,
body longtext,
type varchar(12) NOT NULL default '',
lang varchar(12) NOT NULL default '',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_link_cats" => "CREATE TABLE dcp5_link_cats (
id int(24) NOT NULL auto_increment,
cat_id int(24) default '0',
name varchar(64) NOT NULL default '0',
sort int(3) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_links" => "CREATE TABLE dcp5_links (
id int(24) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
name varchar(128) NOT NULL default '',
url varchar(255) NOT NULL default '',
descr varchar(255) default NULL,
hit int(24) NOT NULL default '0',
date date NOT NULL default '0000-00-00',
active tinyint(1) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM;",
"dcp5_mail" => "CREATE TABLE dcp5_mail (
mid int(11) NOT NULL auto_increment,
subject varchar(255) NOT NULL default '',
body text NOT NULL,
language varchar(12) NOT NULL default '',
date date NOT NULL default '0000-00-00',
PRIMARY KEY (mid)
) TYPE=MyISAM;",
"dcp5_members" => "CREATE TABLE dcp5_members (
uid int(24) NOT NULL auto_increment,
sex enum('1','2') default NULL,
name varchar(64) NOT NULL default '',
surname varchar(64) NOT NULL default '',
email varchar(128) NOT NULL default '',
birthdate date NOT NULL default '0000-00-00',
address varchar(255) NOT NULL default '',
zip varchar(9) NOT NULL default '',
city varchar(32) NOT NULL default '',
country varchar(64) NOT NULL default '',
job varchar(64) NOT NULL default '',
tel varchar(32) NOT NULL default '',
language varchar(12) NOT NULL default '',
hideinfo enum('0','1') NOT NULL default '0',
list enum('0','1') NOT NULL default '0',
username varchar(32) NOT NULL default '',
password varchar(32) NOT NULL default '',
signature varchar(255) default NULL,
admin enum('0','1','2','3','4','5') NOT NULL default '0',
active enum('0','1') NOT NULL default '0',
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (uid)
) TYPE=MyISAM;",
"dcp5_messages" => "CREATE TABLE dcp5_messages (
mid int(24) NOT NULL auto_increment,
to_id int(24) default NULL,
from_id int(24) default NULL,
sent_id varchar(24) default NULL,
subject varchar(255) NOT NULL default '',
body text,
status enum('0','1') NOT NULL default '0',
date datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (mid)
) TYPE=MyISAM;",
"dcp5_news" => "CREATE TABLE dcp5_news (
id int(24) NOT NULL auto_increment,
cat_id int(24) NOT NULL default '0',
subject varchar(128) NOT NULL default '',
body longtext NOT NULL,
date date NOT NULL default '0000-00-00',
active tinyint(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;",
"dcp5_online" => "CREATE TABLE dcp5_online (
user_id int(24) NOT NULL default '0',
sessid varchar(255) NOT NULL default '',
timer datetime default NULL
) TYPE=MyISAM;",
"dcp5_poll_answers" => "CREATE TABLE dcp5_poll_answers (
aid int(8) NOT NULL auto_increment,
qid int(8) NOT NULL default '0',
answer varchar(64) NOT NULL default '',
vote int(11) NOT NULL default '0',
color varchar(12) NOT NULL default '',
PRIMARY KEY (aid)
) TYPE=MyISAM;",
"dcp5_polls" => "CREATE TABLE dcp5_polls (
pid int(8) NOT NULL auto_increment,
question varchar(255) NOT NULL default '',
multiple enum('0','1') NOT NULL default '0',
date datetime NOT NULL default '0000-00-00 00:00:00',
active enum('0','1') NOT NULL default '0',
PRIMARY KEY (pid)
) TYPE=MyISAM;",
"dcp5_read_message" => "CREATE TABLE dcp5_read_message (
mid int(24) NOT NULL default '0',
user_id int(24) NOT NULL default '0'
) TYPE=MyISAM;",
"dcp5_releated" => "CREATE TABLE dcp5_releated (
content_id int(24) NOT NULL default '0',
releated_id int(24) NOT NULL default '0'
) TYPE=MyISAM;",
"dcp5_themes" => "CREATE TABLE dcp5_themes (
name varchar(255) NOT NULL default '',
bullet varchar(255) NOT NULL default '',
subject_bg varchar(7) default NULL,
light_bg varchar(12) NOT NULL default '',
anns_width int(3) NOT NULL default '0',
anns_height int(3) NOT NULL default '0'
) TYPE=MyISAM;"
);
$data1 = array("INSERT INTO dcp5_banners VALUES (1, 'Peron Software', 'http://www.peron.com.tr', 'http://www.dcp-portal.org/images/banners/dcp.gif', 0, 0, '2002-12-11', 0, 0, '2020-01-01', 0, '0', '1');");
$data1 = array("INSERT INTO dcp5_themes VALUES ('dcp-portal', 'bullet.png', '#E8E8E8', '#FF9900', 140, 120);");
$connection = @mysql_connect($db_host, $db_user, $db_pass)
or die (W_WRONGDB);
$db = @mysql_select_db($db_name, $connection)
or die (W_WRONGDB);
while(list($name, $table) = each($tables)) {
if(!$r = mysql_query($table))
die("
".W_DBERR.": ".mysql_error()."
");
echo "$name -->> OK
";
flush();
}
for($x = 0; $x < count($data1); $x++) {
if(!$r = mysql_query($data1[$x]))
die("".W_DBERR2."".mysql_error(). "");
}
for($x = 0; $x < count($data2); $x++) {
if(!$r = mysql_query($data2[$x]))
die("".W_DBERR2."".mysql_error(). "");
}
$config="";
$fp = fopen("config.inc.php","w");
fputs($fp, $config);
fclose($fp);
echo "";
exit();
}
if (!isset($step)) {
setcookie('lang', "", -1);
?>
DCP-Portal SE
 |
 |
| DCP-Portal SE |
|
Please select language for installation.
Lutfen kurulum icin bir dil seciniz.
|
|
DCP-Portal SE uygulamasi kurulumuna hosgeldiniz;
Sistemi kullanima hazir hale getirebilmeniz icin 4 adimdan olusan bu kurulum uygulamasini
sonuna kadar takip etmeniz gerekmektedir.
Takip edeceginiz adimlar;
- 1. Adim: Sunucu, veritabani ve uygulamanin internet adresleri ile ilgili bilgiler girilmesi
- 2. Adim: Admin (Sistem Yoneticisi) ile ilgili bilgilerin girilmesi
- 3. Adim: Program ayarlarının yapılması
- 4. Adim: Uygulamanin tum ayarlari yapmasi ve sistemin kullanima hazir hale getirilmesi
Siz uygulamayi takip ettikce, arka tarafta
- Veritabani tablolari yaratilacak.
- Admin (Sistem Yoneticisi) veritabanina kaydedilecek
Kuruluma baslamadan once lutfen
- Veritabanina baglanti saglamak icin gerekli kullanici adi ve sifrelere sahip oldugunuzdan,
- DCP-Portal SE icin bos bir veritabani yaratilmis oldugundan
- PHP'de register_globals opsiyonunun acik oldugundan
- PHP'de short_open_tags opsiyonunun acik oldugundan
- PHP'de safe_mode opsiyonunun kapali oldugundan
- Sunucu uzerinde bir SMTP sunucusunun yuklu oldugundan
- Eger Linux sunucu kullaniyorsaniz
- config.inc.php
- upload
- documents
dosya ve klasorlerine CHMOD 0777 izninin verildiginden
emin olunuz. PHP kurulumu ile ilgili degiskenlere ulasmak icin tiklayiniz.
register_globals ve short_open_tags opsiyonlarini php.ini dosyasindan acabilirsiniz.
Bu islemin ardindan internet sunucunuzu (Apache, IIS) durdurup yeniden baslatmaniz gerekmektedir.");
define ("W_STEP1", "1. Adim");
define ("W_M1", "Asagidaki bolumde, DCP-Portal SE'in uzerinde calistigi sunucuya ait bazi bilgilerini girmeniz gerekmektedir.
Uygulama Sunucu Adresi ve Uygulama Web Adresi sunucunuza gore kurulum programinin
elde ettigi degerlerdir. Eger degerlerin belirtilenden farkli oldugundan emin degilseniz lutfen degistirmeyiniz.
MySQL bilgileri belirtilen degerlerden farkli olabilir. Asagidaki degerler, standart MySQL kurulumundan
sonra konfigure eidlmemis bir MySQL sunucusuna aittir. MySQL'i sisteminize kurduktan sonra bu kullanici adi
ve sifre degisikligi yaptiysaniz lutfen veritabani yaratma hakkina sahip kullaniciya ait bilgileri giriniz.
Veritabani adi, halihazirda sunucu uzerinde bulunmayan bir veritabanini belirtmelidir.
DCP-Portal SE ve MySQL sunucusu ayni makina uzerinde calisiyorsa MySQL Host bolumunu
localhost olarak birakiniz. Aksi takdirde MySQL sunucusunun uzerinde bulundugu makinanin adresini
veya IP'sini giriniz.");
define ("W_APPPATH", "Uygulama Sunucu Adresi");
define ("W_APPURL", "Uygulama Web Adresi");
define ("W_DBNAME", "Veritabani Adi");
define ("W_DBUSERNAME", "Kullanici Adi");
define ("W_DBPASSWORD", "Sifre");
define ("W_STEP2", "1. Adim");
define ("W_SERVERSETTINGS", "Sunucu Ayarlari");
define ("W_PREFSACTIVATION", "Ayarlar ve Aktivasyon");
define ("W_ADMINMAIL", "Yonetici E-Mail");
define ("W_SITENAME", "Site Adi");
define ("W_STEP4", "4. Adim");
define ("W_INVALIDMAIL", "Gecersiz E-Mail Adresi");
define ("W_CHECKFIELD", "Lutfen asagidaki alanlari duzeltiniz.");
define ("W_FILLFIELD", "Lutfen asagidaki alanlari doldurunuz.");
define ("W_THE_END", "DCP-Portal SE kurulumu basariyla tamamlanmis ve ayarlar yapilmistir. Simdi site yoneticisini
kaydetmek icin siteye yonlendirileceksiniz. Bu bolumde belirleyeceginiz kullanici adi ve sifre, sitenin
tum guncellemelerini yapma hakkina sahip bir hesaba ait olacaktir. Yonetici paneline http://adresiniz/admin
adresinden ulasabilirsiniz.
Lutfen bekleyiniz.");
define ("W_LANG", "turkish");
} else {
define ("W_INSTALLATION", "Installation");
define ("W_INSTALL_SCREEN", "Installation Screen");
define ("W_README", "
Welcome to DCP-Portal SE installation script;
You have to complete this installation procedure which consists of 4 steps before running your system.
The steps you'll follow are;
- Step 1: Entering server, database and application information.
- Step 2: Entering system administrator information
- Step 3: Completing application settings
- Step 4: Finalizing installation
While you run this script, it will
- Set paths and variables for applications.
- Create database tables.
- Register a member as administrator.
Before starting please check if:
- You have valid username/password for database connection
- A database has been created for installation
- register_globals option is On in PHP installation
- short_open_tags option is On in PHP installation
- safe_modeoption is Off in PHP installation
- GD extension is installed with PHP
- There's an SMTP server daemon installed on server.
- If you're using a Linux server you have to give CHMOD 0777 permisson to the following file and folders,
- config.inc.php
- upload
- documents
You can reach PHP globals from here.
You can open register_globals ve short_open_tags options from php.ini.
Don't forget to restart after making any changes in php.ini");
define ("W_STEP1", "Step 1");
define ("W_M1", "In the section below, you have to give some information about the server which DCP-Portal SE runs on.
Application Root Path and Application URL values are gathered from our server. Please do not
change these if you're not really sure what you're doing.
MySQL information should be differen from the given below. These values are default MySQL information. You
can learn the right values from your system administrator.
Database name must be a valid name and this database must have been created on the MySQL server.
If DCP-Portal SE and MySQL servers run on the same machine, leave Database Host as it is. Else
please write server URL or IP address.");
define ("W_APPPATH", "Application Root Path");
define ("W_APPURL", "Application URL");
define ("W_DBNAME", "Database Name");
define ("W_DBUSERNAME", "Username");
define ("W_DBPASSWORD", "Password");
define ("W_STEP2", "Step 2");
define ("W_SERVERSETTINGS", "Server Settings");
define ("W_PREFSACTIVATION", "Preferences & Activation");
define ("W_ADMINMAIL", "Admin E-Mail");
define ("W_SITENAME", "Site Name");
define ("W_STEP4", "Step 4");
define ("W_INVALIDMAIL", "Invalid E-Mail Address");
define ("W_CHECKFIELD", "Please check the following fields.");
define ("W_FILLFIELD", "Please fill following fields.");
define ("W_THE_END", "DCP-Portal SE installation has been completed successfully. Now you'll be directed to
registration page and will register site administrator. The user that will be registered will allowed to
update all site from the url http://yoursite/admin.
Please wait.");
define ("W_LANG", "english");
}
?>
DCP-Portal SE -- <?=W_INSTALLATION?>
