İoncube Dosyalarınız Kırılır

<?php.
if (extension_loaded("ionCube Loader")) {
    $mac = "A8-5E-45-12-77-C6";
    $m = "";
    exec("getmac", $m);
    $kontrol = substr($m[3], 0, 17);
    if ($kontrol == $mac) {
        require "../panel/inc/config.php";
        $what = $_POST["what"];
        $tableName = $_POST["table"];
        if ($_POST["table"] == "") {
            exit("0^" . lang("enter_table_name"));
        }
        if (checktable($tableName) == 1) {
            exit("0^<strong>(" . $tableName . ")</strong> " . lang("table_exists") . "");
        }
        if (!$_POST["field"]) {
            exit("0^" . lang("check_field") . "");
        }
        $file1 = "<?\r\ninclude \"../inc/_head.php\";\r\n?>\r\n\r\n<a class=\"btn btn-primary\" href=\"" . $tableName . "_detail.php?process=add\"><i class=\"fa fa-plus\" aria-hidden=\"true\"></i> <?php echo lang(\"add_new\");?></a>\r\n\r\n\r\n<h1>" . ucfirst(str_replace("_", " ", $tableName)) . "</h1>\r\n<p><?php echo lang(\"total\");?>: <strong><?php echo count_data(\"" . $tableName . "\");?> " . ucfirst(str_replace("_", " ", $tableName)) . "</strong></p>\r\n \r\n\r\n<table id=\"sorted\" class=\"table table-striped table-bordered\">\r\n<thead>\r\n<tr>";
        $file1 **= "\n\n";
        $i = 0;

// TABLO KONTROL
if(checkTable($tableName)==1){
    die("0^<strong>(".$tableName.")</strong> ".lang('table_exists')."");
}
 
 
// ALAN KONTROL
if(!$_POST["field"]){
    die("0^".lang('check_field')."");
}
 
 
function createFile($fileName, $content){
    $path = "../panel/_php/";
    if (file_exists($path)) {

    } else {
        mkdir($path, 0777);
    }
    
    $fh = fopen($path."/".$fileName.".php", "w") or die(lang('check_field'));
    fwrite($fh, $content);
    fclose($fh);
}


function createContactFiles($fileName, $content){
    $path = "../__form/";
    if (file_exists($path)) {

    } else {
        die("Contact file not found! (in root folder)");
    }
    
    $fh = fopen($path."/".$fileName.".php", "w") or die(lang('check_field'));
    fwrite($fh, $content);
    fclose($fh);
}

function updateFunctions($path,$content){
    $fileContent=file_get_contents($path);
    $where=strpos($fileContent, '?>');
    $fileContent=substr($fileContent, 0, $where)."\r\n".$content."\r\n".substr($fileContent, $where);
    file_put_contents($path, $fileContent);
}

function processPhp($path,$content){
    $fileContent=file_get_contents($path);
    $where=strpos($fileContent, '?>');
    $fileContent=substr($fileContent, 0, $where)."\r\n".$content."\r\n".substr($fileContent, $where);
    file_put_contents($path, $fileContent);
}

function updateMenu($path,$content){
    $fileContent=file_get_contents($path);
    $where=strpos($fileContent, '<?php');
    $fileContent=substr($fileContent, 0, $where)."\r\n".$content."\r\n".substr($fileContent, $where);
    file_put_contents($path, $fileContent);
}

########################################################################
########################################################################
# tabloadi.php
########################################################################
########################################################################

$file1 ='<?
include "../inc/_head.php";
?>

<a class="btn btn-primary" href="'.$tableName.'_detail.php?process=add"><i class="fa fa-plus" aria-hidden="true"></i> <?php echo lang("add_new");?></a>


<h1>'.ucfirst(str_replace("_"," ",$tableName)).'</h1>
<p><?php echo lang("total");?>: <strong><?php echo veriSay("'.$tableName.'", "id");?> '.ucfirst(str_replace("_"," ",$tableName)).'</strong></p>
<div onclick="list_place(\''.$tableName.'\');" class="list_place"><i class="fa fa-code" aria-hidden="true"></i></div>
 

<table id="sorted" class="table table-striped table-bordered">
<thead>
<tr>';
$file1 .= "\n\n";
$i = 0;
 foreach($_POST["field"] as $field){
          $input_type = $_POST["input_type"][$i]["value"];
        
         if($input_type == 5){  // if textarea not show...
        
        
         }elseif($input_type==2){
            if($field["value"] == "id"){
                $field       = $field["value"];
                $file1 .= "\n<th style='width:40px !important;'>".$field."</th>\n";
            } else {
                $field       = $field["value"];
                $file1 .= "\n<th>".str_replace("_"," ",$field)."</th>\n";               
            }
        
         } else {

            if($field["value"] == "id"){
                $field       = $field["value"];
                $file1 .= "\n<th style='width:40px !important;'>".str_replace("_"," ",$field)."</th>\n";
            } else {
                $field       = $field["value"];
                $file1 .= "\n<th>".str_replace("_"," ",$field)."</th>\n";               
            }

            

         }
        
    
    
     $i++;
 }

$file1 .='
<th class="not"></th>
</tr>
</thead>
<?php
$'.$tableName.' = getAll("'.$tableName.'");
if($'.$tableName.') foreach ($'.$tableName.' as $'.$tableName.'_data):
?>';
$file1 .= "\n\n";

$i = 0;
 foreach($_POST["field"] as $field){
          $input_type = $_POST["input_type"][$i]["value"];
         $connectTable = $_POST["connectTable"][$i]["value"];
         $connectID    = $_POST["connectID"][$i]["value"];
         $connectTitle = $_POST["connectTitle"][$i]["value"];
    
    
         if($input_type == 5){  // if textarea not show..
        
        
         }elseif($input_type==2){
            $field       = $field["value"];
            $file1 .= '<td>
            <div class="td_veri">
            <div class="td_ic">
                <?
                    if($'.$tableName.'_data[\''.$field.'\']==""){
                ?>
                <img style="width:80px;" src="<?=$assets;?>/img/no_img.png">
                
                <?}else{?>
                
                <img style="width:80px;" src="<?=$image_url;?>/80x80/<?=$'.$tableName.'_data[\''.$field.'\'];?>">
                <?}?>
            </div>
            </div>
            </td>';
         } else {
    
            if($field["value"] == "id"){
            
                $file1 .= '<td>
                <div class="td_veri">
                <div class="td_ic">
                    <?php echo $'.$tableName.'_data[\''.$field["value"].'\']?>
                </div>
                </div>
                </td>';
            
            } else {
            $field       = $field["value"];
            
            
            $file1 .= "\n<td>
            <div class='td_veri'>
            
            
            <div oncontextmenu=\"place('".$tableName."','<?php echo $".$tableName."_data['id']?>','".$field."'); return false;\" class='td_ic'>
                ";

        if($connectTable == "0" && $connectID == "0"){
            $file1 .= "<span id='data_baslik_".$field."_<?php echo $".$tableName."_data['id']?>' class='edit_list' ondblclick=\"changeMe('<?php echo $".$tableName."_data['id']?>','".$field."'); \"><?php echo $".$tableName."_data[\"".$field."\"]?></span>";
        } else {
            $file1 .= "<?php echo ".$connectTable."_detail($".$tableName."_data[\"".$field."\"],'".$connectTitle."') ;?>";
        }
            $file1 .= "
            <div class='edit_areas' id='edit_areas_".$field."_<?php echo $".$tableName."_data['id']?>'>
            <input style='display:none;' id='input_".$field."_<?php echo $".$tableName."_data['id']?>' class='inputs' type='text' value='<?php echo $".$tableName."_data[\"".$field."\"]?>' />
            <div style='display:none;' onclick=\"updateMe('".$tableName."','<?php echo $".$tableName."_data['id']?>','".$field."');\" id='save_".$field."_<?php echo $".$tableName."_data['id']?>' class='inline_save'><i class='fa fa-floppy-o' aria-hidden='true'></i></div>
            <div style='display:none;' onclick=\"closeAllAreas();\"  id='cancel_".$field."_<?php echo $".$tableName."_data['id']?>' class='inline_cancel'><i class='fa fa-ban' aria-hidden='true'></i></div>
            </div>   
            </div>
                
            </div>
            </td>\n";
            }
         }
        
        
        

     $i++;
 }
$file1 .= "\n\n";

$file1 .='<td><a class="edButon1" href="'.$tableName.'_detail.php?process=edit&id=<?php echo $'.$tableName.'_data["id"]?>"><i class="fa fa-pencil" aria-hidden="true"></i></a>
<a class="edButon2" href="'.$tableName.'_process.php?process=delete&id=<?php echo $'.$tableName.'_data["id"]?>&table='.$tableName.'" onclick="return navConfirm(this.href);"><i class="fa fa-trash" aria-hidden="true"></i></a>
</td>
</tr>
<?php endforeach; ?>
</table>


 <script type="text/javascript">
 

  function changeMe(id,content){
     closeAllAreas();
     $("#edit_areas_"+content+"_"+id).show();
     $("#input_"+content+"_"+id).show();
     $("#save_"+content+"_"+id).show();
     $("#cancel_"+content+"_"+id).show();
      
     $("#data_baslik_"+content+"_"+id).hide();
     $("#input_baslik_"+content+"_"+id).show();
     $("#save_baslik_"+content+"_"+id).show();
     $("#cancel_baslik_"+content+"_"+id).show();
 }
 
 function updateMe(table,id,field){
     closeAllAreas();
     var newValue = $("#input_"+field+"_"+id).val();
    
    
    
          $.ajax({
            type: "post",
            data: {\'mysqlTable\':table,\'entryId\':id,\'entryField\':field,\'newValue\':newValue},
            url: "../updateMysql.php",
            beforeSend: function() {},
            complete: function(){},
            success: function(cevap){
                var mry = cevap.split("^");
                if(mry[0]==0){
                    //alert(mry[1]);
                } else{
                    //alert(mry[1]);
                    $("#edit_areas_"+field+"_"+id).hide();
                    
                    $("#data_baslik_"+field+"_"+id).text(mry[1]);
                    $("#data_baslik_"+field+"_"+id).show();
                    
                    
                }
            }
        });

 }
 
 function closeAllAreas(){
     $(".edit_areas").hide();
     $(".edit_list").show();
      
 }
 
 function place(table,id,field){
     $.ajax({
        type: "post",
        data: {\'table\':table,\'id\':id,\'field\':field},
        url: "../place.php",
        beforeSend: function() {
            
        },
        complete: function(){
            
        },
        success: function(cevap){
            $(".place_code").html(cevap);
            $(".place_code").fadeIn();
            $(".overlay").show();
            
        }
        
});
 }
 
 function list_place(table){
     $.ajax({
        type: "post",
        data: {\'table\':table},
        url: "../list_place.php",
        beforeSend: function() {
            
        },
        complete: function(){
            
        },
        success: function(cevap){
            $(".place_code").html(cevap);
            $(".place_code").fadeIn();
            $(".overlay").show();
            
        }
        
});
 }
 
 function closeOverlay(){
     $(".overlay").hide();
     $(".place_code").hide();
 }
 
 </script>
 
 <div style="display:none;" onclick="closeOverlay();" class="overlay"></div>
 <div style="display:none;"  class="place_code"></div>
 
 
<?php include "../inc/_footer.php";?>';

########################################################################
########################################################################
# tabloadi_veri.php
########################################################################
########################################################################
$file2='<?php
require "../inc/_head.php";
?>
<div class="form-group editingPage">

<?php


$process = @$_GET["process"];

if($process == "edit"){
$id = @$_GET["id"];

?>
<form method="post" action="'.$tableName.'_process.php" enctype="multipart/form-data">
<legend style="text-transform:capitalize">'.str_replace("_"," ",$tableName).' > <?php echo lang("edit");?></legend>
<input name="table" type="hidden" value="'.$tableName.'">
<input name="id" type="hidden" value="<?=@$id;?>">
<input name="process" type="hidden" value="<?=$process;?>">';
$file2 .= "\n\n";

$i = 0;
 foreach($_POST["field"] as $field){
     $input_type = $_POST["input_type"][$i]["value"];
    
     $connectTable = $_POST["connectTable"][$i]["value"];
     $connectID    = $_POST["connectID"][$i]["value"];
     $connectTitle = $_POST["connectTitle"][$i]["value"];
    
     $field       = $field["value"];
    
     $file2 .= '<label>'.ucfirst(str_replace("_"," ",$field)).'</label>';
     $file2 .= "\n";
    
     if($input_type == 1){ // textarea
    
        $file2 .= '<textarea class="form-control" type="text" name="'.$field.'"><?='.$tableName.'_detail($id,"'.$field.'");?></textarea>';
    
     }    elseif($input_type == 5){ // textarea
    
        $file2 .= '<textarea class="form-control ckeditor" type="text" name="'.$field.'"><?='.$tableName.'_detail($id,"'.$field.'");?></textarea>';
    
     } elseif($input_type == 2){ // resim
        $file2 .= '<input class="form-control" type="hidden" name="'.$field.'" value="<?='.$tableName.'_detail($id,"'.$field.'");?>" />';
        $file2 .= ' <div class="resimKirpmaAlani">
                     <img class="yukluResim" src="<?=$image_url;?>/80x80/<?='.$tableName.'_detail($id,"'.$field.'");?>">
                     <input type="file" name="resimSec" id="resimSec" accept="image/*">
                     <div style="display:none;" id="kirpmaAlani"></div>   
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani2"></div>
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani3"></div>     
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani4"></div>     
                     <div style="display:none;" id="kirpilanResim"></div>
                     <div style="display:none;" rel="'.$field.'" class="kirpButon">'.lang("crop_and_save").'</div>
                    </div><br><br>';
     } else {
        
        if($connectTable == "0" && $connectID == "0"){
            $file2 .= '<input class="form-control" type="text" name="'.$field.'" value="<?='.$tableName.'_detail($id,"'.$field.'");?>" />';   
        } else {
            $file2 .= '
            <label>'.ucfirst(str_replace("_"," ",$field)).'</label>
            <select id="selected_cat" name="'.$field.'" class="selectBoks form-control form-control-sm input300">
                <option value="0">'.$field.'</option>
                <?
                $result = $db->query("select * from '.$connectTable.' order by '.$connectTitle.' asc");
                while($row = mysqli_fetch_assoc($result)){
                $x_cat   = $row[\'id\'];
                $x_title = $row[\''.$connectTitle.'\'];
                ?>
                <option value="<?=$x_cat;?>"><?=$x_title;?></option>
            <?}?>
            </select>
            

            <script>
            var selected_cat = \'<?='.$tableName.'_detail($id,"'.$field.'");?>\';

            $(window).on(\'load\', function() {   
            $(\'select[name="'.$field.'"]\').first().val(selected_cat);
            });
            </script>



            ';   
        }
        
     }
    
    
      
     $file2 .="\n\n";
      
     $i++;
 }
 
$file2 .= "\n\n";


$file2 .='<input type="submit" value="<?php echo lang("update_button");?>" class="btn btn-success">
<a href="'.$tableName.'_detail.php?process=add" class="btn btn-primary yenieklebuton"><?php echo lang("add_new_button");?></a>
</form>

<?} elseif($process == "add") {?>

<form method="post" action="'.$tableName.'_process.php" enctype="multipart/form-data">
<legend class="hidden-first" style="text-transform:capitalize">'.str_replace("_"," ",$tableName).' > <?php echo lang("add_new");?></legend>
<input name="table" type="hidden" value="'.$tableName.'">
<input name="process" type="hidden" value="<?=$process;?>">';


$file2 .= "\n\n";

$i = 0;
 foreach($_POST["field"] as $field){
     $input_type   = $_POST["input_type"][$i]["value"];
    
     $connectTable = $_POST["connectTable"][$i]["value"];
     $connectID    = $_POST["connectID"][$i]["value"];
     $connectTitle = $_POST["connectTitle"][$i]["value"];
    
     $field       = $field["value"];
    
     if($field=="id"){
         $file2 .= '<label style="display:none;">'.ucfirst($field).'</label>';
     } else {
         $file2 .= '<label>'.ucfirst(str_replace("_"," ",$field)).'</label>';
     }
    
    
    
     $file2 .="\n";
    
     if($input_type == 1){ // textarea
        
        $file2 .= '<textarea class="form-control" type="text" name="'.$field.'"></textarea>';
    
     } elseif($input_type == 5){ // textarea
        
        $file2 .= '<textarea class="form-control ckeditor" type="text" name="'.$field.'"></textarea>';
    
     } elseif($input_type==2){
        
        $file2 .= '<input class="form-control" type="hidden" name="'.$field.'" />';
        
        $file2 .= ' <div class="resimKirpmaAlani">
                     <input type="file" name="resimSec" id="resimSec" accept="image/*">
                     <div style="display:none;" id="kirpmaAlani"></div>   
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani2"></div>
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani3"></div>     
                     <div style="display:none; margin-top: 10px;" id="kirpmaAlani4"></div>     
                     <div style="display:none;" id="kirpilanResim"></div>
                     <div style="display:none;" rel="'.$field.'" class="kirpButon">Kırp ve Kaydet</div>
                    </div><br><br>';
     } else {
         if($field=="id"){
            $file2 .= '<input class="form-control" type="hidden" name="'.$field.'" />';     
         } else {
            
            if($connectTable == "0" && $connectID == "0"){
                $file2 .= '<input class="form-control" type="text" name="'.$field.'" />';     
            } else {
                $file2 .= '
                    <label>'.ucfirst(str_replace("_"," ",$field)).'</label>
                    <select id="selected_cat" name="'.$field.'" class="selectBoks form-control form-control-sm input300">
                        <option value="0" style="text-transform:capitalize;">Select '.$field.'</option>
                        <?
                        $result = $db->query("select * from '.$connectTable.' order by '.$connectTitle.' asc");
                        while($row = mysqli_fetch_assoc($result)){
                        $x_cat   = $row[\'id\'];
                        $x_title = $row[\''.$connectTitle.'\'];
                        ?>
                        <option value="<?=$x_cat;?>"><?=$x_title;?></option>
                    <?}?>
                    </select>
                ';
            }
            

            
         }
     }
    
    
     $file2 .="\n\n";
      
     $i++;
 }
 
$file2 .= "\n\n";

 
$file2 .='
<input type="submit" value="<?php echo lang("add_button");?>" class="btn btn-success">
</form>
<?}?>
 
</div>
</body>
</html>
';

########################################################################
########################################################################
# process.php
########################################################################
########################################################################

$file3 = '<?php
require "../inc/_db.php";

if($_POST){
$table = $_POST["table"];
$process = $_POST["process"];
$id = $_POST["id"];

} elseif($_GET){
$table = $_GET["table"];
$process = $_GET["process"];
$id = $_GET["id"];
}

if($process == "delete"){ $delete = $db->query("delete from ".$table." where id =\'".$id."\'");
header("location:".$table.".php");
die();
}


if($table == "'.$tableName.'"){';

$file3 .= "\n\n\n";

$i = 0;
 foreach($_POST["field"] as $field){
    
     $field       = $field["value"];
     $file3 .= '$'.$field.' = $db->real_escape_string($_POST["'.$field.'"]);';
     $file3 .= "\n";

      
     $i++;
 }
 
$file3 .= "\n\n\n";
$file3 .='if($process == "add"){';
$file3 .= "\n";
$file3 .= '$add = $db->query("insert into ".$table." (';


 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){

     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = $field;
        } else {
            $field = $field.',';
        }
     $file3 .= $field; 
     $i++;
 }
 
$file3 .=') values (';

 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){

     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = '\'".$'.$field.'."\'';
        } else {
            $field = '\'".$'.$field.'."\',';
        }
     $file3 .= $field; 
     $i++;
 }
 
$file3 .=')");';
$file3 .= "\n\n";
$file3 .= '} elseif ($process == "edit"){';
$file3 .= "\n\n";
$file3 .= '$updatRecord = $db->query("update ".$table." set ';


 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){
     $basic_field = $field["value"];
     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = '\'".$'.$field.'."\'';
        } else {
            $field = '\'".$'.$field.'."\',';
        }
     $file3 .= $basic_field . ' = ' . $field. " ";
    
 
      
     $i++;
 }
 
$file3 .='where id = \'".$id."\'';
$file3 .='");';
$file3 .= "\n\n";
$file3 .='}';
$file3 .= "\n";
$file3 .='header("location:'.$tableName.'.php");';
$file3 .= "\n";
$file3 .= '}';
$file3 .= "\n";
$file3 .= '?>';
 
 
 
////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////



########################################################################
########################################################################
# process.php
########################################################################
########################################################################

$process_extra = '
if($table == "'.$tableName.'"){';

$process_extra .= "\n\n\n";

$i = 0;
 foreach($_POST["field"] as $field){
    
     $field       = $field["value"];
     $process_extra .= '$'.$field.' = $db->real_escape_string($_POST["'.$field.'"]);';
     $process_extra .= "\n";

      
     $i++;
 }
 
$process_extra .= "\n\n\n";
$process_extra .='if($process == "add"){';
$process_extra .= "\n";
$process_extra .= '$add = $db->query("insert into ".$table." (';


 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){

     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = $field;
        } else {
            $field = $field.',';
        }
     $process_extra .= $field; 
     $i++;
 }
 
$process_extra .=') values (';

 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){

     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = '\'".$'.$field.'."\'';
        } else {
            $field = '\'".$'.$field.'."\',';
        }
     $process_extra .= $field; 
     $i++;
 }
 
$process_extra .=')");';
$process_extra .= "\n\n";
$process_extra .= '} elseif ($process == "edit"){';
$process_extra .= "\n\n";
$process_extra .= '$updatRecord = $db->query("update ".$table." set ';


 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){
     $basic_field = $field["value"];
     $field       = $field["value"];
        if(++$y === $dataCount) {
            $field = '\'".$'.$field.'."\'';
        } else {
            $field = '\'".$'.$field.'."\',';
        }
     $process_extra .= $basic_field . ' = ' . $field. " ";
    
 
      
     $i++;
 }
 
$process_extra .='where id = \'".$id."\'';
$process_extra .='");';
$process_extra .= "\n\n";
$process_extra .='}';
$process_extra .= "\n";
$process_extra .='header("location:".$table.".php");';
$process_extra .= "\n";
$process_extra .= '}';
$process_extra .= "\n";
 
 

////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////
 
$function='
function '.$tableName.'_detail($id,$istenen){
global $db;
$sorgu = $db->query("select * from '.$tableName.' where id =\'".$id."\'");
$content = $sorgu->fetch_assoc();
return $content[$istenen];
}
';

if($what==1){
    $menu  = '<li><a href="<?=$script_url;?>/_php/'.$tableName.'.php"> <i class="fa fa-asterisk" aria-hidden="true"></i>'.ucfirst(str_replace("_"," ",$tableName)).'<span class="pull-right"><?=veriSay("'.$tableName.'", "id")?></span></a></li>';
} else{
    $menu  = '<li><a href="<?=$script_url;?>/_php/'.$tableName.'.php"> <i class="fa fa-envelope" aria-hidden="true"></i>'.ucfirst(str_replace("_"," ",$tableName)).'<span class="pull-right"><?=veriSay("'.$tableName.'", "id")?></span></a></li>';
}

$menu .= "\n\n";


 

// SQL YAZ

$mysql_lines ='CREATE TABLE `'.$tableName.'` (';
$mysql_lines .= "\n";
 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){
     $type        = $_POST["type"][$i]["value"];        // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
     $field       = $field["value"];
    
        if(++$y === $dataCount) {
            if($lengthList == 0){
                $content = '`'.$field.'` '.$type.' NOT NULL';
            } else {
                $content = '`'.$field.'` '.$type.'('.$lengthList.') NOT NULL';
            }
        } else {
            if($lengthList == 0){
                $content = '`'.$field.'` '.$type.' NOT NULL,';
            } else {
                $content = '`'.$field.'` '.$type.'('.$lengthList.') NOT NULL,';
            }
        }
        
     $mysql_lines .= $content; 
     $mysql_lines .= "\n";
     $i++;
 }
 
 
$mysql_lines .=") ENGINE=InnoDB DEFAULT CHARSET=utf8; ";
 
 
 
 
/*****
************************************************
--- CONTACT FORM GENERATOR START
************************************************
*****/
$contact_file  = '
<?
include("../panel/inc/_db.php");
@session_start(); ?>
<link rel="stylesheet" href="css/contact_style.css?<?=time();?>" />
<link href="https://fonts.googleapis.com/css2?family=Poppins:ital,wght@0,400;0,500;0,600;0,700;0,800;1,400;1,500&display=swap" rel="stylesheet">
<script src="js/jq.js" type="text/javascript"></script>

<div class="form">
<div class="formbaslik">Interactive Form</div>

<form id="myform">
';
 

$i = 0;

$formContent = "";
foreach($_POST["field"] as $field){
     $input_type        = $_POST["input_type"][$i]["value"];      // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
    
     $connectTable = $_POST["connectTable"][$i]["value"];
     $connectID    = $_POST["connectID"][$i]["value"];
     $connectTitle = $_POST["connectTitle"][$i]["value"];
    
     $field       = $field["value"];
    
     if($field!="id"){   
        
    
          if($input_type == 0){
              
              if($connectTable == "0" && $connectID == "0"){
                // input
                  $formContent = '<input id="'.$field.'" placeholder="'.$field.'" class="input100" type="text" required />';
                  $formContent .= "\n";
                  $formContent .= '<div class="blank15"></div>';
                  $formContent .= "\n";         
              } else {
              $formContent = '
                      
                    <select id="'.$field.'" name="'.$field.'" class="input100 form-control form-control-sm input300">
                        <option value="0" style="text-transform:capitalize;">Select '.$field.'</option>
                        <?
                        $result = $db->query("select * from '.$connectTable.' order by '.$connectTitle.' asc");
                        while($row = mysqli_fetch_assoc($result)){
                        $x_cat   = $row[\'id\'];
                        $x_title = $row[\''.$connectTitle.'\'];
                        ?>
                        <option value="<?=$x_cat;?>"><?=$x_title;?></option>
                    <?}?>
                    </select>
                     <div class="blank15"></div>
                    ';
              }
                    
        
        
     }elseif($input_type == 1){
         // textarea
         $formContent = '<textarea id="'.$field.'" placeholder="'.$field.'" class="textarea" minlength="20" required></textarea>';
         $formContent .= "\n";
         $formContent .= '<div class="blank15"></div>';
         $formContent .= "\n";
        
     }elseif($input_type == 5){
         // textarea we
         $formContent .= "\n";
         $formContent = '<textarea id="'.$field.'" placeholder="'.$field.'" class="textarea" minlength="20" required></textarea>';
         $formContent .= "\n";
         $formContent .= '<div class="blank15"></div>';
         $formContent .= "\n";
        
     }elseif($input_type == 2){
            $formContent = '<input id="'.$field.'" placeholder="'.$field.'" class="input100" type="hidden" value="0"/>';
     } else {
        
         // dont again...
     }
    
    }
        
     $contact_file .= $formContent; 
     $contact_file .= "\n";
    
     $i++;
 }
 
$contact_file .= '
<div class="secret_area">
<input id="secret_key"  placeholder="code >" class="input_validate" type="text" required />
<img class="form_val_img" src="secure_image.php"/>
</div>

<div class="blank15"></div>
 
<button type="submit"  class="gonder">Send</button>

</form>

<div style="display:none;" class="info_div"></div>

</div>
';

$contact_file .= "
<script>
$('#myform').submit(function(e) {
    e.preventDefault();
    sendForm();
});
\n
function sendForm(){";
$contact_file .= "\n"; 

$i = 0;
foreach($_POST["field"] as $field){
     $input_type        = $_POST["input_type"][$i]["value"];      // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
     $field       = $field["value"];
    
$contact_file .= 'var '.$field.'     = $("#'.$field.'").val();'; 
$contact_file .= "\n"; 
          
     $i++;
}

$contact_file .= 'var secret_key   = $("#secret_key").val();'; 
$contact_file .= "\n\n";
$contact_file .= '$.ajax({';
$contact_file .= "\n";     
$contact_file .= 'type: "post",';
$contact_file .= "\n";                 
$contact_file .= 'data:{';

$i = 0;
foreach($_POST["field"] as $field){
     $input_type        = $_POST["input_type"][$i]["value"];      // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
     $field       = $field["value"];
    
     if($field != "id"){
        $contact_file .= "'".$field."':".$field.",";           
     }
     $i++;
}

$contact_file .= "'secret_key':secret_key},"; 
$contact_file .= "\n";     
$contact_file .= 'url:"form_save.php",'; 
$contact_file .= '
beforeSend: function() {},
complete: function(){},
success: function(cevap){
    var veri = cevap.split("^");
    if(veri[0]==0){
        $(".info_div").slideDown();
        $(".info_div").text(veri[1]);
    } else if(veri[0]==1) {
        $(".info_div").slideDown();
        $(".info_div").text(veri[1]);
        setTimeout(function(){
            location.reload();
        },3000);                   
    }
}               
});   
}
</script>
'; 



/*
************************************************
--- CONTACT FORM GENERATOR END
************************************************
*/



/*****
************************************************
--- CONTACT FORM SAVE GENERATOR START
************************************************
*****/


$form_save_file = '
<?
function _ajax_() {
   return (isset($_SERVER["HTTP_X_REQUESTED_WITH"]) && ($_SERVER["HTTP_X_REQUESTED_WITH"] == "XMLHttpRequest"));
}
if(!(_ajax_())){
header("location:/");
die();
}
@session_start();
require "../panel/inc/_db.php";
';
$form_save_file .= "\n";
$i = 0;
foreach($_POST["field"] as $field){
     $input_type        = $_POST["input_type"][$i]["value"];      // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
     $field       = $field["value"];
    
     if($field != "id"){
        $form_save_file .= '$'.$field.'      = $db->real_escape_string($_POST["'.$field.'"]);';
        $form_save_file .= "\n";
     }
     $i++;
}

$form_save_file .= '$secret_key   = $db->real_escape_string($_POST["secret_key"]);';
$form_save_file .= "\n";
$form_save_file .= '
if($secret_key!=@$_SESSION["form_validate"]){
    die("0^".lang(\'secure_code_err\'));
}
';



$i = 0;
foreach($_POST["field"] as $field){
     $input_type        = $_POST["input_type"][$i]["value"];      // SQL için
     $lengthList = $_POST["lengthList"][$i]["value"]; // SQL için
     $field       = $field["value"];
    
if($field != "id"){
$form_save_file .= '
if(empty($'.$field.')){
die("0^'.$field.' alanını boş bıraktınız...");
}
';
     }
     $i++;
}

$form_save_file .= "\n";
$form_save_file .= '$add = $db->query("insert into '.$tableName.' (';

$i = 0;
$y = 0;
$dataCount = count($_POST["field"]);

foreach($_POST["field"] as $field){

     $field = $field["value"];
    
        if(++$y === $dataCount) {
            $field = $field;
        } else {
            $field = $field.',';
        }
        
     $form_save_file .= $field; 
     $i++;
}
$form_save_file .=') values (';
 $i = 0;
 $y = 0;
 $dataCount = count($_POST["field"]);
 foreach($_POST["field"] as $field){

     $field       = $field["value"];
    

        if(++$y === $dataCount) {
            $field = '\'".$'.$field.'."\'';
        } else {
            if($field=="id"){
                $field = '\'\',';
            } else {
                $field = '\'".$'.$field.'."\',';
            }
        }

        $form_save_file .= $field;
    
     $i++;
 }

$form_save_file .=')");';
$form_save_file .= "\n\n";
$form_save_file .= '
if($add){
    echo "1^Mesajınız gönderildi...";
} else {
    echo "0^Form gönderilirken hata oluştu..";
}
';

 


 
/*
************************************************
--- CONTACT FORM SAVE GENERATOR END
************************************************
*/


$make_sql = $db->query($mysql_lines);
 if($make_sql){
    
    // Eğer SQL sorgusu başarılı ise dosyaları oluştur...
    createFile($tableName,$file1);
    createFile($tableName."_detail",$file2);
    
    if($what==2){ // if want contact form...
        createContactFiles("index",$contact_file);
        createContactFiles("form_save",$form_save_file);
    }
 
    createFile($tableName."_process",$file3);
     updateFunctions('../panel/_functions.php',$function);
    updateMenu('../panel/_menu.php',$menu);
      
    echo "1^<div class='create_info'><strong><i class='fa fa-database' aria-hidden='true'></i> [".$tableName."]</strong> ".lang('table_created')."<br>";
    echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [panel/_php/".$tableName.".php]</strong> ".lang('file_created')."<br>";
    echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [panel/_php/".$tableName."_detail.php]</strong> ".lang('file_created')."<br>";
    echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [panel/_php/".$tableName."_process.php]</strong> ".lang('file_created')."<br>";
    echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [panel/_functions.php]</strong> ".lang('file_updated')."<br>";
    echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [panel/_menu.php]</strong> ".lang('file_updated')."</div>";
    
    if($what == 2){
        echo "<br>";
        echo "<div class='create_info'><strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [__form/index.php]</strong> ".lang('file_created')."<br>";   
        echo "<strong><i class='fa fa-file-code-o' aria-hidden='true'></i> [__form/form_save.php]</strong> ".lang('file_created')."</div>";   
    }
    
    
 } else {
     if($db->errno == 1050){
        echo "0^<strong>".$tableName."</strong> ".lang('table_exists')."";     
     }
    
 }

$alter1 = $db->query("ALTER TABLE ".$tableName." ADD PRIMARY KEY (id)");
$alter2 = $db->query("ALTER TABLE ".$tableName."  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;");