PHP sql_pre_query函数代码示例

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

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

示例1: varchar

"  \"GuestName\" varchar(150) NOT NULL default '',\n".
"  \"TimeStamp\" numeric(15) NOT NULL default '0',\n".
"  \"Post\" text NOT NULL,\n".
"  \"IP\" varchar(50) NOT NULL default ''
");", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."tagboard\" VALUES (1,-1,'".$iDB_Author."',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null)); 
sql_query($query,$SQLStat);
*/
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "themes\" (\n" . "  \"id\" SERIAL PRIMARY KEY NOT NULL,\n" . "  \"Name\" varchar(32) NOT NULL default '',\n" . "  \"ThemeName\" varchar(32) NOT NULL default '',\n" . "  \"ThemeMaker\" varchar(150) NOT NULL default '',\n" . "  \"ThemeVersion\" varchar(150) NOT NULL default '',\n" . "  \"ThemeVersionType\" varchar(150) NOT NULL default '',\n" . "  \"ThemeSubVersion\" varchar(150) NOT NULL default '',\n" . "  \"MakerURL\" varchar(150) NOT NULL default '',\n" . "  \"CopyRight\" varchar(150) NOT NULL default '',\n" . "  \"WrapperString\" text NOT NULL,\n" . "  \"CSS\" text NOT NULL,\n" . "  \"CSSType\" varchar(150) NOT NULL default '',\n" . "  \"FavIcon\" varchar(150) NOT NULL default '',\n" . "  \"TableStyle\" varchar(150) NOT NULL default '',\n" . "  \"MiniPageAltStyle\" varchar(150) NOT NULL default '',\n" . "  \"PreLogo\" varchar(150) NOT NULL default '',\n" . "  \"Logo\" varchar(150) NOT NULL default '',\n" . "  \"LogoStyle\" varchar(150) NOT NULL default '',\n" . "  \"SubLogo\" varchar(150) NOT NULL default '',\n" . "  \"TopicIcon\" varchar(150) NOT NULL default '',\n" . "  \"MovedTopicIcon\" varchar(150) NOT NULL default '',\n" . "  \"HotTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedHotTopic\" varchar(150) NOT NULL default '',\n" . "  \"PinTopic\" varchar(150) NOT NULL default '',\n" . "  \"AnnouncementTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedPinTopic\" varchar(150) NOT NULL default '',\n" . "  \"HotPinTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedHotPinTopic\" varchar(150) NOT NULL default '',\n" . "  \"ClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"HotClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedHotClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"PinClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedPinClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"HotPinClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"MovedHotPinClosedTopic\" varchar(150) NOT NULL default '',\n" . "  \"MessageRead\" varchar(150) NOT NULL default '',\n" . "  \"MessageUnread\" varchar(150) NOT NULL default '',\n" . "  \"Profile\" varchar(150) NOT NULL default '',\n" . "  \"WWW\" varchar(150) NOT NULL default '',\n" . "  \"PM\" varchar(150) NOT NULL default '',\n" . "  \"TopicLayout\" varchar(150) NOT NULL default '',\n" . "  \"AddReply\" varchar(150) NOT NULL default '',\n" . "  \"FastReply\" varchar(150) NOT NULL default '',\n" . "  \"NewTopic\" varchar(150) NOT NULL default '',\n" . "  \"QuoteReply\" varchar(150) NOT NULL default '',\n" . "  \"EditReply\" varchar(150) NOT NULL default '',\n" . "  \"DeleteReply\" varchar(150) NOT NULL default '',\n" . "  \"Report\" varchar(150) NOT NULL default '',\n" . "  \"LineDivider\" varchar(150) NOT NULL default '',\n" . "  \"ButtonDivider\" varchar(150) NOT NULL default '',\n" . "  \"LineDividerTopic\" varchar(150) NOT NULL default '',\n" . "  \"TitleDivider\" varchar(150) NOT NULL default '',\n" . "  \"ForumStyle\" varchar(150) NOT NULL default '',\n" . "  \"ForumIcon\" varchar(150) NOT NULL default '',\n" . "  \"SubForumIcon\" varchar(150) NOT NULL default '',\n" . "  \"RedirectIcon\" varchar(150) NOT NULL default '',\n" . "  \"TitleIcon\" varchar(150) NOT NULL default '',\n" . "  \"NavLinkIcon\" varchar(150) NOT NULL default '',\n" . "  \"NavLinkDivider\" varchar(150) NOT NULL default '',\n" . "  \"StatsIcon\" varchar(150) NOT NULL default '',\n" . "  \"NoAvatar\" varchar(150) NOT NULL default '',\n" . "  \"NoAvatarSize\" varchar(150) NOT NULL default '',\n" . "  UNIQUE (\"Name\")\n" . ");", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "topics\" (\n" . "  \"id\" SERIAL PRIMARY KEY NOT NULL,\n" . "  \"PollID\" numeric(15) NOT NULL default '0',\n" . "  \"ForumID\" numeric(15) NOT NULL default '0',\n" . "  \"CategoryID\" numeric(15) NOT NULL default '0',\n" . "  \"OldForumID\" numeric(15) NOT NULL default '0',\n" . "  \"OldCategoryID\" numeric(15) NOT NULL default '0',\n" . "  \"UserID\" numeric(15) NOT NULL default '0',\n" . "  \"GuestName\" varchar(150) NOT NULL default '',\n" . "  \"TimeStamp\" numeric(15) NOT NULL default '0',\n" . "  \"LastUpdate\" numeric(15) NOT NULL default '0',\n" . "  \"TopicName\" varchar(150) NOT NULL default '',\n" . "  \"Description\" text NOT NULL,\n" . "  \"NumReply\" numeric(15) NOT NULL default '0',\n" . "  \"NumViews\" numeric(15) NOT NULL default '0',\n" . "  \"Pinned\" numeric(5) NOT NULL default '0',\n" . "  \"Closed\" numeric(5) NOT NULL default '0'\n" . ");", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "topics\" (\"PollID\", \"ForumID\", \"CategoryID\", \"OldForumID\", \"OldCategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"TopicName\", \"Description\", \"NumReply\", \"NumViews\", \"Pinned\", \"Closed\") VALUES\n" . "(0, 1, 1, 1, 1, -1, '" . $iDB_Author . "', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate, $YourDate, $_POST['AdminUser']));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "wordfilter\" (\n" . "  \"id\" SERIAL PRIMARY KEY NOT NULL,\n" . "  \"FilterWord\" text NOT NULL,\n" . "  \"Replacement\" text NOT NULL,\n" . "  \"CaseInsensitive\" varchar(5) NOT NULL default '',\n" . "  \"WholeWord\" varchar(5) NOT NULL default ''\n" . ");", array(null));
sql_query($query, $SQLStat);
$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "topics", "wordfilter");
$TablePreFix = $_POST['tableprefix'];
function add_prefix($tarray)
{
    global $TablePreFix;
    return $TablePreFix . $tarray;
}
$TableChCk = array_map("add_prefix", $TableChCk);
$tcount = count($TableChCk);
$ti = 0;
while ($ti < $tcount) {
    $OptimizeTea = sql_query(sql_pre_query("VACUUM ANALYZE \"" . $TableChCk[$ti] . "\"", array(null)), $SQLStat);
    ++$ti;
}

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:pgsql.php

