setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $dbOptions = $file_db->query('SELECT name FROM sqlite_master WHERE type="table" AND name="options"'); $hasOptions = "No"; foreach($dbOptions as $row) : if (in_array("options", $row)) : $hasOptions = "Yes"; endif; endforeach; if($hasOptions == "No") : $title = "Organizr"; $topbar = "#333333"; $topbartext = "#66D9EF"; $bottombar = "#333333"; $sidebar = "#393939"; $hoverbg = "#AD80FD"; $activetabBG = "#F92671"; $activetabicon = "#FFFFFF"; $activetabtext = "#FFFFFF"; $inactiveicon = "#66D9EF"; $inactivetext = "#66D9EF"; $loading = "#66D9EF"; $hovertext = "#000000"; endif; if($hasOptions == "Yes") : $resulto = $file_db->query('SELECT * FROM options'); foreach($resulto as $row) : $title = isset($row['title']) ? $row['title'] : "Organizr"; $topbartext = isset($row['topbartext']) ? $row['topbartext'] : "#66D9EF"; $topbar = isset($row['topbar']) ? $row['topbar'] : "#333333"; $bottombar = isset($row['bottombar']) ? $row['bottombar'] : "#333333"; $sidebar = isset($row['sidebar']) ? $row['sidebar'] : "#393939"; $hoverbg = isset($row['hoverbg']) ? $row['hoverbg'] : "#AD80FD"; $activetabBG = isset($row['activetabBG']) ? $row['activetabBG'] : "#F92671"; $activetabicon = isset($row['activetabicon']) ? $row['activetabicon'] : "#FFFFFF"; $activetabtext = isset($row['activetabtext']) ? $row['activetabtext'] : "#FFFFFF"; $inactiveicon = isset($row['inactiveicon']) ? $row['inactiveicon'] : "#66D9EF"; $inactivetext = isset($row['inactivetext']) ? $row['inactivetext'] : "#66D9EF"; $loading = isset($row['loading']) ? $row['loading'] : "#66D9EF"; $hovertext = isset($row['hovertext']) ? $row['hovertext'] : "#000000"; endforeach; endif; ?> <?=$title;?> Chat
'; echo '
'; echo '

SQLITE3

'; echo '
'; echo '
'; echo getError(getOS(),'sqlite3'); echo '
'; die(); } if( $db = new SQLite3("chatpack.db") ){ if( $db->busyTimeout(5000) ){ if( $db->exec("PRAGMA journal_mode = wal;") ) { $logtable = "CREATE TABLE IF NOT EXISTS chatpack_log (id INTEGER PRIMARY KEY, timestamp INTEGER NOT NULL, user TEXT NOT NULL, avatar TEXT NOT NULL, message TEXT NOT NULL, liked INTEGER DEFAULT 0)"; if( $db->exec($logtable) ){ $usertable = "CREATE TABLE IF NOT EXISTS chatpack_typing (id INTEGER PRIMARY KEY, timestamp INTEGER NOT NULL, user TEXT NOT NULL)"; $onlinetable = "CREATE TABLE IF NOT EXISTS chatpack_last_message ( user TEXT PRIMARY KEY NOT NULL, timestamp INTEGER NOT NULL, avatar TEXT NOT NULL)"; if( $db->exec($usertable) && $db->exec($onlinetable) ){ $dbcreated = true; }else{ errormessage("creating database table for typing"); } }else{ errormessage("creating database table for messages"); } if( !$db->close() ){ errormessage("closing database connection"); } }else{ errormessage("setting journal mode"); } }else{ errormessage("setting busy timeout"); } }else{ errormessage("using SQLite"); } if( $dbcreated ){?>



start chatting...

    Online