PHP DataObject::dbinsert方法代码示例

 /**
  * Insert object into DB based on previously recorded changes.
  *
  * @return boolean true
  */
 function dbinsert()
 {
     global $DB, $localtimenow;
     $DB->begin();
     $this->set_param('timestamp', 'date', date2mysql($localtimenow));
     $result = parent::dbinsert();
     if ($result) {
         // Commit current transaction
         $DB->commit();
     } else {
         // Rollback current transaction
         $DB->rollback();
     }
     return $result;
 }

    /**
     * Insert object into DB based on previously recorded changes.
     */
    function dbinsert()
    {
        global $DB;
        $DB->begin();
        if (parent::dbinsert()) {
            global $Blog;
            // Update/Insert/Delete custom fields:
            $this->dbsave_custom_fields();
            if (!empty($Blog)) {
                // Enable this item type only for selected Blog:
                $DB->query('INSERT INTO T_items__type_coll
					       ( itc_ityp_ID, itc_coll_ID )
					VALUES ( ' . $this->ID . ', ' . $Blog->ID . ' )');
            }
        }
        $DB->commit();
    }

 /**
  * Insert object into DB based on previously recorded changes.
  */
 function dbinsert()
 {
     global $DB;
     $DB->begin();
     parent::dbinsert();
     // Create group permissions/settings for the current group
     $GroupSettings =& $this->get_GroupSettings();
     $GroupSettings->dbupdate($this->ID);
     $DB->commit();
 }

 /**
  * Insert into the DB
  */
 function dbinsert()
 {
     global $DB;
     $DB->begin();
     if (parent::dbinsert()) {
         if (isset($this->CollectionSettings)) {
             // So far all settings have been saved to collection #0 !
             // Update the settings: hackish but the base class should not even store this value actually...
             // dh> what do you mean? What "base class"? Is there a problem with CollectionSettings?
             $this->CollectionSettings->cache[$this->ID] = $this->CollectionSettings->cache[0];
             unset($this->CollectionSettings->cache[0]);
             $this->CollectionSettings->dbupdate();
         }
     }
     $DB->commit();
 }

    /**
     * Insert object into DB based on previously recorded changes
     *
     * Triggers the plugin event AfterUserInsert.
     *
     * @param boolean TRUE to automatically create new blog if group has permission
     * @return boolean true on success
     */
    function dbinsert($create_auto_blog = true)
    {
        global $Plugins, $DB;
        $DB->begin();
        if ($result = parent::dbinsert()) {
            // We could insert the user object..
            // Add new fields:
            if (!empty($this->new_fields)) {
                $sql = 'INSERT INTO T_users__fields( uf_user_ID, uf_ufdf_ID, uf_varchar )
								VALUES (' . $this->ID . ', ' . implode('), (' . $this->ID . ', ', $this->new_fields) . ' )';
                $DB->query($sql, 'Insert new fields');
                // Reset new fields in object:
                $this->new_fields = array();
            }
            // Notify plugins:
            // A user could be created also in another DB (to synchronize it with b2evo)
            $Plugins->trigger_event('AfterUserInsert', $params = array('User' => &$this));
            $Group =& $this->get_Group();
            if ($create_auto_blog && $Group->check_perm('perm_getblog', 'allowed')) {
                // automatically create new blog for this user
                // TODO: sam2kb> Create a blog only when this user is validated!
                $new_Blog = new Blog(NULL);
                $shortname = $this->get('login');
                $new_Blog->set('owner_user_ID', $this->ID);
                $new_Blog->set('shortname', $shortname);
                $new_Blog->set('name', $shortname . '\'s blog');
                $new_Blog->set('locale', $this->get('locale'));
                $new_Blog->set('urlname', urltitle_validate($shortname, $shortname, $new_Blog->ID, false, 'blog_urlname', 'blog_ID', 'T_blogs', $this->get('locale')));
                // Defines blog settings by its kind.
                $Plugins->trigger_event('InitCollectionKinds', array('Blog' => &$new_Blog, 'kind' => 'std'));
                $new_Blog->create();
            }
            // Save IP Range and user counter
            antispam_increase_counter('user');
        }
        $DB->commit();
        return $result;
    }

    /**
     * Insert message in existing thread
     *
     * @return true if success, instead false
     */
    function dbinsert_message()
    {
        global $DB, $localtimenow;
        if ($this->ID != 0) {
            die('Existing object cannot be inserted!');
        }
        $DB->begin();
        $this->get_Thread();
        $this->Thread->set_param('datemodified', 'string', date('Y-m-d H:i:s', $localtimenow));
        if ($this->Thread->dbupdate()) {
            $this->set_param('thread_ID', 'integer', $this->Thread->ID);
            if (parent::dbinsert()) {
                $sql = 'UPDATE T_messaging__threadstatus
						SET tsta_first_unread_msg_ID = ' . $this->ID . '
						WHERE tsta_thread_ID = ' . $this->Thread->ID . '
							AND tsta_user_ID <> ' . $this->author_user_ID . '
							AND tsta_first_unread_msg_ID IS NULL';
                $DB->query($sql, 'Insert thread statuses');
                // check if contact pairs between sender and recipients exists
                $recipient_list = $this->Thread->load_recipients();
                // remove author user from recipient list
                $recipient_list = array_diff($recipient_list, array($this->author_user_ID));
                // insert missing contact pairs if required
                if ($this->dbinsert_contacts($recipient_list)) {
                    if ($this->dbupdate_last_contact_datetime()) {
                        $DB->commit();
                        $this->send_email_notifications(false);
                        return true;
                    }
                }
            }
        }
        $DB->rollback();
        return false;
    }

    /**
     * Insert object into DB based on previously recorded changes.
     *
     * @return boolean true on success
     */
    function dbinsert()
    {
        global $DB;
        if ($this->ID != 0) {
            debug_die('Existing object cannot be inserted!');
        }
        $DB->begin();
        $order_max = $DB->get_var('SELECT MAX(wi_order)
				 FROM T_widget
				WHERE wi_coll_ID = ' . $this->coll_ID . '
					AND wi_sco_name = ' . $DB->quote($this->sco_name), 0, 0, 'Get current max order');
        $this->set('order', $order_max + 1);
        $res = parent::dbinsert();
        $DB->commit();
        return $res;
    }

 /**
  * Get karma and set it before adding the Comment to DB.
  *
  * @return boolean true on success, false if it did not get inserted
  */
 function dbinsert()
 {
     /**
      * @var Plugins
      */
     global $Plugins;
     global $Settings;
     // Get karma percentage (interval -100 - 100)
     $spam_karma = $Plugins->trigger_karma_collect('GetSpamKarmaForComment', array('Comment' => &$this));
     $this->set_spam_karma($spam_karma);
     // Change status accordingly:
     if (!is_null($spam_karma)) {
         if ($spam_karma < $Settings->get('antispam_threshold_publish')) {
             // Publish:
             $this->set('status', 'published');
         } elseif ($spam_karma > $Settings->get('antispam_threshold_delete')) {
             // Delete/No insert:
             return false;
         }
     }
     $dbchanges = $this->dbchanges;
     if ($r = parent::dbinsert()) {
         $Plugins->trigger_event('AfterCommentInsert', $params = array('Comment' => &$this, 'dbchanges' => $dbchanges));
     }
     return $r;
 }

    /**
     * Insert object into DB based on previously recorded changes
     *
     * Triggers the plugin event AfterUserInsert.
     *
     * @param boolean TRUE to automatically create new blog if group has permission
     * @return boolean true on success
     */
    function dbinsert($create_auto_blog = true)
    {
        global $Plugins, $DB;
        $DB->begin();
        if ($result = parent::dbinsert()) {
            // We could insert the user object..
            // Add new fields:
            if (!empty($this->new_fields)) {
                $sql = 'INSERT INTO T_users__fields( uf_user_ID, uf_ufdf_ID, uf_varchar )
								VALUES (' . $this->ID . ', ' . implode('), (' . $this->ID . ', ', $this->new_fields) . ' )';
                $DB->query($sql, 'Insert new fields');
                // Reset new fields in object:
                $this->new_fields = array();
            }
            // Notify plugins:
            // A user could be created also in another DB (to synchronize it with b2evo)
            $Plugins->trigger_event('AfterUserInsert', $params = array('User' => &$this));
            $Group =& $this->get_Group();
            if ($create_auto_blog && $Group->check_perm('perm_getblog', 'allowed')) {
                // automatically create new blog for this user
                // TODO: sam2kb> Create a blog only when this user is validated!
                $new_Blog = new Blog(NULL);
                $shortname = $this->get('login');
                $new_Blog->set('owner_user_ID', $this->ID);
                $new_Blog->set('shortname', $shortname);
                $new_Blog->set('name', $shortname . '\'s blog');
                $new_Blog->set('locale', $this->get('locale'));
                $new_Blog->set('urlname', urltitle_validate($shortname, $shortname, $new_Blog->ID, false, 'blog_urlname', 'blog_ID', 'T_blogs', $this->get('locale')));
                // Defines blog settings by its kind.
                $Plugins->trigger_event('InitCollectionKinds', array('Blog' => &$new_Blog, 'kind' => 'std'));
                $new_Blog->create();
            }
            /* Save IP Range -- start */
            $ip = int2ip(ip2int($_SERVER['REMOTE_ADDR']));
            // Convert IPv6 to IPv4
            if (preg_match('#^\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}$#i', $ip)) {
                // Check IP for correct format
                $ip_24bit_start = ip2int(preg_replace('#\\.\\d{1,3}$#i', '.0', $ip));
                $ip_24bit_end = ip2int(preg_replace('#\\.\\d{1,3}$#i', '.255', $ip));
                if ($iprange = get_ip_range($ip_24bit_start, $ip_24bit_end)) {
                    // Update ip range
                    $DB->query('UPDATE T_antispam__iprange
									SET aipr_user_count = ' . $DB->quote($iprange->aipr_user_count + 1) . '
									WHERE aipr_ID = ' . $DB->quote($iprange->aipr_ID));
                } else {
                    // Insert new ip range
                    $DB->query('INSERT INTO T_antispam__iprange ( aipr_IPv4start, aipr_IPv4end, aipr_user_count )
									VALUES ( ' . $DB->quote($ip_24bit_start) . ', ' . $DB->quote($ip_24bit_end) . ', ' . $DB->quote('1') . ' ) ');
                }
            }
            /* Save IP Range -- end */
        }
        $DB->commit();
        return $result;
    }

 /**
  * Insert object into DB based on previously recorded changes.
  *
  * @return boolean true on success
  */
 function dbinsert()
 {
     global $DB, $localtimenow;
     load_funcs('items/model/_item.funcs.php');
     if ($this->ID != 0) {
         die('Existing object cannot be inserted!');
     }
     // Start transaction because of urltitle validation
     $DB->begin('SERIALIZABLE');
     // validate url title / slug
     $this->set('urlname', urltitle_validate($this->urlname, $this->name, $this->ID, false, $this->dbprefix . 'urlname', $this->dbIDname, $this->dbtablename));
     $this->set_param('last_touched_ts', 'date', date('Y-m-d H:i:s', $localtimenow));
     if (parent::dbinsert()) {
         // The chapter was inserted successful
         $DB->commit();
         return true;
     }
     // Could not insert the chapter object
     $DB->rollback();
     return false;
 }

 /**
  * Insert object into DB based on previously recorded changes
  *
  * @return boolean true on success, false on failure
  */
 function dbinsert()
 {
     global $Debuglog;
     if ($this->meta == 'unknown') {
         debug_die('cannot insert File if meta data has not been checked before');
     }
     if ($this->ID != 0 || $this->meta != 'notfound') {
         debug_die('Existing file object cannot be inserted!');
     }
     $Debuglog->add('Inserting meta data for new file into db', 'files');
     // Let's make sure the bare minimum gets saved to DB:
     $this->set_param('root_type', 'string', $this->_FileRoot->type);
     $this->set_param('root_ID', 'integer', $this->_FileRoot->in_type_ID);
     $this->set_param('path', 'string', $this->_rdfp_rel_path);
     // Let parent do the insert:
     $r = parent::dbinsert();
     // We can now consider the meta data has been loaded:
     $this->meta = 'loaded';
     return $r;
 }

    /**
     * Insert into the DB
     */
    function dbinsert()
    {
        global $DB, $Plugins, $Settings;
        $DB->begin();
        if ($this->get('order') == 0) {
            // Set an order as max value of previous order + 1 if it is not defined yet
            $SQL = new SQL();
            $SQL->SELECT('MAX( blog_order )');
            $SQL->FROM('T_blogs');
            $max_order = intval($DB->get_var($SQL->get()));
            $this->set('order', $max_order + 1);
        }
        $set_default_blog_ID = isset($Settings);
        if (get_setting_Blog('default_blog_ID')) {
            // Don't set a default blog if it is already defined and the blog exists in DB
            $set_default_blog_ID = false;
        }
        if ($set_default_blog_ID) {
            // No default blog yet, Use for first base url as "Default collection on baseurl"
            $this->set('access_type', 'baseurl');
        } else {
            // For all other blogs use "Extra path on index.php"
            $this->set('access_type', 'extrapath');
        }
        if (parent::dbinsert()) {
            if ($set_default_blog_ID) {
                // Use this blog as default because it is probably first created
                $Settings->set('default_blog_ID', $this->ID);
                $Settings->dbupdate();
            }
            if (isset($this->CollectionSettings)) {
                // So far all settings have been saved to collection #0 !
                // Update the settings: hackish but the base class should not even store this value actually...
                // dh> what do you mean? What "base class"? Is there a problem with CollectionSettings?
                $this->CollectionSettings->cache[$this->ID] = $this->CollectionSettings->cache[0];
                unset($this->CollectionSettings->cache[0]);
                $this->CollectionSettings->dbupdate();
            }
            $default_post_type_ID = $this->get_setting('default_post_type');
            if (!empty($default_post_type_ID)) {
                // Enable post type that is used by default for this collection:
                global $DB;
                $DB->query('INSERT INTO T_items__type_coll
									 ( itc_ityp_ID, itc_coll_ID )
						VALUES ( ' . $DB->quote($default_post_type_ID) . ', ' . $DB->quote($this->ID) . ' )');
            }
            // Enable default item types for the inserted collection:
            $this->enable_default_item_types();
            $Plugins->trigger_event('AfterCollectionInsert', $params = array('Blog' => &$this));
        }
        $DB->commit();
    }

 /**
  * Insert object into DB based on previously recorded changes.
  *
  * @return boolean true on success, false on failure to insert
  */
 function dbinsert()
 {
     global $DB;
     $dbchanges = $this->dbchanges;
     $DB->begin();
     if (($r = parent::dbinsert()) !== false) {
         // Update types of the Files
         $this->update_file_types();
         $DB->commit();
     } else {
         $DB->rollback();
     }
     return $r;
 }

 /**
  * Insert object into DB based on previously recorded changes
  *
  * @return boolean true on success, false on failure
  */
 function dbinsert()
 {
     global $Debuglog;
     if ($this->meta == 'unknown') {
         debug_die('cannot insert File if meta data has not been checked before');
     }
     if ($this->ID != 0 || $this->meta != 'notfound') {
         debug_die('Existing file object cannot be inserted!');
     }
     $Debuglog->add('Inserting meta data for new file into db', 'files');
     // Let's make sure the bare minimum gets saved to DB:
     $this->set_param('root_type', 'string', $this->_FileRoot->type);
     $this->set_param('root_ID', 'number', $this->_FileRoot->in_type_ID);
     $this->set_param('path', 'string', $this->_rdfp_rel_path);
     $this->set_param('path_hash', 'string', md5($this->_FileRoot->type . $this->_FileRoot->in_type_ID . $this->_rdfp_rel_path, true));
     if (!$this->is_dir()) {
         // create hash value only for files but not for folders
         $this->set_param('hash', 'string', md5_file($this->get_full_path(), true));
     }
     // Let parent do the insert:
     $r = parent::dbinsert();
     // We can now consider the meta data has been loaded:
     $this->meta = 'loaded';
     return $r;
 }

 /**
  * Get karma and set it before adding the Comment to DB.
  *
  * @return boolean true on success, false if it did not get inserted
  */
 function dbinsert()
 {
     /**
      * @var Plugins
      */
     global $Plugins;
     global $Settings;
     // Get karma percentage (interval -100 - 100)
     $spam_karma = $Plugins->trigger_karma_collect('GetSpamKarmaForComment', array('Comment' => &$this));
     $this->set_spam_karma($spam_karma);
     // Change status accordingly:
     if (!is_null($spam_karma)) {
         if ($spam_karma < $Settings->get('antispam_threshold_publish')) {
             // Publish:
             $this->set('status', 'published');
         } elseif ($spam_karma > $Settings->get('antispam_threshold_delete')) {
             // Delete/No insert:
             return false;
         }
     }
     // set comment secret for quick moderation
     // fp> users have requested this for all comments
     $comment_Item =& $this->get_Item();
     $comment_Blog =& $comment_Item->get_Blog();
     if ($comment_Blog->get_setting('comment_quick_moderation') != 'never') {
         // quick moderation is permitted, set comment secret
         $this->set('secret', generate_random_key());
     }
     $dbchanges = $this->dbchanges;
     if ($r = parent::dbinsert()) {
         if ($this->is_published()) {
             // Update last touched date of item if comment is created in published status
             $comment_Item->update_last_touched_date();
         }
         $Plugins->trigger_event('AfterCommentInsert', $params = array('Comment' => &$this, 'dbchanges' => $dbchanges));
     }
     return $r;
 }