commit: 1ce3c9c90a14683c6900e9812202c6fa355e53df
Author: Brian Evans <grknight <AT> gentoo <DOT> org>
AuthorDate: Tue Jan 30 15:38:23 2018 +0000
Commit: Brian Evans <grknight <AT> gentoo <DOT> org>
CommitDate: Tue Jan 30 15:38:23 2018 +0000
URL: https://gitweb.gentoo.org/proj/bouncer.git/commit/?id=1ce3c9c9
Remove old db lib backup
php/lib/db.php.orig | 306 ----------------------------------------------------
1 file changed, 306 deletions(-)
diff --git a/php/lib/db.php.orig b/php/lib/db.php.orig
deleted file mode 100644
index 23dd1ea..0000000
--- a/php/lib/db.php.orig
+++ /dev/null
@@ -1,306 +0,0 @@
-<?php
-/**
- * Minimal wrappers for core PHP mysql_* functions.
- * @package mirror
- * @subpackage lib
- */
-
-/**
- * Connect to a MySQL database server.
- * @param string $host db server, defaults to localhost
- * @param string $user db username
- * @param string $password db password
- * @return resource dbh
- */
-function db_connect($host='localhost',$user=null,$password=null)
-{
- static $dbh = null;
- if (!empty($host) && isset($user) && isset($password)) {
- $dbh = @mysql_connect($host,$user,$password);
- }
- if (is_resource($dbh)) {
- return $dbh;
- }
- else die("Unable to create database connection in db_connect()");
-}
-
-/**
- * Select database.
- * @param string $database name of the database to select
- * @param resource $dbh valid dbh, null if not defined
- * @return bool success of command
- */
-function db_select($database,$dbh=null)
-{
- if(is_resource($dbh)){
- return @mysql_select_db($database);
- }else{
- return @mysql_select_db($database, db_connect());
- }
-
-}
-
-/**
- * Execute a MySQL query.
- * @param string $qry MySQL query
- * @param resource $dbh valid dbh
- */
-function db_query($qry=null,$dbh=null)
-{
- static $result = null;
- if(!is_resource($dbh)) $dbh = db_connect();
- printf("q:%s dbh=%s\n",$qry,$dbh);
- if(is_null($qry))
- {
- if(is_resource($result)) return $result;
- else return false;
- }
- else
- {
- $result = mysql_query($qry,$dbh);
- return $result;
- }
-}
-
-/**
- * Fetch a row as an array from a result.
- * @param string $result (default to null)
- * @return array
- */
-function db_fetch($result=null,$type=MYSQL_BOTH)
-{
- if(!is_resource($result)) {
- print 'Rerun query"'.$result.'"';
- return @mysql_fetch_array(db_query());
- } else {
- return @mysql_fetch_array($result,$type);
- }
-}
-
-/**
- * Fetch an array based on a query.
- * @param string $query database query
- * @param int $type result type
- * @param string $col_id if passed it, the values of this column in the
result set will be used as the array keys in the returned array
- * @return array $list array of database rows
- * Example of returned array:
- * <code>
- * db_get("SELECT * FROM table",MYSQL_ASSOC);
- * returns...
- * Array
- * (
- * [0] => Array
- * (
- * [id] => 1
- * [field1] => data1
- * [field2] => data2
- * )
- *
- * )
- * </code>
- */
-function db_get($query,$type=MYSQL_BOTH,$col_id=NULL)
-{
- $res = db_query($query);
- $list = array();
- if (is_resource($res) && !is_null($col_id) && ($type == MYSQL_BOTH ||
$type == MYSQL_ASSOC) && @mysql_num_rows($res) !== 0) {
- $col_test = db_fetch($res,$type);
- @mysql_data_seek($res, 0);
- if (array_key_exists($col_id,$col_test)) {
- while ( $buf = db_fetch($res,$type) ) {
- $list[$buf[$col_id]] = $buf;
- }
- return $list;
- }
- }
- while ( $buf = db_fetch($res,$type) ) {
- $list[] = $buf;
- }
- return $list;
-}
-
-/**
- * Get all of the fieldnames for the specified table.
- * @param string $table name of table to describe
- * @return array array of column names, must be an array
- */
-function db_fieldnames($table)
-{
- $dbh = db_connect();
- $results = db_query("DESCRIBE $table");
- if (is_resource($results))
- {
- while ($buf=db_fetch($results))
- {
- $field_names[] = $buf[0];
- }
- }
- else
- {
- $field_names[] = 0;
- }
- return $field_names;
-}
-
-/**
- * Create a MySQL INSERT statement based on $_POST array generated by form
submission.
- * <ul>
- * <li>does not work with mysql functions (PASSWORD, etc.) because
there are forced double quotes</li>
- * <li>do not use clean_in() before this, or you'll have double
the slashes</li>
- * <li>use the function only when it saves you time, not
_always_</li>
- * <li>form items not set will not be processed (unchecked radios,
checkboxes) - handle these manually, or don't use the func</li>
- * </ul>
- * @param array $vars array of posts
- * @param string $table name of the table that fields will be inserted into
- * @return string $query resulting MySQL insert string
- */
-function db_makeinsert($vars,$table)
-{
- $dbh = db_connect();
- $fields = db_fieldnames($table);
- foreach ($fields as $field)
- {
- if (get_magic_quotes_gpc) $vars[$field] = stripslashes($vars[$field]);
- $vars[$field] = addslashes($vars[$field]);
- if (isset($vars[$field]))
- {
- isset($q1)?$q1 .= ','.$field:$q1='INSERT INTO '.$table.'('.$field;
- isset($q2)?$q2 .= ",'$vars[$field]'":$q2=" VALUES('$vars[$field]'";
- }
- }
- $q1 .= ')';
- $q2 .= ')';
- $query = $q1.$q2;
- return $query;
-}
-
-/**
- * Create a MySQL REPLACE statement based on $_POST array generated by
form submission.
- * <ul>
- * <li>does not work with mysql functions (PASSWORD, etc.) because
there are forced double quotes</li>
- * <li>do not use clean_in() before this, or you'll have double
the slashes</li>
- * <li>use the function only when it saves you time, not
_always_</li>
- * <li>form items not set will not be processed (unchecked radios,
checkboxes) - handle these manually, or don't use the func</li>
- * </ul>
- * @param array $vars array of posts
- * @param string $table name of the table that fields will be inserted into
- * @return string $query resulting MySQL insert string
- */
-function db_makereplace($vars,$table)
-{
- $dbh = db_connect();
- $fields = db_fieldnames($table);
- foreach ($fields as $field)
- {
- if (get_magic_quotes_gpc) $vars[$field] = stripslashes($vars[$field]);
- $vars[$field] = addslashes($vars[$field]);
- if (isset($vars[$field]))
- {
- isset($q1)?$q1 .= ','.$field:$q1='REPLACE INTO '.$table.'('.$field;
- isset($q2)?$q2 .= ",'$vars[$field]'":$q2=" VALUES('$vars[$field]'";
- }
- }
- $q1 .= ')';
- $q2 .= ')';
- $query = $q1.$q2;
- return $query;
-}
-
-/**
- * Create a MySQL UPDATE statement based on $_POST array generated by form
submission.
- * <ul>
- * <li>does not work with mysql functions (PASSWORD, etc.) because
there are forced double quotes</li>
- * <li>do not use clean_in() before this, or you'll have double
the slashes</li>
- * <li>use the function only when it saves you time, not
_always_</li>
- * <li>form items not set will not be processed (unchecked radios,
checkboxes) - handle these manually, or don't use the func</li>
- * </ul>
- * @param array $vars array of posts
- * @param string $table name of the table that fields will be inserted into
- * @param string $where where clause, describing which records are to be
updated
- */
-function db_makeupdate($vars,$table,$where)
-{
- $dbh = db_connect();
- $fields = db_fieldnames($table);
- foreach ($fields as $field)
- {
- if (isset($vars[$field]))
- {
- if (get_magic_quotes_gpc()) $vars[$field] =
stripslashes($vars[$field]);
- $vars[$field]=addslashes($vars[$field]);
- $q1 = isset($q1)?$q1 .= '
,'.$field."='$vars[$field]'":'UPDATE '.$table.' set '.$field."='$vars[$field]'";
- }
- }
- $query = $q1.' '.$where;
- return $query;
-}
-
-/**
- * Since PHP's mysql_insert_id() sometimes throws an error, this is the
replacement
- * @param resource $dbh optional dbh to get the last inserted id from
- * @return int the return value of MySQL's last_insert_id()
- */
-function db_insert_id($dbh=null)
-{
- if(!is_resource($dbh)) $dbh = db_connect();
- $buf = db_fetch(db_query("SELECT LAST_INSERT_ID()", $dbh));
- return empty($buf[0]) ? false : $buf[0];
-}
-
-/**
- * Determine number of rows in result.
- * @param resource $result mysql result
- * @return int number of rows in query result
- */
-function db_numrows($result=null)
-{
- return (!is_resource($result))? @mysql_num_rows(db_query()) :
@mysql_num_rows($result);
-}
-
-/**
- * Close the db connection. If a dbh is not specified, assume the last
opened link.
- * @param resource $dbh optional dbh to close
- */
-function db_close($dbh=null)
-{
- return is_resource($dbh)?@mysql_close($dbh):@mysql_close();
-}
-
-/**
- * Get one record.
- * @param string $query query
- * @param int $type result type
- */
-function db_get_one($query,$type=MYSQL_ASSOC) {
- $buf = db_get($query.' LIMIT 1',$type);
- return $buf[0];
-}
-
-/**
- * Get an ID based on name.
- * @param string $table
- * @param string $id_col
- * @param string $name_col
- * @param string $name
- */
-function db_name_to_id($table,$id_col,$name_col,$name)
-{
- $q = "SELECT {$id_col} FROM {$table} WHERE {$name_col} = '{$name}'";
- print 'Query: '.$q."<br />\n";
- $buf = db_get_one($q, MYSQL_NUM);
- return $buf[0];
-}
-
-/**
- * Sets enum booleans to their opposite
- * @param string $table
- * @param string $pri
- * @param string $col
- * @param array $id
- * @return int
- */
-function db_toggle_bool($table, $pri, $col, $id)
-{
- return db_query("UPDATE {$table} SET {$col} = IF({$col} = '1', '0', '1')
WHERE {$pri} = {$id}");
-}
-?>
