Clansphere :: FREE Clan Content Management System

<?php
// ClanSphere 2007 - www.clansphere.net
// $Id: pdo_sqlite.php 101 2006-07-12 09:36:29Z hajo $

function cs_sql_count($cs_file,$sql_table,$sql_where = 0, $distinct = 0) {

global $cs_db;

$row = empty($distinct) ? '*' : 'DISTINCT ' . $distinct;

$sql_query = 'SELECT COUNT('.$row.') FROM ' . $cs_db['prefix'] . '_' . $sql_table;
$sql_query .= empty($sql_where) ? '' : ' WHERE ' . $sql_where;

$sql_query = str_replace('{pre}',$cs_db['prefix'],$sql_query);
if($sql_data = $cs_db['con']->query($sql_query, PDO::FETCH_NUM)) {
$sql_result = $sql_data->fetch();
$sql_data = NULL;
$result = $sql_result[0];
}
else {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_count', $error[2]);
$result = 0;
}
cs_log_sql($sql_query);
return $result;
}

function cs_sql_delete($cs_file,$sql_table,$sql_id,$sql_field = 0) {

global $cs_db;
settype($sql_id,'integer');
if(empty($sql_field)) {
$sql_field = $sql_table . '_id';
}
$sql_delete = 'DELETE FROM ' . $cs_db['prefix'] . '_' . $sql_table;
$sql_delete .= ' WHERE ' . $sql_field . ' = ' . $sql_id;
if(!$cs_db['con']->query($sql_delete)) {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_delete', $error[2]);
}
cs_log_sql($sql_delete,1);
}

function cs_sql_escape($string) {

global $cs_db;
$string = $cs_db['con']->quote($string);
return substr($string,1,-1);
}

function cs_sql_insert($cs_file,$sql_table,$sql_cells,$sql_content) {

global $cs_db;
$max = count($sql_cells);
$set = " (";
for($run=0; $run<$max; $run++) {
$set .= $sql_cells[$run];
if($run != $max - 1) { $set .= ","; }
}
$set .= ") VALUES (";
for($run=0; $run<$max; $run++) {
$set .= $cs_db['con']->quote($sql_content[$run]);
if($run != $max - 1) { $set .= ','; }
}
$set .= ')';

$sql_insert = 'REPLACE INTO ' . $cs_db['prefix'] . '_' . $sql_table . $set;
if(!$cs_db['con']->query($sql_insert)) {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_insert', $error[2]);
}
cs_log_sql($sql_insert,1);
}

function cs_sql_insertid($cs_file) {

global $cs_db;
if($cs_db['type'] == 'pdo_pgsql') {
$sql_query = 'SELECT LASTVAL()';
cs_log_sql($sql_query);
if($sql_data = $cs_db['con']->query($sql_query, PDO::FETCH_NUM)) {
$sql_result = $sql_data->fetch();
$sql_data = NULL;
$result = $sql_result[0];
}
}
else {
$result = $cs_db['con']->lastInsertId();
}
if($result > 0) {
return $result;
}
else {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_insertid', $error[2]);
}
}

function cs_sql_option($cs_file,$mod) {

global $cs_db;
$result = 0;
$sql_query = 'SELECT options_name, options_value FROM ' . $cs_db['prefix'] . '_' . 'options';
$sql_query .= " WHERE options_mod='" . $mod . "'";
if($sql_data = $cs_db['con']->query($sql_query, PDO::FETCH_ASSOC)) {
while($sql_result = $sql_data->fetch()) {
$name = $sql_result['options_name'];
$new_result[$name] = $sql_result['options_value'];
}
$sql_data = NULL;
if(!empty($new_result)) {
$result = $new_result;
}
}
else {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_option', $error[2]);
}
cs_log_sql($sql_query);
return $result;
}

function cs_sql_query($cs_file,$sql_query) {

global $cs_db;
$sql_query = str_replace('{pre}',$cs_db['prefix'],$sql_query);
if($sql_data = $cs_db['con']->query($sql_query)) {
$result = array('affected_rows' => $sql_data->rowCount());
}
else {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_query', $error[2]);
$result = 0;
}
cs_log_sql($sql_query);
return $result;
}

