General developer forum

ask insert new user using sql server

 
Picture of efi rochmatika
ask insert new user using sql server
 

Hi Everyone,

I have tried to create a new user with SQL server, btw i use moodle 3.3. my query :

INSERT INTO mdl33_user (username,firstname,lastname,email,maildisplay,confirmed,timecreated,password) 

VALUES(N'fiika2',N'efika',N'tika',N'abc@gmail.com','2','1',N'',N'$2y$10$yTKP54H973/avXn9TalZFeltVHD97/VUGStouFCHpXrv7GxAJtQSK')

INSERT INTO mdl33_context (contextlevel,instanceid,depth,path) VALUES('30','18','0',NULL)

INSERT INTO mdl33_user_preferences (userid,name,value) VALUES('18',N'auth_forcepasswordchange','0')

INSERT INTO mdl33_cache_flags (flagtype,name,value,expiry,timemodified) VALUES(N'userpreferenceschanged','18',N'1',N'',N'')

INSERT INTO mdl33_user_preferences (name,value,userid) VALUES(N'email_bounce_count','1','18')

INSERT INTO mdl33_user_preferences (name,value,userid) VALUES(N'email_send_count','1','18')


But still i can't login with that username and password, please help me

Thank you

 
Average of ratings: -