<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include_once $path . '/connect_db.php';
include_once $path . '/all_scripts/singular_plural.php';


// $ads_que_sql = $connect->query("SELECT * FROM ads LIMIT 20");
// $connect->query("UPDATE `ads` SET `junk`=0");
// die('updated');
// $ads_que_sql = $connect->query("SELECT * FROM ads WHERE adid = 113");
$ads_que_sql = $connect->query("SELECT * FROM ads WHERE junk=0 LIMIT 500");
// $ads_que_sql = $connect->query("SELECT * FROM ads WHERE memberid ='{$memberid}' AND adid ='{$adid}'");

if($ads_que_sql->num_rows > 0){

    $sp = new Inflect(); //plural or singlur convertion class

    echo '<pre>';
    while($row_ads = $ads_que_sql->fetch_array(MYSQLI_ASSOC)){

        $adid = $row_ads['adid'];

        $cat1 = $row_ads["cat1"];
        $cat2 = $row_ads["cat2"];
        $cat3 = $row_ads["cat3"];

        // echo $description;
        // die();

        $categories = $cat1." ".$cat2." ".$cat3;
        $categories = trim($categories);

        echo "<b>categories: </b>".$categories." [<b>ID: </b>".$adid."]<br>";
        // die();

        

        if(strlen($categories)){

            $categories = explode(" ", $categories);

            $category_plural = '';

            foreach ($categories as $key => $value) {
                $category_plural .= $sp->singularize($value)." ";
                $category_plural .= $sp->pluralize($value)." ";
            }

            $category_plural = addslashes(trim($category_plural));

            echo "<b>category_plural: </b>".$category_plural."<br>";
            // die();

            $connect->query("UPDATE `ads` SET `category_plural`= '{$category_plural}', `junk`=1 WHERE `adid`='{$adid}'") || die('Update error: '.$connect->error);

            
        } else{
            $connect->query("UPDATE `ads` SET `junk`=1 WHERE `adid`='{$adid}'") || die('Update error: '.$connect->error);
        }

        

        echo "<br>";
        echo "<br>";

        // $connect->query("UPDATE `ads` SET `junk`=1 WHERE `adid`='{$adid}'") || die('Update error: '.$connect->error);

        echo '<meta http-equiv="refresh" content="3">';
    }
}