示例2: redirect

            $errorstr = $errorstr . "Your Group Name is too big.<br />\n";
        }
        if ($Error != "Yes") {
            redirect("refresh", $rbasedir . url_maker($exfile['admin'], $Settings['file_ext'], "act=view&menu=groups", $Settings['qstr'], $Settings['qsep'], $prexqstr['admin'], $exqstr['admin'], FALSE), "4");
            $admincptitle = " " . $ThemeSet['TitleDivider'] . " Updating Settings";
            if ($_POST['GroupName'] != $OldGroupName) {
                $query = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "permissions\" SET \"Name\"='%s' WHERE \"Name\"='%s'", array($_POST['GroupName'], $OldGroupName));
                sql_query($query, $SQLStat);
                $query = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "catpermissions\" SET \"Name\"='%s' WHERE \"Name\"='%s'", array($_POST['GroupName'], $OldGroupName));
                sql_query($query, $SQLStat);
            }
            if ($_POST['id'] != 1) {
                $query = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "groups\" SET \"Name\"='%s',\"NamePrefix\"='%s',\"NameSuffix\"='%s',\"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBags\"='%s',CanViewIPAddress='%s',CanViewUserAgent='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i,\"PromoteTo\"=%i,\"PromotePosts\"=%i,\"PromoteKarma\"=%i,\"HasModCP\"='%s',\"HasAdminCP\"='%s',\"ViewDBInfo\"='%s' WHERE \"id\"=%i", array($_POST['GroupName'], $_POST['NamePrefix'], $_POST['NameSuffix'], $_POST['CanViewBoard'], $_POST['CanViewOffLine'], $_POST['CanEditProfile'], $_POST['CanAddEvents'], $_POST['CanPM'], $_POST['CanSearch'], $_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['CanViewIPAddress'], $_POST['CanViewUserAgent'], $_POST['FloodControl'], $_POST['SearchFlood'], $_POST['PromoteTo'], $_POST['PromotePosts'], $_POST['PromoteKarma'], $_POST['HasModCP'], $_POST['HasAdminCP'], $_POST['ViewDBInfo'], $_POST['id']));
            }
            if ($_POST['id'] == 1) {
                $query = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "groups\" SET \"Name\"='%s',\"NamePrefix\"='%s',\"NameSuffix\"='%s',\"CanDoHTML\"='%s',\"CanUseBBags\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i WHERE \"id\"=%i", array($_POST['GroupName'], $_POST['NamePrefix'], $_POST['NameSuffix'], $_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['FloodControl'], $_POST['SearchFlood'], $_POST['id']));
            }
            sql_query($query, $SQLStat);
        }
    }
}
$doupdate = false;
if (isset($_POST['id']) && $_POST['subact'] == "editnow") {
    $doupdate = true;
}
if (isset($_POST['id']) && isset($_POST['permid']) && $_POST['subact'] == "makenow") {
    $doupdate = true;
}
if ($_POST['act'] == "addgroup" && $_POST['update'] == "now" && $_GET['act'] == "addgroup") {
    $doupdate = true;
}

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:groups.php

示例3: sql_session_gc

function sql_session_gc($maxlifetime)
{
    global $sqltable, $SQLStat;
    $time = GMTimeStamp() - $maxlifetime;
    //sql_query(sql_pre_query('DELETE FROM \"'.$sqltable.'sessions\" WHERE \"expires\" < UNIX_TIMESTAMP();', array(null)),$SQLStat);
    sql_query(sql_pre_query("DELETE FROM \"" . $sqltable . "sessions\" WHERE \"expires\" < %i", array($time)), $SQLStat);
    return true;
}

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:8，代码来源:sql.php

示例4: sql_pre_query

