[HELP] PINK STAR RESET KILL

10/07/2016 16:27 AgustinWoW#1
hi every1
i want a script wich reset your pink star and put you a tag like [*1] 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.
10/07/2016 17:06 MC Flip#2
A Rebirth System.
Adding a tag automatically might be a bit difficult, unless you can somehow make an edit that would split character names into 2 parts, like BestFighter 1 where BestFighter is the character name and 1 the rebirth count in another collumn. So every time a character reaches 200.000 (or whatever is max on your server) kills, it will reset the killcount and execute "RebirthCount" +1, so that character would then be called BestFighter 2.

There might be a conflict with stat resets though, for example if a character reset back to 1 kill from 200.000 (or max), he would still only get the stat points for rank 1 instead of Max Rank + Rank 1. I believe that would have to be edited in ps_game.

I don't think there is such a script released, and a simple script wouldn't suffice since this would require ps_game edits for the character names and stat points, so you will have to create your own edits.

If I knew how, I would try to set it up as I described above. There could be a more efficient method though.
10/08/2016 01:48 beetols#3
If you do it by database doesn't seems hard, something like:
- add 2 columns in dbo.Chars named PinkRank, Original Name

- on usp.insertactionlog add on logout:
-if kill >= 200k update k1 = 0, PinkRank + 1 and Charname = originalname
-if charname = originalname update charname = '[*PinkRank ]+charname

- on usp.savecharname and usp.createchar add originalname = charname

and if you get till here, you can even make a custom vet manager that works on relog removing the one in game.
10/08/2016 09:00 momocruz#4
Credit not for me i take this script years ago here !!

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 >= 200000 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 MasterCharID=@CharID

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

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 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 MasterName=@CharName+ '[*]'
WHERE MasterCharID=@CharID

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

UPDATE PS_GameData.dbo.BanChars
SET BanName=@CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 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 MasterCharID=@CharID

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

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 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 MasterCharID=@CharID

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

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
END
10/08/2016 16:41 AgustinWoW#5
the script that momocruz post here is the carlota script , using it i got error in sql :
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@ActionType".
Msg 137, Level 15, State 2, Line 9
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 13
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 20
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 24
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 28
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 31
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 38
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 42
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 46
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 53
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 57
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 60
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 64
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 68
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 72
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 75
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 79
Must declare the scalar variable "@UserUID".
Msg 137, Level 15, State 2, Line 82
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 86
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 90
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Line 94
Must declare the scalar variable "@CharName".
10/08/2016 19:59 beetols#6
Quote:
Originally Posted by AgustinWoW View Post
the script that momocruz post here is the carlota script , using it i got error in sql :
You must insert it inside PS_GameLog/programmability/storedprocedure/dbo.usp_Action_Log_e (before: SET @[Only registered and activated users can see links. Click Here To Register...] = N')