This for the hash type md5_user which you can find in your site.ini. If you use another hash type you need to change the password_hash and the hash_type number
$hash_type_nr = 2;
$password_hash = md5('YOUR LOGIN' . "\n" . 'YOUR PASSWORD'); $query = "INSERT INTO ezuser VALUES(USER_OBJECT_ID, 14, 'YOUR EMAIL', 'YOUR LOGIN', $password_hash, $hash_type_nr)";
(Replace all words in capitals with your settings)
If you do not have the user content object anymore I don't know what to do.
Remember to make a backup of your database before doing this.
Yes, you are right - the user_object_id was to much... I really shouldn't post something when I am busy with other stuff. Ok, hopefully I will be a bit more careful now.
I do not know where all the user relevant data is stored and how you lost your admin user, so I am not sure how to solve your problem. Check whether the user is enabled (table ezuser_setting). Enable full debug output and check whether you can see anything in there. Make sure that the object with the id 14 still exists (just fetch it in a template). Make sure the user is a child of the admin user group.
What happens when you try to login? Do you get a message about the password being wrong, does it tell you about wrong permissions or what?
Also have a look at this post - this might help you to create a new admin user if nothing else works. http://ez.no/community/forum/developer/loosing_administrator_user/re_loosing_administrator_user__7