/plugin/authucenter/lib/uc_client/model/ |
H A D | pm.php | 24 var $db; variable in pmmodel 32 $this->db = $base->db; 57 if($this->db->fetch_array($query)) { 240 $plid = $this->db->insert_id(); 242 $pmid = $this->db->insert_id(); 249 $pmid = $this->db->insert_id(); 266 $plid = $this->db->insert_id(); 268 $pmid = $this->db->insert_id(); 332 $pmid = $this->db->insert_id(); 486 $query = $this->db->query($sql); [all …]
|
H A D | domain.php | 14 var $db; variable in domainmodel 23 $this->db = $base->db; 28 $this->db->query("INSERT INTO ".UC_DBTABLEPRE."domains SET domain='$domain', ip='$ip'"); 30 return $this->db->insert_id(); 34 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."domains"); 40 $data = $this->db->fetch_all("SELECT * FROM ".UC_DBTABLEPRE."domains LIMIT $start, $ppp"); 46 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."domains WHERE id IN ($domainids)"); 47 return $this->db->affected_rows(); 51 $this->db->query("UPDATE ".UC_DBTABLEPRE."domains SET domain='$domain', ip='$ip' WHERE id='$id'"); 52 return $this->db->affected_rows();
|
H A D | user.php | 14 var $db; variable in usermodel 23 $this->db = $base->db; 27 $arr = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."members WHERE uid='$uid'"); 136 $uid = $this->db->insert_id(); 137 $this->db->query("INSERT INTO ".UC_DBTABLEPRE."memberfields SET uid='$uid'"); 166 return $this->db->affected_rows(); 185 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."members WHERE uid IN($uids)"); 190 return $this->db->affected_rows(); 212 while($user = $this->db->fetch_array($query)) { 221 while($user = $this->db->fetch_array($query)) { [all …]
|
H A D | friend.php | 14 var $db; variable in friendmodel 23 $this->db = $base->db; 27 …$direction = $this->db->result_first("SELECT direction FROM ".UC_DBTABLEPRE."friends WHERE uid='$f… 29 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."friends SET uid='$uid', friendid='$friendid', comme… 30 …$this->db->query("UPDATE ".UC_DBTABLEPRE."friends SET direction='3' WHERE uid='$friendid' AND frie… 38 return $this->db->insert_id(); 44 …$this->db->query("DELETE FROM ".UC_DBTABLEPRE."friends WHERE uid='$uid' AND friendid IN ($friendid… 45 $affectedrows = $this->db->affected_rows(); 47 …$this->db->query("UPDATE ".UC_DBTABLEPRE."friends SET direction=1 WHERE uid IN ($friendids) AND fr… 63 …$totalnum = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."friends WHERE $sqladd"); [all …]
|
H A D | tag.php | 14 var $db; variable in tagmodel 23 $this->db = $base->db; 27 $arr = $this->db->fetch_all("SELECT * FROM ".UC_DBTABLEPRE."tags WHERE tagname='$tagname'"); 32 …$result = $this->db->result_first("SELECT tagtemplates FROM ".UC_DBTABLEPRE."applications WHERE ap… 51 …$return = $this->db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."tags WHERE tagname='$data… 53 …$this->db->query("UPDATE ".UC_DBTABLEPRE."tags SET data='$datanew', expiration='".$this->base->tim… 55 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."tags (tagname, appid, data, expiration) VALUES ('$d… 61 …$return = $this->db->result_first("SELECT count(*) FROM ".UC_DBTABLEPRE."tags WHERE tagname='$tagn… 63 …$this->db->query("UPDATE ".UC_DBTABLEPRE."tags SET expiration='0' WHERE tagname='$tagname' AND app… 65 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."tags (tagname, appid, expiration) VALUES ('$tagname…
|
H A D | mail.php | 16 var $db; variable in mailmodel 26 $this->db = $base->db; 31 $data = $this->db->result_first("SELECT COUNT(*) FROM ".UC_DBTABLEPRE."mailqueue"); 49 $this->db->query("DELETE FROM ".UC_DBTABLEPRE."mailqueue WHERE mailid IN ($ids)"); 50 return $this->db->affected_rows(); 66 $this->db->query($sql); 67 $insert_id = $this->db->insert_id(); 68 …$insert_id && $this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars SET name='mailexists', value='1… 99 $this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars SET name='mailexists', value='0'"); 140 return $this->db->query("DELETE FROM ".UC_DBTABLEPRE."mailqueue WHERE mailid='$mailid'"); [all …]
|
H A D | note.php | 20 var $db; variable in notemodel 32 $this->db = $base->db; 85 …$this->db->query("INSERT INTO ".UC_DBTABLEPRE."notelist SET getdata='$getdata', operation='$operat… 86 $insert_id = $this->db->insert_id(); 87 …$insert_id && $this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars (name, value) VALUES ('noteexis… 100 …$this->db->query("REPLACE INTO ".UC_DBTABLEPRE."vars SET name='noteexists".UC_APPID."', value='0'"… 146 …$this->db->query("UPDATE ".UC_DBTABLEPRE."notelist SET app$appid='1', totalnum=totalnum+1, succeed… 149 …$this->db->query("UPDATE ".UC_DBTABLEPRE."notelist SET app$appid = app$appid-'1', totalnum=totalnu… 157 …$data = $this->db->fetch_first("SELECT * FROM ".UC_DBTABLEPRE."notelist WHERE closed='0' AND $app_… 162 …rand(0, UC_NOTE_GC) == 0 && $this->db->query("DELETE FROM ".UC_DBTABLEPRE."notelist WHERE closed='… [all …]
|
/plugin/labeled/ |
H A D | helper.php | 22 static $db; 23 if (!is_null($db)) { 24 return $db; 28 if (is_null($db)) { 33 return $db; 96 $db = $this->getDb(); 107 $db = $this->getDb(); 120 $db = $this->getDb(); 134 $db = $this->getDb(); 162 $db = $this->getDb(); [all …]
|
/plugin/jplayer/vendor/james-heinrich/getid3/getid3/ |
H A D | extension.cache.sqlite3.php | 105 private $db; variable in getID3_cached_sqlite3 133 $db = $this->db; 137 $stmt = $db->prepare($sql); 151 $db=$this->db; 152 $db->close(); 161 $db = $this->db; 163 $db->exec($sql); 193 $db = $this->db; 226 $db = $this->db; 228 return $db->exec($sql); [all …]
|
/plugin/starred/ |
H A D | helper.php | 25 if(!is_null($db) && $db->init('starred', dirname(__FILE__) . '/db/')) { 26 return $db; 42 $db = $this->getDB(); 43 if(!$db) return; 74 $db = $this->getDB(); 75 if(!$db) return false; 84 $row = $db->res2row($res); 98 $db = $this->getDB(); 99 if(!$db) return $result; 118 $res = $db->query($sql, $user); [all …]
|
/plugin/issuelinks/helper/ |
H A D | db.php | 14 private $db = null; variable in helper_plugin_issuelinks_db 26 $db = $this->getDB(); 27 if (!$db) { 67 return $this->db; 77 $db = $this->getDB(); 78 if (!$db) return; 83 $db->query('VACUUM'); 96 if (!$db) { 135 if (!$db) { 188 if (!$db) { [all …]
|
/plugin/tagging/ |
H A D | helper.php | 20 static $db = null; 21 if ($db !== null) { 22 return $db; 27 if ($db === null) { 43 return $db; 125 $db = $this->getDB(); 391 $db = $this->getDB(); 425 $db = $this->getDb(); 521 $res = $db->query( 546 $db->res2arr($res); [all …]
|
/plugin/numbering/scripts/ |
H A D | getnum.php | 18 $db = numberingDB(); 22 $number = getNumberingNextNumber($db, $start); 51 function getNumberingNextNumber($db, $start) { argument 53 io_lock($db); 54 $ar = unserialize(io_readFile($db,false)); 70 file_put_contents($db,serialize($ar)); 71 io_unlock($db); 76 $db = metaFN("numbering:seqnum",'.ser'); 77 if(!file_exists($db)) { 78 io_saveFile($db,"", array()); [all …]
|
/plugin/freechat/phpfreechat/src/containers/ |
H A D | mysql.class.php | 100 $db = $this->_connect($c); 101 if ($db === FALSE) 109 $db_list = mysql_list_dbs($db); 161 $db = $this->_connect(); 173 mysql_query($sql_insert, $db); 196 $db = $this->_connect(); 256 $db = $this->_connect(); 267 mysql_query($sql_insert, $db); 272 mysql_query($sql_update, $db); 290 $db = $this->_connect(); [all …]
|
/plugin/do/ |
H A D | helper.php | 20 private $db = null; variable in helper_plugin_do 28 if (!$this->db) { 33 $this->db = null; 44 if (!$this->db) { 59 if (!$this->db) { 65 $this->db->query( 76 $this->db->query( 104 if (!$this->db) { 257 if (!$this->db) { 294 $this->db->query( [all …]
|
/plugin/blogtng/helper/ |
H A D | sqlite.php | 19 protected $db = null; variable in helper_plugin_blogtng_sqlite 35 if($this->db === null) { 36 $this->db = plugin_load('helper', 'sqlite'); 37 if($this->db === null) { 41 if(!$this->db->init('blogtng', dirname(__FILE__) . '/../db/')) { 42 $this->db = null; 46 return $this->db;
|
/plugin/data/_test/ |
H A D | action_handle.test.php | 14 protected $db; variable in action_handle_test 19 $this->db->query('DELETE FROM pages WHERE page = ?','test'); 27 $this->db = $this->helper->_getDB(); 29 $this->db->query('INSERT INTO pages ( pid, page, title , class , lastmod) VALUES 61 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test'); 62 $pid = $this->db->res2single($res); 68 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test'); 69 $pid = (int) $this->db->res2single($res);
|
/plugin/bez/action/ |
H A D | migration.php | 60 $db->beginTransaction(); 62 $res = $db->query($query); 66 $db->rollBack(); 70 $db->commit(); 93 $db->beginTransaction(); 99 $db->rollBack(); 103 $db->commit(); 134 $db->beginTransaction(); 140 $db->rollBack(); 147 $db->commit(); [all …]
|
/plugin/struct/action/ |
H A D | move.php | 20 protected $db = null; variable in action_plugin_struct_move 45 $this->db = $hlp->getDB(false); 46 if (!$this->db) return false; 51 $this->db->query('BEGIN TRANSACTION'); 85 $ok = $this->db->query('COMMIT TRANSACTION'); 87 $this->db->query('ROLLBACK TRANSACTION'); 107 $this->db->query($sql, array($new, $old)); 111 $this->db->query($sql, array($new, $old)); 125 $this->db->query($sql, array($new, $old)); 140 $this->db->query($sql, array($new, $old)); [all …]
|
/plugin/numbering/ |
H A D | action.php | 78 $db = metaFN("numbering:$db_name",'.ser'); 80 else $db = metaFN("numbering:seqnum",'.ser'); 82 if(!file_exists($db)) { 83 io_saveFile($db,"", array()); 85 return $db; 89 $db = $this->numberingDB(); 91 io_lock($db); 92 $ar = unserialize(io_readFile($db,false)); 108 file_put_contents($db,serialize($ar)); 109 io_unlock($db);
|
/plugin/sqlite/classes/ |
H A D | adapter_sqlite2.php | 10 protected $db; variable in helper_plugin_sqlite_adapter_sqlite2 37 $this->db = sqlite_open($this->dbfile, 0666, $error); 38 if(!$this->db) { 45 $this->db, 'group_concat', 56 sqlite_close($this->db); 63 sqlite_create_function($this->db, $function_name, $callback, $num_args); 74 $res = @sqlite_query($this->db, $sql, SQLITE_ASSOC, $err); 80 sqlite_error_string(sqlite_last_error($this->db)). 241 return sqlite_changes($this->db);
|
H A D | adapter_pdosqlite.php | 13 protected $db; variable in helper_plugin_sqlite_adapter_pdosqlite 32 $this->db->sqliteCreateFunction($function_name, $callback, $num_args); 73 $this->db = new PDO($dsn); 78 $this->db->sqliteCreateAggregate( 90 $this->db = null; 100 $res = $this->db->query($sql); 105 $err = $this->db->errorInfo(); 181 return $this->db->quote($string); 191 return trim($this->db->quote($str), "'");
|
/plugin/data-au/_test/ |
H A D | action_handle.test.php | 27 $this->db = $this->helper->_getDB(); 29 $this->db->query('INSERT INTO pages ( pid, page, title , class , lastmod) VALUES 61 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test'); 62 $pid = $this->db->res2single($res); 68 $res = $this->db->query('SELECT pid FROM pages WHERE page = ?','test'); 69 $pid = (int) $this->db->res2single($res);
|
/plugin/database2/ |
H A D | admin.php | 29 protected $db; variable in admin_plugin_database2 241 $result = $db->getLink()->query( $query ); 254 echo $db->__renderTable( null, $cols, $rows, 289 if ( !( $this->db instanceof Database2_Admin ) ) 294 $db = new Database2_Admin( $this ); 300 if ( $db->connect( $dbFile ) ) 301 $this->db = $db; 305 return $this->db;
|
/plugin/crossdbsqlclient/syntax/ |
H A D | dbwrapper.php | 66 mysqli_autocommit ( $db, TRUE ); 70 if (! $db) { 76 $result = $db->store_result (); 92 $err = mysqli_errno ( $db ); 97 if ($db->more_results ()) { 107 if ($db) { 108 $db->close (); 126 $db = pg_connect ( $url ); 131 if (! $db) { 164 if ($db) { [all …]
|