mysql server stats
#10

Quote:
Originally Posted by KinderClans
Посмотреть сообщение
That's how i wanna make it. I don't wanna use my accounts table for showing server stats.

That's why i made a separate serverstats table. I just need to fix that. Code is in the first post, any help is accepted.
Actual Server Stats are still better to do with SUM or COUNT wherever you can. Especially kills/deaths/connects/num. of accounts.
Not only is it much easier than creating a seperate table and keep the data in sync, it's also consistent and just a query. You can extend this system as you add new columns or saved data to the users table and just extend the query for retrieving them, instead of having a seperate system just for stats.

Admin Logs or Actions are a different thing.

But if you really want the server stats to be seperated for whatever reason, the error you have in your first post is caused by an empty table, or at least zero retrieved rows.

Quote:

(number of rows: '0')

Make sure the table isn't empty and test the query you try to execute in phpmyadmin.
Reply


Messages In This Thread
mysql server stats - by KinderClans - 20.09.2018, 13:23
Re: mysql server stats - by iLearner - 20.09.2018, 13:48
Re: mysql server stats - by KinderClans - 20.09.2018, 13:57
Re: mysql server stats - by NaS - 20.09.2018, 15:12
Re: mysql server stats - by KinderClans - 20.09.2018, 15:16
Re: mysql server stats - by NaS - 20.09.2018, 15:17
Re: mysql server stats - by KinderClans - 20.09.2018, 15:32
Re: mysql server stats - by ReD_HunTeR - 20.09.2018, 19:08
Re: mysql server stats - by KinderClans - 20.09.2018, 19:19
Re: mysql server stats - by NaS - 20.09.2018, 19:28

Forum Jump:


Users browsing this thread: 1 Guest(s)