Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 07:34

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

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.

Reply
 
Old 03/24/2015, 13:29   #16
 
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
Quote:
Originally Posted by Exo View Post
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 ?
raptter is offline  
Old 03/24/2015, 13:56   #17
 
bestprem's Avatar
 
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] [intIDENTITY(1,1NOT NULL,
    [
KillerID] [intNOT NULL,
    [
CharID] [intNOT NULL,
    [
strPos] [varchar](64NOT NULL,
    [
JobType] [varchar](maxNOT NULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO 
bestprem is offline  
Thanks
1 User
Old 03/24/2015, 14:58   #18


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
Quote:
Originally Posted by raptter View Post
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.
​Exo is offline  
Old 03/24/2015, 15:53   #19
 
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
Quote:
Originally Posted by Exo View Post
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
raptter is offline  
Old 03/24/2015, 16:02   #20


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
^ Just edit this line
​Exo is offline  
Old 03/24/2015, 18:19   #21
 
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
Quote:
Originally Posted by Exo View Post
^ 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 ?
raptter is offline  
Old 03/24/2015, 19:35   #22


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
Quote:
Originally Posted by raptter View Post
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?
​Exo is offline  
Old 03/24/2015, 19:41   #23
 
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
Quote:
Originally Posted by Exo View Post
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
raptter is offline  
Old 03/24/2015, 20:00   #24


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
Give me your TV ID/PW -,-
​Exo is offline  
Thanks
1 User
Old 03/24/2015, 20:05   #25
 
elite*gold: 0
Join Date: Jan 2008
Posts: 79
Received Thanks: 8
Quote:
Originally Posted by Exo View Post
Give me your TV ID/PW -,-
add me on skype better

thank alot Exo <3
raptter is offline  
Old 03/29/2015, 13:13   #26
 
elite*gold: 0
Join Date: Mar 2015
Posts: 311
Received Thanks: 164
Good Job Exo
Gummieֆ' is offline  
Old 10/05/2015, 15:10   #27
 
Dev Microsoft's Avatar
 
elite*gold: 1
Join Date: Sep 2015
Posts: 413
Received Thanks: 264
thq man
keep it ip
Dev Microsoft is offline  
Old 10/06/2015, 12:27   #28
 
elite*gold: 36
Join Date: Mar 2010
Posts: 558
Received Thanks: 224
-good job
Laag#82 is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.