Register for your free account! | Forgot your password?

You last visited: Today at 01:41

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

 

[HELP] PINK STAR RESET KILL

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2017
Posts: 22
Received Thanks: 0
Unhappy [HELP] PINK STAR RESET KILL

Hi everyone
I want to correct the script and delete the tag name

Quote:
/*Sisteme de reset pvp rank*/


DECLARE @Tag1 varchar(30)
DECLARE @TagName varchar(30)
SET @Tag1 = (SELECT SUBSTRING(CharName, 5,30) FROM PS_GameData.dbo.Chars WHERE CharID = @CharID);
DECLARE @Tag2 varchar(30)
SET @Tag2 = (SELECT SUBSTRING(CharName, 6,30) FROM PS_GameData.dbo.Chars WHERE CharID = @CharID);
IF @ActionType = '108'
BEGIN
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 0)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[*]', TagID = 1
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE [email protected]
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 1)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[**]', TagID = 2
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET [email protected]+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.FriendChars
SET [email protected]+'[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.BanChars
SET [email protected]+ '[*]'
WHERE [email protected]
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 2)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[***]', TagID = 3
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE [email protected]
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 3)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, StatPoint = StatPoint + 100, TagName = '[****]', TagID = 4
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE [email protected]

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE [email protected]
END
END



Wa7dani is offline  
Old   #2
 
elite*gold: 0
Join Date: Apr 2009
Posts: 170
Received Thanks: 165
what you wan't on that script and also can you tell what you wan't?


arjulie is offline  
Old   #3
 
elite*gold: 0
Join Date: Apr 2017
Posts: 22
Received Thanks: 0
Quote:
Originally Posted by arjulie View Post
what you wan't on that script and also can you tell what you wan't?
i dont want tag name i mean this[*]
and sory for my languge
Wa7dani is offline  
Old   #4
 
elite*gold: 0
Join Date: Jun 2010
Posts: 409
Received Thanks: 153
so remove the *


killer2p is offline  
Old   #5

 
elite*gold: 120
Join Date: Mar 2013
Posts: 687
Received Thanks: 228
Why you ask for easy thinks like this?
You just can learn by doing. Make a copy of original file and then edit the files... when it donīt work or something is from use the old original file and try again. When you donīt able to do this. I help you.
.:Skrillex:. is offline  
Thanks
1 User
Old   #6
 
elite*gold: 0
Join Date: Apr 2017
Posts: 22
Received Thanks: 0
Quote:
Originally Posted by .:Skrillex:. View Post
Why you ask for easy thinks like this?
You just can learn by doing. Make a copy of original file and then edit the files... when it donīt work or something is from use the old original file and try again. When you donīt able to do this. I help you.
i know how to make this script work but i dont like tag name when someone get the friest reset will get[*] in his name , i do my best to edit but i failed
if you know how to edit this script and make it without tag just tell me , ty
and sorry for my languge
Wa7dani is offline  
Old   #7
 
elite*gold: 0
Join Date: Nov 2017
Posts: 44
Received Thanks: 15
Quote:
Originally Posted by Wa7dani View Post
i know how to make this script work but i dont like tag name
I checked script... it so easy....
instead of update charname (it show your name in game) dont change it...
[MXD]Takeshi is offline  
Thanks
1 User
Old   #8
 
elite*gold: 0
Join Date: Feb 2018
Posts: 8
Received Thanks: 3
lmao the script so easy
[DEV]Wandersson is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Apr 2017
Posts: 22
Received Thanks: 0
Quote:
Originally Posted by [DEV]Wandersson View Post
lmao the script so easy
i write new one , but thank you for help


Wa7dani is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[HELP] PINK STAR RESET KILL
hi every1 i want a script wich reset your pink star and put you a tag like and go up when do more than 1 reset and also had include give DP when...
5 Replies - Shaiya PServer Development
Biete Lieutenant General (Awm Pink Dual de Pink, Mauser hw usw..)
Hey Leute, biete hier meinen Na Acc. Suche dafür einen Na Acc. Paar Infos: Namecards : Snowman NameTag: 409 Tage Halloween NameTag: 211 Tage...
9 Replies - CrossFire Trading
[Trading] Suche Na acc mit m4 pink oder awm pink
Topic regelt , schreibt einfach euren skype namen rein und ich add euch dann und schick den link von meinem acc :)
2 Replies - CrossFire Trading
Crossfire NA, M1A1 Carbine, Dual PInk Uzi, Jackhammer H, Dual Pink DE...
Hallo, ich verkaufe meinen Crossfire NA Account! Und zwar bei Ebay! Ab heute ist der letzte Tag der Auktion und ich hoffe ihr bietet alle fleißig...
0 Replies - CrossFire Trading
WTT 90X Sorc With Pink PETS for high level MAGE or Knight. or with pink pet
I have a 90X Sorc in (GRACIA ). With Alot of Pink pEts to level to 99 easily. Full Relm. Low Profile. I want to trade it to a High level Mage or...
6 Replies - Archlord Trading



All times are GMT +2. The time now is 01:41.


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.