Register for your free account! | Forgot your password?

You last visited: Today at 15:18

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Uppitems NPC

Discussion on Uppitems NPC within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
Mind.'s Avatar
 
elite*gold: 0
Join Date: Feb 2013
Posts: 244
Received Thanks: 12
Uppitems NPC

Hat einer schon ne Fertige datei die ich bei Navicat einfügen kann, das ein NPC alle Uppitems beinhaltet?


mfg.
Mind. is offline  
Old 03/24/2013, 22:11   #2
 
elite*gold: 0
Join Date: Nov 2012
Posts: 373
Received Thanks: 132
Ehm wie wärs mit selbermachen??
Des dauert 10 Min maximal.
Marsia is offline  
Thanks
1 User
Old 03/24/2013, 23:11   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 377
Received Thanks: 143
HTML Code:
quest rustungen begin
	state start begin
    
		when 9003.chat."Gemischtwarenhändlerin" begin
			npc.open_shop(3)
		setskin(NOWINDOW)
		end

		when 9003.chat."Itemshophändlerin" begin
			npc.open_shop(9929)
		setskin(NOWINDOW)
		end
    end
end
Dazu eine quest, die brauchste nur erweitern und dazu itemshop Items:

HTML Code:
INSERT INTO `shop_item` VALUES ('9929', '25040', '1');
INSERT INTO `shop_item` VALUES ('9929', '27102', '200');
INSERT INTO `shop_item` VALUES ('9929', '50023', '1');
INSERT INTO `shop_item` VALUES ('9929', '50513', '1');
INSERT INTO `shop_item` VALUES ('9929', '70005', '1');
INSERT INTO `shop_item` VALUES ('9929', '70006', '1');
INSERT INTO `shop_item` VALUES ('9929', '70038', '200');
INSERT INTO `shop_item` VALUES ('9929', '70102', '25');
INSERT INTO `shop_item` VALUES ('9929', '71001', '200');
INSERT INTO `shop_item` VALUES ('9929', '71002', '1');
INSERT INTO `shop_item` VALUES ('9929', '71003', '1');
INSERT INTO `shop_item` VALUES ('9929', '71027', '200');
INSERT INTO `shop_item` VALUES ('9929', '71028', '200');
INSERT INTO `shop_item` VALUES ('9929', '71029', '200');
INSERT INTO `shop_item` VALUES ('9929', '71030', '200');
INSERT INTO `shop_item` VALUES ('9929', '71033', '1');
INSERT INTO `shop_item` VALUES ('9929', '71044', '200');
INSERT INTO `shop_item` VALUES ('9929', '71045', '200');
INSERT INTO `shop_item` VALUES ('9929', '71048', '1');
INSERT INTO `shop_item` VALUES ('9929', '71049', '1');
INSERT INTO `shop_item` VALUES ('9929', '71050', '200');
INSERT INTO `shop_item` VALUES ('9929', '71054', '1');
INSERT INTO `shop_item` VALUES ('9929', '71084', '200');
INSERT INTO `shop_item` VALUES ('9929', '71085', '200');
INSERT INTO `shop_item` VALUES ('9929', '71094', '200');
INSERT INTO `shop_item` VALUES ('9929', '71095', '25');
INSERT INTO `shop_item` VALUES ('9929', '72018', '1');
INSERT INTO `shop_item` VALUES ('9929', '72701', '1');
INSERT INTO `shop_item` VALUES ('9929', '72725', '1');
INSERT INTO `shop_item` VALUES ('9929', '72729', '1');
Also per Query Table einfügen

So Uppitem shop hab ich nicht weil man bei mir 100% uppchance und keine items hat
volume1a is offline  
Thanks
1 User
Old 03/24/2013, 23:24   #4
 
