分类目录归档:PHP

PHP技术相关

PHP按字符串长度分割成数组,支持中文

支持中文字符串,值得分享学习


/**
 * 将unicode字符串按传入长度分割成数组
 * @param  string  $str 传入字符串
 * @param  integer $l   字符串长度
 * @return mixed      数组或false
 */
 function str_split_unicode($str, $l = 0) {
    if ($l > 0) {
        $ret = array();
        $len = mb_strlen($str, "UTF-8");
        for ($i = 0; $i < $len; $i += $l) {
            $ret[] = mb_substr($str, $i, $l, "UTF-8");
        }
        return $ret;
    }
    return preg_split("//u", $str, -1, PREG_SPLIT_NO_EMPTY);
 }

 


<?php
 function str_split_unicode($str, $l = 0) {
     if ($l > 0) {
         $ret = array();
         $len = mb_strlen($str, "UTF-8");
         for ($i = 0; $i < $len; $i += $l) {
             $ret[] = mb_substr($str, $i, $l, "UTF-8");
         }
         return $ret;
     }
     return preg_split("//u", $str, -1, PREG_SPLIT_NO_EMPTY);
 }
 ?>
 $s = "还未如愿sss见gfg者不rtret不朽"; // Mild milk
 print_r(str_split($s, 5));
 print_r(str_split_unicode($s, 5));

 //输出
 //Array ( [0] => 还�� [1] => �如� [2] => ��sss [3] => 见gf [4] => g者� [5] => ��rtr [6] => et不 [7] => 朽 )
 //Array ( [0] => 还未如愿s [1] => ss见gf [2] => g者不rt [3] => ret不朽 )

PHP过滤各种HTML标签

PHP过滤各种HTML标签的表达式,值得收藏


$str=preg_replace("/<\s*img\s+[^>]*?src\s*=\s*(\'|\")(.*?)\\1[^>]*?\/?\s*>/i", " ", $str); //过滤img标签

$str=preg_replace("/\s+/", " ", $str); //过滤多余回车

$str=preg_replace("/<[ ]+/si","<",$str); //过滤<__("<"号后面带空格)

$str=preg_replace("/<\!--.*?-->/si","",$str); //注释

$str=preg_replace("/<(\!.*?)>/si","",$str); //过滤DOCTYPE

$str=preg_replace("/<(\/?html.*?)>/si","",$str); //过滤html标签

$str=preg_replace("/<(\/?head.*?)>/si","",$str); //过滤head标签

$str=preg_replace("/<(\/?meta.*?)>/si","",$str); //过滤meta标签

$str=preg_replace("/<(\/?body.*?)>/si","",$str); //过滤body标签

$str=preg_replace("/<(\/?link.*?)>/si","",$str); //过滤link标签

$str=preg_replace("/<(\/?form.*?)>/si","",$str); //过滤form标签

$str=preg_replace("/cookie/si","COOKIE",$str); //过滤COOKIE标签

$str=preg_replace("/<(applet.*?)>(.*?)<(\/applet.*?)>/si","",$str); //过滤applet标签

$str=preg_replace("/<(\/?applet.*?)>/si","",$str); //过滤applet标签

$str=preg_replace("/<(style.*?)>(.*?)<(\/style.*?)>/si","",$str); //过滤style标签

$str=preg_replace("/<(\/?style.*?)>/si","",$str); //过滤style标签

$str=preg_replace("/<(title.*?)>(.*?)<(\/title.*?)>/si","",$str); //过滤title标签

$str=preg_replace("/<(\/?title.*?)>/si","",$str); //过滤title标签

$str=preg_replace("/<(object.*?)>(.*?)<(\/object.*?)>/si","",$str); //过滤object标签

$str=preg_replace("/<(\/?objec.*?)>/si","",$str); //过滤object标签

$str=preg_replace("/<(noframes.*?)>(.*?)<(\/noframes.*?)>/si","",$str); //过滤noframes标签

$str=preg_replace("/<(\/?noframes.*?)>/si","",$str); //过滤noframes标签

$str=preg_replace("/<(i?frame.*?)>(.*?)<(\/i?frame.*?)>/si","",$str); //过滤frame标签

$str=preg_replace("/<(\/?i?frame.*?)>/si","",$str); //过滤frame标签

$str=preg_replace("/<(script.*?)>(.*?)<(\/script.*?)>/si","",$str); //过滤script标签

$str=preg_replace("/<(\/?script.*?)>/si","",$str); //过滤script标签

$str=preg_replace("/javascript/si","Javascript",$str); //过滤script标签

$str=preg_replace("/vbscript/si","Vbscript",$str); //过滤script标签

$str=preg_replace("/on([a-z]+)\s*=/si","On\\1=",$str); //过滤script标签

$str=preg_replace("/&#/si","&#",$str); //过滤script标签

如果仅仅是过滤一整篇篇html文档,
比如说head这样的整篇文档中所有的html标签,则可以用 php的 strip_tags()函数来脱掉所有的html或php标签。

需要注意的是:strip_tags()函数是不怎么验证标签的完整性的,也就说如果缺少一个或者其他的标签,则很有可能导致有更多的内容被脱掉。

PHP获取照片exif信息

在这个没图说个屁的年代,照片还是很重要的。如果照片上传后会自动加上 照片相关信息,那用户体验的确会好很多,本着这个想法,今天尝试了下 PHP获取照片exif信息,重要的是 获取图片的GPS信息,如果再加上 google maps API 的话,就可以轻松得到位置信息 继续阅读

Ucenter整合网站同步登陆

这几天一直在弄 Ucenter 同步登陆的问题,才仔细发现,其实同步登陆就是远程执行了 js脚本。。。

string uc_user_synlogout()
string uc_user_synlogin(integer uid)

返回的类型都是字符串,所以返回的字符串一定要在 网页中输出 才可同步。最好网页在进行延时。 继续阅读

把时间显示为”刚刚””N分钟前””N小时前”等

在很多场合为了显示出信息的及时性,一般会将时间显示成“刚刚”,“5分钟前”,“3小时前”等,而不是直接将时间打印出来。比如微博,SNS类应用就最长用到这个功能。而一般存储在数据库中的时间格式为 Unix时间戳,所以这里记录一个将 Unix时间戳 转化为时间轴显示的PHP函数。 继续阅读

WordPress半角引号变全角较完美解决办法

替换引号

为了安全考虑,wordpress会将一些字符如引号替换成别的字符 。这一功能不影响一般博客,可对于需要贴代码类的博客来讲,这属于致命伤。试想那么多单引号双引号都被替换成中文字符 ,因字体差异很小,访客不明白,直接将代码复制粘贴使用,程序报错自然是在所难免的了。而就阅读效果,该用左右引号却变成一大一小,这样也是非常难看的。 继续阅读

PHP安装APC加速缓存扩展

用PHP有一段时间了,学习Linux也有一段时间了,前段时间用了yaf扩展框架,就使用php扩展,不过对于这个框架没有深入研究。不过觉得装个APC缓存扩展应该不错。今天就在VPS上面装了一下试试

下载地址在 :http://pecl.php.net/package/apc

建议下载使用 stable的,现在最新的稳定版是 3.1.9

#wget http://pecl.php.net/get/APC-3.1.9.tgz

#tar -zxvf APC-3.1.9.tgz

# cd APC-3.1.9/

#/usr/local/php/bin/phpize             //这里是php安装目录下bin下面的phpize
#./configure –enable-apc –enable-mmap –enable-apc-spinlocks –disable-apc-pthreadmutex –with-php-config=/usr/local/php/bin/php-config
#make && make install

然后在 php.ini文件里面加入 extension=apc.so 就ok了。。。具体配置可以百度搜一下

DiscuzX2.5数据库字典 值得学习

pre_common_admincp_cmenu – 后台菜单收藏表
title => ‘菜单名称’
url => ‘菜单地址’
sort => ‘0’ COMMENT ‘菜单类型,备用’
displayorder => ‘显示顺序’
clicks => ‘1’ COMMENT ‘点击数,备用’
uid => ‘添加用户’
dateline => ‘添加时间’

pre_common_admingroup – 管理组表

admingid => ‘所属管理员分组ID’
alloweditpost => ‘是否允许编辑帖子’
alloweditpoll => ‘是否允许编辑投票’
allowstickthread => ‘是否允许置顶主题’
allowmodpost => ‘是否允许审核帖子’
allowdelpost => ‘是否允许删除帖子’
allowmassprune => ‘是否允许批量删帖’
allowrefund => ‘是否允许强制退款’
allowcensorword => ‘兼容性字段’
allowviewip => ‘是否允许查看IP’
allowbanip => ‘是否允许禁止IP’
allowedituser => ‘是否允许编辑用户’
allowmoduser => ‘是否允许审核用户’
allowbanuser => ‘是否允许禁止用户发言’
allowbanvisituser => ‘是否允许禁止用户访问’
allowpostannounce => ‘是否允许发布站点公告’
allowviewlog => ‘是否允许查看管理日志’
allowbanpost => ‘是否允许屏蔽帖子’
supe_allowpushthread => ‘兼容性字段’
allowhighlightthread => ‘是否允许高亮主题’
allowdigestthread => ‘是否允许精华主题’
allowrecommendthread => ‘是否允许推荐主题’
allowbumpthread => ‘是否允许提升主题’
allowclosethread => ‘是否允许关闭主题’
allowmovethread => ‘是否允许移动主题’
allowedittypethread => ‘是否允许编辑主题分类’
allowstampthread => ‘是否允许添加主题图章’
allowstamplist => ‘是否允许添加主题图标’
allowcopythread => ‘是否允许复制主题’
allowmergethread => ‘是否允许合并主题’
allowsplitthread => ‘是否允许分割主题’
allowrepairthread => ‘是否允许修复主题’
allowwarnpost => ‘是否允许警告帖子’
allowviewreport => ‘是否允许查看用户报告’
alloweditforum => ‘是否允许编辑版块’
allowremovereward => ‘是否允许移除悬赏’
allowedittrade => ‘是否允许编辑商品’
alloweditactivity => ‘是否允许管理活动报名者’
allowstickreply => ‘是否允许置顶回帖’
allowmanagearticle => ‘是否允许管理所有文章’
allowaddtopic => ‘是否允许创建专题’
allowmanagetopic => ‘是否允许管理专题’
allowdiy => ‘是否允许DIY’
allowclearrecycle => ‘是否允许删除回收站的帖子’
allowmanagetag => ‘是否允许管理标签’
alloweditusertag => ‘是否允许管理用户标签’
managefeed => ‘是否允许管理动态(feed)’
managedoing => ‘是否允许管理记录’
manageshare => ‘是否允许管理分享’
manageblog => ‘是否允许管理日志’
managealbum => ‘是否允许管理相册’
managecomment => ‘是否允许管理评论’
managemagiclog => ‘是否允许管理道具记录’
managereport => ‘是否允许管理举报’
managehotuser => ‘是否允许管理推荐成员’
managedefaultuser => ‘是否允许管理推荐好友’
managevideophoto => ‘是否允许管理视频认证’
managemagic => ‘是否允许管理道具’
manageclick => ‘是否允许管理表态动作’
allowmanagecollection => ‘是否允许管理淘专辑’

pre_common_adminnote – 后台留言表
id => ‘后台留言id’
admin => ‘管理员姓名’
access => ‘哪组可以看到信息’
adminid => ‘管理员id’
dateline => ‘发表时间’
expiration => ‘过期时间’
message => ‘消息’

pre_common_advertisement – 广告数据表
advid => ‘广告id’
available => ‘是否启用’
type => ‘0’ COMMENT ‘类型’
displayorder => ‘显示顺序’
title => ‘广告标题’
targets => ‘投放范围’
parameters text NOT NULL COMMENT ‘参数序列化存放的数组数据’, code => ‘代码’
starttime => ‘开始时间’
endtime => ‘结束时间’

pre_common_advertisement_custom – 自定义广告数据表
id => ‘自定义广告类型id’
name => ‘名称’

pre_common_banned – 禁止访问表
id => ‘禁止id’
ip1 => ‘IP分段1’
ip2 => ‘IP分段2’
ip3 => ‘IP分段3’
ip4 => ‘IP分段4’
admin => ‘管理员姓名’
dateline => ‘禁止时间’
expiration => ‘过期时间’

pre_common_cache – 通用缓存表
cachekey => ‘缓存名称’
cachevalue => ‘缓存数据’
dateline => ‘缓存时间’

pre_common_card – 充值卡密表
id => ‘生成的卡片号码’
typeid => ‘卡片分类’
maketype => ‘卡片生成的方法’
makeruid => ‘卡片生成者uid’
price => ‘0’ COMMENT ‘卡片面值’
extcreditskey => ‘0’ COMMENT ‘充值积分种类’
extcreditsval => ‘0’ COMMENT ‘积分数额’
status => ‘1’ COMMENT ‘卡片状态(位与):1:可用,2:已用’
dateline => ‘卡片生成时间’
cleardateline => ‘卡片清理时间’
useddateline => ‘使用时间’
uid => ‘使用者’

pre_common_card_log – 充值卡密表
id => ‘生成的卡片号码’
uid => ‘0’ COMMENT ‘卡片生成者’
username => ‘卡片生成者’
cardrule => ‘卡片生成规则’
info => ‘卡片生成log’
dateline => ‘本次log生成时间’
description => ‘卡片描述’
operation => ‘操作动作(位与):1:生成,2:任务生成,4:删除,9:卡片过期’

pre_common_card_type – 卡片分类表
id => ‘卡片分类ID’
typename => ‘分类名称’

pre_common_credit_log – 积分日志表
uid => ‘所属用户uid’
operation => ‘操作类型’
relatedid => ‘操作相关ID’
dateline => ‘记录时间’
extcredits1 => ‘积分1变化值’
extcredits2 => ‘积分2变化值’
extcredits3 => ‘积分3变化值’
extcredits4 => ‘积分4变化值’
extcredits5 => ‘积分5变化值’
extcredits6 => ‘积分6变化值’
extcredits7 => ‘积分7变化值’
extcredits8 => ‘积分8变化值’

