Discuz! X2/3 SLQ 新增用戶,使用未使用的UID
[*]前往「管理中心」→「站長」→「數據庫」→「升級」。
[*]於「Discuz! 數據庫升級 - 請將數據庫升級語句粘貼在下面:」輸入SQL語法並執行。
SET sql_mode='';
INSERT INTO pre_ucenter_members SET secques='', uid ='10', username='Skyey', password='047099adb883dc19616dae0ef2adc5b6', email='skyey@skyey.tw', regip='127.0.0.1', regdate='1387443784', salt='873533';
INSERT INTO pre_ucenter_memberfields SET uid ='10';
INSERT INTO pre_common_member SET uid ='10', username ='Skyey', password ='047099adb883dc19616dae0ef2adc5b6', email ='skyey@skyey.tw', adminid ='0', groupid ='10', regdate ='1387443784', credits ='0', timeoffset ='9999';
INSERT INTO pre_common_member_status SET uid ='10', regip ='127.0.0.1', lastip ='127.0.0.1', lastvisit ='1387443784', lastactivity ='1387443784', lastpost ='0', lastsendmail ='0';
INSERT INTO pre_common_member_profile SET uid ='10';
INSERT INTO pre_common_member_field_forum SET uid ='10';
INSERT INTO pre_common_member_field_home SET uid ='10';
INSERT INTO pre_common_member_count SET uid ='10', extcredits1 ='0', extcredits2 ='0', extcredits3 ='0', extcredits4 ='0', extcredits5 ='0', extcredits6 ='0', extcredits7 ='0', extcredits8 ='0';
註解:
uid ='10' UID為10
username ='Skyey' 用戶名為"Skyey"
password ='047099adb883dc19616dae0ef2adc5b6' 密碼為"123456789"
email ='skyey@skyey.tw' 信箱為"skyey@skyey.tw"
[*]新增完畢。
頁:
[1]