Verzeichnisstruktur phpBB-2.0.0
- Veröffentlicht
- 03.04.2002
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
mysql.php
001 <?php
002 /***************************************************************************
003 * mysql.php
004 * -------------------
005 * begin : Saturday, Feb 13, 2001
006 * copyright : (C) 2001 The phpBB Group
007 * email : support@phpbb.com
008 *
009 * $Id$
010 *
011 ***************************************************************************/
012
013 /***************************************************************************
014 *
015 * This program is free software; you can redistribute it and/or modify
016 * it under the terms of the GNU General Public License as published by
017 * the Free Software Foundation; either version 2 of the License, or
018 * (at your option) any later version.
019 *
020 ***************************************************************************/
021
022 if(!defined("SQL_LAYER"))
023 {
024
025 define("SQL_LAYER","mysql");
026
027 class sql_db
028 {
029
030 var $db_connect_id;
031 var $query_result;
032 var $row = array();
033 var $rowset = array();
034 var $num_queries = 0;
035
036 //
037 // Constructor
038 //
039 function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
040 {
041
042 $this->persistency = $persistency;
043 $this->user = $sqluser;
044 $this->password = $sqlpassword;
045 $this->server = $sqlserver;
046 $this->dbname = $database;
047
048 if($this->persistency)
049 {
050 $this->db_connect_id = @mysql_pconnect($this->server, $this->user, $this->password);
051 }
052 else
053 {
054 $this->db_connect_id = @mysql_connect($this->server, $this->user, $this->password);
055 }
056 if($this->db_connect_id)
057 {
058 if($database != "")
059 {
060 $this->dbname = $database;
061 $dbselect = @mysql_select_db($this->dbname);
062 if(!$dbselect)
063 {
064 @mysql_close($this->db_connect_id);
065 $this->db_connect_id = $dbselect;
066 }
067 }
068 return $this->db_connect_id;
069 }
070 else
071 {
072 return false;
073 }
074 }
075
076 //
077 // Other base methods
078 //
079 function sql_close()
080 {
081 if($this->db_connect_id)
082 {
083 if($this->query_result)
084 {
085 @mysql_free_result($this->query_result);
086 }
087 $result = @mysql_close($this->db_connect_id);
088 return $result;
089 }
090 else
091 {
092 return false;
093 }
094 }
095
096 //
097 // Base query method
098 //
099 function sql_query($query = "", $transaction = FALSE)
100 {
101 // Remove any pre-existing queries
102 unset($this->query_result);
103 if($query != "")
104 {
105 $this->num_queries++;
106
107 $this->query_result = @mysql_query($query, $this->db_connect_id);
108 }
109 if($this->query_result)
110 {
111 unset($this->row[$this->query_result]);
112 unset($this->rowset[$this->query_result]);
113 return $this->query_result;
114 }
115 else
116 {
117 return ( $transaction == END_TRANSACTION ) ? true : false;
118 }
119 }
120
121 //
122 // Other query methods
123 //
124 function sql_numrows($query_id = 0)
125 {
126 if(!$query_id)
127 {
128 $query_id = $this->query_result;
129 }
130 if($query_id)
131 {
132 $result = @mysql_num_rows($query_id);
133 return $result;
134 }
135 else
136 {
137 return false;
138 }
139 }
140 function sql_affectedrows()
141 {
142 if($this->db_connect_id)
143 {
144 $result = @mysql_affected_rows($this->db_connect_id);
145 return $result;
146 }
147 else
148 {
149 return false;
150 }
151 }
152 function sql_numfields($query_id = 0)
153 {
154 if(!$query_id)
155 {
156 $query_id = $this->query_result;
157 }
158 if($query_id)
159 {
160 $result = @mysql_num_fields($query_id);
161 return $result;
162 }
163 else
164 {
165 return false;
166 }
167 }
168 function sql_fieldname($offset, $query_id = 0)
169 {
170 if(!$query_id)
171 {
172 $query_id = $this->query_result;
173 }
174 if($query_id)
175 {
176 $result = @mysql_field_name($query_id, $offset);
177 return $result;
178 }
179 else
180 {
181 return false;
182 }
183 }
184 function sql_fieldtype($offset, $query_id = 0)
185 {
186 if(!$query_id)
187 {
188 $query_id = $this->query_result;
189 }
190 if($query_id)
191 {
192 $result = @mysql_field_type($query_id, $offset);
193 return $result;
194 }
195 else
196 {
197 return false;
198 }
199 }
200 function sql_fetchrow($query_id = 0)
201 {
202 if(!$query_id)
203 {
204 $query_id = $this->query_result;
205 }
206 if($query_id)
207 {
208 $this->row[$query_id] = @mysql_fetch_array($query_id);
209 return $this->row[$query_id];
210 }
211 else
212 {
213 return false;
214 }
215 }
216 function sql_fetchrowset($query_id = 0)
217 {
218 if(!$query_id)
219 {
220 $query_id = $this->query_result;
221 }
222 if($query_id)
223 {
224 unset($this->rowset[$query_id]);
225 unset($this->row[$query_id]);
226 while($this->rowset[$query_id] = @mysql_fetch_array($query_id))
227 {
228 $result[] = $this->rowset[$query_id];
229 }
230 return $result;
231 }
232 else
233 {
234 return false;
235 }
236 }
237 function sql_fetchfield($field, $rownum = -1, $query_id = 0)
238 {
239 if(!$query_id)
240 {
241 $query_id = $this->query_result;
242 }
243 if($query_id)
244 {
245 if($rownum > -1)
246 {
247 $result = @mysql_result($query_id, $rownum, $field);
248 }
249 else
250 {
251 if(empty($this->row[$query_id]) && empty($this->rowset[$query_id]))
252 {
253 if($this->sql_fetchrow())
254 {
255 $result = $this->row[$query_id][$field];
256 }
257 }
258 else
259 {
260 if($this->rowset[$query_id])
261 {
262 $result = $this->rowset[$query_id][0][$field];
263 }
264 else if($this->row[$query_id])
265 {
266 $result = $this->row[$query_id][$field];
267 }
268 }
269 }
270 return $result;
271 }
272 else
273 {
274 return false;
275 }
276 }
277 function sql_rowseek($rownum, $query_id = 0){
278 if(!$query_id)
279 {
280 $query_id = $this->query_result;
281 }
282 if($query_id)
283 {
284 $result = @mysql_data_seek($query_id, $rownum);
285 return $result;
286 }
287 else
288 {
289 return false;
290 }
291 }
292 function sql_nextid(){
293 if($this->db_connect_id)
294 {
295 $result = @mysql_insert_id($this->db_connect_id);
296 return $result;
297 }
298 else
299 {
300 return false;
301 }
302 }
303 function sql_freeresult($query_id = 0){
304 if(!$query_id)
305 {
306 $query_id = $this->query_result;
307 }
308
309 if ( $query_id )
310 {
311 unset($this->row[$query_id]);
312 unset($this->rowset[$query_id]);
313
314 @mysql_free_result($query_id);
315
316 return true;
317 }
318 else
319 {
320 return false;
321 }
322 }
323 function sql_error($query_id = 0)
324 {
325 $result["message"] = @mysql_error($this->db_connect_id);
326 $result["code"] = @mysql_errno($this->db_connect_id);
327
328 return $result;
329 }
330
331 } // class sql_db
332
333 } // if ... define
334
335 ?>