elite*gold: 2500
Join Date: Feb 2010
Posts: 692
Received Thanks: 63
PHP Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30003''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30004''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30005''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30006''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30077''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30007''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30076''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30008''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30078''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30009''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30083''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30010''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30071''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30011''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30015''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30086''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30014''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30089''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30016''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30087''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30017''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30019''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30020''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30021''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30022''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30082''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30023''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30024''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30025''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30026''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30027''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30070''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30028''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30069''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30029''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30030''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30031''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30032''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30074''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('18''30033''2'); 
PHP Code:
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30034''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30073''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30035''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30036''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30037''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30038''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30039''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30085''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30040''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30041''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30075''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30042''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30045''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30046''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30081''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30044''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30043''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30047''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30080''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30048''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30088''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30049''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30050''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30090''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30051''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30084''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30052''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30053''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30072''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30055''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30056''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30057''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30058''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30059''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30060''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30061''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30139''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30091''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30092''2'); 
INSERT INTO `shop_item` (`shop_vnum`, `item_vnum`, `count`) VALUES ('19''30063''2'); 
ralriki is offline  
Thanks
1 User
Old 03/24/2013, 23:55   #5
 
☆RealPain's Avatar
 
elite*gold: 85
Join Date: Aug 2009
Posts: 177
Received Thanks: 39
Ist doch ganz einfach
1. Quest für die Richtigen NPC
(Wie man Quest richtig einbaut solltest du denke ich wissen)
^^
Quote:
quest blabla begin
state start begin

when "NPC-ID".chat.""SHOP-NAME"" begin
npc.open_shop("SHOP-ID")
setskin(NOWINDOW)
end

when "NPC-ID".chat."SHOP-NAME" begin
npc.open_shop("SHOP-ID")
setskin(NOWINDOW)
end
end
end
2. Danach gehst du einfach in die Datenbank in die Player Table in das Verzeichnis
Quote:
2.1 Shop Erste Spalte einfach(vnum=Shop-ID)Name ist SHOP-Name npc_vnum ist die NPC-ID
Quote:
2.2Shop_item gleiche Table, Shop_vnum ist die (Vnum=Shop-ID)dann kommt die item_vnum (wo du die Item_vnum wie schon gesagt einfügen musst)
Count einfach nur die Anzahl.
Mit freundlichen Grüßen
☆RealPain

PS: Skype adden
☆RealPain is offline  
Reply


Similar Threads Similar Threads
Uppitems
09/15/2012 - Metin2 Private Server - 2 Replies
Hallo, ich habe gerade die Uppitems aus dem Thread hier eingefügt: (Die Kristalle) Deutsch 3 neue Uppitems (nur die Icons!)
[S]Uppitems
07/18/2012 - Metin2 Private Server - 1 Replies
Hallo, da ich in der Sufu keine Uppitems finde. ( also neue Icons ) Die ich einfügen kann Wäre es lieb wenn ihr hier mir helft. Welche zu finden :P mfg Rosi
UppItems
06/12/2011 - Metin2 Private Server - 1 Replies
Hallo, Ich suche die Values und Namen für die alle UppItems. z.B. : Bärenfußhaut = 1 War nur ein Beispiel. Ich habe schon im Sticky geguckt aber da waren die mit anderen Items vermischt und ich wusste nicht welche UppItems sind und welche nicht.
Uppitems
06/12/2011 - Metin2 Private Server - 3 Replies
Moinsen liebe epvp com,ich hätte ma ne frage bezüglich der Uppitems.Ich möchte das man für nen SSP+9 zu King z.b 2 rote perlen und 1 gga bräuchte.Nun hab ich das prob wie soll ich das in der refine_proto einstellen?Ich weiß wo alles hinsoll aber gibst dafür nicht ein speziellen value.Es gibt ja für 2 segis und 1 gga den code 551 oder 501 ka.gibst nun auch ein speziellen für 2 rote perlen und 1 gga?Das ist meine Frage lg Freak
UppItems
11/28/2009 - Metin2 Private Server - 2 Replies
hi ich hab auf meinen server uppitems ausgestellt aber möchte sie wieder einstellen wie mach ich das jetzt die ganzen ziffern und so ken ich nima was in navicat rein muss kan mir einer helfen ? .



All times are GMT +2. The time now is 15:18.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.