[Help Thread] Please post your questions here.

[smoegsmoeg]

I'll post it here as well

• Rappelz 952:
  anyone has an english resouce db? (Arcadia.dbo.StringResource & Arcadia.dbo.ItemResource )
  I can't search for the new stuff since its all in arabic:
  
  
  
  

• so i can't find the item ID's
  Lycan's Crossbow I know from older arcadias is 3100025 and others but with 9.5.2 some other stuff was added since 9.4 and i can't search for it.

thanks for your support

[ThunderNikk]

There is an English string resource table already in the database.

[Hatrick_Wildfan]

hi , i want to remove a field prop after adding it ..
i found this command

remove_field_prop()

but i have no idead how it works i ve tried to add a prop

add_field_prop(2203, 0, 127568,108645, 0, 10, 0, 0, 0, 1, 1, 1)

and then i want to delete it .. thanks

[Azreil]

Originally Posted by smoegsmoeg

I'll post it here as well

• Rappelz 952:
  anyone has an english resouce db? (Arcadia.dbo.StringResource & Arcadia.dbo.ItemResource )
  I can't search for the new stuff since its all in arabic:
  
  
  
  

• so i can't find the item ID's
  Lycan's Crossbow I know from older arcadias is 3100025 and others but with 9.5.2 some other stuff was added since 9.4 and i can't search for it.

thanks for your support

I have exported the item list from the db to a .txt file...which if you use notepad ++ makes the item numbers somewhat easy to find. The first number is the item number....and if you look at the 3rd word from the end is the description....for example: 705001 is the item number and "item_wakestone" is the description...so..going by that ..705001 is an awaken stone...probably not the easiest way to look these up...but it helps me...maybe it could help others.

Link:

I tried to add it as an attachment, but it said the file was too large.

[SilentWisdom]

Originally Posted by Azreil

I have exported the item list from the db to a .txt file...which if you use notepad ++ makes the item numbers somewhat easy to find. The first number is the item number....and if you look at the 3rd word from the end is the description....for example: 705001 is the item number and "item_wakestone" is the description...so..going by that ..705001 is an awaken stone...probably not the easiest way to look these up...but it helps me...maybe it could help others.

Link:

I tried to add it as an attachment, but it said the file was too large.

This.

This makes me so happy. To see people making the effort to help.

Makes me also wanna help:

