ADM ,GS,GM

01/27/2014 21:36 havenban#1

how i can make ADM GM or GS at name
this not work:admin:true,Admin lvl 255,status 16
i have only blue nick
... pls help

01/27/2014 22:02 Baby_Doll#2

change the name of the character in Ps_GameData.dbo.Chars ans simply set a [ADM] [GM] [GS] or whatever you want in front of the charactername.
That has to be done for every character on the GM account you want to give a tag.

01/27/2014 22:07 TeddyBear94#3

you can aswell take the easy way and just run an Sql script such as

Code:

Update Ps_GameDate.dbo.Chars
Set Charname = '[GM]XXX'
Where CharID = x

01/27/2014 23:11 havenban#4

ty <3

01/27/2014 23:12 nubness#5

Wrong section
Don't say thanks, just use the damn thanks button, thanks for reading. Thanks.

01/27/2014 23:20 Autrux#6

#moved

01/28/2014 11:58 AxelMac#7

Quote:
Originally Posted by TeddyBear94
you can aswell take the easy way and just run an Sql script such as
Code:
Update Ps_GameDate.dbo.Chars
Set Charname = '[GM]XXX'
Where CharID = x

maybe it's better to use this

Code:

UPDATE [PS_GameData].[dbo].[Chars]

SET CharName= '[ADM]XXX'
WHERE CharName= 'XXX'

01/28/2014 16:41 TeddyBear94#8

Quote:
Originally Posted by AxelMac
maybe it's better to use this
Code:
UPDATE [PS_GameData].[dbo].[Chars]

SET CharName= '[ADM]XXX'
WHERE CharName= 'XXX'

it not better nor worst it just depends on what you like/prefear

01/28/2014 16:50 nubness#9

It is better, you most likely have no idea what your CharID is, while everyone knows their CharName.

01/28/2014 18:31 nephren#10

CharID is Unique so it is better to use CharID.
Let anyone named the same with a point at the End or an I instead of a L.

However, it can be corrected so, well.
If you're too lazy to search for the CharID use the CharName.

01/28/2014 21:11 AxelMac#11

Quote:

Originally Posted by nephren

CharID is Unique so it is better to use CharID.
Let anyone named the same with a point at the End or an I instead of a L.

However, it can be corrected so, well.
If you're too lazy to search for the CharID use the CharName.

is about 50 players or more can happen that you do not know well charid but only by changing the old name, if you do not know you should enter the ID database to check if you know the name we do not need anything, just change the script putting the old name and the new one, it may happen that the old man is wrong, but it has never been used will give an error, if you are wrong ID we are going to completely change the name of someone who did not want to

01/29/2014 06:46 TeddyBear94#12

Quote:

Originally Posted by nephren

CharID is Unique so it is better to use CharID.
Let anyone named the same with a point at the End or an I instead of a L.

However, it can be corrected so, well.
If you're too lazy to search for the CharID use the CharName.

atleast some1 uses his brain^^

Quote:

Originally Posted by AxelMac

is about 50 players or more can happen that you do not know well charid but only by changing the old name, if you do not know you should enter the ID database to check if you know the name we do not need anything, just change the script putting the old name and the new one, it may happen that the old man is wrong, but it has never been used will give an error, if you are wrong ID we are going to completely change the name of someone who did not want to

it is better to not make any mistakes if your running a private server.
Mistakes like that makes you look stupid from the point of view of the players^^. So it is atleast in my eyes ( as i said everyone might prefear something different) a better way since you make sure your doing the right thing to the player ;)

01/29/2014 14:15 nubness#13

Teddy, tell me when was the last time you remembered all CharIDs on your server so you can smoothly write update queries. It's not that he uses his brain, it's that he's supporting your point of view. Now, if we have to develop the idea, let's make something like:

Code:

UPDATE PS_GameData.dbo.Chars
SET CharName = 'new charname'
WHERE CharName = 'name' AND Family = x and Job = y AND whatever other filter conditions to make sure you pick the right one.

01/29/2014 19:29 Baby_Doll#14

Imo you all shared your opinions & showed him few different ways he could use.
I don't think one is better or worse, it's just what way you prefear & how difficult the charname is in fact.

I don't think you need to go deeper into the "my way is better" "you say this because he say that" disscussion since 1. his question got answered & 2. you already poke each other more than enough ;)