ZNote Acc - Error creating character

[Helliot1]

Hello, I was configuring my server, and my skills are renamed, sword=meele, shield=defending.
I changed in all files in my archives. But when I go create a new character I get a error, somebody know how to resolve it ?!

string(744) "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`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing`) VALUES ('Helliot', '1', '2', '1', '1', '250', '250', '0', '68', '76', '78', '58', '1', '0', '10', '0', '0', '0', '0', '1', '1017', '1015', '6', '', '0', '1', '0', '3174480879', '1', '0', '0', '0', '0', '0', '1', '1', '', '1', '1', '', '1');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Unknown column 'skill_sword' in 'field list'

Thanks!

 

[secondlife]

First, why is the columns exists in players?
U have renamed
skill_sword to skill_meele in .sql files or ingame(client/php files in site)??


try this:

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`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_meele`, `skill_axe`, `skill_dist`, `skill_defending`, `skill_fishing`) VALUES ('Helliot', '1', '2', '1', '1', '250', '250', '0', '68', '76', '78', '58', '1', '0', '10', '0', '0', '0', '0', '1', '1017', '1015', '6', '', '0', '1', '0', '3174480879', '1', '0', '0', '0', '0', '0', '1', '1', '', '1', '1', '', '1');

 

[Helliot1]

First, why is the columns exists in players?
U have renamed
skill_sword to skill_meele in .sql files or ingame(client/php files in site)??


try this:

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`, `lastlogout`, `blessings`, `balance`, `skill_fist`, `skill_club`, `skill_meele`, `skill_axe`, `skill_dist`, `skill_defending`, `skill_fishing`) VALUES ('Helliot', '1', '2', '1', '1', '250', '250', '0', '68', '76', '78', '58', '1', '0', '10', '0', '0', '0', '0', '1', '1017', '1015', '6', '', '0', '1', '0', '3174480879', '1', '0', '0', '0', '0', '0', '1', '1', '', '1', '1', '', '1');

I have renamed it in the twice options!!
But when I go create a new character they say that don't exist the "Skill_Sword" but i have renamed all files, I checked it a lot of times.
I think need change the way to createcharacter, but I don't know where is It.

 

[secondlife]

@Helliot1
I recommend you do not rename sql files to avoid new problems, just modify php pages and your client according to your interest.

Ex:
Ranking in ZNOTE,
go to highscores.php and modify:

function skillName($type) {
$types = array(
1 => "Club",
2 => "Sword",
....

to

function skillName($type) {
$types = array(
1 => "Club",
2 => "Melee",
....

and:

<option value="2" <?php if ($type == 2) echo "selected"; ?>>Sword</option>

to

<option value="2" <?php if ($type == 2) echo "selected"; ?>>Melee</option>

Understand?
You do not need to modify your sql file for make this.
This will avoid major problems in the future.

I wish success for you!

 

[Helliot1]

@Helliot1
I recommend you do not rename sql files to avoid new problems, just modify php pages and your client according to your interest.

Ex:
Ranking in ZNOTE,
go to highscores.php and modify:

function skillName($type) {
$types = array(
1 => "Club",
2 => "Sword",
....

to

function skillName($type) {
$types = array(
1 => "Club",
2 => "Melee",
....

and:

<option value="2" <?php if ($type == 2) echo "selected"; ?>>Sword</option>

to

<option value="2" <?php if ($type == 2) echo "selected"; ?>>Melee</option>

Understand?
You do not need to modify your sql file for make this.
This will avoid major problems in the future.

I wish success for you!

Yes, I understand, thought that just renaming, would not bring problems
But anyway, thank you !!

 

[secondlife]

@Helliot1
In fact, it is possible to rename and do works fine, however, all the scripts you find for your webpart were created with the common queries, understand? you will have the job of adapting everything to your site.
In my opinion, unnecessary work
Use the common queries and everything will work fine!
If you need help with something, contact me in pm.

Hugs!

 

[Helliot1]

@Helliot1
In fact, it is possible to rename and do works fine, however, all the scripts you find for your webpart were created with the common queries, understand? you will have the job of adapting everything to your site.
In my opinion, unnecessary work
Use the common queries and everything will work fine!
If you need help with something, contact me in pm.

Hugs!

Thanks, but the best way that I found is to create a table to "skill_sword" just to have this table, because the "skill_melee" will works right the same way!!