Page 6 of 6

Re: [WIP] NodeUTStats Beta 1

Posted: Tue Oct 08, 2019 3:20 pm
by UT Sniper (SJA94)
Qwerty wrote:
Mon Oct 07, 2019 10:31 pm
UT Sniper (SJA94) wrote:
Sun Oct 06, 2019 7:16 pm
Qwerty wrote:
Sun Oct 06, 2019 6:49 pm
damn i don't have access to my servers windows login to perform the other installs :(
This does work on Linux as well.
any instructions on how to fully install? lets say on a VDS or shared hosted servers?
I updated the first post a bit, hopefully its a bit clearer on how this project works.

On my Raspberry PI it was:

MYSQL
- Enter this command into the terminal to install mysql: sudo apt-get install mysql-server
- Enter <sudo> mysql into terminal to access mysql.
- Then enter this into the terminal to change the root username and password UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';
Note: You only have to install this for the website module, the server modules connect to the website module that has the database.


Node.js
- Enter this command into the terminal to install Node.js sudo apt-get install nodejs

All the database stuff is created via the node install.js script in the server module, I tried to make it as simple as possible to install you won't need to use a mysql app to setup all the tables, you just have to change the mysql variables in the config.js to connect to right database.




EDIT

I have made a zip of all the required packages minus the utstats package(don't want to step on anyones toes) for easier installation:

Node UTStats Beta 1

I have also updated the first post with the link and some other stuff.

Re: [WIP] NodeUTStats Beta 2

Posted: Wed Oct 09, 2019 7:44 pm
by UT Sniper (SJA94)
New build available: NodeUTStats Beta 2

Make sure to change the username and password for the website module
Upgrading from beta build 1:
- The only package that has changed is the website module so there is no need to replace the other packages, or reinstall the databases.

Change Log:

- Added views counter to match pages.
- Added views counter to profile pages.
- Updated the style so data is easier to read.
- Changed the DM scoreboard so it is the same order as in-game.

Image
Image

Re: [WIP] NodeUTStats Beta 2

Posted: Tue Oct 22, 2019 4:23 am
by UT Sniper (SJA94)
Been adding support to query a list of servers every X minutes, then save the results to a database.

(Map images haven't been added yet):

Image

Re: [WIP] NodeUTStats Beta 2

Posted: Wed Oct 23, 2019 7:30 pm
by Gustavo6046
Manage Monsters must be themed with the other icons.

Re: [WIP] NodeUTStats Beta 2

Posted: Thu Oct 24, 2019 4:01 am
by UT Sniper (SJA94)
Gustavo6046 wrote:
Wed Oct 23, 2019 7:30 pm
Manage Monsters must be themed with the other icons.
Image


You reminded me to update the monster page, forgot to iterate through the json data so people don't need 100 different images for slightly different monsters.

Re: [WIP] NodeUTStats Beta 2

Posted: Thu Oct 24, 2019 4:22 pm
by Gustavo6046
Eh, that's better! I'd add a skull, though.

Re: [WIP] NodeUTStats Beta 3

Posted: Fri Oct 25, 2019 10:51 am
by UT Sniper (SJA94)
Added pickup summary to match pages:
Image



Build 3 released:

https://drive.google.com/open?id=1G6zj3 ... EQCDPUq_Lh
- Build 3 release notes:

- Added UT server queries, you can now specify a number of ut servers you want to query every X minutes.
These will then be displayed on the homepage displaying the map image, current player count, server ip:port, and when the server was last queried.
Servers that use a dynamic dns will still work without problem whenever the server ip changes, and the correct ip:port will be displayed.

- Added a new admin area for managing ut server queries.

- Fixed monster file image status in admin area.

- Added pickups data to match pages, this displays every single weapon, ammo, and powerups for every player.

- Added site hits counter at the bottom of the home page.

Re: [WIP] NodeUTStats Beta 4

Posted: Sat Oct 26, 2019 2:29 pm
by UT Sniper (SJA94)
Build 4 released:
- Build 4 release notes:

- Added player connection events to match pages.
- Added last import time at bottom of home page.
https://drive.google.com/open?id=1knc-V ... IOMB1J31-e

Re: [WIP] Node.js UTStats Beta 5

Posted: Tue Oct 29, 2019 4:48 pm
by UT Sniper (SJA94)
Build 5b released:

Download: https://drive.google.com/file/d/17IsgIi ... sp=sharing
- Build 5 release notes:

- Fixed crash if a server is added to the query list if the server address is not a valid ip or address (Website).
- Added reimport script, if you upgrade to a new build(that requires a new database) and want to import all previous logs imported, you can
use the command "node reimport" to import all valid logs from ../Logs/imported/ (Server).

- Build 4 release notes:

- Added player connection events to match pages.
- Added last import time at bottom of home page.


- Build 3 release notes:

- Added UT server queries, you can now specify a number of ut servers you want to query every X minutes.
These will then be displayed on the homepage displaying the map image, current player count, server ip:port, and when the server was last queried.
Servers that use a dynamic dns will still work without problem whenever the server ip changes, and the correct ip:port will be displayed.

- Added a new admin area for managing ut server queries.

- Fixed monster file image status in admin area.

- Added pickups data to match pages, this displays every single weapon, ammo, and powerups for every player.

- Added site hits counter at the bottom of the home page.


- Build 2 release notes

Upgrading from beta build 1:
- The only package that has changed is the website module so there is no need to replace the other packages, or reinstall the databases.

- Added views counter to match pages.
- Added views counter to profile pages.
- Updated the style so data is easier to read.
- Changed the DM scoreboard so it is the same order as in-game.


Re: [WIP] Node.js UTStats Beta 5

Posted: Sat Nov 02, 2019 4:33 pm
by UT Sniper (SJA94)
I've been improving the sites search functions:


You can now search Map name, map title, and map authors.
Image


Image

Re: [WIP] Node.js UTStats Beta 6

Posted: Mon Nov 04, 2019 3:56 pm
by UT Sniper (SJA94)
Build 6 released:

Download here: https://drive.google.com/file/d/1Vch0ac ... sp=sharing
- Build 6 release notes(04/11/19):

- Added order types to player searches, you can now order by total matches, total time, last seen, and name. This includes ASC and DESC order.
- Fixed searches not returning more that the first page or data for player searches.
- Added more options to map search, you can now search for map name, map title, and map author. You can order the search by map name, map title, map author, total matches, total playtime, last match, and first match in ASC and DESC order.
- Updated style of map search page.
- Updated style of map page.
- Updated style of player search page.
- Updated style of player profile pages.
- Updated the colours for teams throughout the site.
- Added mouse over event for every flag image that displays the country name.
- Fixed client side javascript accessed null on match page.

Re: [WIP] Node.js UTStats Beta 6B

Posted: Tue Nov 05, 2019 7:57 pm
by UT Sniper (SJA94)
Build 6B released:

Fixes problems installing on Linux because I'm an idiot and put "require('Promise')" instead of "require('promise')" in two files... :sad2:

Download here:
- Build 6b release notes(05/11/19):

- Fixed "Can't find package Promise" even when it was installed.
- Fixed crash when no UT Servers are set to be queried.


---------edit----------------

Build 6C released:

Download: xxxxx
- Build 6c release notes(05/11/19):

- Fixed match import if killer is empty in log.


--------------edit------------

Build 6D released:

Download: https://drive.google.com/file/d/1QIaI07 ... sp=sharing
- Build 6d release notes(06/11/19):

- Fixed broken flag image links on Linux machines.

Re: [WIP] Node.js UTStats Beta 7

Posted: Fri Nov 08, 2019 9:43 pm
by UT Sniper (SJA94)
Build 7C released:

Download: https://drive.google.com/file/d/1EklsrN ... sp=sharing
- Build 7c release notes(09/11/19):

- Fixed installer script.

- Build 7b release notes(08/11/19):

- Fixed logic error for inserting kills into the database.

- Build 7 release notes(08/11/19):

- Fixed broken flag image links on rankings, records, and match pages.
- Added view image option to admin area for map images.
- Added view image option to admin area for monster images.
- Added face images to admin faces area.
- Added users can now connect directly to a utserver by clicking the server ip link on a server box on the homepage.
- Fixed country flag size on rankings page.
- Fixed country flag size and position on match frag performance area.
- Fixed country flag size and position on match Multi kills and sprees area.
- Fixed country flag size and position on match weapon stats area.
- Fixed country flag size and position on match ranking change area.
- Fixed country flag size and position on match connections area.
- Fixed country flag size and position on match kills match up area.
- Fixed country flag size and position on player search page.
- Fixed country flag size and position on records main page.
- Updated recent match boxes to include the server name (Every page).
- Fixed text overflow on gametype boxes on player pages.
- Updated the style of match pickups.

Re: [WIP] Node.js UTStats Beta 7B

Posted: Sun Nov 10, 2019 3:08 am
by UT Sniper (SJA94)
Next build has support for nexgen stats viewer:

Image
Image




----------------- EDIT ----------------------


Build 8 Released:

https://drive.google.com/file/d/10JbNwG ... sp=sharing
- Build 8 release notes(10/11/19):

- Added Nexgen Stats Viewer support.
- Made the mutator log a random face texture if PlayerReplicationInfo.TalkTexture == None

Re: [WIP] Node.js UTStats Beta 8

Posted: Sun Nov 17, 2019 1:18 am
by papercoffee
Image(⌐__⌐) someone is better in Food Fight then me...


:gj: