t4zu scrie:Salutare tuturor. Folosesc un svf+client 40k si doresc sa adaug armuri si arme noi.
Intrebare1: Cum pot sa imi fac urmatorul paragraf pt item_proto (CLIENT), din 34k in 40k?
Intrebare2: Cum pot sa imi fac urmatorul paragraf pt item_proto (SERVER sau mai bine zis querry), din 34k in 40k?
Intrebare3: Care este de mai jos "Sansa de succes", Materialele cerute pentru imbunatatire, si cum pot sa fac ca itemul respectiv sa evolueze din "Vesmant negru+9"?
Intrebare4: Cum procedez ca sa pot implementa armura atat pe server cat si pe client?
Multumesc!

item_proto (CLIENT) - 34k

Cod: Selectaţi tot

<Item vnum="166000" hashName="'Vesmant de Safir+0'" name="Vesmant de Safir+0" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7100000" buy_price="110000" limittype0="1" limitvalue0="71" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="21" applytype1="7" applyvalue1="5" applytype2="0" applyvalue2="0" value0="0" value1="200" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166001" refine_set="166000" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166001" hashName="'Vesmant de Safir+1'" name="Vesmant de Safir+1" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7200000" buy_price="120000" limittype0="1" limitvalue0="72" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="22" applytype1="7" applyvalue1="10" applytype2="0" applyvalue2="0" value0="0" value1="210" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166002" refine_set="166001" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166002" hashName="'Vesmant de Safir+2'" name="Vesmant de Safir+2" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7300000" buy_price="130000" limittype0="1" limitvalue0="73" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="23" applytype1="7" applyvalue1="15" applytype2="0" applyvalue2="0" value0="0" value1="220" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166003" refine_set="166002" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166003" hashName="'Vesmant de Safir+3'" name="Vesmant de Safir+3" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7400000" buy_price="140000" limittype0="1" limitvalue0="74" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="24" applytype1="7" applyvalue1="20" applytype2="0" applyvalue2="0" value0="0" value1="230" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166004" refine_set="166003" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166004" hashName="'Vesmant de Safir+4'" name="Vesmant de Safir+4" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7500000" buy_price="150000" limittype0="1" limitvalue0="75" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="25" applytype1="7" applyvalue1="25" applytype2="0" applyvalue2="0" value0="0" value1="240" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166005" refine_set="166004" magic_pct="15" specular="30" socket_pct="3" />
<Item vnum="166005" hashName="'Vesmant de Safir+5'" name="Vesmant de Safir+5" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7600000" buy_price="160000" limittype0="1" limitvalue0="76" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="26" applytype1="7" applyvalue1="30" applytype2="0" applyvalue2="0" value0="0" value1="250" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166006" refine_set="166005" magic_pct="15" specular="40" socket_pct="3" />
<Item vnum="166006" hashName="'Vesmant de Safir+6'" name="Vesmant de Safir+6" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7700000" buy_price="170000" limittype0="1" limitvalue0="77" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="27" applytype1="7" applyvalue1="35" applytype2="0" applyvalue2="0" value0="0" value1="260" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166007" refine_set="166006" magic_pct="15" specular="50" socket_pct="3" />
<Item vnum="166007" hashName="'Vesmant de Safir+7'" name="Vesmant de Safir+7" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7800000" buy_price="180000" limittype0="1" limitvalue0="78" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="28" applytype1="7" applyvalue1="40" applytype2="0" applyvalue2="0" value0="0" value1="270" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166008" refine_set="166007" magic_pct="15" specular="65" socket_pct="3" />
<Item vnum="166008" hashName="'Vesmant de Safir+8'" name="Vesmant de Safir+8" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7900000" buy_price="190000" limittype0="1" limitvalue0="79" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="29" applytype1="7" applyvalue1="45" applytype2="0" applyvalue2="0" value0="0" value1="280" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166009" refine_set="166008" magic_pct="15" specular="80" socket_pct="3" />
<Item vnum="166009" hashName="'Vesmant de Safir+9'" name="Vesmant de Safir+9" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="8000000" buy_price="200000" limittype0="1" limitvalue0="80" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="30" applytype1="7" applyvalue1="50" applytype2="0" applyvalue2="0" value0="0" value1="290" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="15" specular="100" socket_pct="3" /> 

item_proto (SERVER) - 34k

Cod: Selectaţi tot