$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n" . "('sweat.png', 'Sweat', ':sweat:', 'smileys/', 'yes', 'yes');", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n" . "('tongue.png', 'Tongue', ':P', 'smileys/', 'yes', 'no');", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n" . "('wub.png', 'Wub', ':wub:', 'smileys/', 'yes', 'yes');", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n" . "('x.png', 'X', ':x:', 'smileys/', 'yes', 'yes');", array(null));
sql_query($query, $SQLStat);
/*
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."tagboard\" (\n".
"  \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
"  \"UserID\" INTEGER NOT NULL default '0',\n".
"  \"GuestName\" VARCHAR(150) NOT NULL default '',\n".
"  \"TimeStamp\" INTEGER NOT NULL default '0',\n".
"  \"Post\" TEXT NOT NULL,\n".
"  \"IP\" VARCHAR(50) NOT NULL default ''
");", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."tagboard\" VALUES (1,-1,'".$iDB_Author."',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null)); 
sql_query($query,$SQLStat);
*/
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "themes\" (\n" . "  \"id\" INTEGER PRIMARY KEY NOT NULL,\n" . "  \"Name\" VARCHAR(32) UNIQUE NOT NULL default '',\n" . "  \"ThemeName\" VARCHAR(150) NOT NULL default '',\n" . "  \"ThemeMaker\" VARCHAR(150) NOT NULL default '',\n" . "  \"ThemeVersion\" VARCHAR(150) NOT NULL default '',\n" . "  \"ThemeVersionType\" VARCHAR(150) NOT NULL default '',\n" . "  \"ThemeSubVersion\" VARCHAR(150) NOT NULL default '',\n" . "  \"MakerURL\" VARCHAR(150) NOT NULL default '',\n" . "  \"CopyRight\" VARCHAR(150) NOT NULL default '',\n" . "  \"WrapperString\" TEXT NOT NULL default '',\n" . "  \"CSS\" TEXT NOT NULL,\n" . "  \"CSSType\" VARCHAR(150) NOT NULL default '',\n" . "  \"FavIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"TableStyle\" VARCHAR(150) NOT NULL default '',\n" . "  \"MiniPageAltStyle\" VARCHAR(150) NOT NULL default '',\n" . "  \"PreLogo\" VARCHAR(150) NOT NULL default '',\n" . "  \"Logo\" VARCHAR(150) NOT NULL default '',\n" . "  \"LogoStyle\" VARCHAR(150) NOT NULL default '',\n" . "  \"SubLogo\" VARCHAR(150) NOT NULL default '',\n" . "  \"TopicIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedTopicIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"HotTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedHotTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"PinTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"AnnouncementTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedPinTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"HotPinTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedHotPinTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"ClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"HotClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedHotClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"PinClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"HotPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MovedHotPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"MessageRead\" VARCHAR(150) NOT NULL default '',\n" . "  \"MessageUnread\" VARCHAR(150) NOT NULL default '',\n" . "  \"Profile\" VARCHAR(150) NOT NULL default '',\n" . "  \"WWW\" VARCHAR(150) NOT NULL default '',\n" . "  \"PM\" VARCHAR(150) NOT NULL default '',\n" . "  \"TopicLayout\" VARCHAR(150) NOT NULL default '',\n" . "  \"AddReply\" VARCHAR(150) NOT NULL default '',\n" . "  \"FastReply\" VARCHAR(150) NOT NULL default '',\n" . "  \"NewTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"QuoteReply\" VARCHAR(150) NOT NULL default '',\n" . "  \"EditReply\" VARCHAR(150) NOT NULL default '',\n" . "  \"DeleteReply\" VARCHAR(150) NOT NULL default '',\n" . "  \"Report\" VARCHAR(150) NOT NULL default '',\n" . "  \"LineDivider\" VARCHAR(150) NOT NULL default '',\n" . "  \"ButtonDivider\" VARCHAR(150) NOT NULL default '',\n" . "  \"LineDividerTopic\" VARCHAR(150) NOT NULL default '',\n" . "  \"TitleDivider\" VARCHAR(150) NOT NULL default '',\n" . "  \"ForumStyle\" VARCHAR(150) NOT NULL default '',\n" . "  \"ForumIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"SubForumIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"RedirectIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"TitleIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"NavLinkIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"NavLinkDivider\" VARCHAR(150) NOT NULL default '',\n" . "  \"StatsIcon\" VARCHAR(150) NOT NULL default '',\n" . "  \"NoAvatar\" VARCHAR(150) NOT NULL default '',\n" . "  \"NoAvatarSize\" VARCHAR(150) NOT NULL default ''\n" . ");", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "topics\" (\n" . "  \"id\" INTEGER PRIMARY KEY NOT NULL,\n" . "  \"PollID\" INTEGER NOT NULL default '0',\n" . "  \"ForumID\" INTEGER NOT NULL default '0',\n" . "  \"CategoryID\" INTEGER NOT NULL default '0',\n" . "  \"OldForumID\" INTEGER NOT NULL default '0',\n" . "  \"OldCategoryID\" INTEGER NOT NULL default '0',\n" . "  \"UserID\" INTEGER NOT NULL default '0',\n" . "  \"GuestName\" VARCHAR(150) NOT NULL default '',\n" . "  \"TimeStamp\" INTEGER NOT NULL default '0',\n" . "  \"LastUpdate\" INTEGER NOT NULL default '0',\n" . "  \"TopicName\" VARCHAR(150) NOT NULL default '',\n" . "  \"Description\" TEXT NOT NULL,\n" . "  \"NumReply\" INTEGER NOT NULL default '0',\n" . "  \"NumViews\" INTEGER NOT NULL default '0',\n" . "  \"Pinned\" INTEGER NOT NULL default '0',\n" . "  \"Closed\" INTEGER NOT NULL default '0'\n" . ");", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "topics\" (\"PollID\", \"ForumID\", \"CategoryID\", \"OldForumID\", \"OldCategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"TopicName\", \"Description\", \"NumReply\", \"NumViews\", \"Pinned\", \"Closed\") VALUES\n" . "(0, 1, 1, 1, 1, -1, '" . $iDB_Author . "', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate, $YourDate, $_POST['AdminUser']));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE \"" . $_POST['tableprefix'] . "wordfilter\" (\n" . "  \"id\" INTEGER PRIMARY KEY NOT NULL,\n" . "  \"FilterWord\" TEXT NOT NULL,\n" . "  \"Replacement\" TEXT NOT NULL,\n" . "  \"CaseInsensitive\" VARCHAR(5) NOT NULL default '',\n" . "  \"WholeWord\" VARCHAR(5) NOT NULL default ''\n" . ");", array(null));
sql_query($query, $SQLStat);
$OptimizeTea = sql_query(sql_pre_query("VACUUM", array(null)), $SQLStat);

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:30，代码来源:sqlite.php

