Rudra

September 14, 2022

5 hours ago, mechannical said:

In src/map/battle.cpp find for:
{ "max_body_style", &battle_config.max_body_style, 1, 0, SHRT_MAX, },

Change to:

{ "max_body_style", &battle_config.max_body_style, 4, 0, SHRT_MAX, },

Recompile and try again, please

And, what script command are you using to open this dress room?

this:

opendressroom(1);

thanks i will try

September 13, 2022

I'm having a problem, I'm trying to implement new class visuals and I'm not getting it

data\luafiles514\lua files\dressroom\jobdresslist.lub

_DressList_f = {
    [4009] = {
        { "(0) Original", 0 },
        { "(1) 2-1/2-2", 1 },
        { "(2) 3rd kRO", 2 },
        { "(3) 3rd jRO", 3 },
        { "(4) 4th", 4 }
    },

I added the referring sprites for each folder

data\sprite\ÀÎ°£Á·\¸öÅë\¿©\costume_1 == ÇÏÀÌÇÁ¸®_¿©_1
data\sprite\ÀÎ°£Á·\¸öÅë\¿©\costume_2 == ÇÏÀÌÇÁ¸®_¿©_2
data\sprite\ÀÎ°£Á·\¸öÅë\¿©\costume_3 == ÇÏÀÌÇÁ¸®_¿©_3
data\sprite\ÀÎ°£Á·\¸öÅë\¿©\costume_4 == ÇÏÀÌÇÁ¸®_¿©_4

/rAthena/conf/battle/client.conf

min_body_style: 0
max_body_style: 4

and only the first option is working is not switching to the other sprites.

do you know what's wrong?

lol2.png.dd86e115b34c7f4bf354bbf25cdfc437.png

thanks!

August 27, 2022

9 minutes ago, Tokei said:
Heya,

Well, the first step would be converting your SQL database to CSV/text format. You can do that by querying the following:
// for db/re/item_db.txt
select `id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk:matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, CONCAT('{', IFNULL(`script`, ''), '}'), CONCAT('{', IFNULL(`equip_script`, ''), '}'), CONCAT('{', IFNULL(`unequip_script`, ''), '}') from `item_db_re`
I'm using HeidiSQL, but from there... right-click a row > Export grid rows >
- Output format: Delimited text
- Row selection: Complete
- Options:
- Uncheck "Include column names"
- Field separator: ","
- NULL value: "" (leave empty)

Then you should have a normal item_db.txt output. Paste the output to your item_db.txt file in the db folder, do the same for the import folder using the other SQL table. From there, you can run the csv2yaml tool (just make sure there is no item_db.yml files, otherwise it won't actually attempt to do the conversion).

Well, I see that the structure you sent is different from the current one in rathena:

  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `name_aegis` varchar(50) NOT NULL DEFAULT '',
  `name_english` varchar(100) NOT NULL DEFAULT '',
  `type` varchar(20) DEFAULT NULL,
  `subtype` varchar(20) DEFAULT NULL,
  `price_buy` mediumint(8) unsigned DEFAULT NULL,
  `price_sell` mediumint(8) unsigned DEFAULT NULL,
  `weight` smallint(5) unsigned DEFAULT NULL,
  `attack` smallint(5) unsigned DEFAULT NULL,
  `defense` smallint(5) unsigned DEFAULT NULL,
  `range` tinyint(2) unsigned DEFAULT NULL,
  `slots` tinyint(2) unsigned DEFAULT NULL,
  `job_all` tinyint(1) unsigned DEFAULT NULL,
  `job_acolyte` tinyint(1) unsigned DEFAULT NULL,
  `job_alchemist` tinyint(1) unsigned DEFAULT NULL,
  `job_archer` tinyint(1) unsigned DEFAULT NULL,
  `job_assassin` tinyint(1) unsigned DEFAULT NULL,
  `job_barddancer` tinyint(1) unsigned DEFAULT NULL,
  `job_blacksmith` tinyint(1) unsigned DEFAULT NULL,
  `job_crusader` tinyint(1) unsigned DEFAULT NULL,
  `job_gunslinger` tinyint(1) unsigned DEFAULT NULL,
  `job_hunter` tinyint(1) unsigned DEFAULT NULL,
  `job_knight` tinyint(1) unsigned DEFAULT NULL,
  `job_mage` tinyint(1) unsigned DEFAULT NULL,
  `job_merchant` tinyint(1) unsigned DEFAULT NULL,
  `job_monk` tinyint(1) unsigned DEFAULT NULL,
  `job_ninja` tinyint(1) unsigned DEFAULT NULL,
  `job_novice` tinyint(1) unsigned DEFAULT NULL,
  `job_priest` tinyint(1) unsigned DEFAULT NULL,
  `job_rogue` tinyint(1) unsigned DEFAULT NULL,
  `job_sage` tinyint(1) unsigned DEFAULT NULL,
  `job_soullinker` tinyint(1) unsigned DEFAULT NULL,
  `job_stargladiator` tinyint(1) unsigned DEFAULT NULL,
  `job_supernovice` tinyint(1) unsigned DEFAULT NULL,
  `job_swordman` tinyint(1) unsigned DEFAULT NULL,
  `job_taekwon` tinyint(1) unsigned DEFAULT NULL,
  `job_thief` tinyint(1) unsigned DEFAULT NULL,
  `job_wizard` tinyint(1) unsigned DEFAULT NULL,
  `class_all` tinyint(1) unsigned DEFAULT NULL,
  `class_normal` tinyint(1) unsigned DEFAULT NULL,
  `class_upper` tinyint(1) unsigned DEFAULT NULL,
  `class_baby` tinyint(1) unsigned DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `location_head_top` tinyint(1) unsigned DEFAULT NULL,
  `location_head_mid` tinyint(1) unsigned DEFAULT NULL,
  `location_head_low` tinyint(1) unsigned DEFAULT NULL,
  `location_armor` tinyint(1) unsigned DEFAULT NULL,
  `location_right_hand` tinyint(1) unsigned DEFAULT NULL,
  `location_left_hand` tinyint(1) unsigned DEFAULT NULL,
  `location_garment` tinyint(1) unsigned DEFAULT NULL,
  `location_shoes` tinyint(1) unsigned DEFAULT NULL,
  `location_right_accessory` tinyint(1) unsigned DEFAULT NULL,
  `location_left_accessory` tinyint(1) unsigned DEFAULT NULL,
  `location_costume_head_top` tinyint(1) unsigned DEFAULT NULL,
  `location_costume_head_mid` tinyint(1) unsigned DEFAULT NULL,
  `location_costume_head_low` tinyint(1) unsigned DEFAULT NULL,
  `location_costume_garment` tinyint(1) unsigned DEFAULT NULL,
  `location_ammo` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_armor` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_weapon` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_shield` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_shoes` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_right_accessory` tinyint(1) unsigned DEFAULT NULL,
  `location_shadow_left_accessory` tinyint(1) unsigned DEFAULT NULL,
  `weapon_level` tinyint(1) unsigned DEFAULT NULL,
  `armor_level` tinyint(1) unsigned DEFAULT NULL,
  `equip_level_min` tinyint(3) unsigned DEFAULT NULL,
  `equip_level_max` tinyint(3) unsigned DEFAULT NULL,
  `refineable` tinyint(1) unsigned DEFAULT NULL,
  `view` smallint(5) unsigned DEFAULT NULL,
  `alias_name` varchar(50) DEFAULT NULL,
  `flag_buyingstore` tinyint(1) unsigned DEFAULT NULL,
  `flag_deadbranch` tinyint(1) unsigned DEFAULT NULL,
  `flag_container` tinyint(1) unsigned DEFAULT NULL,
  `flag_uniqueid` tinyint(1) unsigned DEFAULT NULL,
  `flag_bindonequip` tinyint(1) unsigned DEFAULT NULL,
  `flag_dropannounce` tinyint(1) unsigned DEFAULT NULL,
  `flag_noconsume` tinyint(1) unsigned DEFAULT NULL,
  `flag_dropeffect` varchar(20) DEFAULT NULL,
  `delay_duration` bigint(20) unsigned DEFAULT NULL,
  `delay_status` varchar(30) DEFAULT NULL,
  `stack_amount` smallint(5) unsigned DEFAULT NULL,
  `stack_inventory` tinyint(1) unsigned DEFAULT NULL,
  `stack_cart` tinyint(1) unsigned DEFAULT NULL,
  `stack_storage` tinyint(1) unsigned DEFAULT NULL,
  `stack_guildstorage` tinyint(1) unsigned DEFAULT NULL,
  `nouse_override` smallint(5) unsigned DEFAULT NULL,
  `nouse_sitting` tinyint(1) unsigned DEFAULT NULL,
  `trade_override` smallint(5) unsigned DEFAULT NULL,
  `trade_nodrop` tinyint(1) unsigned DEFAULT NULL,
  `trade_notrade` tinyint(1) unsigned DEFAULT NULL,
  `trade_tradepartner` tinyint(1) unsigned DEFAULT NULL,
  `trade_nosell` tinyint(1) unsigned DEFAULT NULL,
  `trade_nocart` tinyint(1) unsigned DEFAULT NULL,
  `trade_nostorage` tinyint(1) unsigned DEFAULT NULL,
  `trade_noguildstorage` tinyint(1) unsigned DEFAULT NULL,
  `trade_nomail` tinyint(1) unsigned DEFAULT NULL,
  `trade_noauction` tinyint(1) unsigned DEFAULT NULL,
  `script` text,
  `equip_script` text,
  `unequip_script` text,

But if I convert to CSV and check the options would it work?

August 27, 2022

8 hours ago, Chaos92 said:

rathena are still using .sql for those files in sql-files as monster database and item database and didnt use yml for that.

this files usually being used in fluxcp as information for itemdb and monster db. this changes that you meant ?

No, rAthena still uses item_db.sql item_db_equip.sql item_db_etc.sql, but it is optional.

You can make modification here:

rAthena/conf/inter_athena.conf

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

I currently use SQL mode but I want to revert back to using via rAthena/db folder.

But I don't know if there is any tool for such a conversion. Does anyone know if there is?

August 26, 2022

1 hour ago, Chaos92 said:

Recompile and you should see the converter, csv2yaml

This video teaches for item_db.txt and mob_db.txt files.

What I'm wanting is to convert item_db.sql and mob_db.sql files to .yml

August 26, 2022

Hello is it possible to convert item_db.sql mob_db.sql to item_db.yml mob_db.yml?

I made a lot of changes in my .sql database, but I'm wanting to return to using the db folder

August 21, 2022

I'm trying to use the modifications in a clean version and it's giving me this error in the console:

Added via git apply command, except pcc.hpp file which returned error, so manually added.

March 26, 2018

thanks!

March 25, 2018

Is there any way to create an achievement when finishing a quest? if yes, what would the group and condition look like?

thanks!

February 3, 2014

How do I add, only for registered accounts an item in your inventory?

command in phpmyadmin please

January 8, 2014

what is problem?

Trying to find file "data/sprite/�ΰ���/����/��/���ؽ�ũ�ν�_��.spr"...
File not found in data folder.
Searching in GRFs...
Loading GRF file "data.grf"...
Search in GRF "data.grf", fail.
File not found...
Trying to find file "data/sprite/�ΰ���/����/��/���ؽ�ũ�ν�_��.act"...
File not found in data folder.
Searching in GRFs...
Search in GRF "data.grf", fail.
File not found...
Trying to find file "data/sprite/�ΰ���/�Ӹ���/��/1_��.spr"...
File not found in data folder.
Searching in GRFs...
Search in GRF "data.grf", fail.
File not found...
Trying to find file "data/sprite/�ΰ���/�Ӹ���/��/1_��.act"...
File not found in data folder.
Searching in GRFs...
Search in GRF "data.grf", fail.
File not found...

help me

Block a number of group members on a map · October 31, 2013

THANKS

Block a number of group members on a map · October 30, 2013

I'm looking for some time how to block on a given map, a number of members of a party.

Anyone know how to do this?

I wanted as a portal

I got make a restricting the amount of guild members, but really wanted to group

function	script	woePortal	{

	if (getmapguildusers (getarg(1), getcharid(2)) < getarg(0))
	warp getarg(1), getarg(2), getarg(3);

	else
		dispbottom "There is " + getarg(0) + " member" + (getarg(0) != 1 ? "s" : "") + " of this guild in the castle.";
	end;

}

//= Arunafeltz
aru_gld,155,274,0	script	#arug_cas01	45,2,2,{ callfunc ("woePortal", 1, "arug_cas01", 275, 93); }
aru_gld,78,47,0	script	#arug_cas02	45,2,2,{ callfunc ("woePortal", 1, "arug_cas02", 139, 31); }
aru_gld,68,150,0	script	#arug_cas03	45,2,2,{ callfunc ("woePortal", 1, "arug_cas03", 141, 45); }
aru_gld,289,347,0	script	#arug_cas04	45,2,2,{ callfunc ("woePortal", 2, "arug_cas04", 141, 45); }
aru_gld,287,107,0	script	#arug_cas05	45,2,2,{ callfunc ("woePortal", 3, "arug_cas05", 141, 45); }

//= Schwaltzvalt
sch_gld,293,90,0	script	#schg_cas01	45,2,2,{ callfunc ("woePortal", 1, "schg_cas01", 119, 8); }
sch_gld,288,258,0	script	#schg_cas02	45,2,2,{ callfunc ("woePortal", 1, "schg_cas02", 339, 78); }
sch_gld,97,183,0	script	#schg_cas03	45,2,2,{ callfunc ("woePortal", 1, "schg_cas03", 337, 330); }
sch_gld,137,98,0	script	#schg_cas04	45,2,2,{ callfunc ("woePortal", 2, "schg_cas04", 119, 8); }
sch_gld,65,315,0	script	#schg_cas05	45,2,2,{ callfunc ("woePortal", 3, "schg_cas05", 119, 8); }

sorry my bad english )=

February 17, 2013

@teaga

http://rathena.org/wiki/Favorite_tab#Msgstringtable

there are alot topic discussed this...

pardon my ignorance.

February 17, 2013

I tried to change and was not. someone help me?

February 17, 2013

bump

Guild members as being members of Group · January 20, 2013

Good, that means already explained what I want the title.

For those who would not understand the following, wanted the Guild members can use skills that could only be picked up at all by group (Angelus, Magnificat, Redemption, Glory etc ...) Besides being able to see the hp bar, not necessarily the window ALT + Z more visually below the char.

Can someone help me?

December 22, 2012

LOL, aewsome

August 23, 2012

Wow, amazing project you are doing, I think the developer would not think of doing something so big. good luck

August 23, 2012

Its make this change? I am wanting a monster can give skill on player, when using the command @summon xxxx

sorry my bad english

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by Rudra