[color=blue]
>
>goto
http://yoursite.com/admin_setup.php[/color]
The admin_setup. php is as follows
<?php
require "settings.php";
include("admin.php");
include("aheader");
include("mysql.php");
//$reset=1;
if ($reset)
{
$t1=new mysql_tb($website["prefix"]."members");
$t1->drop();
$t2=new mysql_tb($website["prefix"]."projects");
$t2->drop();
$t3=new mysql_tb($website["prefix"]."bids");
$t3->drop();
$tb=new mysql_tb($website["prefix"]."boards");
$tb->drop();
$tb=new mysql_tb($website["prefix"]."reviews");
$tb->drop();
};
$t1=new mysql_tb($website["prefix"]."members","id int(11) DEFAULT '0' NOT NULL
auto_increment, nick varchar(80) NOT NULL, registered date, password varchar(40), email
varchar(40), url varchar(40), name varchar(30), picture varchar(100), category text,
country varchar(30), state varchar(30), city varchar(30), address varchar(120), telephone
varchar(40), languages varchar(100), details text, payment text, credit float(11,2), type
varchar(80), status varchar(100), PRIMARY KEY (id)");
$t2=new mysql_tb($website["prefix"]."projects","id int(11) DEFAULT '0' NOT NULL
auto_increment, nick varchar(80) NOT NULL, registered date, name varchar(100), min
varchar(20), max varchar(20), days varchar(20), category text, country varchar(30), state
varchar(30), city varchar(30), languages varchar(100), description text, file
varchar(100), winer varchar(80), type varchar(50), status varchar(20), PRIMARY KEY (id)");
$t3=new mysql_tb($website["prefix"]."bids","id int(11) DEFAULT '0' NOT NULL
auto_increment, nick varchar(80) NOT NULL, project varchar(100) NOT NULL, registered date,
amount varchar(20), days varchar(20), description text, type varchar(50), status
varchar(20), PRIMARY KEY (id)");
$tb=new mysql_tb($website["prefix"]."boards","id int(11) DEFAULT '0' NOT NULL
auto_increment, nick varchar(80) NOT NULL, name varchar(100) NOT NULL, target
varchar(100),registered date, description text, type varchar(50), status varchar(20),
PRIMARY KEY (id)");
$tb=new mysql_tb($website["prefix"]."reviews","id int(11) DEFAULT '0' NOT NULL
auto_increment, nick varchar(80) NOT NULL, name varchar(100) NOT NULL, grade varchar(100),
registered date, description text, type varchar(50), status varchar(20), PRIMARY KEY
(id)");
echo "Installed successfully! Please manually delete admin_setup.php !";
include("afooter");
?>
