<?php


    $database_naam = '';
    $database_login = '';
    $database_paswoord = '';
    $database_host = 'localhost';
    $export_file = 'export.sql';
    
	//Connect to DB the old fashioned way and get the names of the tables on the server
	$cnx = mysql_connect($database_host, $database_login, $database_paswoord) or die(mysql_error());
	mysql_select_db($database_naam, $cnx) or die(mysql_error());
    
    //=====


    $tab_status = mysql_query("SHOW TABLE STATUS");
    while($all = mysql_fetch_assoc($tab_status)):
        $tbl_stat[$all['Name']] = $all['Auto_increment'];
    endwhile;
    unset($backup);
    $tables = mysql_list_tables($database_naam);
    while($tabs = mysql_fetch_row($tables)):
        $backup .= "#\n#Table structure for `".$tabs[0]."`\n#\n\nDROP TABLE IF EXISTS `".$tabs[0]."`;\nCREATE TABLE `".$tabs[0]."` (";
        $res = mysql_query("SHOW CREATE TABLE ".$tabs[0]);
        while($all = mysql_fetch_assoc($res)):
            $str = str_replace("CREATE TABLE `".$tabs[0]."` (", "", $all['Create Table']);
            $str = str_replace(",", ",", $str);
            $str2 = str_replace("`) ) TYPE=MyISAM ", "`)\n ) TYPE=MyISAM ", $str);
            $backup .= $str2 . ";\n\n";
        endwhile;
        $backup .= "#\n#Data to be executed for table `$tabs[0]`\n#\n\n";
        $data = mysql_query("SELECT * FROM ".$tabs[0]);
        while($dt = mysql_fetch_row($data)):
            $backup .= "INSERT INTO `".$tabs[0]."` VALUES('".$dt[0]."'";
            for($i=1; $i<count($dt); $i++):
                $backup .= ', "' . str_replace('"', '\"', $dt[$i]) . '"';
            endfor;
            $backup .= ");\n";
        endwhile;
        $backup .= "\n# --------------------------------------------------------\n\n";
    endwhile;
    
    //PLEK WAAR HET BESTAND WORDT WEGGESCHREVEN MOET WRITE_ENABLED ZIJN (CHMOD +777)
    $fp = fopen($_SERVER['SERVER_NAME'] . '/rss/' . 'export.sql', "w");  
    fwrite($fp, $backup);  


?>

<?php include("_include-config.php");?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 


<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="content-type" content="text/html; charset=utf-8" /> 
<title>Pro-tuner-evolution.eu</title> 
<meta name="keywords" content="" /> 
<meta name="Everyday Series" content="" /> 
<link href="default.css" rel="stylesheet" type="text/css" media="screen" /> 
<script type="text/javascript"> 






var loadedobjects="" 
var rootdomain="http://"+window.location.hostname 


function ajaxpage(url, containerid){ 
var page_request = false 
if (window.XMLHttpRequest) // if Mozilla, Safari etc 
page_request = new XMLHttpRequest() 
else if (window.ActiveXObject){ // if IE 
try { 
page_request = new ActiveXObject("Msxml2.XMLHTTP") 
}  
catch (e){ 
try{ 
page_request = new ActiveXObject("Microsoft.XMLHTTP") 
} 
catch (e){} 
} 
} 
else 
return false 
page_request.onreadystatechange=function(){ 
loadpage(page_request, containerid) 
} 
page_request.open('GET', url, true) 
page_request.send(null) 
} 


function loadpage(page_request, containerid){ 
if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1)) 
document.getElementById(containerid).innerHTML=page_request.responseText 
} 


function loadobjs(){ 
if (!document.getElementById) 
return 
for (i=0; i<arguments.length; i++){ 
var file=arguments[i] 
var fileref="" 
if (loadedobjects.indexOf(file)==-1){ //Check to see if this object has not already been added to page before proceeding 
if (file.indexOf(".js")!=-1){ //If object is a js file 
fileref=document.createElement('script') 
fileref.setAttribute("type","text/javascript"); 
fileref.setAttribute("src", file); 
} 
else if (file.indexOf(".css")!=-1){ //If object is a css file 
fileref=document.createElement("link") 
fileref.setAttribute("rel", "stylesheet"); 
fileref.setAttribute("type", "text/css"); 
fileref.setAttribute("href", file); 
} 
} 
if (fileref!=""){ 
document.getElementsByTagName("head").item(0).appendChild(fileref) 
loadedobjects+=file+" " //Remember this object as being already added to page 
} 
} 
} 


now = new Date(); 
dif = now.getTime() - <?php echo time(); ?>*1000; 


function updateTime() { 
  now = new Date(); 
  now.setTime(now.getTime() - dif); 


  var hour = now.getHours(); 
  if(hour < 10) 
    hour = "0" + hour; 
  var minute = now.getMinutes(); 
  if(minute < 10) 
    minute = "0" + minute; 
  var second = now.getSeconds(); 
  if(second < 10) 
    second = "0" + second; 


  document.forms[0].elements[0].value = hour +":"+ minute +":"+ second; 
} 
setInterval("updateTime()",1000); 
</script>
</head> 
<body> 
<!-- start header --> 
<div id="header"> 
    <div id="logo"> 
        <h1><a href="#"><span>Pro-tun</span>er-evolution</a></h1> 
        <p>Designed By Free CSS Templates</p> 
    </div> 
