<?php
ignore_user_abort();
ini_set('max_execution_time', 86400);

require "db.php";

if (isset($_POST['formSubmit'])) {

    if ($_POST['dump'] == '') {
        setMessage('"Dump" cannot be empty!', 'error');
    }

    if (!getMessages(false, 'error')) {
        $arr = array_filter(explode("\n", $_POST['dump']), 'strlen');
        foreach ($arr as $key => $value) {
            $k = explode('|', $value);
            for ($i = 1; $i <= 14; $i++) {
                if ($_POST['select' . $i]) {
                    $import[$key][$_POST['select' . $i]] = $k[$i - 1];
                }
            }
        }

        $getUser = dbRow("SELECT `record_num` FROM `users` WHERE `username` = '" . mysqli_real_escape_string($dbconn, $_POST['submitter']) . "'", false);
        $_POST['submitter'] = is_array($getUser) ? $getUser['record_num'] : 0;

        $counter = 0;
        $errors = 0;
        
        foreach ($import as $i) {
            if ($i['name']) {
                $i = mysqli_real_escape_array($i);
                $tmp = dbQuery("SELECT * FROM paysites WHERE name LIKE '$i[name]'", false);
                if (count($tmp) < 1) {
                    $checkInsert = mysqli_query($dblink, "INSERT INTO paysites SET name = '$i[name]', description = '$i[description]', user = '$_POST[submitter]', url = '$i[url]', ad0 = '$i[ad0]',  ad1 = '$i[ad1]',  ad2 = '$i[ad2]',  ad3 = '$i[ad3]',  ad4 = '$i[ad4]',  ad5 = '$i[ad5]',  ad6 = '$i[ad6]',  ad7 = '$i[ad7]',  ad8 = '$i[ad8]',  ad9 = '$i[ad9]'");
                    if (mysqli_affected_rows($dblink) > 0) {
                        $inserted = mysqli_insert_id($dblink);

                        if ($i['thumbnail']) {
                            $thumbData = file_get_contents($i['thumbnail']);
                            if (strlen($thumbData) > 1024) { // prevent downloading too small/LQ images
                                if (file_put_contents("$misc_path/paysite$inserted.jpg", $thumbData)) {
                                    if (is_numeric($_POST['resizeImageWidth']) && is_numeric($_POST['resizeImageHeight'])) {
                                        _mogrifyImageThumbnail("$misc_path/paysite$inserted.jpg", $_POST['resizeImageWidth'], $_POST['resizeImageHeight']);
                                    }
                                }
                            }
                        }

                        $counter++;
                    } else {
                        $errors++;
                    }
                } else {
                    $errors++;
                }
            } else {
                $errors++;
            }
        }
        setMessage("<strong>$counter paysites added to import queue. $errors paysites were not added.</strong>", 'info');
        header("Location: $_SERVER[REQUEST_URI]");
        exit();
    }
}
?>

<? require "header.php"; ?>

<div class="content-page">
    
    <div class="header-area">
        <div class="breadcrumbs">  
            <a href="index.php">Admin Home</a>          
            <span><a href="paysites_csv.php">CSV Import</a></span>  
        </div>
    </div>
    
    <div class="content-outer">
        
        <h2>CSV<strong>Paysites</strong></h2>
        
        <div class="notification info">Imports must be delimited by | (aka. pipes) only!</div>
        
        <div class="notification alert">Please note: Make sure you don't accidently put any linebreaks, as it will produce undesirable results with your import!</div>
        
        <div class="content-inner">

            <? echo getMessages(); ?>
            
            <form method="POST" action="" id="form-import" class="form" novalidate autocomplete="off">
                <table class="pagetable">
                    <tbody>
                        <tr>
                            <td>Import Format:</td>
                            <td>
                                <div class="row columnized-input" id="import-format-selects">
                                    <?php for ($i = 1; $i <= 14; $i++) { ?>
                                        <div class="col-xs-12 col-sm-4 col">
                                            <span class="prefix"><?php echo $i; ?></span>
                                            <select name="select<?php echo $i; ?>">
                                                <option value="" selected="selected">-</option>
                                                <option value="name">name</option>
                                                <option value="description">description</option>
                                                <option value="thumbnail">thumbnail</option>
                                                <option value="url">url</option>      
                                                <option value="ad0">ad0</option>
                                                <option value="ad1">ad1</option>
                                                <option value="ad2">ad2</option>
                                                <option value="ad3">ad3</option>
                                                <option value="ad4">ad4</option>
                                                <option value="ad5">ad5</option>
                                                <option value="ad6">ad6</option>
                                                <option value="ad7">ad7</option>
                                                <option value="ad8">ad8</option>
                                                <option value="ad9">ad9</option>
                                            </select>
                                        </div>
                                    <?php } ?>
                                </div>
                            </td>
                        </tr>
                        <tr>
                            <td>Resize Thumbs:</td>
                            <td>
                                <input type="number" name="resizeImageWidth" value="<?php echo $thumbwidth; ?>" class="tiny" min="0" />
                                <span class="suffix">px</span>
                                &nbsp;x&nbsp;
                                <input type="number" name="resizeImageHeight" value="<?php echo $thumbheight; ?>" class="tiny" min="0" />
                                <span class="suffix">px</span>
                                <p class="hint">width x height, in pixels. Leave blank to skip resizing</p>
                            </td>
                        </tr>
                        <tr>
                            <td>Partner</td>
                            <td>
                                <input type="text" name="submitter" id="contentAutocomplete" value=""/>
                                <script type="text/javascript">
                                    $(document).ready(function () {
                                        $("#contentAutocomplete").autocomplete({
                                            source: "<?php echo $basehttp; ?>/admin/search_content.php?type=2",
                                            minLength: 2
                                        });
                                    });
                                </script>
                            </td>
                        </tr>
                        <tr>
                            <td>Dump:</td>
                            <td><textarea name="dump" rows="10" required></textarea></td>
                        </tr>
                        <tr class="item submit">
                            <td colspan="2">
                                <input type="hidden" name="formSubmit" value="1">
                                <button type="submit" class="btn action-save">Submit</button>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </form>
        </div>
    </div>
</div>

<?php require "footer.php"; ?>