pre_common_credit_rule_log – 积分规则日志表
clid => ‘策略日志ID’
uid => ‘策略日志所有者uid’
rid => ‘策略ID’
fid => ‘版块ID’
total => ‘策略被执行总次数’
cyclenum => ‘周期被执行次数’
extcredits1 => ‘扩展1’
extcredits2 => ‘扩展2’
extcredits3 => ‘扩展3’
extcredits4 => ‘扩展4’
extcredits5 => ‘扩展5’
extcredits6 => ‘扩展6’
extcredits7 => ‘扩展7’
extcredits8 => ‘扩展8’
starttime => ‘周期开始时间’
dateline => ‘策略最后执行时间’

pre_common_credit_rule_log_field – 积分规则日志扩展表
clid => ‘策略日志ID’
uid => ‘策略日志所有者uid’
info => ‘记录信息防重’
user => ‘记录用户防重’
app => ‘记录应用防重’

pre_common_credit_rule – 积分规则表
rid => ‘规则ID’
rulename => ‘规则名称’
action => ‘规则action唯一KEY’
cycletype => ‘奖励周期0:一次;1:每天;2:整点;3:间隔分钟;4:不限;’
cycletime => ‘间隔时间’
rewardnum => ‘奖励次数’
norepeat => ‘是否去重1:去重;0:不去重’
extcredits1 => ‘扩展1’
extcredits2 => ‘扩展2’
extcredits3 => ‘扩展3’
extcredits4 => ‘扩展4’
extcredits5 => ‘扩展5’
extcredits6 => ‘扩展6’
extcredits7 => ‘扩展7’
extcredits8 => ‘扩展8’
fids => ‘记录自定义策略版块ID’

pre_common_cron – 计划任务表
cronid => ‘计划任务id’
available => ‘是否启用’
type => ‘类型’
name => ‘名称’
filename => ‘对应文件’
lastrun => ‘上次执行时间’
nextrun => ‘下次执行时间’
weekday => ‘周计划’
day => ‘0’ COMMENT ‘日计划’
hour => ‘0’ COMMENT ‘小时计划’
minute => ‘分计划’

pre_common_domain – 二级域名表
domain => ‘域名前缀’
domainroot => ‘二级域名后缀’
id => ‘对应对象id’
idtype => ‘对应对象类型subarea:分区、forum:版块、home:个人空间、group:群组、topic:专题、channel:频道’

pre_common_failedlogin – 失败登录表
ip => ‘失败IP’
username => ‘失败时的用户名’
count => ‘尝试次数’
lastupdate => ‘最后一次尝试时间’

pre_common_friendlink – 友情链接表
id => ‘id’
displayorder => ‘显示顺序,正序’
name => ‘名称’
url => ‘url’
description => ‘解释说明’
logo => ‘logo’
type => ‘0’

pre_common_relatedlink – 关联链接表
id => ‘id’
name => ‘名称’
url => ‘url’
extent => ‘0’

pre_common_invite – 邀请表
id => ‘ID’
uid => ‘邀请人’
code => ‘邀请码’
fuid => ‘受邀人UID’
fusername => ‘受邀人姓名’
type => ‘0’ COMMENT ‘邮件邀请 1是0否’
email => ‘邀请Email’
inviteip => ‘邀请IP’
appid => ‘应用ID’
dateline => ‘邀请码生成时间’
endtime => ‘邀请码结束时间’
regdateline => ‘注册时间’
status => ‘1’ COMMENT ‘邀请码状态’
orderid => ‘购买邀请码的订单号id’

pre_common_mailcron – 邮件计划任务表
touid => ‘对象UID’
email => ‘对象email地址’
sendtime => ‘发送时间’

pre_common_mailqueue – 邮件队列表
`subject` => ‘邮件标题’
message => ‘邮件内容’
dateline => ‘添加时间’

pre_common_member – 用户主表
uid => ‘会员id’
email => ‘邮箱’
username => ‘用户名’
password => ‘密码’
status => ‘0’ COMMENT ‘判断用户是否已经删除 需要discuz程序加判断,并增加整体清理的功能。原home字段为flag’
emailstatus => ’email是否经过验证 home字段为emailcheck’
avatarstatus => ‘是否有头像 home字段为avatar’
videophotostatus => ‘视频认证状态 home’
adminid => ‘管理员id’
groupid => ‘会员组id’
groupexpiry => ‘用户组有效期’
extgroupids => ‘扩展用户组’
regdate => ‘注册时间’
credits => ‘总积分’
notifysound => ‘短信声音’
timeoffset => ‘时区校正’
newpm => ‘新短消息数量’
newprompt => ‘新提醒数目’
accessmasks => ‘标志’
allowadmincp => ‘标志’
onlyacceptfriendpm => ‘是否只接收好友短消息’
conisbind => ‘用户是否绑定QC’

pre_common_member_count – 用户统计表
uid => ‘会员id’
extcredits1 => ‘声望’
extcredits2 => ‘金钱’
extcredits3 => ‘扩展’
extcredits4 => ‘扩展’
extcredits5 => ‘扩展’
extcredits6 => ‘扩展’
extcredits7 => ‘扩展’
extcredits8 => ‘扩展’
friends => ‘好友个数 home’
posts => ‘帖子数’
threads => ‘主题数’
digestposts => ‘精华数’
doings => ‘记录数’
blogs => ‘日志数’
albums => ‘相册数’
sharings => ‘分享数’
attachsize => ‘上传附件占用的空间 home’
views => ‘空间查看数’
oltime => ‘在线时间’
todayattachs => ‘当天上传附件数’
todayattachsize => ‘当天上传附件容量’
feeds => ‘广播数’
follower => ‘听众数量’
following => ‘收听数量’
newfollower => ‘新增听众数量’

pre_common_member_field_forum – 用户论坛字段表
uid => ‘会员id’
publishfeed => ‘用户自定义发送哪些类型的feed(原字段为customaddfeed)’
customshow => ‘自定义帖子显示模式’
customstatus => ‘自定义头衔’
medals => ‘勋章信息’
sightml => ‘签名’
groupterms => ‘公共用户组’
authstr => ‘找回密码验证串’
groups => ‘用户所有群组’
attentiongroup => ‘用户偏好’

pre_common_member_field_home – 用户家园字段表
uid => ‘会员id’
videophoto => ‘视频认证照片地址 home’
spacename => ‘空间名称’
spacedescription => ‘空间简介’
domain => ‘空间绑定二级域名 home’
addsize => ‘额外授予的上传空间 home’
addfriend => ‘额外允许增加的好友数 home’
menunum => ‘应用显示个数’
theme => ‘空间风格主题 home’
spacecss => ‘个人空间自定义css home’
blockposition => ‘个人空间自定义模块位置及相关参数 home’
recentnote => ‘最近一次行为记录’
spacenote => ‘最近一次twitter’
privacy => ‘home隐私设置(注意要和论坛发feed等开关的设置结合)’
feedfriend => ‘接受feed的好友缓存’
acceptemail => ‘接受新通知邮件及设置邮件接收参数’
magicgift => ‘道具红包卡相关信息’
stickblogs => ‘置顶的日志ID’

pre_common_member_profile – 用户栏目表
uid => ‘会员id’
realname => ‘实名’
gender => ‘性别(0:保密 1:男 2:女)’
birthyear => ‘出生年’
birthmonth => ‘出生月’
birthday => ‘出生日’
constellation => ‘星座(根据生日自动计算)’
zodiac => ‘生肖(根据生日自动计算)’
telephone => ‘固定电话’
mobile => ‘手机’
idcardtype => ‘证件类型:身份证 护照 军官证等’
idcard => ‘证件号码’
address => ‘邮寄地址’
zipcode => ‘邮编’
nationality => ‘国籍’
birthprovince => ‘出生省份’
birthcity => ‘出生城市’
birthdist => ‘出生行政区/县’
birthcommunity => ‘出生小区’
resideprovince => ‘居住省份’
residecity => ‘居住城市’
residedist => ‘居住行政区/县’
residecommunity => ‘居住小区’
residesuite => ‘小区、写字楼门牌号’
graduateschool => ‘毕业学校’
company => ‘ 公司’
education => ‘ 学历’
occupation => ‘ 职业’
position => ‘职位’
revenue => ‘ 年收入’
affectivestatus => ‘ 情感状态’
lookingfor => ‘ 交友目的(交友类型)’
bloodtype => ‘血型’
height => ‘ 身高’
weight => ‘ 体重’
alipay => ‘支付宝帐号’
icq => ‘ICQ’
qq => ‘QQ’
yahoo => ‘YAHOO’
msn => ‘MSN’
taobao => ‘阿里旺旺’
site => ‘主页’
bio => ‘自我介绍 来自论坛bio字段’
interest => ‘兴趣爱好’
field1 => ‘自定义字段1’
field2 => ‘自定义字段2’
field3 => ‘自定义字段3’
field4 => ‘自定义字段4’
field5 => ‘自定义字段5’
field6 => ‘自定义字段6’
field7 => ‘自定义字段7’
field8 => ‘自定义字段8’

pre_common_member_status – 用户状态表
uid => ‘会员id’
regip => ‘注册IP’
lastip => ‘最后登录IP’
lastvisit => ‘最后访问’
lastactivity => ‘最后活动’
lastpost => ‘最后发表’
lastsendmail => ‘上次发送email时间 home原字段为lastsend’
invisible => ‘是否隐身登录’
buyercredit => ‘买家信用等级及积分’
sellercredit => ‘卖家信用等级及积分’
favtimes => ‘个人空间收藏次数’
sharetimes => ‘个人空间分享次数’
profileprogress => ‘个人资料完成度’

pre_common_member_stat_field – 用户资料统计项
optionid => ‘资料统计项 id’
fieldid => ‘资料项字段标志符’
fieldvalue => ‘资料值’
hash => ‘由fieldid和fieldvalue生成的hash’
users => ‘对应用户数’
updatetime => ‘更新时间’

pre_common_member_action_log – 用户操作日志表
id => ‘记录id’
uid => ‘用户ID’
action => ‘0’ COMMENT ‘操作代码’
dateline int(10) unsigned NOT NULL default ‘0’,

pre_home_follow – 用户关注关系表
uid => ‘用户ID’
username => ‘用户名’
followuid => ‘被关注用户ID’
fusername => ‘被关注用户名称’
bkname => ‘用户备注’
status => ‘0’ COMMENT ‘0:正常 1:特殊关注 -1:不能再关注此人’
mutual => ‘0:单向 1:已互相关注’
dateline int(10) unsigned NOT NULL default ‘0’,

pre_home_follow_feed – 被关注者事件表
feedid => ‘自增id’
uid => ‘被关注者ID’
username => ‘被关注用户名’
tid => ‘帖子tid’
note => ‘转发理由’
dateline int(10) unsigned NOT NULL default ‘0’,

pre_home_follow_feed_archiver – 被关注者事件存档
feedid => ‘自增id’
uid => ‘被关注者ID’
username => ‘被关注用户名’
tid => ‘帖子tid’
note => ‘转发理由’
dateline int(10) unsigned NOT NULL default ‘0’,

pre_common_member_log – 漫游用户日志表
uid => ‘记录UID’
action => ‘记录动作’
dateline => ‘添加时间’

pre_common_member_verify – 用户认证表
uid => ‘会员id’
verify1 => ‘认证1: -1:被拒绝 0:待审核 1:审核通过’
verify2 => ‘认证2: -1:被拒绝 0:待审核 1:审核通过’
verify3 => ‘认证3: -1:被拒绝 0:待审核 1:审核通过’
verify4 => ‘认证4: -1:被拒绝 0:待审核 1:审核通过’
verify5 => ‘认证5: -1:被拒绝 0:待审核 1:审核通过’
verify6 => ‘实名认证: -1:被拒绝 0:待审核 1:审核通过’
verify7 => ‘视频认证: -1:被拒绝 0:待审核 1:审核通过’

pre_common_member_verify_info – 个人信息修改审核
vid => ‘审核id’
uid => ‘会员id’
username => ‘用户名’
verifytype => ‘审核类型0:资料审核, 1:认证1, 2:认证2, 3:认证3, 4:认证4, 5:认证5’
flag => ‘-1:被拒绝 0:待审核 1:审核通过’
field => ‘序列化存储变化值’
dateline => ‘提交日期’

pre_common_member_profile_setting – 个人信息扩展表
fieldid => ‘profile字段标志符’
available => ‘是否可用’
invisible => ‘是否隐藏’
needverify => ‘是否需要审核’
title => ‘栏目标题’
description => ‘解释说明’
displayorder => ‘显示顺序’
required => ‘是否必填内容’
unchangeable => ‘不可修改’
showincard => ‘在名片中显示’
showinthread => ‘在帖子中显示’
showinregister => ‘是否在注册页面显示’
allowsearch => ‘是否可搜索’
formtype => ‘表单元素类型’
size => ‘内容最大长度’
choices => ‘选填内容’
validate => ‘验证数据的正则表达式’

pre_common_member_security – 个人信息修改审核
securityid => ‘审核项id’
uid => ‘会员id’
username => ‘用户名’
fieldid => ‘profile字段标志符’
oldvalue => ‘旧的profile字段值’
newvalue => ‘新的profile字段值’
dateline => ‘提交日期’

pre_common_member_validate – 用户审核表
uid => ‘会员id’
submitdate => ‘提交日期’
moddate => ‘审核日期’
admin => ‘管理员名’
submittimes => ‘提交的次数’
status => ‘0’ COMMENT ‘状态’
message => ‘注册原因’
remark => ‘管理员留言’

pre_common_member_crime – 用户惩罚操作表
cid => ‘自增id’
uid => ‘被惩罚操作的用户id’
operatorid => ‘进行惩罚操作的用户id’
operator => ‘进行惩罚操作的用户名’
action => ‘惩罚行为’
reason => ‘惩罚理由’
dateline => ‘惩罚操作时间’

pre_common_member_grouppm – 群发短消息用户记录表
uid => ‘会员id’
gpmid => ‘消息id’
status => ‘0=未读 1=已读 -1=删除’
dateline => ‘阅读时间’

pre_common_grouppm – 群发短消息表
id => ‘消息id’
authorid => ‘作者id’
author => ‘作者姓名’
dateline => ‘时间’
message => ‘消息’
numbers => ‘数量’

