PHP q_singleval函数代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中q_singleval函数的典型用法代码示例。如果您正苦于以下问题：PHP q_singleval函数的具体用法？PHP q_singleval怎么用？PHP q_singleval使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了q_singleval函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: attach_add

function attach_add($at, $owner, $attach_opt = 0, $ext = 0)
{
    $mime_type = (int) q_singleval("SELECT id FROM phpgw_fud_mime WHERE fl_ext='" . addslashes(substr(strrchr($at['name'], '.'), 1)) . "'");
    $id = db_qid("INSERT INTO phpgw_fud_attach (location,message_id,original_name,owner,attach_opt,mime_type,fsize) VALUES('',0,'" . addslashes($at['name']) . "', " . $owner . ", " . $attach_opt . ", " . $mime_type . ", " . $at['size'] . ")");
    safe_attachment_copy($at['tmp_name'], $id, $ext);
    return $id;
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:7，代码来源:getfile.php

示例2: th_move

function th_move($id, $to_forum, $root_msg_id, $forum_id, $last_post_date, $last_post_id)
{
    if (!db_locked()) {
        db_lock('phpgw_fud_poll WRITE, phpgw_fud_thread_view WRITE, phpgw_fud_thread WRITE, phpgw_fud_forum WRITE, phpgw_fud_msg WRITE');
        $ll = 1;
    }
    $msg_count = q_singleval("SELECT count(*) FROM phpgw_fud_thread LEFT JOIN phpgw_fud_msg ON phpgw_fud_msg.thread_id=phpgw_fud_thread.id WHERE phpgw_fud_msg.apr=1 AND phpgw_fud_thread.id=" . $id);
    q('UPDATE phpgw_fud_thread SET forum_id=' . $to_forum . ' WHERE id=' . $id);
    q('UPDATE phpgw_fud_forum SET post_count=post_count-' . $msg_count . ' WHERE id=' . $forum_id);
    q('UPDATE phpgw_fud_forum SET thread_count=thread_count+1,post_count=post_count+' . $msg_count . ' WHERE id=' . $to_forum);
    q('DELETE FROM phpgw_fud_thread WHERE forum_id=' . $to_forum . ' AND root_msg_id=' . $root_msg_id . ' AND moved_to=' . $forum_id);
    if ($aff_rows = db_affected()) {
        q('UPDATE phpgw_fud_forum SET thread_count=thread_count-' . $aff_rows . ' WHERE id=' . $to_forum);
    }
    q('UPDATE phpgw_fud_thread SET moved_to=' . $to_forum . ' WHERE id!=' . $id . ' AND root_msg_id=' . $root_msg_id);
    q('INSERT INTO phpgw_fud_thread
		(forum_id, root_msg_id, last_post_date, last_post_id, moved_to)
	VALUES
		(' . $forum_id . ', ' . $root_msg_id . ', ' . $last_post_date . ', ' . $last_post_id . ', ' . $to_forum . ')');
    rebuild_forum_view($forum_id);
    rebuild_forum_view($to_forum);
    $c = q('SELECT poll_id FROM phpgw_fud_msg WHERE thread_id=' . $id . ' AND apr=1 AND poll_id>0');
    while ($r = db_rowarr($c)) {
        $p[] = $r[0];
    }
    unset($c);
    if (isset($p)) {
        q('UPDATE phpgw_fud_poll SET forum_id=' . $to_forum . ' WHERE id IN(' . implode(',', $p) . ')');
    }
    if (isset($ll)) {
        db_unlock();
    }
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:33，代码来源:mvthread.php

示例3: poll_validate

function poll_validate($poll_id, $msg_id)
{
    if (($mid = (int) q_singleval('SELECT id FROM phpgw_fud_msg WHERE poll_id=' . $poll_id)) && $mid != $msg_id) {
        return 0;
    } else {
        return $poll_id;
    }
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:8，代码来源:poll.php

示例4: get_sql_disk_usage

function get_sql_disk_usage()
{
    $ver = q_singleval('SELECT VERSION()');
    if ($ver[0] != 4 && strncmp($ver, '3.23', 4)) {
        return;
    }
    $sql_size = 0;
    $c = uq('SHOW TABLE STATUS FROM ' . $GLOBALS['phpgw_info']['server']['db_name'] . ' LIKE \'' . $GLOBALS['DBHOST_TBL_PREFIX'] . '%\'');
    while ($r = db_rowobj($c)) {
        $sql_size += $r->Data_length + $r->Index_length;
    }
    return $sql_size;
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:13，代码来源:admstats.php

示例5: register_vote

function register_vote(&$options, $poll_id, $opt_id, $mid)
{
    /* invalid option or previously voted */
    if (!isset($options[$opt_id]) || q_singleval('SELECT id FROM phpgw_fud_poll_opt_track WHERE poll_id=' . $poll_id . ' AND user_id=' . _uid)) {
        return;
    }
    if (db_li('INSERT INTO phpgw_fud_poll_opt_track(poll_id, user_id, poll_opt) VALUES(' . $poll_id . ', ' . _uid . ', ' . $opt_id . ')', $a)) {
        q('UPDATE phpgw_fud_poll_opt SET count=count+1 WHERE id=' . $opt_id);
        q('UPDATE phpgw_fud_poll SET total_votes=total_votes+1 WHERE id=' . $poll_id);
        poll_cache_rebuild($opt_id, $options);
        q('UPDATE phpgw_fud_msg SET poll_cache=' . strnull(addslashes(@serialize($options))) . ' WHERE id=' . $mid);
    }
    return 1;
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:14，代码来源:reported.php

示例6: grp_delete_member

function grp_delete_member($id, $user_id)
{
    if (!$user_id || $user_id == '2147483647') {
        return;
    }
    q('DELETE FROM phpgw_fud_group_members WHERE group_id=' . $id . ' AND user_id=' . $user_id);
    if (q_singleval("SELECT id FROM phpgw_fud_group_members WHERE user_id=" . $user_id . " LIMIT 1")) {
        /* we rebuild cache, since this user's permission for a particular resource are controled by
         * more the one group. */
        grp_rebuild_cache(array($user_id));
    } else {
        q("DELETE FROM phpgw_fud_group_cache WHERE user_id=" . $user_id);
    }
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:14，代码来源:groupmgr.php

示例7: ignore_add

    }
    if (!empty($usr->ignore_list)) {
        $usr->ignore_list = @unserialize($usr->ignore_list);
    }
    if (!isset($usr->ignore_list[$ignore_id])) {
        ignore_add(_uid, $ignore_id);
    } else {
        error_dialog('Info', 'You already have this user on your ignore list');
    }
}
/* incomming from message display page (ignore link) */
if (isset($_GET['add']) && ($_GET['add'] = (int) $_GET['add'])) {
    if (!empty($usr->ignore_list)) {
        $usr->ignore_list = @unserialize($usr->ignore_list);
    }
    if (($ignore_id = q_singleval('SELECT id FROM phpgw_fud_users WHERE id=' . $_GET['add'] . ' AND (users_opt & 1048576)=0')) && !isset($usr->ignore_list[$ignore_id])) {
        ignore_add(_uid, $ignore_id);
    }
    check_return($usr->returnto);
}
if (isset($_GET['del']) && ($_GET['del'] = (int) $_GET['del'])) {
    ignore_delete(_uid, $_GET['del']);
    /* needed for external links to this form */
    if (isset($_GET['redr'])) {
        check_return($usr->returnto);
    }
}
ses_update_status($usr->sid, 'Browsing own ignore list');
$ignore_member_search = $FUD_OPT_1 & (8388608 | 4194304) ? '<br>Or use the <a href="javascript://" class="GenLink" onClick="javascript: window_open(\'/egroupware/fudforum/3814588639/index.php?t=pmuserloc&amp;' . _rsid . '&amp;js_redr=buddy_add.add_login&amp;overwrite=1\', \'user_list\', 250,250);">Find User</a> feature to find a person.' : '';
$tabs = '';
if (_uid) {

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:ignore_list.php

示例8: php_uname

}
require $WWW_ROOT_DISK . 'adm/admpanel.php';
?>
<h2>System Configuration</h2>
<table class="datatable">
<tr>
	<td><b>PHP built On:</b></td>
	<td><?php 
echo php_uname();
?>
</td>
</tr>
<tr>
	<td><b>Database Version:</b></td>
	<td><?php 
echo q_singleval('SELECT VERSION()');
?>
</td>
</tr>
<tr>
	<td><b>PHP Version:</b></td>
	<td><?php 
echo PHP_VERSION;
?>
</td>
</tr>
<tr>
	<td><b>Web Server:</b></td>
	<td><?php 
echo get_server_software();
?>

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:admsysinfo.php

示例9: is_forum_notified

function is_forum_notified($user_id, $forum_id)
{
    return q_singleval('SELECT id FROM phpgw_fud_forum_notify WHERE forum_id=' . $forum_id . ' AND user_id=' . $user_id);
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:4，代码来源:threadt.php

示例10: alt_var

        $email_link = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Email:</td><td class="GenText">[<a href="/egroupware/fudforum/3814588639/index.php?t=email&amp;toi=' . $u->id . '&amp;' . _rsid . '">Clicca qui per spedire un&#39;email all&#39;utente</a>]</td></tr>';
    } else {
        $email_link = '';
    }
}
if ($referals = q_singleval('SELECT count(*) FROM phpgw_fud_users WHERE referer_id=' . $u->id)) {
    $referals = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Utenti referenziati:</td><td class="GenText"><a href="/egroupware/fudforum/3814588639/index.php?t=list_referers&amp;' . _rsid . '">' . $referals . ' Utenti</a></td></tr>';
} else {
    $referals = '';
}
if (_uid && _uid != $u->id && !q_singleval("SELECT id FROM phpgw_fud_buddy WHERE user_id=" . _uid . " AND bud_id=" . $u->id)) {
    $buddy = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Buddy:</td><td class="GenText"><a href="/egroupware/fudforum/3814588639/index.php?t=buddy_list&amp;add=' . $u->id . '&amp;' . _rsid . '" class="GenLink">aggiungi alla buddy list</a></td></tr>';
} else {
    $buddy = '';
}
if ($polls = q_singleval('SELECT count(*) FROM phpgw_fud_poll p INNER JOIN phpgw_fud_forum f ON p.forum_id=f.id WHERE p.owner=' . $u->id . ' AND f.cat_id>0 ' . ($usr->users_opt & 1048576 ? '' : ' AND f.id IN(' . implode(',', array_keys($frm_perms)) . ')'))) {
    $polls = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Sondaggi:</td><td class="GenText"><a href="/egroupware/fudforum/3814588639/index.php?t=polllist&amp;uid=' . $u->id . '&amp;' . _rsid . '">' . $polls . '</a></td></tr>';
} else {
    $polls = '';
}
$usrinfo_private_msg = $FUD_OPT_1 & 1024 && _uid ? '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Messaggio privato:</td><td class="GenText"><a href="/egroupware/index.php?menuaction=messenger.uimessenger.compose&message_to=;' . _rsid . '&amp;message_to=' . $u->alias . '" class="GenLink"><img src="/egroupware/fudforum/3814588639/theme/italian/images/msg_pm.gif" /></a></td></tr>' : '';
if ($u->users_opt & 1024) {
    $gender = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Genere:</td><td class="GenText">Maschio</td></tr>';
} else {
    if (!($u->users_opt & 512)) {
        $gender = '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Genere:</td><td class="GenText">Femmina</td></tr>';
    } else {
        $gender = '';
    }
}
$location = $u->location ? '<tr class="' . alt_var('search_alt', 'RowStyleA', 'RowStyleB') . '"><td nowrap class="GenText">Località:</td><td class="GenText">' . $u->location . '</td></tr>' : '';

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:usrinfo.php

示例11: pmsg_del

function pmsg_del($mid, $fldr = null)
{
    if (is_null($fldr) && is_null($fldr = q_singleval('SELECT fldr FROM phpgw_fud_pmsg WHERE duser_id=' . _uid . ' AND id=' . $mid))) {
        return;
    }
    if ($fldr != 5) {
        pmsg_move($mid, 5, false);
    } else {
        q('DELETE FROM phpgw_fud_pmsg WHERE id=' . $mid);
        $c = uq('SELECT id FROM phpgw_fud_attach WHERE message_id=' . $mid . ' AND attach_opt=1');
        while ($r = db_rowarr($c)) {
            @unlink($GLOBALS[''] . $r[0] . '.atch');
        }
        q('DELETE FROM phpgw_fud_attach WHERE message_id=' . $mid . ' AND attach_opt=1');
    }
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:16，代码来源:pmsg_view.php

示例12: q

">
<input type="hidden" name="adm_confirm" value="1">
<div align="center">You are taking away administration privileges from <font color="red"><b><?php 
                echo $u->alias;
                ?>
</b></font>!<br><br>
Are you sure you want to do this?<br>
<input type="submit" value="Yes" name="btn_yes"> <input type="submit" value="No" name="btn_no">
</div>
</form>
</body></html>
<?php 
                exit;
            } else {
                if (isset($_POST['btn_yes'])) {
                    if (q_singleval('SELECT count(*) FROM ' . $DBHOST_TBL_PREFIX . 'mod WHERE user_id=' . $u->id)) {
                        q('UPDATE ' . $DBHOST_TBL_PREFIX . 'users SET users_opt=(users_opt & ~ 1048576) |524288 WHERE id=' . $usr_id);
                        $u->users_opt ^= 1048576;
                    } else {
                        q('UPDATE ' . $DBHOST_TBL_PREFIX . 'users SET users_opt=users_opt & ~ (524288|1048576) WHERE id=' . $usr_id);
                        $u->users_opt = $u->users_opt & ~(1048576 | 524288);
                    }
                }
            }
        } else {
            if (!isset($_POST['adm_confirm'])) {
                ?>
<html>
<title>Adminstrator confirmation</title>
<body color="white">
<form method="post" action="admuser.php"><?php

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:admuser.php

示例13: foreach

     if (!$gid) {
         $error_reason = 'Failed to add group';
         $error = 1;
     } else {
         if ($gr_resource) {
             foreach ($gr_resource as $v) {
                 q('INSERT INTO ' . $DBHOST_TBL_PREFIX . 'group_resources (resource_id, group_id) VALUES(' . (int) $v . ', ' . $gid . ')');
             }
         }
         /* only rebuild the group cache if the all ANON/REG users were added */
         if ($gr_ramasks) {
             grp_rebuild_cache(array(0, 2147483647));
         }
     }
 } else {
     if (($frm = q_singleval('SELECT forum_id FROM ' . $DBHOST_TBL_PREFIX . 'groups WHERE id=' . $edit)) !== null) {
         /* update an existing group */
         if (!$res) {
             $old = db_sab("SELECT groups_opt, groups_opti FROM " . $DBHOST_TBL_PREFIX . "groups WHERE id=" . $edit);
         } else {
             $old =& $res[$edit];
         }
         group_sync($edit, isset($_POST['gr_name']) ? $_POST['gr_name'] : null, $gr_inherit_id, $perm, $permi);
         if (!$frm) {
             q('DELETE FROM ' . $DBHOST_TBL_PREFIX . 'group_resources WHERE group_id=' . $edit);
             $aff = db_affected();
             if ($gr_resource) {
                 foreach ($gr_resource as $v) {
                     q('INSERT INTO ' . $DBHOST_TBL_PREFIX . 'group_resources (resource_id, group_id) VALUES(' . (int) $v . ', ' . $edit . ')');
                 }
             }

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:admgroups.php

示例14: compile_all

     $edit = '';
 } else {
     if (isset($_GET['rebuild']) && ($data = db_saq('SELECT theme, lang, name FROM ' . $DBHOST_TBL_PREFIX . 'themes WHERE id=' . (int) $_GET['rebuild']))) {
         compile_all($data[0], $data[1], $data[2]);
     } else {
         if (isset($_GET['edit']) && ($c = db_arr_assoc('SELECT * FROM ' . $DBHOST_TBL_PREFIX . 'themes WHERE id=' . $edit))) {
             foreach ($c as $k => $v) {
                 ${'thm_' . $k} = $v;
             }
             $thm_t_default = $c['theme_opt'] & 2;
             $thm_enabled = $c['theme_opt'] & 1;
         } else {
             if (isset($_GET['del']) && (int) $_GET['del'] > 1) {
                 fud_theme::delete((int) $_GET['del']);
             } else {
                 if (isset($_GET['optimize']) && $is_tok && ($t_name = q_singleval('SELECT name FROM ' . $DBHOST_TBL_PREFIX . 'themes WHERE id=' . (int) $_GET['optimize']))) {
                     /* optimize *.php files */
                     $path = $WWW_ROOT_DISK . 'theme/' . $t_name;
                     $dir = opendir($path);
                     $path .= '/';
                     while ($f = readdir($dir)) {
                         if ($f == '.' || $f == '..') {
                             continue;
                         }
                         if (@is_file($path . $f) && substr($f, -4) == '.php') {
                             $toks = token_get_all(file_get_contents($path . $f));
                             while (get_func_usage($toks)) {
                             }
                             clean_code($path . $f, $toks);
                         }
                     }

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:admthemes.php

示例15: user_set_post_count

function user_set_post_count($uid)
{
    $pd = db_saq("SELECT MAX(id),count(*) FROM phpgw_fud_msg WHERE poster_id=" . $uid . " AND apr=1");
    $level_id = (int) q_singleval('SELECT id FROM phpgw_fud_level WHERE post_count <= ' . $pd[1] . ' ORDER BY post_count DESC LIMIT 1');
    q('UPDATE phpgw_fud_users SET u_last_post_id=' . (int) $pd[0] . ', posted_msg_count=' . (int) $pd[1] . ', level_id=' . $level_id . ' WHERE id=' . $uid);
}

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:6，代码来源:index.php

示例16: fud_egw

* (at your option) any later version.
***************************************************************************/
require './GLOBALS.php';
fud_egw();
fud_use('adm.inc', true);
$tbl = $GLOBALS['DBHOST_TBL_PREFIX'];
if (isset($_GET['usr_id'])) {
    $usr_id = (int) $_GET['usr_id'];
} else {
    if (isset($_POST['usr_id'])) {
        $usr_id = (int) $_POST['usr_id'];
    } else {
        $usr_id = '';
    }
}
if (!$usr_id || !($login = q_singleval('SELECT alias FROM ' . $tbl . 'users WHERE id=' . $usr_id))) {
    exit('<html><script language="JavaScript">window.close();</script></html>');
}
if (isset($_POST['mod_submit'])) {
    q('DELETE FROM ' . $tbl . 'mod WHERE user_id=' . $usr_id);
    if (isset($_POST['mod_allow'])) {
        foreach ($_POST['mod_allow'] as $m) {
            q('INSERT INTO ' . $tbl . 'mod (forum_id, user_id) VALUES(' . (int) $m . ', ' . $usr_id . ')');
        }
    }
    /* mod rebuild */
    fud_use('users_reg.inc');
    rebuildmodlist();
    ?>
<html>
<script language="JavaScript">

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:admmodfrm.php

示例17: q_singleval

    $usr_lmt = ' p.owner=' . $uid . ' AND ';
} else {
    $uid = $usr_lmt = '';
}
if ($_GET['oby'] == 'ASC') {
    $oby = 'ASC';
    $oby_rev_val = 'DESC';
} else {
    $oby = 'DESC';
    $oby_rev_val = 'ASC';
}
$ttl = (int) q_singleval('SELECT count(*)
				FROM phpgw_fud_poll p
				INNER JOIN phpgw_fud_forum f ON p.forum_id=f.id
				INNER JOIN phpgw_fud_cat c ON c.id=f.cat_id
				LEFT JOIN phpgw_fud_mod mm ON mm.forum_id=p.forum_id AND mm.user_id=' . _uid . '
				INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=' . (_uid ? '2147483647' : '0') . ' AND g1.resource_id=p.forum_id
				LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=' . _uid . ' AND g2.resource_id=p.forum_id
				WHERE
					' . $usr_lmt . ($usr->users_opt & 1048576 ? ' 1=1' : ' (mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) & 2) > 0)'));
$poll_entries = $pager = '';
if ($ttl) {
    $c = uq('SELECT
				p.owner, p.name, (CASE WHEN expiry_date = 0 THEN 0 ELSE (p.creation_date + p.expiry_date) END) AS poll_expiry_date, p.creation_date, p.id AS poid, p.max_votes, p.total_votes,
				u.alias, u.alias AS login, (u.last_visit + ' . $LOGEDIN_TIMEOUT * 60 . ') AS last_visit, u.users_opt,
				m.id,
				t.thread_opt,
				' . ($usr->users_opt & 1048576 ? '1' : 'mm.id') . ' AS md,
				pot.id AS cant_vote,
				(CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS gco
				FROM phpgw_fud_poll p

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:31，代码来源:polllist.php

示例18: del_account

 function del_account($row)
 {
     $ac_id = (int) $row['account_id'];
     if (!$ac_id) {
         return;
     }
     define('plain_page', 1);
     $db =& $GLOBALS['phpgw']->db;
     $server =& $GLOBALS['phpgw_info']['server'];
     require $server['files_dir'] . "/fudforum/" . sprintf("%u", crc32($GLOBALS['phpgw_info']['user']['domain'])) . "/include/GLOBALS.php";
     if (!empty($server['use_adodb']) || empty($db->Link_ID) || !is_resource($db->Link_ID)) {
         // open your own connection, as ADOdb does not export the use Link_ID
         switch ($server['db_type']) {
             case 'mysql':
                 $func = $server['db_persistent'] ? 'mysql_pconnect' : 'mysql_connect';
                 define('fud_sql_lnk', $func($db->Host, $db->User, $db->Password));
                 mysql_select_db($db->Database, fud_sql_lnk);
                 break;
             case 'pgsql':
                 $func = $server['db_persistent'] ? 'pg_pconnect' : 'pg_connect';
                 define('fud_sql_lnk', $func('dbname=' . $db->Database . ' host=' . $db->Host . ' user=' . $db->User . ' password=' . $db->Password));
                 break;
             default:
                 die('FUDforum only supports mysql or pgsql !!!');
         }
         unset($func);
     } else {
         define('fud_sql_lnk', $db->Link_ID);
     }
     fud_use('db.inc');
     fud_use('private.inc');
     fud_use('users_reg.inc');
     fud_use('users_adm.inc', true);
     $GLOBALS['DBHOST_TBL_PREFIX'] = 'phpgw_fud_';
     $id = q_singleval("SELECT id FROM phpgw_fud_users WHERE egw_id=" . $ac_id);
     if ($id) {
         usr_delete($id);
     }
 }

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:39，代码来源:class.ufud.inc.php

示例19: q_singleval

<div align="center">
<table border="0" cellspacing="1" cellpadding="2" class="mnavWarnTbl">
<tr>
	<td class="GenTextRed">The date range you&#39;ve specified is larger then the one allowed by the administrator, narrow down date range of your search.</td>
</tr>
</table>
</div>';
            $mnav_pager = '';
        } else {
            if (isset($_GET['u'])) {
                $tm = __request_timestamp__ - $mage;
                $total = q_singleval('SELECT count(*) FROM phpgw_fud_msg m
					INNER JOIN phpgw_fud_thread t ON m.thread_id=t.id
					INNER JOIN phpgw_fud_forum f ON t.forum_id=f.id
					INNER JOIN phpgw_fud_cat c ON f.cat_id=c.id
					INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=' . (_uid ? '2147483647' : '0') . ' AND g1.resource_id=f.id
					LEFT JOIN phpgw_fud_mod mm ON mm.forum_id=f.id AND mm.user_id=' . _uid . '
					LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=' . _uid . ' AND g2.resource_id=f.id
				WHERE
					m.post_stamp > ' . $tm . ' AND m.apr=1 ' . $qry_lmt . '
					' . ($usr->users_opt & 1048576 ? '' : ' AND (mm.id IS NOT NULL OR ((CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) & 2) > 0)'));
                if (!$total) {
                    $mnav_pager = '';
                    $mnav_data = '<div align="center" class="GenText" class="manvNoRes">There are no messages matching query.</div>';
                } else {
                    $c = uq('SELECT u.alias, f.name AS forum_name, f.id AS forum_id,
					m.poster_id, m.id, m.thread_id, m.subject, m.poster_id, m.foff, m.length, m.post_stamp, m.file_id, m.icon
					FROM phpgw_fud_msg m
					INNER JOIN phpgw_fud_thread t ON m.thread_id=t.id
					INNER JOIN phpgw_fud_forum f ON t.forum_id=f.id
					INNER JOIN phpgw_fud_cat c ON f.cat_id=c.id
					INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=' . (_uid ? '2147483647' : '0') . ' AND g1.resource_id=f.id

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:32，代码来源:mnav.php

示例20: sync_user

 function sync_user()
 {
     $rb_mod_list = !($this->users_opt & 524288) && ($is_mod = q_singleval("SELECT id FROM phpgw_fud_mod WHERE user_id={$this->id}")) && q_singleval("SELECT alias FROM phpgw_fud_users WHERE id={$this->id}") == $this->alias;
     q("UPDATE phpgw_fud_users SET " . $passwd . "\n\t\t\ticq=" . in($this->icq) . ",\n\t\t\taim=" . ssn(urlencode($this->aim)) . ",\n\t\t\tyahoo=" . ssn(urlencode($this->yahoo)) . ",\n\t\t\tmsnm=" . ssn(urlencode($this->msnm)) . ",\n\t\t\tjabber=" . ssn(htmlspecialchars($this->jabber)) . ",\n\t\t\taffero=" . ssn(urlencode($this->affero)) . ",\n\t\t\tposts_ppg='" . iz($this->posts_ppg) . "',\n\t\t\ttime_zone='" . addslashes($this->time_zone) . "',\n\t\t\tbday=" . iz($this->bday) . ",\n\t\t\tuser_image=" . ssn(htmlspecialchars($this->user_image)) . ",\n\t\t\tlocation=" . ssn(htmlspecialchars($this->location)) . ",\n\t\t\toccupation=" . ssn(htmlspecialchars($this->occupation)) . ",\n\t\t\tinterests=" . ssn(htmlspecialchars($this->interests)) . ",\n\t\t\tavatar=" . iz($this->avatar) . ",\n\t\t\ttheme=" . iz($this->theme) . ",\n\t\t\tavatar_loc=" . ssn($this->avatar_loc) . ",\n\t\t\tsig=" . ssn($this->sig) . ",\n\t\t\thome_page=" . ssn(htmlspecialchars($this->home_page)) . ",\n\t\t\tbio=" . ssn($this->bio) . ",\n\t\t\tusers_opt=" . $this->users_opt . "\n\t\tWHERE id=" . $this->id);
     if ($rb_mod_list) {
         rebuildmodlist();
     }
 }

开发者ID:BackupTheBerlios，项目名称:milaninegw-svn，代码行数:8，代码来源:register.php

注：本文中的q_singleval函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP qa函数代码示例发布时间：2022-05-15

PHP q函数代码示例发布时间：2022-05-15

CVE-2022-32119

1 krishnaik06/Machine-Learning-in-90-days

krishnaik06/Machine-Learning-in-90-days

阅读：1054|2022-08-18

2 CVE-2021-31676

A reflected XSS was discovered in PESCMS-V2.3.3. When combined with CSRF in the

阅读：857|2022-07-08

3 armancodv/building-energy-model-matlab:

armancodv/building-energy-model-matlab: It is a small software which is develope

阅读：1108|2022-08-17

4 美元符号为什么是“$”

在美元的英文“dollar”里面明明没有字母“s”，为什么美元的符号($)是一条竖线穿过字

阅读：1056|2022-11-06

5 libevent/libevent: Event notification li

libevent/libevent: Event notification library

阅读：747|2022-08-15

6 FGRibreau/import-tweets-to-mastodon: How

FGRibreau/import-tweets-to-mastodon: How to import tweets to mastodon (e.g. http

阅读：918|2022-08-17

7 tboronczyk/localization-middleware: PSR-

tboronczyk/localization-middleware: PSR-15 middleware to assist primarily with l

阅读：493|2022-08-16

8 长沙科技学院怎么样?是几本

长沙城南，有一所以“环保”为名的学校，从1979年创立以来，四易归属、五更其名。这

阅读：747|2022-11-06

9 heinrichreimer/material-intro: A simple

heinrichreimer/material-intro: A simple material design app intro with cool anim

阅读：404|2022-08-17

10 matlab中imfilter、conv2、imfilter2用法及

来源：https://blog.csdn.net/u013066730/article/details/56665308（比较详细） htt

阅读：747|2022-07-18

客服电话

电子邮件

PHP q_singleval函数代码示例

示例1: attach_add

示例2: th_move

示例3: poll_validate

示例4: get_sql_disk_usage

示例5: register_vote

示例6: grp_delete_member

示例7: ignore_add

示例8: php_uname

示例9: is_forum_notified

示例10: alt_var

示例11: pmsg_del

示例12: q

示例13: foreach

示例14: compile_all

示例15: user_set_post_count

示例16: fud_egw

示例17: q_singleval

示例18: del_account

示例19: q_singleval

示例20: sync_user

请发表评论

全部评论

上一篇：

下一篇：

krishnaik06/Machine-Learning-in-90-days

CVE-2022-34972

armancodv/building-energy-model-matlab:

美元符号为什么是“$”

jvandemo/generator-angular2-library: Yeo

CVE-2022-32119

PacktPublishing/Python-Machine-Learning-

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

TheDelphiContainerLibrary(DCLX)几处BUG

关于我们

产品与服务

解决方案

139-2527-9053