PHP Archive::getSQLQueries方法代码示例

<?php

try {
    $Archive = new Archive();
    $Archive->setFilename("index.php");
    $Archive->setPage($_GET['page'], "page");
    if (!$_COOKIE['login']) {
        $Archive->setPublic(1);
    }
    $Archive->DateList();
    $AboutMe = array(array("title" => "Information", "info" => array("Alias" => "Compubomb", "Name" => "Robert Kraig", "Height" => "5'11")), array("title" => "Contact", "info" => array("ICQ" => "59128707", "AIM" => "c0mpub0mb", "YIM" => "compubomb", "MSN" => "compubomb at hotmail.com", "Email" => "robertkraig at gmail.com")), array("title" => "Community Sites", "info" => array("myspace.com" => "<a href=\"http://www.myspace.com/compubomb\">Here</a>", "okcupid.com" => "<a href=\"http://www.okcupid.com/profile?u=compubomb\">Here</a>")), array("title" => "Music Genres", "info" => array("Electronic" => "*Trance, Deep House, Disco House, Progressive House, Ibiza/Chillout", "Jazz" => "Smooth, Acid, Traditional", "POP" => "Everything that has a catchy beat")), array("title" => "Music Artists", "info" => array("Trance" => "Armin Van Burrent, DJ Tiesto, Ferry Corsten, Paul Van Dyke, Chicane", "Deep House" => "DJ Mark Farina", "Dream House" => "Robert Miles", "Chillout" => "Cafe Del Mar")), array("title" => "Community Sites", "info" => array("OS" => "Microsoft Windows XP sp3 Pro, Ubuntu", "Graphics" => "Adobe Photoshop CS3", "Desk.Pub" => "Indesign CS3", "Web Dev" => "Adobe Dreamweaver CS3, Zend Studio Eclipse, Notepad++, gvim 7.0")));
    $smarty->assign(array("page_name" => "About Me", "load" => "aboutme.tpl", "filename" => $Archive->getFilename(), "archive_index" => $Archive->getIndex(), "sql_queries" => $Archive->getSQLQueries(), "aboutme" => $AboutMe));
    $smarty->display('public/body/index.tpl');
    echo "<!-- page rendered in approx {$timer->Stop()} -->";
} catch (Exception $e) {
    $smarty->assign(array("exception" => $e->getMessage()));
    $smarty->display('public/body/error.tpl');
}

    $linksCat->setId($vars['cat']);
    $Archive->BuildData();
    $links->BuildData();
    $linksCat->BuildData();
    if ($vars['url']) {
        if (is_array($row = $links->getRecords())) {
            foreach ($row as $info) {
                $url = $info['link_url'];
            }
            header("location: {$url}");
        }
    } else {
        if ($vars['cat']) {
            $title = "Links : ( {$linksCat->getTitle($links->getCatId())} ) Page : " . (1 + $links->getPage()) . " of " . $links->getnumOfRecords();
            $loadFile = "links.tpl";
            $records = $links->getRecords();
            $pageList = $links->getCountDisplay();
        } else {
            $title = "Link Categories : Page : " . (1 + $linksCat->getPage()) . " of " . $linksCat->getnumOfRecords();
            $loadFile = "linkcat.tpl";
            $records = $linksCat->getRecords();
            $pageList = $linksCat->getCountDisplay();
        }
        $smarty->assign(array("page_name" => $title, "load" => "links/" . $loadFile, "filename" => $Archive->getFilename(), "archive_index" => $Archive->getIndex(), "records" => $records, "page_list" => $pageList, "sql_queries" => array_merge($Archive->getSQLQueries(), $links->getSQLQueries(), $linksCat->getSQLQueries())));
        $smarty->display('public/body/index.tpl');
        echo "<!-- page rendered in approx {$timer->Stop()} -->";
    }
} catch (Exception $e) {
    $smarty->assign(array("exception" => $e->getMessage()));
    $smarty->display('public/body/error.tpl');
}

        if (!(strlen($alias) > 3)) {
            $error[] = "alias must be greater than 3 characters";
            $e_alias = true;
        }
        if (!eregi($regex, $email)) {
            $error[] = "Email is Not AlphaNumeric. These are the only allowed non-alphanumeric characters ( - . @ )";
            $e_email = true;
        }
        if (count($error) > 0) {
            $loadfile = "register/register_error.tpl";
        } else {
            $user->CountRecords($email);
            if (!$user->getRecordNum()) {
                $var = array("email" => $email, "username" => $username, "password" => $password, "alias" => $alias);
                $user->Insert($var);
                $loadfile = "register/register_successful.tpl";
            } else {
                $loadfile = "register/register_email.tpl";
                $e_email = true;
            }
        }
    } else {
        $loadfile = "register/register_form.tpl";
    }
    $smarty->assign(array("page_name" => "Register", "load" => $loadfile, "error" => $error, "archive_index" => $Archive->getIndex(), "sql_queries" => array_merge($Archive->getSQLQueries()), "username" => $e_username, "alias" => $e_alias, "password" => $e_password, "email" => $e_email));
    $smarty->display('public/body/index.tpl');
    echo "<!-- page rendered in approx {$timer->Stop()} -->";
} catch (Exception $e) {
    $smarty->assign(array("exception" => $e->getMessage()));
    $smarty->display('public/body/error.tpl');
}

    $Archive->setPage($vars['page'], "page");
    $Archive->setFilename("/Archive");
    $Archive->setDay($vars['day']);
    $Archive->setMonth($vars['month']);
    $Archive->setYear($vars['year']);
    $Archive->setUserId($vars['user']);
    $Archive->setId($vars['post']);
    $Archive->setCatId($vars['cat']);
    if (!$_SESSION['login']) {
        $Archive->setPublic(1);
    }
    $ArchiveCategories = new ArchiveCategories();
    $Archive->BuildData();
    $ArchiveCategories->BuildData();
    if (isal_num($vars['cat'])) {
        $title = " ( {$ArchiveCategories->getTitle($Archive->getCatId())} {$Archive->getLookupDate()}) : Page : " . (1 + $Archive->getPage()) . " of " . $Archive->getnumOfRecords();
    } else {
        if ($Archive->getLibUseType() == "archive") {
            $title = " : Archive ( {$Archive->getLookupDate()} ) Page : " . (1 + $Archive->getPage()) . " of " . $Archive->getnumOfRecords();
        } else {
            $title = " : Page : " . (1 + $Archive->getPage()) . " of " . $Archive->getnumOfRecords();
        }
    }
    //
    $smarty->assign(array("page_name" => "News" . $title, "load" => "news/news.tpl", "filename" => $Archive->getFilename(), "archive_index" => $Archive->getIndex(), "records" => $Archive->getRecords(), "page_list" => $Archive->getCountDisplay(), "sql_queries" => array_merge($Archive->getSQLQueries(), $ArchiveCategories->getSQLQueries())));
    $smarty->display('public/body/index.tpl');
    echo "<!-- page rendered in approx {$timer->Stop()} -->";
} catch (Exception $e) {
    $smarty->assign(array("exception" => $e->getMessage()));
    $smarty->display('public/body/error.tpl');
}

    $Comments->setPostId($vars['post']);
    $Archive->BuildData();
    $Comments->BuildData();
    //
    if ($_POST['post_submit'] == "true") {
        if (!isset($_SESSION['userid']) && isal_num($_SESSION['userid'])) {
            $error[] = "User ID Session variable is missing";
        }
        if (!isset($vars['post']) && isal_num($vars['post'])) {
            $error[] = "Post ID GET variable is missing";
        }
        if (strlen($_POST['comment']) < 10) {
            $error[] = "Comment must be longer than 10 characters long";
        }
        if (!count($error)) {
            $var = array("user_id" => $_SESSION['userid'], "post_id" => $_POST['post'], "comment" => $_POST['comment']);
            $Comments->Insert($var);
            $status = "success";
        } else {
            $status = "failed";
        }
    } else {
        $status = "unknown";
    }
    $smarty->assign(array("page_name" => "News&nbsp;:&nbsp;Comment", "load" => "news/comments.tpl", "filename" => $Archive->getFilename(), "archive_index" => $Archive->getIndex(), "records" => $Archive->getRecords(), "comments" => $Comments->getRecords(), "page_list" => $Comments->getCountDisplay(), "sql_queries" => array_merge($Archive->getSQLQueries(), $Comments->getSQLQueries()), "status" => $status, "errors" => $error));
    $smarty->display('public/body/index.tpl');
    echo "<!-- page rendered in approx {$timer->Stop()} -->";
} catch (Exception $e) {
    $smarty->assign(array("exception" => $e->getMessage()));
    $smarty->display('public/body/error.tpl');
}

                if ($auth->Authenticate()) {
                    $loadfile = "login/login_successful.tpl";
                    $redirect = "/#1";
                } else {
                    $loadfile = "login/login_{$auth->getError()}.tpl";
                    switch ($auth->getError()) {
                        case "email":
                            $e_email = true;
                            break;
                        case "username":
                            $e_username = true;
                            break;
                        case "password":
                            $e_password = true;
                            break;
                    }
                }
            }
        } else {
            $loadfile = "login/login_form.tpl";
        }
        $smarty->assign(array("page_name" => "Login", "load" => $loadfile, "archive_index" => $Archive->getIndex(), "error" => $error, "redirect" => $redirect, "sql_queries" => array_merge($Archive->getSQLQueries(), $auth->getSQLQueries()), "username" => $e_username, "password" => $e_password, "email" => $e_email));
        $smarty->display('public/body/index.tpl');
        echo "<!-- page rendered in approx {$timer->Stop()} -->";
    } catch (Exception $e) {
        $smarty->assign(array("exception" => $e->getMessage()));
        $smarty->display('public/body/error.tpl');
    }
} else {
    header("location: /");
}