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

[Problem] Zapytania Query

DarkNightxx

Rekomendowane odpowiedzi

DarkNightxx Pomocnik

DarkNightxx

Opublikowano
Pomocnik

DarkNightxx

Opublikowano

Witam mam problem z przerobienie query na 2010

 

 

Oot zapytania

 

 

 

INSERT INTO `item_proto` VALUES ('30187', 'Probka Piekielnego Kamienia', 'Probka Piekielnego Kamienia, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30267', 'Oko Aethira', 'Oko Aethira, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('71057', 'Smoczy Krysztal', 'Smoczy Krysztal, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30254', 'Odlamek Piekielnego Kamienia', 'Odlamek Piekielnego Kamienia, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('71056', 'Kula Blasku', 'Kula Blasku, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30203', 'Smoczy Pryzmat', 'Smoczy Pryzmat, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('70045', 'Kiel Mlodego Smoka', 'Kiel Mlodego Smoka, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30189', 'Smoczy Pyl', 'Smoczy Pyl, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('71100', 'Podpis Trzech Krolestw', 'Podpis Trzech Krolestw, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30129', 'List Druida', 'List Druida, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('70019', 'Smoczy Wisiorek', 'Smoczy Wisiorek, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('50033', 'Szkatulka Przeznaczenia', 'Szkatulka Przeznaczenia, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30144', 'Smoczy Podmuch', 'Smoczy Podmuch, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('27999', 'Sakwa Aethira', 'Sakwa Aethira, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('70029', 'Zaklety Plomien', 'Zaklety Plomien, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('30183', 'Glowa Beredosa', 'Glowa Beredosa, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('70030', 'Insygnia Zlego Krola', 'Insygnia Zlego Krola, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

INSERT INTO `item_proto` VALUES ('70015', 'Sztylet Beredosa', 'Sztylet Beredosa, '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '0', '0');

 

 

 

 

i gdy chcem wgrac je w FTP wyskakuje w mysql takie cos

 

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0', '0', '1', '1', '0', '1', '0', '', '50000', '20000', '0', '0', '0', '15', '1'' at line 1

 

 

i tak do gazdego zapytania kto pomoze limit lajkow

 

 

@edit przy okazji mysle ze w clietn jest dobzre ale na wszelki wypadek tez podam :)

 

 

 

 

Item vnum="30187" name="Probka Piekielnego Kamienia" gb2312name="Probka Piekielnego Kamienia" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30267" name="Oko Aethira" gb2312name="Oko Aethira" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="71057" name="Smoczy Krysztal" gb2312name="Smoczy Krysztal" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30254" name="Odlamek Piekielnego Kamienia" gb2312name="Odlamek Piekielnego Kamienia" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="71056" name="Kula Blasku" gb2312name="Kula Blasku" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30203" name="Smoczy Pryzmat" gb2312name="Smoczy Pryzmat" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="70045" name="Kiel Mlodego Smoka" gb2312name="Kiel Mlodego Smoka" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30189" name="Smoczy Pyl" gb2312name="Smoczy Pyl" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="71100" name="Podpis Trzech Krolestw" gb2312name="Podpis Trzech Krolestw" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30129" name="List Druida" gb2312name="List Druida" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="70019" name="Smoczy Wisiorek" gb2312name="Smoczy Wisiorek" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="50033" name="Szkatulka Przeznaczenia" gb2312name="Szkatulka Przeznaczenia" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30144" name="Smoczy Podmuch" gb2312name="Smoczy Podmuch" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="27999" name="Sakwa Aethira" gb2312name="Sakwa Aethira" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="70029" name="Zaklety Plomien" gb2312name="Zaklety Plomien" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="30183" name="Glowa Beredosa" gb2312name="Glowa Beredosa" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="70030" name="Insygnia Zlego Krola" gb2312name="Insygnia Zlego Krola" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

<Item vnum="70015" name="Sztylet Beredosa" gb2312name="Sztylet Beredosa" type="0" subtype="0" weight="1" size="1" antiflag="0" flag="1" wearflag="0" immuneflag="0" gold="20000" buy_price="50000" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" 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="11" refine_set="1" magic_pct="15" specular="0" socket_pct="0" />

 

68888487823051815750.png

ProfesorPSK Pomocnik

ProfesorPSK

Opublikowano
Pomocnik

ProfesorPSK

Opublikowano

Mam Ten Sam Problem

Oto Zapytanie:

 

INSERT INTO `item_proto` VALUES ('75003', ''Modna Fryzura (nieb.)'', 'Modna Fryzura (nieb.)', '18', '10', '0', '1', '106938', '8192', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '65008', '127', '64992', '21631', '4855', '0', '0', '0');

 

A to błąd:

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Modna Fryzura (nieb.)'', 'Modna Fryzura (nieb.)', '18', '10', '0', '1', '106938'' at line 1

 

 

 

 

 

 

 

 

 

czego tu szukasz ?

 

 

 

 

 

 

 

 

ProfesorPSK Pomocnik

ProfesorPSK

Opublikowano
Pomocnik

ProfesorPSK

Opublikowano

Wiem już to naprawiłem

 

Ps: Dzięki za Odpowiedz :P

 

 

 

 

 

 

 

 

 

czego tu szukasz ?

 

 

 

 

 

 

 

 

Zarchiwizowany

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

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