[MEGA RELEASE] Serverfiles complet / Sursă.[Testat si functional]

Nu recomandam folosirea lor pentru a deschide un server. Aici găsiți serverfiles din care puteți extrage foarte multe resurse.
Avatar utilizator
atomyc
Nivel 1

Nivel 1
Mesaje: 66
Membru din: 04 Iul 2014, 21:04
Server: HHTB
Regat: Jinno
Aprecieri: 138  
Mulţumiri: 3  
 Contact:
Medalii

Lexus scrie: ↑28 Mar 2020, 23:52
Kazuhiri scrie: ↑28 Mar 2020, 22:40
Lexus scrie: ↑28 Mar 2020, 22:39

cineva, putin ajutor va rog?...
Nu 🙅, nu mai cereți suport în topic, aveți secțiunea probleme și întrebări

[ Postat de pe Android ] Imagine
Stai linistit, pana raspunde cineva... i-am dat singur de cap.
Pentru cine mai are problema cu GCC 49 command not found cand dati comanda gmake -j20, intrati in folderele game si db din sursa, cautati fisierul Makefile si schimbati din CC = g++49 in CC = g++48.
Valabil doar pentru cine a luat VDI-ul cu freebsd 9.2 cu sursa!
P.S: nu merge instalat gcc49 pe acea sursa, nu inteleg de ce, nici macar manual. pentru cine stie, rog sa impartaseasca cu noi :)
vezi ca este un link lasat cu vdi 9.2 gcc 4.9 eu ala l am descarcat si functioneaza poti compila fara erori
Avatar utilizator
atomyc
Nivel 1

Nivel 1
Mesaje: 66
Membru din: 04 Iul 2014, 21:04
Server: HHTB
Regat: Jinno
Aprecieri: 138  
Mulţumiri: 3  
 Contact:
Medalii

Fifanike1337 scrie: ↑31 Mar 2020, 21:00 Toata lumea vrea serverfiles-uri cu 0 buguri si probabil si toate sistemele premium in ele...munciti, dupa ce ca omu v-a pus ceva STABIL( porneste, nu are crash-uri (asta doar daca bagati voi ceva gresit si o sa apara pe parcurs, pentru ca e ceva normal pana la urma) ) vreti totu mura-n gura... daca nu sunteti capabili si nu stiti macar limbaju respectiv, apelati la cineva care se pricepe si invatati de la respectivu cum a facut x, de ce a facut y si etc.
In ziua de azi nimeni nu mai ofera servicii gratuite pentru un server, pentru ca si omu respectiv care te ajuta pierde timp pe partea cealalta si tu castigi pe partea cealalta $$.
Sunt mii de tutoriale cum sa rezolvi problema x y z, cum sa adaugi, cum sa modifici, daca nici asa, iei un serverfiles care are sistemu respectiv fara buguri si compari liniile scrise cu ale tale si ai rezolvat problema.
bine zis
Avatar utilizator
AliaceOfficial
Nivel 6

Nivel 6
Mesaje: 1002
Membru din: 26 Iun 2019, 23:08
Server: nu am
Regat: Jinno
Aprecieri: 896  
Mulţumiri: 25  
Medalii

Kazuhiri scrie: ↑10 Apr 2020, 10:03
Noksy scrie: ↑10 Apr 2020, 00:16 Salutare tuturor !! Cine imi zice si mie de unde pot dezactiva shop offline ? sa se faca shop normal, clasic de pe manunchi.
Navicat deoarece este great

[ Postat de pe Android ] Imagine
Vad ca esti activ pe svf asta si ca lucrezi pe el.

Ai reusit sa iti dai seama de la ce este problema cu deconectarile random? Pe mine unul nu ma scoate dar am 2 testeri ce se plang de treaba asta, nu am eroare syserr client nici ch1/99/db cand se intampla chestia cu deconectarea.

[ Postat de pe Android ] Imagine
Avatar utilizator
sk1per
Nivel 7

Nivel 7
Mesaje: 1351
Membru din: 14 Dec 2013, 18:03
Server: blackmetin2
Regat: Chunjo
Aprecieri: 584  
Mulţumiri: 882  
Medalii

