管理團隊招募中 點此管理團隊申請

《蔚藍的天空總版規》 積分計算方程式

蔚藍的天空「魔力寶貝」 蔚藍的天空「幻想神域」

蔚藍幻境 - Facebook 蔚藍的天空 - Facebook

搜索
查看: 214|回復: 0

[教學] Discuz! X2/3 SLQ 新增用戶,使用未使用的UID

[複製鏈接]

等級: 19- 已有大成

經驗值: 0 / 186

魔法值: 4636 / 4636

生命值: 6%

發表於 2018-1-24 01:45:45 | 顯示全部樓層 |閱讀模式
  • 前往「管理中心」→「站長」→「數據庫」→「升級」。
  • 於「Discuz! 數據庫升級 - 請將數據庫升級語句粘貼在下面:」輸入SQL語法並執行。
    [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"
  • 新增完畢。





◎請嚴格遵守《蔚藍的天空總版規》《Discuz!版規》,以免影響自身權益!
您需要登錄後才可以回帖 登錄 | 立即註冊

本版積分規則