pre_common_myapp – 漫游应用表
appid => ‘应用id’
appname => ‘应用名称’
narrow => ‘是否显示为窄的profile box’
flag => ‘应用状态(黑白名单、默认应用等)’
version => ‘应用版本号’
userpanelarea => ‘userabout显示区域、1主区、2、副区、3应用区’
canvastitle => ‘canvas页面标题’
fullscreen => ‘是否是全屏应用’
displayuserpanel => ‘是否显示应用右侧的用户菜单’
displaymethod => ‘显示方式(iframe/myml)’
displayorder => ‘显示顺序’
appstatus => ‘标识应用1:新、2:热’
iconstatus => ‘应用图标是否已下载到本地。-1:失败;0:未下载;1:已下载’
icondowntime => ‘应用图标下载到本地时间’

pre_common_myinvite – 用户邀请表
id => ‘邀请id’
typename => ‘邀请名称’
appid => ‘应用id’
type => ‘0’ COMMENT ‘类型(request 邀请/invite 请求)’
fromuid => ‘邀请者id’
touid => ‘接收者id’
myml => ‘邀请内容’
dateline => ‘发送邀请的时间戳’
hash => ‘0’ COMMENT ‘hash标记’

pre_common_nav – 自定义导航栏表
id => ‘项目id’
parentid => ‘父 id(navtype=0)’
name => ‘导航名称’
title => ‘导航说明’
url => ‘导航链接’
identifier => ‘链接标识/相关ID’
target => ‘目标框架(0:本窗口 1:新窗口)’
type => ‘0’ COMMENT ‘类型 0 系统 1 自定义 3 插件 4 频道’
available => ‘是否可用’
displayorder => ‘显示顺序’
highlight => ‘样式(navtype=0)’
`level` => ‘使用等级(0:游客 1:会员 2:版主 3:管理员)’
subtype => ‘0’ COMMENT ‘二级导航样式(navtype=0) 顶部导航位置(navtype=4)’
subcols => ‘0’ COMMENT ‘横排一行显示的条目数(navtype=0)’
icon => ‘图标地址(navtype=1、3)’
subname => ‘副导航名称(navtype=1)’
suburl => ‘副导航地址(navtype=1)’
navtype =>’导航类型(0:主导航 1:底部导航 2:家园导航 3:快捷导航 4:顶部导航)’
logo => ‘自定义 Logo’

pre_common_onlinetime – 在线时间表
uid => ‘UID’
thismonth => ‘本月在线时间’
total => ‘总在线时间’
lastupdate => ‘最后活动时间’

pre_common_regip – 注册IP限制表
ip => ‘IP地址’
dateline => ‘限制时间’
count => ‘限制数量’

pre_common_secquestion – 验证问题数据表
id => ‘验证问题id’
type => ‘验证问题类型’
question => ‘验证问题’
answer => ‘问题答案’

pre_common_session – 站点在线活动表
sid => ‘sid’
ip1 => ‘IP段’
ip2 => ‘IP段’
ip3 => ‘IP段’
ip4 => ‘IP段’
uid => ‘会员id’
username => ‘会员名’
groupid => ‘会员组’
invisible => ‘是否隐身登录’
action => ‘0’ COMMENT ‘当前动作’
lastactivity => ‘最后活动时间’
lastolupdate => ‘在线时间最后更新’
fid => ‘论坛id’
tid => ‘主题id’

pre_common_setting – 设置表
skey => ‘变量名’
svalue => ‘值’

pre_common_smiley – 表情表
id => ‘表情id’
typeid => ‘表情分类 id’
displayorder => ‘显示顺序’
type => ‘类型’
code => ‘标记’
url => ‘路径’

pre_common_stat – 趋势统计
daytime => ‘时间’
login => ‘登陆’
mobilelogin => ‘手机登陆’
connectlogin => ‘QQConnect登陆’
register => ‘注册’
invite => ‘邀请’
appinvite => ‘应用邀请’
doing => ‘记录’
blog => ‘日志’
pic => ‘图片’
poll => ‘投票’
activity => ‘活动’
share => ‘0’ COMMENT ‘分享’
thread => ‘主题’
docomment => ‘记录评论’
blogcomment => ‘日志评论’
piccomment => ‘图片评论’
sharecomment => ‘分享评论’
reward => ‘悬赏’
debate => ‘辩论’
trade => ‘商品’
group => ‘0’ COMMENT ‘群组’
groupjoin => ‘参与群组’
groupthread => ‘群组主题’
grouppost => ‘群组回复’
post => ‘主题回复’
wall => ‘留言’
poke => ‘打招呼’
click => ‘表态’
sendpm => ‘发送PM’
friend => ‘成为好友’
addfriend => ‘好友请求’

pre_common_statuser – 统计用户表
uid => ‘UID’
daytime => ‘时间’
type => ‘各种用户行为如:invite、register、login…’

pre_common_style – 风格表
styleid => ‘风格id’
name => ‘风格名称’
available => ‘风格是否可用’
templateid => ‘对应模板id’
extstyle => ‘配色’

pre_common_stylevar – 风格变量表
stylevarid => ‘风格变量id’
styleid => ‘风格id’
variable => ‘变量名’
substitute => ‘变量赋值’

pre_common_syscache – 缓存数据表
cname => ‘缓存名称’
ctype => ‘缓存类型 0=value, serialize=1’
dateline => ‘缓存生成时间’
data => ‘缓存数据’

pre_common_template – 模板表
templateid => ‘模板id’
name => ‘名称’
directory => ‘目录’
copyright => ‘版权’

pre_common_usergroup – 用户组表
groupid => ‘会员组id’
radminid => ‘关联关管理组’
type => ‘类型’
system => ‘会员是否可以自由进出’
grouptitle => ‘组头衔’
creditshigher => ‘该组的积分上限’
creditslower => ‘该组的积分下限’
stars => ‘星星数量’
color => ‘组头衔颜色’
icon varchar(255) NOT NULL default , allowvisit => ‘允许访问’
allowsendpm => ‘是否允许发送短信息’
allowinvite => ‘允许使用邀请注册’
allowmailinvite => ‘允许通过论坛邮件系统发送邀请码’
maxinvitenum => ‘最大邀请码拥有数量’
inviteprice => ‘邀请码购买价格’
maxinviteday => ‘邀请码有效期’

pre_common_usergroup_field – 会员用户组权限表
groupid => ‘会员组id’
readaccess => ‘阅读权限’
allowpost => ‘允许发帖’
allowreply => ‘允许回复’
allowpostpoll => ‘允许发表投票’
allowpostreward => ‘允许发表悬赏’
allowposttrade => ‘允许发表交易’
allowpostactivity => ‘允许发表活动’
allowdirectpost => ‘是否需要审核’
allowgetattach => ‘允许下载附件’
allowgetimage => ‘允许查看图片’
allowpostattach => ‘允许上传附件’
allowpostimage => ‘允许上传图片’
allowvote => ‘允许参与投票’
allowsearch => ‘允许搜索’
allowcstatus => ‘允许自定义头衔’
allowinvisible => ‘允许隐身登录’
allowtransfer => ‘允许积分转帐’
allowsetreadperm => ‘允许设置阅读权限’
allowsetattachperm => ‘允许设置附件权限’
allowposttag => ‘允许使用标签’
allowhidecode => ‘允许使用hide代码’
allowhtml => ‘允许使用html’
allowanonymous => ‘允许匿名发帖’
allowsigbbcode => ‘允许签名使用bbcode’
allowsigimgcode => ‘允许使用img’
allowmagics => ‘允许使用道具’
disableperiodctrl => ‘不受时间段限制’
reasonpm => ‘操作理由短信通知作者’
maxprice => ‘主题最大售价’
maxsigsize => ‘最大签名尺寸’
maxattachsize => ‘最大附件尺寸’
maxsizeperday => ‘每天最大附件总尺寸’
maxthreadsperhour => ‘每小时发主题数限制’
maxpostsperhour => ‘每小时发回帖数限制’
attachextensions => ‘允许发表的附件类型’
raterange => ‘评分范围’
mintradeprice => ‘交易最小积分’
maxtradeprice => ‘交易最大积分’
minrewardprice => ‘悬赏最小积分’
maxrewardprice => ‘悬赏最大积分’
magicsdiscount => ‘道具折扣’
maxmagicsweight => ‘道具负载最大值’
allowpostdebate => ‘允许发表辩论’
tradestick => ‘可商品推荐数’
exempt => ‘用户组表达式’
maxattachnum => ‘最大每天附件数量’
allowposturl => ‘是否允许发送含 url 内容’
allowrecommend => ‘是否允许评价主题’
allowpostrushreply => ‘允许发表抢楼帖’
maxfriendnum => ‘最多好友数’
maxspacesize => ‘空间大小’
allowcomment => ‘发表留言/评论’
allowcommentarticle => ‘发表文章的评论’
searchinterval => ‘两次搜索操作间隔’
searchignore => ‘是否免费搜索’
allowblog => ‘发表日志’
allowdoing => ‘发表记录’
allowupload => ‘上传图片’
allowshare => ‘发布分享’
allowblogmod => ‘发表日志需要审核’
allowdoingmod => ‘发表记录需要审核’
allowuploadmod => ‘上传图片需要审核’
allowsharemod => ‘发布分享需要审核’
allowcss => ‘允许自定义CSS’
allowpoke => ‘允许打招呼’
allowfriend => ‘允许加好友’
allowclick => ‘允许表态’
allowmagic => ‘允许使用道具’
allowstat => ‘允许查看趋势统计’
allowstatdata => ‘允许查看统计数据报表’
videophotoignore => ‘视频认证限制’
allowviewvideophoto => ‘允许查看视频认证’
allowmyop => ‘允许使用应用’
magicdiscount => ‘购买道具折扣’
domainlength => ‘二级域名最短长度’
seccode => ‘发布操作需填验证码’
disablepostctrl => ‘发表是否受防灌水限制’
allowbuildgroup => ‘是否允许建立群组,0为不允许’
allowgroupdirectpost => ‘是否允许直接在群组中发帖’
allowgroupposturl => ‘是否允许在群组中发站外URL’
edittimelimit => ‘编辑帖子时间限制’
allowpostarticle => ‘允许发布文章’
allowdownlocalimg => ‘允许下载本地图片’
allowdownremoteimg => ‘允许下载远程图片’
allowpostarticlemod => ‘发布文章是否需要审核’
allowspacediyhtml => ‘允许自定义模块使用HTML’
allowspacediybbcode => ‘允许自定义模块使用BBCODE’
allowspacediyimgcode => ‘允许自定义模块使用[img]’
allowcommentpost => ‘允许帖子点评 0:禁止 1:楼主 2:回复 3:All’
allowcommentitem => ‘允许发表点评观点’
allowcommentreply => ‘允许发表回复点评’
allowreplycredit => ‘允许设置回帖奖励’
ignorecensor => ‘是否忽略要审核的关键字’
allowsendallpm => ‘是否不受“只接收好友短消息”设置的限制’
allowsendpmmaxnum => ’24小时内允许发短消息的数量’
maximagesize => ‘相册中允许最大图片大小’
allowmediacode => ‘允许使用多媒体代码’
allowat => ‘允许@用户 0:禁止 n:发帖时@的数量’
allowsetpublishdate => ‘允许定时发布主题’
allowfollowcollection => ‘允许关注淘专辑数’
allowcommentcollection => ‘允许评论淘专辑’
allowcreatecollection => ‘允许创建淘专辑数’

pre_common_word – 词语过滤表
id => ‘词汇id’
admin => ‘管理员名’
type => ‘关键词分类’
find => ‘不良词语’
replacement => ‘替换内容’

pre_common_word_type – 词语过滤分类
id => ‘词语过滤分类id’
typename => ‘分类名称’

pre_common_tag – 标签表
tagid => ‘标签id’
tagname => ‘标签名’
status => ‘显示状态(0:正常 1:关闭 2:推荐 3:用户标签)’

pre_common_tagitem – 标签内容表
tagid => ‘标签id’
itemid => ‘itemid’
idtype => ‘内容类型’

pre_forum_access – 访问权限表
uid => ‘会员id’
fid => ‘论坛id’
allowview => ‘允许浏览’
allowpost => ‘允许发表’
allowreply => ‘允许回复’
allowgetattach => ‘允许下载附件’
allowgetimage => ‘允许查看图片’
allowpostattach => ‘允许上传附件’
allowpostimage => ‘允许上传图片’
adminuser => ‘管理员id’
dateline => ‘时间’

pre_forum_activity – 活动表
tid => ‘主题id’
uid => ‘会员id’
aid => ‘主题图片id’
cost => ‘每人花销’
starttimefrom => ‘开始时间’
starttimeto => ‘结束时间’
place => ‘地点’
class => ‘类别’
gender => ‘性别’
number => ‘人数’
applynumber => ‘已参加人数’
expiration => ‘报名截止日期’
ufield => ‘用户定制项目’
credit => ‘需消耗的积分’

pre_forum_activityapply – 活动申请表
applyid => ‘申请id’
tid => ‘主题id’
username => ‘用户名’
uid => ‘会员id’
message => ‘消息’
verified => ‘是否审核通过(0:N 1:Y 2:需完善资料)’
dateline => ‘申请时间’
payment => ‘每人花销’
ufielddata => ‘用户定制项目数据’

pre_forum_announcement – 公告表
id => ‘公告id’
author => ‘作者姓名’
subject => ‘公告标题’
type => ‘公告类型(0:文字公告 1:网址链接)’,
displayorder => ‘显示顺序’
starttime => ‘开始时间’
endtime => ‘结束时间’
message => ‘消息’
groups => ‘接受用户组’

pre_forum_threadimage – 主题图片表
tid => ‘0’
attachment => ‘服务器路径’
remote => ‘是否远程附件’

pre_forum_attachment – 附件索引表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
tableid => ‘附件表id’
downloads => ‘下载次数’

pre_forum_attachment_exif – Exif缓存表
aid => ‘附件id’
exif => ‘exif信息’

pre_forum_attachment_unused – 未使用附件表
aid => ‘附件id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’

pre_forum_attachment_0 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_1 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_2 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_3 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_4 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_5 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_6 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_7 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_8 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachment_9 – 附件表
aid => ‘附件id’
tid => ‘主题id’
pid => ‘帖子id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filesize => ‘文件大小’
attachment => ‘服务器路径’
remote => ‘是否远程附件’
description => ‘说明’
readperm => ‘阅读权限’
price => ‘附件价格’
isimage => ‘是否图片’
width => ‘附件宽度’
thumb => ‘是否是缩率图’
picid => ‘相册图片ID ‘

pre_forum_attachtype – 附件类型表
id => ‘类型id’
fid => ‘论坛id’
extension => ‘扩展名’
maxsize => ‘允许上传最大值’

