您的位置:首页 > 帝国cms教程

【帝国cms】【sql语句】修改会员的登录次数

2020-03-24 14:44:11 帝国cms教程 151

如何修改,设置会员的登录次数,jiuhecai的sql语句大全会帮助您的 。
会员表-
会员副表:enewsmemberadd
字段名称:loginnum

Array
(
[userid] => 1
[truename] =>
[oicq] =>
[msn] =>
[mycall] =>
[phone] =>
[address] =>
[zip] =>
[spacestyleid] => 1
[homepage] =>
[saytext] =>
[pany] =>
[fax] =>
[userpic] =>
[spacename] =>
[spacegg] =>
[viewstats] => 380
[regip] => 127.0.0.1
[lasttime] => 1599040827
[lastip] => 118.73.57.62
[loginnum] => 28
[regipport] =>
[lastipport] => 20716
)

容易得到,修改的sql语句为:
update[!db.pre!]enewsmemberaddset loginnum='0' where 1=1;

相关推荐