Register for your free account! | Forgot your password?

You last visited: Today at 22:15

  • 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: 30
Received Thanks: 10
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 02/03/2018, 07:05   #2
 
elite*gold: 0
Join Date: Apr 2009
Posts: 189
Received Thanks: 171
what you wan't on that script and also can you tell what you wan't?


arjulie is offline  
Old 02/03/2018, 10:39   #3
 
elite*gold: 0
Join Date: Apr 2017
Posts: 30
Received Thanks: 10
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 02/04/2018, 01:27   #4
 
elite*gold: 0
Join Date: Jun 2010
Posts: 416
Received Thanks: 157
so remove the *


killer2p is offline  
Old 02/04/2018, 12:07   #5


 
elite*gold: 10
Join Date: Mar 2013
Posts: 724
Received Thanks: 276
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.
.:Unix:. is offline  
Thanks
1 User
Old 02/04/2018, 13:41   #6
 
elite*gold: 0
Join Date: Apr 2017
Posts: 30
Received Thanks: 10
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 02/04/2018, 14:07   #7
 
elite*gold: 0
Join Date: Nov 2017
Posts: 95
Received Thanks: 75
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 02/18/2018, 14:42   #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 02/18/2018, 19:24   #9
 
elite*gold: 0
Join Date: Apr 2017
Posts: 30
Received Thanks: 10
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



« [HELP]DC on enter world | İ need Raid Kill Share Script ? »

Similar Threads
[HELP] PINK STAR RESET KILL
10/08/2016 - Shaiya PServer Development - 5 Replies
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 make reset.I used Carlota´s script but doesnt work.
Biete Lieutenant General (Awm Pink Dual de Pink, Mauser hw usw..)
03/02/2014 - CrossFire Trading - 9 Replies
Hey Leute, biete hier meinen Na Acc. Suche dafür einen Na Acc. Paar Infos: Namecards : Snowman NameTag: 409 Tage Halloween NameTag: 211 Tage WCG 2013 NameTag: 687 Tage Chars: SWAT, OMOH, SAS , SIA, UNSF, SFG(Slaughter Ticket),Spop Waffen die nicht angezeigt werden: MG4, Criss Super V Tiger, Thompson VIP, Awm Pink
[Trading] Suche Na acc mit m4 pink oder awm pink
11/11/2013 - CrossFire Trading - 2 Replies
Topic regelt , schreibt einfach euren skype namen rein und ich add euch dann und schick den link von meinem acc :)
Crossfire NA, M1A1 Carbine, Dual PInk Uzi, Jackhammer H, Dual Pink DE...
04/12/2013 - CrossFire Trading - 0 Replies
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 mit :) Hier nochmal der Link. Auktionsende ist Samstag um ca 15 Uhr! Crossfire NA Account Viele ZP Waffen! Carbine u.v.m | eBay Viel Spaß beim mitbieten :)
WTT 90X Sorc With Pink PETS for high level MAGE or Knight. or with pink pet
01/31/2011 - Archlord Trading - 6 Replies
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 Knight in (GRACIA). Or decent level Mage or Knight with lots of pink pets. Or WTSell it.



All times are GMT +1. The time now is 22:15.


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.