|
You last visited: Today at 07:34
Advertisement
[SQL] Kill Fetch [KillEvent/Points/Survival]
Discussion on [SQL] Kill Fetch [KillEvent/Points/Survival] within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
03/24/2015, 13:29
|
#16
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
Quote:
Originally Posted by Exo
PHP Code:
IF (@EventID = 20) BEGIN EXEC Exo_KillFetch @CharID,@Desc,@strPos END
|
i added that to add log char and now should i wear job or wait untill it notice or what to do to start it ?
|
|
|
03/24/2015, 13:56
|
#17
|
elite*gold: 0
Join Date: Nov 2011
Posts: 353
Received Thanks: 199
|
IF (@strPos = '0x0000' AND @JobType = 'Job')
--Table
PHP Code:
CREATE TABLE [dbo].[_KillLogs]( [ID] [int] IDENTITY(1,1) NOT NULL, [KillerID] [int] NOT NULL, [CharID] [int] NOT NULL, [strPos] [varchar](64) NOT NULL, [JobType] [varchar](max) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO
|
|
|
03/24/2015, 14:58
|
#18
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Quote:
Originally Posted by raptter
i added that to add log char and now should i wear job or wait untill it notice or what to do to start it ?
|
Create that table, change the INSERT INTO TABLE at the procedure to your new table path, go and kill someone, check the table.
|
|
|
03/24/2015, 15:53
|
#19
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
Quote:
Originally Posted by Exo
Create that table, change the INSERT INTO TABLE at the procedure to your new table path, go and kill someone, check the table.
|
i added this table but no kills records could u add me on skype to help me ?
my skype lovestory3mr
|
|
|
03/24/2015, 16:02
|
#20
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
^ Just edit this line
Quote:
CREATE PROCEDURE Exo_KillFetch
-- =============================================
-- Author: <Exo>
-- Create date: <13.5.2014>
-- Description: <KillFetch>
-- =============================================
@CharID INT,
@Desc VARCHAR(512),
@strPos VARCHAR(64)
AS
BEGIN SET NOCOUNT ON;
--//---------------------------------------------------------------
DECLARE
@KillerName VARCHAR(max),
@KillerID INT,
@JobType VARCHAR(max),
@StartPos TINYINT
--//---------------------------------------------------------------
SELECT @StartPos = (SELECT CHARINDEX('(',@desc)) + 1
SELECT @KillerName = (SELECT SUBSTRING(@Desc, @StartPos, CHARINDEX(')', @Desc, @StartPos) - @StartPos))
SELECT @KillerID = (SELECT CharID FROM Fayox_Shard.._Char WHERE CharName16 = @KillerName)
--//---------------------------------------------------------------
SELECT @JobType = CASE
WHEN (@desc LIKE '%My: Trader%')
OR (@desc LIKE '%My: Robber%')
OR (@desc LIKE '%My: Hunter%')
THEN 'Job'
WHEN (@desc LIKE '%Murderer%')
THEN 'Murder'
ELSE 'Free'
END
--//---------------------------------------------------------------
BEGIN TRANSACTION
--ADD your event conditions here example:
--IF (@strPos = '0x0000')
--BEGIN
-- Give silk
--END
INSERT Fayox_Log.._KillLogs VALUES (@KillerID,@CharID,@strPos,@JobType)
COMMIT TRANSACTION
END
|
|
|
|
03/24/2015, 18:19
|
#21
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
Quote:
Originally Posted by Exo
^ Just edit this line
|
i'll try it hope it works
i did all what you say but nothing happened ^^ should i add this table at VT_SHARDLOG or VT_SHARD ?
|
|
|
03/24/2015, 19:35
|
#22
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Quote:
Originally Posted by raptter
i'll try it hope it works
i did all what you say but nothing happened ^^ should i add this table at VT_SHARDLOG or VT_SHARD ?
|
Are you using any gs addon that disables log?
|
|
|
03/24/2015, 19:41
|
#23
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
Quote:
Originally Posted by Exo
Are you using any gs addon that disables log?
|
my srzor disable log = 0
and i use K-guard i don't know it disable it or not
|
|
|
03/24/2015, 20:00
|
#24
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
Give me your TV ID/PW -,-
|
|
|
03/24/2015, 20:05
|
#25
|
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
|
Quote:
Originally Posted by Exo
Give me your TV ID/PW -,-
|
add me on skype better
thank alot Exo <3
|
|
|
03/29/2015, 13:13
|
#26
|
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
|
Good Job Exo
|
|
|
10/05/2015, 15:10
|
#27
|
elite*gold: 1
Join Date: Sep 2015
Posts: 413
Received Thanks: 264
|
thq man
keep it ip
|
|
|
10/06/2015, 12:27
|
#28
|
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
|
-good job
|
|
|
|
|
Similar Threads
|
[Tutorial] Changing the kill cap and stat points given by the Vet Manager
09/14/2018 - Shaiya PServer Guides & Releases - 6 Replies
Hello everyone,
As some of you may have remarked, on Shaiya Euphoria I modified the PvP rank kill caps and the amount of stat points a player receives from the Vet Manager after reaching a certain PvP rank. I was already asked by some individuals how to do it, so I decided to make a thread here on elitepvpers to explain how it is done. I hope that those who are reading this post are more curious about knowing how it is done, than just having it done by someone, and this is why I'll explain...
|
[Help] ClientSocket.Fetch
04/29/2013 - Flyff Private Server - 0 Replies
2013/ 4/29 09:16:44 Other Cache Connection - IP : 124.120.236.222
2013/ 4/29 09:19:03 Other Cache Connection - IP :
2013/ 4/29 09:19:22 CClientSocket.Fetch: ip = 124.120.236.222, size = 1330205781
2013/ 4/29 09:19:22 CClientSocket.Fetch: ip = 124.120.236.222, size = 1330205781
2013/ 4/29 09:19:22 CClientSocket.Fetch: ip = 124.120.236.222, size = 1330205781
|
[B]Boss KillEvent - Service
10/31/2011 - WarRock Trading - 3 Replies
/closed
|
Easy survival mode all win with 30 kill
08/27/2009 - Grand Chase Hacks, Bots, Cheats & Exploits - 5 Replies
Make a rum and scan 1 (team mode)
Then switch to survival mode scan 2
Then pick the two adress that starts at 02
((((Thats the adreess for survival mode all win)))))))
To get 30 kill
Start a game (team mode) then kill 1 enemy and scan 1
after that kill another one and scan 2..
|
Less PK Points Per Kill
02/19/2007 - CO2 Guides & Templates - 11 Replies
Ok Guys i have just remembred how to get 5 pk points everytime u kill some 1.
You go up to the person you want to kill and go with no gear make him kill you a couple times to make him on ur enemy list.
Then everytime you kill that person after you get him/her in enemy you will get 5 pk points
if you already know this please dont flame this thanks. ;)
|
All times are GMT +1. The time now is 07:34.
|
|