Home
last modified time | relevance | path

Searched refs:db (Results 1 – 25 of 164) sorted by relevance

1234567

/plugin/authucenter/lib/uc_client/model/
H A Dpm.php24 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 Duser.php14 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 Ddomain.php14 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 Dfriend.php14 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 Dtag.php14 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 Dmail.php16 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 Dnote.php20 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 Dhelper.php22 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 Dextension.cache.sqlite3.php105 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 Dhelper.php25 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/tagging/
H A Dhelper.php20 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/issuelinks/helper/
H A Ddb.php14 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/do/
H A Dhelper.php20 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/freechat/phpfreechat/src/containers/
H A Dmysql.class.php100 $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/numbering/scripts/
H A Dgetnum.php18 $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/bez/action/
H A Dmigration.php60 $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/blogtng/helper/
H A Dsqlite.php19 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 Daction_handle.test.php14 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/struct/action/
H A Dmove.php20 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 Daction.php78 $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 Dadapter_sqlite2.php10 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 Dadapter_pdosqlite.php13 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 Daction_handle.test.php27 $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 Dadmin.php29 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 Ddbwrapper.php66 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 …]

1234567