[HELP] PINK STAR RESET KILL

[AgustinWoW]

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.

[MC Flip]

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.

[beetols]

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.

[momocruz]

Credit not for me i take this script years ago here !!

/*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

[AgustinWoW]

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".

[beetols]

Originally Posted by AgustinWoW

the script that momocruz post here is the carlota script , using it i got error in sql :

 Spoiler

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".

You must insert it inside PS_GameLog/programmability/storedprocedure/dbo.usp_Action_Log_e (before: SET @ = N')