示例5: sprintf

     $NewestMem['Name'] = "Anonymous";
     $NewestMem['IP'] = "127.0.0.1";
 }
 $NewestMemTitle = null;
 $NewestMemExtraIP = null;
 if ($GroupInfo['CanViewIPAddress'] == "yes") {
     $NewestMemTitle = " title=\"" . $NewestMem['IP'] . "\"";
     $NewestMemExtraIP = " (<a title=\"" . $NewestMem['IP'] . "\" onclick=\"window.open(this.href);return false;\" href=\"" . sprintf($IPCheckURL, $NewestMem['IP']) . "\">" . $NewestMem['IP'] . "</a>)";
 }
 $bdMonthChCk = GMTimeGet("m", $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']);
 $bdDayChCk = GMTimeGet("d", $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']);
 if ($Settings['AdminValidate'] == "on") {
     $bdquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "members\" WHERE \"BirthDay\"=%i AND \"BirthMonth\"=%i AND \"HiddenMember\"='no' AND \"Validated\"='yes' AND \"GroupID\"<>%i ORDER BY \"id\"", array($bdDayChCk, $bdMonthChCk, $Settings['ValidateGroup']));
 }
 if ($Settings['AdminValidate'] != "on") {
     $bdquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "members\" WHERE \"BirthDay\"=%i AND \"BirthMonth\"=%i AND \"HiddenMember\"='no' ORDER BY \"id\"", array($bdDayChCk, $bdMonthChCk));
 }
 $bdresult = sql_query($bdquery, $SQLStat);
 $bdmembers = sql_num_rows($bdresult);
 $bdi = 0;
 if ($bdmembers > 0) {
     $bdstring = $bdmembers . " member(s) have a birthday today";
 }
 if ($bdmembers <= 0) {
     $bdstring = "<div>&nbsp;</div>&nbsp;No members have a birthday today<div>&nbsp;</div>";
 }
 while ($bdi < $bdmembers) {
     $bdmemberz = $bdmembers - 1;
     $birthday['ID'] = sql_result($bdresult, $bdi, "id");
     $birthday['Name'] = sql_result($bdresult, $bdi, "Name");
     $birthday['IP'] = sql_result($bdresult, $bdi, "IP");

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:stats.php

示例6: sql_result

 $ForumID = sql_result($result, $i, "id");
 $ForumName = sql_result($result, $i, "Name");
 $ForumShow = sql_result($result, $i, "ShowForum");
 $ForumType = sql_result($result, $i, "ForumType");
 $ForumShowTopics = sql_result($result, $i, "CanHaveTopics");
 $ForumShowTopics = strtolower($ForumShowTopics);
 $NumTopics = sql_result($result, $i, "NumTopics");
 $NumPosts = sql_result($result, $i, "NumPosts");
 $NumRedirects = sql_result($result, $i, "Redirects");
 $ForumDescription = sql_result($result, $i, "Description");
 $ForumType = strtolower($ForumType);
 $sflist = null;
 $gltf = array(null);
 $gltf[0] = $ForumID;
 if ($ForumType == "subforum") {
     $apcquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "forums\" WHERE \"ShowForum\"='yes' AND \"InSubForum\"=%i" . $ForumIgnoreList2 . " ORDER BY \"OrderID\" ASC, \"id\" ASC", array($ForumID));
     $apcresult = sql_query($apcquery, $SQLStat);
     $apcnum = sql_num_rows($apcresult);
     $apci = 0;
     $apcl = 1;
     if ($apcnum >= 1) {
         while ($apci < $apcnum) {
             $NumsTopics = sql_result($apcresult, $apci, "NumTopics");
             $NumTopics = $NumsTopics + $NumTopics;
             $NumsPosts = sql_result($apcresult, $apci, "NumPosts");
             $NumPosts = $NumsPosts + $NumPosts;
             $SubsForumID = sql_result($apcresult, $apci, "id");
             $SubsForumName = sql_result($apcresult, $apci, "Name");
             $SubsForumType = sql_result($apcresult, $apci, "ForumType");
             $SubsForumShowTopics = sql_result($result, $i, "CanHaveTopics");
             if (isset($PermissionInfo['CanViewForum'][$SubsForumID]) && $PermissionInfo['CanViewForum'][$SubsForumID] == "yes") {

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:lowcategories.php

示例7: sql_result

     $rei = 0;
     $ipshow = "two";
     $User1ID = $MyUserID;
     $GuestsName = $MyGuestName;
     $User1Name = sql_result($reresult, $rei, "Name");
     $User1IP = sql_result($reresult, $rei, "IP");
     if ($User1IP == $MyPostIP) {
         $ipshow = "one";
     }
     $User1Email = sql_result($reresult, $rei, "Email");
     $User1Title = sql_result($reresult, $rei, "Title");
     $User1Joined = sql_result($reresult, $rei, "Joined");
     $User1Joined = GMTimeChange($_SESSION['iDBDateFormat'], $User1Joined, $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']);
     $User1Hidden = sql_result($reresult, $rei, "HiddenMember");
     $User1GroupID = sql_result($reresult, $rei, "GroupID");
     $gquery = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "groups\" WHERE \"id\"=%i LIMIT 1", array($User1GroupID));
     $gresult = sql_query($gquery, $SQLStat);
     $User1Group = sql_result($gresult, 0, "Name");
     $GroupNamePrefix = sql_result($gresult, 0, "NamePrefix");
     $GroupNameSuffix = sql_result($gresult, 0, "NameSuffix");
     sql_free_result($gresult);
 }
 if ($User1CanUseBBags1 == "yes") {
     $MyPost = bbcode_parser($MyPost);
 }
 if ($User1CanExecPHP == "no") {
     $MyPost = preg_replace("/\\[ExecPHP\\](.*?)\\[\\/ExecPHP\\]/is", "<span style=\"color: red; font-weight: bold;\">ERROR:</span> cannot execute php code.", $MyPost);
 }
 if ($User1CanExecPHP == "yes") {
     $MyPost = php_execute($MyPost);
 }

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:lowreplies.php

示例8: sql_pre_query

            if ($_POST['id'] == 1) {
                $dmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemHidden'], $_POST['MemWarnLevel'], $_POST['MemBanTime'], $_POST['MemPostCount'], $_POST['MemKarma'], $_POST['id']));
                $dpmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "mempermissions\" SET \"CanDoHTML\"='%s',\"CanUseBBags\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i WHERE \"id\"=%i", array($_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['FloodControl'], $_POST['SearchFlood'], $_POST['id']));
            }
        }
        if ($_POST['MemName'] != $DMemName && $username_check < 1) {
            if ($_POST['id'] != 1) {
                if (!is_numeric($_POST['MemPermID'])) {
                    $_POST['MemPermID'] = "0";
                }
                $dmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"Name\"='%s',\"GroupID\"=%i,\"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemName'], $_POST['gid'], $_POST['MemHidden'], $_POST['MemWarnLevel'], $_POST['MemBanTime'], $_POST['MemPostCount'], $_POST['MemKarma'], $_POST['id']));
                $dpmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "mempermissions\" SET \"PermissionID\"=%i,\"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBags\"='%s',\"CanViewIPAddress\"='%s',\"CanViewUserAgent\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i,\"HasModCP\"='%s',\"HasAdminCP\"='%s',\"ViewDBInfo\"='%s' WHERE \"id\"=%i", array($_POST['MemPermID'], $_POST['CanViewBoard'], $_POST['CanViewOffLine'], $_POST['CanEditProfile'], $_POST['CanAddEvents'], $_POST['CanPM'], $_POST['CanSearch'], $_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['CanViewIPAddress'], $_POST['CanViewUserAgent'], $_POST['FloodControl'], $_POST['SearchFlood'], $_POST['HasModCP'], $_POST['HasAdminCP'], $_POST['ViewDBInfo'], $_POST['id']));
            }
            if ($_POST['id'] == 1) {
                $dmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "members\" SET \"Name\"='%s',\"HiddenMember\"='%s',\"WarnLevel\"=%i,\"BanTime\"=%i,\"PostCount\"=%i,\"Karma\"=%i WHERE \"id\"=%i", array($_POST['MemName'], $_POST['MemHidden'], $_POST['MemWarnLevel'], $_POST['MemBanTime'], $_POST['MemPostCount'], $_POST['MemKarma'], $_POST['id']));
                $dpmquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "mempermissions\" SET \"CanViewBoard\"='%s',\"CanViewOffLine\"='%s',\"CanEditProfile\"='%s',\"CanAddEvents\"='%s',\"CanPM\"='%s',\"CanSearch\"='%s',\"CanDoHTML\"='%s',\"CanUseBBags\"='%s',\"CanViewIPAddress\"='%s',\"CanViewUserAgent\"='%s',\"FloodControl\"=%i,\"SearchFlood\"=%i WHERE \"id\"=%i", array($_POST['CanViewBoard'], $_POST['CanViewOffLine'], $_POST['CanEditProfile'], $_POST['CanAddEvents'], $_POST['CanPM'], $_POST['CanSearch'], $_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['CanViewIPAddress'], $_POST['CanViewUserAgent'], $_POST['FloodControl'], $_POST['SearchFlood'], $_POST['id']));
            }
        }
        sql_query($dmquery, $SQLStat);
        sql_query($dpmquery, $SQLStat);
    }
    ?>
