[™The Last Emperor™]

المشاركة الأصلية كتبت بواسطة bombom عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

استخدم ال query دى

[php]    use sro_vt_shard /* items to mall for silk by caipi */
    declare @codename varchar (74)
    declare @yourprice int
    declare @whichtab varchar(74)



    set @codename = 'item_mall_avatar_m_dragondress'            /* the spawncode of the item you want to add */
    set @yourprice = 130                                        /* silkprice */
    set @whichtab = 'mall_avatar_dress'                            /* to which tab of the item mall do you want to add the item*/


    declare @data varchar(15) set @data = '0'                    /*leave '0' as long as you're adding avatars - otherwise quantity of item*/
    if exists(select codename128 from _refobjcommon where codename128 = @codename)
    begin
    /*only avatar tabs possible at the moment*/if (@whichtab = 'mall_avatar_attach' or @whichtab = 'mall_avatar_dress' or @whichtab = 'mall_avatar_hat') /*to make sure that the tab is correct (in order to missspellings)*/
    begin

    /* codename instead of the id */ 
    declare @itemid int set @itemid = (select id from _refobjcommon where codename128 = @codename)

    /* which itemdata.txt is affected in the media.pk2*/
    declare @newitemid varchar(5)
    if (@itemid < 5000) set @newitemid = 5000
    else if (@itemid < 10000) set @newitemid = 10000
    else if (@itemid < 15000) set @newitemid = 15000
    else if (@itemid < 20000) set @newitemid = 20000
    else if (@itemid < 25000) set @newitemid = 25000
    else if (@itemid < 30000) set @newitemid = 30000
    else if (@itemid < 35000) set @newitemid = 35000
    else if (@itemid < 40000) set @newitemid = 40000
    else set @newitemid = 45000
    print ''
    print @codename + ' from media\server_dep\silkroad\textdata\itemdata_'+@newitemid+'.txt'
    print ''
    /*end which itemdata.txt*/

    /* for _refpackageitem */
    if exists (select codename128 from _refpackageitem where codename128 = 'package_'+@codename)
        begin
            declare @sn1 varchar(74) set @sn1 = (select namestrid from _refpackageitem where codename128 = 'package_'+@codename)
            declare @desc1 varchar(74) set @desc1 = (select descstrid from _refpackageitem where codename128 = 'package_'+@codename)
            declare @ddj1 varchar(74) set @ddj1 = (select assocfileicon from _refpackageitem where codename128 = 'package_'+@codename)
            declare @topid1 varchar (10) set @topid1 = (select id from _refpackageitem where codename128 = 'package_'+@codename)
                print '##check the following lines @ refpackageitem.txt!'
                print '1    15    '+@topid1+'    package_'+@codename+'    0    expand_term_all    '+@sn1+'    '+@desc1+'    '+@ddj1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print ''
        end
            else begin
                declare @sn varchar(74) set @sn = (select namestrid128 from _refobjcommon where id = @itemid)
                declare @desc varchar(74) set @desc = (select descstrid128 from _refobjcommon where id = @itemid)
                declare @ddj varchar(74) set @ddj = (select assocfileicon128 from _refobjcommon where id = @itemid)
                    insert into _refpackageitem (service,country,codename128,saletag,expandterm,namestrid,descstrid,assocfileicon,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128) 
                    values (1,15,'package_'+@codename,0,'expand_term_all',@sn,@desc,@ddj,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
                declare @topid varchar (10) set @topid = (select max(id) from _refpackageitem)
                    print ''
                    print 'add the following line @ refpackageitem.txt'
                    print '1    15    '+@topid+'    package_'+@codename+'    0    expand_term_all    '+@sn+'    '+@desc+'    '+@ddj+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                    print ''
            end

    /* for _refpricepolicyofitem */
    if exists (select refpackageitemcodename from _refpricepolicyofitem where refpackageitemcodename = 'package_'+@codename)
        begin
            print '##check the following lines @ refpricepolicyofitem.txt!'
            declare @newprice1 varchar(15) set @newprice1 = (select cost from _refpricepolicyofitem where refpackageitemcodename = 'package_'+@codename and paymentdevice = 2)
                print '1    15    package_'+@codename+'    2    0    '+@newprice1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print '1    15    package_'+@codename+'    4    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print '1    15    package_'+@codename+'    16    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print ''
        end
            else begin
                insert into _refpricepolicyofitem (service,country,refpackageitemcodename,paymentdevice,previouscost,cost,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128)
                values (1,15,'package_'+@codename,2,0,@yourprice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
                insert into _refpricepolicyofitem (service,country,refpackageitemcodename,paymentdevice,previouscost,cost,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128)
                values (1,15,'package_'+@codename,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
                insert into _refpricepolicyofitem (service,country,refpackageitemcodename,paymentdevice,previouscost,cost,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128)
                values (1,15,'package_'+@codename,16,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            declare @newprice varchar(15) set @newprice = @yourprice
                print ''
                print 'add the following lines @ refpricepolicyofitem.txt'
                print '1    15    package_'+@codename+'    2    0    '+@newprice+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print '1    15    package_'+@codename+'    4    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print '1    15    package_'+@codename+'    16    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print ''
            end

    /* for _refshopgoods */
    if exists (select refpackageitemcodename from _refshopgoods where refpackageitemcodename = 'package_'+@codename and reftabcodename = @whichtab)
        begin
            print '##check the following lines @ refshopgoods.txt!'
            declare @whichtab1 varchar(74) set @whichtab1 = (select reftabcodename from _refshopgoods where refpackageitemcodename = 'package_'+@codename)
            declare @newslotindex1 varchar(15) set @newslotindex1 = (select slotindex from _refshopgoods where refpackageitemcodename = 'package_'+@codename and reftabcodename = @whichtab1)
            print '1    15    '+@whichtab1+'    '+'package_'+@codename+'    '+@newslotindex1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print ''
        end
            else begin
                declare @newslotindex varchar(15) set @newslotindex = (select max(slotindex) from _refshopgoods where reftabcodename = @whichtab)+1
                insert into _refshopgoods (service,country,reftabcodename,refpackageitemcodename,slotindex,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128)
                values (1,15,@whichtab,'package_'+@codename,@newslotindex,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
                print ''
                print 'add the following line @ refshopgoods.txt'
                print '1    15    '+@whichtab+'    '+'package_'+@codename+'    '+@newslotindex+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print ''
            end

    /* for _refscrapofpackageitem */
    if exists (select refpackageitemcodename from _refscrapofpackageitem where refpackageitemcodename = 'package_'+@codename and refitemcodename = @codename)
        begin
            print '##check the following lines @ refscrapofpackageitem.txt!'
            declare @scrapindex1 varchar(15)
            set @scrapindex1 = (select [index] from _refscrapofpackageitem where refitemcodename = @codename)
            declare @data1 varchar(15) set @data1 = (select data from _refscrapofpackageitem where refitemcodename = @codename)
            print '1    15    '+'package_'+@codename+'    '+@codename+'    0    0    '+@data1+'    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@scrapindex1    
            print ''
        end
            else begin
                insert into _refscrapofpackageitem (service,country,refpackageitemcodename,refitemcodename,optlevel,variance,data,magparamnum,magparam1,magparam2,magparam3,magparam4,magparam5,magparam6,magparam7,magparam8,magparam9,magparam10,magparam11,magparam12,param1,param1_desc128,param2,param2_desc128,param3,param3_desc128,param4,param4_desc128)
                values (1,15,'package_'+@codename,@codename,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
                declare @scrapindex varchar(15)
                set @scrapindex = (select [index] from _refscrapofpackageitem where refitemcodename = @codename)
                    print ''
                    print 'add the following line @ refscrapofpackageitem.txt'
                    print '1    15    '+'package_'+@codename+'    '+@codename+'    0    0    '+@data+'    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@scrapindex
                    print ''
            end
        print ''
        print ''
        print 'done!'
    end
    else begin
    print 'the @whichtab value is incorrect!'
    end
    end
    else begin 
    print '@codename value does not exist.'
    end

او شوف الشرح ده

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عملت الكويرى ده معملش حاجه والموضوع اللى فى اللنك والله مشيت معاه سطر سطر 3 مرات