INSERT INTO item_proto SET vnum='166000', name='Vesmant de Safir+0', locale_name='Vesmant de Safir+0', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7100000', shop_buy_price='110000', refined_vnum='166001', refine_set='166000', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='71', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='21', applytype1='7', applyvalue1='5', applytype2='0', applyvalue2='0', value0='0', value1='200', value2='0', value3='166000', 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='166001', name='Vesmant de Safir+1', locale_name='Vesmant de Safir+1', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7200000', shop_buy_price='120000', refined_vnum='166002', refine_set='166001', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='72', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='22', applytype1='7', applyvalue1='10', applytype2='0', applyvalue2='0', value0='0', value1='210', value2='0', value3='166000', 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='166002', name='Vesmant de Safir+2', locale_name='Vesmant de Safir+2', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7300000', shop_buy_price='130000', refined_vnum='166003', refine_set='166002', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='73', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='23', applytype1='7', applyvalue1='15', applytype2='0', applyvalue2='0', value0='0', value1='220', value2='0', value3='166000', 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='166003', name='Vesmant de Safir+3', locale_name='Vesmant de Safir+3', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7400000', shop_buy_price='140000', refined_vnum='166004', refine_set='166003', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='74', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='24', applytype1='7', applyvalue1='20', applytype2='0', applyvalue2='0', value0='0', value1='230', value2='0', value3='166000', 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='166004', name='Vesmant de Safir+4', locale_name='Vesmant de Safir+4', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7500000', shop_buy_price='150000', refined_vnum='166005', refine_set='166004', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='75', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='25', applytype1='7', applyvalue1='25', applytype2='0', applyvalue2='0', value0='0', value1='240', value2='0', value3='166000', 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='166005', name='Vesmant de Safir+5', locale_name='Vesmant de Safir+5', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7600000', shop_buy_price='160000', refined_vnum='166006', refine_set='166005', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='76', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='26', applytype1='7', applyvalue1='30', applytype2='0', applyvalue2='0', value0='0', value1='250', value2='0', value3='166000', 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='166006', name='Vesmant de Safir+6', locale_name='Vesmant de Safir+6', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7700000', shop_buy_price='170000', refined_vnum='166007', refine_set='166006', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='77', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='27', applytype1='7', applyvalue1='35', applytype2='0', applyvalue2='0', value0='0', value1='260', value2='0', value3='166000', 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='166007', name='Vesmant de Safir+7', locale_name='Vesmant de Safir+7', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7800000', shop_buy_price='180000', refined_vnum='166008', refine_set='166007', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='78', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='28', applytype1='7', applyvalue1='40', applytype2='0', applyvalue2='0', value0='0', value1='270', value2='0', value3='166000', 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='166008', name='Vesmant de Safir+8', locale_name='Vesmant de Safir+8', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7900000', shop_buy_price='190000', refined_vnum='166009', refine_set='166008', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='79', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='29', applytype1='7', applyvalue1='45', applytype2='0', applyvalue2='0', value0='0', value1='280', value2='0', value3='166000', 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='166009', name='Vesmant de Safir+9', locale_name='Vesmant de Safir+9', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='8000000', shop_buy_price='200000', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='80', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='30', applytype1='7', applyvalue1='50', applytype2='0', applyvalue2='0', value0='0', value1='290', value2='0', value3='166000', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';

item_list - 34k (?? La ce se foloseste si cum ??)

166000 ARMOR 166000
166001 ARMOR 166000
166002 ARMOR 166000
166003 ARMOR 166000
166004 ARMOR 166000
166005 ARMOR 166000
166006 ARMOR 166000
166007 ARMOR 166000
166008 ARMOR 166000
166009 ARMOR 166000

Multumesc!

Item vnum=

ItemDef Vnum=

socket3='-1', socket4='-1', socket5='-1

[RaffaeL] scrie:

t4zu scrie:Salutare tuturor. Folosesc un svf+client 40k si doresc sa adaug armuri si arme noi.
Intrebare1: Cum pot sa imi fac urmatorul paragraf pt item_proto (CLIENT), din 34k in 40k?
Intrebare2: Cum pot sa imi fac urmatorul paragraf pt item_proto (SERVER sau mai bine zis querry), din 34k in 40k?
Intrebare3: Care este de mai jos "Sansa de succes", Materialele cerute pentru imbunatatire, si cum pot sa fac ca itemul respectiv sa evolueze din "Vesmant negru+9"?
Intrebare4: Cum procedez ca sa pot implementa armura atat pe server cat si pe client?
Multumesc!

item_proto (CLIENT) - 34k

Cod: Selectaţi tot

