function cms_table_exists($create) { global $con; if (!($result = mysqli_query($con, "SELECT * FROM cms"))) { //if table doesn't exist if ($create == true) { if (!($query = mysqli_query($con, "CREATE TABLE cms (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\ttag VARCHAR(100) COLLATE latin1_bin, primaryimage VARCHAR(10) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\tvisibleto VARCHAR(100) COLLATE latin1_bin,\n\t\t\t\t\t\t\t\t\t\t\t\tcreated VARCHAR(100) COLLATE latin1_bin, showname VARCHAR(50) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\tfeatured VARCHAR(10) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\ttitle VARCHAR(100) COLLATE latin1_bin, headline VARCHAR(200) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\tabstract VARCHAR(200) COLLATE latin1_bin, includes TEXT COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\thead TEXT COLLATE latin1_bin, main TEXT COLLATE latin1_bin, additionalimages VARCHAR(100) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\t\tmisc TEXT COLLATE latin1_bin) \n\t\t\t\t\t\t\t\t\t\t\t\tCOLLATE latin1_bin"))) { errorreport(mysqli_error($con) . "\r\nCreating table cms"); return false; } else { return true; //database created } } } else { return true; //database exists } return false; }
function images_table_exists($create) { global $con, $date, $root, $imagesdir, $imgsubdir; foreach ($imgsubdir as $subdir) { @mkdir($root . $imagesdir . $subdir); } if (!($result = mysqli_query($con, "SELECT * FROM images"))) { //if table doesn't exist if ($create == true) { if (!($query = mysqli_query($con, "CREATE TABLE images (id INT AUTO_INCREMENT PRIMARY KEY, groupid INT COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\ttag VARCHAR(100) COLLATE latin1_bin, width INT COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\theight INT COLLATE latin1_bin, directory VARCHAR(255) COLLATE latin1_bin, filename VARCHAR(255) COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\tsize BIGINT COLLATE latin1_bin, original INT COLLATE latin1_bin, \n\t\t\t\t\t\t\t\t\t\t\tuploadtime VARCHAR(255) COLLATE latin1_bin) COLLATE latin1_bin"))) { errorreport(mysqli_error($con) . "\r\nCreating table images"); return false; } else { return true; //database created } } } else { return true; //database exists } return false; }