PHP Do_Fetch_Row 예제들

예제 #1

파일: phpbb2.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $table_prefix;
    $q = DoQuery("SELECT user_password FROM {$table_prefix}users WHERE username='******'");
    $pass = Do_Fetch_Row($q);
    return $pass[0];
}

예제 #2

파일: md5.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $SERVER;
    $q = DoQuery("SELECT password FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
    $pass = Do_Fetch_Row($q);
    return $pass[0];
}

예제 #3

파일: nuke.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $nukepre, $nuke, $DATABASE, $SERVER, $_COOKIE;
    mysql_close();
    mysql_connect($nuke['DBHOST'], $nuke['UNAME'], $nuke['PWORD']);
    mysql_select_db($nuke['DBNAME']);
    $q = DoQuery("SELECT user_password FROM {$nukepre}users WHERE username='******'");
    echo mysql_error();
    $pass = Do_Fetch_Row($q);
    mysql_close();
    DoConnect($DATABASE['HOST'], $DATABASE['USER'], $DATABASE['PASS']);
    DoSelectDb($DATABASE['DATABASE']);
    $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
    $row = Do_Fetch_Row($q);
    if ($row[0] == "" && $_COOKIE['X2CHATP'] == $pass[0]) {
        DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}users VALUES('0','{$username}','','','1','','','','','','','','','14000,1000,1,1,0,3,1,0,0,1')");
    }
    return $pass[0];
}

예제 #4

파일: invision.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $INFO, $DATABASE, $_COOKIE, $SERVER;
    mysql_close();
    mysql_connect($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass']);
    mysql_select_db($INFO['sql_database']);
    $q = DoQuery("SELECT password FROM {$INFO[sql_tbl_prefix]}members WHERE name='{$username}'");
    echo mysql_error();
    $pass = Do_Fetch_Row($q);
    mysql_close();
    DoConnect($DATABASE['HOST'], $DATABASE['USER'], $DATABASE['PASS']);
    DoSelectDb($DATABASE['DATABASE']);
    $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
    $row = Do_Fetch_Row($q);
    if ($row[0] == "" && $_COOKIE['X2CHATP'] == $pass[0]) {
        DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}users VALUES('0','{$username}','','','1','','','','','','','','','14000,1000,1,1,0,3,1,0,0,1')");
    }
    return $pass[0];
}

예제 #5

파일: xmb.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $DATABASE, $_COOKIE, $SERVER, $xmb_host, $xmb_user, $xmb_password, $xmb_db, $xmb_prefix;
    mysql_close();
    @DoConnect("{$xmb_host}", "{$xmb_user}", "{$xmb_password}");
    @DoSelectDb("{$xmb_db}");
    $q = DoQuery("SELECT password FROM {$xmb_prefix}members WHERE username='******'");
    echo mysql_error();
    $pass = Do_Fetch_Row($q);
    mysql_close();
    DoConnect($DATABASE['HOST'], $DATABASE['USER'], $DATABASE['PASS']);
    DoSelectDb($DATABASE['DATABASE']);
    $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
    $row = Do_Fetch_Row($q);
    if ($row[0] == "" && $_COOKIE['X2CHATP'] == $pass[0]) {
        DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}users VALUES('0','{$username}','','','1','','','','','','','','','14000,1000,1,1,0,3,1,0,0,1')");
        echo mysql_error();
    }
    return $pass[0];
}

예제 #6

파일: update.php 프로젝트: BackupTheBerlios/domsmod-svn

	}


	window.parent.frames['left_top'].document.showon.users.value='<?php 
    echo $ONLINE['USERS'] + $ONLINE['ADMIN'];
    ?>
';
	window.parent.frames['left_top'].document.showon.rooms.value='<?php 
    echo $ROOMS['TOTAL_ROOMS'];
    ?>
