Copyrights plugin first.'); if(is_array($errors)) { array_push($errors, $msg); } else { $errors=Array($msg); } return false; } // Create the author table $query = ' CREATE TABLE IF NOT EXISTS '.$prefixeTable.'author_extended ( author_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) UNIQUE NOT NULL, code varchar (4) UNIQUE NOT NULL, url varchar(255), descr text DEFAULT NULL, copyright int(11) DEFAULT NULL, PRIMARY KEY (author_id) ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 ;'; pwg_query($query); // Temporary disable the auto increment $query = ' ALTER TABLE '.$prefixeTable.'copyrights_admin MODIFY cr_id int(11) NOT NULL ;'; pwg_query($query); // Insert "author's default copyright" in the copyrights table. On duplicates, it does nothing. $query = ' INSERT INTO '.$prefixeTable.'copyrights_admin VALUES (-1, \'Author\'\'s default copyright\', \'\', \'This is the default copyright for an author.\', 1) ON DUPLICATE KEY UPDATE cr_id = -1 ;'; pwg_query($query); // Reenable the auto increment $query = ' ALTER TABLE '.$prefixeTable.'copyrights_admin MODIFY cr_id int(11) NOT NULL AUTO_INCREMENT ;'; pwg_query($query); } function plugin_uninstall() { global $prefixeTable; // Drop the author table $query = ' DROP TABLE '.$prefixeTable.'author_extended ;'; pwg_query($query); // Remove the default copyright from the admin table $query = ' DELETE FROM '.$prefixeTable.'copyrights_admin WHERE cr_id = -1 ;'; pwg_query($query); // And remove all default copyrights from the media table $query = ' DELETE FROM '.$prefixeTable.'copyrights_media WHERE cr_id = -1 ;'; pwg_query($query); } ?>