USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[MAIL_STR] Script Date: 26/10/2016 13:04:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[MAIL_STR]
@iGu CHAR(2),
@nMail INT,
@serverindex CHAR(2),
@idReceiver CHAR(7) = '0000000',
@idSender CHAR(7) = '0000000',
@nGold INT = 0,
@reate INT = 0,
@byRead INT = 0,
@itle VARCHAR(128) = '', @xt VARCHAR(1024) = '',
@dwItemId INT = 0,
@nItemNum INT = 0,
@nRepairNumber INT = 0,
@nHitPoint INT = 0,
@nMaxHitPoint INT = 0,
@nMaterial INT = 0,
@byFlag INT = 0,
@dwSerialNumber INT = 0,
@nOption INT = 0,
@bItemResist INT = 0,
@nResistAbilityOption INT = 0,
@idGuild INT = 0,
@nResistSMItemId INT = 0,
@bCharged INT = 0,
@dwKeepTime INT = 0,
@nRandomOptItemId bigINT = 0,
@nPiercedSize INT = 0,
@dwItemId1 INT = 0,
@dwItemId2 INT = 0,
@dwItemId3 INT = 0,
@dwItemId4 INT = 0
------------------- Version9 Pet
,@bPet int = 0,
@nKind int = 0,
@nLevel int = 0,
@dwExp int = 0,
@gy int = 0, @fe int = 0,
@anAvailLevel_D int = 0,
@anAvailLevel_C int = 0,
@anAvailLevel_B int = 0,
@anAvailLevel_A int = 0,
@anAvailLevel_S int = 0,
@dwItemId5 int = 0
----------------- Ver. 12
,@dwItemId6 int = 0, @dwItemId7 int = 0, @dwItemId8 int = 0, @dwItemId9 int = 0, @dwItemId10 int = 0
,@dwItemId11 int = 0, @dwItemId12 int = 0, @dwItemId13 int = 0, @dwItemId14 int = 0, @dwItemId15 int = 0
,@nPiercedSize2 int = 0
----------------- Ver. 13
, @szPetName varchar(32) = ''
AS
set nocount on
IF @iGu = 'S1'
BEGIN
SELECT * FROM MAIL_TBL WHERE serverindex = @serverindex AND byRead<90 order by nMail
RETURN
END
ELSE
IF @iGu = 'A1'
BEGIN
INSERT MAIL_TBL
(
nMail,
serverindex,
idReceiver,
idSender,
nGold,
tmCreate,
byRead,
szTitle,
szText,
dwItemId,
nItemNum,
nRepairNumber,
nHitPoint,
nMaxHitPoint,
nMaterial,
byFlag,
dwSerialNumber,
nOption,
bItemResist,
nResistAbilityOption,
idGuild,
nResistSMItemId,
bCharged,
dwKeepTime,
nRandomOptItemId,
nPiercedSize,
dwItemId1,
dwItemId2,
dwItemId3,
dwItemId4,
SendDt
, bPet, nKind, nLevel, dwExp, wEnergy, wLife, anAvailLevel_D, anAvailLevel_C
, anAvailLevel_B, anAvailLevel_A, anAvailLevel_S, dwItemId5
, dwItemId6, dwItemId7, dwItemId8, dwItemId9, dwItemId10, dwItemId11
, dwItemId12, dwItemId13, dwItemId14, dwItemId15, nPiercedSize2
-- Ver. 13
, szPetName
)
VALUES
(
@nMail,
@serverindex,
@idReceiver,
@idSender,
@nGold,
@reate,
@byRead,
@itle, @xt,
@dwItemId,
@nItemNum,
@nRepairNumber,
@nHitPoint,
@nMaxHitPoint,
@nMaterial,
@byFlag,
@dwSerialNumber,
@nOption,
@bItemResist,
@nResistAbilityOption,
@idGuild,
@nResistSMItemId,
@bCharged,
@dwKeepTime,
@nRandomOptItemId,
@nPiercedSize,
@dwItemId1,
@dwItemId2,
@dwItemId3,
@dwItemId4,
getdate()
, @bPet, @nKind, @nLevel, @dwExp, @gy, @fe, @anAvailLevel_D, @anAvailLevel_C
, @anAvailLevel_B, @anAvailLevel_A, @anAvailLevel_S ,@dwItemId5
, @dwItemId6, @dwItemId7, @dwItemId8, @dwItemId9, @dwItemId10, @dwItemId11
, @dwItemId12, @dwItemId13, @dwItemId14, @dwItemId15, @nPiercedSize2
-- Ver. 13
, @szPetName
)
RETURN
END
IF @iGu = 'D1'
BEGIN
UPDATE MAIL_TBL SET byRead=90, DeleteDt=getdate() WHERE nMail = @nMail AND serverindex = @serverindex
RETURN
END
IF @iGu = 'D2'
begin
--update MAIL_TBL set byRead=90, DeleteDt=getdate() where serverindex = @serverindex and tmCreate < @reate
return
end
IF @iGu = 'U1'
BEGIN
UPDATE MAIL_TBL SET
ItemFlag=90, ItemReceiveDt=getdate()
WHERE nMail = @nMail AND serverindex = @serverindex
RETURN
END
IF @iGu = 'U2'
BEGIN
UPDATE MAIL_TBL SET GoldFlag=90, GetGoldDt=getdate() WHERE nMail = @nMail AND serverindex = @serverindex
RETURN
END
IF @iGu = 'U3'
BEGIN
UPDATE MAIL_TBL SET byRead = 1, ReadDt=getdate() WHERE nMail = @nMail AND serverindex = @serverindex
RETURN
END
It seems that either the Title or the Text is too long for the column.By default, szTitle can take 128 and szText can take up to 255 characters.
Check what length your szText and szTitle columns (in MAIL_TBL) can take and check what your server wants to insert there (maybe with debug output, or some error log output for testing).
SMC : Fortress War Taxes 09/18/2018 - SRO Private Server - 5 Replies Hello :
i opened SmC : Schedule Controller : TAX_PERIOD ,
i'm trying to make guilds collect the fortress war taxes every day in the week and in any time , does any one know what is the option and time setting i should chose ? cuz i keep failing
there is 2 options :
01- everyday for ( duration ) from (Start time)
[Trading] [H] 5€ Amazon GiftCard [W] 5€ paysafecard! can pay e*gold taxes, i go first 07/03/2016 - Trading - 2 Replies hello,
iam here to trade my earned amazon giftcard (5€) for a 5€ paysafecard! I will go first if you are trusted enough (atleast 100 tbm´s!!) otherwise i get ma code first :)
iam ok with paying taxes
group level limit/taxes in the blackmarket 01/16/2014 - Shaiya PServer Development - 2 Replies Hey guys I come with another request to you, what I am searching for is for a group level limit which i want to set. I don't know how, where and I have no idea.
Also there are taxes in the blackmarket, anybody have an idea of where I can change them?
Created npc and Fortress taxes 10/09/2012 - SRO Private Server - 2 Replies Hi, how to set npc selling items on fortress war tax system ?
[Bug] Taxes 10/20/2008 - Kal Online - 0 Replies Hey... Well I play on a private server and I am the castle owner... well I had the following thing: When i took taxes, i had my full 2kkk. But when I taked it and put it in storage, i went back and saw it has again 2kkk...
Well after geting the money a few times, i got c/l. Now the taxes are normal... I heared from some guys that they read about this bug and how to use it. Do anyone know of you how to use it?
Would be great!
Thanks
reate INT = 0,
