Query For Honor Rank

tk69ok · 03/18/2014, 02:16

Hello,anyone have query that i can reset the honor rank every 1 month auto plz?.

Crue* · 03/18/2014, 07:39

PHP Code:


			
truncate table _TrainingCampMember

print 'Cleaned _TrainingCampMember'

truncate table _TrainingCampSubMentorHonorPoint

print 'Cleaned _TrainingCampSubMentorHonorPoint'

update _TrainingCampHonorRank set CampID = NULL, Rank = NULL

print 'Cleaned _TrainingCampHonorRank'

truncate table _TrainingCampBuffStatus

print 'Cleaned _TrainingCampBuffStatus'

delete from _TrainingCamp

print 'Cleaned _TrainingCamp'

tk69ok · 03/18/2014, 21:23

Quote:

Originally Posted by Crue*

PHP Code:

truncate table _TrainingCampMember print 'Cleaned _TrainingCampMember' truncate table _TrainingCampSubMentorHonorPoint print 'Cleaned _TrainingCampSubMentorHonorPoint' update _TrainingCampHonorRank set CampID = NULL, Rank = NULL print 'Cleaned _TrainingCampHonorRank' truncate table _TrainingCampBuffStatus print 'Cleaned _TrainingCampBuffStatus' delete from _TrainingCamp print 'Cleaned _TrainingCamp'

thank you

.