Discuz!NT dnt_createuser存储过程是否有问题?
INSERT INTO [dnt_users]([username],[nickname], [password], [secques], [gender], [adminid], [groupid], [groupexpiry], [extgroupids], [regip], [joindate], [lastip], [lastvisit], [lastactivity], [lastpost], [lastpostid], [lastposttitle], [posts], [digestposts], [oltime], [pageviews], [credits], [extcredits1], [extcredits2], [extcredits3], [extcredits4], [extcredits5], [extcredits6], [extcredits7], [extcredits8], [avatarshowid], [email], [bday], [sigstatus], [tpp], [ppp], [templateid], [pmsound], [showemail], [newsletter], [invisible], [newpm], [accessmasks]) VALUES(@username,@nickname, @password, @secques, @gender, @adminid, @groupid, @groupexpiry, @extgroupids, @regip, @joindate, @lastip, @lastvisit, @lastactivity, @lastpost, @lastpostid, @lastposttitle, @posts, @digestposts, @oltime, @pageviews, @credits, @extcredits1, @extcredits2, @extcredits3, @extcredits4, @extcredits5, @extcredits6, @extcredits7, @extcredits8, @avatarshowid, @email, @bday, @sigstatus, @tpp, @ppp, @templateid, @pmsound, @showemail, @newsletter, @invisible, @newpm, @accessmasks)
SELECT SCOPE_IDENTITY() AS 'userid'
SET @uid = SCOPE_IDENTITY()
IF @@ERROR=0
BEGIN
UPDATE [dnt_statistics] SET [totalusers]=[totalusers] + 1,[lastusername]=@username,[lastuserid]=@uid
END
INSERT INTO dnt_userfields
([uid],[website],[icq],[qq],[yahoo],[msn],[skype],[location],[customstatus],[medals],[bio],[signature],[sightml],[authstr],[realname],[idcard],[mobile],[phone])
VALUES
(@uid,@website,@icq,@qq,@yahoo,@msn,@skype,@location,@customstatus,@medals,@bio,@signature,@sightml,@authstr,@realname,@idcard,@mobile,@phone)
GO
每次新注册一个帐号都没办法登陆因为用户注册的时候只往[dnt_users]插了一条数据而[dnt_userfields]用户的头像表并没有数据因为它是根据[dnt_users]的id来的 只有建下一用户的时候才会有数据 希望大家解决一下
