[Release] Quirys to help a new GM

[SafeBett]

Hi everyone,

i have been a GM a very long time, but i am not IT i am not a specialist or even good at database or servers in general.

I got sucked into this role by accident way back in the Euro days and its been a passion for even longer.

<3 Shaiya

This is a list of Quirys that are by far the most common needed for a GM, if one does not suit the task just follow the logical path and adjust to the result you require.

if i had these back in the day, my life would have been so much easier ^^

So here we go, my 1st ever release

To search a Char

SELECT * FROM ps_GameData.dbo.Chars
Where CharName like '%CharNameHere%'

to reset all acc's to leave 0

UPDATE PS_UserData.dbo.Users_Master SET Leave = 0

to change a users p/w

UPDATE PS_UserData.dbo.Users_Master set Pw = 'new p/w' WHERE UserID = 'loginhere'

to search actionlog for transactions to/from particular char

SELECT * FROM ps_Gamelog.dbo.ActionLog
Where CharID like '%idhere%'

to search attatched accounts from a single IP

SELECT * FROM ps_UserData.dbo.Users_Master
Where userIp like '%ip goes here%'

to ressurect a char by name

UPDATE PS_GameData.dbo.Chars set Del = '0' Where CharName = 'charnamehere'

to bann all accounts from a single ip

UPDATE PS_UserData.dbo.Users_Master set Status = -1 WHERE UserIp = 'ipgoeshere'

to bann a single account

UPDATE PS_UserData.dbo.Users_Master set Status = -1 WHERE UserUID = 'UserUIDhere'

Thanks go to Abrasive for being a good friend and mentor aswell as the Dev Team/social group for all the support and courage they give. ty guys n gals

I hope this helps the ppl that are starting and or testing a server at home.

Best Regards
Safe

[[Admin]Snuggle]

Yay a truly useful release
(We have been lacking those lately...)
Thank you Safe this is very useful to me
Saves a lot time lol

[JohnHeatz]

Really useful as Shadow said ^-----there a lot of people that has not knowledge on SQL are going to love this release

[SafeBett]

thanks guys,

i was very imbarassed to release

i was worried i was stepping on toe's or posting what has been done many times.

Thankyou for the confidence boost

if anyone has a question about why/how these work, PM me or it can i beleive be discussed here

Best regards
Safe

[SafeBett]

This is a bump, good information for new GMs here xD

[[GM]Recover]

Bump well cause some of these are pretty good

[SafeBett]

B:u:m this is still useful for new GMs xD

[[Dev]Ansem]

Originally Posted by SafeBett

B:u:m this is still useful for new GMs xD

agree'd

[ShaiyaForever14]

So , i just put those querys in SQL Manager , execute them and ... done ? O.o Sorry but i am new xD

[viper4513]

So , i just put those querys in SQL Manager , execute them and ... done

Simple as that

[JohnHeatz]

Yes, all you need is to type them, change the values you want/need to change and Execute the Query

[SafeBett]

Am i gonna get in trouble for bumping a necro post? even if the information is still pertinent to current and or new learning GMs/Admins?

Best Regards
Safe

[MC Flip]

Very useful querrys, but what is dead should remain dead.
This also goes for dead forum topics.

[SafeBett]

Originally Posted by MC Flip

Very useful querrys, but what is dead should remain dead.
This also goes for dead forum topics.

I guess you prefer i just re post it all, seems as you agree they are useful quirys?

not getting your point sorry

[nubness]

What's the point in posting the same thing again ?

These queries represent the very basics of SQL, and they are not dummy proof at all.
Just saying.