as you can gather from the sql query, there is nothing to edit the nickname so the nickname admin would still be intact.
In phpMyAdmin run the following MySQL queries.
UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='1';
UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='1';
Now Delete user1.php from the cache folder on the server. (This step is important.)
You can also use this to reset other users passwords as well as long as you know the ID. Just change the number 1 in the above instructions to the ID of the member your resetting the password of.
ID 1, which by default is the administrators ID, doesnt mean the nickname is admin, though in most cases users opt for that name. from the query you can ascertain the following, the password is being provided in text form. the query takes the text form, and randomizes SALT as well as md5 hashes the textual characters.
there is nothing on there that edits the nickname.
second part of your question is related to cache, both cache and cache_public are part of the file structure. so you would need to access the area on the server where your files are located, via ftp or some other means. the two directories cache and cache_public are listed alphabetically. there is a file in the cache directory that needs to remain there. the name of the file is .htaccess, leave it there, and just delete everything else that is cached.
in the cache_public, just remove everything that is in there.
Is this cache in PhpMyAdmin or Cpanel i am unable to find cache anywhere? also once i have completed this how do i reset my password & is the login still "admin"
i will look into the forgot.php once i can get into Dolphin Admin
Thanks
Alan
Alan, the sql statement is what i used to reset the password in relation to the userID.
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support