|
|
ÇáãÔÇÑßÉ ÇáÃÕáíÉ ßÊÈÊ ÈæÇÓØÉ mr ! HЄro
ÚÝæÇ ,,, áÇíãßäß ãÔÇåÏå ÇáÑæÇÈØ áÇäß ÛíÑ ãÓÌá áÏíäÇ [ ááÊÓÌíá ÇÖÛØ åäÇ ]
|
|
|
use [sro_vt_shard]
declare @charname varchar (max)
declare @graduates int
declare @honorpoints int
declare @charid int
declare @campid int
set @charname = '[gm]mario$'
set @charid = (select charid from _char where charname16 = @charname)
set @campid = (select top 1 campid from _trainingcampbuffstatus where recipientcharid = @charid)
set @graduates = '1234'
set @honorpoints= @graduates * 39
--------------------
update [dbo].[_trainingcamp]
set graduatecount = @graduates
where [dbo].[_trainingcamp].[id] = @campid
update [dbo].[_trainingcampmember]
set honorpoint = @honorpoints
where [dbo].[_trainingcampmember].[campid]=@campid
|
ÍØ ÇÓã ÇáÇßæäÊ ÈÊÇÚß ãßÇä mario É åÊÇÎÏ 4 ÈÞÇÊ áæ ÚÇíÒ ÊÇÎÏ 2 Çæ 3 ÚÏá ÇáÇÑÞÇã Çáí ÊÍÊ |
ÊãÇã íÇ ÌãÇÚå ÔßÑÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇ
.gif "111 (4)")