Why? As far as I know you can't inject php code to connect to a database, and you can't connect to the root from external of the localhost unless you setup your host connection to be % or an IP address.
Having a password will increase security but only for people logged into the vps directly
There are probably other unbuilt changes that are causing the problem. You would have to trace those down. More than likely the RSA keys in the emulator no longer match the SWF.
2 should be fine, but if you start reaching 60+ users you should invest in 4.
RAM is another big one, I haven't calculated how much memory an average room takes up, or an average user but it could get expensive in memory with how much is going on. You might want at least 4GB of RAM.
Go to your Database and look for "emulator_settings". Then look for
' hotelview.halloffame.query '
The code you want for the value is this
SELECT users.id,username,look,amount AS hof_points FROM users INNER JOIN users_currency ON users.id=users_currency.user_id WHERE users_currency.type = 5...
Just remember, Windows manages your threading and each CPU Core = 2 Threads that can execute at the same time. With only one core, you only have 2 threads available to the system. These threads must manage between the emulator connections and windows. On a habbo server, you can have a few...
Well there is 'RP' but it's not related to the R63B tag. RP is for Roleplay it has to do with the emulator and involves users have health, stats, jobs, and it makes the hotel more interactive. It's not a standard hotel where all users can build and create rooms.