المشاركة الأصلية كتبت بواسطة bombom
(المشاركة 4589003)
استخدم ال 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
او شوف الشرح ده
http://silkroad4arab.com/vb/showthread.php?t=462801
|