pre_forum_bbcode – Discuz! 代码表
id => ‘代码id’
available => ‘是否启用(0:不启用 1:启用但不显示 2:启用并显示)’
tag => ‘标签’
icon => ‘图标’
replacement => ‘替换内容’
example => ‘例子’
explanation => ‘解释说明’
params => ‘参数个数’
prompt => ‘标签描述’
nest => ‘嵌套层次’
displayorder => ‘显示顺序’
perm => ‘有权使用的用户组’

pre_forum_creditslog – 转帐记录表
uid => ‘会员id’
fromto => ‘来自/到’
sendcredits => ‘转出积分字段’
receivecredits => ‘接受积分字段’
send => ‘转出积分’
receive => ‘接受积分’
dateline => ‘转帐日期’
operation => ‘操作’

pre_forum_debate – 辩论主题表
tid => ‘主题id’
uid => ‘发起人id’
starttime => ‘开始时间’
endtime => ‘结束时间’
affirmdebaters => ‘正方辩论人数’
negadebaters => ‘反方辩论人数’
affirmvotes => ‘正方得票数’
negavotes => ‘反方得票数’
umpire => ‘裁判用户名’
winner => ‘获胜方(0:平局 1:为正方 2:为反方)裁判评判结果’
bestdebater => ‘最佳辩手用户名’
affirmpoint => ‘正方观点’
negapoint => ‘反方观点’
umpirepoint => ‘裁判观点,裁判结束辩论时填写’
affirmvoterids => ‘正方投票人的 id 集合’
negavoterids => ‘反方投票人的 id 集合’
affirmreplies => ‘正方回复次数,用来翻页’
negareplies => ‘反方回复次数,用来翻页’

pre_forum_debatepost – 辩论帖子表
pid => ‘帖子id’
stand => ‘立场(0:中立 1:正方 2:为反方)’
tid => ‘主题id’
uid => ‘发起人id’
dateline => ‘发表的时间’
voters => ‘投票人数’
voterids => ‘投票人的 id 集合’

pre_forum_faq – 论坛帮助表
id => ‘帮助id’
fpid => ‘帮助父id’
displayorder => ‘排序’
identifier => ‘帮助标识’
keyword => ‘帮助关键词’
title => ‘帮助标题’
message => ‘帮助内容’

pre_forum_postcache – 论坛帖子缓存表
pid int(10) unsigned NOT NULL, comment => ‘点评内容缓存’
rate => ‘评分情况缓存’
dateline => ‘缓存时间’

pre_home_favorite – 收藏表
favid => ‘收藏id’
uid => ‘会员id’
idtype => ‘收藏类型’
spaceuid => ‘空间会员id’
title => ‘标题’
description => ‘简介’
dateline => ‘时间’

pre_forum_forum – 版块表
fid => ‘论坛id’
fup => ‘上级论坛id’
type => ‘类型(group:分类 forum:普通论坛 sub:子论坛)’
name => ‘名称’
status => ‘显示状态(0:隐藏 1:正常 3:群组)’
displayorder => ‘显示顺序’
styleid => ‘风格id’
threads => ‘主题数量’
posts => ‘帖子数量’
todayposts => ‘今日发帖数量’
lastpost => ‘最后发表’
domain => ‘绑定的二级域名’
allowsmilies => ‘允许使用表情’
allowhtml => ‘允许使用html’
allowbbcode => ‘允许bbcode’
allowimgcode => ‘允许img’
allowmediacode => ‘允许使用多媒体代码’
allowanonymous => ‘允许匿名’
allowpostspecial => ‘允许发表特殊主题’
allowspecialonly => ‘只允许发表特殊主题’
allowappend => ‘是否开启帖子补充’
alloweditrules => ‘允许版主修改论坛规则’
allowfeed => ‘允许推送动态,默认推送广播’
allowside => ‘显示边栏’
recyclebin => ‘是否启用回收站’
modnewposts => ‘是否审核发帖’
jammer => ‘是否启用干扰码’
disablewatermark => ‘是否图片附件增加水印’
inheritedmod => ‘本论坛或分类版主的权力继承到下级论坛’
autoclose => ‘自动关闭主题’
forumcolumns => ‘增加论坛水平横排设置’
catforumcolumns => ‘增加分区版块水平横排设置’
threadcaches => ‘主题缓存功能设置’
alloweditpost => ‘允许编辑帖子’
simple => ‘0’ COMMENT ‘只显示子版块’
modworks => ‘本版有待处理的管理事项’
allowglobalstick => ‘是否显示全局置顶’
level => ‘群组等级’
commoncredits => ‘群组公共积分’
archive => ‘0’ COMMENT ‘是否有存档表’
recommend => ‘推荐到的版块’
favtimes => ‘版块或群组的收藏次数’
sharetimes => ‘版块或群组的分享次数’
disablethumb => ‘是否添加缩略图’
disablecollect => ‘禁止淘帖’

pre_forum_forumfield – 版块扩展表
fid => ‘版块id’
description => ‘解释说明’
password => ‘私密论坛密码’
icon => ‘图标’
redirect => ‘URL转发’
attachextensions => ‘允许上传附件类型’
creditspolicy => ‘版块积分策略’
formulaperm => ‘版块权限表达式’
moderators => ‘版主列表,格式:admin’
rules => ‘版块规则’
threadtypes => ‘主题分类,序列化存放的设置,格式为一个数组’
threadsorts => ‘分类信息,序列化存放的设置,格式为一个数组’
viewperm => ‘阅读权限, 格式: 1 4 5’
postperm => ‘发表权限, 格式: 1 4 5’
replyperm => ‘回复权限, 格式: 1 4 5’
getattachperm => ‘下载附件权限, 格式: 1 4 5’
postattachperm => ‘上传附件权限, 格式: 1 4 5’
postimageperm => ‘上传图片权限, 格式: 1 4 5’
spviewperm => ‘不受限于版权权限表达式, 格式: 1 4 5’
seotitle => ‘版块seo标题’
keywords => ‘版块seo关键词’
seodescription => ‘版块seo描述’
supe_pushsetting => ‘supe推送设置,序列化存放设置数据,格式为一个数组。’
modrecommend => ‘版主推荐规则’
threadplugin => ‘特殊主题插件数据’
jointype => ‘加入群组方式 -1为关闭,0为公开, 2邀请’
gviewperm => ‘群组浏览权限 0:仅成员 1:所有用户’
membernum => ‘群组成员数’
dateline => ‘群组创建时间’
lastupdate => ‘群组最后更新时间’
activity => ‘群组活跃度’
founderuid => ‘群组创始人UID’
foundername => ‘群组创始人名称’
banner => ‘群组头图片’
groupnum => ‘分类下的群组数量’
commentitem => ”
relatedgroup => ”
picstyle => ‘帖子列表是否以图片形式显示 0:否 1:是’
widthauto => ‘默认是否宽屏 0:全局 -1:宽屏 1:窄屏’

pre_forum_forum_threadtable – 版块存档信息
fid => ‘版块id’
threadtableid => ‘thread分区id’
threads => ‘0’ COMMENT ‘主题数’
posts => ‘0’ COMMENT ‘帖子数’

pre_forum_forumrecommend – 版主推荐表
fid => ‘版块id’
tid => ‘帖子id’
typeid => ‘是否含有附件图片’
displayorder => ‘推荐顺序’
subject => ‘推荐主题标题’
author => ‘推荐主题作者’
authorid => ‘推荐主题作者id’
moderatorid => ‘推荐管理人员id’
expiration => ‘推荐主题有效期’
position => ‘显示位置’
highlight => ‘高亮颜色’
aid => ‘附件ID’
filename => ‘附件文件’

pre_forum_imagetype – 图片 表情 头像等 分类
typeid => ‘分类id’
available => ‘是否启用’
name => ‘分类名称’
type => ‘分类类型(smiley:表情 icon:图标 avatar:头像)’
displayorder => ‘分类顺序’
directory => ‘图片目录’

pre_forum_medal – 勋章表
medalid => ‘勋章id’
name => ‘勋章名称’
available => ‘是否启用’
image => ‘勋章图片’
type => ‘0’ COMMENT ‘勋章类型’
displayorder => ‘勋章显示顺序’
description => ‘勋章描述’
expiration => ‘勋章有效期’
permission => ‘勋章获得条件表达式’
credit => ‘0’ COMMENT ‘勋章购买使用积分’
price => ‘0’ COMMENT ‘勋章价格’

pre_forum_medallog – 勋章日志表
id => ‘记录id’
uid => ‘勋章拥有着用户id’
medalid => ‘勋章id’
type => ‘0’ COMMENT ‘勋章类型id’
dateline => ‘颁发时间id’
expiration => ‘有效期id’
status => ‘0’ COMMENT ‘勋章状态id’

pre_common_member_magic – 用户道具数据表
uid => ‘用户uid’
magicid => ‘道具id’
num => ‘拥有数量’

pre_common_member_medal – 用户勋章数据表
uid => ‘UID’
medalid => ‘勋章类型’

pre_forum_memberrecommend – 用户推荐表
tid => ‘主题ID’
recommenduid => ‘推荐会员ID’
dateline => ‘推荐时间’

pre_forum_moderator – 版主表
uid => ‘会员id’
fid => ‘论坛id’
displayorder => ‘显示顺序’
inherited => ‘是否继承’

pre_forum_modwork – 论坛管理统计表
uid => ‘会员id’
modaction => ‘动作’
dateline => ‘时间段’
count => ‘登录次数’
posts => ‘发表数’

pre_common_mytask – 我的任务表
uid => ‘用户Uid’
username => ‘用户名’
taskid => ‘任务id’
`status` => ‘任务状态(-1:失败 0:进行中 1:已完成)’
csc => ‘任务进度’
dateline => ‘申请任务时间’

pre_forum_onlinelist – 在线列表定制
groupid => ‘会员组id’
displayorder => ‘显示顺序’
title => ‘组名称’
url => ‘图例URL’

pre_forum_order – 订单信息表
orderid => ‘订单号id’
status => ‘状态’
buyer => ‘购买者姓名’
admin => ‘补单管理员姓名’
uid => ‘购买者id’
amount => ‘数量’
price => ‘价格’
submitdate => ‘提交日期’
confirmdate => ‘确认日期’
email => ‘购买时的Email’
ip => ‘购买时的IP’

pre_forum_groupfield – 群组扩展信息缓存
fid => ‘群组关联fid’
privacy => ‘群组隐私设置’
dateline => ‘缓存生成时间’
type => ‘缓存类型’
data => ‘缓存数据’

pre_forum_groupinvite – 群组邀请
fid => ‘群组id’
uid => ‘邀请人id’
inviteuid => ‘被邀请人id’
dateline => ‘邀请时间’

pre_forum_groupuser – 群组成员
fid => ‘群组关联fid’
uid => ‘成员id’
username => ‘成员名’
level => ‘成员等级(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员)’
threads => ‘成员主题数’
replies => ‘成员回复数’
joindateline => ‘成员加入群组时间’
lastupdate => ‘成员最后活动时间’
privacy => ‘成员隐私设置’

pre_common_plugin – 插件表
pluginid => ‘插件id’
available => ‘是否启用’
adminid => ‘管理员id’
name => ‘名称’
identifier => ‘唯一标识符’
description => ‘解释说明’
datatables => ‘插件数据表’
directory => ‘插件目录’
copyright => ‘版权信息’
modules => ‘插件信息’
version => ‘插件版本’

pre_common_pluginvar – 插件变量表
pluginvarid => ‘插件变量id’
pluginid => ‘插件id’
displayorder => ‘显示顺序’
title => ‘名称’
description => ‘解释说明’
variable => ‘变量名’
type => ‘text’ COMMENT ‘类型’
value => ‘值’
extra => ‘附加’

pre_forum_thread_moderate – 主题审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_forum_post_moderate – 帖子审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_home_blog_moderate – 日志审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_home_pic_moderate – 图片审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_home_doing_moderate – 记录审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_home_share_moderate – 分享审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_portal_article_moderate – 文章审核数据表
id => ‘ID’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_home_comment_moderate – 家园评论审核数据表
id => ‘ID’
idtype => ‘ID类型’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_portal_comment_moderate – 文章/专题评论审核数据表
id => ‘ID’
idtype => ‘ID类型’
status => ‘状态 0 审核中,1 已忽略’
dateline => ‘0’

pre_forum_postlog – 漫游帖子日志
pid => ‘0’
tid => ‘0’
fid => ‘0’
uid => ‘0’
`action` char(10) NOT NULL DEFAULT , dateline => ‘0’

pre_forum_threadlog – 漫游主题日志
tid => ‘0’
fid => ‘0’
uid => ‘0’
otherid => ‘0’
`action` char(10) NOT NULL, expiry => ‘0’
dateline => ‘0’

pre_forum_threadpreview – 服务于广播
tid => ‘主题ID’
relay => ‘转播次数’
content => ‘主题内容预览’

pre_forum_poll – 投票表
tid => ‘主题id’
overt => ‘是否公开投票参与人’
multiple => ‘是否多选’
visible => ‘是否投票后可见’
maxchoices => ‘最大可选项数’
expiration => ‘过期时间’
pollpreview => ‘选项内容前两项预览’
voters => ‘投票人数’

pre_forum_pollvoter – 投票用户表
tid => ‘主题id’
uid => ‘会员id’
username => ‘会员名’
options => ‘选项 分隔’
dateline => ‘发表时间’

pre_forum_polloption – 投票选项表
polloptionid => ‘选项id’
tid => ‘主题id’
votes => ‘票数’
displayorder => ‘显示顺序’
polloption => ‘选项内容’
voterids => ‘投票人id’

pre_forum_post – 帖子表
pid => ‘帖子id’
fid => ‘论坛id’
tid => ‘主题id’
first => ‘0’ COMMENT ‘是否是首贴’
author => ‘作者姓名’
authorid => ‘作者id’
subject => ‘标题’
dateline => ‘发表时间’
message => ‘消息’
useip => ‘发帖者IP’
invisible => ‘是否通过审核’
anonymous => ‘是否匿名’
usesig => ‘是否启用签名’
htmlon => ‘是否允许HTML’
bbcodeoff => ‘是否关闭BBCODE’
smileyoff => ‘是否关闭表情’
parseurloff => ‘是否允许粘贴URL’
attachment => ‘附件’
rate => ‘评分分数’
ratetimes => ‘评分次数’
status => ‘0’ COMMENT ‘帖子状态’
tags => ‘新增字段,用于存放tag’
comment => ‘0’ COMMENT ‘是否存在点评’
replycredit => ‘回帖获得积分记录’
position => ‘帖子位置信息’