<div class="TableMenuBorder">
<?php 
    if ($ThemeSet['TableStyle'] == "div") {
        ?>
<div class="TableMenuRow1">
<?php 
        echo $ThemeSet['TitleIcon'];
        ?>
<a href="<?php

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:members.php

示例9: redirect

        if ($prenum == 0) {
            redirect("location", $rbasedir . url_maker($exfile['admin'], $Settings['file_ext'], "act=view", $Settings['qstr'], $Settings['qsep'], $prexqstr['admin'], $exqstr['admin'], false));
            sql_free_result($preresult);
            ob_clean();
            header("Content-Type: text/plain; charset=" . $Settings['charset']);
            $urlstatus = 302;
            gzip_page($Settings['use_gzip'], $GZipEncode['Type']);
            session_write_close();
            die;
        }
        if ($prenum >= 1) {
            $PermissionName = sql_result($preresult, 0, "Name");
            sql_free_result($preresult);
        }
        //$nextidnum = sql_get_next_id($Settings['sqltable'],"catpermissions",$SQLStat);
        $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "catpermissions\" (\"PermissionID\", \"Name\", \"CategoryID\", \"CanViewCategory\") VALUES\n" . "(%i, '%s', %i, '%s')", array($_POST['permid'], $PermissionName, $_POST['id'], $_POST['CanViewCategory']));
        sql_query($query, $SQLStat);
    }
}
$doupdate = false;
if (isset($_POST['id']) && $_POST['subact'] == "editnow") {
    $doupdate = true;
}
if (isset($_POST['id']) && isset($_POST['permid']) && $_POST['subact'] == "makenow") {
    $doupdate = true;
}
if ($_POST['act'] == "addcategory" && $_POST['update'] == "now" && $_GET['act'] == "addcategory") {
    $doupdate = true;
}
if ($_GET['act'] == "deletecategory" && $_POST['update'] == "now" && $_GET['act'] == "deletecategory") {
    $doupdate = true;

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:categories.php

示例10: setcookie

    }
    if ($cookieDomain != null) {
        if ($cookieSecure === true) {
            setcookie("MemberName", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
            setcookie("UserID", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
            setcookie("SessPass", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
            setcookie(session_name(), "", GMTimeStamp() - 3600, $cbasedir, $cookieDomain, 1);
        }
        if ($cookieSecure === false) {
            setcookie("MemberName", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
            setcookie("UserID", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
            setcookie("SessPass", null, GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
            setcookie(session_name(), "", GMTimeStamp() - 3600, $cbasedir, $cookieDomain);
        }
    }
    unset($_COOKIE[session_name()]);
    $_SESSION = array();
    //session_unset(); session_destroy();
    $temp_user_ip = $_SERVER['REMOTE_ADDR'];
    $exptime = GMTimeStamp() - ini_get("session.gc_maxlifetime");
    sql_query(sql_pre_query("DELETE FROM \"" . $Settings['sqltable'] . "sessions\" WHERE \"expires\" < %i OR ip_address='%s'", array($exptime, $temp_user_ip)), $SQLStat);
    redirect("location", $rbasedir . url_maker($exfile['member'], $Settings['file_ext'], "act=login", $Settings['qstr'], $Settings['qsep'], $prexqstr['member'], $exqstr['member'], false));
    sql_free_result($resultlog2);
    sql_free_result($gresult);
    ob_clean();
    header("Content-Type: text/plain; charset=" . $Settings['charset']);
    $urlstatus = 302;
    gzip_page($Settings['use_gzip'], $GZipEncode['Type']);
    session_write_close();
    die;
}

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:prelogin.php

示例11: closedir

             }
             if (file_exists($skindir . $file . "/info.php")) {
                 if ($file != "." && $file != "..") {
                     include $skindir . $file . "/info.php";
                     $themelist[$dirnum] = $file;
                     ++$dirnum;
                 }
             }
         }
         closedir($handle);
         asort($themelist);
         $themenum = count($themelist);
         $themei = 0;
         while ($themei < $themenum) {
             include $skindir . $themelist[$themei] . "/settings.php";
             $query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "themes\" (\"Name\", \"ThemeName\", \"ThemeMaker\", \"ThemeVersion\", \"ThemeVersionType\", \"ThemeSubVersion\", \"MakerURL\", \"CopyRight\", \"WrapperString\", \"CSS\", \"CSSType\", \"FavIcon\", \"TableStyle\", \"MiniPageAltStyle\", \"PreLogo\", \"Logo\", \"LogoStyle\", \"SubLogo\", \"TopicIcon\", \"MovedTopicIcon\", \"HotTopic\", \"MovedHotTopic\", \"PinTopic\", \"AnnouncementTopic\", \"MovedPinTopic\", \"HotPinTopic\", \"MovedHotPinTopic\", \"ClosedTopic\", \"MovedClosedTopic\", \"HotClosedTopic\", \"MovedHotClosedTopic\", \"PinClosedTopic\", \"MovedPinClosedTopic\", \"HotPinClosedTopic\", \"MovedHotPinClosedTopic\", \"MessageRead\", \"MessageUnread\", \"Profile\", \"WWW\", \"PM\", \"TopicLayout\", \"AddReply\", \"FastReply\", \"NewTopic\", \"QuoteReply\", \"EditReply\", \"DeleteReply\", \"Report\", \"LineDivider\", \"ButtonDivider\", \"LineDividerTopic\", \"TitleDivider\", \"ForumStyle\", \"ForumIcon\", \"SubForumIcon\", \"RedirectIcon\", \"TitleIcon\", \"NavLinkIcon\", \"NavLinkDivider\", \"StatsIcon\", \"NoAvatar\", \"NoAvatarSize\") VALUES\n" . "('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", array($themelist[$themei], $ThemeSet['ThemeName'], $ThemeSet['ThemeMaker'], $ThemeSet['ThemeVersion'], $ThemeSet['ThemeVersionType'], $ThemeSet['ThemeSubVersion'], $ThemeSet['MakerURL'], $ThemeSet['CopyRight'], $ThemeSet['WrapperString'], $ThemeSet['CSS'], $ThemeSet['CSSType'], $ThemeSet['FavIcon'], $ThemeSet['TableStyle'], $ThemeSet['MiniPageAltStyle'], $ThemeSet['PreLogo'], $ThemeSet['Logo'], $ThemeSet['LogoStyle'], $ThemeSet['SubLogo'], $ThemeSet['TopicIcon'], $ThemeSet['MovedTopicIcon'], $ThemeSet['HotTopic'], $ThemeSet['MovedHotTopic'], $ThemeSet['PinTopic'], $ThemeSet['AnnouncementTopic'], $ThemeSet['MovedPinTopic'], $ThemeSet['HotPinTopic'], $ThemeSet['MovedHotPinTopic'], $ThemeSet['ClosedTopic'], $ThemeSet['MovedClosedTopic'], $ThemeSet['HotClosedTopic'], $ThemeSet['MovedHotClosedTopic'], $ThemeSet['PinClosedTopic'], $ThemeSet['MovedPinClosedTopic'], $ThemeSet['HotPinClosedTopic'], $ThemeSet['MovedHotPinClosedTopic'], $ThemeSet['MessageRead'], $ThemeSet['MessageUnread'], $ThemeSet['Profile'], $ThemeSet['WWW'], $ThemeSet['PM'], $ThemeSet['TopicLayout'], $ThemeSet['AddReply'], $ThemeSet['FastReply'], $ThemeSet['NewTopic'], $ThemeSet['QuoteReply'], $ThemeSet['EditReply'], $ThemeSet['DeleteReply'], $ThemeSet['Report'], $ThemeSet['LineDivider'], $ThemeSet['ButtonDivider'], $ThemeSet['LineDividerTopic'], $ThemeSet['TitleDivider'], $ThemeSet['ForumStyle'], $ThemeSet['ForumIcon'], $ThemeSet['SubForumIcon'], $ThemeSet['RedirectIcon'], $ThemeSet['TitleIcon'], $ThemeSet['NavLinkIcon'], $ThemeSet['NavLinkDivider'], $ThemeSet['StatsIcon'], $ThemeSet['NoAvatar'], $ThemeSet['NoAvatarSize']));
             sql_query($query, $SQLStat);
             ++$themei;
         }
     }
     sql_disconnect_db($SQLStat);
     $ThemeSet = $OldThemeSet;
 }
 $CHMOD = $_SERVER['PHP_SELF'];
 $iDBRDate = $SVNDay[0] . "/" . $SVNDay[1] . "/" . $SVNDay[2];
 $iDBRSVN = $VER2[2] . " " . $SubVerN;
 $LastUpdateS = "Last Update: " . $iDBRDate . " " . $iDBRSVN;
 $pretext = "<?php\n/*\n    This program is free software; you can redistribute it and/or modify\n    it under the terms of the GNU General Public License as published by\n    the Free Software Foundation; either version 2 of the License, or\n    (at your option) any later version.\n\n    This program is distributed in the hope that it will be useful,\n    but WITHOUT ANY WARRANTY; without even the implied warranty of\n    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the\n    Revised BSD License for more details.\n\nCopyright 2004-" . $SVNDay[2] . " Game Maker 2k - http://gamemaker2k.org/\n    Copyright 2004-" . $SVNDay[2] . " Game Maker 2k - http://gamemaker2k.org/\n    iDB Installer made by Game Maker 2k - http://idb.berlios.net/\n\n    \$FileInfo: settings.php & settingsbak.php - " . $LastUpdateS . " - Author: cooldude2k \$\n*/\n";
 $pretext2 = array("/*   Board Setting Section Begins   */\n\$Settings = array();", "/*   Board Setting Section Ends  \n     Board Info Section Begins   */\n\$SettInfo = array();", "/*   Board Setting Section Ends   \n     Board Dir Section Begins   */\n\$SettDir = array();", "/*   Board Dir Section Ends   */");
 $settcheck = "\$File3Name = basename(\$_SERVER['SCRIPT_NAME']);\nif (\$File3Name==\"" . $_POST['tableprefix'] . "settings.php\"||\$File3Name==\"/" . $_POST['tableprefix'] . "settings.php\") {\n    header('Location: index.php');\n    exit(); }\n";
 $BoardSettings = $pretext2[0] . "\n" . "require('settings.php');\n" . "\$Settings['sqltable'] = '" . $_POST['tableprefix'] . "';\n" . "\$Settings['board_name'] = '" . $_POST['NewBoardName'] . "';\n" . "\$Settings['weburl'] = '" . $_POST['WebURL'] . "';\n" . "\$Settings['SQLThemes'] = '" . $_POST['SQLThemes'] . "';\n" . "\$Settings['GuestGroup'] = 'Guest';\n" . "\$Settings['MemberGroup'] = 'Member';\n" . "\$Settings['ValidateGroup'] = 'Validate';\n" . "\$Settings['AdminValidate'] = 'off';\n" . "\$Settings['TestReferer'] = '" . $_POST['TestReferer'] . "';\n" . "\$Settings['DefaultTheme'] = '" . $_POST['DefaultTheme'] . "';\n" . "\$Settings['DefaultTimeZone'] = '" . $AdminTime . "';\n" . "\$Settings['DefaultDST'] = '" . $AdminDST . "';\n" . "\$Settings['start_date'] = " . $YourDate . ";\n" . "\$Settings['idb_time_format'] = '" . $Settings['idb_time_format'] . "';\n" . "\$Settings['idb_date_format'] = '" . $Settings['idb_date_format'] . "';\n" . "\$Settings['use_hashtype'] = '" . $_POST['usehashtype'] . "';\n" . "\$Settings['max_posts'] = '10';\n" . "\$Settings['max_topics'] = '10';\n" . "\$Settings['max_memlist'] = '10';\n" . "\$Settings['max_pmlist'] = '10';\n" . "\$Settings['hot_topic_num'] = '15';\n" . "\$Settings['enable_rss'] = 'on';\n" . "\$Settings['enable_search'] = 'on';\n" . "\$Settings['board_offline'] = 'off';\n" . "\$Settings['VerCheckURL'] = '';\n" . "\$Settings['IPCheckURL'] = '';\n" . "\$Settings['log_http_request'] = '" . $_POST['iDBHTTPLogger'] . "';\n" . "\$Settings['log_config_format'] = '" . $_POST['iDBLoggerFormat'] . "';\n" . "\$Settings['BoardUUID'] = '" . base64_encode($ServerUUID) . "';\n" . "\$Settings['KarmaBoostDays'] = '" . $KarmaBoostDay . "';\n" . "\$Settings['KBoostPercent'] = '6|10';\n" . $pretext2[1] . "\n" . "\$SettInfo['board_name'] = '" . $_POST['NewBoardName'] . "';\n" . "\$SettInfo['Author'] = '" . $_POST['AdminUser'] . "';\n" . "\$SettInfo['Keywords'] = '" . $_POST['NewBoardName'] . "," . $_POST['AdminUser'] . "';\n" . "\$SettInfo['Description'] = '" . $_POST['NewBoardName'] . "," . $_POST['AdminUser'] . "';\n?>";

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:mkconfig.php

