Chars DB

[kacanga]

Is there a script or query for doing all Chars' loginstatus=0 at Chars DB.

Thanks for help.

[joins.dj]

Use PS_GameData
SELECT [ServerID]
,[UserID]
,[UserUID]
,[CharID]
,[CharName]
,[New]
,[Del]
,[Slot]
,[Family]
,[Grow]
,[Hair]
,[Face]
,[Size]
,[Job]
,[***]
,[Level]
,[StatPoint]
,[SkillPoint]
,[Str]
,[Dex]
,[Rec]
,[Int]
,[Luc]
,[Wis]
,[HP]
,[MP]
,[SP]
,[Map]
,[Dir]
,[Exp]
,[Money]
,[PosX]
,[PosY]
,[Posz]
,[Hg]
,[Vg]
,[Cg]
,[Og]
,[Ig]
,[K1]
,[K2]
,[K3]
,[K4]
,[KillLevel]
,[DeadLevel]
,[RegDate]
,[DeleteDate]
,[JoinDate]
,[LeaveDate]
,[RenameCnt]
,[OldCharName]
,[RemainTime]
,[LoginStatus]
FROM [PS_GameData].[dbo].[Chars] where [LoginStatus] = 0
GO
or
Use PS_GameData
SELECT *
FROM [PS_GameData].[dbo].[Chars] where [LoginStatus] = 0
GO

[JohnHeatz]

The "Go" isn't really needed on that command, and the best way is the second one you used, the first one is just a waste of time....

Use PS_GameData
Select * from dbo.Chars where LoginStatus = 0

Thats the whole query for it, unless you want it to show just some specific details, something like:

Use PS_GameData
Select CharName, Level, KillLevel, DeadLevel from dbo.Chars where LoginStatus = 0

Which would work to see all just that specific information about those toons

[RebeccaBlack]

The English of what you said wasn't that great. But from what I can tell myself, you said "do all characters login status", which to me, means "change all character's login status"

If that's true, then you need to update.

UPDATE PS_GameData.dbo.Chars SET LoginStatus=0

If you didn't mean it like I guessed it, then John is the person to listen to.