Problem mit 60+80 Helme

~~Ytura~~ · 04/02/2012, 21:51

Bei mir Funktonieren diese Helme nicht, alle anderen Funktoniern allerdings

Woran liegt das..?

Diese Querys gehen einfach nicht, die anderen Query Helme gehen ohne Probleme!

Code:

SELECT * FROM `item_proto`;
INSERT INTO `item_proto` VALUES ('12680', '¹«´ç80+0', 'Seelensplitterhut +0', '2', '1', '0', '1', '28', '0', '2', '', '20000', '20000', '12681', '343', '0', '15', '1', '80', '0', '0', '13', '1', '0', '0', '0', '0', '0', '13', '0', '0', '0', '4', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12681', '¹«´ç80+1', 'Seelensplitterhut +1', '2', '1', '0', '1', '28', '0', '2', '', '20000', '30000', '12682', '344', '0', '15', '1', '80', '0', '0', '13', '2', '0', '0', '0', '0', '0', '13', '0', '0', '0', '6', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12682', '¹«´ç80+2', 'Seelensplitterhut +2', '2', '1', '0', '1', '28', '0', '2', '', '20000', '45000', '12683', '345', '0', '15', '1', '80', '0', '0', '13', '3', '0', '0', '0', '0', '0', '13', '0', '0', '0', '8', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12683', '¹«´ç80+3', 'Seelensplitterhut +3', '2', '1', '0', '1', '28', '0', '2', '', '20000', '70000', '12684', '346', '0', '15', '1', '80', '0', '0', '13', '4', '0', '0', '0', '0', '0', '13', '0', '0', '0', '13', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12684', '¹«´ç80+4', 'Seelensplitterhut +4', '2', '1', '0', '1', '28', '0', '2', '', '20000', '110000', '12685', '347', '0', '15', '1', '80', '0', '0', '13', '5', '0', '0', '0', '0', '0', '13', '0', '0', '0', '18', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12685', '¹«´ç80+5', 'Seelensplitterhut +5', '2', '1', '0', '1', '284', '0', '2', '', '20000', '170000', '12686', '348', '0', '15', '1', '80', '0', '0', '13', '6', '0', '0', '0', '0', '0', '13', '0', '0', '0', '23', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12686', '¹«´ç80+6', 'Seelensplitterhut +6', '2', '1', '0', '1', '284', '0', '2', '', '20000', '260000', '12687', '349', '0', '15', '1', '80', '0', '0', '13', '7', '0', '0', '0', '0', '0', '13', '0', '0', '0', '28', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12687', '¹«´ç80+7', 'Seelensplitterhut +7', '2', '1', '0', '1', '284', '0', '2', '', '20000', '390000', '12688', '350', '0', '15', '1', '80', '0', '0', '13', '8', '0', '0', '0', '0', '0', '13', '0', '0', '0', '33', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12688', '¹«´ç80+8', 'Seelensplitterhut +8', '2', '1', '0', '1', '284', '0', '2', '', '20000', '590000', '12689', '351', '0', '15', '1', '80', '0', '0', '13', '10', '0', '0', '0', '0', '0', '13', '0', '0', '0', '38', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12689', '¹«´ç80+9', 'Seelensplitterhut +9', '2', '1', '0', '1', '284', '0', '2', '', '20000', '890000', '0', '0', '0', '15', '1', '80', '0', '0', '13', '12', '0', '0', '0', '0', '0', '13', '0', '0', '0', '43', '0', '127', '127', '127', '127', '127', '0', '0', '0
INSERT INTO `item_proto` VALUES ('12390', 'ÀÚ°´60+0 ', 'Orkkapuze +0', '2', '1', '0', '1', '52', '0', '2', '', '20000', '30000', '12391', '343', '0', '15', '1', '60', '1', '0', '27', '1', '0', '0', '0', '0', '0', '13', '0', '0', '0', '2', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12391', 'ÀÚ°´60+1', 'Orkkapuze +1', '2', '1', '0', '1', '52', '0', '2', '', '20000', '45000', '12392', '344', '0', '15', '1', '60', '1', '0', '27', '2', '0', '0', '0', '0', '0', '13', '0', '0', '0', '4', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12392', 'ÀÚ°´60+2', 'Orkkapuze +2', '2', '1', '0', '1', '52', '0', '2', '', '20000', '70000', '12393', '345', '0', '15', '1', '60', '1', '0', '27', '3', '0', '0', '0', '0', '0', '13', '0', '0', '0', '6', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12393', 'ÀÚ°´60+3', 'Orkkapuze +3', '2', '1', '0', '1', '52', '0', '2', '', '20000', '110000', '12394', '346', '0', '15', '1', '60', '1', '0', '27', '4', '0', '0', '0', '0', '0', '13', '0', '0', '0', '8', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12394', 'ÀÚ°´60+4', 'Orkkapuze +4', '2', '1', '0', '1', '308', '0', '2', '', '20000', '170000', '12395', '347', '0', '15', '1', '60', '1', '0', '27', '5', '0', '0', '0', '0', '0', '13', '0', '0', '0', '13', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12395', 'ÀÚ°´60+5', 'Orkkapuze +5', '2', '1', '0', '1', '308', '0', '2', '', '20000', '260000', '12396', '348', '0', '15', '1', '60', '1', '0', '27', '6', '0', '0', '0', '0', '0', '13', '0', '0', '0', '18', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12396', 'ÀÚ°´60+6', 'Orkkapuze +6', '2', '1', '0', '1', '308', '0', '2', '', '20000', '390000', '12397', '349', '0', '15', '1', '60', '1', '0', '27', '7', '0', '0', '0', '0', '0', '13', '0', '0', '0', '23', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12397', 'ÀÚ°´60+7', 'Orkkapuze +7', '2', '1', '0', '1', '308', '0', '2', '', '20000', '590000', '12398', '350', '0', '15', '1', '60', '1', '0', '27', '8', '0', '0', '0', '0', '0', '13', '0', '0', '0', '28', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12398', 'ÀÚ°´60+8', 'Orkkapuze +8', '2', '1', '0', '1', '308', '0', '2', '', '20000', '890000', '12399', '351', '0', '15', '1', '60', '1', '0', '27', '9', '0', '0', '0', '0', '0', '13', '0', '0', '0', '33', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12399', 'ÀÚ°´60+9', 'Orkkapuze +9', '2', '1', '0', '1', '308', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '60', '1', '0', '27', '10', '0', '0', '0', '0', '0', '13', '0', '0', '0', '38', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12400', 'ÀÚ°´80+0', 'Spinnenkapuze +0', '2', '1', '0', '1', '52', '0', '2', '', '20000', '30000', '12401', '343', '0', '15', '1', '80', '0', '0', '13', '1', '0', '0', '0', '0', '0', '13', '0', '0', '0', '4', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12401', 'ÀÚ°´80+1', 'Spinnenkapuze +1', '2', '1', '0', '1', '52', '0', '2', '', '20000', '45000', '12402', '344', '0', '15', '1', '80', '0', '0', '13', '2', '0', '0', '0', '0', '0', '13', '0', '0', '0', '6', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12402', 'ÀÚ°´80+2', 'Spinnenkapuze +2', '2', '1', '0', '1', '52', '0', '2', '', '20000', '70000', '12403', '345', '0', '15', '1', '80', '0', '0', '13', '3', '0', '0', '0', '0', '0', '13', '0', '0', '0', '8', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12403', 'ÀÚ°´80+3', 'Spinnenkapuze +3', '2', '1', '0', '1', '52', '0', '2', '', '20000', '110000', '12404', '346', '0', '15', '1', '80', '0', '0', '13', '4', '0', '0', '0', '0', '0', '13', '0', '0', '0', '13', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12404', 'ÀÚ°´80+4', 'Spinnenkapuze +4', '2', '1', '0', '1', '52', '0', '2', '', '20000', '170000', '12405', '347', '0', '15', '1', '80', '0', '0', '13', '5', '0', '0', '0', '0', '0', '13', '0', '0', '0', '18', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12405', 'ÀÚ°´80+5', 'Spinnenkapuze +5', '2', '1', '0', '1', '308', '0', '2', '', '20000', '260000', '12406', '348', '0', '15', '1', '80', '0', '0', '13', '6', '0', '0', '0', '0', '0', '13', '0', '0', '0', '23', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12406', 'ÀÚ°´80+6', 'Spinnenkapuze +6', '2', '1', '0', '1', '308', '0', '2', '', '20000', '390000', '12407', '349', '0', '15', '1', '80', '0', '0', '13', '7', '0', '0', '0', '0', '0', '13', '0', '0', '0', '28', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12407', 'ÀÚ°´80+7', 'Spinnenkapuze +7', '2', '1', '0', '1', '308', '0', '2', '', '20000', '590000', '12408', '350', '0', '15', '1', '80', '0', '0', '13', '8', '0', '0', '0', '0', '0', '13', '0', '0', '0', '33', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12408', 'ÀÚ°´80+8', 'Spinnenkapuze +8', '2', '1', '0', '1', '308', '0', '2', '', '20000', '890000', '12409', '351', '0', '15', '1', '80', '0', '0', '13', '10', '0', '0', '0', '0', '0', '13', '0', '0', '0', '38', '0', '127', '127', '127', '127', '127', '0', '0', '0');
INSERT INTO `item_proto` VALUES ('12409', 'ÀÚ°´80+9', 'Spinnenkapuze +9', '2', '1', '0', '1', '308', '0', '2', '', '20000', '890000', '0', '0', '0', '0', '1', '80', '0', '0', '13', '12', '0', '0', '0', '0', '0', '13', '0', '0', '0', '43', '0', '127', '127', '127', '127', '127', '0', '0', '0');

~~ShyLu~~ · 04/02/2012, 22:08

#problem hat sich gelöst hab ihm geholfen

xllMethoXx · 04/02/2012, 22:10

Einfach die Query eines anderes Helms nehmen & in die Vnum des neuen Helms umschreiben

~~Ytura~~ · 04/02/2012, 22:13

Quote:

Originally Posted by .ісз

#problem hat sich gelöst hab ihm geholfen

Haben wir erst gedacht, geht aber doch nicht

Quote:

Originally Posted by αη∂яєу *__[xllMethoXx]__*

Einfach die Query eines anderes Helms nehmen & in die Vnum des neuen Helms umschreiben

Aufjedenfall, jeder Helm hat andere Werte, wegen dieser NUMMER welche Klassen den Helm anziehen kann usw..

xllMethoXx · 04/02/2012, 22:20

Diese kannst du doch dann ändern O.o

~~Ytura~~ · 04/03/2012, 13:47

Klar ich weiss auch 20 Nummern oder so aussen Kopf..

xllMethoXx · 04/04/2012, 13:31

1 - max tp
2 - max mp
3 - vit
4 - int
5 - str
6 - dex
7 - angreiffsgeschwindigkeit
8 - bewegungsgeschwindigket
9 - skill speed
10 - tp reg
11 - mp reg
12 - vergiftungschance
13 - ohnmachtschance
14 - verlangsamungschance
15 - krit chance
16 - durchbruchchance
17 - stark gegen halbmenschen
18 - stark gegen tiere
19 - stark gegen orks
20 - stark gegen esos
21 - stark gegen untote
22 - stark gegen teufel
23 - schaden wird von tp absorbiert
24 - schaden wird von mp absorbiert
25 - chance mp des gegners zu übernehmen
26 - chance mp bei treffer zurückzuerhalten
27 - chance körperlichen angrif abzublocken
28 - chance pfeilangriff auszuweichen
29 - schwertverteidigung
30 - zweihandverteidigung
31 - dolchverteidigung
32 - glockenverteidigung
33 - fächerverteidigung
34 - pfeilwiderstand
35 - feuerwiderstand
36 - blitzwiderstand
37 - magiewiderstand
38 - windwiderstand
39 - chance körperlichen angriff zu reflecktieren
40 - chance fluch zu reflecktieren
41 - giftwiderstand
42 - chance mp wiederherzustellen
43 - chance auf exp bonus
44 - chance doppelte menge yang zu droppen
45 - chance doppelte mege gegenstände zu droppen
46 - trank effeckt zuwachs
47 - chance tp wiederherrzustellen
48 - abwehr gegen ohnmacht
49 - abwehr gegen verlangsamen
50 - immun gegen stürzen
52 - bogenreichweite +?m
53 - angriffswert +
54 - verteidigung
55 - magischer angriffswert
56 - magische verteidigung
58 - max ausdauer
59 - stark gegen krieger
60 - stark gegen ninja
61 - stark gegen sura
62 - stark gegen schamanen
63 - stark gegen monster
64 - angriffswert +?
65 - verteidigung
66 - exp +?%
67 - dropchance von gegenständen [??,?]
68 - dropchance von gold [??,?]
71 - fertigkeitsschaden
72 - durchschnitsschaden
73 - widerstand gegen fertigkeitsschaden
74 - durchschn. schadenswiderstand
76 - iCafe exp-bonus
77 - iCafe chance auf erbeuten von gegenständen
78 - abwehrchance gegen kriegerangriffe
79 - abwehrchance gegen ninjaangriffe
80 - abwehrchance gegen suraangriffe
81 - abwehrchance gegen schamanenangriffe