</div> 
<!-- end header --> 
<div id="wrapper"> 
    <!-- start page --> 
    <div id="page"> 
    <div id="page-bg"> 
        <div id="sidebar1" class="sidebar"> 
            <ul> 
<?php            if($data) { 
echo '
    <li> 
                    <h2>Algemeen</h2> 
                    <ul> 
                        <li><a href="javascript:ajaxpage(\'home.php\', \'content\');">Home</a></li> 
                        <li><a href="javascript:ajaxpage('help.php', \'content\');">Help/Faq</a></li> 
                        <li><a href="javascript:ajaxpage(\'login.php?x=logout\', \'content\');">Logout</a></li> 
                         
                     
                    </ul> 
                </li> 
        <li> 
        <h2>User</h2> 
        <ul> 
        <li><a href="javascript:ajaxpage(\'hq.php\', \'content\');">Hoofdkwartier</a></li> 
        <li><a href="javascript:ajaxpage(\'list.php\', \'content\');">Member-list</a></li> 
        <li><a href="javascript:ajaxpage(\'shop.php\', \'content\');">Shop</a></li> 
        <li><a href="javascript:ajaxpage(\'bank.php\', \'content\');">Bank</a></li> 
       <li><a href="javascript:ajaxpage(\'casino.php\', \'content\');">casino</a></li> 
       <li><a href="javascript:ajaxpage('log.php', \'content\');">Logs</a></li>         
        <li><a href="javascript:ajaxpage(\'message.php\', \'content\');">Berichten</a></li> 
        <li><a href="javascript:ajaxpage(\'edit.php\', \'content\');">Profiel</a></li> 
        </ul></li> 
        <li> 
        <ul> 
        <li><h2>Clan</h2> 
        <ul><li><a href="javascript:ajaxpage(\'clan.php?p=list\', \'content\');">Clan list</a></li>';
   
            if ($data->clanlevel==0){  
                print ' <li><a href="javascript:ajaxpage(\'clan.php?p=join\', \'content\');">Aanmelden</a></li>';
}  
              if ($data->clanlevel & 0x01 ) 
    print'  <li><a href="javascript:ajaxpage(\'clan.php?p=new\', \'content\');">Nieuwe clan</a></li>';} 
    else{    
        print' <li><a href="javascript:ajaxpage(\'clan.php?p=.'$data->clan.'\', \'content\');">Clan list</a></li>';
	} 
             
             
                if ($data->clanlevel>=8)||($data->clanlevel==6) ( 
                print' <li><a href="javascript:ajaxpage(\'clanbank.php\', \'content\');">Bank</a></li>'; 
                print' <li><a href="javascript:ajaxpage(\'clanshop.php\', \'content\');">Bouwterrein</a></li>';
				}     if ($data->clanlevel>=8)||($data->clanlevel==2) { 
                    print' <li><a href="javascript:ajaxpage(\'clanhq.php?p=recruits\', \'content\');">Aanmeldingen</a></li>';
								} 
                    if ($data->clanlevel > 0) { 
                        ($data->clanlevel < 9) 
                        print' <li><a href="javascript:ajaxpage(\'clan.php?p=quit\', \'content\');">Stap uit je clan </a></li>';
                } 
                else { 
		print' <li><a href="javascript:ajaxpage(\'clan.php?p=delete\', \'content\');">Verwijder clan</a></li>'; 
                } 
                }
                echo '</li></ul>'; 


                if ($data->level & 0x80){  
?>
                    <ul><li><h2>Admin</a> 
                    <li><a href="javascript:ajaxpage('admin.php?p=search', 'content');">Zoek/bewerk speler</a></li> 
                    <li><a href="javascript:ajaxpage('admin.php?p=massmsg', 'content');">Massa bericht</a></li>                 
                    <li><a href="javascript:ajaxpage('admin.php?p=adminmsg', 'content');">Admin bericht</a></li>  
                    <li><a href="javascript:ajaxpage('admin.php?p=donate', 'content');">Doneer speler</a></li></li></ul> 
<?php 
                } 
                else { print" \n";} 
                  
                 else { 
echo ' 
<ul><li><h2>Algemeen</h2>  
<li><a href="javascript:ajaxpage(\'home.php\', \'content\');">Home</a></li> 
<li><a href="javascript:ajaxpage(\'help.php\', \'content\');">Help/Faq</a></li>                      
<li><a href="javascript:ajaxpage('login.php', \'content\');">login</a></li> 
<li><a href="javascript:ajaxpage('signup.php', \'content\');">Aanmelden</a></li></li</ul>';


}                          
    }                  
    ?>                   
                      
                      
                      
                      
                     
                  
                  
                  
                  
                   
        </div> 
        <!-- start content --> 
        <div id="content"> 


             
             
             
        </div> 
        <!-- end content --> 
        <!-- start sidebars --> 
        <div id="sidebar1" class="sidebar"> 
            <ul> 
                <li> 
                     
                        <div> 
                            <h2>info</h2> 


                        </div> 
                     
                </li> 
                 
                     
            </ul> 
        </div> 
        <!-- end sidebars --> 
        <div style="clear: both;"> </div> 
    </div> 
    </div> 
    <!-- end page --> 
</div> 
<div id="footer"> 
    <p class="copyright">©  2009 All Rights Reserved  •  Design by <a href="#">Deathkill</a>.</p> 
     
</div> 
</body> 
</html>