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;
}
