Ultimo post e mando onnn

Offline 
Stato
Discussione chiusa ad ulteriori risposte.

TheDark AkA Treni

Utente Electrum
1 Gennaio 2013
367
43
54
198
Raga queste sono me mie ultime richieste e starto server:
1) le query delle armi e armature beta e come implementarele in navicat
2)come mettere item uppabili
 
Asd, come implementarli, penso ke il procedimento sia sempre lo stesso, vorrei sapere come ti chiami su skype, perkè mi sembra di conoscerti.allora
-Starta server
-Entra nel db
-Vai su player
-Quando clicchi su player appaiono delle cosette sotto ovvero tables-queries ec...
-Vai su queries e fai new queries e ci incolli questo
siccome nn so fare uno spoiler, sono obbligato a dartele qua <.<
ci incolli queste query per le armature :
INSERT INTO item_proto SET vnum='20500', name='Abbigliamento Dorato+0', locale_name='Abbigliamento Dorato+0', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20501', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20501', name='Abbigliamento Dorato+1', locale_name='Abbigliamento Dorato+1', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20502', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20502', name='Abbigliamento Dorato+2', locale_name='Abbigliamento Dorato+2', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20503', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20503', name='Abbigliamento Dorato+3', locale_name='Abbigliamento Dorato+3', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20504', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20504', name='Abbigliamento Dorato+4', locale_name='Abbigliamento Dorato+4', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20505', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20505', name='Abbigliamento Dorato+5', locale_name='Abbigliamento Dorato+5', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20506', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20506', name='Abbigliamento Dorato+6', locale_name='Abbigliamento Dorato+6', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20507', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20507', name='Abbigliamento Dorato+7', locale_name='Abbigliamento Dorato+7', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20508', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20508', name='Abbigliamento Dorato+8', locale_name='Abbigliamento Dorato+8', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20509', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20509', name='Abbigliamento Dorato+9', locale_name='Abbigliamento Dorato+9', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20750', name='Arm. a Placche Ossee+0', locale_name='Arm. a Placche Ossee+0', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20751', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20751', name='Arm. a Placche Ossee+1', locale_name='Arm. a Placche Ossee+1', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20752', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20752', name='Arm. a Placche Ossee+2', locale_name='Arm. a Placche Ossee+2', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20753', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20753', name='Arm. a Placche Ossee+3', locale_name='Arm. a Placche Ossee+3', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20754', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20754', name='Arm. a Placche Ossee+4', locale_name='Arm. a Placche Ossee+4', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20755', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20755', name='Arm. a Placche Ossee+5', locale_name='Arm. a Placche Ossee+5', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20756', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20756', name='Arm. a Placche Ossee+6', locale_name='Arm. a Placche Ossee+6', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20757', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20757', name='Arm. a Placche Ossee+7', locale_name='Arm. a Placche Ossee+7', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20758', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20758', name='Arm. a Placche Ossee+8', locale_name='Arm. a Placche Ossee+8', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20759', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20759', name='Arm. a Placche Ossee+9', locale_name='Arm. a Placche Ossee+9', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20000', name='Corazza Corno Diavolo+0', locale_name='Corazza Corno Diavolo+0', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20001', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20001', name='Corazza Corno Diavolo+1', locale_name='Corazza Corno Diavolo+1', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20002', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20002', name='Corazza Corno Diavolo+2', locale_name='Corazza Corno Diavolo+2', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20003', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20003', name='Corazza Corno Diavolo+3', locale_name='Corazza Corno Diavolo+3', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20004', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20004', name='Corazza Corno Diavolo+4', locale_name='Corazza Corno Diavolo+4', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20005', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20005', name='Corazza Corno Diavolo+5', locale_name='Corazza Corno Diavolo+5', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20006', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20006', name='Corazza Corno Diavolo+6', locale_name='Corazza Corno Diavolo+6', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20007', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20007', name='Corazza Corno Diavolo+7', locale_name='Corazza Corno Diavolo+7', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20008', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20008', name='Corazza Corno Diavolo+8', locale_name='Corazza Corno Diavolo+8', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20009', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20009', name='Corazza Corno Diavolo+9', locale_name='Corazza Corno Diavolo+9', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO `item_proto` VALUES ('20250', 0x416269746F20436176616C6361647261676869202B30, 0x416269746F20436176616C6361647261676869202B30, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20251', '0', '0', '15', '1', '90', '0', '0', '27', '1', '8', '5', '1', '500', '0', '350', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20251', 0x416269746F20436176616C6361647261676869202B31, 0x416269746F20436176616C6361647261676869202B31, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20252', '0', '0', '15', '1', '92', '0', '0', '27', '3', '8', '9', '1', '1000', '0', '422', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20252', 0x416269746F20436176616C6361647261676869202B32, 0x416269746F20436176616C6361647261676869202B32, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20253', '0', '0', '15', '1', '94', '0', '0', '27', '4', '8', '13', '1', '1500', '0', '494', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20253', 0x416269746F20436176616C6361647261676869202B33, 0x416269746F20436176616C6361647261676869202B33, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20254', '0', '0', '15', '1', '96', '0', '0', '27', '6', '8', '17', '1', '2000', '0', '566', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20254', 0x416269746F20436176616C6361647261676869202B34, 0x416269746F20436176616C6361647261676869202B34, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20255', '0', '0', '15', '1', '98', '0', '0', '27', '7', '8', '21', '1', '2500', '0', '638', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20255', 0x416269746F20436176616C6361647261676869202B35, 0x416269746F20436176616C6361647261676869202B35, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20256', '0', '0', '15', '1', '100', '0', '0', '27', '9', '8', '24', '1', '3000', '0', '711', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20256', 0x416269746F20436176616C6361647261676869202B36, 0x416269746F20436176616C6361647261676869202B36, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20257', '0', '0', '15', '1', '102', '0', '0', '27', '10', '8', '28', '1', '3500', '0', '783', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20257', 0x416269746F20436176616C6361647261676869202B37, 0x416269746F20436176616C6361647261676869202B37, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20258', '0', '0', '15', '1', '104', '0', '0', '27', '12', '8', '32', '1', '4000', '0', '855', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20258', 0x416269746F20436176616C6361647261676869202B38, 0x416269746F20436176616C6361647261676869202B38, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20259', '0', '0', '15', '1', '104', '0', '0', '27', '13', '8', '36', '1', '4500', '0', '927', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20259', 0x416269746F20436176616C6361647261676869202B39, 0x416269746F20436176616C6361647261676869202B39, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '0', '0', '0', '15', '1', '105', '0', '0', '27', '15', '8', '40', '1', '5000', '0', '1000', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
e fai run, quando finisce salva col nome.nn ho capito cosa intendi x item upp asd spiegati meglio <.<


- - - Updated - - -

Asd, come implementarli, penso ke il procedimento sia sempre lo stesso, vorrei sapere come ti chiami su skype, perkè mi sembra di conoscerti.allora
-Starta server
-Entra nel db
-Vai su player
-Quando clicchi su player appaiono delle cosette sotto ovvero tables-queries ec...
-Vai su queries e fai new queries e ci incolli questo
siccome nn so fare uno spoiler, sono obbligato a dartele qua <.<
ci incolli queste query per le armature :
INSERT INTO item_proto SET vnum='20500', name='Abbigliamento Dorato+0', locale_name='Abbigliamento Dorato+0', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20501', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20501', name='Abbigliamento Dorato+1', locale_name='Abbigliamento Dorato+1', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20502', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20502', name='Abbigliamento Dorato+2', locale_name='Abbigliamento Dorato+2', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20503', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20503', name='Abbigliamento Dorato+3', locale_name='Abbigliamento Dorato+3', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20504', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20504', name='Abbigliamento Dorato+4', locale_name='Abbigliamento Dorato+4', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20505', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20505', name='Abbigliamento Dorato+5', locale_name='Abbigliamento Dorato+5', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20506', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20506', name='Abbigliamento Dorato+6', locale_name='Abbigliamento Dorato+6', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20507', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20507', name='Abbigliamento Dorato+7', locale_name='Abbigliamento Dorato+7', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20508', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20508', name='Abbigliamento Dorato+8', locale_name='Abbigliamento Dorato+8', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20509', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20509', name='Abbigliamento Dorato+9', locale_name='Abbigliamento Dorato+9', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20750', name='Arm. a Placche Ossee+0', locale_name='Arm. a Placche Ossee+0', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20751', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20751', name='Arm. a Placche Ossee+1', locale_name='Arm. a Placche Ossee+1', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20752', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20752', name='Arm. a Placche Ossee+2', locale_name='Arm. a Placche Ossee+2', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20753', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20753', name='Arm. a Placche Ossee+3', locale_name='Arm. a Placche Ossee+3', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20754', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20754', name='Arm. a Placche Ossee+4', locale_name='Arm. a Placche Ossee+4', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20755', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20755', name='Arm. a Placche Ossee+5', locale_name='Arm. a Placche Ossee+5', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20756', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20756', name='Arm. a Placche Ossee+6', locale_name='Arm. a Placche Ossee+6', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20757', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20757', name='Arm. a Placche Ossee+7', locale_name='Arm. a Placche Ossee+7', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20758', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20758', name='Arm. a Placche Ossee+8', locale_name='Arm. a Placche Ossee+8', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20759', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20759', name='Arm. a Placche Ossee+9', locale_name='Arm. a Placche Ossee+9', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20000', name='Corazza Corno Diavolo+0', locale_name='Corazza Corno Diavolo+0', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20001', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20001', name='Corazza Corno Diavolo+1', locale_name='Corazza Corno Diavolo+1', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20002', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20002', name='Corazza Corno Diavolo+2', locale_name='Corazza Corno Diavolo+2', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20003', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20003', name='Corazza Corno Diavolo+3', locale_name='Corazza Corno Diavolo+3', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20004', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20004', name='Corazza Corno Diavolo+4', locale_name='Corazza Corno Diavolo+4', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20005', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20005', name='Corazza Corno Diavolo+5', locale_name='Corazza Corno Diavolo+5', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20006', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20006', name='Corazza Corno Diavolo+6', locale_name='Corazza Corno Diavolo+6', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20007', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20007', name='Corazza Corno Diavolo+7', locale_name='Corazza Corno Diavolo+7', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20008', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20008', name='Corazza Corno Diavolo+8', locale_name='Corazza Corno Diavolo+8', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20009', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20009', name='Corazza Corno Diavolo+9', locale_name='Corazza Corno Diavolo+9', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO `item_proto` VALUES ('20250', 0x416269746F20436176616C6361647261676869202B30, 0x416269746F20436176616C6361647261676869202B30, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20251', '0', '0', '15', '1', '90', '0', '0', '27', '1', '8', '5', '1', '500', '0', '350', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20251', 0x416269746F20436176616C6361647261676869202B31, 0x416269746F20436176616C6361647261676869202B31, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20252', '0', '0', '15', '1', '92', '0', '0', '27', '3', '8', '9', '1', '1000', '0', '422', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20252', 0x416269746F20436176616C6361647261676869202B32, 0x416269746F20436176616C6361647261676869202B32, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20253', '0', '0', '15', '1', '94', '0', '0', '27', '4', '8', '13', '1', '1500', '0', '494', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20253', 0x416269746F20436176616C6361647261676869202B33, 0x416269746F20436176616C6361647261676869202B33, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20254', '0', '0', '15', '1', '96', '0', '0', '27', '6', '8', '17', '1', '2000', '0', '566', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20254', 0x416269746F20436176616C6361647261676869202B34, 0x416269746F20436176616C6361647261676869202B34, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20255', '0', '0', '15', '1', '98', '0', '0', '27', '7', '8', '21', '1', '2500', '0', '638', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20255', 0x416269746F20436176616C6361647261676869202B35, 0x416269746F20436176616C6361647261676869202B35, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20256', '0', '0', '15', '1', '100', '0', '0', '27', '9', '8', '24', '1', '3000', '0', '711', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20256', 0x416269746F20436176616C6361647261676869202B36, 0x416269746F20436176616C6361647261676869202B36, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20257', '0', '0', '15', '1', '102', '0', '0', '27', '10', '8', '28', '1', '3500', '0', '783', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20257', 0x416269746F20436176616C6361647261676869202B37, 0x416269746F20436176616C6361647261676869202B37, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20258', '0', '0', '15', '1', '104', '0', '0', '27', '12', '8', '32', '1', '4000', '0', '855', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20258', 0x416269746F20436176616C6361647261676869202B38, 0x416269746F20436176616C6361647261676869202B38, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20259', '0', '0', '15', '1', '104', '0', '0', '27', '13', '8', '36', '1', '4500', '0', '927', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20259', 0x416269746F20436176616C6361647261676869202B39, 0x416269746F20436176616C6361647261676869202B39, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '0', '0', '0', '15', '1', '105', '0', '0', '27', '15', '8', '40', '1', '5000', '0', '1000', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
e fai run, quando finisce salva col nome.nn ho capito cosa intendi x item upp asd spiegati meglio <.<
Se nn sbaglio queste sn per l'item proto
 
Asd, come implementarli, penso ke il procedimento sia sempre lo stesso, vorrei sapere come ti chiami su skype, perkè mi sembra di conoscerti.allora
-Starta server
-Entra nel db
-Vai su player
-Quando clicchi su player appaiono delle cosette sotto ovvero tables-queries ec...
-Vai su queries e fai new queries e ci incolli questo
siccome nn so fare uno spoiler, sono obbligato a dartele qua <.<
ci incolli queste query per le armature :
INSERT INTO item_proto SET vnum='20500', name='Abbigliamento Dorato+0', locale_name='Abbigliamento Dorato+0', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20501', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20501', name='Abbigliamento Dorato+1', locale_name='Abbigliamento Dorato+1', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20502', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20502', name='Abbigliamento Dorato+2', locale_name='Abbigliamento Dorato+2', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20503', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20503', name='Abbigliamento Dorato+3', locale_name='Abbigliamento Dorato+3', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20504', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20504', name='Abbigliamento Dorato+4', locale_name='Abbigliamento Dorato+4', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20505', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20505', name='Abbigliamento Dorato+5', locale_name='Abbigliamento Dorato+5', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20506', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20506', name='Abbigliamento Dorato+6', locale_name='Abbigliamento Dorato+6', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20507', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20507', name='Abbigliamento Dorato+7', locale_name='Abbigliamento Dorato+7', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20508', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20508', name='Abbigliamento Dorato+8', locale_name='Abbigliamento Dorato+8', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20509', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20509', name='Abbigliamento Dorato+9', locale_name='Abbigliamento Dorato+9', type='2', subtype='0', weight='0', size='2', antiflag='284', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20750', name='Arm. a Placche Ossee+0', locale_name='Arm. a Placche Ossee+0', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20751', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20751', name='Arm. a Placche Ossee+1', locale_name='Arm. a Placche Ossee+1', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20752', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20752', name='Arm. a Placche Ossee+2', locale_name='Arm. a Placche Ossee+2', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20753', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20753', name='Arm. a Placche Ossee+3', locale_name='Arm. a Placche Ossee+3', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20754', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20754', name='Arm. a Placche Ossee+4', locale_name='Arm. a Placche Ossee+4', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20755', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20755', name='Arm. a Placche Ossee+5', locale_name='Arm. a Placche Ossee+5', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20756', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20756', name='Arm. a Placche Ossee+6', locale_name='Arm. a Placche Ossee+6', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20757', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20757', name='Arm. a Placche Ossee+7', locale_name='Arm. a Placche Ossee+7', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20758', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20758', name='Arm. a Placche Ossee+8', locale_name='Arm. a Placche Ossee+8', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='20759', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20759', name='Arm. a Placche Ossee+9', locale_name='Arm. a Placche Ossee+9', type='2', subtype='0', weight='0', size='2', antiflag='300', flag='1', wearflag='1', immuneflag='0', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20000', name='Corazza Corno Diavolo+0', locale_name='Corazza Corno Diavolo+0', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20001', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='90', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='1', applytype1='8', applyvalue1='5', applytype2='1', applyvalue2='500', value0='0', value1='350', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20001', name='Corazza Corno Diavolo+1', locale_name='Corazza Corno Diavolo+1', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20002', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='92', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='3', applytype1='8', applyvalue1='9', applytype2='1', applyvalue2='1000', value0='0', value1='422', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20002', name='Corazza Corno Diavolo+2', locale_name='Corazza Corno Diavolo+2', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20003', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='94', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='4', applytype1='8', applyvalue1='13', applytype2='1', applyvalue2='1500', value0='0', value1='494', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20003', name='Corazza Corno Diavolo+3', locale_name='Corazza Corno Diavolo+3', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20004', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='96', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='6', applytype1='8', applyvalue1='17', applytype2='1', applyvalue2='2000', value0='0', value1='566', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='0', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20004', name='Corazza Corno Diavolo+4', locale_name='Corazza Corno Diavolo+4', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20005', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='98', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='7', applytype1='8', applyvalue1='21', applytype2='1', applyvalue2='2500', value0='0', value1='638', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='30', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20005', name='Corazza Corno Diavolo+5', locale_name='Corazza Corno Diavolo+5', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20006', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='100', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='9', applytype1='8', applyvalue1='24', applytype2='1', applyvalue2='3000', value0='0', value1='711', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='40', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20006', name='Corazza Corno Diavolo+6', locale_name='Corazza Corno Diavolo+6', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20007', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='102', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='10', applytype1='8', applyvalue1='28', applytype2='1', applyvalue2='3500', value0='0', value1='783', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='50', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20007', name='Corazza Corno Diavolo+7', locale_name='Corazza Corno Diavolo+7', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20008', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='12', applytype1='8', applyvalue1='32', applytype2='1', applyvalue2='4000', value0='0', value1='855', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='65', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20008', name='Corazza Corno Diavolo+8', locale_name='Corazza Corno Diavolo+8', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='20009', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='104', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='13', applytype1='8', applyvalue1='36', applytype2='1', applyvalue2='4500', value0='0', value1='927', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='80', socket_pct='3', addon_type='0';
INSERT INTO item_proto SET vnum='20009', name='Corazza Corno Diavolo+9', locale_name='Corazza Corno Diavolo+9', type='2', subtype='0', weight='0', size='2', antiflag='56', flag='1', wearflag='1', immuneflag='', gold='0', shop_buy_price='0', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='105', limittype1='0', limitvalue1='0', applytype0='27', applyvalue0='15', applytype1='8', applyvalue1='40', applytype2='1', applyvalue2='5000', value0='0', value1='1000', value2='0', value3='13', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';
INSERT INTO `item_proto` VALUES ('20250', 0x416269746F20436176616C6361647261676869202B30, 0x416269746F20436176616C6361647261676869202B30, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20251', '0', '0', '15', '1', '90', '0', '0', '27', '1', '8', '5', '1', '500', '0', '350', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20251', 0x416269746F20436176616C6361647261676869202B31, 0x416269746F20436176616C6361647261676869202B31, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20252', '0', '0', '15', '1', '92', '0', '0', '27', '3', '8', '9', '1', '1000', '0', '422', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20252', 0x416269746F20436176616C6361647261676869202B32, 0x416269746F20436176616C6361647261676869202B32, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20253', '0', '0', '15', '1', '94', '0', '0', '27', '4', '8', '13', '1', '1500', '0', '494', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20253', 0x416269746F20436176616C6361647261676869202B33, 0x416269746F20436176616C6361647261676869202B33, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20254', '0', '0', '15', '1', '96', '0', '0', '27', '6', '8', '17', '1', '2000', '0', '566', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20254', 0x416269746F20436176616C6361647261676869202B34, 0x416269746F20436176616C6361647261676869202B34, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20255', '0', '0', '15', '1', '98', '0', '0', '27', '7', '8', '21', '1', '2500', '0', '638', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20255', 0x416269746F20436176616C6361647261676869202B35, 0x416269746F20436176616C6361647261676869202B35, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20256', '0', '0', '15', '1', '100', '0', '0', '27', '9', '8', '24', '1', '3000', '0', '711', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20256', 0x416269746F20436176616C6361647261676869202B36, 0x416269746F20436176616C6361647261676869202B36, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20257', '0', '0', '15', '1', '102', '0', '0', '27', '10', '8', '28', '1', '3500', '0', '783', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20257', 0x416269746F20436176616C6361647261676869202B37, 0x416269746F20436176616C6361647261676869202B37, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20258', '0', '0', '15', '1', '104', '0', '0', '27', '12', '8', '32', '1', '4000', '0', '855', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20258', 0x416269746F20436176616C6361647261676869202B38, 0x416269746F20436176616C6361647261676869202B38, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '20259', '0', '0', '15', '1', '104', '0', '0', '27', '13', '8', '36', '1', '4500', '0', '927', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
INSERT INTO `item_proto` VALUES ('20259', 0x416269746F20436176616C6361647261676869202B39, 0x416269746F20436176616C6361647261676869202B39, '2', '0', '0', '2', '308', '1', '1', '', '0', '0', '0', '0', '0', '15', '1', '105', '0', '0', '27', '15', '8', '40', '1', '5000', '0', '1000', '0', '13', '0', '0', '-1', '-1', '-1', '-1', '-1', '-1', '0', '3', '0');
e fai run, quando finisce salva col nome.nn ho capito cosa intendi x item upp asd spiegati meglio <.<


- - - Updated - - -


Se nn sbaglio queste sn per l'item proto

Ma che sono, i promessi sposi? :coniglio:
 
madonnamia quanto spam..
cerco le query (o come si kiamano)
ke si mettono in navicat
e cm si mettono gli item uppabili
ki sa fare entrambe le cose o anke solo una
mi contatti su skype:lampadabianca
 
madonnamia quanto spam..
cerco le query (o come si kiamano)
ke si mettono in navicat
e cm si mettono gli item uppabili
ki sa fare entrambe le cose o anke solo una
mi contatti su skype:lampadabianca
















Non prenderla male ma se non sai fare nemmeno le query e inutile aprire un server.
 
Peccato che hai fatto un leggerissimo necropost xD Occhio che qui i mod sono alquanto voraci di carne fresca da mietere D: (questa mi è uscita male)
 
Stato
Discussione chiusa ad ulteriori risposte.

DISCUSSIONI SIMILI

Indietro
Top Bottom