[Release] Quirys to help a new GM

Page 1 of 2

07/03/2011 15:51 SafeBett#1

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

Code:

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

to reset all acc's to leave 0

Code:

UPDATE PS_UserData.dbo.Users_Master SET Leave = 0

to change a users p/w

Code:

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

to search actionlog for transactions to/from particular char

Code:

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

to search attatched accounts from a single IP

Code:

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

to ressurect a char by name

Code:

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

to bann all accounts from a single ip

Code:

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

to bann a single account

Code:

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

07/03/2011 21:01 [Admin]Snuggle#2

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

07/03/2011 21:05 JohnHeatz#3

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

07/04/2011 14:40 SafeBett#4

thanks guys,

i was very imbarassed to release :D

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

07/09/2011 12:17 SafeBett#5

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

07/19/2011 09:36 [GM]Recover#6

Bump well cause some of these are pretty good

08/05/2011 15:45 SafeBett#7

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

08/08/2011 15:45 [Dev]Ansem#8

Quote:

Originally Posted by SafeBett

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

agree'd :)

08/23/2011 08:19 ShaiyaForever14#9

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

08/23/2011 08:27 viper4513#10

Quote:

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

Simple as that

08/23/2011 22:24 JohnHeatz#11

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

05/16/2014 11:34 SafeBett#12

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

05/16/2014 12:44 MC Flip#13

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

05/16/2014 18:04 SafeBett#14

Quote:

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

05/16/2014 20:31 nubness#15

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.

Page 1 of 2