Exemplo n.º 1
0
 public static function query($q, $params = array())
 {
     if (self::$link === null) {
         self::connect();
     }
     if (!is_array($params)) {
         $params = array_slice(func_get_args(), 1);
     }
     if (!empty($params)) {
         $q = preg_replace('/:(\\d+)/e', 'self::quote($params[\\1 - 1])', $q);
     }
     self::$numQueries++;
     self::$sql = $q;
     self::$result = mysql_query($q, self::$link) or die(mysql_error());
     if (!self::$result) {
         return false;
     } else {
         if (!is_resource(self::$result)) {
             return true;
         }
     }
     $rset = array();
     while ($row = mysql_fetch_assoc(self::$result)) {
         $rset[] = $row;
     }
     return $rset;
 }
Exemplo n.º 2
0
 public function query($query)
 {
     if (!empty($query) && trim($query) != "") {
         self::connect();
         self::$result = mysql_query($query, self::$connection) or Log::write("mysql", mysql_error());
     }
 }
Exemplo n.º 3
0
     $the_tag = str_replace("¡¡", " ", $the_tag);
     $the_tag = str_replace(" ", "_", $the_tag);
     $the_tag = explode(",", $the_tag);
     $max_count = count($the_tag);
     for ($n = 0; $n < $max_count; $n++) {
         $the_tag[$n] = trim($the_tag[$n], "_");
         $the_tag[$n] = mysql_real_escape_string($the_tag[$n]);
         if (strlen($the_tag[$n]) < 3 || preg_match("/[\\d\\.]+/", $the_tag[$n])) {
             $db_tmp->update($setting['db']['pre_sub'] . "news_show", array("tag" => "replace('" . $the_tag[$n] . ",', '', tag)"), array("news_id", "n=", $record['news_id']));
             $db_tmp->update($setting['db']['pre_sub'] . "news_show", array("tag" => "replace('," . $the_tag[$n] . "', '', tag)"), array("news_id", "n=", $record['news_id']));
             continue;
         }
         if (strlen($the_tag[$n] > 50)) {
             $the_tag[$n] = substrPro($the_tag[$n], 0, 50);
         }
         if ($db_tmp->result($setting['db']['pre_sub'] . "news_tag", "id", array("tag", "=", $the_tag[$n]))) {
             $db_tmp->update($setting['db']['pre_sub'] . "news_tag", array("count" => "+1", "update_date" => "UNIX_TIMESTAMP()"), array("tag", "=", $the_tag[$n]));
         } else {
             $db_tmp->insert($setting['db']['pre_sub'] . "news_tag", array(0, $the_tag[$n], 1, 0, "UNIX_TIMESTAMP()", "UNIX_TIMESTAMP()"));
         }
     }
     if (++$n % 50 === 0) {
         $db_tmp->ReConnect(false, $setting['db']['name']);
     }
 }
 $db_tmp->delete($setting['db']['pre_sub'] . "news_tag", array(array("count", "n<", 2), array("click", "n<", 5, "and"), array("add_date", "f<", "UNIX_TIMESTAMP()-60*60*24*10", "and")));
 $db->Free();
 $n = 1;
 $db->select($setting['db']['pre_sub'] . "news_tag", "id, tag");
 while ($record = $db->GetRS()) {
     $counter = $db_tmp->result($setting['db']['pre_sub'] . "news_show", "count(*)", array("tag", "like", $record['tag']));
Exemplo n.º 4
0
    mysql_close();
    include_once "gzip_footer.php";
} else {
    if ($_GET[code] == '01') {
        if ($_POST['system_safe'] != '1') {
            header("location:index.php?act=idx");
        }
        require "memory.php";
        require "function/lib_install.php";
        include_once "gzip_header.php";
        echo "<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"en\">\n<head>\n\t<meta name=\"Author\" content=\"" . $CP[author] . "\">\n\t<meta name=\"Keywords\" content=\"" . $CP[name] . "\">\n\t<meta name=\"Description\" content=\"" . $CP[credit] . "\">\n\t<meta name=\"Copyright\" content=\"" . $CP[name] . " (c) " . $CP[corp] . "\">\n\t<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\">\n\t<link rel=\"stylesheet\" type=\"text/css\" href=\"theme/{$STORED['THEME']}/style.css\">\n\t<style type=\"text/css\">\n\t\t.title_bar {\n\t\t\tBACKGROUND-IMAGE: url(theme/{$STORED['THEME']}/{$THEME['title_bar_img_url']})\n\t\t}\n\t\t.title_bar2 {\n\t\t\tBACKGROUND-IMAGE: url(theme/{$STORED['THEME']}/{$THEME['title_bar2_img_url']})\n\t\t}\n\t</style>\n</head>\n<body " . $background . ">\n";
        $sql = new MySQL();
        $sql->Connect($CONFIG_sql_host, $CONFIG_sql_username, $CONFIG_sql_password);
        $query = "SELECT COUNT(*) FROM {$CONFIG_sql_cpdbname}.memory WHERE memory_object =\"sgcp_install\" AND memory_value1=\"1\"";
        $sql->result = mysql_query($query);
        if (!$sql->result()) {
            if (mysql_select_db($CONFIG_sql_cpdbname)) {
                $dropdb = "DROP DATABASE `{$CONFIG_sql_cpdbname}`;";
                mysql_query($dropdb);
            }
            $createdb = "CREATE DATABASE `{$CONFIG_sql_cpdbname}`;";
            if (mysql_query($createdb)) {
                if ($contents = file_get_contents("install/sql-files/sgcp_database.sql")) {
                    $cpi = new CP_Install();
                    $execute_query = $cpi->promt_query($contents);
                    for ($i = 0; $i < count($execute_query); $i++) {
                        mysql_db_query($CONFIG_sql_cpdbname, $execute_query[$i]);
                    }
                    redir("index.php?act=idx", "Automatic System : has created a {$CONFIG_sql_cpdbname} database", 3);
                } else {
                    redir("index.php?act=idx", "Automatic System : Could not read sgcp_database.sql file", 3);
Exemplo n.º 5
0
<?
/*
 * Sintaxe: table nome da tabela onde procurar a imagem id id da imagem
 * typeField nome do campo tipo da imagem imgField nome do campo onde está a
 * imagem - blob
 */
error_reporting ( E_ALL );
include_once ("classes.inc.php");
$db = new MySQL ();
$db->open ();
$sql = "SELECT *
FROM " . $_REQUEST ['table'] . "
WHERE id_" . $_REQUEST ['table'] . "='" . $_REQUEST ['id'] . "'";
$db->query ( $sql );
$varTabela = $db->result ( 0, $_REQUEST ['typeField'] );
header ( "Content-type: $varTabela" );
echo $db->result ( 0, $_REQUEST ['imgField'] );
$db->close ();
?>
Exemplo n.º 6
0
function check_category($forum_id)
{
    global $CONFIG_sql_cpdbname;
    $forum_id = (int) $forum_id;
    $sql = new MySQL();
    $query = "SELECT category_id FROM {$CONFIG_sql_cpdbname}.forum WHERE forum_id = \"" . mysql_res($forum_id) . "\"";
    $sql->result = $sql->execute_query($query, 'function.php');
    if ($sql->count_rows()) {
        $row = $sql->fetch_row();
        $query = "SELECT COUNT(*) FROM {$CONFIG_sql_cpdbname}.memory WHERE memory_object = \"forum_category\" and memory_value1 = \"" . mysql_res($row['category_id']) . "\"";
        $sql->result = $sql->execute_query($query, 'function.php');
        if (!$sql->result()) {
            return 0;
        }
    } else {
        return 0;
    }
    return $row[category_id];
}
Exemplo n.º 7
0
             }
     }
 } else {
     if ($GET_showtopic && $GET_view) {
         $GET_showtopic = (int) $GET_showtopic;
         if ($GET_view == 'getnewpost') {
             $query = "SELECT reply_id FROM {$CONFIG_sql_cpdbname}.board_reply WHERE topic_id =\"" . mysql_res($GET_showtopic) . "\" ORDER by reply_id DESC";
             $sql->result = $sql->execute_query($query, 'index.php');
             $count_rows_topic = $sql->count_rows();
             $row_get_topic = $sql->fetch_row();
             $reply_id = $row_get_topic[reply_id];
         } else {
             if ($GET_view == 'findpost' && $GET_p) {
                 $query = "SELECT COUNT(*) FROM {$CONFIG_sql_cpdbname}.board_reply WHERE topic_id =\"" . mysql_res($GET_showtopic) . "\" && reply_id<=\"" . mysql_res($GET_p) . "\" ORDER by reply_id DESC";
                 $sql->result = $sql->execute_query($query, 'index.php');
                 $count_rows_topic = $sql->result();
                 $reply_id = $GET_p;
             } else {
                 header("location:index.php?act=idx");
             }
         }
         if ($count_rows_topic <= $CONFIG_per_page) {
             $pages = '1';
         } else {
             if ($count_rows_topic % $CONFIG_per_page == '0') {
                 $pages = $count_rows_topic / $CONFIG_per_page;
             } else {
                 $pages = $count_rows_topic / $CONFIG_per_page + 1;
                 $pages = (int) $pages;
             }
         }
Exemplo n.º 8
0
function get_attn_reg($check, $val, $val2)
{
    header("Content-type: text/xml;charset=iso-8859-3");
    global $CONFIG_sql_dbname, $lang;
    $sql = new MySQL();
    $check = strip_tags($check);
    switch ($check) {
        case "userid":
            $query = "SELECT userid FROM {$CONFIG_sql_dbname}.login WHERE userid = \"" . mysql_res($val) . "\"";
            if (!length($val, 4, 24)) {
                echo "- {$lang['Reg_attn_1']}";
            } else {
                if (!isAlphaNumeric($val)) {
                    echo "- {$lang['Reg_attn_11']}";
                } else {
                    if ($sql->count_rows($sql->execute_query($query, 'lib_ajax.php'))) {
                        echo "- {$lang['Reg_attn_2']}";
                    }
                }
            }
            break;
        case "pass":
            if (!length($val, 4, 24)) {
                echo "- {$lang['Reg_attn_3']}";
            } else {
                if (!isAlphaNumeric($val)) {
                    echo "- {$lang['Reg_attn_12']}";
                }
            }
            break;
        case "pass2":
            if ($val != $val2) {
                echo "- {$lang['Reg_attn_4']}";
            } else {
                if (!isAlphaNumeric($val)) {
                    echo "- {$lang['Reg_attn_13']}";
                } else {
                    if (!length($val, 4, 24)) {
                        echo "- {$lang['Reg_attn_5']}";
                    }
                }
            }
            break;
        case "slspass":
            if (!length($val, 4, 24)) {
                echo "- {$lang['Reg_attn_6']}";
            } else {
                if (!isAlphaNumeric($val)) {
                    echo "- {$lang['Reg_attn_14']}";
                }
            }
            break;
        case "slspass2":
            if ($val != $val2) {
                echo "- {$lang['Reg_attn_7']}";
            } else {
                if (!isAlphaNumeric($val)) {
                    echo "- {$lang['Reg_attn_15']}";
                } else {
                    if (!length($val, 4, 24)) {
                        echo "- {$lang['Reg_attn_8']}";
                    }
                }
            }
            break;
        case "email":
            $query = "SELECT COUNT(*) FROM {$CONFIG_sql_dbname}.login WHERE email = \"" . mysql_res($val) . "\"";
            if (!isMailform($val)) {
                echo "- {$lang['Reg_attn_9']}";
            } else {
                if ($sql->result($sql->execute_query($query, 'lib_ajax.php'))) {
                    echo "- {$lang['Reg_attn_10']}";
                }
            }
            break;
    }
}