Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

[Pytanie] Czy dobrze napisałem zapytania ? Item_Proto.

GoldenCraft

Rekomendowane odpowiedzi

GoldenCraft Znawca

GoldenCraft

Opublikowano
Znawca

GoldenCraft

Opublikowano

Witam mam pytanie.. czy napisałem poprawnie o to te zapytania:

 

Item_Proto Serwerowe:

 


INSERT INTO `item_proto` VALUES ('20001', 'Zbroja Lorda +9', 'Zbroja Lorda +9', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '0', '0', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20002', 'Zbroja Lorda +8', 'Zbroja Lorda +8, '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '1', '1', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20003', 'Zbroja Lorda +7', 'Zbroja Lorda +7', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '2', '2', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20004', 'Zbroja Lorda +6', 'Zbroja Lorda +6', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '3', '3', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20005', 'Zbroja Lorda +5', 'Zbroja Lorda +5', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '4', '4', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20006', 'Zbroja Lorda +4', 'Zbroja Lorda +4', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '5', '5', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20007', 'Zbroja Lorda +3', 'Zbroja Lorda +3', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '6', '6', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20008', 'Zbroja Lorda +2', 'Zbroja Lorda +2', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '7', '7', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20009', 'Zbroja Lorda +1', 'Zbroja Lorda +1', '2', '0', '2', '2', '312', '1', '1', '', '0', '0', '8', '8', '0', '15', '1', '250', '0', '0', '37', '50', '1', '700000', '8', '100', '0', '5000', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');

 

 

Item_Proto Clientowe:


<Item vnum="20001" hashName="Zbroja Lorda +9" name="Zbroja Lorda +9" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="1" refine_set="1" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20002" hashName="Zbroja Lorda +8" name="Zbroja Lorda +8" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="2" refine_set="2" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20003" hashName="Zbroja Lorda +7" name="Zbroja Lorda +7" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="3" refine_set="3" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20004" hashName="Zbroja Lorda +6" name="Zbroja Lorda +6" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="4" refine_set="4" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20005" hashName="Zbroja Lorda +5" name="Zbroja Lorda +5" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="5" refine_set="5" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20006" hashName="Zbroja Lorda +4" name="Zbroja Lorda +4" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="6" refine_set="6" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20007" hashName="Zbroja Lorda +3" name="Zbroja Lorda +3" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="7" refine_set="7" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20008" hashName="Zbroja Lorda +2" name="Zbroja Lorda +2" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="8" refine_set="8" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="20009" hashName="Zbroja Lorda +1" name="Zbroja Lorda +1" type="2" subtype="0" weight="2" size="2" antiflag="312" flag="1" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="250" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="50" applytype1="1" applyvalue1="700000" applytype2="8" applyvalue2="100" value0="0" value1="5000" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64944" socket2="127" socket3="65008" socket4="21631" socket5="4855" refine_vnum="9" refine_set="9" magic_pct="15" specular="0" socket_pct="3" />


image.png

TEKEN5 Bywalec

TEKEN5

Opublikowano
Bywalec

TEKEN5

Opublikowano

Raczej dobrze ;) jesli bd zle to w mysql wywali bledy przy wgrywaniu zapytan.

Pomogłem? Daj Lubie to! :)

 

2252770056.png

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...