bunicel eu unu iam scos md5 ala mi se pare la fel de inutil si ca cel normal.
daca vrea sati sparga cineva baza de date o face si cu si fara md5. criptare parole...
Cauti un host bun si preturi superbe te astept pe www.softserver.ro :heart_eyes:
Afișează semnătura
Avatar utilizator
Hellion
Nou Venit

Nou Venit
Mesaje: 13
Membru din: 16 Apr 2020, 03:59
Regat: Jinno
Aprecieri: 13  
Mulţumiri: 2  
Medalii

Wizz. scrie: ↑30 Iun 2019, 23:21 Serverul este stabil, îl puteți folosi cu încredere. :ymhug:
Sursa este aceea de la serenity îmbunătățită și cu foarte multe fix-uri.
Sursa game este compatibila cu gcc49

service.h sursă game.
#ifndef __INC_METIN2_COMMON_DEFINES_H__
#define __INC_METIN2_COMMON_DEFINES_H__

enum eCommonDefines {
	MAP_ALLOW_LIMIT = 64, // 32 default
};

#define ENABLE_PLAYER_PER_ACCOUNT5
#define ENABLE_PORT_SECURITY

/* SYSTEME PRINCIPALE JUCATORI*/
#define __WJ_SHOW_MOB_INFO__
#define __SEND_TARGET_INFO__
#define __SPECIAL_STORAGE__
#define __7AND8TH_SKILLS__
#define __TITLE_SYSTEM__
#define __TIMER_ELIXIR__
#define __SASH_SYSTEM__
#define __MULTI_SHOP__
#define __BIOLOG_TIME__
#define __BIOLOG_SYSTEM__
#define __CHANGE_SEX_WR__
#define __REFINE_SYSTEM__
#define __CHANGELOOK_SYSTEM__
#define __CHANGELOOK_EXTEND__
#define __EXTENDED_ITEM_NAME__
#define __EXPANDED_BOOK_NAME__
#define __WEAPON_COSTUME_SYSTEM__
#define __COSTUME_ATTR_SYSTEM__
#define __COSTUME_RING_SYSTEM__
#define __SEQUENCE_SYSTEM__
#define __SHOW_CHEST_DROP__
#define __ATTENDANCE_EVENT__
#define __ENABLE_BATTLE_FIELD__
#define __DUNGEON_INFO_SYSTEM__
#define __SKILLS_LEVEL_OVER_P__
#define __VIEW_TARGET_PLAYER_HP__
#define __VIEW_TARGET_DECIMAL_HP__


// #ifndef ENABLE_ANNOUNCEMENT_REFINE_SUCCES
	// #define ENABLE_ANNOUNCEMENT_REFINE_SUCCES
	// #define ENABLE_ANNOUNCEMENT_REFINE_SUCCES_MIN_LEVEL 9
// #endif

#define ENABLE_NEW_QUICK_SLOT_SYSTEM
//#define WJ_GUILD_LEADER_SYSTEM
#define WJ_ENABLE_PICKUP_ITEM_EFFECT
#define WJ_ENABLE_TRADABLE_ICON

#define ENABLE_CHANGE_CHANNEL
#define ENABLE_ANTIEXP_RENEWAL
#define ENABLE_SORT_INVENTORY
#define ENABLE_CUBE_RENEWAL
#define ENABLE_DICE_SYSTEM
#define ENABLE_GLOBAL_CHAT
#define ENABLE_FISH_EVENT
#define ENABLE_GEM_SYSTEM
#define ENABLE_NEWSTUFF
#define ENABLE_PET_SLOT
#define NEW_PET_SYSTEM
#define NEW_PET_SUMMON

#define ENABLE_MOUNT_COSTUME_SYSTEM
#define ENABLE_SUPPORT_SYSTEM
#define ENABLE_AGGREGATE_MONSTER_EFFECT
#define ITEM_REMAINING


/* SYSTEME PENTRU ADMINISTRARE*/
#define __WHISPER_ADMIN__
#define __ADMIN_MANAGER__


