|
You last visited: Today at 09:34
Advertisement
Query Of Buff Academy
Discussion on Query Of Buff Academy within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
11/10/2012, 22:26
|
#1
|
elite*gold: 41 
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Query Of Buff Academy
Hello E*p-rz
Today i have Query Of Buff Academy
Use This ..
PHP Code:
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = 'Crue*[YourCharName]'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '1234[Number Of Graduates] '
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
Give Me L!ke if Helped You
|
|
|
|
11/11/2012, 01:13
|
#2
|
elite*gold: 0
Join Date: Oct 2012
Posts: 206
Received Thanks: 48
|
useful query I was looking for something like this
|
|
|
|
|
11/11/2012, 18:10
|
#3
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Quote:
Originally Posted by Lyso7
useful query I was looking for something like this
|
Welcome
Quote:
Originally Posted by Lyso7
useful query I was looking for something like this
|
Welcome
|
|
|
|
|
11/11/2012, 18:19
|
#4
|
elite*gold: 0
Join Date: Aug 2011
Posts: 121
Received Thanks: 26
|
Very helpful query ,i still didn't test use it is it give the 3 Buff's ?
|
|
|
|
|
11/11/2012, 20:10
|
#5
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Quote:
Originally Posted by SayedKate
Very helpful query ,i still didn't test use it is it give the 3 Buff's ?
|
4 not 3 
|
|
|
|
|
11/12/2012, 19:52
|
#6
|
elite*gold: 0
Join Date: Aug 2011
Posts: 121
Received Thanks: 26
|
(0 row(s) affected)
(0 row(s) affected)
|
|
|
|
|
11/12/2012, 20:54
|
#7
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Quote:
Originally Posted by SayedKate
(0 row(s) affected)
(0 row(s) affected)
|
not work ?
|
|
|
|
|
11/12/2012, 21:47
|
#8
|
elite*gold: 0
Join Date: Aug 2011
Posts: 121
Received Thanks: 26
|
Fixed, before use the query need to run that one
Quote:
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
|
|
|
|
|
|
11/12/2012, 22:58
|
#9
|
elite*gold: 0
Join Date: Dec 2011
Posts: 73
Received Thanks: 20
|
it wont work if the selected char havent a Academy created. Means else u create the academy for the char manual or u add a few more lines to register the academy as well.
|
|
|
|
|
11/16/2012, 19:07
|
#10
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
yea You Must Use this
PHP Code:
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
|
|
|
|
|
09/17/2013, 18:33
|
#11
|
elite*gold: 0
Join Date: Apr 2010
Posts: 343
Received Thanks: 15
|
what if i got the graduates and honor points but in honor rank my char is 3rd its like first one have 180 graduates and i have 1240 but im num 7 can anyone explain to me why is that ?
|
|
|
|
|
06/14/2014, 16:27
|
#12
|
elite*gold: 0
Join Date: Dec 2013
Posts: 73
Received Thanks: 7
|
work ?
|
|
|
|
Similar Threads
|
Academy buff and honor points.
07/26/2011 - Silkroad Online - 4 Replies
So I have enough points for 70lv sun weapon. But some guy said if i'll take it, i will need more graduates for academy buff. Is it true?
|
Suche Torkas Buff geben Sertain Buff
07/16/2011 - Metin2 Trading - 0 Replies
Suche ein Buff sollte lvl 35 sein Krit Segen M haben
Gebe S15 Buff lvl 43 K Segen m2 24,9% und krit m1 24,4% Reflekt 3 7,6%
|
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
|
Academy Buff
01/13/2010 - Silkroad Online - 3 Replies
Is it only for exp or exp/sp i mean the one for 40- chars.
|
All times are GMT +1. The time now is 09:36.
|
|
