[Share]Fixed sp_LogAction_Insert On Neo / Gunner Server Files

[IamDJDRB]

Hello Good Day RaGEZONERs,
Here's another own modified script again for all of you guyz.
Almost 2 months i didn't share new anything here :P
I know this is practical ERROR for all Neo Files user.
So this is the SOLUTION.
Use your eyes, hands, and brain to do it work especially the BRILLIAN TOOL the " COMMON SENSE "

ERROR :



SOLUTION :
Just copy this next connect to ur own SQL Management Studio Express
After that click NEW QUERY then PASTE this code then EXECUTE KABOOM !

USE [RanLog]
GO
/****** Object:  StoredProcedure [dbo].[sp_LogAction_Insert]    Script Date: 08/08/2012 08:01:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[sp_LogAction_Insert]
    @nChaNum int,
    @nType int,
    @nTargetNum int,
    @nTargetType int,
    @nExpPoint money,
    @nBrightPoint int,
    @nLifePoint int,
    @nMoney money
AS    
    SET NOCOUNT ON
    IF (@nType=2)
    BEGIN
    UPDATE RanGame1.dbo.ChaInfo
    SET ChaKills=ChaKills+1
    WHERE ChaNum = @nChaNum
    END
    INSERT INTO LogAction (ChaNum,   Type,   TargetNum,   TargetType,   ExpPoint,   BrightPoint,   LifePoint,   ActionMoney) 
    VALUES    (@nChaNum, @nType, @nTargetNum, @nTargetType, @nExpPoint, @nBrightPoint, @nLifePoint, @nMoney)

    SET NOCOUNT OFF 

DONT ASK ME HOW TO EXECUTE 'COZ I'VE ALREADY TOLD HOW TO DO IT


Credits :
EssaeyPride
SeiferXIII

[MentaL]

[PatPayatot]

@Essay Thanks :D Solved my problem :)

[charlie001]

this problem occurs when player pk another player. :)

[IamDJDRB]

this problem occurs when player pk another player. :)

Yeah, you're right .

[biogenic70]

Yeah, you're right .

how about this error? did you already solved this?

DB:{call sp_LogAction_Insert(190798,1,0,4,73786988389466112,0,0,0)}
DB:42000, NativeError:8114, [Microsoft][SQL Native Client][SQL Server]Error converting data type numeric to money.

[hujiko]

sir,

what about this one,
DB:Exec sp_UpdateMakeAllUserOffline 1
DB:42000, NativeError:2812, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'sp_UpdateMakeAllUserOffline

[fsjwiper]

Thank you for sharing...

[hujiko]

sir essaey, you were able to solve my problem in the other thread using your script by using my own ep6 Ranuser db together with ep7 db, and they were all success with no error while stating the server, but i got problem on login coz sytem error caused login fail, what do you think sir it is not compatible with the client coz am using jamran client,... thnx!

[EMOLISTA]

That script is only applicable for Neo Version only. Otherwise, don't to execute this if this is not fitted for the server files you have :)

[tearhear18]

this script hasn't any incompatible issue on what ever Ran Database
what it does is update your chakill counts once you kill character in-game..
commonly use to rank top killer players

[ImMiremo]

is this compatible with sweety? ^^.