';

	<?php 
    if ($XUSER['POPUPPM'] == 1) {
        $q = DoQuery("SELECT fromuser,id FROM {$SERVER['TBL_PREFIX']}pmsessions WHERE user='******'NAME']}' AND isopen='0'");
        while ($row = Do_Fetch_Row($q)) {
            if ($row[0] != "") {
                $session = time() . strlen($row[0]);
                print "window.open('privatemessage.php?user={$row['0']}','PM{$session}','width=600,height=300');";
                DoQuery("UPDATE {$SERVER['TBL_PREFIX']}pmsessions SET isopen='1' WHERE id='{$row['1']}'");
            }
        }
    }
} else {
    if (isset($pincorrect)) {
        print "This chat room requires a password.  <a href=\"../index.php\" target=\"_parent\">Click Here</a> to enter it.";
    }
}
cleanmsgs();
$RV = printinroom();
$usersonline = $RV[0];

예제 #7

파일: functions.php 프로젝트: BackupTheBerlios/domsmod-svn

function logBandwidth($size)
{
    global $SERVER, $XUSER;
    $month = date("m");
    $q = DoQuery("SELECT bandwidth,allowed,month FROM {$SERVER['TBL_PREFIX']}bandwidth WHERE user='******'NAME']}'");
    $row = Do_Fetch_Row($q);
    if ($row[0] == "") {
        $q = DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}bandwidth VALUES('0','{$XUSER['NAME']}','{$month}','0','d')");
        $row[0] = 0;
        $row[1] = "d";
        $row[2] = $month;
    }
    // reset if its a new month
    if ($row[2] != $month) {
        DoQuery("UPDATE {$SERVER['TBL_PREFIX']}bandwidth SET month={$month},bandwidth=0 WHERE user='******'NAME']}'");
        $row[0] = 0;
    }
    // record new bandwdith
    $newbandwidth = $row[0] + $size;
    DoQuery("UPDATE {$SERVER['TBL_PREFIX']}bandwidth SET bandwidth={$newbandwidth} WHERE user='******'NAME']}'");
    // See if user has gone over limit
    if ($row[1] == "d") {
        $row[1] = $SERVER['DEFAULT_BAND_LIMIT'];
    }
    if ($row[1] != 0) {
        if ($newbandwidth >= $row[1] && ($XUSER['LEVEL'] != 4 && $XUSER['LEVEL'] != 5)) {
            return 0;
        } else {
            return 1;
        }
    }
    return 1;
}

예제 #8

파일: xoops.php 프로젝트: BackupTheBerlios/domsmod-svn

function getPass($username)
{
    global $table_prefix, $DATABASE;
    @DoConnect(XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS);
    @DoSelectDb(XOOPS_DB_NAME);
    $q = DoQuery("SELECT pass FROM {$table_prefix}users WHERE uname='{$username}'");
    $pass = Do_Fetch_Row($q);
    DoConnect($DATABASE['HOST'], $DATABASE['USER'], $DATABASE['PASS']);
    DoSelectDb($DATABASE['DATABASE']);
    if ($pass[0] == "") {
        $q = DoQuery("SELECT email,password FROM {$SERVER['TBL_PREFIX']}users WHERE username='******'");
        $row = Do_Fetch_Row($q);
        if ($row[0] == "Guest") {
            $pass[0] = $row[1];
        }
    }
    return $pass[0];
}

예제 #9

