الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group 

 use sro_vt_shard 
truncate table _trainingcamphonorrank 
insert into _trainingcamphonorrank(ranking) values (1) 
insert into _trainingcamphonorrank(ranking) values (2) 
insert into _trainingcamphonorrank(ranking) values (3) 
insert into _trainingcamphonorrank(ranking) values (4) 
insert into _trainingcamphonorrank(ranking) values (5) 
insert into _trainingcamphonorrank(ranking) values (6) 
insert into _trainingcamphonorrank(ranking) values (7) 
insert into _trainingcamphonorrank(ranking) values (8) 
insert into _trainingcamphonorrank(ranking) values (9) 
insert into _trainingcamphonorrank(ranking) values (10) 
insert into _trainingcamphonorrank(ranking) values (11) 
insert into _trainingcamphonorrank(ranking) values (12) 
insert into _trainingcamphonorrank(ranking) values (13) 
insert into _trainingcamphonorrank(ranking) values (14) 
insert into _trainingcamphonorrank(ranking) values (15) 
insert into _trainingcamphonorrank(ranking) values (16) 
insert into _trainingcamphonorrank(ranking) values (17) 
insert into _trainingcamphonorrank(ranking) values (18) 
insert into _trainingcamphonorrank(ranking) values (19) 
insert into _trainingcamphonorrank(ranking) values (20) 
insert into _trainingcamphonorrank(ranking) values (21) 
insert into _trainingcamphonorrank(ranking) values (22) 
insert into _trainingcamphonorrank(ranking) values (23) 
insert into _trainingcamphonorrank(ranking) values (24) 
insert into _trainingcamphonorrank(ranking) values (25) 
insert into _trainingcamphonorrank(ranking) values (26) 
insert into _trainingcamphonorrank(ranking) values (27) 
insert into _trainingcamphonorrank(ranking) values (28) 
insert into _trainingcamphonorrank(ranking) values (29) 
insert into _trainingcamphonorrank(ranking) values (30) 
insert into _trainingcamphonorrank(ranking) values (31) 
insert into _trainingcamphonorrank(ranking) values (32) 
insert into _trainingcamphonorrank(ranking) values (33) 
insert into _trainingcamphonorrank(ranking) values (34) 
insert into _trainingcamphonorrank(ranking) values (35) 
insert into _trainingcamphonorrank(ranking) values (36) 
insert into _trainingcamphonorrank(ranking) values (37) 
insert into _trainingcamphonorrank(ranking) values (38) 
insert into _trainingcamphonorrank(ranking) values (39) 
insert into _trainingcamphonorrank(ranking) values (40) 
insert into _trainingcamphonorrank(ranking) values (41) 
insert into _trainingcamphonorrank(ranking) values (42) 
insert into _trainingcamphonorrank(ranking) values (43) 
insert into _trainingcamphonorrank(ranking) values (44) 
insert into _trainingcamphonorrank(ranking) values (45) 
insert into _trainingcamphonorrank(ranking) values (46) 
insert into _trainingcamphonorrank(ranking) values (47) 
insert into _trainingcamphonorrank(ranking) values (48) 
insert into _trainingcamphonorrank(ranking) values (49) 
insert into _trainingcamphonorrank(ranking) values (50) 
exec _training_camp_updatehonorrank

use [sro_vt_shard]
declare @charname varchar (max)
declare @graduates int
declare @honorpoints int
declare @charid int
declare @campid int
set @charname = 'charname'
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