Server statistics, how many mages, HKs, warrs in each town

[chrissdegrece]

In the DB backup files released with the 219 files there is a table missing, that table is named "CharInfo"

The table is automatically updated by Accountserver so you don't have to do anything else, only create the table in your ASD database:

CREATE TABLE [dbo].[CharInfo](
	[AccountID] [char](21) NULL,
	[ServerIdx] [char](2) NULL,
	[CharName] [char](21) NULL,
	[CharType] [char](2) NULL,
	[Nation] [char](2) NULL,
	[default] [char](10) NULL
) ON [PRIMARY]

As you see, you will then be able to show in your server website how many ppl are in Temoz and how many in Quanato, how many of them are Mages,Archers,HKs,Warriors.

Enjoy!

P.S. The first time you create it, it's not going to update the existing users you already have in your server. You are going to have to do this by hand.
For every new user created, the table will be automatically updated.

[MentaL]

[onyourrisk]

Very well , liked this one :)

Thanks for share

[chrissdegrece]

Good, at least there is 1 who liked it :p

[onyourrisk]

Yeah as always i like innovative things by the way you tested this ? As i tried that with ep 3 AS and some older db back up it wasnt updating the info .

[chrissdegrece]

as I said will NOT work for OLD players. OLD players you have to add by hand

[cvrdheeraj]

as I said will NOT work for OLD players. OLD players you have to add by hand

Why not? Copy the first 2 rows of the Charac0 table and update them to the CharInfo. Each time they login, the CharInfo will get updated accordingly.

[chrissdegrece]

hehe, copy/paste is adding by hand, isn't it?

An "insert .... where not in ..." command would be equally efficient though ;)

[getdeepz]

Use this

INSERT INTO CharInfo(AccountId, CharName) SELECT c_sheadera, c_id FROM Charac0

[Mrgentle]

hmmm.........nice one