<?php
    include('db.php');
    echo "\nStart\n";
    
    ini_set('memory_limit','2048M');

    dbQuery("TRUNCATE TABLE content_search");

    $result = mysqli_query($dblink,"SELECT title, keywords, description, photos, record_num FROM content WHERE enabled = 1 ORDER BY title ASC");
    echo mysqli_num_rows($result)." content to proccess\n";
    if(mysqli_num_rows($result) > 0) {
        //store current values
        while($row = mysqli_fetch_assoc($result)) {
            $record_num = (int)$row['record_num'];

            $array[$record_num]['titles'] = $row['title'];
            $array[$record_num]['keywords'] = $row['keywords'];
            $array[$record_num]['descriptions'] = $row['description'];
            $array[$record_num]['photos'] = $row['photos'];

            $getLangs = mysqli_query($dblink,"SELECT title,keywords,description FROM content_languages WHERE content = $record_num");
            if(mysqli_num_rows($getLangs) > 0) {
                while($lang = mysqli_fetch_assoc($getLangs)) {
                    if(!empty($lang['title'])) {
                        $tmp['titles'][] = $lang['title'];
                    }

                    if(!empty($lang['keywords'])) {
                        $tmp['keywords'][] = $lang['keywords'];
                    }

                    if(!empty($lang['description'])) {
                        $tmp['descriptions'][] = $lang['description'];
                    }
                }

                if(!empty($tmp['titles'])) {
                    $array[$record_num]['titles'] = "{$array[$record_num]['titles']},".implode(",",$tmp['titles']);
                }

                if(!empty($tmp['keywords'])) {
                    $array[$record_num]['keywords'] = "{$array[$record_num]['keywords']},".implode(",",$tmp['keywords']);
                }

                if(!empty($tmp['descriptions'])) {
                    $array[$record_num]['descriptions'] = "{$array[$record_num]['descriptions']},".implode(",",$tmp['descriptions']);
                }

                unset($tmp);

                $titles = mysqli_real_escape_string($dblink,$array[$record_num]['titles']);
                $keywords = mysqli_real_escape_string($dblink,$array[$record_num]['keywords']);
                $descriptions = mysqli_real_escape_string($dblink, $array[$record_num]['descriptions']);
                $photos = $array[$record_num]['photos'];

                mysqli_query($dblink,"INSERT INTO content_search(titles,keywords,descriptions,content,photos) VALUES('$titles','$keywords','$descriptions','$record_num','$photos')");
            } else {
				$titles = mysqli_real_escape_string($dblink,$array[$record_num]['titles']);
                $keywords = mysqli_real_escape_string($dblink,$array[$record_num]['keywords']);
                $descriptions = mysqli_real_escape_string($dblink, $array[$record_num]['descriptions']);
                $photos = $array[$record_num]['photos'];
                 mysqli_query($dblink,"INSERT INTO content_search(titles,keywords,descriptions,content,photos) VALUES('$titles','$keywords','$descriptions','$record_num','$photos')");
            }

            unset($array[$record_num]);
        }
    }

    echo "Done\n\n";
?>