Пример #1
0
function query($db, $sql)
{
    global $utftrans;
    if ($utftrans) {
        $sql = utf8_encode($sql);
    }
    $rc = $db->query($sql);
    if (DB::isError($rc)) {
        dbFehler($sql, $rc->userinfo);
        return false;
    }
    return $rc;
}
Пример #2
0
*Copyright: (c) 2004 Lx-System
*License: non free
*eMail: info@lx-system.de
*Version: 1.0.0
*Shop: osCommerce 2.2
***************************************************************/
$login = $_GET["login"];
require_once "DB.php";
require_once "conf{$login}.php";
$LAND = array("Germany" => "D");
$db = DB::connect($SHOPdns);
if (!$db) {
    dbFehler("", $db->getDebugInfo());
}
if (DB::isError($db)) {
    dbFehler("", $db->getDebugInfo());
    die($db->getDebugInfo());
}
function createCategory($name, $maingroup)
{
    global $db, $langs;
    $newID = uniqid(rand());
    $sql = "insert into categories (categories_image,parent_id,date_added) values ('{$newID}',{$maingroup},now())";
    $rc = $db->query($sql);
    $sql = "select * from categories where categories_image = '{$newID}'";
    $rs = $db->getAll($sql, DB_FETCHMODE_ASSOC);
    $id = $rs[0]["categories_id"];
    $sql = "update categories set categories_image = null where categories_id={$id}";
    $rc = $db->query($sql);
    echo "({$name}) ";
    foreach ($langs as $LANG) {