pre_forum_postcomment – 点评帖子表
`id` => ”
tid => ‘0’ COMMENT ‘主题ID’
pid => ‘0’ COMMENT ‘帖子ID’
author => ‘作者’
authorid => ‘0’ COMMENT ‘作者ID x1.5以后:0为游客 -1为观点’
dateline => ‘0’ COMMENT ‘时间’
comment => ‘点评内容’
score => ‘0’ COMMENT ‘是否包含点评观点’
useip => ‘发帖者IP’
rpid => ‘0’ COMMENT ‘关联的帖子ID’

pre_forum_post_location – 帖子地理位置表
pid => ‘0’
tid => ‘0’
uid => ‘0’
mapx => ”
mapy => ”
location => ”

pre_forum_post_tableid – post分表协调表
pid => ‘Post ID’

pre_forum_poststick – 回帖置顶表
tid => ‘所属主题TID’
pid => ‘回帖PID’
position => ”
dateline => ‘操作时间’

pre_forum_promotion – 论坛推广
ip => ‘IP地址’
uid => ‘会员id’
username => ‘会员名’

pre_forum_ratelog – 帖子评分记录表
pid => ‘帖子id’
uid => ‘会员id’
username => ‘会员名’
extcredits => ‘评分字段’
dateline => ‘评分时间’
score => ‘分数’
reason => ‘操作理由’

pre_forum_relatedthread – 相关主题表
tid => ‘主题id’
type => ‘关键词类型’
expiration => ‘过期时间’
keywords => ‘关键字’
relatedthreads => ‘相关主题序列’

pre_forum_rsscache – rss缓存表
lastupdate => ‘最后更新时间’
fid => ‘论坛id’
tid => ‘主题id’
dateline => ‘发表时间’
forum => ‘论坛名称’
author => ‘作者’
subject => ‘标题’
description => ‘解释说明’
guidetype => ‘导读中的类型’

pre_forum_replycredit – 主题回帖获得积分规则表
tid => ‘主题tid’
extcredits => ‘单次回复奖励额度’
extcreditstype => ‘本规则下奖励积分的类型’
times => ‘回复奖励次数’
membertimes => ‘单个用户参与次数’
random => ‘用户设置的回帖奖励几率’

pre_common_searchindex – 搜索缓存表
searchid => ‘缓存id’
srchmod => ‘mod模块’
keywords => ‘关键字’
searchstring => ‘查找字符串’
useip => ‘搜索人IP’
uid => ‘会员id’
dateline => ‘搜索时间’
expiration => ‘过期时间’
threadsortid => ‘分类信息id’
num => ‘主题数量’
ids => ‘主题id序列’

pre_common_sphinxcounter – Sphinx 增量索引记录表
`indexid` tinyint(1) NOT NULL, `maxid` int(10) NOT NULL,

pre_forum_spacecache – minispace缓存表
uid => ‘用户 uid’
variable => ‘缓存变量的名称’
value => ‘缓存变量的值’
expiration => ‘过期时间’

pre_forum_statlog – 版块统计日志表
logdate => ‘日志日期’
fid => ‘版块ID’
`type` smallint(5) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘记录类型 value => ‘0’ COMMENT ‘记录值’

pre_common_task – 论坛任务表
taskid => ‘任务id’
relatedtaskid smallint(6) unsigned NOT NULL default ‘0’ COMMENT ‘依存任务id 必须完成依存任务才能申请该任务’, available => ‘是否启用’
name => ‘任务名称’
description => ‘任务描述’
icon => ‘任务图标’
applicants => ‘已申请任务人次’
achievers => ‘已完成任务人次’
tasklimits => ‘允许申请并完成该任务的人次上限’
applyperm => ‘允许申请任务的用户组id, 格式: 1 2 3’
scriptname => ‘任务脚本文件名’
starttime => ‘任务上线时间’
endtime => ‘任务下线时间’
period => ‘任务周期 单位:小时 默认为0表示一次性任务 设置为24即1天表示日常任务’
periodtype => ‘任务间隔周期单位 0:小时 1:天 2:周 3:月’
reward => ‘奖励类型(credit:积分 magic:道具 medal:勋章 invite:邀请码 group:特殊用户组)’
prize => ‘奖品: 哪一个扩展积分, 道具id, 勋章id,邀请码有效期, 特殊用户组id’
bonus int(10) NOT NULL default ‘0’ COMMENT ‘奖品数量/有效期: 积分数量, 道具数量, 勋章有效期, 邀请码数量,特殊用户组有效期’, displayorder => ‘显示顺序’
version => ‘任务脚本版本号’

pre_common_taskvar – 论坛任务设置表
taskvarid => ‘任务变量id’
taskid => ‘任务id’
sort => ‘变量类别(apply:申请任务条件 complete:完成任务条件)’
name => ‘变量名称’
description => ‘变量描述’
variable => ‘变量名’
type => ‘text’ COMMENT ‘变量类型’
value => ‘变量值’

pre_forum_thread – 主题表
tid => ‘主题id’
fid => ‘上级论坛’
posttableid => ‘帖子表ID’
typeid => ‘主题分类id’
sortid => ‘分类信息id’
readperm => ‘阅读权限’
price => ‘价格’
author => ‘会员名’
authorid => ‘会员id’
subject => ‘标题’
dateline => ‘发表时间’
lastpost => ‘最后发表’
lastposter => ‘最后发表人id’
views => ‘浏览次数’
replies => ‘回复次数’
displayorder => ‘显示顺序’
highlight => ‘是否高亮’
digest => ‘是否精华’
rate => ‘是否评分’
special => ‘特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关’
attachment => ‘附件,0无附件 1普通附件 2有图片附件’
moderated => ‘是否被管理员改动’
closed => ‘是否关闭’
stickreply => ‘是否有回帖置顶’
recommends => ‘推荐指数’
recommend_add => ‘支持人数’
recommend_sub => ‘反对人数’
heats => ‘主题热度值’
status smallint(6) unsigned NOT NULL default ‘0’ , isgroup => ‘是否为群组帖子’
favtimes => ‘主题收藏次数’
sharetimes => ‘主题分享次数’
stamp => ‘-1’ COMMENT ‘主题图章’
icon => ‘-1’ COMMENT ‘主题图标’
pushedaid => ‘被推送到的文章aid’
cover => ‘主题封面 负数:远程 正数:本地 0:无封面’
replycredit => ‘回帖奖励积分主题记录积分值’
relatebytag => ‘根据帖子标签取的相关主题id (time /t tid,…)’
maxposition => ‘最大回帖位置信息’

pre_forum_threadaddviews – 主题查看数延时更新表
tid => ‘主题id’
addviews => ‘浏览次数’

pre_forum_threaddisablepos – 主题有楼层不准确时不使用position查询
tid => ‘主题id’

pre_forum_threadclosed – 主题转移后保留的指向记录
tid => ‘对应源主题’
redirect => ‘保留的指向 tid’

pre_forum_threadmod – 主题管理记录表
tid => ‘主题id’
uid => ‘会员id’
username => ‘会员名’
dateline => ‘操作时间’
expiration => ‘有效时间’
action => ‘操作’
status => ‘0’ COMMENT ‘状态’
magicid => ‘使用道具id’
stamp => ‘主题图章/图标 ID’
reason => ‘操作原因’

pre_forum_threadpartake – 主题参与者记录表
tid => ‘主题id’
uid => ‘会员id’
dateline => ‘参与时间’

pre_forum_threadrush – 抢楼设置表
tid => ‘主题id’
stopfloor => ‘截止楼层’
starttimefrom => ‘开始时间’
starttimeto => ‘结束时间’
rewardfloor => ‘奖励楼层’
creditlimit => ‘积分下限’

pre_forum_threadtype – 分类信息表
typeid => ‘分类信息id’
fid => ‘0’
displayorder => ‘显示顺序’
name => ‘名称’
description => ‘解释说明’
icon => ‘分类图标URL’
special => ‘分类状态’
modelid => ‘分类模型id’
expiration => ‘分类有效期’
template => ‘分类信息内容模板’
stemplate => ‘分类信息主题模板’
ptemplate => ‘分类信息发帖模板’
btemplate => ‘分类信息模块调用模板’

pre_forum_trade – 商品数据表
tid => ‘主题id’
pid => ‘帖子id’
typeid => ‘主题分类id’
sellerid => ‘卖家id’
seller => ‘卖家名’
account => ‘卖家帐号’
tenpayaccount => ‘卖家财付通账号’
subject => ‘标题’
price => ‘价格’
amount => ‘数量’
quality => ‘成色’
locus => ‘所在地’
transport => ‘物流方式’
ordinaryfee => ‘平邮附加费’
expressfee => ‘快递附加费’
emsfee => ‘EMS附加费’
itemtype => ‘商品类型’
dateline => ‘交易时间’
expiration => ‘过期时间’
lastbuyer => ‘最后买家用户名’
lastupdate => ‘最后交易时间’
totalitems => ‘总交易量’
tradesum => ‘总交易额’
closed => ‘是否关闭’
aid => ‘商品图片的 Aid’
displayorder => ‘显示顺序’
costprice => ‘商品原价’
credit => ‘积分价格’
costcredit => ‘积分原价’
credittradesum => ‘总积分交易额’

pre_forum_threadclass – 主题分类表
typeid => ‘分类ID’
fid => ‘所属版块ID’
name => ‘分类名称’
displayorder => ‘显示顺序’
icon => ‘分类图标URL’
moderators => ‘0’ COMMENT ‘仅管理者可用’

pre_forum_tradecomment – 信用评价
id => ‘id’
orderid => ‘订单 id’
pid => ‘帖子 id’
type => ‘类型’
raterid => ‘评价方会员id’
rater => ‘评价方用户名’
rateeid => ‘被评价方会员id’
ratee => ‘被评价方用户名’
message => ‘评价内容’
explanation => ‘解释’
score => ‘评分’
dateline => ‘评价时间’

pre_forum_tradelog – 交易记录表
tid => ‘主题id’
pid => ‘帖子id’
orderid => ‘订单号id’
tradeno => ‘支付宝订单号’
paytype => ‘在线支付方式’
subject => ‘标题’
price => ‘价格’
quality => ‘成色’
itemtype => ‘商品类型’
number => ‘数量’
tax => ‘交易手续费’
locus => ‘物品所在地’
sellerid => ‘卖家id’
seller => ‘卖家名’
selleraccount => ‘卖家交易帐号’
tenpayaccount => ‘卖家财付通账号’
buyerid => ‘买家id’
buyer => ‘买家名’
buyercontact => ‘买家联系方式’
buyercredits => ‘买家暂扣积分’
buyermsg => ‘买家留言’
status => ‘0’ COMMENT ‘状态’
lastupdate => ‘状态最后更新’
offline => ‘是否离线交易’
buyername => ‘买家姓名’
buyerzip => ‘买家邮编’
buyerphone => ‘买家电话’
buyermobile => ‘买家手机’
transport => ‘运输方式’
transportfee => ‘运输费用’
baseprice => ‘商品原价’
discount => ‘折扣’
ratestatus => ‘评价状态’
message => ‘订单留言’
credit => ‘积分价格’
basecredit => ‘积分原价’

pre_forum_typeoption – 分类信息设置项目表
optionid => ‘分类信息项目ID’
classid => ‘分类信息上级项目ID’
displayorder => ‘分类信息排序’
expiration => ‘分类信息项目是否受有效期限制’
protect => ‘分类信息项目是否是保护项目’
title => ‘分类信息项目标题’
description => ‘分类信息项目描述’
identifier => ‘分类信息项目标识’
type => ‘分类信息项目类型’
unit => ‘分类信息项目单位’
rules => ‘分类信息项目规则’
permprompt => ‘分类信息项目权限提示’

pre_forum_typeoptionvar – 分类信息项目数据表
sortid => ‘分类信息id’
tid => ‘分类信息数据对应帖子id’
fid => ‘分类信息数据对应帖子板块id’
optionid => ‘分类信息数据对应选项id’
expiration => ‘分类信息数据有效期’
value => ‘分类信息数据数值’

pre_forum_typevar – 分类信息对应项目表
sortid => ‘分类信息id’
optionid => ‘分类信息对应项目id’
available => ‘分类信息对应项目是否可用’
required => ‘分类信息对应项目是否必填’
unchangeable => ‘分类信息对应项目是否可修改’
search => ‘分类信息对应项目是否可搜索’
displayorder => ‘分类信息对应项目顺序’
subjectshow => ”

pre_forum_warning – 警告记录表
wid => ‘记录id’
pid => ‘帖子 pid’
operatorid => ‘警告者 Uid’
operator => ‘警告者用户名’
authorid => ‘被警告者 uid’
author => ‘被警告者用户名’
dateline => ‘警告时间’
reason => ‘警告原因’

pre_home_album – 相册表
albumid => ‘相册ID ‘
albumname => ‘相册名字’
catid => ‘相册系统分类’
uid => ‘相册用户ID ‘
username => ‘相册用户名’
dateline => ‘相册建立时间戳’
updatetime => ‘相册最后修改时间戳’
picnum => ‘相册照片数量’
pic => ‘相册封面照片’
picflag => ‘相册是否有图片’
friend => ‘相册隐私设置:”0″全站用户可见,”1″为全好友可见,”2″为仅指定的好友可见,”3″为仅自己可见,”4″为凭密码查看 ‘
password => ‘相册密码’
target_ids => ‘允许查看相册的用户ID,多个用户ID用”m”间隔 ‘
favtimes => ‘相册收藏次数’
sharetimes => ‘相册分享次数’
depict => ‘相册描述 ‘

pre_home_appcreditlog – 漫游应用积分操作记录表
logid => ‘序列id’
uid => ‘用户id’
appid => ‘用户名’
appname => ‘应用名称’
type => ‘0’ COMMENT ‘积分转入转出类型’
credit => ‘积分数’
note => ‘备注’
dateline => ‘操作时间’

pre_home_blacklist – 屏蔽黑名单表
uid => ‘用户ID ‘
buid => ‘被屏蔽的用户ID ‘
dateline => ‘被屏蔽的时间戳’

