PHP rex_login_sql::getValue示例

示例#1

文件： user.inc.php 项目： BackupTheBerlios/redaxo-svn

 if ($sql->hasPerm('admin[]')) {
     $adminchecked = 'checked';
 } else {
     $adminchecked = '';
 }
 if ($sql->hasPerm('csw[0]')) {
     $allcatschecked = 'checked';
 } else {
     $allcatschecked = '';
 }
 if ($sql->hasPerm('media[0]')) {
     $allmcatschecked = 'checked';
 } else {
     $allmcatschecked = '';
 }
 if ($sql->getValue($REX['TABLE_PREFIX'] . 'user.status') == 1) {
     $statuschecked = 'checked';
 } else {
     $statuschecked = '';
 }
 // Allgemeine Permissions setzen
 foreach ($REX['PERM'] as $_perm) {
     if ($sql->hasPerm($_perm)) {
         $sel_all->setSelected($_perm);
     }
 }
 // optionen
 foreach ($REX['EXTPERM'] as $_perm) {
     if ($sql->hasPerm($_perm)) {
         $sel_ext->setSelected($_perm);
     }

示例#2

文件： profile.inc.php 项目： BackupTheBerlios/redaxo

    }
}
// ---------------------------------- ERR MSG
if ($info != '') {
    echo rex_info($info);
}
if ($warning != '') {
    echo rex_warning($warning);
}
// --------------------------------- FORMS
$sql = new rex_login_sql();
$sql->setQuery('select * from ' . $REX['TABLE_PREFIX'] . 'user where user_id=' . $user_id);
if ($sql->getRows() != 1) {
    echo rex_warning('You have no permission to this area!');
} else {
    $userpsw = $sql->getValue($REX['TABLE_PREFIX'] . 'user.psw');
    $username = $sql->getValue($REX['TABLE_PREFIX'] . 'user.name');
    $userdesc = $sql->getValue($REX['TABLE_PREFIX'] . 'user.description');
    echo '
    <div class="rex-usr-editmode">
    <form action="index.php" method="post">
      <fieldset>
        <legend class="rex-lgnd">' . $I18N->msg('profile_myprofile') . '</legend>

        <div class="rex-fldst-wrppr">
          <input type="hidden" name="page" value="profile" />

          <div>
            <p class="rex-cnt-col2">
              <label for="userlogin">' . htmlspecialchars($I18N->msg('login_name')) . '</label>
              <span id="userlogin">' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . 'user.login')) . '</span>

示例#3

文件： user.inc.php 项目： BackupTheBerlios/redaxo

                $userperm_mylang = "be_lang[en_gb]";
            } else {
                $userperm_mylang = "be_lang[default]";
            }
        }
        $sel_mylang->set_selected($userperm_mylang);
        // ----- FORM UPDATE AUSGABE
        echo '
    <table class="rex" style="table-layout:auto;" cellpadding="5" cellspacing="1">
    <form action="index.php" method="post">
    <input type="hidden" name="page" value="user">
    <input type="hidden" name="user_id" value="' . $user_id . '">
    <tr><th colspan="4"><b>' . $I18N->msg("edit_user") . '</b></th></tr>
    <tr>
      <td width="100">' . $I18N->msg("login_name") . '</td>
      <td width="250"><b>' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . "user.login")) . '</b></td>
      <td width="100">' . $I18N->msg("password") . '</td>
      <td><input class="inp100" type="text" size="20" name="userpsw" value="' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . "user.psw")) . '"><br />';
        if ($REX['PSWFUNC'] != "") {
            echo $I18N->msg("psw_encrypted");
        }
        echo '</td>
    </tr>

    <tr>
      <td>' . $I18N->msg("name") . '</td>
      <td><input class="inp100" type="text" size="20" name="username" value="' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . "user.name")) . '"></td>
      <td>' . $I18N->msg("description") . '</td>
      <td><input class="inp100" type="text" size="20" name="userdesc" value="' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . "user.description")) . '"></td>
    </tr>
    <tr>

示例#4

文件： profile.inc.php 项目： BackupTheBerlios/redaxo-svn

$sel_be_sprache->setSelected($userperm_be_sprache_selected);
// ---------------------------------- ERR MSG
if ($info != '') {
    echo rex_info($info);
}
if ($warning != '') {
    echo rex_warning($warning);
}
// --------------------------------- FORMS
$sql = new rex_login_sql();
$sql->setQuery('select * from ' . $REX['TABLE_PREFIX'] . 'user where user_id=' . $user_id);
if ($sql->getRows() != 1) {
    echo rex_warning('You have no permission to this area!');
} else {
    // $userpsw = $sql->getValue($REX['TABLE_PREFIX'].'user.psw');
    $username = $sql->getValue($REX['TABLE_PREFIX'] . 'user.name');
    $userdesc = $sql->getValue($REX['TABLE_PREFIX'] . 'user.description');
    echo '
    <div class="rex-form" id="rex-form-profile">
    <form action="index.php" method="post">
      <fieldset class="rex-form-col-2">
        <legend>' . $I18N->msg('profile_myprofile') . '</legend>

        <div class="rex-form-wrapper">
          <input type="hidden" name="page" value="profile" />

					<div class="rex-form-row">
						<p class="rex-form-col-a rex-form-read">
              <label for="userlogin">' . htmlspecialchars($I18N->msg('login_name')) . '</label>
              <span class="rex-form-read" id="userlogin">' . htmlspecialchars($sql->getValue($REX['TABLE_PREFIX'] . 'user.login')) . '</span>
						</p>

示例#5

文件： user.inc.php 项目： Barnhiac/MTW_REDAXO

 if ($sql->isAdmin()) {
     $adminchecked = 'checked="checked"';
 } else {
     $adminchecked = '';
 }
 if ($sql->hasPerm('csw[0]')) {
     $allcatschecked = 'checked="checked"';
 } else {
     $allcatschecked = '';
 }
 if ($sql->hasPerm('media[0]')) {
     $allmcatschecked = 'checked="checked"';
 } else {
     $allmcatschecked = '';
 }
 if ($sql->getValue($REX['TABLE_PREFIX'] . 'user.status') == 1) {
     $statuschecked = 'checked="checked"';
 } else {
     $statuschecked = '';
 }
 // Allgemeine Permissions setzen
 foreach ($REX['PERM'] as $_perm) {
     if ($sql->hasPerm($_perm)) {
         $sel_all->setSelected($_perm);
     }
 }
 // optionen
 foreach ($REX['EXTPERM'] as $_perm) {
     if ($sql->hasPerm($_perm)) {
         $sel_ext->setSelected($_perm);
     }