Muse Tryteh Skill book bug

[tomekk228]

Hey,

i found a bug in the System to buy Skillbooks.

If i go to Tryteh and try to buy the Skillbook "Wand Mastery", then i dont get "Wand Mastery". I get the Skillbook "purify".

And if i buy the Book "purify" i get the book "Party heal".

I compile my server from the branches sources and i use the client "evo rose ver 170".

Can somebody help me?

[soccerstar]

are you using the newest csv in the submit code section?

[Drakia]

The latest CSV posted is only 165 as far as I know.

[rl2171]

I will be posting 170 csv's

[tomekk228]

hö? csv?

I'm using Rev 80.

Edit:

Ok, i understand.

I copy the CSV files into my Server folder.

But i get 2 errors from the sql files in navicat:

Line number On/Off | Expand/Contract | Select all

1.  
2. [Err] 1136 - Column count doesn't match value count at row 1
3. [Err] INSERT INTO `skills_data` VALUES ('2839','0','0','14','0','0','0','0','10','100','0|0|0|0|0','0|0|0|0|0','0|0|0','0|0|0','0','0','0','0','0','0','0','0','0','0','0','0','____________: Metal Moldie _Pre_F2P Unique Skill_','60','0','0','0');
4. [Msg] Finished - Unsuccessfully
5. ----------------------------------------------
6.  

and

Line number On/Off | Expand/Contract | Select all

1.  
2. [Err] 1050 - Table 'skills_data' already exists
3. [Err] #WARNING, multiple skillID detected !! 2987
4. #WARNING, multiple skillID detected !! 321
5. #WARNING, multiple skillID detected !! 5587
6. #Don t forget to enter the good values for fields script, value1, gm_aoe
7.  
8. #
9. # Table structure for table 'skills_data'
10. #
11. CREATE TABLE `skills_data` (
12. `id` int(11) NOT NULL default '0',
13. `level` int(11) NOT NULL,
14. `sp` int(11) NOT NULL,
15. `type` int(11) NOT NULL,
16. `range` int(11) NOT NULL,
17. `target` int(11) NOT NULL,
18. `power` int(11) NOT NULL,
19. `duration` int(11) NOT NULL,
20. `mp` int(11) NOT NULL,
21. `success` int(11) NOT NULL,
22. `weapon` varchar(1000) NOT NULL,
23. `class` varchar(1000) NOT NULL,
24. `rskills` varchar(1000) NOT NULL,
25. `lskills` varchar(1000) NOT NULL,
26. `buff1` int(11) NOT NULL,
27. `buffv11` int(11) NOT NULL,
28. `buffv12` int(11) NOT NULL,
29. `buff2` int(11) NOT NULL,
30. `buffv21` int(11) NOT NULL,
31. `buffv22` int(11) NOT NULL,
32. `buff3` int(11) NOT NULL,
33. `buffv31` int(11) NOT NULL,
34. `buffv32` int(11) NOT NULL,
35. `clevel` int(11) NOT NULL,
36. `aoe` tinyint(1) NOT NULL,
37. `aoeradius` int(11) NOT NULL,
38. `skillname` varchar(100) NOT NULL,
39. `cooldown` int(11) NOT NULL default '0',
40. `script` int(11) NOT NULL default '0',
41. `value1` int(11) NOT NULL default '0',
42. `gm_aoe` tinyint(1) NOT NULL default '0',
43. PRIMARY KEY  (`id`)
44. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
45. [Msg] Finished - Unsuccessfully
46. --------------------------------------------------
47.  

[lmame]

Rev 80 uses csv and sql files.

[tomekk228]

Rev 80 uses csv and sql files.

Yet i know that too

But i get 2 navicat errors. Show the edit above this post

[lmame]

I added a post for the skill file, you should see it.
viewtopic.php?f=21&t=1727&p=19172#p19172

It should solve the other error you got (extrat_skills.sql).

[tomekk228]

1°) skills_data.sql:
In ths skill file (skills_data.sql) you got this as first lines:

#WARNING, multiple skillID detected !! 2987
#WARNING, multiple skillID detected !! 321
#WARNING, multiple skillID detected !! 5587
#Don t forget to enter the good values for fields script, value1, gm_aoe

This means there are several skills with the same skillID. It's taken from the STB so what you need to do is to remove some skills that have the same skillID in a way that only one should remain.
Once it's done, delete those lines:

#WARNING, multiple skillID detected !! 2987
#WARNING, multiple skillID detected !! 321
#WARNING, multiple skillID detected !! 5587
#Don t forget to enter the good values for fields script, value1, gm_aoe

And use Navicat (or phpmyadmin or whatever) to execute the .sql file.


2°) extra-skill.sql:
Execute file "extra-skill.sql" AFTER "skills_data.sql".

I dont understand this

where must i delete 2987, 321 and 5587?

[soccerstar]

there will be two or more of those specific numbers, you must delete the extra numbers so that you only have one of each of those numbers.