pre_common_block – 模块表
bid => ‘模块ID’
blockclass => ‘模块分类 article/pic/member/board/poll’
blocktype => ‘调用类型 0为模板调用 1为js调用’
name => ‘模块标名称’
title => ‘模块标题名’
classname => ‘指定样式class’
summary => ‘模块自定义内容’
uid => ‘创建者用户ID ‘
username => ‘创建者用户名’
styleid => ‘模块风格ID’
blockstyle => ‘自定义风格’
picwidth => ‘显示图片长度’
picheight => ‘显示图片宽度’
target => ‘模块链接打开方式: _blank, _self, _top’
dateformat => ‘时间格式: H:i; u; Y-m-d等’
dateuformat => ‘是否使用个性化时间格式’
script => ‘模块获取数据脚本名’
param => ‘模块参数配置序列化存储’
shownum => ‘获取数据数目’
cachetime => ‘模块缓存更新时间间隔’
cachetimerange => ‘模块缓存更新时间区间’
punctualupdate => ‘是否严格按照缓存时间更新(忽略优化)’
hidedisplay => ‘是否屏蔽输出’
dateline => ‘模块缓存创建时间戳’
notinherited => ‘是否继承所在页面权限’
isblank => ‘是否为空白模块,只显示准送数据’

pre_common_block_style – 模块模板表
styleid => ‘模块样式ID’
blockclass => ‘模块分类’
name => ‘样式名称’
template => ‘样式模板’
hash => ‘样式hash(blockclass + template)’
getpic => ‘是否需要获取pic数据’
getsummary => ‘是否需要获取summary数据’
makethumb => ‘是否需要block设置缩略图’
settarget => ‘是否需要设置链接打开方式’
fields => ‘模板中用到的模块分类字段’
moreurl => ‘是否有更多链接’

pre_common_block_item – 模块数据表
itemid => ‘信息ID’
bid => ‘模块ID’
id => ‘来源ID’
idtype => ‘来源ID TYPE,手工添加数据为rand’
itemtype => ‘信息类型 0为自动 1为手工输入 2已编辑’
title => ‘信息标题名’
url => ‘信息链接地址’
pic => ‘信息图片’
picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’
makethumb => ‘是否已生成缩略图 1:生成成功; 2:生成失败’
thumbpath => ‘缩略图地址’
summary => ‘信息摘要’
showstyle => ‘显示样式’
related => ‘相关链接’
fields => ‘信息附属num/author/authorid/dateline’
displayorder => ‘显示顺序’
startdate => ‘开始时间戳’
enddate => ‘结束时间戳’

pre_common_block_pic – 模块使用图片表
picid => ‘图片ID’
bid => ‘模块ID’
itemid => ‘信息ID’
pic => ‘信息图片’
picflag => ‘图片类型 0为本地 1为ftp远程’
type => ‘0’ COMMENT ‘信息类型 0为模块缩略图 1为上传的图’

pre_common_block_item_data – 模块推荐信息表
dataid => ‘推荐信息ID’
bid => ‘模块ID’
id => ‘来源ID’
idtype => ‘来源ID TYPE’
itemtype => ‘信息类型 0为自动 1为手工输入 3推荐数据’
title => ‘信息标题名’
url => ‘信息链接地址’
pic => ‘信息图片’
picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’
makethumb => ‘是否已生成缩略图’
summary => ‘信息摘要’
showstyle => ‘显示样式’
related => ‘相关链接’
fields => ‘信息附属num/author/authorid/dateline’
displayorder => ‘显示顺序’
startdate => ‘开始时间戳’
enddate => ‘结束时间戳’
uid => ‘推荐者 UID’
username => ‘推荐者用户名’
dateline => ‘推荐日期’
isverified => ‘是否已通过审核’
verifiedtime => ‘通过审核日期’
stickgrade => ‘置顶等级: 0~10’

pre_common_block_xml – 模块 XML 扩展类数据表
id => ‘ID’
name => ‘XML扩展 名称’
version => ‘XML扩展 版本’
url => ‘XML扩展 URL’
clientid => ‘客户端ID’
key => ‘通信密钥’
signtype => ‘签名的加密方式:目前只支持MD5方式,空为不使用签名,直接使用通信密钥’
data => ‘XML扩展 数据’

pre_common_block_favorite – 模块收藏表
favid => ‘收藏id’
uid => ‘会员id’
bid => ‘模块id’
dateline => ‘收藏时间’

pre_home_blog – 日志表
blogid => ‘日志ID’
uid => ‘日志所属用户ID ‘
username => ‘日志所属用户名’
subject => ‘日志标题’
classid => ‘个人分类id’
catid => ‘系统分类id’
viewnum => ‘日志查看数’
replynum => ‘日志回复数’
hot => ‘热度’
dateline => ‘日志发布时间’
picflag => ‘日志是否有图片’
noreply => ‘是否允许评论:”0″为允许,”1″为不允许 ‘
friend => ‘日志隐私设置:”0″为全站用户可见,”1″为全好友可见,”2″为仅指定的好友可见,”3″为仅自己可见,”4″为凭密码查看 ‘
password => ‘日志密码’
favtimes => ‘日志收藏次数’
sharetimes => ‘日志分享次数’
status => ‘0’ COMMENT ‘blog状态 1-审核’
click1 => ‘表态1 id’
click2 => ‘表态2 id’
click3 => ‘表态3 id’
click4 => ‘表态4 id’
click5 => ‘表态5 id’
click6 => ‘表态6 id’
click7 => ‘表态7 id’
click8 => ‘表态8 id’

pre_home_blogfield – 日志字段表
blogid => ‘日志id’
uid => ‘日志所属用户ID ‘
pic => ‘标题图片’
tag => ‘日志TAG ‘
message => ‘日志内容’
postip => ‘发表日志的IP ‘
related => ‘相关日志的数据信息’
relatedtime => ‘相关日志产生时间戳’
target_ids => ‘允许查看日志的用户ID多个ID以”,”间隔 ‘
hotuser => ‘热点用户’
magiccolor => ‘道具彩色灯id’
magicpaper => ‘道具信纸id’
pushedaid => ‘被推送到的文章aid’

pre_home_class – 日志个人分类表
classid => ‘个人分类id’
classname => ‘分类名称’
uid => ‘分类所属用户ID ‘
dateline => ‘分类创建时间戳’

pre_home_click – 表态动作
clickid => ‘表态ID’
name => ‘表态名称’
icon => ‘表态图标’
idtype => ‘表态类型’
available => ‘是否有效’
displayorder => ‘排序’

pre_home_clickuser – 用户表态表
uid => ‘表态用户id’
username => ‘表态用户名’
id => ‘作用对象id’
idtype => ‘作用对象id类型’
clickid => ‘表态id’
dateline => ‘发表表态时间戳’

pre_home_comment – 用户评论表
cid => ‘评论id’
uid => ‘发表评论的用户id’
id => ‘评论对象id’
idtype => ‘评论对象的id类型:blogid,picid,uid’
authorid => ‘若为回复,回复作者用户ID ‘
author => ‘若为回复,回复作者用户名 ‘
ip => ‘评论IP ‘
dateline => ‘评论时间戳’
message => ‘评论内容’
magicflicker => ‘是否使用了道具彩虹炫’
status => ‘评论状态 1-审核’

pre_home_docomment – 用户记录回复表
id => ‘记录回复id’
upid => ‘上级记录回复id’
doid => ‘所评论的记录id’
uid => ‘发布记录者用户id’
username => ‘发布记录者用户名’
dateline => ‘记录回复时间戳’
message => ‘记录回复内容’
ip => ‘发布记录ip’
grade => ‘记录回复的层级’

pre_home_doing – 用户记录表
doid => ‘记录id’
uid => ‘记录发布者用户id’
username => ‘记录发布者用户名’
from => ‘记录的发表来源’
dateline => ‘记录发布时间戳’
message => ‘记录内容’
ip => ‘记录发布ip’
replynum => ‘记录回复数’
status => ‘记录状态 1-审核’

pre_home_feed – 站点feed表
feedid => ‘feed的ID ‘
appid => ‘应用程序ID ‘
icon => ‘feed图标 ‘
uid => ‘产生feed的用户ID ‘
username => ‘产生feed的用户名 ‘
dateline => ‘feed产生时间戳 ‘
friend => ‘产生feed信息的隐私设置 ‘
hash_template => ‘模板hash:md5(title_template” “body_template) ‘
hash_data => ‘数据内容hash:md5(title_templat” “title_data” “body_template” “body_data) ‘
title_template => ‘feed标题模板 ‘
title_data => ‘feed标题 ‘
body_template => ‘feed内容模板 ‘
body_data => ‘feed内容 ‘
body_general => ‘用户填写的信息 ‘
image_1 => ‘feed图1’
image_1_link => ‘feed图片链接1’
image_2 => ‘feed图片2’
image_2_link => ‘feed图片链接2’
image_3 => ‘feed图片3’
image_3_link => ‘feed图片链接3’
image_4 => ‘feed图片4’
image_4_link => ‘feed图片链接4’
target_ids => ‘产生feed信息允许查看的好友ID ‘
id => ‘feed对应对象id’
idtype => ‘feed对应对象类型’
hot => ‘热度’

pre_home_feed_app – 应该feed表
feedid => ‘应用feed id’
appid => ‘应用程序ID’
icon => ‘feed图标 ‘
uid => ‘产生feed的用户ID ‘
username => ‘产生feed的用户名 ‘
dateline => ‘feed产生时间戳 ‘
friend => ‘产生feed信息的隐私设置 ‘
hash_template => ‘模板hash:md5(title_template” “body_template) ‘
hash_data => ‘数据内容hash:md5(title_templat” “title_data” “body_template” “body_data) ‘
title_template => ‘feed标题模板 ‘
title_data => ‘feed标题 ‘
body_template => ‘feed内容模板 ‘
body_data => ‘feed内容 ‘
body_general => ‘用户填写的信息 ‘
image_1 => ‘feed图1’
image_1_link => ‘feed图片链接1’
image_2 => ‘feed图片2’
image_2_link => ‘feed图片链接2’
image_3 => ‘feed图片3’
image_3_link => ‘feed图片链接3’
image_4 => ‘feed图片4’
image_4_link => ‘feed图片链接4’
target_ids => ‘产生feed信息允许查看的好友ID ‘

pre_home_friend – 用户好友表
uid => ‘用户ID ‘
fuid => ‘用户好友ID ‘
fusername => ‘用户好友名’
gid => ‘好友所在的好友组ID ‘
num => ‘好友之间的任务关系数’
dateline => ‘加好友的时间戳’
note => ‘好友备注’

pre_home_friend_request – 申请好友表
uid => ‘用户ID ‘
fuid => ‘被请求用户ID ‘
fusername => ‘被请求用户名称’
gid => ‘好友所在的好友组ID ‘
note => ‘申请附言’
dateline => ‘请求好友时间戳’

pre_home_friendlog – 用户好友动作日志表
uid => ‘用户ID ‘
fuid => ‘好友用户ID ‘
action => ‘好友动作:”add”添加,”update”更新 ‘
dateline => ‘好友动作时间’

pre_common_magiclog – 道具日志表
uid => ‘用户id’
magicid => ‘道具id’
action => ‘操作动作 1 购买 2 使用 3 赠送’
dateline => ‘操作时间’
amount => ‘操作数量’
credit => ‘操作积分’
price => ‘操作价格’
targetid => ‘0’
`idtype` char(6) DEFAULT NULL, targetuid => ‘道具目标uid’

pre_common_magic – 道具数据表
magicid => ‘道具id’
available => ‘是否可用’
name => ‘名称’
identifier => ‘唯一标识’
description => ‘描述’
displayorder => ‘顺序’
credit => ‘使用的积分’
price => ‘价格’
num => ‘数量’
salevolume => ‘销售量’
supplytype => ‘自动补货类型’
supplynum => ‘自动补货数量’
useperoid => ‘使用周期’
usenum => ‘周期使用数量’
weight => ‘重量’
magicperm => ‘权限’
useevent => ‘0:只在特定环境使用 1:可以在道具中心使用’

pre_home_notification – 通知表
id => ‘通知ID ‘
uid => ‘通知用户ID ‘
type => ‘通知类型:”doing”记录,”friend”好友请求,”sharenotice”好友分享,”post”话题回复, ‘
new => ‘0’ COMMENT ‘通知是否为新:”1″为新通知,”0″为通知已读 ‘
authorid => ‘作者用户ID ‘
author => ‘用户名’
note => ‘通知内容’
dateline => ‘通知产生的时间戳’
from_id => ‘来源对象id’
from_idtype => ‘来源对象类型’
from_num => ‘来源量’

pre_home_pic – 家园图片表
picid => ‘图片ID ‘
albumid => ‘图片所属相册ID ‘
uid => ‘图片所属用户ID ‘
username => ‘图片所属用户名’
dateline => ‘图片上传时间戳’
postip => ‘图片上传ip’
filename => ‘图片文件名’
title => ‘图片标题’
type => ‘图片类型’
size => ‘图片大小’
filepath => ‘图片路径’
thumb => ‘是否有缩略图’
remote => ‘是否有远程图片0:home本地图片,1:home远程图片,2:论坛本地图片,3论坛远程图片’
hot => ‘热度’
sharetimes => ‘图片分享次数’
click1 => ‘表态1 id’
click2 => ‘表态2 id’
click3 => ‘表态3 id’
click4 => ‘表态4 id’
click5 => ‘表态5 id’
click6 => ‘表态6 id’
click7 => ‘表态7 id’
click8 => ‘表态8 id’
magicframe => ‘道具使用相框id’
status => ‘图片状态 1-审核’

pre_home_picfield – 家园图片拓展表
picid => ‘图片id’
hotuser => ‘图片对应热点用户’

pre_home_poke – 用户招呼表
uid => ‘接招呼的用户ID ‘
fromuid => ‘打招呼的用户ID ‘
fromusername => ‘打招呼的用户名 ‘
note => ‘招呼内容’
dateline => ‘打招呼时间戳’
iconid => ‘招呼图标’

pre_home_pokearchive – 用户招呼存档表
pid => ‘招呼历史id’
pokeuid => ‘uid + fromuid’
uid => ‘目标用户ID’
fromuid => ‘发起用户ID’
note => ‘招呼内容’
dateline => ‘招呼时间戳’
iconid => ‘招呼图标’

