PHP Dba::write方法代码示例

 /**
  * insert
  * This inserts a new record for the specified object
  * with the specified information, amazing!
  */
 public static function insert($type, $oid, $user, $agent = '')
 {
     $type = self::validate_type($type);
     $sql = "INSERT INTO `object_count` (`object_type`,`object_id`,`date`,`user`,`agent`) " . " VALUES (?, ?, ?, ?, ?)";
     $db_results = Dba::write($sql, array($type, $oid, time(), $user, $agent));
     if (!$db_results) {
         debug_event('statistics', 'Unabled to insert statistics:' . $sql, '3');
     }
 }

 /**
  * insert
  * This inserts a new record for the specified object
  * with the specified information, amazing!
  */
 public static function insert($type, $oid, $user, $agent = '', $location, $count_type = 'stream')
 {
     if (!self::is_already_inserted($type, $oid, $user)) {
         $type = self::validate_type($type);
         $latitude = null;
         $longitude = null;
         $geoname = null;
         if (isset($location['latitude'])) {
             $latitude = $location['latitude'];
         }
         if (isset($location['longitude'])) {
             $longitude = $location['longitude'];
         }
         if (isset($location['name'])) {
             $geoname = $location['name'];
         }
         $sql = "INSERT INTO `object_count` (`object_type`,`object_id`,`count_type`,`date`,`user`,`agent`, `geo_latitude`, `geo_longitude`, `geo_name`) " . " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
         $db_results = Dba::write($sql, array($type, $oid, $count_type, time(), $user, $agent, $latitude, $longitude, $geoname));
         if (Core::is_media($type)) {
             Useractivity::post_activity($user, 'play', $type, $oid);
         }
         if (!$db_results) {
             debug_event('statistics', 'Unabled to insert statistics:' . $sql, '3');
         }
     } else {
         debug_event('statistics', 'Statistics insertion ignored due to graceful delay.', '3');
     }
 }

 /**
  * update
  *
  * This function updates the saved version with the current settings.
  */
 public function update(array $data = null)
 {
     if ($data && is_array($data)) {
         $this->name = $data['name'];
         $this->type = $data['pl_type'];
         $this->random = $data['random'];
         $this->limit = $data['limit'];
     }
     if (!$this->id) {
         return false;
     }
     $sql = "UPDATE `search` SET `name` = ?, `type` = ?, `rules` = ?, `logic_operator` = ?, `random` = ?, `limit` = ? WHERE `id` = ?";
     Dba::write($sql, array($this->name, $this->type, serialize($this->rules), $this->logic_operator, $this->random, $this->limit, $this->id));
     return $this->id;
 }

 /**
  * update_380005
  *
  * Add manual update flag on artist
  */
 public static function update_380005()
 {
     $retval = true;
     $sql = "ALTER TABLE `artist` ADD COLUMN `manual_update` SMALLINT( 1 ) DEFAULT '0'";
     $retval &= Dba::write($sql);
     return $retval;
 }

 /**
  * Remove the video from disk.
  */
 public function remove_from_disk()
 {
     $deleted = parent::remove_from_disk();
     if ($deleted) {
         $sql = "DELETE FROM `tvshow_episode` WHERE `id` = ?";
         $deleted = Dba::write($sql, array($this->id));
     }
     return $deleted;
 }

 public function remove_from_disk()
 {
     $deleted = true;
     $season_ids = $this->get_seasons();
     foreach ($season_ids as $id) {
         $season = new TVShow_Season($id);
         $deleted = $season->remove_from_disk();
         if (!$deleted) {
             debug_event('tvshow', 'Error when deleting the season `' . $id . '`.', 1);
             break;
         }
     }
     if ($deleted) {
         $sql = "DELETE FROM `tvshow` WHERE `id` = ?";
         $deleted = Dba::write($sql, array($this->id));
         if ($deleted) {
             Art::gc('tvshow', $this->id);
             Userflag::gc('tvshow', $this->id);
             Rating::gc('tvshow', $this->id);
             Shoutbox::gc('tvshow', $this->id);
             Useractivity::gc('tvshow', $this->id);
         }
     }
     return $deleted;
 }

 /**
  * set_rating
  * This function sets the rating for the current object.
  * If no userid is passed in, we use the currently logged in user.
  */
 public function set_rating($rating, $user_id = null)
 {
     if (is_null($user_id)) {
         $user_id = $GLOBALS['user']->id;
     }
     $user_id = intval($user_id);
     debug_event('Rating', "Setting rating for {$this->type} {$this->id} to {$rating}", 5);
     // If score is -1, then remove rating
     if ($rating == '-1') {
         $sql = "DELETE FROM `rating` WHERE " . "`object_id` = ? AND " . "`object_type` = ? AND " . "`user` = ?";
         $params = array($this->id, $this->type, $user_id);
     } else {
         $sql = "REPLACE INTO `rating` " . "(`object_id`, `object_type`, `rating`, `user`) " . "VALUES (?, ?, ?, ?)";
         $params = array($this->id, $this->type, $rating, $user_id);
     }
     Dba::write($sql, $params);
     parent::add_to_cache('rating_' . $this->type . '_user' . $user_id, $this->id, $rating);
     foreach (Plugin::get_plugins('save_rating') as $plugin_name) {
         $plugin = new Plugin($plugin_name);
         if ($plugin->load($GLOBALS['user'])) {
             $plugin->_plugin->save_rating($this, $rating);
         }
     }
     return true;
 }

 /**
  * delete_track
  * This deletes a track from the tmpplaylist
  */
 public function delete_track($id)
 {
     /* delete the track its self */
     $sql = "DELETE FROM `tmp_playlist_data` WHERE `id` = ?";
     Dba::write($sql, array($id));
     return true;
 }

 /**
  * rebuild_all_preferences
  * This rebuilds the user preferences for all installed users, called by the plugin functions
  */
 public static function rebuild_all_preferences()
 {
     // Clean out any preferences garbage left over
     $sql = "DELETE `user_preference`.* FROM `user_preference` " . "LEFT JOIN `user` ON `user_preference`.`user` = `user`.`id` " . "WHERE `user_preference`.`user` != -1 AND `user`.`id` IS NULL";
     Dba::write($sql);
     // Get only users who has less preferences than excepted
     // otherwise it would have significant performance issue with large user database
     $sql = "SELECT `user` FROM `user_preference` " . "GROUP BY `user` HAVING COUNT(*) < (" . "SELECT COUNT(`id`) FROM `preference` WHERE `catagory` != 'system')";
     $db_results = Dba::read($sql);
     while ($row = Dba::fetch_assoc($db_results)) {
         User::fix_preferences($row['user']);
     }
     return true;
 }

 /**
  * Add a new wanted release.
  * @param string $mbid
  * @param int $artist
  * @param string $artist_mbid
  * @param string $name
  * @param int $year
  */
 public static function add_wanted($mbid, $artist, $artist_mbid, $name, $year)
 {
     $sql = "INSERT INTO `wanted` (`user`, `artist`, `artist_mbid`, `mbid`, `name`, `year`, `date`, `accepted`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
     $accept = $GLOBALS['user']->has_access('75') ? true : AmpConfig::get('wanted_auto_accept');
     $params = array($GLOBALS['user']->id, $artist, $artist_mbid, $mbid, $name, $year, time(), '0');
     Dba::write($sql, $params);
     if ($accept) {
         $wantedid = Dba::insert_id();
         $wanted = new Wanted($wantedid);
         $wanted->accept();
         database_object::remove_from_cache('wanted', $wantedid);
     }
 }

 public function save_access()
 {
     $sql = "UPDATE `share` SET `counter` = (`counter` + 1), lastvisit_date = ? WHERE `id` = ?";
     return Dba::write($sql, array(time(), $this->id));
 }

 /**
  * delete
  * Deletes the catalog and everything associated with it
  * it takes the catalog id
  */
 public static function delete($catalog_id)
 {
     // Large catalog deletion can take time
     set_time_limit(0);
     // First remove the songs in this catalog
     $sql = "DELETE FROM `song` WHERE `catalog` = ?";
     $db_results = Dba::write($sql, array($catalog_id));
     // Only if the previous one works do we go on
     if (!$db_results) {
         return false;
     }
     $sql = "DELETE FROM `video` WHERE `catalog` = ?";
     $db_results = Dba::write($sql, array($catalog_id));
     if (!$db_results) {
         return false;
     }
     $catalog = self::create_from_id($catalog_id);
     $sql = 'DELETE FROM `catalog_' . $catalog->get_type() . '` WHERE catalog_id = ?';
     $db_results = Dba::write($sql, array($catalog_id));
     if (!$db_results) {
         return false;
     }
     // Next Remove the Catalog Entry it's self
     $sql = "DELETE FROM `catalog` WHERE `id` = ?";
     Dba::write($sql, array($catalog_id));
     // Run the cleaners...
     self::gc();
 }

 public static function create(array $data)
 {
     $subject = trim(strip_tags($data['subject']));
     $message = trim(strip_tags($data['message']));
     if (empty($subject)) {
         AmpError::add('subject', T_('Error: Subject Required'));
     }
     $to_user = User::get_from_username($data['to_user']);
     if (!$to_user->id) {
         AmpError::add('to_user', T_('Error: Unknown user'));
     }
     if (!AmpError::occurred()) {
         $from_user = $data['from_user'] ?: $GLOBALS['user']->id;
         $creation_date = $data['creation_date'] ?: time();
         $is_read = $data['is_read'] ?: 0;
         $sql = "INSERT INTO `user_pvmsg` (`subject`, `message`, `from_user`, `to_user`, `creation_date`, `is_read`) " . "VALUES (?, ?, ?, ?, ?, ?)";
         if (Dba::write($sql, array($subject, $message, $from_user, $to_user->id, $creation_date, $is_read))) {
             $insert_id = Dba::insert_id();
             // Never send email in case of user impersonation
             if (!isset($data['from_user']) && $insert_id) {
                 if (Preference::get_by_user($to_user->id, 'notify_email')) {
                     if (!empty($to_user->email)) {
                         $mailer = new Mailer();
                         $mailer->set_default_sender();
                         $mailer->recipient = $to_user->email;
                         $mailer->recipient_name = $to_user->fullname;
                         $mailer->subject = "[" . T_('Private Message') . "] " . $subject;
                         $mailer->message = sprintf(T_("You just received a new private message from %s.\n\n\n        ----------------------\n        %s\n        ----------------------\n\n        %s\n        "), $GLOBALS['user']->fullname, $message, AmpConfig::get('web_path') . "/pvmsg.php?action=show&pvmsg_id=" . $insert_id);
                         $mailer->send();
                     }
                 }
             }
             return $insert_id;
         }
     }
     return false;
 }

 /**
  * gc
  * This cleans up art that no longer has a corresponding object
  */
 public static function gc()
 {
     // iterate over our types and delete the images
     foreach (array('album', 'artist') as $type) {
         $sql = "DELETE FROM `image` USING `image` LEFT JOIN `" . $type . "` ON `" . $type . "`.`id`=" . "`image`.`object_id` WHERE `object_type`='" . $type . "' AND `" . $type . "`.`id` IS NULL";
         Dba::write($sql);
     }
     // foreach
 }

 /**
  * delete
  * this function deletes a specific shoutbox entry
  */
 public function delete($shout_id)
 {
     // Delete the shoutbox post
     $shout_id = Dba::escape($shout_id);
     $sql = "DELETE FROM `user_shout` WHERE `id`='{$shout_id}'";
     Dba::write($sql);
 }