Login

Create procedure (create game account): CREATE PROCEDURE [dbo].[rasp_CreateAtlanticaGameAccount] ( --Input data @Login varchar(20), @Passwd varchar(32) ) AS set nocount on BEGIN DECLARE @idnum int ,@user_id varchar(20) SET @user_id = @Login ...

Have someone problems with Sbot after i start the Game and Login it Close and says "Connection to Silkroad Server terminated (10054)". Have someone a Fix for it? Edit: Fixed it with First Connection with first "Manual Login".

...hat use Status = -3 time ban and Status = -5 Permanent Ban. In addiction there is dbo.Users_Block_Log for add a reason or so. The procedure is stored inside dbo.usp_Try_GameLogin_Taiwan and is this part: -- BlockUser Check IF @Status = -3 BEGIN -- Get Block Limit Date AND Replace date text DECLARE @BlockEndDate datetime SELECT @BlockEndDate = Block...

...em. I was toying around with SSMT,MS SQL 2016 with the sendcode3 storedprocedure, and when I tried to execute dbo.ROHAN_SENDCODE3 it was complaining that it does not get the Login_id. Anyone get this? However selecting everything and executing work as intended. EDIT: Nvm, I understand what happened. Sorry for bothering with nonsese

Hello, Since I edited my usp_Try_GameLogin_Taiwan and usp_Try_GameLogout_R procedures, I have been receiving such strange errors. Does anybody know what they mean and how to fix them? Thank you in advance for any h...

...h SQL, I decided to share this easy way for prevent people to dual-box, statpad etc. that i just made for my server. First off, if you read official rules from Shaiya, multilogin is not allowed for ANY reason from the same IP, but I'm the first that want allow everyone to play, even from the same IP, so i added an exceptions column that you can manage ...

...****** Object: StoredProcedure [dbo].[BuyItem] Script Date: 06/02/2016 14:44:47 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[BuyItem] Login_id nvarchar(50) AS BEGIN DECLARE @i as integer, Counter as integer, user_id as INTEGER, row as integer, -- item_id as integer, stack as integer, PRICE...

...AS SET NOCOUNT ON DECLARE LogTime datetime DECLARE sql nvarchar(4000) DECLARE yyyy varchar(4) DECLARE @mm varchar(2) DECLARE @dd varchar(2) DECLARE LogType bit -- Login:0, Logout:1 SET LogType = 1 SET LogTime = GETDATE() SET yyyy = DATEPART(yyyy, LogTime) SET @mm = DATEPART(mm, LogTime) SET @dd = DATEPART(dd, LogTime) IF( LEN(@...