<Item vnum="166000" hashName="'Vesmant de Safir+0'" name="Vesmant de Safir+0" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7100000" buy_price="110000" limittype0="1" limitvalue0="71" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="21" applytype1="7" applyvalue1="5" applytype2="0" applyvalue2="0" value0="0" value1="200" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166001" refine_set="166000" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166001" hashName="'Vesmant de Safir+1'" name="Vesmant de Safir+1" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7200000" buy_price="120000" limittype0="1" limitvalue0="72" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="22" applytype1="7" applyvalue1="10" applytype2="0" applyvalue2="0" value0="0" value1="210" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166002" refine_set="166001" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166002" hashName="'Vesmant de Safir+2'" name="Vesmant de Safir+2" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7300000" buy_price="130000" limittype0="1" limitvalue0="73" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="23" applytype1="7" applyvalue1="15" applytype2="0" applyvalue2="0" value0="0" value1="220" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166003" refine_set="166002" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166003" hashName="'Vesmant de Safir+3'" name="Vesmant de Safir+3" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7400000" buy_price="140000" limittype0="1" limitvalue0="74" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="24" applytype1="7" applyvalue1="20" applytype2="0" applyvalue2="0" value0="0" value1="230" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166004" refine_set="166003" magic_pct="15" specular="0" socket_pct="3" />
<Item vnum="166004" hashName="'Vesmant de Safir+4'" name="Vesmant de Safir+4" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7500000" buy_price="150000" limittype0="1" limitvalue0="75" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="25" applytype1="7" applyvalue1="25" applytype2="0" applyvalue2="0" value0="0" value1="240" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166005" refine_set="166004" magic_pct="15" specular="30" socket_pct="3" />
<Item vnum="166005" hashName="'Vesmant de Safir+5'" name="Vesmant de Safir+5" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7600000" buy_price="160000" limittype0="1" limitvalue0="76" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="26" applytype1="7" applyvalue1="30" applytype2="0" applyvalue2="0" value0="0" value1="250" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166006" refine_set="166005" magic_pct="15" specular="40" socket_pct="3" />
<Item vnum="166006" hashName="'Vesmant de Safir+6'" name="Vesmant de Safir+6" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7700000" buy_price="170000" limittype0="1" limitvalue0="77" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="27" applytype1="7" applyvalue1="35" applytype2="0" applyvalue2="0" value0="0" value1="260" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166007" refine_set="166006" magic_pct="15" specular="50" socket_pct="3" />
<Item vnum="166007" hashName="'Vesmant de Safir+7'" name="Vesmant de Safir+7" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7800000" buy_price="180000" limittype0="1" limitvalue0="78" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="28" applytype1="7" applyvalue1="40" applytype2="0" applyvalue2="0" value0="0" value1="270" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166008" refine_set="166007" magic_pct="15" specular="65" socket_pct="3" />
<Item vnum="166008" hashName="'Vesmant de Safir+8'" name="Vesmant de Safir+8" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="7900000" buy_price="190000" limittype0="1" limitvalue0="79" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="29" applytype1="7" applyvalue1="45" applytype2="0" applyvalue2="0" value0="0" value1="280" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="166009" refine_set="166008" magic_pct="15" specular="80" socket_pct="3" />
<Item vnum="166009" hashName="'Vesmant de Safir+9'" name="Vesmant de Safir+9" type="2" subtype="0" weight="0" size="2" antiflag="28" flag="1" wearflag="1" immuneflag="0" gold="8000000" buy_price="200000" limittype0="1" limitvalue0="80" limittype1="0" limitvalue1="0" applytype0="37" applyvalue0="30" applytype1="7" applyvalue1="50" applytype2="0" applyvalue2="0" value0="0" value1="290" value2="0" value3="166000" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="15" specular="100" socket_pct="3" /> 

item_proto (SERVER) - 34k

Cod: Selectaţi tot