/* OFFLINE SHOPS */
#define OFFLINE_SHOP // Offline shops system
#define GIFT_SYSTEM // gift system enable
#define FULL_YANG // Enable support for yang type long long
#define SHOP_TIME_REFRESH 1*60 // time for cycle checking older shops
#define SHOP_BLOCK_GAME99 //Blocking create shops on channel 99
//#define SHOP_DISTANCE // Show shops in pos distance like WoM2
#define SHOP_AUTO_CLOSE //Enable auto closing shop after sell last item
//#define SHOP_ONLY_ALLOWED_INDEX //Enable limiting for other map index which is not defined in player.shop_limit
//#define SHOP_HIDE_NAME // Enable hidding shop npc names like "Player's shop"
#define SHOP_GM_PRIVILEGES GM_IMPLEMENTOR //Minimum GM privileges to using Shop GM Panel
#define ENABLE_OFFLINE_SHOP_HIDE
#define SHOP_SEARCH
#define SHOP_SEARCH_PRICE_MIN //Price in gui is a minimum eq. price >= item_price if is commented price in gui is a maximum
/* END OFFLINE SHOPS */

/* SYSTEME TEMNITE */
#define __VERSION_162__
#ifdef __VERSION_162__
	#define HEALING_SKILL_VNUM 265
#endif

#define __DUNGEON_FOR_GUILD__
#ifdef __DUNGEON_FOR_GUILD__
	#define __MELEY_LAIR_DUNGEON__
	#ifdef __MELEY_LAIR_DUNGEON__
		#define __DESTROY_INFINITE_STATUES_GM__
		#define __LASER_EFFECT_ON_75HP__
		#define __LASER_EFFECT_ON_50HP__
	#endif
#endif
/* END SYSTEME TEMNITE */

#endif
Câteva imagini cu sistemele implementate.
ImagineImagineImagine

Mai multe imagini click aici https://imgur.com/a/QVVvwZV
Sursă game și serverfiles complet:
Imagine
Continut: Ascuns
Trebuie sa multumesti autorului pentru a putea vedea mesajul.

Sursă client + client complet cu toate programele necesare:
Imagine
Continut: Ascuns
Trebuie sa multumesti autorului pentru a putea vedea mesajul.


GCC49 Instalare manuala cu tutorial:
Continut: Ascuns
Trebuie sa multumesti autorului pentru a putea vedea mesajul.

Rezolvare problema la fereastra de logare:
În networkmodule.py

Caută:
		if self.curPhaseWindow:
			self.curtain.FadeIn()
			self.curPhaseWindow.SetFocus()
			
Înlocuiește cu:

		if self.curPhaseWindow:
			self.curtain.FadeIn()
			# self.curPhaseWindow.SetFocus()
		else:
			app.Exit()
Spor la cât mai multe servere!

DIN DATA DE 13.12.2019: NU MAI OFER SUPPORT GRATUIT.

------------------------------------------------------------------------------------------
Cateva rezolvari din partea super moderatorului vostru preferat,Kazuhiri
------------------------------------------------------------------------------------------
1.Rezolvare negot:
Pasul 1)intrati in usr/src/vlad/files/common/service.h
Pasul 2)inainte de ultimul #endif pune :
#define __NEW_EXCHANGE_WINDOW__
Pasul 3) intrati in usr/src/vlad/filles/game/exchange.cpp si cautati:
m_pGrid = M2_NEW CGrid(4, 3);
inlocuiti cu
#ifdef __NEW_EXCHANGE_WINDOW__
	m_pGrid = M2_NEW CGrid(6, 4);
#else
	m_pGrid = M2_NEW CGrid(4, 3);
#endif
Pasul 4)intrati in usr/src/vlad/filles/game/exchange.h si cautati:
EXCHANGE_ITEM_MAX_NUM = 12,
inlocuiti cu
#ifdef __NEW_EXCHANGE_WINDOW__
	EXCHANGE_ITEM_MAX_NUM = 24,
#else
	EXCHANGE_ITEM_MAX_NUM = 12,
