RevCMS Important Fix.

See http://forum.ragezone.com/f353/revcm...6/#post8127124 for extensive information about this issue.

Another easy fix is using this 2 query's:

PHP Code:

---

ALTER TABLE `users` MODIFY COLUMN `seckey` DEFAULT '1234';

Update users set seckey = '1';
if the first one is not working use this one:
ALTER TABLE `users`
MODIFY COLUMN `seckey`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '1234' ; 


---

PS YOU DONT NEED TO FIX THIS IF YOU HAVE A SECKEY! (Why number 1 because you never can hash something with md5 and get 1 as result :P md5 is always more as 10+ characters

Edit ---
updated the query's
Peaple just reaplace
Heres what you need to do to fix it with methode 1

search:

PHP Code:

---

final public function forgotten()
    {
        global $template, $_CONFIG, $core;
        
        if(isset($_POST['forgot']))
        {
        
            $template->form->setData();
            unset($template->form->error);
            
            if($this->nameTaken($template->form->for_username))
            {
                if(strlen($template->form->for_password) > 6)
                {
                    if($this->getInfo($this->getID($template->form->for_username), 'seckey') == $core->hashed($template->form->for_key))
                    {
                        $this->updateUser($this->getID($template->form->for_username), 'password', $core->hashed($template->form->for_password));
                        $template->form->error = 'Account recovered! Go <b><a href="index">here</a></b> to login!';
                        return;
                    }
                    else
                    {
                        $template->form->error = 'Secret key is incorrect';
                        return;
                    }
                }
                else
                {
                    $template->form->error = 'Password must have more than 6 characters.';
                    return;
                }
            }
            else
            {
                $template->form->error = 'Username does not exist';
                return;
            }
        }
    } 


---

Replace it with:

PHP Code:

---

    final public function forgotten()
{
} 


---

thats the only thing <_< what you need to edit

maybe some rep for me and Jamal because we fixed it?

You sir, are a fucking legend. Big like from me and rep.

Even if I don't use RevCMS , this is very usefull for those that aren't able to fix this ;)

Nice release dude (y) !

Quote:

---

Originally Posted by PSK

I'm getting white page when deleting the whole final public function forgotten() function?

---

Look mate you forgot something :

Go to class.core.php and delete everything that looks like this case "forgot":

DELETE :
case "forgot":
$users->forgotten();
break;

DELETE :
case "forgot":
header('Location: '.$_CONFIG['hotel']['url'].'/me');
exit;
break;

Please don't ask help in this thread. Follow the steps provide and if not working properly either contact the OP or post in the Habbo Hotel Help section here: http://forum.ragezone.com/f333

Keep in mind anyone breaking the rules will get warned and / or infracted.

app\interfaces\interface.users.php

Delete

public function forgotten();

ALTER TABLE users ADD COLUMN seckey VARCHAR( '999' );
Update users set seckey = '1';

fixed

Quote:

---

Originally Posted by ImNotSatan

app\interfaces\interface.users.php

Delete

public function forgotten();

---

No shit sherlock..
its not that we already said that 4 times in this theard... @ImNotSatan under me
If you delete the function then you delete all of the forgot shit.. because you otherwise get errors
Emptying does nothing to the cms because it just returns nothing Just the 404 page.

Quote:

---

Originally Posted by Spot Ify

No shit sherlock..
its not that we already said that 4 times in this theard...

---

Nah, you told them to just empty,it why not fully delete it...?

Edit well, its fine for me...

If I run the query I get this error
[SQL]ALTER TABLE `users` MODIFY COLUMN `seckey` DEFAULT '1234';
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DEFAULT '1234'' at line 1

Code:

---

ALTER TABLE `users` ADD `seckey` VARCHAR(999) NOT NULL

---

didn't help.

Quote:

---

Originally Posted by DutchenL

didn't help.

---

Well it should have, or just do this

Code:

---

ALTER TABLE `users` ADD `seckey` VARCHAR(999)

---

basically the "seckey" is inexistent, with the above you would add it and it should continue without errors.

Please post your output after doing that.

[SQL]ALTER TABLE `users` ADD `seckey` VARCHAR(999)


[Err] 1060 - Duplicate column name 'seckey'