示例12: sql_pre_query

    echo $TopicForumID;
    ?>
" class="TableRow2">
<td class="TableColumn2" colspan="2" style="width: 100%;">Making a Reply in Topic <?php 
    echo $TopicName;
    ?>
</td>
</tr>
<tr class="TableRow3" id="MkReply<?php 
    echo $TopicForumID;
    ?>
">
<td class="TableColumn3" style="width: 15%; vertical-align: middle; text-align: center;">
<div style="width: 100%; height: 160px; overflow: auto;">
<table style="width: 100%; text-align: center;"><?php 
    $renee_query = sql_pre_query("SELECT * FROM \"" . $Settings['sqltable'] . "smileys\" WHERE \"Display\"='yes'", array(null));
    $renee_result = sql_query($renee_query, $SQLStat);
    $renee_num = sql_num_rows($renee_result);
    $renee_s = 0;
    $SmileRow = 0;
    $SmileCRow = 0;
    while ($renee_s < $renee_num) {
        ++$SmileRow;
        $FileName = sql_result($renee_result, $renee_s, "FileName");
        $SmileName = sql_result($renee_result, $renee_s, "SmileName");
        $SmileText = sql_result($renee_result, $renee_s, "SmileText");
        $SmileDirectory = sql_result($renee_result, $renee_s, "Directory");
        $ShowSmile = sql_result($renee_result, $renee_s, "Display");
        $ReplaceType = sql_result($renee_result, $renee_s, "ReplaceCI");
        if ($SmileRow == 1) {
            ?>

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:replies.php

示例13: int

"  \"TimeStamp\" int(15) NOT NULL default '0',\n".
"  \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
"  \"IP\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
"  PRIMARY KEY  (\"id\")\n".
") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."tagboard\" VALUES (1,-1,'".$iDB_Author."',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null)); 
sql_query($query,$SQLStat);
*/
$query = sql_pre_query("CREATE TABLE IF NOT EXISTS \"" . $_POST['tableprefix'] . "themes\" (\n" . "  \"id\" int(15) NOT NULL auto_increment,\n" . "  \"Name\" varchar(32) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ThemeName\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ThemeMaker\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ThemeVersion\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ThemeVersionType\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ThemeSubVersion\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MakerURL\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"CopyRight\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"WrapperString\" text COLLATE " . $Settings['sql_collate'] . " NOT NULL,\n" . "  \"CSS\" text COLLATE " . $Settings['sql_collate'] . " NOT NULL,\n" . "  \"CSSType\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"FavIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TableStyle\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MiniPageAltStyle\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"PreLogo\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"Logo\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"LogoStyle\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"SubLogo\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TopicIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedTopicIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"HotTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedHotTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"PinTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"AnnouncementTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedPinTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"HotPinTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedHotPinTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"HotClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedHotClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"PinClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedPinClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"HotPinClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MovedHotPinClosedTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MessageRead\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"MessageUnread\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"Profile\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"WWW\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"PM\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TopicLayout\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"AddReply\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"FastReply\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"NewTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"QuoteReply\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"EditReply\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"DeleteReply\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"Report\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"LineDivider\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ButtonDivider\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"LineDividerTopic\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TitleDivider\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ForumStyle\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"ForumIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"SubForumIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"RedirectIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TitleIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"NavLinkIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"NavLinkDivider\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"StatsIcon\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"NoAvatar\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"NoAvatarSize\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  PRIMARY KEY  (\"id\"),\n" . "  UNIQUE KEY \"Name\" (\"Name\")\n" . ") ENGINE=" . $SQLStorageEngine . "  DEFAULT CHARSET=" . $Settings['sql_charset'] . " COLLATE=" . $Settings['sql_collate'] . ";", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE IF NOT EXISTS \"" . $_POST['tableprefix'] . "topics\" (\n" . "  \"id\" int(15) NOT NULL auto_increment,\n" . "  \"PollID\" int(15) NOT NULL default '0',\n" . "  \"ForumID\" int(15) NOT NULL default '0',\n" . "  \"CategoryID\" int(15) NOT NULL default '0',\n" . "  \"OldForumID\" int(15) NOT NULL default '0',\n" . "  \"OldCategoryID\" int(15) NOT NULL default '0',\n" . "  \"UserID\" int(15) NOT NULL default '0',\n" . "  \"GuestName\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"TimeStamp\" int(15) NOT NULL default '0',\n" . "  \"LastUpdate\" int(15) NOT NULL default '0',\n" . "  \"TopicName\" varchar(150) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"Description\" text COLLATE " . $Settings['sql_collate'] . " NOT NULL,\n" . "  \"NumReply\" int(15) NOT NULL default '0',\n" . "  \"NumViews\" int(15) NOT NULL default '0',\n" . "  \"Pinned\" int(5) NOT NULL default '0',\n" . "  \"Closed\" int(5) NOT NULL default '0',\n" . "  PRIMARY KEY  (\"id\")\n" . ") ENGINE=" . $SQLStorageEngine . "  DEFAULT CHARSET=" . $Settings['sql_charset'] . " COLLATE=" . $Settings['sql_collate'] . ";", array(null));
sql_query($query, $SQLStat);
$query = sql_pre_query("INSERT INTO \"" . $_POST['tableprefix'] . "topics\" (\"PollID\", \"ForumID\", \"CategoryID\", \"OldForumID\", \"OldCategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"TopicName\", \"Description\", \"NumReply\", \"NumViews\", \"Pinned\", \"Closed\") VALUES\n" . "(0, 1, 1, 1, 1, -1, '" . $iDB_Author . "', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate, $YourDate, $_POST['AdminUser']));
sql_query($query, $SQLStat);
$query = sql_pre_query("CREATE TABLE IF NOT EXISTS \"" . $_POST['tableprefix'] . "wordfilter\" (\n" . "  \"id\" int(15) NOT NULL auto_increment,\n" . "  \"FilterWord\" text COLLATE " . $Settings['sql_collate'] . " NOT NULL,\n" . "  \"Replacement\" text COLLATE " . $Settings['sql_collate'] . " NOT NULL,\n" . "  \"CaseInsensitive\" varchar(5) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  \"WholeWord\" varchar(5) COLLATE " . $Settings['sql_collate'] . " NOT NULL default '',\n" . "  PRIMARY KEY  (\"id\")\n" . ") ENGINE=" . $SQLStorageEngine . "  DEFAULT CHARSET=" . $Settings['sql_charset'] . " COLLATE=" . $Settings['sql_collate'] . ";", array(null));
sql_query($query, $SQLStat);
$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "members", "mempermissions", "messenger", "permissions", "posts", "polls", "restrictedwords", "sessions", "smileys", "topics", "wordfilter");
$TablePreFix = $_POST['tableprefix'];
function add_prefix($tarray)
{
    global $TablePreFix;
    return $TablePreFix . $tarray;
}
$TableChCk = array_map("add_prefix", $TableChCk);
$tcount = count($TableChCk);
$ti = 0;
while ($ti < $tcount) {
    $OptimizeTea = sql_query(sql_pre_query("OPTIMIZE TABLE \"" . $TableChCk[$ti] . "\"", array(null)), $SQLStat);
    ++$ti;
}

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:mysql.php

示例14: redirect

            redirect("location", $rbasedir . url_maker($exfile['admin'], $Settings['file_ext'], "act=view", $Settings['qstr'], $Settings['qsep'], $prexqstr['admin'], $exqstr['admin'], false));
            sql_free_result($preresult);
            ob_clean();
            header("Content-Type: text/plain; charset=" . $Settings['charset']);
            $urlstatus = 302;
            gzip_page($Settings['use_gzip'], $GZipEncode['Type']);
            session_write_close();
            die;
        }
        if ($prenum >= 1) {
            $PermissionName = sql_result($preresult, 0, "Name");
            sql_free_result($preresult);
        }
        //$nextidnum = sql_get_next_id($Settings['sqltable'],"permissions",$SQLStat);
        $nextidnum = null;
        $query = sql_pre_query("INSERT INTO \"" . $Settings['sqltable'] . "permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBags\", \"CanModForum\") VALUES\n" . "(%i, '%s', %i, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 'no', '%s', '%s', '%s')", array($_POST['permid'], $PermissionName, $_POST['id'], $_POST['CanViewForum'], $_POST['CanMakePolls'], $_POST['CanMakeTopics'], $_POST['CanMakeReplys'], $_POST['CanMakeReplysCT'], $_POST['CanEditTopics'], $_POST['CanEditTopicsCT'], $_POST['CanEditReplys'], $_POST['CanEditReplysCT'], $_POST['CanDeleteTopics'], $_POST['CanDeleteTopicsCT'], $_POST['CanDeleteReplys'], $_POST['CanDeleteReplysCT'], $_POST['CanCloseTopics'], $_POST['CanPinTopics'], $_POST['CanDoHTML'], $_POST['CanUseBBags'], $_POST['CanModForum']));
        sql_query($query, $SQLStat);
    }
}
$doupdate = false;
if (isset($_POST['id']) && $_POST['subact'] == "editnow") {
    $doupdate = true;
}
if (isset($_POST['id']) && isset($_POST['permid']) && $_POST['subact'] == "makenow") {
    $doupdate = true;
}
if ($_POST['act'] == "addforum" && $_POST['update'] == "now" && $_GET['act'] == "addforum") {
    $doupdate = true;
}
if ($_GET['act'] == "deleteforum" && $_POST['update'] == "now" && $_GET['act'] == "deleteforum") {
    $doupdate = true;

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:forums.php

示例15: array_map

</tr>
</table>
</div>
<?php 
}
if ($_POST['act'] == "info" && $_POST['update'] == "now" && $_GET['act'] == "info" && $_SESSION['UserGroup'] != $Settings['GuestGroup'] && $GroupInfo['HasAdminCP'] == "yes") {
    $_POST = array_map("rsq", $_POST);
    if (!isset($Settings['BoardUUID']) || $Settings['BoardUUID'] === null) {
        $Settings['BoardUUID'] = rand_uuid("rand");
    }
    $_POST['board_name'] = htmlspecialchars($_POST['board_name'], ENT_QUOTES, $Settings['charset']);
    $_POST['board_name'] = fixbamps($_POST['board_name']);
    $_POST['board_name'] = remove_spaces($_POST['board_name']);
    $_POST['board_name'] = str_replace("\\&#039;", "&#039;", $_POST['board_name']);
    if ($_POST['board_name'] != $Settings['board_name'] && $Settings['SQLThemes'] == "on") {
        $logoquery = sql_pre_query("UPDATE \"" . $Settings['sqltable'] . "themes\" SET \"Logo\"='%s' WHERE \"Logo\"='%s'", array($_POST['board_name'], $Settings['board_name']));
        sql_query($logo, $SQLStat);
    }
    $_POST['Author'] = htmlspecialchars($_POST['Author'], ENT_QUOTES, $Settings['charset']);
    $_POST['Author'] = fixbamps($_POST['Author']);
    $_POST['Author'] = remove_spaces($_POST['Author']);
    $_POST['Author'] = str_replace("\\&#039;", "&#039;", $_POST['Author']);
    $_POST['Keywords'] = htmlspecialchars($_POST['Keywords'], ENT_QUOTES, $Settings['charset']);
    $_POST['Keywords'] = fixbamps($_POST['Keywords']);
    $_POST['Keywords'] = remove_spaces($_POST['Keywords']);
    $_POST['Keywords'] = str_replace("\\&#039;", "&#039;", $_POST['Keywords']);
    $_POST['Description'] = htmlspecialchars($_POST['Description'], ENT_QUOTES, $Settings['charset']);
    $_POST['Description'] = fixbamps($_POST['Description']);
    $_POST['Description'] = remove_spaces($_POST['Description']);
    $_POST['Description'] = str_replace("\\&#039;", "&#039;", $_POST['Description']);
    $BoardSettings = $pretext2[0] . "\nrequire('settings.php');\n" . "\$Settings['sqltable'] = " . null_string($Settings['sqltable']) . ";\n" . "\$Settings['board_name'] = " . null_string($_POST['board_name']) . ";\n" . "\$Settings['weburl'] = " . null_string($Settings['weburl']) . ";\n" . "\$Settings['SQLThemes'] = " . null_string($Settings['SQLThemes']) . ";\n" . "\$Settings['GuestGroup'] = " . null_string($Settings['GuestGroup']) . ";\n" . "\$Settings['MemberGroup'] = " . null_string($Settings['MemberGroup']) . ";\n" . "\$Settings['ValidateGroup'] = " . null_string($Settings['ValidateGroup']) . ";\n" . "\$Settings['AdminValidate'] = " . null_string($Settings['AdminValidate']) . ";\n" . "\$Settings['TestReferer'] = " . null_string($Settings['TestReferer']) . ";\n" . "\$Settings['DefaultTheme'] = " . null_string($Settings['DefaultTheme']) . ";\n" . "\$Settings['DefaultTimeZone'] = " . null_string($Settings['DefaultTimeZone']) . ";\n" . "\$Settings['DefaultDST'] = " . null_string($Settings['DefaultDST']) . ";\n" . "\$Settings['start_date'] = " . null_string($Settings['start_date']) . ";\n" . "\$Settings['idb_time_format'] = " . null_string($Settings['idb_time_format']) . ";\n" . "\$Settings['idb_date_format'] = " . null_string($Settings['idb_date_format']) . ";\n" . "\$Settings['use_hashtype'] = " . null_string($Settings['use_hashtype']) . ";\n" . "\$Settings['max_posts'] = " . null_string($Settings['max_posts']) . ";\n" . "\$Settings['max_topics'] = " . null_string($Settings['max_topics']) . ";\n" . "\$Settings['max_memlist'] = " . null_string($Settings['max_memlist']) . ";\n" . "\$Settings['max_pmlist'] = " . null_string($Settings['max_pmlist']) . ";\n" . "\$Settings['hot_topic_num'] = " . null_string($Settings['hot_topic_num']) . ";\n" . "\$Settings['enable_rss'] = " . null_string($Settings['enable_rss']) . ";\n" . "\$Settings['enable_search'] = " . null_string($Settings['enable_search']) . ";\n" . "\$Settings['board_offline'] = " . null_string($Settings['board_offline']) . ";\n" . "\$Settings['VerCheckURL'] = " . null_string($Settings['VerCheckURL']) . ";\n" . "\$Settings['IPCheckURL'] = " . null_string($Settings['IPCheckURL']) . ";\n" . "\$Settings['log_http_request'] = " . null_string($Settings['log_http_request']) . ";\n" . "\$Settings['log_config_format'] = " . null_string($Settings['log_config_format']) . ";\n" . "\$Settings['BoardUUID'] = " . null_string(base64_encode($Settings['BoardUUID'])) . ";\n" . "\$Settings['KarmaBoostDays'] = " . null_string($Settings['KarmaBoostDays']) . ";\n" . "\$Settings['KBoostPercent'] = " . null_string($Settings['KBoostPercent']) . ";\n" . $pretext2[1] . "\n" . "\$SettInfo['board_name'] = " . null_string($_POST['board_name']) . ";\n" . "\$SettInfo['Author'] = " . null_string($_POST['Author']) . ";\n" . "\$SettInfo['Keywords'] = " . null_string($_POST['Keywords']) . ";\n" . "\$SettInfo['Description'] = " . null_string($_POST['Description']) . ";\n?>";

开发者ID:BackupTheBerlios，项目名称:idb，代码行数:31，代码来源:main.php

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