#endif
compilati si aia e
2.Daca apasati pe moneda dragon,aia care se invarte de jos,va da pe un item-shop,o reclama "indirecta"...
Pasul 1) intrati in fiecare config,din fiecare canal,cautati MALL_URL si puneti orice nume(de ex salampower.tk/item-shop)in cazul meu am
MALL_URL: kazu.ro/item-shop.php
Pasul 2)Reboot
3.Rezolvare gaya
Pasul 1)intrati in quest,facei un fisier numit gaya_create.lua si puneti asta
Pasul 2)scriem ./qc gaya_create.lua,intram in joc,dam un /reload q si gata.
4.Rezolvare insotitori:
Intrati in quest si creati un folder numit
-newpetstaff.quest si adaugati
-PetSystemIncubator.lua si adaugati
-PetSystems.lua si adaugati
Apoi in putty scriem ./qc newpetstaff.quest ./qc PetSystemIncubator.lua ./qc PetSystems.lua
reload q in joc si aia e
5.Nu merg unele mape
Ei bine,daca nu merg unele mape,nu va teleporteaza in ele,uitati cum rezolvati:
-intrati in sysser din ch1,si daca apare ceva de genul
cannot find map location index 73
,ne uitam dupa index,in cazul meu 73
-mergem in fiecare config din fiecare ch,iar la map Allow adaugam acest numar/index (ATENTIE,sa fie in ordine crescatoare sirul,nu puneti acel index in capat sau la inceput,puneti in asa fel in cat sa fie crescator)
Dupa ce am facut toate astea dam reboot si gata,avem mapele functionale
6.Pornirea serverului
Multi imi dati msj ca"auzi,l-ai ajutat pe ala sa porneasca sv,ma ajuti si pe mine plss?"m-am decis sa pun aici tutorial cum sa porniti sv..
Pasul 1)punem https://mega.nz/#!s5sETahQ!bbkvaCffDlq9 ... FrV8J6hSAA in usr/lib,usr/lib32 si /lib
Pasul 2)intram in fiecare config din ch+conf.txt din datebase si la BIND_ip punem ip-ul nostru
Pasul 3)intram in navicat si dam empty la urmatoarele tabele
-account
-gmlist
-player
-player_gift
-player_index
-player_shop
-player_shop_item
Pasul 4)reboot
Bafta
Cine vrea shopurile la invatatori cu frizurile fara bonusuri le aveti aici:

Cod: Selectaţi tot

/*
aura
20340 (blue) [29]
20320 (yellow) [21]
20300 (red) [13]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (29, 73012, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (21, 73012, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (13, 73012, 1, 0, 0);

/*
mental 
20341 (blue) [30]
20321 (yellow) [22]
20301 (red) [14]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (30, 75012, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (22, 75012, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75001, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75002, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75003, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75004, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75005, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75006, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75007, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75008, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75009, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75010, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75011, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (14, 75012, 1, 0, 0);

/*
lupta de apro pumnal
20342 (blue) [31]
20322 (yellow) [23]
20302 (red) [15]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73251, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73252, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73253, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73254, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73255, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73256, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73257, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73258, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73259, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73260, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73261, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (31, 73262, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73251, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73252, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73253, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73254, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73255, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73256, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73257, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73258, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73259, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73260, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73261, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (23, 73262, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73251, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73252, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73253, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73254, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73255, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73256, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73257, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73258, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73259, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73260, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73261, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (15, 73262, 1, 0, 0);

/*
lupta departata arc
20343 (blue) [32]
20323 (yellow) [24]
20303 (red) [16]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75201, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75202, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75203, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75204, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75205, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75206, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75207, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75208, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75209, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75210, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75211, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (32, 75212, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75201, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75202, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75203, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75204, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75205, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75206, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75207, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75208, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75209, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75210, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75211, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (24, 75212, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75201, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75202, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75203, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75204, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75205, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75206, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75207, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75208, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75209, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75210, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75211, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (16, 75212, 1, 0, 0);

/*
arme magice
20344 (blue) [33]
20324 (yellow) [25]
20304 (red) [17]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73501, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73502, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73503, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73504, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73505, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73506, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73507, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73508, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73509, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73510, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73511, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (33, 73512, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73501, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73502, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73503, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73504, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73505, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73506, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73507, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73508, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73509, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73510, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73511, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (25, 73512, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73501, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73502, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73503, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73504, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73505, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73506, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73507, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73508, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73509, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73510, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73511, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (17, 73512, 1, 0, 0);

/*
magie neagra
20345 (blue) [34]
20325 (yellow) [26]
20305 (red) [18]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75401, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75402, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75403, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75404, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75405, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75406, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75407, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75408, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75409, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75410, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75411, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (34, 75412, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75401, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75402, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75403, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75404, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75405, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75406, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75407, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75408, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75409, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75410, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75411, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (26, 75412, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75401, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75402, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75403, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75404, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75405, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75406, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75407, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75408, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75409, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75410, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75411, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (18, 75412, 1, 0, 0);

/*
putere zmeu
20346 (blue) [35]
20326 (yellow) [27]
20306 (red) [19]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75601, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75602, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75603, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75604, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75605, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75606, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75607, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75608, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75609, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75610, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75611, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (35, 75612, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75601, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75602, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75603, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75604, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75605, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75606, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75607, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75608, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75609, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75610, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75611, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (27, 75612, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75601, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75602, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75603, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75604, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75605, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75606, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75607, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75608, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75609, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75610, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75611, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (19, 75612, 1, 0, 0);

/*
vindecare
20347 (blue) [36]
20327 (yellow) [28]
20308 (red) [20]
*/
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73751, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73752, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73753, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73754, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73755, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73756, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73757, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73758, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73759, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73760, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73761, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (36, 73762, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73751, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73752, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73753, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73754, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73755, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73756, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73757, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73758, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73759, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73760, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73761, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (28, 73762, 1, 0, 0);

INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73751, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73752, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73753, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73754, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73755, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73756, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73757, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73758, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73759, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73760, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73761, 1, 0, 0);
INSERT INTO `shop_item`(`shop_vnum`, `item_vnum`, `count`, `price_vnum`, `price`) VALUES (20, 73762, 1, 0, 0);
Pentru acest mesaj, Hellion for the post:
Ak47
Avatar utilizator
sk1per
Nivel 7