pre_home_share – 用户分享表
sid => ‘分享id’
itemid => ‘相关条目的ID’
type => ‘分享类型’
uid => ‘分享者用户id’
username => ‘分享者用户名’
fromuid => ‘被分享者用户ID’
dateline => ‘分享时间戳’
title_template => ‘分享标题模板’
body_template => ‘分享内容模板’
body_data => ‘分享内容数据’
body_general => ‘分享说明’
image => ‘分享的图片’
image_link => ‘分享的图片链接’
hot => ‘热度’
hotuser => ‘相关热点用户’
status => ‘分享条目状态 1-审核’

pre_home_show – 用户上榜表
uid => ‘我要上榜用户id’
username => ‘我要上榜用户名’
unitprice => ‘单次访问单价’
credit => ‘上榜总积分’
note => ‘上榜宣言’

pre_home_userapp – 用户使用应用表
uid => ‘使用应用的用户ID ‘
appid => ‘应用ID ‘
appname => ‘应用名’
privacy => ‘应用是否公开’
allowsidenav => ‘是否在开始菜单中显示’
allowfeed => ‘是否允许应用产生feed ‘
allowprofilelink => ‘时都允许在首页显示连接’
narrow => ‘是否在个人空间左边显示’
menuorder => ‘菜单顺序’
displayorder => ‘显示顺序’

pre_home_userappfield – 用户使用应用扩展表
uid => ‘使用应用的用户id’
appid => ‘应用id’
profilelink => ‘应用链接’
myml => ‘myml格式的首页显示信息’

pre_home_visitor – 空间访问日志表
uid => ‘受访者用户id’
vuid => ‘访问者用户id’
vusername => ‘访问者用户名’
dateline => ‘访问时间戳’

pre_portal_article_title – 门户文章标题表
aid => ‘文章ID’
catid => ‘栏目id’
bid => ‘模块id’
uid => ‘用户id’
username => ‘用户名’
title => ‘标题’
highlight => ‘标题样式’
author => ‘原作者’
from => ‘来源’
fromurl => ‘来源URL’
url => ‘访问URL’
summary => ‘摘要’
pic => ‘封面图片’
thumb => ‘封面图片是否缩略’
remote => ‘封面图片是否远程’
id => ‘来源ID’
idtype => ‘来源ID类型’
contents => ‘内容分页数’
allowcomment => ‘是否允许评论’
owncomment => ‘对于推送过来的文章:1,使用文章评论;0,同步原主题/日志的帖子/评论’
click1 => ‘表态1 id’
click2 => ‘表态2 id’
click3 => ‘表态3 id’
click4 => ‘表态4 id’
click5 => ‘表态5 id’
click6 => ‘表态6 id’
click7 => ‘表态7 id’
click8 => ‘表态8 id’
tag => ‘文章属性,共八位’
dateline => ‘添加时间’
status => ‘文章状态 0-已审核 1-需要审核 2-已忽略’
showinnernav => ‘是否显示分页导航’

pre_portal_article_content – 门户文章内容表
cid => ‘内容ID’
aid => ‘文章ID’
id => ‘来源ID’
idtype => ‘来源ID类型’
title => ‘标题’
content => ‘文章内容’
pageorder => ‘分页排序’
dateline => ‘添加时间’

pre_portal_article_count – 门户文章统计数据表
aid => ‘文章ID’
catid => ‘栏目id’
viewnum => ‘查看数’
commentnum => ‘评论数’
favtimes => ‘文章收藏次数’
sharetimes => ‘文章分享次数’

pre_portal_article_trash – 门户文章回收站表
aid => ‘垃圾文章ID’
content => ‘文章数据的seriallize存储’

pre_portal_comment – 门户评论表
cid => ‘评论id’
uid => ‘发表评论的用户id’
username => ‘发表评论的用户名’
id => ‘评论对象id’
idtype => ‘评论对象的id类型:aid,topicid’
postip => ‘评论IP ‘
dateline => ‘评论时间戳’
status => ‘评论状态 1-审核’
message => ‘评论内容’

pre_portal_rsscache – 文章rss缓存表
lastupdate => ‘最后更新时间’
catid => ‘文章分类id’
aid => ‘文章id’
dateline => ‘发表时间’
catname => ‘分类名称’
author => ‘作者’
subject => ‘标题’
description => ‘解释说明’

pre_portal_topic – 门户专题表
topicid => ‘专题ID’
title => ‘专题标题’
name => ‘静态化名称’
domain => ‘二级域名’
summary => ‘专题介绍’
keyword => ‘SEO 关键字’
cover => ‘专题封面’
picflag => ‘图片类型 0为url 1为本地 2 为ftp远程’
primaltplname => ‘原模板地址’
useheader => ‘是否使用网站导航内容’
usefooter => ‘是否使用网站尾部信息’
uid => ‘创建者UID’
username => ‘创建者用户名’
viewnum => ‘查看数’
dateline => ‘创建时间’
closed => ‘是否关闭状态’
allowcomment => ‘是否允许评论’
commentnum => ‘评论数’

pre_portal_topic_pic – 门户专题图片表
picid => ‘图片ID ‘
topicid => ‘图片所属专题ID ‘
uid => ‘图片所属用户ID ‘
username => ‘图片所属用户名’
dateline => ‘图片上传时间戳’
filename => ‘图片文件名’
title => ‘图片标题’
size => ‘图片大小’
filepath => ‘图片路径’
thumb => ‘是否有缩略图’
remote => ‘是否有远程图片’

pre_common_diy_data – DIY模板页面数据的存档表
targettplname => ‘目标模板文件名’
tpldirectory => ‘原模板所在目录’
primaltplname => ‘原模板文件名’
diycontent => ‘DIY的内容’
name => ‘目标模板页面名称’
uid => ‘会员id’
username => ‘用户名’
dateline => ‘更新时间’

pre_common_template_block – 模板页面和模块的关联表
targettplname => ‘目标模板文件名’
tpldirectory => ‘原模板所在目录’
bid => ‘模块ID’

pre_common_template_permission – DIY模板页面权限表
targettplname => ‘目标模板’
uid => ‘用户ID’
allowmanage => ‘允许管理’
allowrecommend => ‘允许推荐’
needverify => ‘推荐需要审核’
inheritedtplname => ‘继承自的模板名称’

pre_common_block_permission – 模块权限表
bid => ‘模块ID’
uid => ‘会员id’
allowmanage => ‘允许管理’
allowrecommend => ‘允许推荐’
needverify => ‘推荐需要审核’
inheritedtplname => ‘继承自的模板名称’

pre_portal_category_permission – 文章分类权限表
catid => ‘分类ID’
uid => ‘会员id’
allowpublish => ‘允许发布文章’
allowmanage => ‘允许管理文章’
inheritedcatid => ‘继承自的频道ID’

pre_portal_category – 门户 文章栏目表
catid => ‘栏目id’
upid => ‘上级栏目id’
catname => ‘标题’
articles => ‘文章数’
allowcomment => ‘是否允许评论’
displayorder => ‘显示顺序’
notinheritedarticle => ‘是否不继承上级文章管理权限’
notinheritedblock => ‘是否不继承上级DIY页面和模块权限’
domain => ‘二级域名’
url => ‘自定义链接’
uid => ‘创建者ID’
username => ‘创建者用户名’
dateline => ‘创建时间’
closed => ‘是否关闭’
shownav => ‘是否在导航显示’
description => ‘分类介绍 SEO描述’
seotitle => ‘SEO 标题’
keyword => ‘SEO 关键字’
primaltplname => ‘列表页原模板地址’
articleprimaltplname => ‘文章页原模板地址’
disallowpublish => ‘是否禁止发布文章’
foldername => ‘文件夹名称’
notshowarticlesummay => ‘文章内容页是否不显示摘要’
perpage => ‘列表每页显示文章数’
maxpages => ‘列表最大分页数’

pre_common_process – 进程锁管理
processid => ‘锁名称的md5’
expiry => ‘锁的过期时间’
extra => ‘锁的附属信息’

pre_common_admincp_group – 后台管理组
cpgroupid => ‘后台组id’
cpgroupname => ‘后台组名称’

pre_common_admincp_member – 后台管理成员
uid => ‘成员uid’
cpgroupid => ‘成员组id’
customperm => ‘自定义管理权限’

pre_common_admincp_perm – 后台权限表
cpgroupid => ‘后台组id’
perm => ‘后台组权限’

pre_common_admincp_session – 后台session表
uid => ‘用户id’
adminid => ‘管理组id’
panel => ‘面板位置’
ip => ‘IP’
dateline => ‘最后动作时间’
errorcount => ‘登录错误次数’
storage => ‘临时内容存储’

pre_portal_attachment – 门户文章附件表
attachid => ‘附件id’
uid => ‘会员id’
dateline => ‘上传时间’
filename => ‘原文件名’
filetype => ‘文件类型’
filesize => ‘文件大小’
attachment => ‘服务器路径’
isimage => ‘是否图片’
thumb => ‘是否是缩率图’
remote => ‘是否远程附件’
aid => ‘文章id’

pre_portal_article_related – 门户相关文章
aid => ‘文章ID’
raid => ‘相关文章ID’
displayorder => ‘显示顺序’

pre_home_specialuser – 特殊用户表
uid => ‘用户ID’
username => ‘用户名’
status => ‘用户类型0为推荐用户1为默认好友’
dateline => ‘设置时间’
reason => ‘操作原因’
opuid => ‘操作者用户ID’
opusername => ‘操作者用户名’
displayorder => ‘显示顺序’

pre_common_district – 地区表
id => ‘地区ID’
name => ‘地区名称’
level => ‘0’ COMMENT ‘地区等级:1,省级;2,市级;3,县级;4,乡镇’
usetype => ‘使用对象:0:都不启用; 1:出生地; 2:居住地; 3:都启用’
upid => ‘上级地区ID’
displayorder => ‘显示顺序’

pre_forum_grouplevel – 群组等级表
levelid => ‘等级ID’
type => ‘类型’
leveltitle => ‘群组等级名称’
creditshigher => ‘该等级的积分上限’
creditslower => ‘该等级的积分下限’
icon => ‘等级图标’
creditspolicy => ‘积分策略’
postpolicy => ‘帖子策略’
specialswitch => ‘特殊开能开关’

pre_forum_groupcreditslog – 群组积分日志表
fid => ‘群组ID’
uid => ‘成员UID’
logdate => ‘日期/20100308’

pre_home_blog_category – 日志系统栏目
catid => ‘栏目id’
upid => ‘上级栏目id’
catname => ‘标题’
num => ‘日志数’
displayorder => ‘显示顺序’

pre_home_album_category – 相册系统栏目
catid => ‘栏目id’
upid => ‘上级栏目id’
catname => ‘标题’
num => ‘相册数’
displayorder => ‘显示顺序’

pre_common_report – 用户举报表
id => ‘记录id’
urlkey => ‘地址md5’
url => ‘地址’
message => ‘举报理由’
uid => ‘会员id’
username => ‘用户名’
dateline => ‘举报时间’
num => ‘举报次数’
opuid => ‘管理员id’
opname => ‘管理员姓名’
optime => ‘处理时间’
opresult => ‘对举报人的奖惩’
fid => ‘论坛id’

pre_common_patch – 漏洞补丁表
serial => ‘漏洞编号’
rule => ‘修补规则’
note => ‘漏洞说明’
status => ‘0’ COMMENT ‘修补状态’
dateline => ‘漏洞发布时间’

pre_forum_collection – 淘帖专辑表
ctid => ‘专辑ID’
uid => ‘用户ID’
username => ‘用户名’
name => ‘专辑名’
dateline => ‘创建时间’
follownum => ‘订阅数’
threadnum => ‘主题数’
commentnum => ‘评论数’
desc => ‘简介’
lastupdate => ‘最后变动时间’
rate => ‘评分’
ratenum => ‘评分次数’
lastpost => ‘最后主题ID’
lastsubject => ‘最后主题标题’
lastposttime => ‘最后主题时间’
lastposter => ‘最后主题发帖者’
lastvisit => ‘创建者最后访问’
keyword => ‘专辑关键词’

pre_forum_collectioncomment – 淘帖评论表
cid => ‘评论ID’
ctid => ‘专辑ID’
uid => ‘用户ID’
username => ‘用户名’
message => ‘评论内容’
dateline => ‘评论时间’
useip => ‘IP地址’
rate => ‘评分’

pre_forum_collectionfollow – 淘帖关注表
uid => ‘用户ID’
username => ‘用户名’
ctid => ‘专辑ID’
dateline => ‘关注时间’
lastvisit => ‘最后访问专辑时间’

pre_forum_collectioninvite – 邀请管理淘专辑
ctid => ‘专辑ID’
uid => ‘邀请合作者ID’
dateline => ‘邀请时间’

pre_forum_collectionrelated – 淘帖主题被收入专辑表
tid => ‘主题ID’
collection => ‘专辑列表’

pre_forum_collectionteamworker – 淘帖合作编辑表
ctid => ‘专辑ID’
uid => ‘合作者ID’
name => ‘专辑名’
username => ‘用户名’
lastvisit => ‘最后访问专辑时间’

pre_forum_collectionthread – 淘帖包含主题表
ctid => ‘专辑ID’
tid => ‘专辑内主题ID’
dateline => ‘主题日期’
reason => ‘推荐理由’

高效的PHP写法技巧详细分析

一.尽量静态化:

如果一个方法能被静态,那就声明它为静态的,速度可提高1/4,甚至我测试的时候,这个提高了近三倍。
当然了,这个测试方法需要在十万级以上次执行,效果才明显。
其实静态方法和非静态方法的效率主要区别在内存:静态方法在程序开始时生成内存,实例方法在程序运行中生成内存,所以静态方法可以直接调用,实例方法要先成生实例,通过实例调用方法,静态速度很快,但是多了会占内存。
任何语言都是对内存和磁盘的操作,至于是否面向对象,只是软件层的问题,底层都是一样的,只是实现方法不同。静态内存是连续的,因为是在程序开始时就生成了,而实例申请的是离散的空间,所以当然没有静态方法快。
静态方法始终调用同一块内存,其缺点就是不能自动进行销毁,而是实例化可以销毁。

 

二.ECHO的效率高于PRINT,因为ECHO没有返回值,PRINT返回一个整型;

