Znote AAC creating a character.

[Jarhead]

Hi,

I got this error:

string(749) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Asdd', '1', '4', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '1', '5', '5', '2', '', '470', '1', '0', '1604359840', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'skull' in 'field list'

When rename column on database from redskull to skull, I can create character but cannot login to the game.
My server needs to use column "redskull". What I can do about it?

tags (for ppl with same problems): znote cant create character / how to add new column in database / how to make hashed version of password / permission files cache

 

[Cornex]

When rename column on database from redskull to skull, I can create character but cannot login to the game.
My server needs to use column "redskull". What I can do about it?

Create a new skull column.

ALTER TABLE `players` ADD `skull` tinyint(1) NOT NULL DEFAULT '0';

 

[Jarhead]

Thank you!

Now I got problem with accounts... When creating account, in database 'accounts' I can see new accounts, but password is changing for '7c4a8d09ca3762af61e59520943dc26494f8941b'
I need to change this manually to login
How I can fix this?

 

[Cornex]

Thank you!

Now I got problem with accounts... When creating account, in database 'accounts' I can see new accounts, but password is changing for '7c4a8d09ca3762af61e59520943dc26494f8941b'
I need to change this manually to login
How I can fix this?

That is a sha1 hashed version of your password. Open your config.lua and find

encryptionType = "plain"

change to

encryptionType = "sha1"

 

[Jarhead]

It's the same thing?:

passwordType = "plain"

When I changed this to "sha1" all my accounts got hashed password.

 

[HalfAway]

It's the same thing?:

passwordType = "plain"

When I changed this to "sha1" all my accounts got hashed password.

Thats because you should use encrypted passwords, its no need to use plain passwords.

 

[Jarhead]

Ok, now I can login on website and server. Thanks guys!

How do I repair this on main site:

No changelogs submitted.
Warning: fopen(engine/cache/news.cache.php): failed to open stream: Permission denied in /home/ot/www/public_html/engine/function/cache.php on line 91

Warning: fwrite() expects parameter 1 to be resource, boolean given in /home/ot/www/public_html/engine/function/cache.php on line 92

Warning: fclose() expects parameter 1 to be resource, boolean given in /home/ot/www/public_html/engine/function/cache.php on line 93

No news exist.

This lines:

/**
        * Saves the content into its appropriate cache file.
        *
        * @access public
        * @return void
        **/
        public function save() {
            $handle = fopen($this->_file, 'w');
            fwrite($handle, $this->_content);
            fclose($handle);
        }

 

[Cornex]

failed to open stream: Permission denied

You have to set permission to the cache files/folder, something like

sudo chmod -R 755 /home/ot/www/public_html/engine/cache

 

[Jarhead]

You have to set permission to the cache files/folder, something like

sudo chmod -R 755 /home/ot/www/public_html/engine/cache

Hmm, setting this permission doesn't help
Also I got this error on top 5 players widget.

Solved: I just set permisson to all files on folder 'cache' via WinSCP.

Thank you very much @Cornex and @HalfAway. This is a great example of awesome community!