look out

[cookiegruemel]

I have look me with the admin account out (I del it) :( is there a way to recover?

[ICTKashif]

please run the following commands in MySQL

#> mysql
USE ictfax;
INSERT INTO usr(username, passwd, first_name, last_name, email, phone, active, created_by) VALUES ('admin', MD5('helloAdmin'), 'System', 'Administrator', '[email protected]', '111111', 1, 1);
SELECT @usrId := LAST_INSERT_ID();
SELECT @roleId := role_id FROM role WHERE name='admin';
INSERT INTO user_role VALUES (@roleId, @usrId);
SELECT @roleId := role_id FROM role WHERE name='user';
INSERT INTO user_role VALUES (@roleId, @usrId);