Chars DB

08/15/2011 15:58 kacanga#1

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

Thanks for help.

08/15/2011 16:04 joins.dj#2

Use PS_GameData
SELECT [ServerID]
,[UserID]
,[UserUID]
,[CharID]
,[CharName]
,[New]
,[Del]
,[Slot]
,[Family]
,[Grow]
,[Hair]
,[Face]
,[Size]
,[Job]
,[Sex]
,[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

08/16/2011 02:07 JohnHeatz#3

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....

Code:

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:

Code:

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

08/16/2011 02:51 RebeccaBlack#4

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.

Code:

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. :)