PHP DbSpice::table_created Examples

Example #1

File: DbSpice.class.php Project: sqall01/additional_plugins

 static function install(&$obj)
 {
     global $serendipity;
     $dbversion = $obj->get_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG);
     if (empty($dbversion)) {
         $dbversion = 0;
     }
     if (!DbSpice::table_created('commentspice')) {
         // twitternames cant be longer than 15 referring to API docs. 20 for safety. nvarchar because of unicode names
         $q = "create table {$serendipity['dbPrefix']}commentspice (" . "commentid int(10) not null, " . "twittername nvarchar(20), " . "primary key (commentid)" . ")";
         $result = serendipity_db_schema_import($q);
         if ($result !== true) {
             return;
         }
         $obj->set_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG, 1);
     }
     // Version 2 updates
     if ($obj->get_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG < 2)) {
         $q = "alter table {$serendipity['dbPrefix']}commentspice" . " add column promo_name nvarchar(200)," . " add column promo_url nvarchar(250);";
         serendipity_db_query($q);
         $obj->set_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG, 2);
     }
     // Version 3 updates
     if ($obj->get_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG < 3)) {
         $q = "CREATE INDEX IDX_COMMENTS_EMAIL" . " on {$serendipity['dbPrefix']}comments (email);";
         serendipity_db_query($q);
         // if it already exists, it won't be created
         $obj->set_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG, 3);
     }
     // Version 4 updates
     if ($obj->get_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG < 4)) {
         $q = "alter table {$serendipity['dbPrefix']}commentspice" . " add column boo nvarchar(250);";
         serendipity_db_query($q);
         $obj->set_config(PLUGIN_EVENT_COMMENTSPICE_CNAME_DBCONFIG, 4);
     }
 }