anyone can share this stored procedure
user_gametimecvt
anyone can share this stored procedure
user_gametimecvt
Add this to GLchar.cpp
find this
case EMSPECA_REFDAMAGE:
case EMSPECA_NONBLOW:
case EMSPECA_PIERCE:
and add this below
case EMSPECA_INVISIBLE: //add invi-anti
case EMSPECA_RECVISIBLE: //add invi-anti
same goes for glcharclient
find this
case EMSPECA_REFDAMAGE:
case EMSPECA_NONBLOW:
case EMSPECA_PIERCE:
and add this below
case EMSPECA_INVISIBLE: //add invi-anti
case EMSPECA_RECVISIBLE: //add invi-anti
Anyone how make campus_1f to be campus a school class map only all I can't save him?
Thank you :)
same problem with you bro.
Is there anyone who already fixed this? if none yet, let me check other db shared from this forum.
if you check the whole thread the database is already shared here . you just need to look .
I used this one -> https://forum.ragezone.com/f528/inga...-wtih-1179663/
thank you bro
how can I create .aps file? there is no aps editor or what embyte crypt would use to encrypt aps abl files?
Is this a bug or I just don't meet the requirement of TW?
Scenario is I went inside the TW Event then Knock down the 3 Tower when TW Event is finish I just only receive 1 Reward Buff which represent "BUFF_REWARD_MAIN" but the BUFF_REWARD_01,BUFF_REWARD_02,BUFF_REWARD_03 not showing or I didn't receive. hmmmm
Thanks.
for those having problem with missing stored procedure for gametime convert, paste and execute this on your SQL Server under RanUser database.
PS. I found it from database shared already in this section
Code:/****** Object: StoredProcedure [dbo].[user_gametimecvt] Script Date: 6/18/2021 5:43:44 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[user_gametimecvt] @szUserID varchar (33), @nReturn int OUTPUT AS SET NOCOUNT ON DECLARE -- Declare variables used in error checking. @ERROR_var int, @Rowcount_var int, @NuserNum int, @nGameTime int, @nGameTimeDiv int, @nGameTimeRes int, @vUserName varchar(33), @Minutes int, @Total int, @PMinutes int, @PTotal int, @wa int, @sagot int, @sagot1 int, @sagot2 int, @after int, @af1 int, @af2 int, @pafter int, @BP int --set your configuration here SET @nGameTimeDiv = 60; SET @nGameTimeRes = 2; SELECT @NuserNum = UserNum , @vUserName = UserID , @nGameTime = PlayTime , @BP = UserPoint2 From UserInfo Where UserName = @szUserID --calculate SET @Minutes = @nGameTime / @nGameTimeDiv; SET @Total = @Minutes SET @PMinutes = @nGameTime/@nGameTimeDiv; SET @PTotal = @PMinutes; --conversion SET @wa=@nGameTime/@nGameTimeDiv; SET @sagot=@wa; SET @sagot1 @sagot*@nGameTimeDiv; SET @sagot2 @sagot*@nGameTimeRes; --FOR LOG SET @after = @nGameTime - @sagot1; SET @af1=@after/@nGameTimeDiv SET @af2=@af1; SET @pafter = @BP + @sagot2; SELECT @ERROR_var = @ERROR, @Rowcount_var = @RowCOUNT IF @NuserNum !=0 BEGIN IF @nGameTime >= @nGameTimeDiv BEGIN -- update point UPDATE dbo.UserInfo SET UserPoint2 = UserPoint2 + @sagot2 , PlayTime = PlayTime - @sagot1 WHERE UserName = @szUserID SET @nReturn = @NuserNum RETURN @nReturn END ELSE BEGIN SET @nReturn = 0 RETURN @nReturn END END ELSE BEGIN SET @nReturn = 0 RETURN @nReturn END SET NOCOUNT OFF RETURN @nReturn GO
[QUOTE=aizen00;9085199]no not the points i don't have a problem with it what imean is the item stock
like this one .
https://streamable.com/prs3i7
do you still have this problem?