function cs_sql_select($cs_file,$sql_table,$sql_select,$sql_where = 0,$sql_order = 0,$first = 0,$max = 1) {

global $cs_db;
settype($first,'integer');
settype($max,'integer');
$new_result = 0;
$run = 0;
$sql_query = 'SELECT ' . $sql_select . ' FROM ' . $cs_db['prefix'] . '_' . $sql_table;
if(!empty($sql_where)) {
$sql_query .= ' WHERE ' . $sql_where;
}
if(!empty($sql_order)) {
$sql_query .= ' ORDER BY ' . $sql_order;
}
if(!empty($max)) {
$limit = $cs_db['type'] == 'pdo_pgsql' ? $max . ' OFFSET ' . $first : $first . ',' . $max;
$sql_query .= ' LIMIT ' . $limit;
}
$sql_query = str_replace('{pre}',$cs_db['prefix'],$sql_query);
cs_log_sql($sql_query);
if($sql_data = $cs_db['con']->query($sql_query)) {
$new_result = $max == 1 ? $sql_data->fetch(PDO::FETCH_ASSOC) : $sql_data->fetchAll(PDO::FETCH_ASSOC);
$sql_data = NULL;
}
else {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_select', $error[2]);
}

if(!empty($new_result)) {
return $new_result;
}
}

function cs_sql_update($cs_file,$sql_table,$sql_cells,$sql_content,$sql_id,$sql_where = 0) {

global $cs_db;
settype($sql_id,'integer');
$max = count($sql_cells);
$set = ' SET ';
for($run=0; $run<$max; $run++) {
$set .= $sql_cells[$run] . '=' . $cs_db['con']->quote($sql_content[$run]);
if($run != $max - 1) { $set .= ', '; }
}

$sql_update = 'UPDATE ' . $cs_db['prefix'] . '_' . $sql_table . $set . ' WHERE ';
if(empty($sql_where)) {
$sql_update .= $sql_table . "_id='" . $sql_id . "'";
}
else {
$sql_update .= $sql_where;
}
$action = $sql_cells[0] == 'users_laston' OR $sql_table == 'count' ? 0 : 1;
if(!$cs_db['con']->query($sql_update)) {
$error = $cs_db['con']->errorInfo();
cs_error_sql($cs_file, 'cs_sql_update', $error[2]);
}
cs_log_sql($sql_update,$action);
}

?>

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Warning: getimagesize(../../uploads/gallery/pics/GM-Joern 2.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /var/www/html/web600/html/mods/gallery/image.php on line 243

Notice: Undefined variable: im in /var/www/html/web600/html/mods/gallery/image.php on line 277

Fatal error: Call to a member function dump() on a non-object in /var/www/html/web600/html/mods/gallery/image.php on line 277

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Warning: getimagesize(../../uploads/gallery/pics/GM-Joern 2.jpg) [function.getimagesize]: failed to open stream: No such file or directory in /var/www/html/web600/html/mods/gallery/image.php on line 242

Warning: imagesx(): supplied argument is not a valid Image resource in /var/www/html/web600/html/mods/gallery/image.php on line 113

Warning: imagesy(): supplied argument is not a valid Image resource in /var/www/html/web600/html/mods/gallery/image.php on line 114

Warning: imagesx(): supplied argument is not a valid Image resource in /var/www/html/web600/html/mods/gallery/image.php on line 113

Warning: imagesy(): supplied argument is not a valid Image resource in /var/www/html/web600/html/mods/gallery/image.php on line 114

Warning: imagejpeg(): supplied argument is not a valid Image resource in /var/www/html/web600/html/mods/gallery/image.php on line 120

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|

Greetz Swifter

Wenn du dich klein, nutzlos, beleidigt und depressiv fühlst, denke immer daran: Du warst einmal das schnellste und erfolgreichste Spermium deiner Gruppe!

|