Limmek / MStats-for-rust

Logs player statistics and other server stuff to MySql
https://buymeacoffee.com/Limmek
5 stars 3 forks source link

Can you add one more functionality ? #16

Closed logistic94 closed 2 years ago

logistic94 commented 2 years ago

If possible, make a table with 2 fields, in which 2 values of the current online and time would be entered, with a frequency of 5 minutes, for example

logistic94 commented 2 years ago

And will be great if in player_kill table display player name, at now display only steam id. Thnx

Limmek commented 2 years ago

If possible, make a table with 2 fields, in which 2 values of the current online and time would be entered, with a frequency of 5 minutes, for example

This do exist in the table player_stats already. player_state 1 = online, 0 = offline and player_online_time = total minutes online

logistic94 commented 2 years ago

If possible, make a table with 2 fields, in which 2 values of the current online and time would be entered, with a frequency of 5 minutes, for example

This do exist in the table player_stats already. player_state 1 = online, 0 = offline and player_online_time = total minutes online

Yes, I understand, in principle, all the initial data is there to build such a table or graph, but my knowledge of C # will not allow me to combine these data) Nevertheless thank you

logistic94 commented 2 years ago

And will be great if in player_kill table display player name, at now display only steam id. Thnx

What about this ?

Limmek commented 2 years ago

I did just push a update. Removed EncodeNonAsciiCharacters since it was not used everywhere anyways and added player_name to the missing tables.

It's not tested so please report any error

logistic94 commented 2 years ago

I did just push a update. Removed EncodeNonAsciiCharacters since it was not used everywhere anyways and added player_name to the missing tables.

It's not tested so please report any error

okey im testing, and reporting you

logistic94 commented 2 years ago

I did just push a update. Removed EncodeNonAsciiCharacters since it was not used everywhere anyways and added player_name to the missing tables.

It's not tested so please report any error

all work correct, thnx you.

logistic94 commented 2 years ago

If possible, make a table with 2 fields, in which 2 values of the current online and time would be entered, with a frequency of 5 minutes, for example

This do exist in the table player_stats already. player_state 1 = online, 0 = offline and player_online_time = total minutes online

If you have time do this, i will be so happy. I see this like thiss

online_table | date_time 55 | 26.08.22.18:45 51 | 26.08.22.18:50 32 | 26.08.22.18:55

Limmek commented 2 years ago

If i get some time over this weekend i can add it for you. But since the data already exist you can easily handle this in the frontend when requesting the data. Do you work on a web page that displays the players info? I could provide some SQL query's for you if needed to point you in the right direction.

logistic94 commented 2 years ago

If i get some time over this weekend i can add it for you. But since the data already exist you can easily handle this in the frontend when requesting the data. Do you work on a web page that displays the players info? I could provide some SQL query's for you if needed to point you in the right direction.

I would be very grateful if you would add this. But in parallel, you can send me sql queries, I also need to study and try to do it. It’s just that I don’t understand how to display the current online, with a frequency of 10 minutes, if everyone has different times in the table, I just want to build an online graph on the server on my page.

logistic94 commented 2 years ago

i see some error image

logistic94 commented 2 years ago

another image image

Limmek commented 2 years ago

It should be corrected now. I am not home atm but pushed a update from my phone.

logistic94 commented 2 years ago

It should be corrected now. I am not home atm but pushed a update from my phone.

Сool, it reminded me a couple of years ago when I was pick up the company's server from my phone, at that time I was on a hike on top of a mountain

logistic94 commented 2 years ago

It should be corrected now. I am not home atm but pushed a update from my phone.

sorry but one more errro

image

Limmek commented 2 years ago

The error points me to this line as you can see the parameter @4 is removed. Can you try download the latest update again and reload the plugin.

logistic94 commented 2 years ago

The error points me to this line as you can see the parameter @4 is removed. Can you try download the latest update again and reload the plugin.

steel have error image image

Limmek commented 2 years ago

Now everything should work as attended :)

logistic94 commented 2 years ago

Now everything should work as attended :)

Yes, all work perfectly