|
You last visited: Today at 06:50
Advertisement
DB Frage
Discussion on DB Frage within the Metin2 Private Server forum part of the Metin2 category.
11/29/2011, 12:30
|
#1
|
elite*gold: 0 
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
DB Frage
Hallo
und zwar kann man mir ausführlich erklären welcher eintrag in der item_proto serverside für was ist,und zwar habe ich eben ein neues armband eingefügt aber leider ist es so wenn ich dieses anklicke wird es als helm getragen,so was hatte ich schon mal mit schildern deshalb suche welche nummer ich eintragen muss das,das item seinen zweck erfüllt
MFG
|
|
|
|
11/29/2011, 12:39
|
#2
|
elite*gold: 26
Join Date: Mar 2010
Posts: 3,765
Received Thanks: 2,661
|
musst an type & subtype die werte für armband eintragen glaube ich.
Gleichs halt mal mit einem bereits bestehendem Armband ab.
|
|
|
|
|
11/29/2011, 12:46
|
#3
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
so habe mal verglichen,habe mir dazu das weissgoldarmband genommen,bei type und subtype stehen die werte der 2 item´s gleich
|
|
|
|
|
11/29/2011, 12:52
|
#4
|
elite*gold: 26
Join Date: Mar 2010
Posts: 3,765
Received Thanks: 2,661
|
hast du es auch clientside als armband drin stehen?
also mit den type und subtype werten
|
|
|
|
|
11/29/2011, 12:55
|
#5
|
elite*gold: 306
Join Date: Feb 2011
Posts: 1,251
Received Thanks: 598
|
Ja du bekommst bei dem Itemmaker den ich nehm ne Value und da musst du dann nur auswählen welches Item du möchtest.
Wenn du willst kann ich ihn dir schicken.
|
|
|
|
|
11/29/2011, 12:59
|
#6
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
würde es gern schon mal testen dein tool,naja clientside ist es genauso
hier mal die item proto clientside
PHP Code:
<Item vnum="215487" hashName="'Zin-Himmelsarmband+0'" name="Zin-Himmelsarmband+0" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="14" applytype1="46" applyvalue1="5" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="" socket_pct="0" />
<Item vnum="215488" hashName="'Zin-Himmelsarmband+1'" name="Zin-Himmelsarmband+1" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="17" applytype1="46" applyvalue1="6" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="" socket_pct="0" />
<Item vnum="215489" hashName="'Zin-Himmelsarmband+2'" name="Zin-Himmelsarmband+2" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="20" applytype1="46" applyvalue1="7" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="" socket_pct="0" />
<Item vnum="215490" hashName="'Zin-Himmelsarmband+3'" name="Zin-Himmelsarmband+3" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="23" applytype1="46" applyvalue1="8" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="" socket_pct="0" />
<Item vnum="215491" hashName="'Zin-Himmelsarmband+4'" name="Zin-Himmelsarmband+4" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="26" applytype1="46" applyvalue1="9" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="30" socket_pct="0" />
<Item vnum="215492" hashName="'Zin-Himmelsarmband+5'" name="Zin-Himmelsarmband+5" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="29" applytype1="46" applyvalue1="10" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="40" socket_pct="0" />
<Item vnum="215493" hashName="'Zin-Himmelsarmband+6'" name="Zin-Himmelsarmband+6" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="32" applytype1="46" applyvalue1="11" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="50" socket_pct="0" />
<Item vnum="215494" hashName="'Zin-Himmelsarmband+7'" name="Zin-Himmelsarmband+7" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="35" applytype1="46" applyvalue1="12" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="60" socket_pct="0" />
<Item vnum="215495" hashName="'Zin-Himmelsarmband+8'" name="Zin-Himmelsarmband+8" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="38" applytype1="46" applyvalue1="13" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="85" socket_pct="0" />
<Item vnum="215496" hashName="'Zin-Himmelsarmband+9'" name="Zin-Himmelsarmband+9" type="2" subtype="3" weight="0" size="1" antiflag="0" flag="1" wearflag="2" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="90" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="41" applytype1="46" applyvalue1="14" applytype2="37" applyvalue2="20" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="0" refine_set="1" magic_pct="15" specular="100" socket_pct="0" />
und hier serverside
PHP Code:
INSERT INTO `item_proto` VALUES ('215487', 'Zin-Himmelsarmband+0', 'Zin-Himmelsarmband+0', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215488', '0', '0', '15', '1', '90', '0', '0', '28', '14', '46', '5', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0');
INSERT INTO `item_proto` VALUES ('215488', 'Zin-Himmelsarmband+1', 'Zin-Himmelsarmband+1', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215489', '0', '0', '15', '1', '90', '0', '0', '28', '17', '46', '6', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0');
INSERT INTO `item_proto` VALUES ('215489', 'Zin-Himmelsarmband+2', 'Zin-Himmelsarmband+2', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215490', '0', '0', '15', '1', '90', '0', '0', '28', '20', '46', '7', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0');
INSERT INTO `item_proto` VALUES ('215490', 'Zin-Himmelsarmband+3', 'Zin-Himmelsarmband+3', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215491', '0', '0', '15', '1', '90', '0', '0', '28', '23', '46', '8', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '', '0', '0');
INSERT INTO `item_proto` VALUES ('215491', 'Zin-Himmelsarmband+4', 'Zin-Himmelsarmband+4', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215492', '0', '0', '15', '1', '90', '0', '0', '28', '26', '46', '9', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '30', '0', '0');
INSERT INTO `item_proto` VALUES ('215492', 'Zin-Himmelsarmband+5', 'Zin-Himmelsarmband+5', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215493', '0', '0', '15', '1', '90', '0', '0', '28', '29', '46', '10', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '40', '0', '0');
INSERT INTO `item_proto` VALUES ('215493', 'Zin-Himmelsarmband+6', 'Zin-Himmelsarmband+6', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215494', '0', '0', '15', '1', '90', '0', '0', '28', '32', '46', '11', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '50', '0', '0');
INSERT INTO `item_proto` VALUES ('215494', 'Zin-Himmelsarmband+7', 'Zin-Himmelsarmband+7', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215495', '0', '0', '15', '1', '90', '0', '0', '28', '35', '46', '12', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '60', '0', '0');
INSERT INTO `item_proto` VALUES ('215495', 'Zin-Himmelsarmband+8', 'Zin-Himmelsarmband+8', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '215496', '0', '0', '15', '1', '90', '0', '0', '28', '38', '46', '13', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '85', '0', '0');
INSERT INTO `item_proto` VALUES ('215496', 'Zin-Himmelsarmband+9', 'Zin-Himmelsarmband+9', '2', '3', '0', '1', '0', '1', '2', '', '0', '0', '0', '0', '0', '15', '1', '90', '0', '0', '28', '41', '46', '14', '37', '20', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '100', '0', '0');
MFG
|
|
|
|
|
11/29/2011, 13:10
|
#7
|
elite*gold: 26
Join Date: Mar 2010
Posts: 3,765
Received Thanks: 2,661
|
probier mal flag auf 0 und wearflga auf 8 zu setzen
|
|
|
|
|
11/29/2011, 13:41
|
#8
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
Super so geht es,kann mir jemand bitte hier schreiben wie man flag und wearflag für die verschiedenen items einstellen muss,will nich jedes mal fragen müssen und sufu bringt nich wirklich passende ergebnisse
MFG
|
|
|
|
|
11/29/2011, 13:52
|
#9
|
elite*gold: 26
Join Date: Mar 2010
Posts: 3,765
Received Thanks: 2,661
|
Quote:
Originally Posted by Structurix
Super so geht es,kann mir jemand bitte hier schreiben wie man flag und wearflag für die verschiedenen items einstellen muss,will nich jedes mal fragen müssen und sufu bringt nich wirklich passende ergebnisse
MFG
|
schau einfach in deine DB bei den bereits existierenden Items 
Da siehste doch das Muster.
|
|
|
|
|
11/29/2011, 14:14
|
#10
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
ja stimmt schon,aber ehrlich gesagt keine richtige lust dazu gehabt,aber irgendwo muss es doch hier was geben wo das beschrieben steht
|
|
|
|
|
11/29/2011, 14:29
|
#11
|
elite*gold: 168
Join Date: Feb 2010
Posts: 4,333
Received Thanks: 2,640
|
Guck mal dort 
Woher hast du die Sachen hören sich nett an^^
|
|
|
|
|
11/30/2011, 00:41
|
#12
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,131
Received Thanks: 347
|
Ja genau so was habe ich gesucht,so kann man gleich schauen ob es und nich erst ingame den schock bekommen und dann wieder alles aus einander zunehmen,orny schreib mich einfach an kannste von mir habe,weist doch habe meine fühler überall^^
|
|
|
|
|
11/30/2011, 07:29
|
#13
|
elite*gold: 168
Join Date: Feb 2010
Posts: 4,333
Received Thanks: 2,640
|
Quote:
Originally Posted by Structurix
Ja genau so was habe ich gesucht,so kann man gleich schauen ob es und nich erst ingame den schock bekommen und dann wieder alles aus einander zunehmen,orny schreib mich einfach an kannste von mir habe,weist doch habe meine fühler überall^^
|
Mache ich
#Closerequest
|
|
|
|
All times are GMT +1. The time now is 06:52.
|
|