Nivel 7
Mesaje: 1351
Membru din: 14 Dec 2013, 18:03
Server: blackmetin2
Regat: Chunjo
Aprecieri: 584  
Mulţumiri: 882  
Medalii

mici chesti de reparat plus cateva prin surse. si e bunicel serveru pentru cine se descurca cu el.
Cauti un host bun si preturi superbe te astept pe www.softserver.ro :heart_eyes:
Afișează semnătura
Avatar utilizator
sorrellboss
Nivel 3

Nivel 3
Mesaje: 461
Membru din: 29 Iun 2014, 09:51
Server: Metin2Gorj
Regat: Shinsoo
Aprecieri: 45  
Mulţumiri: 4  
Medalii

cum introduc o mapa in acest client?
Avatar utilizator
sk1per
Nivel 7

Nivel 7
Mesaje: 1351
Membru din: 14 Dec 2013, 18:03
Server: blackmetin2
Regat: Chunjo
Aprecieri: 584  
Mulţumiri: 882  
Medalii

eclipse27 : schimb ip din bind_ip din fie ch si auth si o sati mearga
sorrellboss : cum se baga ori ce mapa...
Cauti un host bun si preturi superbe te astept pe www.softserver.ro :heart_eyes:
Afișează semnătura
Avatar utilizator
sorrellboss
Nivel 3

Nivel 3
Mesaje: 461
Membru din: 29 Iun 2014, 09:51
Server: Metin2Gorj
Regat: Shinsoo
Aprecieri: 45  
Mulţumiri: 4  
Medalii

spune mi tu mie unde gasesc fisierul index din map. descarca resursa si uita te...
Avatar utilizator
Kazuhiri
Nivel 9

Nivel 9
Mesaje: 2088
Membru din: 26 Mar 2017, 19:14
Server: Demetris
Regat: Shinsoo
Aprecieri: 396  
Mulţumiri: 3227  
  Rezolvări prob.: 2
Discord: Copiază ID
Medalii

sorrellboss scrie: ↑17 Apr 2020, 22:50 spune mi tu mie unde gasesc fisierul index din map. descarca resursa si uita te...
Ăla nu e fișier....

[ Postat de pe Android ] Imagine
Demetris2 Imagine
Afișează semnătura
Răspunde
Răspunsuri
78
Vizualizări
16414
Răspunsuri
3
Vizualizări
986
Răspunsuri
22
Vizualizări
6635

Înapoi la “Serverfiles”

  • Informaţie
  • Cine este conectat

    Utilizatori ce ce navighează pe acest forum: Niciun utilizator înregistrat și 8 vizitatori