Item Enums

 Spoiler

    public class ItemBase
    {
        public enum Type
        {
            ETC = 0,       // 일반
            ARMOR = 1,     // 장비
            CARD = 2,      // 카드
            SUPPLY = 3,        // 소모품
            CUBE = 4,      // 큐브
            CHARM = 5,     // 부적
            USE = 6,       // 사용형 - 소모되지 않고 쿨타임만
            SOULSTONE = 7,     // 소울스톤
            USE_CARD = 8
        };

        public enum Group
        {
            ETC = 0,  // 기타
            WEAPON = 1,   // 무기
            ARMOR = 2,    // 의상
            SHIELD = 3,   // 방패
            HELM = 4, // 투구
            GLOVE = 5,    // 장갑
            BOOTS = 6,    // 부츠
            BELT = 7, // 벨트
            MANTLE = 8,   // 망토
            ACCESSORY = 9,    // 악세서리
            SKILLCARD = 10,   // 스킬 카드
            ITEMCARD = 11,    // 유니트 카드
            SPELLCARD = 12,   // 스펠 카드(미구현)
            SUMMONCARD = 13,  // 소환수 카드
            FACE = 15,    // 가면
            UNDERWEAR = 16,   // 속옷
            BAG = 17, // 가방
            PET_CAGE = 18,    // 펫 우리
            STRIKE_CUBE = 21, // 스트라이크 큐브
            DEFENCE_CUBE = 22,    // 디펜스 큐브
            SKILL_CUBE = 23,  // 스킬 큐브
            RESTORATION_CUBE = 24,    // 환원의 큐브
            SOULSTONE = 93,   // 소울 스톤
            BULLET = 98,  // 탄환
            CONSUMABLE = 99,  // 소모품
            NPC_FACE = 100,   // NPC용 얼굴
            DECO = 110,   // 꾸미기 아이템
            RIDING = 120, // 탑승용 아이템
            ARTIFACT = 130,   // 아티팩트 아이템
            EQUIPMENT_ON_BELT = 140,  // 벨트 장착용 보스 카드
        };

        public enum Class
        {
            // 미분류
            ETC = 0,

            // 무기
            DOUBLE_AXE = 95,      // 쌍도끼
            DOUBLE_SWORD = 96,
            DOUBLE_DAGGER = 98,
            EVERY_WEAPON = 99,
            ETCWEAPON = 100,      // 기타무기
            ONEHAND_SWORD = 101,      // 한손검
            TWOHAND_SWORD = 102,      // 양손검
            DAGGER = 103,     // 단검
            TWOHAND_SPEAR = 104,      // 창
            TWOHAND_AXE = 105,        // 양손도끼
            ONEHAND_MACE = 106,       // 한손메이스
            TWOHAND_MACE = 107,       // 양손메이스
            HEAVY_BOW = 108,      // 헤비 보우
            LIGHT_BOW = 109,      // 라이트 보우
            CROSSBOW = 110,       // 석궁
            ONEHAND_STAFF = 111,      // 한손지팡이
            TWOHAND_STAFF = 112,      // 양손지팡이
            ONEHAND_AXE = 113,        // 한손도끼
                                            //DOUBLE_WEAPON = 199,

            // 방어구
            ARMOR = 200,      // 공용의상
            FIGHTER_ARMOR = 201,      // 전사용
            HUNTER_ARMOR = 202,       // 헌터용
            MAGICIAN_ARMOR = 203,     // 마법사용
            SUMMONER_ARMOR = 204,     // 소환사용

            //
            SHIELD = 210,     // 공용방패
            HELM = 220,       // 공용투구
            BOOTS = 230,      // 공용부츠
            GLOVE = 240,      // 공용장갑
            BELT = 250,       // 공용벨트
            MANTLE = 260,     // 공용망토
            QUIVER = 265,     // 화살통

            // 악세사리
            ETC_ACCESSORY = 300,      // 기타악세사리
            RING = 301,       // 링
            EARRING = 302,        // 귀걸이
            ARMULET = 303,        // 목걸이
            EYEGLASS = 304,       // 안경
            MASK = 305,       // 수염
            CUBE = 306,       // 큐브

            // 포스칩, 소울칩, 루나칩
            BOOST_CHIP = 400,

            // 소울스톤
            SOULSTONE = 401,
            CREATURE_FOOD = 402,
            FARM_PASS = 403,

            // 에테리얼 스톤(충전용 배터리)
            ETHEREAL_STONE = 451,

            // 꾸미기 아이템
            //DECO_WEAPON			= 600,		// 꾸미기 무기, 사용하지 않음(무기 종류별 상세 구분 ID로 대체, 609~621)
            DECO_SHIELD = 601,        // 꾸미기 방패
            DECO_ARMOR = 602,     // 꾸미기 갑옷
            DECO_HELM = 603,      // 꾸미기 투구
            DECO_GLOVE = 604,     // 꾸미기 장갑
            DECO_BOOTS = 605,     // 꾸미기 부츠
            DECO_MALTLE = 606,        // 꾸미기 망토
            DECO_SHOULDER = 607,      // 꾸미기 어깨(날개)
            DECO_HAIR = 608,      // 꾸미기 헤어
            DECO_ONEHAND_SWORD = 609,     // 꾸미기 한손검
            DECO_TWOHAND_SWORD = 610,     // 꾸미기 양손검
            DECO_DAGGER = 611,        // 꾸미기 단검
            DECO_TWOHAND_SPEAR = 612,     // 꾸미기 양손창
            DECO_TWOHAND_AXE = 613,       // 꾸미기 양손도끼
            DECO_ONEHAND_MACE = 614,      // 꾸미기 한손메이스
            DECO_TWOHAND_MACE = 615,      // 꾸미기 양손메이스
            DECO_HEAVY_BOW = 616,     // 꾸미기 헤비 보우
            DECO_LIGHT_BOW = 617,     // 꾸미기 라이트 보우
            DECO_CROSSBOW = 618,      // 꾸미기 석궁
            DECO_ONEHAND_STAFF = 619,     // 꾸미기 한손지팡이
            DECO_TWOHAND_STAFF = 620,     // 꾸미기 양손지팡이
            DECO_ONEHAND_AXE = 621,   // 꾸미기 한손도끼

            ELEMENT_EFFECT = 700,     // 속성이펙트
            ELEMENT_ONEHAND_PHYSICAL = 701,       // 속성이펙트공격력강화 (한손)
            ELEMENT_ONEHAND_MAGICAL = 702,        // 속성이펙트마력강화 (한손)
            ELEMENT_TWOHAND_PHYSICAL = 703,       // 속성이펙트공격력강화 (양손)
            ELEMENT_TWOHAND_MAGICAL = 704     // 속성이펙트마력강화 (양손)
        };

        public enum WearType
        {
            CANTWEAR = -1, // 장비불가
            NONE = -1, // 장비 하지 않음

            WEAPON = 0,    // 오른손전용    (방패라던가)
            SHIELD = 1,    // 왼손전용
            ARMOR = 2, // 갑옷
            HELM = 3,  // 투구
            GLOVE = 4, // 장갑
            BOOTS = 5, // 부츠
            BELT = 6,  // 벨트
            MANTLE = 7,    // 망토
            ARMULET = 8,   // 목걸이
            RING = 9,  // 반지		
                       // 10 은 반지 두번째 슬롯을 위해 예약
            EAR = 11,  // 귀걸이
            FACE = 12, // 눈
            HAIR = 13, // 입
            DECO_WEAPON = 14,
            DECO_SHIELD = 15,
            DECO_ARMOR = 16,
            DECO_HELM = 17,
            DECO_GLOVE = 18,
            DECO_BOOTS = 19,
            DECO_MANTLE = 20,
            DECO_SHOULDER = 21,
            RIDE_ITEM = 22,
            BAG_SLOT = 23,
            SPARE_WEAPON = 24,
            SPARE_SHIELD = 25,
            SPARE_DECO_WEAPON = 26,
            SPARE_DECO_SHIELD = 27,

            TWOFINGER_RING = 94,   // 반지 두칸 소모
            TWOHAND = 99,  // 투핸드

            SKILL = 100,   // 스킬
            SUMMON_ONLY = 200, // 크리처 전용 장비

            SECOND_RING = 10
        }
    }

