JoB
|
Last Activity: 09/04/2017 23:28
Mentions
| 08/05/2022 |
| 23:26 - ...rName16 from SRO_VT_SHARD.dbo._Char WHERE CharID = ChariD),
regionID INT = (SELECT LatestRegion FROM sro_VT_shard.dbo._Char WHERE CharID = ChariD)
DECLARE JoBType1 INT = (SELECT JobType From SRO_VT_SHARD.dbo._CharTrijob Where CharID = ChariD )
IF regionID IN (SELECT wRegionID FROM sro_VT_SHARD.dbo._RefRegion WHERE IsBattleField... |
| 08/03/2020 |
| 06:58 - loader8 mentioned JoB in post Academy Honor Via Job kill hi guys im trying to set up the Academy Honor via job kill, i was working with this Produce but i dont know why _TrainingCamp Table dont be affected if i make the update who can help me
USE [SRO_VT_SHARDLOG]
GO
/****** Obje... |
| 06/15/2020 |
| 03:53 - bimbum* mentioned JoB in post Honor Buff Jop ...dn't try that . but it has to work with you
it depends on contribution, you can customize it as you want
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_JobGrant] Script Date: 6/15/2020 4:48:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_JobGrant]
@CharName varchar(64)
... |
| 01/21/2020 |
| 20:12 - Deleted Posts |
| 08/06/2019 |
| 10:16 - CoinY the system from your server is good. you can do a lot here but in matter of silk this is really pay 2 win. you said you can do job cave events medusa. yesterday i was JoB unique and medusa. from job i got about 30 silk and medusa around 11. that is literally nothing in terms of effort you put in it.
now ... |
| 02/26/2019 |
| 20:28 - JujiPoli mentioned JoB in post [RELEASE] Basic GM Reroll You got it for free again, execute, done.
Craftname work this way: 00 STR 00 DEX 00 REC 00 INT 00 WIS 00 LUC 00 HP 00 MP 00 SP 00 ENCHANT (20 numbers)
There is 2 Stored Procedur... |
| 02/04/2019 |
| 20:53 - XareL mentioned JoB in post [Small-Guide] Remove Chat Emote If you want class exchange, you can use this mini query. |
| 10/09/2018 |
| 06:49 - Dermαn ♣ mentioned JoB in post Looking for working job reward system ...e CoinWinforthi int;
declare CoinWinforhun int;
declare dividerfortra int;
declare dividerforthi int;
declare dividerforhun int;
declare charname16 varchar(16);
declare JoBType int;
set dividerfortra = 270000;
set dividerforthi = 900000;
set dividerforhun = 300000;
if(@EventID = 6)
begin
set charname16 = (SELECT CharName16 FROM [SRO_VT_SH... |
| 01/01/2018 |
| 15:32 - tvdynamo mentioned JoB in post Invalid object name SR_CharAppoint FIX ? ...dbo].[_ManageShardCharName] Script Date: 1/1/2018 9:31:04 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
JoB tinyint,
userJID int,
ShardiD smallint,
charname varchar(64),
Oldname varchar(64)
as
-- add new char name
if JoB = 0)
begin
if (not exists(select *... |
| 10/12/2017 |
| 02:59 - [Graphicer]NatureL mentioned JoB in post Instant level for ep 6.4 ...BEGIN
SET @Grow = 3
SET level = 15
SET statPoint = 126
SET skillpoint = 9999
SET money = 2000000
SET Map = 42
SET posX = 57.072
SET posy = 1.700
SET posz = 67.886
IF JoB = 0
BEGIN
SET str = 73
END
ELSE IF JoB = 1
BEGIN
SET rec = 71
END
ELSE IF JoB = 2
BEGIN
SET @dex = 78
END
ELSE IF JoB = 3
BEGIN
SET luc = 72
END
ELSE IF JoB = 4
BEGIN
SET ... |
| 03/16/2017 |
| 20:20 - batymaty mentioned JoB in post Re-Open Skills I had a problem this afternoon, had to delete all the players' open skills, and then re-apply again, but I don't find a script, then I edited one from Elitepvpers for this.
I used... |
| 03/31/2016 |
| 17:20 - Trayne01 mentioned JoB in post [WIP] Shaiya Wings Slot (and trade faction tag) Hello everyone,
I am working on the new wing slot, wings are working well, but the problem is that I didn't fixed few pack issues yet with the new game.exe such as name and few m... |
