[g0nz0uk]

Hello,

It has been ages since I have needed to use the admin section of my HLstatsx page and I've forgotten the logon details, is there a way to reset them?

Thanks

[SanKen]

you have access to phpmyadmin ?

UPDATE `DBNAME`.`DBPREFIX_Users` SET `password` = 'e10adc3949ba59abbe56e057f20f883e' WHERE `DBPREFIX_Users`.`username` = 'YOULOGIN';

new password = 123456




if not, I do not know.

[jonnzus]

And if you don't have access to phpmyadmin or to any other "sql-shell" you can try use this, I didn't test it.
Place it to root of your web installation and run.

<?php

include("./config.php");

try {
        $link = new PDO("mysql:host='DB_ADDR';dbname='DB_NAME'", "'DB_USER'", "'DB_PASS'", array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

        $link -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);

} catch (PDOException $e) {
    die($e);
}

$link->prepare(" UPDATE `DBNAME`.`DBPREFIX_Users` SET `password` = 'e10adc3949ba59abbe56e057f20f883e' WHERE `DBPREFIX_Users`.`username` = 'YOULOGIN';");
$link->execute();

if ($link->rowCount() > 0) {
    echo("Password changed!");
} else {
    echo("Something failed!");
}

?>

[bcs16cluj]

Originally Posted by SanKen you have access to phpmyadmin ? UPDATE `DBNAME`.`DBPREFIX_Users` SET `password` = 'e10adc3949ba59abbe56e057f20f883e' WHERE `DBPREFIX_Users`.`username` = 'YOULOGIN'; if not, I do not know.

where to put that in phpmyadmin!?