/** * Update an existing db entry * * @param array $entry */ function editEntry($entry) { global $wpdb; $ad = new Advertisment($entry['advertisment_id']); $ad->setName($wpdb->escape($entry['advertisment_name'])); $ad->setVendor($wpdb->escape($entry['advertisment_vendor'])); $ad->setHtml($entry['advertisment_code']); $ad->setWeight($entry['advertisment_weight']); $ad->setSize($entry['advertisment_size']); $ad->setActive(isset($entry['advertisment_active']) ? true : false); $ad->updateDatabase(); }
/** * Install the plugin * * This function runs when the plugin is activated. Checks if database table exists and creates it. * * @since 0.1 */ function was_install() { global $wpdb; add_option('was_show_per_page', '10'); $was_db_version = '0.1'; $table_name = $wpdb->prefix . 'was_data'; if ($wpdb->get_var("SHOW TABLES LIKE '{$table_name}'") != $table_name) { $sql = "CREATE TABLE `" . $table_name . "` (\n\t\t\t`advertisment_id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t\t`advertisment_active` int(11) DEFAULT '1' NOT NULL,\n\t\t\t`advertisment_vendor` varchar(200) DEFAULT '' NOT NULL,\n\t\t\t`advertisment_name` varchar(200) DEFAULT '' NOT NULL,\n\t\t\t`advertisment_code` text NOT NULL,\n\t\t\t`advertisment_weight` int(11) DEFAULT '1' NOT NULL,\n\t\t\t`advertisment_size` varchar(20) DEFAULT '125x125' NOT NULL,\n\t\t\tPRIMARY KEY (`advertisment_id`)\n\t\t\t);"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql); add_option('was_db_version', $was_db_version); } $ad = new Advertisment(); $ad->setName('Wordpress Trac'); $ad->setHtml('http://core.trac.wordpress.org/timeline'); $ad->updateDatabase(); }