Salve ragazzi! Oggi mi ritrovo quì con un errore mai riscontrato da me... Le auto pozze non vanno come dovrebbero andare!
quando le creo con il comando gm spuntano già utilizzare e 0%... datemi una mano... parte client dubito che sia dato che prima andava benissimo con un altro database, che purtroppo adesso non ho più.
le query sono le seguenti:
DB:
Client:
Come vanno in gioco:
[video=youtube;PD6MCFPfIiA]http://www.youtube.com/watch?v=PD6MCFPfIiA&feature=youtu.be[/video]
Come risolvo??? Grazie in anticipo
quando le creo con il comando gm spuntano già utilizzare e 0%... datemi una mano... parte client dubito che sia dato che prima andava benissimo con un altro database, che purtroppo adesso non ho più.
le query sono le seguenti:
DB:
INSERT INTO `item_proto` VALUES ('72723', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C2BC, 0x456C697369722064656C20536F6C6520285029, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72724', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C381, 0x456C697369722064656C20536F6C6520284D29, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72725', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C2B4, 0x456C697369722064656C20536F6C6520284729, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72726', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C2BD, 0x456C697369722064656C20536F6C6520285329, '3', '10', '0', '1', '0', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72727', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2BC, 0x456C697369722064656C6C61204C756E6120285029, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72728', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C381, 0x456C697369722064656C6C61204C756E6120284D29, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72729', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2B4, 0x456C697369722064656C6C61204C756E6120284729, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '700000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72730', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2BD, 0x456C697369722064656C6C61204C756E6120285329, '3', '10', '0', '1', '0', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72724', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C381, 0x456C697369722064656C20536F6C6520284D29, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72725', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C2B4, 0x456C697369722064656C20536F6C6520284729, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72726', 0xC388C2ADC2B7C3A6C380C38720C383C3A0C2BAC2B928C2BD, 0x456C697369722064656C20536F6C6520285329, '3', '10', '0', '1', '0', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72727', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2BC, 0x456C697369722064656C6C61204C756E6120285029, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72728', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C381, 0x456C697369722064656C6C61204C756E6120284D29, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '300000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72729', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2B4, 0x456C697369722064656C6C61204C756E6120284729, '3', '10', '0', '1', '106880', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '700000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('72730', 0xC2BCC3B6C2B7C3A6C380C38720C383C3A0C2BAC2B928C2BD, 0x456C697369722064656C6C61204C756E6120285329, '3', '10', '0', '1', '0', '8196', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1000000', '0', '0', '0', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
<Item vnum="72723" hashName="'È·æÀÇÃà º¹(¼'" name="Elisir del Sole (P)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="1000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72724" hashName="'È·æÀÇÃà º¹(Ã'" name="Elisir del Sole (M)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="3000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72725" hashName="'È·æÀÇÃà º¹(´'" name="Elisir del Sole (G)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="7000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72726" hashName="'È·æÀÇÃà º¹(½'" name="Elisir del Sole (S)" type="3" subtype="10" weight="0" size="1" antiflag="0" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="10000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72727" hashName="'¼ö·æÀÇÃà º¹(¼'" name="Elisir della Luna (P)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="100000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72728" hashName="'¼ö·æÀÇÃà º¹(Ã'" name="Elisir della Luna (M)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="300000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72729" hashName="'¼ö·æÀÇÃà º¹(´'" name="Elisir della Luna (G)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="700000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72730" hashName="'¼ö·æÀÇÃà º¹(½'" name="Elisir della Luna (S)" type="3" subtype="10" weight="0" size="1" antiflag="0" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="1000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72724" hashName="'È·æÀÇÃà º¹(Ã'" name="Elisir del Sole (M)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="3000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72725" hashName="'È·æÀÇÃà º¹(´'" name="Elisir del Sole (G)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="7000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72726" hashName="'È·æÀÇÃà º¹(½'" name="Elisir del Sole (S)" type="3" subtype="10" weight="0" size="1" antiflag="0" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="10000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72727" hashName="'¼ö·æÀÇÃà º¹(¼'" name="Elisir della Luna (P)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="100000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72728" hashName="'¼ö·æÀÇÃà º¹(Ã'" name="Elisir della Luna (M)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="300000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72729" hashName="'¼ö·æÀÇÃà º¹(´'" name="Elisir della Luna (G)" type="3" subtype="10" weight="0" size="1" antiflag="106880" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="700000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
<Item vnum="72730" hashName="'¼ö·æÀÇÃà º¹(½'" name="Elisir della Luna (S)" type="3" subtype="10" weight="0" size="1" antiflag="0" flag="8196" wearflag="0" immuneflag="" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="1000000" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="65535" socket1="65535" socket2="65535" socket3="65535" socket4="65535" socket5="65535" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="3" />
Come vanno in gioco:
[video=youtube;PD6MCFPfIiA]http://www.youtube.com/watch?v=PD6MCFPfIiA&feature=youtu.be[/video]
Come risolvo??? Grazie in anticipo