The above enums will be invaluable to you if you want to do mass item selections (during table upgrades like removing dura from items etc) They basically allow you to REALLY FINE TUNE the impact of your WHERE clause.

In the SQL code below I was using it to select all item ids that were dura for a specific group, class, rank and level.

SELECT i.id, s.[value], i.[class], i.[rank], i.[enhance_id]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE i.[group] = 1 and i.[class] = 101 and i.[rank] = 7 and i.[use_min_level] = 160
AND s.value NOT LIKE '%?%' AND s.value NOT LIKE '%<%'
ORDER BY i.id ASC

BUT it can be made as easy as to just select an item by name like:

SELECT i.id, s.[value]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE s.[value] LIKE '%%' -- 1
ORDER BY i.id ASC

/*
-- <> is a placeholder and must be replaced with a real value!!!
1.
- If you know the absolute (must be correct) name of the item change s.[value] LIKE '%%' to s.[value] = ''
- If you want matches where the last word in the s.[value] matches the term change to s.[value] LIKE '% <term>'
- If you want matches where the first word in the s.[value] matches the term change to s.[value] LIKE '<term> %'
*/

Or you could select a range of items like:

SELECT i.id, s.[value], i.[class], i.[rank], i.[enhance_id]

FROM dbo.ItemResource i
LEFT JOIN dbo.StringResource s
ON s.code = i.name_id
LEFT JOIN dbo.StringResource t
ON t.code = i.tooltip_id
WHERE s.[value] LIKE '% Potion'
ORDER BY i.id ASC

And you can change the output columns to your hearts content, just change up the select statement with the columns you want and viola!

I hope this helps not only the original poster (@smoegsmoeg) but you @

[mlejnek2]

Fixed thanks to INK

[mlejnek2]

Looking for a On log in script ... to rebuff players/pets if they wasnt able to be on when say a world boss was killed and they missed the buffs. so need a script to give them the missed buffs to them and pets for same lvl buff and remaining time thats on the current ones so they can still enjoy the rewards that are earned by players....TYVM in advance

[YuhaBah]

Can i take tables with skill dmg formula from client with SilentWisdom or glandu2 tools?

[Azreil]

@ Thank you for the information, this does make searching for items much simpler. If you have the time, may I msg you about a question I have about the files and client?

[SilentWisdom]

@ sure mate, add me on disc #ismokedrow#3102

[Azreil]

Originally Posted by SilentWisdom

@ sure mate, add me on disc #ismokedrow#3102

Disc says: that didn't work , check the spelling.

[swtib9]

Hello

I made a 9.5.2 server using this tuto
Worked fine with local IP
But since i want to play with friend, I tried to use hamachi. I put hamachi IP in gameserver.opt in S:io.ip_adress but when i try to join server it say me "Cannot connect to the login server. 10061

(obvisouly, i also added hamachi IP in launcher.bat

Did i have to put the new IP somewhere else?

EDIT: Tried with another client and it worked .. hum .. Sadly it's not the client i want to use because of the language.

[ThunderNikk]

Make sure the .bat file you use is pointing to the correct auth server port also.

[swtib9]

Yup, port is ok.
What is weird is that it works on my own PC (where the server is hosted) but not on a friend's pc, even if he is on the same hamachi network and with the exact same launcher than me.

With an USB Key, i used the same client and same launcher on both computer.
On mine it works
On friend's one "cannot connect to loggin server 10060"

[Dark Blaze]

Originally Posted by swtib9

Yup, port is ok.
What is weird is that it works on my own PC (where the server is hosted) but not on a friend's pc, even if he is on the same hamachi network and with the exact same launcher than me.

With an USB Key, i used the same client and same launcher on both computer.
On mine it works
On friend's one "cannot connect to loggin server 10060"

Set the GS and auth server IP addresses to the Hamachi IP address and use it for the launcher.