Register for your free account! | Forgot your password?

You last visited: Today at 09:54

  • Please register to post and access all features, it's quick, easy and FREE!


Auto Bann StatPadd Release

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2015
Posts: 118
Received Thanks: 40
Auto Bann StatPadd Release

PS_GameLog.dbo.usp.Insert_Action_Log_E

select and copy under the following code:

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END

PHP Code:
ELSE IF @ActionType 103 -- pvp kill
BEGIN    
    INSERT INTO Kill_Log VALUES 
(@UserID, @UserUID, @CharID, @CharName, @Value1, @Text1, @MapID, @PosX, @PosY, @PosZ, @ActionTime)    
END

ELSE IF @ActionType 104 -- pvp death
BEGIN    
    INSERT INTO Death_Log VALUES 
(@UserID, @UserUID, @CharID, @CharName, @Value1, @Text1, @MapID, @PosX, @PosY, @PosZ, @ActionTime)
        
    DECLARE @
K1 INT = (SELECT COUNT(*) FROM Kill_Log WHERE CharID = @CharID)
    DECLARE @
K2 INT = (SELECT COUNT(*) FROM Death_Log WHERE CharID = @CharID)
    
    IF (@
K2 50 AND @K1 50 < @K2)
    -- if 
the character died more than 10 times and their kills multiplied by 10 are less than their deaths
    BEGIN
        
-- banning the feeder
        UPDATE PS_UserData
.dbo.Users_Master
        SET Status 
= -5
        WHERE UserUID 
= @UserUID
        
        
-- banning the killer
        
-- uncomment those lines if you want the killer to get banned (not recommended)
        --
UPDATE PS_UserData.dbo.Users_Master
        
--SET Status = -5
        
--WHERE UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharID = @Value1)        
    
END
END 
And Execute the following procedures.

PHP Code:
USE [PS_GameLog]
GO

