本文整理汇总了PHP中ListName函数的典型用法代码示例。如果您正苦于以下问题:PHP ListName函数的具体用法?PHP ListName怎么用?PHP ListName使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了ListName函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: Sql_Query
Sql_Query("update {$tables['user']} set htmlemail = 0");
$total = Sql_Affected_Rows();
$action_result .= "<br/>{$total} " . $GLOBALS['I18N']->get('subscribers apply') . '<br/>';
break;
case 'nolists':
$action_result .= $GLOBALS['I18N']->get('Deleting subscribers who are not on any list');
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables['user'], $tables['user'], $tables['listuser'], $tables['user'], $tables['listuser']));
$total = Sql_Affected_Rows();
$action_result .= "<br/>{$total} " . $GLOBALS['I18N']->get('subscribers apply') . '<br/>';
$todo = 'deleteUser';
break;
case 'nolistsnewlist':
$list = sprintf('%d', $_GET['list']);
$action_result .= $GLOBALS['I18N']->get('Moving subscribers who are not on any list to') . ' ' . ListName($list);
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables['user'], $tables['user'], $tables['listuser'], $tables['user'], $tables['listuser']));
$total = Sql_Affected_Rows();
$action_result .= "<br/>{$total} " . $GLOBALS['I18N']->get('subscribers apply') . '<br/>';
$todo = 'moveUser';
break;
case 'bounces':
$action_result .= $GLOBALS['I18N']->get('Deleting subscribers with more than') . ' ' . $num . ' ' . $GLOBALS['I18N']->get('bounces');
$req = Sql_Query(sprintf('select id from %s
where bouncecount > %d', $tables['user'], $num));
$total = Sql_Affected_Rows();
$action_result .= "<br/>{$total} " . $GLOBALS['I18N']->get('subscribers apply') . '<br/>';
$todo = 'deleteUser';
break;
示例2: Sql_Fetch_Row_Query
if ($_SESSION['export']['column'] == 'nodate') {
## fetch dates as min and max from user table
if ($list) {
$dates = Sql_Fetch_Row_Query(sprintf('select date(min(user.modified)),date(max(user.modified)) from %s where listid = %d %s', $querytables, $list, $subselect));
} else {
## this takes begin and end of all users, regardless of whether they are on the list of this admin @TODO
$dates = Sql_Fetch_Row_Query(sprintf('select date(min(user.modified)),date(max(user.modified)) from %s ', $querytables));
}
$fromdate = $dates[0];
$todate = $dates[1];
} else {
$fromdate = $_SESSION['export']['fromdate'];
$todate = $_SESSION['export']['todate'];
}
if ($list) {
$filename = s('phpList Export on %s from %s to %s (%s).csv', ListName($list), $fromdate, $todate, date('Y-M-d'));
} else {
$filename = s('phpList Export from %s to %s (%s).csv', $fromdate, $todate, date('Y-M-d'));
}
ob_end_clean();
$filename = trim(strip_tags($filename));
if (!empty($_SESSION['export']['fileready']) && is_file($_SESSION['export']['fileready'])) {
header('Content-type: ' . $GLOBALS['export_mimetype'] . '; charset=UTF-8');
header("Content-disposition: attachment; filename=\"{$filename}\"");
$fp = fopen($_SESSION['export']['fileready'], 'r');
while (!feof($fp)) {
print fgets($fp);
}
fclose($fp);
unlink($_SESSION['export']['fileready']);
unset($_SESSION['export']);
示例3: array
}
$_SESSION['export'] = array();
$_SESSION['export']['column'] = $_POST['column'];
$_SESSION['export']['cols'] = $_POST['cols'];
$_SESSION['export']['attrs'] = $_POST['attrs'];
$_SESSION['export']['fromdate'] = $from->getDate("from");
$_SESSION['export']['todate'] = $to->getDate("to");
$_SESSION['export']['list'] = $list;
print '<p>' . s('Processing export, this may take a while. Please wait') . '</p>';
print $GLOBALS['img_busy'];
print '<div id="progresscount" style="width: 200; height: 50;">Progress</div>';
print '<br/> <iframe id="export" src="./?page=pageaction&action=export&ajaxed=true' . addCsrfGetToken() . '" scrolling="no" height="50"></iframe>';
return;
}
if ($list) {
print sprintf($GLOBALS['I18N']->get('Export subscribers on %s'), ListName($list));
}
print formStart();
$checked = 'entered';
if (isset($_GET['list']) && $_GET['list'] == 'all') {
$checked = 'nodate';
}
?>
<?php
echo $GLOBALS['I18N']->get('What date needs to be used:');
?>
<br/>
<input type="radio" name="column" value="nodate" <?php
echo $checked == 'nodate' ? ' checked="checked"' : '';
?>
示例4: addUserForm
return;
}
$subselect = " where id = 0";
break;
}
function addUserForm($listid)
{
//nizar 'value'
$html = formStart() . '<input type=hidden name=listid value="' . $listid . '">
' . $GLOBALS['I18N']->get("Add a user") . ': <input type=text name=new value="" size=40><input type=submit
name=add value="' . $GLOBALS['I18N']->get('Add') . '">
</form>';
return $html;
}
if (isset($id)) {
print "<h3>" . $GLOBALS['I18N']->get("Members of") . " " . ListName($id) . "</h3>";
echo "<br />" . PageLink2("editlist", $GLOBALS['I18N']->get("back to this list"), "id={$id}");
echo "<br />" . PageLink2("export&list={$id}", $GLOBALS['I18N']->get("Download users on this list as a CSV file"));
print addUserForm($id);
} else {
Fatal_Error($GLOBALS['I18N']->get("Please enter a listid"));
}
if (isset($_REQUEST["processtags"]) && $access != "view") {
print $GLOBALS['I18N']->get("Processing") . " .... <br/>";
if ($_POST["tagaction"] && is_array($_POST["user"])) {
switch ($_POST["tagaction"]) {
case "move":
$cnt = 0;
foreach ($_POST["user"] as $key => $val) {
Sql_query("delete from {$tables["listuser"]} where listid = {$id} and userid =\n {$key}");
Sql_query("replace into {$tables["listuser"]} (listid,userid)\n values({$_POST["movedestination"]},{$key})");
示例5: array
}
$_SESSION['export'] = array();
$_SESSION['export']['column'] = $_POST['column'];
$_SESSION['export']['cols'] = $_POST['cols'];
$_SESSION['export']['attrs'] = $_POST['attrs'];
$_SESSION['export']['fromdate'] = $from->getDate('from');
$_SESSION['export']['todate'] = $to->getDate('to');
$_SESSION['export']['list'] = $list;
print '<p>' . s('Processing export, this may take a while. Please wait') . '</p>';
print $GLOBALS['img_busy'];
print '<div id="progresscount" style="width: 200; height: 50;">Progress</div>';
print '<br/> <iframe id="export" src="./?page=pageaction&action=export&ajaxed=true' . addCsrfGetToken() . '" scrolling="no" height="50"></iframe>';
return;
}
if ($list) {
print s('Export subscribers on %s', ListName($list));
}
print formStart();
$checked = 'entered';
if (isset($_GET['list']) && $_GET['list'] == 'all') {
$checked = 'nodate';
}
?>
<?php
echo $GLOBALS['I18N']->get('What date needs to be used:');
?>
<br/>
<input type="radio" name="column"
value="nodate" <?php
echo $checked == 'nodate' ? ' checked="checked"' : '';
示例6: sendEmail
//.........这里部分代码省略.........
}
# $req = Sql_Query(sprintf('select filename,data from %s where template = %d',
# $GLOBALS["tables"]["templateimage"],$cached[$messageid]["templateid"]));
$htmlmessage = eregi_replace("\\[USERID\\]", $hash, $htmlmessage);
$textmessage = eregi_replace("\\[USERID\\]", $hash, $textmessage);
$htmlmessage = preg_replace("/\\[USERTRACK\\]/i", '<img src="' . $GLOBALS['scheme'] . '://' . $website . $GLOBALS["pageroot"] . '/ut.php?u=' . $hash . '&m=' . $messageid . '" width="1" height="1" border="0">', $htmlmessage, 1);
$htmlmessage = eregi_replace("\\[USERTRACK\\]", '', $htmlmessage);
if ($listowner) {
$att_req = Sql_Query("select name,value from {$GLOBALS["tables"]["adminattribute"]},{$GLOBALS["tables"]["admin_attribute"]} where {$GLOBALS["tables"]["adminattribute"]}.id = {$GLOBALS["tables"]["admin_attribute"]}.adminattributeid and {$GLOBALS["tables"]["admin_attribute"]}.adminid = {$listowner}");
while ($att = Sql_Fetch_Array($att_req)) {
$htmlmessage = preg_replace("#\\[LISTOWNER." . strtoupper(preg_quote($att["name"])) . "\\]#", $att["value"], $htmlmessage);
}
}
if (is_array($GLOBALS["default_config"])) {
foreach ($GLOBALS["default_config"] as $key => $val) {
if (is_array($val)) {
$htmlmessage = eregi_replace("\\[{$key}\\]", getConfig($key), $htmlmessage);
$textmessage = eregi_replace("\\[{$key}\\]", getConfig($key), $textmessage);
}
}
}
## RSS
if (ENABLE_RSS && sizeof($rssitems)) {
$rssentries = array();
$request = join(",", $rssitems);
$texttemplate = getConfig("rsstexttemplate");
$htmltemplate = getConfig("rsshtmltemplate");
$textseparatortemplate = getConfig("rsstextseparatortemplate");
$htmlseparatortemplate = getConfig("rsshtmlseparatortemplate");
$req = Sql_Query("select * from {$GLOBALS["tables"]["rssitem"]} where id in ({$request}) order by list,added");
$curlist = "";
while ($row = Sql_Fetch_array($req)) {
if ($curlist != $row["list"]) {
$row["listname"] = ListName($row["list"]);
$curlist = $row["list"];
$rssentries["text"] .= parseRSSTemplate($textseparatortemplate, $row);
$rssentries["html"] .= parseRSSTemplate($htmlseparatortemplate, $row);
}
$data_req = Sql_Query("select * from {$GLOBALS["tables"]["rssitem_data"]} where itemid = {$row["id"]}");
while ($data = Sql_Fetch_Array($data_req)) {
$row[$data["tag"]] = $data["data"];
}
$rssentries["text"] .= stripHTML(parseRSSTemplate($texttemplate, $row));
$rssentries["html"] .= parseRSSTemplate($htmltemplate, $row);
}
$htmlmessage = eregi_replace("\\[RSS\\]", $rssentries["html"], $htmlmessage);
$textmessage = eregi_replace("\\[RSS\\]", $rssentries["text"], $textmessage);
}
if (is_array($userdata)) {
foreach ($userdata as $name => $value) {
if (eregi("\\[" . $name . "\\]", $htmlmessage, $regs)) {
$htmlmessage = eregi_replace("\\[" . $name . "\\]", $value, $htmlmessage);
}
if (eregi("\\[" . $name . "\\]", $textmessage, $regs)) {
$textmessage = eregi_replace("\\[" . $name . "\\]", $value, $textmessage);
}
}
}
$destinationemail = '';
if (is_array($user_att_values)) {
foreach ($user_att_values as $att_name => $att_value) {
if (eregi("\\[" . $att_name . "\\]", $htmlmessage, $regs)) {
# the value may be a multiline textarea field
$htmlatt_value = str_replace("\n", "<br/>\n", $att_value);
$htmlmessage = eregi_replace("\\[" . $att_name . "\\]", $htmlatt_value, $htmlmessage);
}
示例7: Sql_Query
Sql_Query("update {$tables["user"]} set htmlemail = 0");
$total = Sql_Affected_Rows();
print "{$total} " . $GLOBALS['I18N']->get('users apply') . "<br/>";
break;
case "nolists":
info($GLOBALS['I18N']->get("Deleting users who are not on any list"));
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables["user"], $tables["user"], $tables["listuser"], $tables["user"], $tables["listuser"]));
$total = Sql_Affected_Rows();
print "{$total} " . $GLOBALS['I18N']->get('users apply') . "<br/>";
$todo = "deleteUser";
break;
case "nolistsnewlist":
$list = sprintf('%d', $_GET["list"]);
info($GLOBALS['I18N']->get("Moving users who are not on any list to") . " " . ListName($list));
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables["user"], $tables["user"], $tables["listuser"], $tables["user"], $tables["listuser"]));
$total = Sql_Affected_Rows();
print "{$total} " . $GLOBALS['I18N']->get('users apply') . "<br/>";
$todo = "moveUser";
break;
case "bounces":
info($GLOBALS['I18N']->get("Deleting users with more than") . " " . $_REQUEST["num"] . " " . $GLOBALS['I18N']->get('bounces'));
$req = Sql_Query(sprintf('select id from %s
where bouncecount > %d', $tables["user"], $_REQUEST["num"]));
$total = Sql_Affected_Rows();
print "{$total} " . $GLOBALS['I18N']->get('users apply') . "<br/>";
$todo = "deleteUser";
break;
示例8: Sql_Query
}
}
# submitting page now saves everything, so check is not necessary
if ($subselect == "") {
Sql_Query("delete from {$tables["listuser"]} where userid = {$id}");
} else {
# only unsubscribe from the lists of this admin
$req = Sql_Query("select id from {$tables["list"]} {$subselect_where}");
while ($row = Sql_Fetch_Row($req)) {
Sql_Query("delete from {$tables["listuser"]} where userid = {$id} and listid = {$row['0']}");
}
}
if (is_array($_POST["subscribe"])) {
foreach ($_POST["subscribe"] as $ind => $lst) {
Sql_Query("insert into {$tables["listuser"]} (userid,listid) values({$id},{$lst})");
print '<br/>' . sprintf($GLOBALS['I18N']->get('User added to list %s'), ListName($lst));
}
print "<br/>";
}
$history_entry = '';
$current_data = Sql_Fetch_Array_Query(sprintf('select * from %s where id = %d', $tables["user"], $id));
$current_data = array_merge($current_data, getUserAttributeValues('', $id));
foreach ($current_data as $key => $val) {
if (!is_numeric($key)) {
if ($old_data[$key] != $val && $key != "modified") {
$history_entry .= "{$key} = {$val}\nchanged from {$old_data[$key]}\n";
}
}
}
if (!$history_entry) {
$history_entry = "\nNo userdata changed";
示例9: ListName
break;
case "all":
$subselect = "";
break;
case "none":
default:
$subselect = "where " . $tables["rssitem"] . ".list = " . $tables["list"] . ".id and " . $tables["list"] . ".owner = 0";
break;
}
} else {
$querytables = $tables["rssitem"];
$subselect = "";
if ($_GET["id"]) {
$pagingurl = '&id=' . $_GET["id"];
$subselect = "where " . $tables["rssitem"] . ".list = " . $_GET["id"];
print "RSS items for " . ListName($_GET["id"]) . "<br/>";
}
}
$req = Sql_query("SELECT count(*) FROM {$querytables} {$subselect}");
$total_req = Sql_Fetch_Row($req);
$total = $total_req[0];
if (isset($start) && $start > 0) {
$listing = "Listing item {$start} to " . ($start + MAX_MSG_PP);
$limit = "limit {$start}," . MAX_MSG_PP;
} else {
$listing = "Listing item 1 to " . MAX_MSG_PP;
$limit = "limit 0," . MAX_MSG_PP;
$start = 0;
}
print $total . " RSS Items</p>";
if ($total) {
示例10: Sql_query
}
print $value . $col_delim;
}
$lists = Sql_query("select listid,name from\n {$tables['listuser']},{$tables['list']} where userid = " . $user["id"] . " and\n {$tables['listuser']}.listid = {$tables['list']}.id {$listselect_and}");
if (!Sql_Affected_rows($lists)) {
print "No Lists";
}
while ($list = Sql_fetch_array($lists)) {
print stripslashes($list["name"]) . " ";
}
print $row_delim;
}
exit;
}
if ($list) {
print sprintf($GLOBALS['I18N']->get('ExportOn'), ListName($list));
}
?>
<form method=post>
<br/><br/>
<table>
<tr><td><?php
echo $GLOBALS['I18N']->get('DateFrom');
?>
</td><td><?php
echo $from->showInput("", "", $fromval);
?>
</td></tr>
<tr><td><?php
示例11: addUserForm
return;
}
$subselect = ' where id = 0';
break;
}
function addUserForm($listid)
{
//nizar 'value'
$html = formStart(' class="membersAdd" ') . '<input type="hidden" name="listid" value="' . $listid . '" />
' . $GLOBALS['I18N']->get('Add a user') . ': <input type="text" name="new" value="" size="40" id="emailsearch"/>
<input class="submit" type="submit" name="add" value="' . $GLOBALS['I18N']->get('Add') . '" />
</form>';
return $html;
}
if (!empty($id)) {
print '<h3>' . $GLOBALS['I18N']->get('Members of') . ' ' . ListName($id) . '</h3>';
print '<div class="actions">';
echo PageLinkButton('editlist', $GLOBALS['I18N']->get('edit list details'), "id={$id}", 'pill-l');
echo PageLinkButton("export&list={$id}", $GLOBALS['I18N']->get('Download subscribers'), '', 'pill-c');
echo PageLinkDialog("importsimple&list={$id}", $GLOBALS['I18N']->get('Import Subscribers to this list'), '', 'pill-r');
print '</div>';
} else {
if ($_REQUEST['id'] != 'all') {
Redirect('list');
} else {
$id = 'all';
$listAll = true;
}
print '<div class="actions">';
echo PageLinkButton('export&list=all', $GLOBALS['I18N']->get('Download subscribers'), '', 'pill-c');
print '</div>';
示例12: addUserForm
return;
}
$subselect = " where id = 0";
break;
}
function addUserForm ($listid) {
$html = formStart().'<input type=hidden name=listid value="'.$listid.'">
Add a user: <input type=text name=new value="" size=40><input type=submit
name=add value="Add">
</form>';
return $html;
}
if (isset($id)) {
print "<h3>Members of ".ListName($id)."</h3>";
echo "<br />".PageLink2("editlist","back to this list","id=$id");
echo "<br />".PageLink2("export&list=$id","Download users on this list as a CSV
file");
print addUserForm($id);
} else {
Fatal_Error("Please enter a listid");
}
if (isset($processtags) && $access != "view") {
print "Processing .... <br/>";
if ($tagaction && is_array($user)) {
switch ($tagaction) {
case "move":
$cnt = 0;
while (list($key,$val) = each ($user)) {
示例13: join
}
$value = join(",", $newval);
} else {
$value = "";
}
Sql_Query(sprintf('replace into %s (userid,attributeid,value)
values(%d,%d,"%s")', $tables["user_attribute"], $id, $val, $value));
}
}
# submitting page now saves everything, so check is not necessary
# if (is_array($subscribe)) {
Sql_Query("delete from {$tables["listuser"]} where userid = {$id}");
if (is_array($subscribe)) {
foreach ($subscribe as $ind => $lst) {
Sql_Query("insert into {$tables["listuser"]} (userid,listid) values({$id},{$lst})");
print "User added to " . ListName($lst) . "<br/>";
}
}
# }
Info("Changes saved");
}
if (isset($delete) && $delete && $access != "view") {
# delete the index in delete
print "Deleting {$delete} ..\n";
if ($require_login && !isSuperUser()) {
$lists = Sql_query("SELECT listid FROM {$tables["listuser"]},{$tables["list"]} where userid = " . $delete . " and {$tables['listuser']}.listid = {$tables['list']}.id {$subselect} ");
while ($lst = Sql_fetch_array($lists)) {
Sql_query("delete from {$tables["listuser"]} where userid = {$delete} and listid = {$lst['0']}");
}
} else {
deleteUser($delete);
示例14: switch
switch ($access) {
case "all":
if ($option) {
set_time_limit(600);
switch ($option) {
case "nolists":
info("Deleting users who are not on any list");
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables["user"], $tables["user"], $tables["listuser"], $tables["user"], $tables["listuser"]));
$total = Sql_Affected_Rows();
print "{$total} users apply<br/>";
$todo = "deleteUser";
break;
case "nolistsnewlist":
info("Moving users who are not on any list to " . ListName($list));
$req = Sql_Query(sprintf('select %s.id from %s
left join %s on %s.id = %s.userid
where userid is NULL', $tables["user"], $tables["user"], $tables["listuser"], $tables["user"], $tables["listuser"]));
$total = Sql_Affected_Rows();
print "{$total} users apply<br/>";
$todo = "moveUser";
break;
case "bounces":
info("Deleting users with more than " . $_REQUEST["num"] . " bounces");
$req = Sql_Query(sprintf('select id from %s
where bouncecount > %d', $tables["user"], $_REQUEST["num"]));
$total = Sql_Affected_Rows();
print "{$total} users apply<br/>";
$todo = "deleteUser";
break;
示例15: ListName
break;
case "all":
$subselect = "";
break;
case "none":
default:
$subselect = "where " . $tables["rssitem"] . ".list = " . $tables["list"] . ".id and " . $tables["list"] . ".owner = 0";
break;
}
} else {
$querytables = $tables["rssitem"];
$subselect = "";
if ($id) {
$pagingurl = '&id=' . $id;
$subselect = "where " . $tables["rssitem"] . ".list = " . $id;
print "RSS items for " . ListName($id) . "<br/>";
}
}
$req = Sql_query("SELECT count(*) FROM {$querytables} {$subselect}");
$total_req = Sql_Fetch_Row($req);
$total = $total_req[0];
if (isset($start) && $start > 0) {
$listing = "Listing item {$start} to " . ($start + MAX_MSG_PP);
$limit = "limit {$start}," . MAX_MSG_PP;
} else {
$listing = "Listing item 1 to " . MAX_MSG_PP;
$limit = "limit 0," . MAX_MSG_PP;
$start = 0;
}
print $total . " RSS Items</p>";
if ($total) {