[WIP] Node.js UTStats Beta 9B

Discussions about UT99
User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 1

Post by UT Sniper (SJA94) » Tue Oct 08, 2019 3:20 pm

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.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 2

Post by UT Sniper (SJA94) » Wed Oct 09, 2019 7:44 pm

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

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 2

Post by UT Sniper (SJA94) » Tue Oct 22, 2019 4:23 am

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

User avatar
Gustavo6046
Inhuman
Posts: 831
Joined: Mon Jun 01, 2015 7:08 pm
Personal rank: Finite
Contact:

Re: [WIP] NodeUTStats Beta 2

Post by Gustavo6046 » Wed Oct 23, 2019 7:30 pm

Manage Monsters must be themed with the other icons.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 2

Post by UT Sniper (SJA94) » Thu Oct 24, 2019 4:01 am

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.

User avatar
Gustavo6046
Inhuman
Posts: 831
Joined: Mon Jun 01, 2015 7:08 pm
Personal rank: Finite
Contact:

Re: [WIP] NodeUTStats Beta 2

Post by Gustavo6046 » Thu Oct 24, 2019 4:22 pm

Eh, that's better! I'd add a skull, though.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 3

Post by UT Sniper (SJA94) » Fri Oct 25, 2019 10:51 am

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.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] NodeUTStats Beta 4

Post by UT Sniper (SJA94) » Sat Oct 26, 2019 2:29 pm

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

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] Node.js UTStats Beta 5

Post by UT Sniper (SJA94) » Tue Oct 29, 2019 4:48 pm

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.


User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] Node.js UTStats Beta 5

Post by UT Sniper (SJA94) » Sat Nov 02, 2019 4:33 pm

I've been improving the sites search functions:


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


Image

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] Node.js UTStats Beta 6

Post by UT Sniper (SJA94) » Mon Nov 04, 2019 3:56 pm

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.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

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

Post by UT Sniper (SJA94) » Tue Nov 05, 2019 7:57 pm

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.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

Re: [WIP] Node.js UTStats Beta 7

Post by UT Sniper (SJA94) » Fri Nov 08, 2019 9:43 pm

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.

User avatar
UT Sniper (SJA94)
Masterful
Posts: 512
Joined: Thu Jun 24, 2010 10:35 pm
Personal rank: noob programmer
Location: England

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

Post by UT Sniper (SJA94) » Sun Nov 10, 2019 3:08 am

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

User avatar
papercoffee
Godlike
Posts: 9399
Joined: Wed Jul 15, 2009 11:36 am
Personal rank: coffee addicted !!!
Location: Cologne, the city with the big cathedral.
Contact:

Re: [WIP] Node.js UTStats Beta 8

Post by papercoffee » Sun Nov 17, 2019 1:18 am

Image(⌐__⌐) someone is better in Food Fight then me...


:gj:

Post Reply