测试:
Echo
0.000929 – 0.001255 s (平均 0.001092 seconds)
Print
0.000980 – 0.001396 seconds (平均 0.001188 seconds)
相差8%左右,总体上echo是比较快的。
注意,echo大字符串的时候,如果没有做调整就严重影响性能。使用打开apached的mod_deflate进行压缩或者打开ob_start先将内容放进缓冲区。

三.在循环之前设置循环的最大次数,而非在在循环中;

傻子都明白的道理。

四.销毁变量去释放内存,特别是大的数组;

数组和对象在php特别占内存的,这个由于php的底层的zend引擎引起的,
一般来说,PHP数组的内存利用率只有 1/10, 也就是说,一个在C语言里面100M 内存的数组,在PHP里面就要1G。
特别是在PHP作为后台服务器的系统中,经常会出现内存耗费太大的问题。

五.避免使用像__GET, __SET, __AUTOLOAD等魔术方法;

对于__开头的函数就命名为魔术函数,此类函数都在特定的条件下初访的。总得来说,有下面几个魔术函数
__construct(),__destruct(),__get(),__set(),__unset(),__call(),__callStatic(),__sleep(),__wakeup(),__toString(),__set_state(),__clone(),__autoload()     其实,如果__autoload不能高效的将类名与实际的磁盘文件(注意,这里指实际的磁盘文件,而不仅仅是文件名)对应起来,系统将不得不做大量的文 件是 否存在(需要在每个include path中包含的路径中去寻找)的判断,而判断文件是否存在需要做磁盘I/O操作,众所周知磁盘I/O操作的效率很低,因此这才是使得autoload机 制效率降低的原因。

因此,我们在系统设计时,需要定义一套清晰的将类名与实际磁盘文件映射的机制。这个规则越简单越明确,autoload机制的效率就越高。
结论:autoload机制并不是天然的效率低下,只有滥用autoload,设计不好的自动装载函数才会导致其效率的降低.
所以说尽量避免使用__autoload魔术方法,有待商榷。

六.REQUIERE_ONCE()比较耗资源;

这是因为requiere_once需要判断该文件是否被引用过),所以能不用尽量不用。常用require/include方法避免。

七.在INCLUDES和REQUIRES中使用绝对路径。

如果包含相对路径,PHP会在include_path里面遍历查找文件。
用绝对路径就会避免此类问题,因此解析操作系统路径所需的时间会更少。

八.如果你需要得到脚本执行时的时间,$_SERVER[‘REQUSET_TIME’]优于TIME();

可以想象。一个是现成就可以直接用,一个还需要函数得出的结果。

九.能用PHP内部字符串操作函数的情况下,尽量用他们,不要用正则表达式; 因为其效率高于正则;

没得说,正则最耗性能。
有没有你漏掉的好用的函数?例如:strpbrk()strncasecmp()strpos()/strrpos()/stripos()/strripos()加速 strtr如果需要转换的全是单个字符的时候,
用字符串而不是数组来做 strtr:
<?php
$addr = strtr($addr, “abcd”, “efgh”); // good
$addr = strtr($addr, array(‘a’ => ‘e’, )); // bad
?>
效率提升:10 倍。

10.STR_REPLACE字符替换比正则替换PREG_REPLACE快,但STRTR比STR_REPLACE又快1/4;

另外不要做无谓的替换即使没有替换,str_replace 也会为其参数分配内存。很慢!解决办法:
用 strpos 先查找(非常快),看是否需要替换,如果需要,再替换效率:- 如果需要替换:效率几乎相等,差别在 0.1% 左右。
如果不需要替换:用 strpos 快 200%。

十一.参数为字符串

如果一个函数既能接受数组又能接受简单字符做为参数,例如字符替换函数,并且参数列表不是太长,可以考虑额外写一段替换代码,使得每次传递参数都是一   个字符,而不是接受数组做为查找和替换参数。大事化小,1+1>2;

十二.最好不用@,用@掩盖错误会降低脚本运行速度;

用@实际上后台有很多操作。用@比起不用@,效率差距:3 倍。特别不要在循环中使用@,在 5 次循环的测试中,即使是先用 error_reporting(0) 关掉错误,在循环完成后再打开,都比用@快。

十三.$ROW[‘ID’]比$ROW[ID]速度快7倍

建议养成数组键加引号的习惯;

十四.在循环里别用函数

例如For($x=0; $x < count($array); $x), count()函数在外面先计算;原因你懂的。

十五.在类的方法里建立局部变量速度最快,几乎和在方法里调用局部变量一样快;

十六.建立一个全局变量要比局部变量要慢2倍;

由于局部变量是存在栈中的,当一个函数占用的栈空间不是很大的时候,这部分内存很有可能全部命中cache,这时候CPU访问的效率是很高的。
相反,如果一个函数里既使用了全局变量又使用了局部变量,那么当这两段地址相差较大时,cpu cache需要来回切换,那么效率会下降。
(我理解啊)

十七.建立一个对象属性(类里面的变量)例如($THIS->PROP++)比局部变量要慢3倍;

十八.建立一个未声明的局部变量要比一个已经定义过的局部变量慢9-10倍

十九.声明一个未被任何一个函数使用过的全局变量也会使性能降低(和声明相同数量的局部变量一样)。

PHP可能去检查这个全局变量是否存在;

二十.方法的性能和在一个类里面定义的方法的数目没有关系

因为我添加10个或多个方法到测试的类里面(这些方法在测试方法的前后)后性能没什么差异;

二十一.在子类里方法的性能优于在基类中;

二十二.只调用一个参数并且函数体为空的函数运行花费的时间等于7-8次$LOCALVAR++运算,而一个类似的方法(类里的函数)运行等于大约15次$LOCALVAR++运算;

二十三. 用单引号代替双引号来包含字符串,这样做会更快一些。

因为PHP会在双引号包围的字符串中搜寻变量,单引号则不会。

PHP 引擎允许使用单引号和双引号来封装字符串变量,但是这个是有很大的差别的!使用双引号的字符串告诉 PHP 引擎首先去读取字符串内容,查找其中的变    量,并改为变量对应的值。一般来说字符串是没有变量的,所以使用双引号会导致性能不佳。最好是使用字
符串连接而不是双引号字符串。
BAD:
$output = “This is a plain string”;
GOOD:
$output = ‘This is a plain string’;
BAD:
$type = “mixed”;
$output = “This is a $type string”;
GOOD:
$type = ‘mixed’;
$output = ‘This is a ‘ . $type .’ string’;

二十四.当ECHO字符串时用逗号代替点连接符更快些。

echo一种可以把多个字符串当作参数的“函数”(译注:PHP手册中说echo是语言结构,不是真正的函数,故把函数加上了双引号)。

例如echo $str1,$str2。

二十五.APACHE解析一个PHP脚本的时间要比解析一个静态HTML页面慢2至10倍。

尽量多用静态HTML页面,少用脚本。

二十六.尽量使用缓存,建议用MEMCACHED。

高性能的分布式内存对象缓存系统,提高动态网络应用程序性能,减轻数据库的负担;

也对运算码 (OP code)的缓存很有用,使得脚本不必为每个请求做重新编译。

二十七.使用IP2LONG()和LONG2IP()函数把IP地址转成整型存放进数据库而非字符型。

这几乎能降低1/4的存储空间。同时可以很容易对地址进行排序和快速查找;

二十八.使用CHECKDNSRR()通过域名存在性来确认部分EMAIL地址的有效性

这个内置函数能保证每一个的域名对应一个IP地址;

二十九.使用MYSQL_*的改良函数MYSQLI_*;

三十.试着喜欢使用三元运算符(?:);

三十一.是否需要PEAR

在你想在彻底重做你的项目前,看看PEAR有没有你需要的。PEAR是个巨大的资源库,很多php开发者都知道;

三十二.使用ERROR_REPORTING(0)函数来预防潜在的敏感信息显示给用户。

理想的错误报告应该被完全禁用在php.ini文件里。可是如果你在用一个共享的虚拟主机,php.ini你不能修改,那么你最好添加error_reporting(0)函数,放在每个脚本文件的第一行(或用

require_once()来加载)这能有效的保护敏感的SQL查询和路径在出错时不被显示;

三十三.使用 GZCOMPRESS() 和GZUNCOMPRESS()对容量大的字符串进行压缩(解压)在存进(取出)数据库时。

这种内置的函数使用gzip算法能压缩到90%;

三十四.通过参数变量地址得引用来使一个函数有多个返回值。

你可以在变量前加个“&”来表示按地址传递而非按值传递;

三十五. 完全理解魔术引用和SQL注入的危险。

Fully understand “magic quotes” and the dangers of SQL injection. I’m hoping that most developers reading this are already familiar with SQL injection. However, I list it here because it’s absolutely critical to understand. If you’ve never heard the term before, spend the entire rest of the day googling and reading.

三十六.某些地方使用ISSET代替STRLEN

当操作字符串并需要检验其长度是否满足某种要求时,你想当然地会使用strlen()函数。此函数执行起来相当快,因为它不做任何计算,只返回在zval 结构(C的内置数据结构,用于存储PHP变量)中存储的已知字符串长度。但是,由于strlen()是函数,多多少少会有些慢,因为函数调用会经过诸多步 骤,如字母小写化(译注:指函数名小写化,PHP不区分函数名大小写)、哈希查找,会跟随被调用的函数一起执行。在某些情况下,你可以使用isset() 技巧加速执行你的代码。

(举例如下)
if (strlen($foo) < 5) { echo “Foo is too short”$$ }
(与下面的技巧做比较)
if (!isset($foo{5})) { echo “Foo is too short”$$ }
调用isset()恰巧比strlen()快,因为与后者不同的是,isset()作为一种语言结构,意味着它的执行不需要函数查找和字母小写化。也就是说,实际上在检验字符串长度的顶层代码中你没有花太多开销。

三十七.使用++$I递增

When incrementing or decrementing the value of the variable $i++ happens to be a tad slower then ++$i. This is something PHP specific and does not apply to other languages, so don’t go modifying your C or Java code thinking it’ll suddenly become faster, it won’t. ++$i happens to be faster in PHP because instead of 4 opcodes used for $i++ you only need 3. Post incrementation actually causes in the creation of a temporary var that is then incremented. While preincrementation increases the original value directly. This is one of the optimization that opcode optimized like Zend’s PHP optimizer. It is a still a good idea to keep in mind since not all opcode optimizers perform this optimization and there are plenty of ISPs and servers running without an opcode optimizer.

当执行变量$i的递增或递减时,$i++会比++$i慢一些。这种差异是PHP特有的,并不适用于其他语言,所以请不要修改你的C或Java代码并指望 它们能立即变快,没用的。++$i更快是因为它只需要3条指令(opcodes),$i++则需要4条指令。后置递增实际上会产生一个临时变量,这个临时 变量随后被递增。而前置递增直接在原值上递增。这是最优化处理的一种,正如Zend的PHP优化器所作的那样。牢记这个优化处理不失为一个好主意,因为并 不是所有的指令优化器都会做同样的优化处理,并且存在大量没有装配指令优化器的互联网服务
提供商(ISPs)和服务器。

三十八. 不要随便就复制变量

有时候为了使 PHP 代码更加整洁,一些 PHP 新手(包括我)会把预定义好的变量复制到一个名字更简短的变量中,其实这样做的结果是增加了一倍的内存消耗,只会使程序更加慢。试想一下,在下面的例子 中,如果用户恶意插入 512KB 字节的文字到文本输入框中,这样就会导致 1MB 的内存被消耗!
BAD:
$description = $_POST[‘description’];
echo $description;
GOOD:
echo $_POST[‘description’];

三十九. 使用选择分支语句

switch case好于使用多个if,else if语句,并且代码更加容易阅读和维护。

四十.在可以用FILE_GET_CONTENTS替代FILE、FOPEN、FEOF、FGETS

在可以用file_get_contents替代file、fopen、feof、fgets等系列方法的情况下,尽量用 file_get_contents,因为他的效率高得多!但是要注意file_get_contents在打开一个URL文件时候的PHP版本问题;

四十一.尽量的少进行文件操作,虽然PHP的文件操作效率也不低的;

四十二.优化SELECT SQL语句,在可能的情况下尽量少的进行INSERT、UPDATE操作(在UPDATE上,我被恶批过);

四十三.尽可能的使用PHP内部函数

四十四.循环内部不要声明变量,尤其是大变量:对象

(这好像不只是PHP里面要注意的问题吧?);

四十五.多维数组尽量不要循环嵌套赋值;

四十六.FOREACH效率更高,尽量用FOREACH代替WHILE和FOR循环;

四十七.“用I+=1代替I=I+1。符合C/C++的习惯,效率还高”;

四十八.对GLOBAL变量,应该用完就UNSET()掉;

四十九. 并不是事必面向对象(OOP),面向对象往往开销很大,每个方法和对象调用都会消耗很多内存。

五十. 不要把方法细分得过多,仔细想想你真正打算重用的是哪些代码?

五十一 如果在代码中存在大量耗时的函数,你可以考虑用C扩展的方式实现它们。

五十二. 打开APACHE的MOD_DEFLATE模块,可以提高网页的浏览速度。

(提到过echo 大变量的问题)

五十三. 数据库连接当使用完毕时应关掉,不要用长连接。

五十四. SPLIT比EXPLOADE快

split()
0.001813 – 0.002271 seconds (avg 0.002042 seconds)
explode()
0.001678 – 0.003626 seconds (avg 0.002652 seconds)
Split can take regular expressions as delimiters, and runs faster too. ~23% on average.

利用PHP的urlencode()函数把连接地址encode编码

网上有些链接地址是中文的,中文的连接地址在IE下不能正常访问。一般情况下需要对连接地址进行encode编码。

目前有很多种方法对连接进行编码。可以用javascript进行编码,之前写过这文章。

现在介绍利用PHP对连接进行encode编码。。。

PHP自带了一个 urlencode()函数,可以对连接进行编码。。。

string urlencode ( string $str )

返回字符串,此字符串中除了 -_. 之外的所有非字母数字字符都将被替换成百分号(%)后跟两位十六进制数,空格则编码为加号(+)。此编码与 WWW 表单 POST 数据的编码方式是一样的,同时与 application/x-www-form-urlencoded 的媒体类型编码方式一样。由于历史原因,此编码在将空格编码为加号(+)方面与 RFC1738 编码(参见 rawurlencode())不同。此函数便于将字符串编码并将其用于 URL 的请求部分,同时它还便于将变量传递给下一页