/****** Object:  Table [dbo].[Death_Log]    Script Date: 6/13/2015 11:26:20 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE 
[dbo].[Death_Log](
    [
RowID] [intIDENTITY(1,1NOT NULL,
    [
UserID] [varchar](18NOT NULL,
    [
UserUID] [intNOT NULL,
    [
CharID] [intNOT NULL,
    [
CharName] [nvarchar](50NOT NULL,
    [
KillerCharID] [intNOT NULL,
    [
KillerCharName] [nvarchar](50NOT NULL,
    [
MapID] [tinyintNOT NULL,
    [
PosX] [realNOT NULL,
    [
PosY] [realNOT NULL,
    [
PosZ] [realNOT NULL,
    [
ActionTime] [datetimeNOT NULL,
 
CONSTRAINT [PK_Death_LogPRIMARY KEY CLUSTERED 
(
    [
RowIDASC
)WITH (PAD_INDEX OFFSTATISTICS_NORECOMPUTE OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS ONALLOW_PAGE_LOCKS ONON [PRIMARY]
ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 
PHP Code:
USE [PS_GameLog]
GO

/****** Object:  Table [dbo].[Kill_Log]    Script Date: 6/13/2015 11:28:13 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE 
[dbo].[Kill_Log](
    [
RowID] [intIDENTITY(1,1NOT NULL,
    [
UserID] [varchar](20NOT NULL,
    [
UserUID] [intNOT NULL,
    [
CharID] [intNOT NULL,
    [
CharName] [nvarchar](50NOT NULL,
    [
DeadCharID] [intNOT NULL,
    [
DeadCharName] [nvarchar](50NOT NULL,
    [
MapID] [tinyintNOT NULL,
    [
PosX] [realNOT NULL,
    [
PosY] [realNOT NULL,
    [
PosZ] [realNOT NULL,
    [
ActionTime] [datetimeNOT NULL,
 
CONSTRAINT [PK_Kill_LogPRIMARY KEY CLUSTERED 
(
    [
RowIDASC
)WITH (PAD_INDEX OFFSTATISTICS_NORECOMPUTE OFFIGNORE_DUP_KEY OFFALLOW_ROW_LOCKS ONALLOW_PAGE_LOCKS ONON [PRIMARY]
ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 
Credits to nubness



[ADM]Whiite is offline  
Thanks
3 Users
Old 06/13/2015, 12:33   #2

 
elite*gold: 105
Join Date: Jun 2015
Posts: 47
Received Thanks: 24
Wink hey

Why one automobile proclamation Statpadd(round of applause Statpadd) you would do better to make a script for removed kil by identical IP or a script which disconnects express die that a kil this fact with the grandma IP


[DEV]_Yűko is offline  
Thanks
1 User
Old 06/13/2015, 14:24   #3
 
elite*gold: 0
Join Date: Jul 2012
Posts: 312
Received Thanks: 274
Im pretty sure that this was alredy released by nubness here
andr3y_you96 is offline  
Thanks
2 Users
Old 06/13/2015, 20:28   #4
 
elite*gold: 0
Join Date: Jun 2015
Posts: 81
Received Thanks: 136
Nice little release I read through all the scripts and its nice and clean and it will do the job but I agree with shineo on some points he made it would work better if it did a kill penalty then banning the people involved everyone tries to cheat or exploit the system at some time or another banning them only cost you players on your server. so by given a penalty you put a stop to it with out losing players


[Alcatraz] is offline  
Thanks
1 User
Old 06/13/2015, 20:59   #5
 
elite*gold: 0
Join Date: Jan 2015
Posts: 118
Received Thanks: 40
Thanks for your suggestions guys, We will look into it
[ADM]Whiite is offline  
Old 06/13/2015, 21:28   #6
 
elite*gold: 0
Join Date: Jun 2015
Posts: 81
Received Thanks: 136
you could do like shineo suggested and make it look for ip address of the killer and the killed but you'll run into a problem there with the Philippines. being alots of the players there use what they call a café and a lot of them will return the same ip address which in turn creates a problem for auto ban scripts and account limits but doing it how you have it set up now and just figure the amount of kills they gain from that one person and have it update the k1 in chars for that person to reduce the total kills I think would put a fast stop to stat padding but that would be a suggestion it would need to be tested to make sure its not creating problems for other players who are just isn't geared enough yet to making kills with out dying 50 times lol
[Alcatraz] is offline  
Old 06/13/2015, 23:04   #7
 
elite*gold: 0
Join Date: Jul 2009
Posts: 330
Received Thanks: 78
Where is the credits to the orginal author because these script have been pulled from Nubness Admin pannel Scripts from his PS_Gamelog
Big_ is offline  
Thanks
1 User
Old 06/14/2015, 00:05   #8
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,235
Quote:
Originally Posted by andr3y_you96 View Post
Im pretty sure that this was alredy released by nubness here
Quote:
Originally Posted by Big_ View Post
Where is the credits to the orginal author because these script have been pulled from Nubness Admin pannel Scripts from his PS_Gamelog
Good point, didn't even notice that. Thanks to both of you for pointing it out.
I guess there's nothing else I have to say here. Typical release for the past year or so.
nubness is offline  
Old 06/14/2015, 19:12   #9
 
elite*gold: 0
Join Date: Jan 2015
Posts: 118
Received Thanks: 40
Credits to nubness
[ADM]Whiite is offline  
Old 06/14/2015, 20:19   #10
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,235
Quote:
Originally Posted by [ADM]Whiite View Post
Credits by nubness
Credits to nubness.

If it's already released, why exactly did you release it again ?
nubness is offline  
Thanks
4 Users
Old 06/24/2015, 00:06   #11
 
elite*gold: 0
Join Date: Aug 2012
Posts: 454
Received Thanks: 104

in this query i get a error, because if anyone kill a player in battle + of 10 times the other is banned :|
I Tested...
AxelMac is offline  
Old 06/30/2015, 00:46   #12
 
elite*gold: 0
Join Date: May 2014
Posts: 34
Received Thanks: 38
nubness thats so much kid u can now stop commenting in every **** thread could you? Thank you
Revolution66614 is offline  
Old 07/01/2015, 10:57   #13
 
elite*gold: 0
Join Date: Jan 2010
Posts: 35
Received Thanks: 1
Char level column need to add


auferhousethe is offline  
Reply



« Just some recolor gears | All System for Shaiya By: [DEV]Cartola »

Similar Threads
Auto-Bann
01/09/2011 - CrossFire Hacks, Bots, Cheats & Exploits - 10 Replies
Man kriegt seit heute bei dem Finject, und bei dem Airdropinjector einen AutoBann nach dem einloggen. Andere Injector habe ich nicht getestet.
Auto bann..
08/10/2010 - Dekaron - 19 Replies
can anyone confirm that there is a auto bann for hacking? or is it simple fact player was hacking wrong place @ wrong time. i ask only cause my brothers summoner got banned lastnight while he was hacking in maze. now i personally had no problems when i was in norak&castor 2 i was doing it for 2 hours or so, he was in maze for about 30mins then DC and when he logged in said banned, pretty much. so whats the deal is there a auto bann now or was it just his luck? cause i dont wanna risk my...
Dekaron auto bann
09/25/2008 - Dekaron - 16 Replies
dekarons autoban is up and running? :D got 3 accounts banned and my ip for fun :)
Auto bann by WPE
03/17/2006 - Ragnarok Online - 13 Replies
also ich spiele auf XileRo PK&EX alls ich mit wpe paket senden wolte war ich gebannt und bei ich habe es mit andre acc hatte ich auch auto bann bekommen kann jemand mir helfen :cry:



All times are GMT +1. The time now is 09:54.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.