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