<?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 <= 8; $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 $import_row) {
            $insert_id = dbInsert('csv_import_photos', array(
                'title' => $import_row['title'],
                'flv' => $import_row['flv'],
                'desc' => $import_row['desc'],
                'keywords' => $import_row['keywords'],
                'paysite' => $import_row['paysite'],
                'pornstars' => $import_row['pornstars'],
                'local' => $import_row['local'],
                'plugurl' => $import_row['plugurl'],
                'default_paysite' => $_POST['default_paysite'],
                'hotlink' => $_POST['ishotlinked'],
                'submitter' => $_POST['submitter'],
            ));
            if (is_numeric($insert_id)) {
                $counter++;
            } else {
                $errors++;
            }
        }
        setMessage("<strong>$counter galleries added to import queue. $errors galleries were not added.</strong>", 'info');
        if ($counter > 0) {
            $pid = backgroundProcess("$php_path $basepath/admin/csv_photos_cron.php", "csv_photo_log.txt");
            setMessage("CSV Photos Importer has been started as PID: $pid");
        }
        header("Location: $_SERVER[REQUEST_URI]");
        exit();
    }
}

entities_walk($_POST);
?>

<? require "header.php"; ?>

<div class="content-page">

    <div class="header-area">
        <div class="breadcrumbs">  
            <a href="index.php">Admin Home</a>          
            <span><a href="csv_photos.php">CSV Photos</a></span>  
        </div>
    </div>

    <div class="content-outer">  

        <h2>CSV<strong>Photos</strong></h2>

        <div class="notification info">Imports must be delimited by | (aka. pipes) only!</div>

        <div class="notification info">Please note: This will not work on 100% of galleries! It will fail on photo galleries that do not link directly to jpg files.</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 <= 8; $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="">-</option>
                                                <option value="flv"<? echo $_POST['select' . $i] == 'flv' ? ' selected' : ''; ?>>url</option>
                                                <option value="title"<? echo $_POST['select' . $i] == 'title' ? ' selected' : ''; ?>>title</option>
                                                <option value="desc"<? echo $_POST['select' . $i] == 'desc' ? ' selected' : ''; ?>>desc</option>
                                                <option value="keywords"<? echo $_POST['select' . $i] == 'keywords' ? ' selected' : ''; ?>>keywords</option>
                                                <option value="paysite"<? echo $_POST['select' . $i] == 'paysite' ? ' selected' : ''; ?>>paysite</option>
                                                <option value="pornstars"<? echo $_POST['select' . $i] == 'pornstars' ? ' selected' : ''; ?>>pornstars</option>
                                            </select>
                                        </div>
                                    <?php } ?>
                                </div>
                            </td>
                        </tr>                        
                        <tr>
                            <td>Default Paysite (Only used if no paysite is provided for video):</td>
                            <td>
                                <select name="default_paysite">
                                    <?php $rresult = dbQuery("SELECT * FROM `paysites` ORDER BY `name`", false); ?>
                                    <? foreach ($rresult as $rrow) { ?>
                                        <option<?php echo ($_POST['paysite'] == $rrow['record_num']) ? ' selected' : ''; ?> value="<?php echo $rrow['record_num']; ?>"><?php echo $rrow['name']; ?></option>
                                    <?php } ?>
                                </select>
                            </td>
                        </tr>
                        <tr>
                            <td>Submitter:</td>
                            <td>
                                <input type="text" name="submitter" id="contentAutocomplete" value="<? echo $_POST['submitter']; ?>" placeholder="Start typing username..." />
                                <script type="text/javascript">
                                    $(document).ready(function () {
                                        $("#contentAutocomplete").autocomplete({
                                            source: "search_content.php?type=2",
                                            minLength: 2
                                        });
                                    });
                                </script>
                            </td>
                        </tr>
                        <tr>
                            <td>Dump:</td>
                            <td><textarea name="dump" rows="10" required><? echo $_POST['dump']; ?></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"; ?>