[Release]Usable sql scripts

[Svinseladden]

dev's in TMOS have collected/changed and edited alot of the stuff that's in here, and as a thanks to all that helped us under the way up we would like to release some of the ones we have to make our server work easyer/better.

and for credits well it's Elite i have no idea now who all that helped with this.. i found it with searching for about 6 month time before i started making the server and 2 years now running my own and changed them to so they work for us. + made some new..

so none named none forgot:-) all i can say is thanks all, hope some of them can help you all

forgot some :

select * from PS_GameData.dbo.Chars
where CharName= 'charname here'

select * from PS_UserData.dbo.Users_Master
where UserID= 'Userid here'

USE PS_UserData;
UPDATE Users_Master
SET Point = (Point + 10000) -- change how many points you want to add here
WHERE UserID = 'xxx' -- userid here in ''

Cleanup action log

delete
from PS_GameLog.dbo.ActionLog
where ActionTime <= getdate() - 30 -- this del Actionlog exept last 30 day's (change how you like it)

how many accounts and how many banned=

SELECT count(*) as 'NoOfAccounts'
FROM [PS_UserData].[dbo].[Users_Master]

select COUNT(*) as 'NoOfBannedIp'
from [PS_UserData].dbo.BannedIPs

[Hybrid~]

I think those scripts will be useful for ADM's and people who work on a new server... Like me xD
im working on a new server EP4 - 4.5

So thanks bro

[mustafatuzlu]

hi , What is the SQL LOGIN ID , PASS and URL ?

[Svinseladden]

you just open your sql and run them there. no url or User/pass for them. this is to be run directly in sql

[Rickicki77]

Thanks !

[thetruestarr1337]

any1 has a DP Query to give all Players DPs?

[abrasive]

Originally Posted by thetruestarr1337

any1 has a DP Query to give all Players DPs?

UPDATE PS_UserData.dbo.Users_Master SET Point = (Point + 1000) WHERE Point < (2147483647 - 1000);

[deadman2012]

Hello Im new to being an Admin I need some help with getting my server up and running... i go to the PSMServer patch and it goes to play then back to the pause ive put the Database in the database file on My D drive Im trying to figure out what I've done wrong or what the issue is Can someone help me my skype is fallenangelforever1 thanks

[TeddyBear94]

Originally Posted by deadman2012

Hello Im new to being an Admin I need some help with getting my server up and running... i go to the PSMServer patch and it goes to play then back to the pause ive put the Database in the database file on My D drive Im trying to figure out what I've done wrong or what the issue is Can someone help me my skype is fallenangelforever1 thanks

this is the totaly wrong place to ask ur question. furthermore this question got already answered million times. use the search engine of epvpers to find what u are looking for. IF u still didnt get further after searchign u can post a thread in shaiya privat section where u provide us ur loogs of ur server which will help to find the problem out.