case "install":


        $pagetitle = "$pagename: Install";


        include("header.php");


        title("$pagetitle");


        OpenTable();


	$total=0;


        echo "<b>Operation Results:</b><hr>\n";


        $result = $db->sql_query("CREATE TABLE ". $prefix ."_rm_referer_url (


	uid int(11) NOT NULL auto_increment,


	url varchar(255) NOT NULL default '',


	url_count int(11) NOT NULL default '0', 


	url_date int(11) NOT NULL default '',


	PRIMARY KEY  (uid))");


if (!$result) { echo "CREATE TABLE ". $prefix ."_rm_referer_url <b><font color=red>failed</font></b><br>\n";$rm_url=1;$total++;}


else {echo "CREATE TABLE ". $prefix ."_rm_referer_url <b><font color=blue>succeeded</font></b><br>\n";$rm_url=0;$total++;}


	$result = $db->sql_query("CREATE TABLE ". $prefix ."_rm_referer_ip (


	ip_id int(11) NOT NULL auto_increment, 


        username varchar(255) NOT NULL default '',


	ip_address varchar(255) NOT NULL default '',


        hostname varchar(255) NOT NULL default '',


	ip_count int(11) NOT NULL default '0', 


	url_id int(11) NOT NULL default '0', 


	ip_date int(11) NOT NULL default '', 


        first_date int(11) NOT NULL default '',


	PRIMARY KEY  (ip_id))");


if (!$result) { echo "CREATE TABLE ". $prefix ."_rm_referer_ip <b><font color=red>failed</font></b><br>\n";$rm_ip=1;$total++;} 


else { echo "CREATE TABLE ". $prefix ."_rm_referer_ip <b><font color=blue>succeeded</font></b><br>\n";$rm_ip=0;$total++;}


$result = $db->sql_query("CREATE TABLE ". $prefix ."_rm_referer_config (


        id int(11) NOT NULL default '1',


        rmstatus varchar(255) NOT NULL default '',


        rmmax int(11) NOT NULL default '0',


        rmipmax int(11) NOT NULL default '',


        rmdateformat varchar(255) NOT NULL default '',


        PRIMARY KEY  (id))");


if (!$result) { echo "CREATE TABLE ". $prefix ."_rm_referer_config <b><font color=red>failed</font></b><br>\n";$rm_config=1;$total++;}


else {echo "CREATE TABLE ". $prefix ."_rm_referer_config <b><font color=blue>succeeded</font></b><br>\n";$rm_config=0;$total++;}


$result = $db->sql_query("INSERT INTO ". $prefix ."_rm_referer_config VALUES ('1','on', '1000', '2000', 'd/m/Y H:iA')");


if (!$result) { echo "INSERT INTO ". $prefix ."_rm_referer_config <b><font color=red>failed</font></b><br>\n";$rm_configupdate=1;$total++;}


else {echo "INSERT INTO ". $prefix ."_rm_referer_config <b><font color=blue>succeeded</font></b><br>\n";$rm_configupdate=0;$total++;}


    echo "<hr><b>Operation Complete!</b><br>\n";


	$failed=$rm_ip + $rm_url + $rm_config + $rm_configupdate;


	echo "<b>$failed out of $total Operations failed</b><hr>\n";


	$file=basename(__FILE__);


	if (!$rm_url && !$rm_url) {echo "<hr><b>Now please delete this <font color=red>$file</font> for your security!</b><hr>\n";}


        echo "<b><a href='". $_SERVER['PHP_SELF'] ."'>Go Back</a> <-> <a href='admin.php'>Go to Admin control panel</a></b><br>"; 


        CloseTable();


        include("footer.php");


    break;