Server statistics, how many mages, HKs, warrs in each town
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:
Code:
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.
Re: Server statistics, how many mages, HKs, warrs in each town
Very well , liked this one :)
Thanks for share
Re: Server statistics, how many mages, HKs, warrs in each town
Good, at least there is 1 who liked it :p
Re: Server statistics, how many mages, HKs, warrs in each town
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 .
Re: Server statistics, how many mages, HKs, warrs in each town
as I said will NOT work for OLD players. OLD players you have to add by hand
Re: Server statistics, how many mages, HKs, warrs in each town
Quote:
Originally Posted by
chrissdegrece
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.
Re: Server statistics, how many mages, HKs, warrs in each town
hehe, copy/paste is adding by hand, isn't it?
An "insert .... where not in ..." command would be equally efficient though ;)
Re: Server statistics, how many mages, HKs, warrs in each town
Use this
INSERT INTO CharInfo(AccountId, CharName) SELECT c_sheadera, c_id FROM Charac0
Re: Server statistics, how many mages, HKs, warrs in each town