<?php $s = new Slug(); $slug_count = $s->like('id', 'category.', 'after')->count(); $c = new Category(); $content_count = $c->count(); if ($slug_count < $content_count) { $slugs = array(); $c = new Category(); foreach ($c->select('slug')->get_iterated() as $content) { $slugs[] = "('category." . $content->slug . "')"; } $slugs = join(', ', $slugs); $this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;"); } $done = true;
<?php $s = new Slug(); $slug_count = $s->like('id', 'page.', 'after')->count(); $c = new Text(); $content_count = $c->where('page_type', 1)->count(); if ($slug_count < $content_count) { $slugs = array(); $c = new Text(); foreach ($c->where('page_type', 1)->select('slug')->get_iterated() as $content) { $slugs[] = "('page." . $content->slug . "')"; } $slugs = join(', ', $slugs); $this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;"); } $done = true;
<?php $s = new Slug(); $slug_count = $s->like('id', 'essay.', 'after')->count(); $c = new Text(); $content_count = $c->where('page_type', 0)->count(); if ($slug_count < $content_count) { $slugs = array(); $c = new Text(); foreach ($c->where('page_type', 0)->select('slug')->get_iterated() as $content) { $slugs[] = "('essay." . $content->slug . "')"; } $slugs = join(', ', $slugs); $this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;"); } $done = true;
<?php $s = new Slug(); $slug_count = $s->like('id', 'content.', 'after')->count(); $c = new Content(); $content_count = $c->count(); if ($slug_count < $content_count) { $slugs = array(); $c = new Content(); foreach ($c->select('slug')->get_iterated() as $content) { $slugs[] = "('content." . $content->slug . "')"; } $slugs = join(', ', $slugs); $this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;"); } $done = true;
<?php $s = new Slug(); $slug_count = $s->like('id', 'album.', 'after')->count(); $c = new Album(); $content_count = $c->count(); if ($slug_count < $content_count) { $slugs = array(); $c = new Album(); foreach ($c->select('slug')->get_iterated() as $content) { $slugs[] = "('album." . $content->slug . "')"; } $slugs = join(', ', $slugs); $this->db->query("INSERT INTO {$s->table}(id) VALUES {$slugs} ON DUPLICATE KEY UPDATE id=id;"); } $done = true;