INSERT INTO item_proto SET vnum='166000', name='Vesmant de Safir+0', locale_name='Vesmant de Safir+0', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7100000', shop_buy_price='110000', refined_vnum='166001', refine_set='166000', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='71', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='21', applytype1='7', applyvalue1='5', applytype2='0', applyvalue2='0', value0='0', value1='200', value2='0', value3='166000', 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='166001', name='Vesmant de Safir+1', locale_name='Vesmant de Safir+1', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7200000', shop_buy_price='120000', refined_vnum='166002', refine_set='166001', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='72', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='22', applytype1='7', applyvalue1='10', applytype2='0', applyvalue2='0', value0='0', value1='210', value2='0', value3='166000', 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='166002', name='Vesmant de Safir+2', locale_name='Vesmant de Safir+2', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7300000', shop_buy_price='130000', refined_vnum='166003', refine_set='166002', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='73', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='23', applytype1='7', applyvalue1='15', applytype2='0', applyvalue2='0', value0='0', value1='220', value2='0', value3='166000', 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='166003', name='Vesmant de Safir+3', locale_name='Vesmant de Safir+3', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7400000', shop_buy_price='140000', refined_vnum='166004', refine_set='166003', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='74', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='24', applytype1='7', applyvalue1='20', applytype2='0', applyvalue2='0', value0='0', value1='230', value2='0', value3='166000', 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='166004', name='Vesmant de Safir+4', locale_name='Vesmant de Safir+4', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7500000', shop_buy_price='150000', refined_vnum='166005', refine_set='166004', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='75', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='25', applytype1='7', applyvalue1='25', applytype2='0', applyvalue2='0', value0='0', value1='240', value2='0', value3='166000', 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='166005', name='Vesmant de Safir+5', locale_name='Vesmant de Safir+5', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7600000', shop_buy_price='160000', refined_vnum='166006', refine_set='166005', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='76', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='26', applytype1='7', applyvalue1='30', applytype2='0', applyvalue2='0', value0='0', value1='250', value2='0', value3='166000', 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='166006', name='Vesmant de Safir+6', locale_name='Vesmant de Safir+6', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7700000', shop_buy_price='170000', refined_vnum='166007', refine_set='166006', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='77', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='27', applytype1='7', applyvalue1='35', applytype2='0', applyvalue2='0', value0='0', value1='260', value2='0', value3='166000', 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='166007', name='Vesmant de Safir+7', locale_name='Vesmant de Safir+7', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7800000', shop_buy_price='180000', refined_vnum='166008', refine_set='166007', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='78', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='28', applytype1='7', applyvalue1='40', applytype2='0', applyvalue2='0', value0='0', value1='270', value2='0', value3='166000', 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='166008', name='Vesmant de Safir+8', locale_name='Vesmant de Safir+8', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='7900000', shop_buy_price='190000', refined_vnum='166009', refine_set='166008', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='79', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='29', applytype1='7', applyvalue1='45', applytype2='0', applyvalue2='0', value0='0', value1='280', value2='0', value3='166000', 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='166009', name='Vesmant de Safir+9', locale_name='Vesmant de Safir+9', type='2', subtype='0', weight='0', size='2', antiflag='28', flag='1', wearflag='1', immuneflag='', gold='8000000', shop_buy_price='200000', refined_vnum='0', refine_set='0', refine_set2='0', magic_pct='15', limittype0='1', limitvalue0='80', limittype1='0', limitvalue1='0', applytype0='37', applyvalue0='30', applytype1='7', applyvalue1='50', applytype2='0', applyvalue2='0', value0='0', value1='290', value2='0', value3='166000', value4='0', value5='0', socket0='-1', socket1='-1', socket2='-1', socket3='-1', socket4='-1', socket5='-1', specular='100', socket_pct='3', addon_type='0';

item_list - 34k (?? La ce se foloseste si cum ??)

166000 ARMOR 166000
166001 ARMOR 166000
166002 ARMOR 166000
166003 ARMOR 166000
166004 ARMOR 166000
166005 ARMOR 166000
166006 ARMOR 166000
166007 ARMOR 166000
166008 ARMOR 166000
166009 ARMOR 166000

Multumesc!

Pentru inceput sa discutam despre item_proto client:
dupa cum ai spus folosesti svf 40k, deci pentru a transforma acele linii din 34k in 40k,
trebuie sa modifici dupa modelul liniei unei armuri din item_proto 40k.

Va arata asa:

Cod: Selectaţi tot

Item vnum=

pe 34k, si

Cod: Selectaţi tot

ItemDef Vnum=

pe 40k.
Modifici toate linile, dupa care, pentru 40k stergi

Cod: Selectaţi tot

socket3='-1', socket4='-1', socket5='-1

in 40k avand numai socket0,1si 2.
Dupa editarea/transformarea tuturor liniilor, le convertesti in query aici.
Rezultatul, il copiezi in navicat, dupa ce in prealabil ai intrat in tabelul player si ai apasat ctrl+q, dupa care apesi run.

Pentru sansa evolutiilor(sansa fierari), tot in navicat/player, deschizi refine_proto, si editezi ultima coloana, si anume "prob"
Pentru a adauga evolutii, setezi la fiecare item care vrei sa evolueze, la refined item=codul itemului in care evolueaza, iar la refine set=setul de refine(pe care il gasesti sau setezi tot in refine_proto).

Ce se afla in acel item list il adaugi in itemlist din locale, pentru a vedea icon-urile in joc.
Pentru a implementa corect o armura, dupa ce efectuezi toti pasii de mai sus, va trebui sa adaugi msm in root.
Pentru a-ti da seama cum se face, urmareste acest tutorial: https://www.youtube.com/watch?v=X6ZzIpXOiII

Sper ca m-am facut inteles, si ca te-am ajutat.