Kenpachi

And in my opinion many people wants them to work again.

I think it should be a conf which by default allows to use @commands when dead. (Î never tried it but on official servers GMs probably are allowed to use commands when dead.)

Custom feature which wont work in every case. -> No, I don't like it. And this is kind of related: unique item_id discussion

+1

Your talking about item type 10, aren't you? (Item type 11 is useable with delayed consmption...) And BTW; What do we think about what? I don't get the point. xD

I'd never use a software which makes so much work just for installing it...

AFAIK there is no good solution to version tables. Actually it's not required since the map server will throw an error if the DB layout doesn't match with what he tries to do. +1

Maybe I'm too sleepy, but why do we need such a command? You can simply do a SQL query to get a characters IP...

+1

From a guy that puts in a UNIQUE constraint for a 3rd party tool, that should handle the business logic. Well, that's something our application can't control so there was no other choice. Sure, I'll work on it in next days.

Dude, school knowledge is one thing, experience another... Redundancy isn't always a bad thing. It can boost the performance and useablity. I'm working with SQL databases everyday and know many companies which do so. Neither me nor one of those campanies uses the foreign key enigine which is shipped with the SQL server. Why this? Pretty simple... Your application should manage the data and the processes, not the SQL server. The SQL server is just a stupid data holding backend which should be replaceable in no time. When you pack it with tons of business logic that's nearly impossible...

Actually it's not required excepting they are included in double quotes themself.

Exactly as in the TXT version. The only difference to item_db.sql is that it's stored in a VARCHAR field instead of INT. Finally done in r16523 and r16524.

Done in r16513. http://rathena.org/board/tracker/issue-6349-sql-file-syntax-error

Thanks xazax. I'll convert the TXT DBs later today.

Great, darling!

In ../src/char/char.c find: //Insert the new char entry to the database if( SQL_ERROR == Sql_Query(sql_handle, "INSERT INTO `%s` (`account_id`, `char_num`, `name`, `zeny`, `str`, `agi`, `vit`, `int`, `dex`, `luk`, `max_hp`, `hp`," "`max_sp`, `sp`, `hair`, `hair_color`, `last_map`, `last_x`, `last_y`, `save_map`, `save_x`, `save_y`) VALUES (" "'%d', '%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d','%d', '%d','%d', '%d', '%s', '%d', '%d', '%s', '%d', '%d')", char_db, sd->account_id , slot, esc_name, start_zeny, str, agi, vit, int_, dex, luk, (40 * (100 + vit)/100) , (40 * (100 + vit)/100 ), (11 * (100 + int_)/100), (11 * (100 + int_)/100), hair_style, hair_color, mapindex_id2name(start_point.map), start_point.x, start_point.y, mapindex_id2name(start_point.map), start_point.x, start_point.y) ) { Sql_ShowDebug(sql_handle); return -2; //No, stop the procedure! } and replace with: //Insert the new char entry to the database if( SQL_ERROR == Sql_Query(sql_handle, "INSERT INTO `%s` (`account_id`, `char_num`, `name`, `zeny`, `str`, `agi`, `vit`, `int`, `dex`, `luk`, `max_hp`, `hp`," "`max_sp`, `sp`, `hair`, `hair_color`, `last_map`, `last_x`, `last_y`, `save_map`, `save_x`, `save_y`, `class`) VALUES (" "'%d', '%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d','%d', '%d','%d', '%d', '%s', '%d', '%d', '%s', '%d', '%d', 4001)", char_db, sd->account_id , slot, esc_name, start_zeny, str, agi, vit, int_, dex, luk, (40 * (100 + vit)/100) , (40 * (100 + vit)/100 ), (11 * (100 + int_)/100), (11 * (100 + int_)/100), hair_style, hair_color, mapindex_id2name(start_point.map), start_point.x, start_point.y, mapindex_id2name(start_point.map), start_point.x, start_point.y) ) { Sql_ShowDebug(sql_handle); return -2; //No, stop the procedure! } and recompile. (untested)

short class_; declares a variable calles class_ with data type short. short is alike int but with a smaller range. (CLICK) And about the problem itself: Maybe I misunderstood you. Are you talking about the stat points that are used to raise stats or about the amount of STR/AGI/VIT/etc?

And where do you need support?

Das item mit der von dir eingegebenen ID existiert dann nicht. Hast du es in die - für deinen Server - richtige DB eingefügt? (pre-re/re)

Open your skill_require_db.txt (../db/pre-re and/or ../db/re) and find this line: 356,0,0,50,0,0,0,3,0,0,none,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 //LK_PARRYING#ƒpƒŠƒCƒ“ƒO# Field #8 (the 3) contains the allowed weapon types. Allowing two-handed and one-handed swords would look lke: 356,0,0,50,0,0,0,2:3,0,0,none,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 //LK_PARRYING#ƒpƒŠƒCƒ“ƒO# When using a one handed sword? Always? Please give details...

In src/common/mmo.h The is a struct called mmo_charstatus which hold the stats of a character. The variables are signed short, so a maximum of 32767 is just fine. I did a SVN blame from revision 15000 up to head revision. Those variables weren't touched....

../src/map/battle.c Check the #ifdef RENEWAL switches.

That's not handled in the source. The client select a sprite that belongs to the class. I'd replace the baby monk sprite with the normal monk sprite. ~Moving to Graphics Support.~

../src/map/battle.c -> int battle_calc_damage(struct block_list *src,struct block_list *bl,struct Damage *d,int damage,int skill_num,int skill_lv)