파일: admin.php 프로젝트: BackupTheBerlios/domsmod-svn

                DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}bans VALUES('0','*','','{$ip}','{$time}','0')");
            }
        }
    } elseif ($action == "bandwidth") {
        $head = $txt[428];
        $body = '<table border="1" cellspacing="0" cellpadding="0">
			<tr>
				<td width="100"><b>' . $txt[12] . '</b></td>
				<td width="150"><b>' . $txt[431] . '</b></td>
				<td width="150"><b>' . $txt[432] . '</b></td>
				<td width="200"><b>' . $txt[433] . '</b></td>
			</tr>';
        $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users");
        $total = 0;
        while ($row = Do_Fetch_Row($q)) {
            $q2 = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}bandwidth WHERE user='******'1']}'");
            $row2 = Do_Fetch_Row($q2);
            $ext = "";
            $total = $total + $row2[3];
            if ($row2[3] >= 1024) {
                $row2[3] = $row2[3] / 1024;
                if ($row2[3] >= 1024) {
                    $row2[3] = $row2[3] / 1024;
                    $ext = " MB";
                } else {
                    $ext = " KB";
                }
            } elseif ($row2[3] > 1024) {
                $ext = " B";
            }
            if (eregi("[0-9]*\\...", "{$row2['3']}", $match)) {

예제 #10

파일: privatemessage.php 프로젝트: BackupTheBerlios/domsmod-svn

		</td>
	</tr>
	<tr>
		<td width="500" style="<?php 
    echo $borderlr;
    ?>
">&nbsp;</td>
	</tr>
</table>

</div>
<?php 
} elseif ($page == "update") {
    // We don't need 1000000 popups coming up do we? no, lets change that
    $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}pmsessions WHERE user='******'NAME']}' AND fromuser='******'");
    $row = Do_Fetch_Row($q);
    $time = time();
    if ($row[0] == "") {
        $update = 0;
        DoQuery("INSERT INTO {$SERVER['TBL_PREFIX']}pmsessions VALUES('0','{$XUSER['NAME']}','{$user}','{$time}','1')");
    } else {
        $update = $row[3];
        DoQuery("UPDATE {$SERVER['TBL_PREFIX']}pmsessions SET time='{$time}' WHERE id='{$row['0']}'");
    }
    ?>
<script language="javascript" type="text/javascript">
<?php 
    ?>
if(window.parent.frames['pm_mw'].issent == 1){
	window.parent.frames['pm_mw'].document.write('<html><head></head><body bgcolor="<?php 
    echo $CS['WIN_BG_2'];

예제 #11

파일: roomcontrol.php 프로젝트: BackupTheBerlios/domsmod-svn

            DoQuery("UPDATE {$SERVER['TBL_PREFIX']}users SET level='1',time='{$time}' WHERE id='{$userid}'");
            mnotice($row[1], 2);
            $head = "{$txt['181']}";
            $body = "{$txt['182']}<Br><Br><a href=\"index.php\">{$txt['6']}</a><br><Br>";
        } else {
            DoQuery("UPDATE {$SERVER['TBL_PREFIX']}users SET level='4',time='0' WHERE id='{$userid}'");
            mnotice($row[1], 1);
            $head = "{$txt['183']}";
            $body = "{$txt['184']}<Br><Br><a href=\"index.php\">{$txt['6']}</a><br><Br>";
        }
    }
} elseif ($action == "voice") {
    $q = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}users WHERE id='{$userid}'");
    $row = Do_Fetch_Row($q);
    $q3 = DoQuery("SELECT * FROM {$SERVER['TBL_PREFIX']}online WHERE username='******'1']}'");
    $row3 = Do_Fetch_Row($q3);
    if ($row3[3] != $ROOMS['IN_ROOM_NAME']) {
        $head = $txt[2];
        $body = $txt[185];
    } else {
        if ($row[4] < 4 && $row[11] != $ROOMS['id']) {
            mnotice($row[1], 5);
            $head = $txt[186];
            $body = "{$txt['187']}<Br><Br><a href=\"index.php\">{$txt['6']}</a><br><Br>";
            DoQuery("UPDATE {$SERVER['TBL_PREFIX']}users SET voice='{$ROOMS['id']}' WHERE id='{$userid}'");
        } elseif ($row[11] == $ROOMS['id']) {
            DoQuery("UPDATE {$SERVER['TBL_PREFIX']}users SET voice='' WHERE id='{$userid}'");
            mnotice($row[1], 6);
            $head = $txt[188];
            $body = "{$txt['189']}<Br><Br><a href=\"index.php\">{$txt['6']}</a><br><Br>";
        } else {