当前位置: 首页>>代码示例>>PHP>>正文


PHP Transaction::fetch方法代码示例

本文整理汇总了PHP中Transaction::fetch方法的典型用法代码示例。如果您正苦于以下问题:PHP Transaction::fetch方法的具体用法?PHP Transaction::fetch怎么用?PHP Transaction::fetch使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Transaction的用法示例。


在下文中一共展示了Transaction::fetch方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: mobbo_settings

 public static function mobbo_settings($var)
 {
     $var2 = Security::injection($var);
     $sql = Transaction::query("SELECT valuer FROM `mobbo_settings` WHERE `variabler` LIKE '{$var2}'");
     $return = Transaction::fetch($sql);
     return $return['valuer'];
 }
开发者ID:habb0,项目名称:mobbo,代码行数:7,代码来源:mobbo.class.php

示例2: while

                </form></table></div><br />

        <div class='tableborder'>
            <div class='tableheaderalt'><center>Equipe staff</center></div>
            <table cellpadding='4' cellspacing='0' width='100%'>
                <tr>
                    <td class='tablesubheader' width='20%'>Nome</td>
                    <td class='tablesubheader' width='30%'>Email</td>
                    <td class='tablesubheader' width='20%'>IP</td>
                    <td class='tablesubheader' width='20%'>Cargo</td>
                    <td class='tablesubheader' width='1%' align='center'>Editar</td>
                </tr>
                <?php 
    while ($row = Transaction::fetch($get_users)) {
        $rank = Transaction::query("SELECT * FROM ranks WHERE id = '" . $row['rank'] . "' ");
        $rank = Transaction::fetch($rank);
        ?>
                    <tr>
                        <td class='tablerow1' align='left'><?php 
        echo $row['username'];
        ?>
 (ID: <?php 
        echo $row['id'];
        ?>
)</td>
                        <td class='tablerow1' align='left'><?php 
        echo $row['mail'];
        ?>
</td>
                        <td class='tablerow1' align='left'><?php 
        echo $row['ip_last'];
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:ranktool.php

示例3: while

                    <tr>
                        <td class='tablesubheader' width='1%' align='center'>ID</td>
                        <td class='tablesubheader' width='20%'>Ttulo</td>
                        <td class='tablesubheader' width='12%' align='left'>Data</td>
                        <td class='tablesubheader' width='10%' align='left'>Autor</td>
                        <td class='tablesubheader' width='1%' align='center'>Editar</td>
                        <td class='tablesubheader' width='1%' align='center'>Remover</td>
                    </tr>
                    <?php 
        $query_min = $page * 50 - 50;
        if ($query_min < 0) {
            // Page 1
            $query_min = 0;
        }
        $get_articles = Transaction::query("SELECT * FROM mobbo_news ORDER BY id DESC LIMIT " . $query_min . ", 50");
        while ($row = Transaction::fetch($get_articles)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['id'];
            ?>
</td>
                            <td class='tablerow2'><strong><?php 
            echo Security::textFilterHK($row['title']);
            ?>
</strong><div class='desctext'><?php 
            echo $row['longstory'];
            ?>
</div></td>
                            <td class='tablerow2' align='left'><?php 
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:news.php

示例4: date

$m = date('m');
$d = date('d');
$Y = date('Y');
$j = date('j');
$n = date('n');
// start the user system
if (isset($_SESSION['id'])) {
    $rawname = htmlentities($_SESSION['id']);
    $usersql = Transaction::query("SELECT * FROM users WHERE id = '" . $rawname . "' LIMIT 1");
    $myrow = Transaction::fetch($usersql);
    $ban = Transaction::query("SELECT * FROM bans WHERE value = '" . $myrow['username'] . "' AND bantype = 'user' or value = '" . $remote_ip . "' AND bantype = 'ip' LIMIT 1");
    $bancheck = Transaction::num_rows($ban);
    if ($myrow['ip_reg'] == "0") {
        Transaction::query("UPDATE users SET ip_reg = '" . $remote_ip . "' WHERE id = '" . $myrow['id'] . "'");
    } elseif ($bancheck > 0) {
        $bandata = Transaction::fetch($ban);
        $timestamp = time();
        if ($bandata['expire'] > $timestamp) {
            session_destroy();
            header("Location: index.php");
            exit;
        } else {
            Transaction::query("DELETE FROM bans WHERE value = '" . $name . "' AND bantype = 'user' or value = '" . $remote_ip . "' AND bantype = 'ip' LIMIT 1");
        }
    }
    $rawhotel = 0;
    $rawhotel = md5($myrow['id'] + $myrow['username'] + $myrow['password'] + Security::getUserIP());
    if (isset($_COOKIE['rawsessionhotel'])) {
        if ($_COOKIE['rawsessionhotel'] == $rawhotel) {
            $logged_in = true;
            $name = mobbo::HoloText($myrow['username']) != 0 ? mobbo::HoloText($myrow['username']) : "Guest";
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:index.php

示例5: getdefault

 private function getdefault()
 {
     $query = Transaction::query("SELECT * FROM mobbo_templates WHERE active = '1' LIMIT 1;");
     $row = Transaction::fetch($query);
     $this->path = $row['path'];
 }
开发者ID:habb0,项目名称:mobbo,代码行数:6,代码来源:Pages.class.php

示例6: while

        <div class='tableborder'>
            <div class='tableheaderalt'><center>Usurios VIP atualmente</center></div>
            <table cellpadding='4' cellspacing='0' width='100%'>

                <tr>
                    <td class='tablesubheader' width='20%' align='left'>Nome de usurio</td>
                    <td class='tablesubheader' width='15%' align='left'>E-mail</td>
                    <td class='tablesubheader' width='15%' align='left'>IP</td>
                    <td class='tablesubheader' width='5%' align='left'>Editar</td>
                </tr>

                <?php 
    $get_vip = Transaction::query("SELECT * FROM users WHERE rank = '2' ORDER BY lastonline");
    while ($vip = Transaction::fetch($get_vip)) {
        $get_user = Transaction::query("SELECT * FROM users WHERE id = '" . $vip['id'] . "'");
        while ($row = Transaction::fetch($get_user)) {
            if ($row['online'] >= 1) {
                $online = "online";
            } else {
                $online = "offline";
            }
            ?>

                        <tr>
                            <td class='tablerow1' align='left'><?php 
            echo $row['username'];
            ?>
 (ID: <?php 
            echo $row['id'];
            ?>
)</td>
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:viptool.php

示例7: COUNT

            <div class='tableborder'>
                <div class='tableheaderalt'><center>Emblemas (<?php 
        echo Transaction::evaluate("SELECT COUNT(*) FROM user_badges WHERE user_id = '" . $key . "'");
        ?>
) </div>

                <table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'>

                    <tr>
                        <td class='tablesubheader' width='1%' align='center'>Cdigo</td>
                        <td class='tablesubheader' width='14%' align='center'>Emblema</td>
                    </tr>

                    <?php 
        $sql = Transaction::query("SELECT * FROM user_badges WHERE user_id = '" . $key . "' ORDER BY badge_id");
        while ($row = Transaction::fetch($sql)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['badge_id'];
            ?>
</td>
                            <td class='tablerow2'><img src="<?php 
            echo $cimagesurl . $badgesurl . $row['badge_id'];
            ?>
.gif"></div></td>
                        </tr>

                    <?php 
        }
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:users_edit.php

示例8: while

                    <tr>
                        <td class='tablesubheader' width='1%' align='center'>ID</td>
                        <td class='tablesubheader' width='10%' align='center'>Cdigo do emblema</td>
                        <td class='tablesubheader' width='10%' align='center'>Nome</td>
                        <td class='tablesubheader' width='10%' align='center'>Preo</td>
                        <td class='tablesubheader' width='10%' align='center'>Editar</td>
                        <td class='tablesubheader' width='12%' align='center'>Borrar</td>
                    </tr>
                    <?php 
        $query_min = $page * 50 - 50;
        if ($query_min < 0) {
            // Page 1
            $query_min = 0;
        }
        $get_marktplatz = Transaction::query("SELECT * FROM mobbo_shop ORDER BY id DESC LIMIT " . $query_min . ", 50");
        while ($row = Transaction::fetch($get_marktplatz)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['id'];
            ?>
</td>
                            <td class='tablerow2' align='center'><img src="http://127.0.0.1/c_images/album1584/<?php 
            echo $row['image'];
            ?>
.gif" alt="<?php 
            echo $row['image'];
            ?>
"></td>
                            <td class='tablerow2' align='center'><?php 
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:marktplatz.php

示例9: while

        while ($row = Transaction::fetch($get_users)) {
            ?>

                    <script language="JavaScript" type="text/javascript">
                        function openWin () {
                            var newWin = window.open ('', '', 'height=330, width=560');
                            newWin.document.close ();
                        }
                    </script>

                    <?php 
            $userdata = Transaction::query("SELECT * FROM users WHERE id = '" . $row['userid'] . "' LIMIT 1");
            $userdata = Transaction::fetch($userdata);
            if (!empty($row['targetid'])) {
                $targetdata = Transaction::query("SELECT * FROM users WHERE id = '" . $row['targetid'] . "' LIMIT 1");
                $targetdata = Transaction::fetch($targetdata);
            } else {
                $targetdata['username'] = "-/-";
            }
            if (!empty($row['note'])) {
                $note = $row['note'];
            } else {
                $note = "<i>None given</i>";
            }
            ?>

                    <tr>
                        <td class='tablerow1' align='left'><?php 
            echo $row['action'];
            ?>
</td>
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:stafflogs.php

示例10: time

                        <td class='tablesubheader' width='10%' align='left'>Desde</td>
                        <td class='tablesubheader' width='10%' align='left'>Acaba</td>
                        <td class='tablesubheader' width='1%' align='left'>IP Banido</td>
                    </tr>

                    <?php 
    $query_min = $page * 50 - 50;
    if ($query_min < 0) {
        // Page 1
        $query_min = 0;
    }
    $get_bans = Transaction::query("SELECT * FROM bans WHERE expire + 3600 > '" . time() . "' ORDER BY expire LIMIT " . $query_min . ", 50");
    while ($row = Transaction::fetch($get_bans)) {
        if ($row['bantype'] == 'user') {
            $userdata = Transaction::query("SELECT * FROM users WHERE username = '" . $row['value'] . "'");
            $users = Transaction::fetch($userdata);
            $ip_last = $users['ip_last'];
        } else {
            $ip_last = '-/-';
        }
        $minuten = $row['expire'] - time();
        if (time() >= $row['expire']) {
            $stat = "Expira em";
            $color = "green";
        } elseif (time() + 3600 >= $row['expire']) {
            if (date('i', $minuten) > 0) {
                $stat = "(H " . date('i', $minuten) . " minutos)";
                $color = "orange";
            } else {
                $stat = "(H " . date('s', $minuten) . " segundos)";
                $color = "orange";
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:banlogs.php

示例11: while

            <div class='tableborder'>
                <div class='tableheaderalt'><center>Banners - Informaci&oacute;n general</center></div>
                <table cellpadding='4' cellspacing='0' width='100%'>
                    <tr>
                        <td class='tablesubheader' width='1%' align='center'>ID</td>
                        <td class='tablesubheader' width='10%' align='center'>Texto</td>
                        <td class='tablesubheader' width='10%' align='center'>Imagen</td>
                        <td class='tablesubheader' width='10%' align='center'>URL</td>
                        <td class='tablesubheader' width='10%' align='center'>HTML</td>
                        <td class='tablesubheader' width='1%' align='center'>Editar</td>
                        <td class='tablesubheader' width='1%' align='center'>Borrar</td>
                    </tr>
                    <?php 
        $get_banners = Transaction::query("SELECT * FROM mobbo_banners ORDER BY id");
        while ($row = Transaction::fetch($get_banners)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['id'];
            ?>
</td>
                            <td class='tablerow2' align='center'><?php 
            echo $row['text'];
            ?>
</td>
                            <td class='tablerow2' align='center'><?php 
            echo $row['banner'];
            ?>
</td>
开发者ID:habb0,项目名称:mobbo,代码行数:30,代码来源:banners.php

示例12: while

                <table cellpadding='4' cellspacing='0' width='100%'>
                    <tr>
                        <td class='tablesubheader' width='1%' align='center'>ID</td>
                        <td class='tablesubheader' width='20%'>Tipo</td>
                        <td class='tablesubheader' width='20%' align='left'>ID da ao</td>
                        <td class='tablesubheader' width='20%' align='center'>Editar</td>
                        <td class='tablesubheader' width='1%' align='center'>Remover</td>
                    </tr>
                    <?php 
        $query_min = $page * 50 - 50;
        if ($query_min < 0) {
            // Page 1
            $query_min = 0;
        }
        $get_recommended = Transaction::query("SELECT * FROM mobbo_recommended ORDER BY id DESC LIMIT " . $query_min . ", 50");
        while ($row = Transaction::fetch($get_recommended)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['id'];
            ?>
</td>
                            <td class='tablerow2'><?php 
            if ($row['type'] == "room") {
                echo 'Sala';
            } else {
                echo 'Grupo';
            }
            ?>
</td>
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:recommended.php

示例13: header

}
if ($user_rank > 4) {
    if ($hkzone !== true) {
        header("Location: index/?throwBack=true");
        exit;
    }
    if (!mobbo::session_is_registered(acp)) {
        header("Location: p/login");
        exit;
    }
    $pagename = "Alertas";
    $pageid = "alert";
    if (isset($_POST['alert'])) {
        $check = Transaction::query("SELECT * FROM users WHERE username = '" . Security::textFilter($_POST['name']) . "' LIMIT 1");
        if (Transaction::num_rows($check) > 0) {
            $userdata = Transaction::fetch($check);
            Transaction::query("INSERT INTO mobbo_alerts (userid,alert) VALUES ('" . $userdata['id'] . "','" . Security::textFilter($_POST['alert']) . "')");
            $msg = "<div class='rounded rounded-green'><center>Alerta enviada a  " . Security::textFilter($_POST['name']) . " (ID: " . $userdata['id'] . ") <img src=\"./w/images/check.gif\"></center></div>";
        } else {
            $msg = "<div class='rounded rounded-red'><center>Oops! este usurio no foi encontrado. <img src=\"./w/images/del.gif\"></center></div>";
        }
    }
    @(include 'subheader.php');
    if (isset($msg)) {
        ?>
<p><strong><?php 
        echo $msg;
        ?>
</strong></p><?php 
    }
    ?>
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:alert.php

示例14: header

}
if ($user_rank > 5) {
    if ($hkzone !== true) {
        header("Location: index.php?throwBack=true");
        exit;
    }
    if (!mobbo::session_is_registered(acp)) {
        header("Location: index.php?p=login");
        exit;
    }
    $pagename = "Banimentos";
    $pageid = "ban";
    if (isset($_POST['value']) && $_POST['length'] && $_POST['reason']) {
        $check_exists = Transaction::query("SELECT * FROM bans WHERE value = '" . Security::textFilter($_POST['value']) . "' AND bantype = '" . Security::textFilter($_POST['type']) . "'");
        $get_cc = Transaction::query("SELECT * FROM users WHERE username = '" . $_POST['value'] . "'");
        $userdata = Transaction::fetch($get_cc);
        if (Transaction::num_rows($check_exists) > 0) {
            Transaction::query("UPDATE bans SET expire = expire + '" . Security::textFilter($_POST['length']) . "' WHERE value = '" . Security::textFilter($_POST['value']) . "' AND bantype = '" . Security::textFilter($_POST['type']) . "'");
            $msg = "<div class='rounded rounded-green'><center>El ban (" . Security::textFilter($_POST['type']) . " - " . Security::textFilter($_POST['value']) . ") ha sido actualizado. <img src=\"./w/images/check.gif\"></center></div>";
        } else {
            if (Transaction::num_rows($get_cc) > 0 && $_POST['type'] == "user") {
                Transaction::query("INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES ('" . Security::textFilter($_POST['type']) . "','" . Security::textFilter($_POST['value']) . "','" . Security::textFilter($_POST['reason']) . "','" . time() . "' + '" . Security::textFilter($_POST['length']) . "','" . $name . "','" . time() . "')");
                Transaction::query("UPDATE users SET auth_ticket = '' WHERE username = '" . Security::textFilter($_POST['value']) . "' LIMIT 1");
                $msg = "<div class='rounded rounded-green'><center>" . $_POST['value'] . " foi banido <img src=\"./w/images/check.gif\"></center></div>";
            } elseif (Transaction::num_rows($get_cc) < 1 && $_POST['type'] == "user") {
                $msg = "<div class='rounded rounded-red'><center>No foi possvel encontrar o usurio <img src=\"./w/images/del.gif\"></center></div>";
            } elseif ($_POST['type'] == "ip") {
                Transaction::query("INSERT INTO bans (bantype,value,reason,expire,added_by,added_date) VALUES ('" . Security::textFilter($_POST['type']) . "','" . Security::textFilter($_POST['value']) . "','" . Security::textFilter($_POST['reason']) . "','" . time() . "' + '" . Security::textFilter($_POST['length']) . "','" . $name . "','" . time() . "')");
                Transaction::query("UPDATE users SET auth_ticket = '' WHERE username = '" . Security::textFilter($_POST['value']) . "' LIMIT 1");
                $msg = "<div class='rounded rounded-green'><center>O IP " . Security::textFilter($_POST['value']) . " foi banido! <img src=\"./w/images/check.gif\"></center></div>";
            }
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:bantool.php

示例15: while

                        <td class='tablesubheader' width='20%' align='left'>Descrio</td>
                        <td class='tablesubheader' width='10%' align='left'>Imagem (50% do tamanho original)</td>
                        <td class='tablesubheader' width='10%' align='left'>URL</td>
                        <td class='tablesubheader' width='7%' align='left'>Boto</td>
                        <td class='tablesubheader' width='1%' align='center'>Editar</td>
                        <td class='tablesubheader' width='1%' align='center'>Excluir</td>
                    </tr>

                    <?php 
        $query_min = $page * 50 - 50;
        if ($query_min < 0) {
            // Page 1
            $query_min = 0;
        }
        $get_hotcampaigns = Transaction::query("SELECT * FROM mobbo_hotcampaigns ORDER BY id DESC LIMIT " . $query_min . ", 50");
        while ($row = Transaction::fetch($get_hotcampaigns)) {
            ?>

                        <tr>
                            <td class='tablerow1' align='center'><?php 
            echo $row['id'];
            ?>
</td>
                            <td class='tablerow2'><?php 
            echo $row['caption'];
            ?>
</td>
                            <td class='tablerow2' align='left'><?php 
            echo $row['descr'];
            ?>
</td>
开发者ID:habb0,项目名称:mobbo,代码行数:31,代码来源:campaigns.php


注:本文中的Transaction::fetch方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。