|
You last visited: Today at 14:34
Advertisement
i need help in Procedure
Discussion on i need help in Procedure within the SRO PServer Questions & Answers forum part of the SRO Private Server category.
03/09/2023, 12:13
|
#1
|
elite*gold: 0 
Join Date: Feb 2023
Posts: 62
Received Thanks: 3
|
i need help in Procedure
i need Procedure give me items from TABLE when use scroll
same it
ITEM_MALL_PREMIUM_GLOBAL_GOLDTIME_PLUS_3
ITEM_LEGENDKNIGHT_EXTRA_GODBLESS3
ITEM_HONOR_SWAGGER_BUFF_SCROLL
ITEM_MALL_GAMER_FIGHT_SCROLL
ITEM_MALL_SWAGGER_LIFE_SCROLL
ITEM_WANTED_Herobuff
|
|
|
|
03/09/2023, 15:38
|
#2
|
elite*gold: 0
Join Date: Dec 2015
Posts: 119
Received Thanks: 16
|
these are costum items
|
|
|
|
|
03/10/2023, 12:10
|
#3
|
elite*gold: 0
Join Date: Feb 2023
Posts: 62
Received Thanks: 3
|
Quote:
Originally Posted by Hynix_1337
these are costum items
|
i need Procedure give me backage donate with scroll
|
|
|
|
|
03/11/2023, 16:53
|
#4
|
elite*gold: 0
Join Date: Dec 2021
Posts: 85
Received Thanks: 74
|
A scroll I made two years ago can be used to reduce the creation of procedures. Adjust it to your needs.
Code:
IF (@Operation = 41 and [MENTION=1134588]item[/MENTION]RefID In(98890408,98890409,98890410,98890411,98890412,98890413,98890414,98890415,98890424,998890408,98890416,98890417,98890418,98890419,98890420))
BEGIN
DECLARE
[MENTION=1956629]chestt[/MENTION]able VARCHAR(MAX), [MENTION=806297]sql[/MENTION]Comm NVARCHAR(MAX)
SET [MENTION=1956629]chestt[/MENTION]able =
CASE [MENTION=1134588]item[/MENTION]RefID
WHEN 98890408 THEN '_DG10ModelsChest' WHEN 98890409 THEN '_EGYAModelsChest'
WHEN 98890410 THEN '_EGYBModelsChest' WHEN 98890411 THEN '_DG11ModelsChest'
WHEN 98890412 THEN '_DG12ModelsChest' WHEN 98890413 THEN '_DG13ModelsChest'
WHEN 98890414 THEN '_DG14ModelsChest' WHEN 98890415 THEN '_DG15ModelsChest'
WHEN 998890408 THEN '_DG16ModelsChest' WHEN 98890416 THEN '_DG17ModelsChest'
WHEN 98890417 THEN '_DG18ModelsChest' WHEN 98890418 THEN '_DG19ModelsChest'
WHEN 98890419 THEN '_DG20ModelsChest' WHEN 98890420 THEN '_DG21ModelsChest'
ELSE '_DG18ModelsChest_SpecialOnes'
END;
SET [MENTION=806297]sql[/MENTION]Comm = 'DECLARE [MENTION=1920592]Succ[/MENTION]Rate INT, [MENTION=2331165]Codename12[/MENTION]8 VARCHAR (128),
[MENTION=5724309]DG10[/MENTION]ModelsChestCharName VARCHAR(64), [MENTION=323292]nameS[/MENTION]TR128 VARCHAR(128),
[MENTION=1920592]Succ[/MENTION]Notification VARCHAR(MAX), [MENTION=656255]fail[/MENTION]Notification VARCHAR(MAX), [MENTION=1138848]modeli[/MENTION]temID INT,
[MENTION=3340698]Highest[/MENTION]Possibility INT = 50,
[MENTION=637345]lowes[/MENTION]tPossibility INT = 48
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Rate = ROUND(RAND()* [MENTION=3340698]Highest[/MENTION]Possibility - [MENTION=637345]lowes[/MENTION]tPossibility) + [MENTION=637345]lowes[/MENTION]tPossibility, 0)
SELECT TOP 1 [MENTION=5724309]DG10[/MENTION]ModelsChestCharName = (SELECT [CharName16] from SRO_VT_SHARD.._Char where [CharID] = '+ CAST(@CharID AS NVARCHAR) + ');
SELECT TOP 1 [MENTION=2331165]Codename12[/MENTION]8 = (SELECT TOP 1 [CodeName128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [SuccRate] = [MENTION=1920592]Succ[/MENTION]Rate ORDER BY NEWID())
SELECT TOP 1 [MENTION=323292]nameS[/MENTION]TR128 = ( SELECT [NameStr128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [CodeName128] [MENTION=2331165]Codename12[/MENTION]8)
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Notification = FORMATMESSAGE(''[%s] Cracked Models Chest and won [%s].'', [MENTION=5724309]DG10[/MENTION]ModelsChestCharName, [MENTION=323292]nameS[/MENTION]TR128)
SELECT TOP 1 [MENTION=656255]fail[/MENTION]Notification = FORMATMESSAGE(''Failed to crack Models Chest, Goodluck next time.'')
SELECT TOP 1 [MENTION=1138848]modeli[/MENTION]temID = (SELECT [ID] FROM SRO_VT_SHARD.dbo.[_RefObjCommon] Where CodeName128 [MENTION=2331165]Codename12[/MENTION]8)
IF [MENTION=1920592]Succ[/MENTION]Rate = 50
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC SRO_VT_ZYENO.[dbo].[_InstantAddOrRemoveItemChest] 1,'+ CAST(@CharID AS NVARCHAR) +' [MENTION=1138848]modeli[/MENTION]temID,1,0,0,''Models Chest''
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 3 [MENTION=1920592]Succ[/MENTION]Notification,''true'','''',''true'',''false'',0
END
ELSE
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 0 [MENTION=656255]fail[/MENTION]Notification,''false'' [MENTION=5724309]DG10[/MENTION]ModelsChestCharName,''false'',''true'',0
END
'
EXEC sp_executesql [MENTION=806297]sql[/MENTION]Comm;
END
|
|
|
|
|
03/11/2023, 16:54
|
#5
|
elite*gold: 0
Join Date: May 2009
Posts: 398
Received Thanks: 223
|
Check painmaker_'s reply and it'll work like magic
|
|
|
|
|
03/11/2023, 17:08
|
#6
|
elite*gold: 0
Join Date: Feb 2023
Posts: 62
Received Thanks: 3
|
Quote:
Originally Posted by painmaker_
A scroll I made two years ago can be used to reduce the creation of tables. Adjust it to your needs.
Code:
IF (@Operation = 41 and [MENTION=1134588]item[/MENTION]RefID In(98890408,98890409,98890410,98890411,98890412,98890413,98890414,98890415,98890424,998890408,98890416,98890417,98890418,98890419,98890420))
BEGIN
DECLARE
[MENTION=1956629]chestt[/MENTION]able VARCHAR(MAX), [MENTION=806297]sql[/MENTION]Comm NVARCHAR(MAX)
SET [MENTION=1956629]chestt[/MENTION]able =
CASE [MENTION=1134588]item[/MENTION]RefID
WHEN 98890408 THEN '_DG10ModelsChest' WHEN 98890409 THEN '_EGYAModelsChest'
WHEN 98890410 THEN '_EGYBModelsChest' WHEN 98890411 THEN '_DG11ModelsChest'
WHEN 98890412 THEN '_DG12ModelsChest' WHEN 98890413 THEN '_DG13ModelsChest'
WHEN 98890414 THEN '_DG14ModelsChest' WHEN 98890415 THEN '_DG15ModelsChest'
WHEN 998890408 THEN '_DG16ModelsChest' WHEN 98890416 THEN '_DG17ModelsChest'
WHEN 98890417 THEN '_DG18ModelsChest' WHEN 98890418 THEN '_DG19ModelsChest'
WHEN 98890419 THEN '_DG20ModelsChest' WHEN 98890420 THEN '_DG21ModelsChest'
ELSE '_DG18ModelsChest_SpecialOnes'
END;
SET [MENTION=806297]sql[/MENTION]Comm = 'DECLARE [MENTION=1920592]Succ[/MENTION]Rate INT, [MENTION=2331165]Codename12[/MENTION]8 VARCHAR (128),
[MENTION=5724309]DG10[/MENTION]ModelsChestCharName VARCHAR(64), [MENTION=323292]nameS[/MENTION]TR128 VARCHAR(128),
[MENTION=1920592]Succ[/MENTION]Notification VARCHAR(MAX), [MENTION=656255]fail[/MENTION]Notification VARCHAR(MAX), [MENTION=1138848]modeli[/MENTION]temID INT,
[MENTION=3340698]Highest[/MENTION]Possibility INT = 50,
[MENTION=637345]lowes[/MENTION]tPossibility INT = 48
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Rate = ROUND(RAND()* [MENTION=3340698]Highest[/MENTION]Possibility - [MENTION=637345]lowes[/MENTION]tPossibility) + [MENTION=637345]lowes[/MENTION]tPossibility, 0)
SELECT TOP 1 [MENTION=5724309]DG10[/MENTION]ModelsChestCharName = (SELECT [CharName16] from SRO_VT_SHARD.._Char where [CharID] = '+ CAST(@CharID AS NVARCHAR) + ');
SELECT TOP 1 [MENTION=2331165]Codename12[/MENTION]8 = (SELECT TOP 1 [CodeName128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [SuccRate] = [MENTION=1920592]Succ[/MENTION]Rate ORDER BY NEWID())
SELECT TOP 1 [MENTION=323292]nameS[/MENTION]TR128 = ( SELECT [NameStr128] from SRO_VT_SHARDLOG..' [MENTION=1956629]chestt[/MENTION]able+' where [CodeName128] [MENTION=2331165]Codename12[/MENTION]8)
SELECT TOP 1 [MENTION=1920592]Succ[/MENTION]Notification = FORMATMESSAGE(''[%s] Cracked Models Chest and won [%s].'', [MENTION=5724309]DG10[/MENTION]ModelsChestCharName, [MENTION=323292]nameS[/MENTION]TR128)
SELECT TOP 1 [MENTION=656255]fail[/MENTION]Notification = FORMATMESSAGE(''Failed to crack Models Chest, Goodluck next time.'')
SELECT TOP 1 [MENTION=1138848]modeli[/MENTION]temID = (SELECT [ID] FROM SRO_VT_SHARD.dbo.[_RefObjCommon] Where CodeName128 [MENTION=2331165]Codename12[/MENTION]8)
IF [MENTION=1920592]Succ[/MENTION]Rate = 50
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC SRO_VT_ZYENO.[dbo].[_InstantAddOrRemoveItemChest] 1,'+ CAST(@CharID AS NVARCHAR) +' [MENTION=1138848]modeli[/MENTION]temID,1,0,0,''Models Chest''
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 3 [MENTION=1920592]Succ[/MENTION]Notification,''true'','''',''true'',''false'',0
END
ELSE
BEGIN
WAITFOR DELAY ''00:00:01''
EXEC [SRO_VT_ZYENO].dbo.[_USNotifier] 0 [MENTION=656255]fail[/MENTION]Notification,''false'' [MENTION=5724309]DG10[/MENTION]ModelsChestCharName,''false'',''true'',0
END
'
EXEC sp_executesql [MENTION=806297]sql[/MENTION]Comm;
END
|
thx for help u can give me table
|
|
|
|
|
03/11/2023, 17:42
|
#7
|
elite*gold: 0
Join Date: Dec 2021
Posts: 85
Received Thanks: 74
|
Quote:
Originally Posted by Legend Sro
thx for help u can give me table
|
for some reasons i am unable to mention a code in a reply lol it goes to that much mentions, anyway, here is the table and the code.
|
|
|
|
|
03/11/2023, 19:14
|
#8
|
elite*gold: 0
Join Date: Feb 2023
Posts: 62
Received Thanks: 3
|
Quote:
Originally Posted by painmaker_
for some reasons i am unable to mention a code in a reply lol it goes to that much mentions, anyway, here is the table and the code.
|
very thx for help
|
|
|
|
 |
Similar Threads
|
[Procedure] Vsro procedure for rewarding players who reach max level
11/16/2022 - SRO PServer Guides & Releases - 9 Replies
Hi everyone,
I hope you are all doing well. I wrote a procedure for rewarding the players who reach the max level. This procedure will let you reward limited number of players.
Reward will be given by Maxiguard filter. If you use any other filter just replace with your codes
Rewards,
1- Silk reward
2 PLVL Expert reward (you can change)
|
hello . i need some help with procedure . someone can help me
02/29/2020 - SRO Private Server - 2 Replies
hello . i need some help with procedure . someone can help me
i have procedure and he have bug ... can someone help me ???
USE
GO
/****** Object: StoredProcedure . Script Date: 2/28/2020 2:46:43 PM ******/
SET ANSI_NULLS ON
GO
|
[Buying] Need help with MySQL stored procedure
08/10/2016 - Coders Trading - 1 Replies
Hey,
I´d like to add a stored procedure to my database and run it every X hours.
I have no idea how to setup so Im asking here for some help and I´m willing to donate some Paypal $$.
Thanks,
Wakan88
|
All times are GMT +1. The time now is 14:35.
|
|
