koko24

No, I prefer to make a shop so they can choose, is more easy.
  
Change this line
- shop gm_shop_npc -1,607:1,608:2, to this
 
- shop gm_shop_npc -1,607:1,608:2 After the last item ID you can't use ','

Actually this will be right:
  unsigned int ratio = skillratio + 100*(8 + st->sp/10); //You'd need something like 6K SP to reach this max, so should be fine for most purposes. if (ratio > 60000) ratio = 60000; //We leave some room here in case skillratio gets further increased.

means if you have 6k sp the formula will be:
skillratio + 100*(8+6000/10) = skillratio + 100*608 = skillratio + 60800
 

The CAP is already at 6k
 

i prefer IPB but im using SMF

@@koko24
 
here's the sql
 
SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `ownladder`-- ----------------------------DROP TABLE IF EXISTS `ownladder`;CREATE TABLE `ownladder` ( `guild_id` int(11) NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT '', `currentown` smallint(6) unsigned NOT NULL DEFAULT '0', `highestown` smallint(6) unsigned NOT NULL DEFAULT '0', `owntime` datetime DEFAULT NULL, PRIMARY KEY (`guild_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Records of ownladder-- ------------------------------ ------------------------------ Table structure for `pvpladder`-- ----------------------------DROP TABLE IF EXISTS `pvpladder`;CREATE TABLE `pvpladder` ( `char_id` int(11) NOT NULL DEFAULT '0', `name` varchar(30) NOT NULL DEFAULT '', `streaks` smallint(6) unsigned NOT NULL DEFAULT '0', `kills` smallint(6) unsigned NOT NULL DEFAULT '0', `deaths` smallint(6) unsigned NOT NULL DEFAULT '0', `streaktime` datetime DEFAULT NULL, PRIMARY KEY (`char_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Records of pvpladder-- ----------------------------

did u add any custom weapons or shields? Looks like an encoding issue in the lua file.

Your client is looking for spriteÀΰ£Á·µµµÏµµµÏ_³²_īŸ¸£_īŸ¸£_°Ë±¤ , which means :
For the male (³²) thief (µµµÏ) class, for the weapon sprite (_īŸ¸£_īŸ¸£, which is view ID 16 - WEAPONTYPE_CATARRH), for the weapon trail sprite (_°Ë±¤).
 
Basically, one of your katar weapon is usable by the thief class (normally they're only usable by assassin or assassin cross classes, so I'm assuming you've changed the applicable job field xD). The trail sprite is missing (it is usually required for the default weapon types). For example, the weapon sprite :

 
The trail sprite :

 
I'm not sure when this is actually displayed ingame though... anyway, you can create empty act/spr files and it will fix the issue. Good luck!
thief_trail.rar

I agree with you the damage reduction is not consistent nor near the set configuration at all.

SELECT * FROM 'char' WHERE 'account_id' = account_id;

You can't find info about deleted chars.

https://raw.githubusercontent.com/HerculesWS/Hercules/df1bcac8ef95885019adc1ee03cb2ed9c663c0df/db/re/job_db1.txt
 

Building plugins under Windows
Building plugins under Linux

What this plugin does?:
It allows you to make your chat colored!

New commands:

2 script commands:*color2hex(var) - converts the decimal value into hex, showing the color in #HEXFORMAT (like #FF0000);*setcolor(var) - sets CHAT_COLOR variable to var value;
 
@color "HEX_COLOR";example usage: @color 0x0000FF - will set your chat color to Blue.

Changelist:
version 1.0: initial release

Screenshots:


 
Added other version of chat_color, now it doesn't disguise you and make you targetable, tho you can't see by yourself the color of your chat. That is done this way because the packet 0x2C1 actually was made to be used only by npcs. For you it will look like normal (green in chat, white above the head), others will see the true color(red, for example, if you set your @color 0xFF0000). :-)
 
Example script to set color:

prontera,150,150,6   script  chat color  700,{  mes color2hex(CHAT_COLOR);  mes CHAT_COLOR;  if(select("close:set color value") == 1) close;  input .@a$;  setcolor(axtoi(.@a$));  close;}
chat_color.c
chat_colorA.c

This script will disguise a character as another class similar to theirs, i.e. disguise a Lord Knight as a Rune Knight or vice versa. If they have a mount, it will display.
 
I've kept this to myself for a while, but after seeing the terrible ways people were going about this, I decided to release this to the public. It's loosely based on the script I made for RebirthRO.
 
Get it from GitHub
 

 
Note: You cannot charge for access to this NPC or it's features. For more details see here.

@@koko24, just add countitem() on the script.. example
if (countitem(Apple) >= 1) { mes "Oh an apple, I didn't want it, I just wanted to see one"; close; }