cerere sql

Sk1ZzO · 18 Ian 2019, 01:49

Salut, am nevoie de sql pentru itemele de la sistemul de insotitori.

va las aici item proto si item name lafel si pt mob proto si name

item_proto.txt

Cod: Selectaţi tot

55701	ȏƮݒȯǐ	ITEM_QUEST	0	1	ANTI_DROP	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55702	ȏƮݒȯǐ	ITEM_QUEST	0	1	ANTI_DROP	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55703	ȏƮݒȯǐ	ITEM_QUEST	0	1	ANTI_DROP	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55704	ȏƮݒȯǐ	ITEM_QUEST	0	1	ANTI_DROP	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55401	նOŹݺƮࠫ	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55402	նOŹݺƮࠫ	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55403	նOŹݺƮࠫ	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55404	նOŹݺƮࠫ	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55001	펫 사료	ITEM_QUEST	0	1	ANTI_DROP | ANTI_SELL | ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55002	펫 가방	ITEM_QUEST	0	1	ANTI_FEMALE	LOG	NONE	NONE	0	0	0	0	0	REAL_TIME	2592000	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0	0
55003	사육비서-1편	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55004	사육비서-2편	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55005	조련비서-1편	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55006	조련비서-2편	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55007	조련비서-3편	ITEM_QUEST	0	1	NONE	ITEM_STACKABLE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55009	펫 스킬북 상자	ITEM_QUEST	0	1	NONE	NONE	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	0	0	0	0	0	0	0	0	0
55010	펫 스킬북(지중)-무사	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	1	0	0	0	0	0	0	0	0
55011	펫 스킬북(지중)-수라	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	2	0	0	0	0	0	0	0	0
55012	펫 스킬북(지중)-자객	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	3	0	0	0	0	0	0	0	0
55013	펫 스킬북(지중)-무당	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	4	0	0	0	0	0	0	0	0
55014	펫 스킬북(지중)-수인	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	5	0	0	0	0	0	0	0	0
55015	펫 스킬북(파천)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	6	0	0	0	0	0	0	0	0
55016	펫 스킬북(천령)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	7	0	0	0	0	0	0	0	0
55017	펫 스킬북(반야)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	8	0	0	0	0	0	0	0	0
55018	펫 스킬북(초혼비무)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	9	0	0	0	0	0	0	0	0
55019	펫 스킬북(회복)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	10	0	0	0	0	0	0	0	0
55020	펫 스킬북(흡인)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	11	0	0	0	0	0	0	0	0
55021	펫 스킬북(흡수)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	12	0	0	0	0	0	0	0	0
55022	펫 스킬북(블럭)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	13	0	0	0	0	0	0	0	0
55023	펫 스킬북(반사)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	14	0	0	0	0	0	0	0	0
55024	펫 스킬북(드랍)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	15	0	0	0	0	0	0	0	0
55025	펫 스킬북(거리)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	16	0	0	0	0	0	0	0	0
55026	펫 스킬북(무적)	ITEM_QUEST	0	1	ANTI_STACK	LOG	NONE	NONE	0	0	0	0	0	LIMIT_NONE	0	LIMIT_NONE	0	APPLY_NONE	0	APPLY_NONE	0	APPLY_NONE	0	17	0	0	0	0	0	0	0	0

item_name.txt

Cod: Selectaţi tot

55001	Biscuit cu Proteine
55002	Cutie de Transport
55003	Carte Insotitor Tanar
55004	Carte Insotitor Salbatic
55005	Carte Insotitor Curajos
55009	Cufar Carte Insotitor
55010	Rezistenta (Razboinic)
55011	Rezistenta (Sura)
55012	Rezistenta (Ninja)
55013	Rezistenta (Saman)
55014	Rezistenta (Lycan)
55015	Carte Berserker
55016	Carte Anti-Magie
55017	Carte Graba	Dupa
55018	Carte Antrenament
55019	Carte Restaurare
55020	Carte de Vampirism
55021	Carte de Spiritism
55022	Carte de Obstructie
55023	Carte Reflexie
55024	Carte Drop Yang
55025	Carte Distanta
55026	Carte Imortalitate
55027	Carte Remediu
55401	Ou
55402	Ou
55403	Ou
55404	Ou
55701	Pui de Maimuta (Sigiliu)
55702	Pui de Paianjen	(Sigiliu)
55703	Pui de Razador	(Sigiliu)
55704	Pui de Nemere	(Sigiliu)

mob_name.txt

Cod: Selectaţi tot

34041	Nuvy Panda
34045	Nuvy Panda
34049	Nuvy Panda
34053	Nuvy Panda
34042	Nuvy Panda
34046	Nuvy Panda
34050	Nuvy Panda
34054	Nuvy Panda

mob_proto.txt

Cod: Selectaţi tot

34041	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34045	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34049	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34053	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34042	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34046	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34050	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1
34054	???	KNIGHT	NPC	MELEE	100		0	0		STUN,SLOW,CURSE,TERROR	1		0	0	0	0	0	0	0	6938	3	1	0	0	802	109	100	100	0	2000	175	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	0	0	0	0	0	0	0	0	0	0	101	??	PAWN	MONSTER	MELEE	1

Multumesc anticipat, daca le are cineva si poate sa le imparta si cu mine =]

Nazir a.k.a. Zorke · 24 Ian 2019, 10:58

Arhivat!

cerere sql

[CERERE] Cerere Blazing Purgatory si Turnul lui Nemere urgent

[CERERE]Cine ştie cum să creez un sv de Metin2[CERERE]

cerere lycan skill nou , cerere tehnician

[Cerere] Cerere pack system vegas!!

Cine este conectat