[Release]Check Activity Of your server PvP/Farm

[SvHe]

Hi Epvp,

This will check the activity about your server with a date ( since ) and it will show :
[1]Accounts [ Will be active if the Player create a Character and play ]
[2]Staff [ * Check Tiny Script to get this work ]
[3]1-15 players [ Only Lv15 Players ]
[4]20-30 players [ Only Lv30 Players ]
[5]80 players [ Only Lv80 Players ]
[6]All Players [ All Levels ]
[7]all Kills [ Will only show 1x/kill ]
[8]Item Mall [ Only Item above 0DP ]
[9]Economy [ Transactions , Buy from Merchants ]


Open it with MSSQL , change Date and press 'Execute'

* U need this to get "Staff" Query to work :

Create new column Staff in [PS_UserData].[dbo].[Users_Master] :

ALTER TABLE [PS_UserData].[dbo].[Users_Master] 
ADD 	Staff int

Update all the Staff Accounts with the Staff column

UPDATE [PS_UserData].[dbo].[Users_Master]
SET Staff = 1
WHERE UserID = '[GS]A' or 
UserID = '[GMA]B' 
/* and so on */

Im new at SQL so dont judge me , i am still learning and i tought it was a usefull script for some servers because you can see what is going on and can change some things on your server,

SvHe

[Stureplan]

#Added to Index.