Piedras +9, bonus 6.7 y perlas de colores ayudaaaaa!!!

Topic created · 2 Mensajes · 217 Visitas
  • Hola, alquien tiene las quest para implementar:

    • Piedras +9

    • Bonus 6 7

    • Perlas de colores

    Si alguien me lo pudiera facilitar estaria muy agradecido

    Gracias, un saludo

  • Hola amigo buen dia,
    Mira:, esto es la query que pones en Navicat:

    INSERT INTO item_proto VALUES (28930, 'Pietra della Perforaz+9 ', 'Pietra della Perforaz. +9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 16, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28931, 'Pietra Colpo Mort.+9 ', 'Pietra Colpo Mort. +9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 15, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28932, 'Pietra della Ripetiz.+9 ', 'Pietra della Ripetiz. +9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 9, 80, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28933, 'Pietra anti War+9 ', 'Pietra anti War+9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 59, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28934, 'Pietra anti Ninja+9 ', 'Pietra anti Ninja+9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 60, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28935, 'Pietra anti Sura+9 ', 'Pietra anti Sura+9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 61, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28936, 'Pietra anti Shamana+9 ', 'Pietra anti Shamana+9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 62, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28937, 'Pietra anti Mostro+9 ', 'Pietra anti Mostro+9', 10, 0, 0, 1, 0, 0, 16, '0', 0, 0, 0, 0, 0, 0, 63, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28938, 'Pietra dell' Evasione+9 ', 'Pietra dell' Evasione+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 27, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28939, 'Pietra dell' Inchino+9 ', 'Pietra dell' Inchino+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 28, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 26, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28940, 'Pietra della Magia+9 ', 'Pietra della Magia+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 2, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 27, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28941, 'Pietra della Vitalità+9 ', 'Pietra della Vitalità+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 1, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28942, 'Pietra della Difesa+9 ', 'Pietra della Difesa+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 65, 4000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 29, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);
    INSERT INTO item_proto VALUES (28943, 'Pietra della Fretta+9 ', 'Pietra della Fretta+9', 10, 0, 0, 1, 0, 0, 1, '0', 0, 0, 0, 0, 0, 0, 8, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30, 0, 64992, 127, 64976, 21631, 4855, 0, 0, 0, 0, 0);

    Y estos van en el item proto del cliente:

    ######Item vnum="28931" hashName="'Àü¿µ¼ö¼(r)+9'" name="Pietra Colpo Mort+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="15" applyvalue0="40" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="18" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28932" hashName="'°*¿µ¼ö¼(r)+9'" name="Pietra della Ripetiz+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="9" applyvalue0="80" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="19" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28933" hashName="'Áö¿µ¼ö¼(r)+9'" name="Pietra anti Guerriero+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="59" applyvalue0="60" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="20" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28934" hashName="'ȸ¿µ¼ö¼(r)+9'" name="Pietra anti Ninja+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="60" applyvalue0="60" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="21" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28935" hashName="'º¹¿µ¼ö¼(r)+9'" name="Pietra anti Sura+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="61" applyvalue0="60" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="22" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28936" hashName="'ÁÖ¿µ¼ö¼(r)+9'" name="Pietra anti Shamy+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="62" applyvalue0="60" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="23" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28937" hashName="'¿ª¿µ¼ö¼(r)+9'" name="Pietra del Mostro+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="16" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="63" applyvalue0="40" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="24" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28938" hashName="'Ÿ¿µ¼ö¼(r)+9'" name="Pietra dell'Evasione.+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="27" applyvalue0="40" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="25" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28939" hashName="'È渶¿µ¼ö¼(r)+9'" name="Pietra dell'Inchino+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="28" applyvalue0="40" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="26" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28940" hashName="'¾Ï¸¶¿µ¼ö¼(r)+9'" name="Pietra della Magia+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="2" applyvalue0="4000" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="27" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28941" hashName="'Å뿵¼ö¼(r)+9'" name="Pietra della Vitalità+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="1" applyvalue0="4000" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="28" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28942" hashName="'*É¿µ¼ö¼(r)+9'" name="Pietra della Difesa+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="65" applyvalue0="250" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="29" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
    ######Item vnum="28943" hashName="'»ì¿µ¼ö¼(r)+9'" name="Pietra della Fretta+9" type="10" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="1" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="8" applyvalue0="80" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="30" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />