Hello Nog Dog Thank you for your prompt response.
Please refer to the code below.
<?php //'
} else {
require('./include/dbinfo.php');
require('./include/vars.php');
require('./include/db.php');
$db->query("
create table ".$db['prefix']."fileinfo(
id int not null auto_increment,
idkey varchar(30) not null unique,
dir varchar(30) not null unique,
mime_type varchar(50),
file_name varchar(200) not null,
size bigint not null default '0',
upload_time int default '0',
no_of_dwnld int default '0',
expire_time int default '0',
max_dwnld int default '0',
link_status tinyint default '1',
recipient varchar(50) not null,
sender varchar(50),
primary key(id)
)");
$db->query("create table ".$db['prefix']."configuration (
conf_id int not null auto_increment,
conf_name varchar(20) not null,
conf_value text,
conf_optional varchar(250),
primary key(conf_id)
)");
$db->query("create table ".$db['prefix']."admin(
uid int not null auto_increment,
uname varchar(15) not null unique,
pwd varchar(32) not null,
email varchar(50) not null,
primary key(uid)
)");
$db->query("create table ".$db['prefix']."adminlog(
uid int(11) not null,
timein int(11) not null,
timeout int(11) default null,
ip varchar(16) default null)");
$db->query("
insert into ".$db['prefix']."configuration(conf_id,conf_name,conf_value,conf_optional) values(1,'MAX_SIZE','1024','1 MB')
,(2,'MIME_TYPES','image/jpeg,image/pjpeg,application/x-gzip-compressed','')
,(3,'MAX_COUNT','5','a limited number of')
,(4,'MAX_TIME','7','7 Days')
,(5,'AUTO_FILE_DELETE','Yes','')
,(6,'DAILY_TRANSFER','0','29-04-2005')");
$db->query("INSERT INTO ".$db['prefix']."admin(uid,uname,pwd,email) VALUES ('1', '".ADMIN_INSTALL_USERNAME."', '".md5('admin')."', 'admin@admin.com')");
echo('Installation is complete, Your admin login details are User: admin Password: admin, you can change it via your admin control panel. Please delete this installation file.');
}
?>
