|
You last visited: Today at 13:14
Advertisement
[Release] Rerward Your Players For Reg. in battle arena
Discussion on [Release] Rerward Your Players For Reg. in battle arena within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
05/22/2015, 23:27
|
#1
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
[Release] Rerward Your Players For Reg. in battle arena
this is a part of Galullians Reward Systems..
and its so so simple
- it counts every registration & cancellation in battle arena
and gives players rewards
what you need
1. Creat a new column in _Char Called : ArenaReg (INT)
2. Put this in LogChar
Use In Case Statement better than IF
Quote:
Originally Posted by Skipper*
|
PHP Code:
IF (@EventID = 239) ---- Arena registration declare @ArenaRegCount int = (SELECT ArenaReg From SRO_VT_SHARD.dbo._Char Where CharID = @CharID) BEGIN IF (@Data1 = 1 AND @Data2 BETWEEN 1 AND 2) BEGIN Update SRO_VT_SHARD.dbo._Char Set ArenaReg = ArenaReg +1 Where CharID = @CharID END IF (@Data1 = 2 AND @Data2 BETWEEN 1 AND 2) BEGIN Update SRO_VT_SHARD.dbo._Char Set ArenaReg = ArenaReg -1 Where CharID = @CharID END INSERT INTO SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,Enable) VALUES (@CharID,(CASE WHEN @ArenaRegCount = 10 THEN '34851' WHEN @ArenaRegCount = 50 THEN '34852' WHEN @ArenaRegCount = 80 THEN '34853' WHEN @ArenaRegCount = 110 THEN '34854' WHEN @ArenaRegCount = 150 THEN '34855' WHEN @ArenaRegCount = 250 THEN '34856' END),1) END
Change rewards as your needs
and you can Creat a new table then store charid & reg counts better than enter _Char Table every registeration
|
|
|
05/23/2015, 05:16
|
#2
|
elite*gold: 0
Join Date: Dec 2010
Posts: 328
Received Thanks: 32
|
BEGIN
INSERT SRO_VT_SHARD.dbo._CharSkill(CharID,SkillID,Enable) Values (@CharID,34856,1)
huh? you was giving a skill?
|
|
|
05/23/2015, 05:17
|
#3
|
elite*gold: 0
Join Date: Dec 2010
Posts: 328
Received Thanks: 32
|
BEGIN
INSERT SRO_VT_SHARD.dbo._CharSkill(CharID,SkillID,Enable) Values (@CharID,34856,1)
huh? you was giving a skill?
|
|
|
05/23/2015, 05:23
|
#4
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
Quote:
Originally Posted by zizoelnigm
BEGIN
INSERT SRO_VT_SHARD.dbo._CharSkill(CharID,SkillID,Enable) Values (@CharID,34856,1)
huh? you was giving a skill?
|
wtf surprise you in giving a skill ?! xD
- yea i was giving a skill in his achivements tab !! .. you can change it as your fucken needs !
|
|
|
05/23/2015, 05:53
|
#5
|
elite*gold: 0
Join Date: Feb 2015
Posts: 80
Received Thanks: 14
|
not bad
|
|
|
05/23/2015, 06:52
|
#6
|
elite*gold: 0
Join Date: Dec 2010
Posts: 328
Received Thanks: 32
|
hey please learn how to respect the people i didn't insult you , i just was asking a question....
|
|
|
05/23/2015, 08:24
|
#7
|
elite*gold: 0
Join Date: Apr 2014
Posts: 28
Received Thanks: 3
|
useful
|
|
|
05/23/2015, 08:26
|
#8
|
elite*gold: 0
Join Date: Jun 2012
Posts: 67
Received Thanks: 6
|
helped
|
|
|
05/23/2015, 09:53
|
#9
|
elite*gold: 71
Join Date: Mar 2011
Posts: 1,594
Received Thanks: 1,099
|
Code:
IF (@EventID = 239) ---- Arena registration
declare @ArenaRegCount int = (SELECT ArenaReg From SRO_VT_SHARD.._Char Where CharID = @CharID)
BEGIN
IF (@Data1 = 1 AND @Data2 BETWEEN 1 AND 2)
BEGIN
Update SRO_VT_SHARD.._Char Set ArenaReg = ArenaReg +1 Where CharID = @CharID
END
IF (@Data1 = 2 AND @Data2 BETWEEN 1 AND 2)
BEGIN
Update SRO_VT_SHARD.._Char Set ArenaReg = ArenaReg -1 Where CharID = @CharID
END
INSERT INTO SRO_VT_SHARD.._CharSkill (CharID,SkillID,Enable) VALUES
(@CharID,(CASE
WHEN @ArenaRegCount = 10 THEN '34851'
WHEN @ArenaRegCount = 50 THEN '34852'
WHEN @ArenaRegCount = 80 THEN '34853'
WHEN @ArenaRegCount = 110 THEN '34854'
WHEN @ArenaRegCount = 150 THEN '34855'
WHEN @ArenaRegCount = 250 THEN '34856'
END),1)
END
This looks cleaner.
|
|
|
05/23/2015, 10:14
|
#10
|
elite*gold: 247
Join Date: Feb 2014
Posts: 1,815
Received Thanks: 495
|
nice
people shuld release more nice things on sro section ..
so we can work all togheder ...
|
|
|
05/23/2015, 15:19
|
#11
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
usefull ty
|
|
|
05/23/2015, 15:55
|
#12
|
elite*gold: 37
Join Date: May 2015
Posts: 339
Received Thanks: 305
|
Useful ty.
|
|
|
05/23/2015, 23:08
|
#13
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
Quote:
Originally Posted by salah15
useful
|
Quote:
Originally Posted by SymbolofeviL
helped
|
Quote:
Originally Posted by Count Dracula
nice
people shuld release more nice things on sro section ..
so we can work all togheder ...
|
thanks
Quote:
Originally Posted by Vxo
Useful ty.
|
Quote:
Originally Posted by raptter
usefull ty
|
thanks to
|
|
|
11/09/2015, 16:16
|
#14
|
elite*gold: 737
Join Date: Oct 2007
Posts: 730
Received Thanks: 133
|
I dont see the point to give a reward for just to register for arena. i would think players will do more bot register afk this way. just a thought
|
|
|
11/10/2015, 06:54
|
#15
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 521
|
Quote:
Originally Posted by sonsof2004
I dont see the point to give a reward for just to register for arena. i would think players will do more bot register afk this way. just a thought
|
thought > Have Brain > Can Read = :
Quote:
Originally Posted by its.soul
IF (@Data1 = 1 AND @Data2 BETWEEN 1 AND 2)
BEGIN
Update SRO_VT_SHARD.dbo._Char Set ArenaReg = ArenaReg +1 Where CharID = @CharID
END
IF (@Data1 = 2 AND @Data2 BETWEEN 1 AND 2)
BEGIN
Update SRO_VT_SHARD.dbo._Char Set ArenaReg = ArenaReg -1 Where CharID = @CharID
END
|
|
|
|
|
|
Similar Threads
|
Help how to remove Arena Coin from all players
04/20/2015 - Shaiya PServer Development - 6 Replies
Need Query remove arena coin from all player's :confused::confused:
|
Help how to remove Arena Coin from all players
04/17/2015 - SRO Private Server - 4 Replies
Help how to remove Arena Coin from all players:confused::confused::confused:
|
SRO-R Battle Arena of Infinity Arena Coins
04/03/2013 - SRO Private Server - 3 Replies
Hi,
is there a possible way to make a script for a sro char, in which the char automatically goes to arena of infinity personal dungeon and transforms itself to one of the 2 monsters and kills wave for wave with the 2 skills provided after transforming? And ofc going back to town and doing it over and over again ? is this possible? its a slow way of farming coins sure but its enough for my accessory set =)
is this possible in auto it?
best regards and thanks in advance for ur reply
|
2.4 Arena PTR: Teleporting to players
03/01/2008 - WoW Exploits, Hacks, Tools & Macros - 0 Replies
Type /console port and you will port to them. This is currently only on the arena PTR to my knowledge.
|
All times are GMT +2. The time now is 13:14.
|
|