This function should be used only to enable showing of errors.
wpdb::hide_errors() should be used instead for hiding of errors. However,
this function can be used to enable and disable showing of database
errors.
| public show_errors ( boolean $show = true ) : boolean | ||
| $show | boolean | Whether to show or hide errors |
| return | boolean | Old value for showing errors. |
function __toString()
{
// if the playlist are saved to db, i load it from db
$playlist = $this->wpdb->get_row("SELECT ID, url, playlist FROM " . $this->table_name . " WHERE url = '" . $this->url . "'");
if ($this->wpdb->num_rows > 0) {
$playlist = unserialize($playlist->playlist);
} else {
$playlist = array();
$code = implode("", file($this->url));
if ($code == "") {
$this->errors->add('no_content', __('The url $url are not valid!'));
}
preg_match_all("/section-row-track(.+)/", $code, $results);
for ($i = 0; $i < sizeof($results[0]); $i++) {
preg_match("/class=\"tracklisttrackname mx-link\">(.+)<\\/a>/U", $results[0][$i], $match);
$title = $match[1];
preg_match("/class=\"tracklistartistname mx-link\">(.+)<\\/a>/U", $results[0][$i], $match);
$artist = $match[1];
if ($title != "" || $artist != "") {
$playlist[] = array("title" => $title, "artist" => $artist);
}
}
$this->wpdb->show_errors();
// save to db the playlist for this url
$this->wpdb->insert($this->table_name, array("url" => $this->url, "playlist" => serialize($playlist)), array("%s", "%s"));
}
$code = "<h3>Playlist</h3><ul class='mixcloud-embed-playlist'>";
for ($i = 0; $i < count($playlist); $i++) {
$code .= "<li><span class='mixcloud-embed-position'>" . ($i + 1) . "</span>";
$code .= "<span class='mixcloud-embed-artist'>" . $playlist[$i]["artist"] . "</span>";
$code .= "<span class='mixcloud-embed-title'>" . $playlist[$i]["title"] . "</span></li>";
}
$code .= "</ul>";
return $code;
}
function fleet_roster_handler($atts)
{
extract(shortcode_atts(array('prefix' => ''), $atts));
$response = '';
if ($prefix) {
$novadb = new wpdb('<username>', '<user password>', '<database>', '<server>');
if ($novadb->show_errors()) {
return $novadb->show_errors();
}
$response = '';
$query = "SELECT pos_name, pos_open from " . $prefix . "_positions_sto where pos_open > 0 order by pos_dept, pos_order;";
$rows = $novadb->get_results($query);
if (!$novadb->num_rows) {
return "No Positions available at this time.";
}
$i = 0;
foreach ($rows as $row) {
$response .= $row->pos_name;
if ($row->pos_open > 1) {
$response .= ' (' . $row->pos_open . ' open)';
}
$i++;
if ($i < $novadb->num_rows) {
$response .= ' - ';
}
}
return $response;
}
return 'Please enter a Command Prefix Code.';
}
/**
* Upgrade routine
* - Creates log table on plugin activation
* - Migrates table structure on updates
*/
public function upgrade()
{
$log_db_version = get_option(self::OPTION_DB_VERSION, 0);
// only run upgrade routine when database version is lower than code version
if (version_compare(self::DB_VERSION, $log_db_version, '<=')) {
return;
}
global $charset_collate;
// don't show errors as this would mess with plugin activation
$this->db->hide_errors();
// Create table if it does not exist
$sql = "\n\t\tCREATE TABLE IF NOT EXISTS {$this->table_name} (\n ID BIGINT(20) NOT NULL AUTO_INCREMENT,\n email VARCHAR(255) NOT NULL,\n list_ids VARCHAR(255) NOT NULL,\n method VARCHAR(255) NOT NULL,\n type VARCHAR(255) NOT NULL,\n success TINYINT(1) DEFAULT 1,\n\t\tdata TEXT NULL,\n related_object_ID BIGINT(20) NULL,\n url VARCHAR(255) DEFAULT '',\n datetime timestamp DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (ID)\n\t\t) {$charset_collate}";
$this->db->query($sql);
// update to v1.0.4
if (version_compare($log_db_version, '1.0.4', '<=')) {
// change 'sign-up_form' in 'sign-up-form';
$this->db->query("UPDATE `{$this->table_name}` SET `signup_type` = 'sign-up-form' WHERE `signup_type` = 'sign-up_form'");
}
// update to v1.1
if (version_compare($log_db_version, '1.1', '<=')) {
// merge columns `form_ID` and `comment_ID` into `related_object_ID`
$this->db->query("ALTER TABLE `{$this->table_name}` CHANGE COLUMN `form_ID` `related_object_ID` BIGINT(20)");
$this->db->query("UPDATE `{$this->table_name}` SET `related_object_ID` = `comment_ID` WHERE `related_object_ID` = 0 AND `comment_ID` > 0 ");
$this->db->query("ALTER TABLE `{$this->table_name}` DROP COLUMN `comment_ID`");
// add 'success' column
$this->db->query("ALTER TABLE `{$this->table_name}` ADD COLUMN `success` TINYINT(1) DEFAULT 1");
// rename columns
$this->db->query("ALTER TABLE `{$this->table_name}` CHANGE COLUMN `signup_method` `method` VARCHAR(255)");
$this->db->query("ALTER TABLE `{$this->table_name}` CHANGE COLUMN `signup_type` `type` VARCHAR(255)");
$this->db->query("ALTER TABLE `{$this->table_name}` CHANGE COLUMN `merge_vars` `data` TEXT");
// alter datatype of `datetime`
$this->db->query("ALTER TABLE `{$this->table_name}` CHANGE COLUMN `datetime` `datetime` timestamp DEFAULT CURRENT_TIMESTAMP");
// change `sign-up-form` to just `form`
$this->db->query("UPDATE `{$this->table_name}` SET `type` = 'form' WHERE `type` = 'sign-up-form'");
}
$this->db->show_errors();
update_option(self::OPTION_DB_VERSION, self::DB_VERSION);
}
array( 'name' => '1m_comments_magic_number', 'label' => 'Magic number', 'description' => '' ),
array( 'name' => '1m_lucky_id', 'label' => 'Winner ID', 'type' => 'text', 'description' => 'This the ID of the 1000000th comment.' ),
array( 'name' => 'sep_000', 'label' => $onem_lucky_id_txt, 'type' => 'separator' ),
);
$theme_options = new qqp_option_page( '1m comments', 'qqp_options', $option_args );
*/
// Register the wp 3.0 Menus
add_action('init', 'register_my_menus');
function register_my_menus()
{
register_nav_menus(array('primary-menu' => __('Primary Menu'), 'secondary-menu' => __('Secondary Menu')));
}
// Add extra Database Object Instance for XMLTeam Stats
$newdb = new wpdb('np_srolland', 'hio_st@ts', 'np_sportsdb', '10.22.199.137');
$newdb->show_errors();
// Ready for theme localisation
load_theme_textdomain('framework');
// Register the sidebars and widget classes
if (function_exists('register_sidebar')) {
register_sidebar(array('name' => 'Main Sidebar', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Footer 1', 'before_widget' => '<div id="%1$s" class="widget %2$s foot-widget-one">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Footer 2', 'before_widget' => '<div id="%1$s" class="widget %2$s foot-widget-two">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Footer 3', 'before_widget' => '<div id="%1$s" class="widget %2$s foot-widget-three">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Footer 4', 'before_widget' => '<div id="%1$s" class="widget %2$s foot-widget-four">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Narrow Left', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Narrow Right', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Sidebar Page', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Narrow Left Page', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Narrow Right Page', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));
register_sidebar(array('name' => 'Main Right Block', 'before_widget' => '<div id="%1$s" class="widget %2$s">', 'after_widget' => '</div>', 'before_title' => '<h3 class="widget-title">', 'after_title' => '</h3>'));