|
You last visited: Today at 16:30
Advertisement
Help Wanted Hero system Not Working
Discussion on Help Wanted Hero system Not Working within the SRO PServer Questions & Answers forum part of the SRO Private Server category.
06/23/2021, 20:29
|
#1
|
elite*gold: 0 
Join Date: Dec 2011
Posts: 81
Received Thanks: 5
|
Help Wanted Hero system Not Working
hello friends Epvp
I have tried this system but it does not work for me
1- I followed this thread
2-When I kill the required number or more, I don't get anything
3-Then he looked at Table _RowKills >>Empty and nothing recorded
As it is shown in the picture
4-I think something is missing Or something that needs changing in Procedure _AddLogChar
@
HTML Code:
If [MENTION=2220328]Eventi[/MENTION]D = 20)
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharTrijob SET Exp= '0' where Exp> '2147483647'
end
--- Wanted System
if [MENTION=2220328]Eventi[/MENTION]D = '19' -- Count kills
BEGIN
if (@strPos like '%(0x60a8)%')
BEGIN
IF [MENTION=316630]DEsc[/MENTION] LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Robber, Neutral, no freebattle team%' -- Thief
) BEGIN
DECLARE [MENTION=643446]killed[/MENTION]Name1 VARCHAR(512) = [MENTION=316630]DEsc[/MENTION]
DECLARE [MENTION=1183983]reql[/MENTION]evel INT = 0
SELECT [MENTION=643446]killed[/MENTION]Name1 = REPLACE [MENTION=643446]killed[/MENTION]Name1, LEFT [MENTION=643446]killed[/MENTION]Name1, CHARINDEX('(', [MENTION=643446]killed[/MENTION]Name1)), '')
SELECT [MENTION=643446]killed[/MENTION]Name1 = REPLACE [MENTION=643446]killed[/MENTION]Name1, RIGHT [MENTION=643446]killed[/MENTION]Name1, CHARINDEX(')', REVERSE [MENTION=643446]killed[/MENTION]Name1))), '')
SELECT [MENTION=1183983]reql[/MENTION]evel = CurLevel FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = [MENTION=643446]killed[/MENTION]Name1
if [MENTION=1183983]reql[/MENTION]evel >= 60
BEGIN
Exec [_Wanted] @CharID , [MENTION=2220328]Eventi[/MENTION]D , [MENTION=316630]DEsc[/MENTION]
End
END
END
END
if [MENTION=2220328]Eventi[/MENTION]D = '20' -- if dies
BEGIN
IF [MENTION=316630]DEsc[/MENTION] LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Robber, Neutral, no freebattle team%' -- Thief
) BEGIN
UPDATE _RowKills SET Kills = '0' WHERE KillerID = @CharID
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID AND JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024')
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID and JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024'
END
END
END
--------- End of wanted system
5-Is there a solution?
|
|
|
|
06/24/2021, 14:00
|
#2
|
elite*gold: 0
Join Date: May 2013
Posts: 2,223
Received Thanks: 1,481
|
Quote:
Originally Posted by coolspace9
hello friends Epvp
I have tried this system but it does not work for me
1- I followed this thread
2-When I kill the required number or more, I don't get anything
3-Then he looked at Table _RowKills >>Empty and nothing recorded
As it is shown in the picture
4-I think something is missing Or something that needs changing in Procedure _AddLogChar
@
HTML Code:
If [MENTION=2220328]Eventi[/MENTION]D = 20)
BEGIN
UPDATE SRO_VT_SHARD.DBO._CharTrijob SET Exp= '0' where Exp> '2147483647'
end
--- Wanted System
if [MENTION=2220328]Eventi[/MENTION]D = '19' -- Count kills
BEGIN
if (@strPos like '%(0x60a8)%')
BEGIN
IF [MENTION=316630]DEsc[/MENTION] LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Robber, Neutral, no freebattle team%' -- Thief
) BEGIN
DECLARE [MENTION=643446]killed[/MENTION]Name1 VARCHAR(512) = [MENTION=316630]DEsc[/MENTION]
DECLARE [MENTION=1183983]reql[/MENTION]evel INT = 0
SELECT [MENTION=643446]killed[/MENTION]Name1 = REPLACE [MENTION=643446]killed[/MENTION]Name1, LEFT [MENTION=643446]killed[/MENTION]Name1, CHARINDEX('(', [MENTION=643446]killed[/MENTION]Name1)), '')
SELECT [MENTION=643446]killed[/MENTION]Name1 = REPLACE [MENTION=643446]killed[/MENTION]Name1, RIGHT [MENTION=643446]killed[/MENTION]Name1, CHARINDEX(')', REVERSE [MENTION=643446]killed[/MENTION]Name1))), '')
SELECT [MENTION=1183983]reql[/MENTION]evel = CurLevel FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = [MENTION=643446]killed[/MENTION]Name1
if [MENTION=1183983]reql[/MENTION]evel >= 60
BEGIN
Exec [_Wanted] @CharID , [MENTION=2220328]Eventi[/MENTION]D , [MENTION=316630]DEsc[/MENTION]
End
END
END
END
if [MENTION=2220328]Eventi[/MENTION]D = '20' -- if dies
BEGIN
IF [MENTION=316630]DEsc[/MENTION] LIKE '%Trader, Neutral, no freebattle team%' -- Trader
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Hunter, Neutral, no freebattle team%' -- Hunter
OR [MENTION=316630]DEsc[/MENTION] LIKE '%Robber, Neutral, no freebattle team%' -- Thief
) BEGIN
UPDATE _RowKills SET Kills = '0' WHERE KillerID = @CharID
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID AND JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024')
BEGIN
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID = @CharID and JobID = '33862' or CharID = @CharID and JobID between '50021' and '50024'
END
END
END
--------- End of wanted system
5-Is there a solution? |
check if your Character level 60+
if @ evel >= 60
|
|
|
|
|
06/24/2021, 19:00
|
#3
|
elite*gold: 0
Join Date: Dec 2011
Posts: 81
Received Thanks: 5
|
@
Thank you So Much My Friend For Help Me
Now the System is working fine It's thanks for your help
Thanks also to Mr @ Thanks for always responding
Problem solved successfully.
by@Over56
|
|
|
|
|
06/25/2021, 02:11
|
#4
|
elite*gold: 0
Join Date: Sep 2016
Posts: 247
Received Thanks: 81
|
Quote:
Originally Posted by coolspace9
@
Thank you So Much My Friend For Help Me
Now the System is working fine It's thanks for your help
Thanks also to Mr @ Thanks for always responding
Problem solved successfully.
by@Over56 |
you're welcome
|
|
|
|
|
06/27/2021, 02:30
|
#5
|
|
dotCom
elite*gold: 9842
Join Date: Mar 2009
Posts: 16,834
Received Thanks: 4,667
|
SRO Private Server -> SRO PServer Quest…
#moved
|
|
|
|
All times are GMT +1. The time now is 16:32.
|
|
