VSP Not Showing Up

[Fragenstein]

E+ is v2.3. I have another issue. The main url for my VSP stats site defaults to the directory instead of the stats:
https://vsp.servegame.com/

[Krillin]

E+ is v2.3. I have another issue. The main url for my VSP stats site defaults to the directory instead of the stats:
https://vsp.servegame.com/

Bro, a few things here. You did not read the ReadME. You are not supposed to FTP the entire contents of VSP_v1.0.51 to your website for viewing, you put the core on your site where YOU know it is if you need to run VSP via a Web Browser.

If you will note in the README, no where will you see a single word mentioning XAMPP, WAMPP, etc in ANY document of VSP for a reason. I used to use them for DEVELOPMENT of VSP. But for the past few years I have been using my Windows Server 2022 DataCenter setup.

If you are running the WEB VSP on your site then you put these files in a folder, for instance "vspstats", then in your browser you open yourwebsite.site/vspstats/vsp.php (you need to call vsp.php as it is NOT index.php), and you will see the web interface of VSP (as seen from your website below). But for public viewing you only need to send the content of the vsp-core_v1.0.51\pub\ to the root of where ever vsp.servegame.com is located.

The vsp.servegame.com indicates a subdomain, so I am not sure of this exact setup. I do this because vsp.krillinsworld.com pointed to my web server where I hosted my VSP Player Stats. This was also where I was working and hosting the latest version of VSP I was working on. And because of this, I had a handful of subdomains hosted here, so using the vhost.conf in my Apache wasn't pretty.

In your case, all I did was click on the vsp.php (THIS IS THE WEB INTERFACE):


Hope this clears up the https://krillinsworld.com/vsp/docs/ReadME.php RTFM LOL
I am looking over the README document, it is NOT confusing, this is close to the original. There was (maybe still is) a statement in there saying "Read these instructions once, twice, three, or four times OR MORE until you understand them 100% completely." Maybe it is time to modernize it?

For shits and giggles, I opened your /pub/ folder (if you noticed there IS an index.php file in there). BUT XAMP BRO? Not recommended for production, these are strictly used for DEVELOPMENT.


-Krillin

P.S. I located an old Q3A/TA server when we were on windows. In side there was an "excessive" folder. I click into it and opened description.txt. It was EP V004 from 3-1-04. I went and got the newest 2.3 created a folder "excessive2" and pasted the contents from the zip file. I played single player really quickly, but the log file did not look anything like the one you submitted (perhaps from this is a client version?) I will try a dedicated server one here and compare;

...loaded 1942 faces, 113 meshes, 42 trisurfs, 0 flares
^3WARNING: could not find sound/player/announce/^1Kr^7ill^4in.wav - using default
CL_InitCGame:  1.32 seconds
6 msec to draw all images
Com_TouchMemory: 0 msec
^1[^722^1:^747^1]^7
^1[^722^1:^747^1]^7 ^1> ^7Excessive Plus v2.3
^1[^722^1:^747^1]^7 ^1> ^7www^3.^7excessiveplus^3.^7net
^1[^722^1:^747^1]^7
^1[^722^1:^747^1]^7 ^3> ^7Running: Default Settings v2.3
^1[^722^1:^747^1]^7
^1[^722^1:^747^1]^7 Ranger^s entered the game.
^1[^722^1:^747^1]^7 Ranger^7^s was gunned down by ^1Kr^7ill^4in^7^s.
^1[^722^1:^747^1]^7 Ranger^7^s blew himself up.
^1[^722^1:^747^1]^7 [0^7] Ranger^s:^2 In a blaze of glory! Oh, hell, at least it is a blaze.
^1[^722^1:^748^1]^7 ^1Kr^7ill^4in^7^s was melted by Ranger^7^s's plasmagun.
^1[^722^1:^749^1]^7 ^1Kr^7ill^4in^7^s almost dodged Ranger^7^s's rocket.
^1[^722^1:^749^1]^7 [0^7] Ranger^s:^2 Let me guess, Krillin. That was a headshot.
^1[^722^1:^749^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^750^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^750^1]^7 ^1Kr^7ill^4in^7^s was melted by Ranger^7^s's plasmagun.
^1[^722^1:^750^1]^7 Ranger^7^s ^3has a kill streak of ^15^3!
^1[^722^1:^750^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^751^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^751^1]^7 ^1Kr^7ill^4in^7^s almost dodged Ranger^7^s's rocket.
^1[^722^1:^751^1]^7 [0^7] Ranger^s:^2 You almost got it right, maggot.
^1[^722^1:^751^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^752^1]^7 Ranger^7^s almost dodged ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^753^1]^7 Ranger^7^s ate ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^754^1]^7 [0^7] Ranger^s:^2 Okay, krillin, I'd salute you ... if I could find my head!
^1[^722^1:^754^1]^7 Ranger^7^s almost dodged ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^755^1]^7 Ranger^7^s ate ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^755^1]^7 Ranger^7^s ate ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^755^1]^7 ^1Kr^7ill^4in^7^s ^3has a kill streak of ^15^3!
^1[^722^1:^756^1]^7 ^1Kr^7ill^4in^7^s ate Ranger^7^s's rocket.
^1[^722^1:^756^1]^7 [0^7] Ranger^s:^2 You almost got it right, maggot.
^1[^722^1:^756^1]^7 Ranger^7^s ate ^1Kr^7ill^4in^7^s's rocket.
^1[^722^1:^757^1]^7 Ranger^s hit the fraglimit.
^1[^722^1:^757^1]^7 ^1Kr^7ill^4in^7^s was melted by Ranger^7^s's plasmagun.
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^3Statistics for ^1'^s^1Kr^7ill^4in^s^1'^7
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^1Kills Deaths Suicides   Time    Acc.    Eff. Score
^1[^722^1:^757^1]^7 [skipnotify]^3----- ------ -------- ------ ------- ------- -----
^1[^722^1:^757^1]^7 [skipnotify]    7     11        0   9:36  20.28%  38.89%     7
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^1Weapon     ^3: ^1Accrcy  Hits/Atts  Kills Deaths  Ammo
^1[^722^1:^757^1]^7 [skipnotify]^3----------- --------------------------------------
^1[^722^1:^757^1]^7 [skipnotify]Machinegun ^3:^s   0.0%     0/0         0      0   200
^1[^722^1:^757^1]^7 [skipnotify]Shotgun    ^3:^s  50.0%     3/6         1      0    64
^1[^722^1:^757^1]^7 [skipnotify]R.Launcher ^3:^s  27.6%    37/134       6      8   205
^1[^722^1:^757^1]^7 [skipnotify]Plasmagun  ^3:^s  12.3%    18/146       0      3   742
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^1Damage Given:^s 1731         ^1Armor  Taken:^s 425
^1[^722^1:^757^1]^7 [skipnotify]^1Damage Recvd:^s 2293         ^1Health Taken:^s 631
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^1Map:  ^7q3dm1
^1[^722^1:^757^1]^7 [skipnotify]^1Time: ^7Match complete
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [skipnotify]^1Name                 ^3: ^1Kll Dth Sui  Time  FPH Eff Score    DG    DR
^1[^722^1:^757^1]^7 [skipnotify]^3--------------------- ---------------------------------------------
^1[^722^1:^757^1]^7 [skipnotify]Ranger              ^s ^3:^s  12   8   0  9:34   75  60    10  2293  1731
^1[^722^1:^757^1]^7 [skipnotify]^1Kr^7ill^4in             ^s ^3:^s   7  11   0  9:36   44  39     7  1731  2293
^1[^722^1:^757^1]^7 [skipnotify]
^1[^722^1:^757^1]^7 [0^7] Ranger^s:^2 Quaker to base.q3dm1 is secured. Phase two can begin. Over.
Wrote screenshots/2024-10-14_22-57-05_q3dm1_---------krillin's-world-tdm.jpg
********************
ERROR: Disconnected from server
********************
----- Server Shutdown -----
==== ShutdownGame ====
AAS shutdown.
Closed log botlib.log
---------------------------

Yes, I lost, but I cannot play with a trackball mouse. But it brought back good memories from yesteryears.

[Fragenstein]

"You are not supposed to FTP the entire contents of VSP_v1.0.51 to your website for viewing, you put the core on your site where YOU know it is if you need to run VSP via a Web Browser."

There is NOTHING in the ReadME as to where the files go, creating a new folder (IE: vspstats) etc...

"3. VSP Setup
If you installed MySQL / MariaDB, PHP, Apache or another webserver or made any changes to your system configuration, its a good idea to reboot your system before you continue any further.

If you made changes to PHP just restart your webserver (Apache or IIS).

a. i) Download the VSP core zip file and extract it to a folder of your choice.

ii) Download the game media zip file that you want VSP to work with and extract to the same folder you chose in step (3a.i), overwriting existing files if necessary. If there is no media file for the game you are looking for, you can ignore this step.

If you care to contribute any media files for your MOD, you are more than welcome to e-mail me and I will be more than happy to help. As of right now we have the Default Media files once found with VSP. We welcome if anyone wants to custom the content of the Default Media Files with the custom content, we all welcome the contribution. Plus it makes the VSP look better than a 'default' layout.

b. Open up pub/configs/cfg-default.php file using a text editor and specify your hostname, database name, database username, password, and other preferences. Further description of what each setting in the cfg file mean, can be found in cfg-default.php itself. Before you start parsing the logs, you must make sure that you set the variable $cfg['game']['name'] in the config file properly. Read the comments above that variable in cfg-default.php"

[Krillin]

This should have been your first clue and there were a lot more clues thereafter:

Open up pub/configs/cfg-default.php
[...]
d. If you want to access your stats from the www, give public access to the pub/themes, pub/games and pub/images subfolder including its sub-directories using your webserver.
NOTE:- if you still get access problems try giving public access to the entire pub/ folder or what ever folder you placed the files from /pub/ folder on your website.

The default theme that VSP uses is pub/themes/bismarck/index.php the index.php is the main stats webpage. If no config file is specified, index.php reads cfg-default.php and uses the information in that to access the MySQL stats database. You can make several different php config files with different database settings and other preferences and tell index.php to read your preferences from the specified config file. All the config files should be put in the ../configs/ folder. (".." is the folder where you uploaded the web portion of the VSP files from the /pub/ folder.

ex: If you have a config file called cfg-myconfig.php with your preferences, then you can tell index.php to read from that config file by accessing:
themes/bismarck/index.php?config=cfg-myconfig.php

As the contents IN /pub/ are what need to be modified (mainly the /pub/configs/cfg-default.php before transferring the contents up to your web host. Like I said before, ReadME may needs to be rewritten to clarify. I have VSP v008 when I first started using VSP, so I will cross check them, but I am currently dealing with a whole can of worms with Q3A as it has gone untested for some time. I got the bugs worked out, but there are other problems with building the awards table, well, with assigning the playerID to the award specifically.. You would think it is a simple process, but it is not or maybe it is just me. I have been pouring over this code for the past 3 - 4 days.

Yeah, the directions I read so far are for setting up VSP on local computer. Section 3 does need some clarifying as I see a few details have been left out, as it is much simpler to setup on a webhost. But anyone with experience knows a folder with an "index.xxx" file is what is needed for serving for the public. I have this on my TODO list for the next release. But the documents are dynamic I will update when I need a break. :-)

Anyways, I am working on some serious issues with Q3A package. But I think I just found a problem with the characterset E+ is using, and writing to the logs is causing a problem. I just need to verify a few things and work them out. Back to work.

Also, check the F.A.Q.'s?

-Krillin

[Fragenstein]

Anyways, I am working on some serious issues with Q3A package. But I think I just found a problem with the characterset E+ is using, and writing to the logs is causing a problem. I just need to verify a few things and work them out. Back to work.

-Krillin

There were definitely problems with the character set and E+ with the version I'm currently using. Most of the issues are with the vsp-q3a.php file. I got it fixed with help from requinix @ php freaks.

[Krillin]

Once again, you are not using the Authentic VSP! And you are screwing up the character color's which is what all the ^n by commenting out the color array as that is what its purpose is for. Yes, i looked at your phpfreaks posts, though I found it interesting, I felt no need to make the changes you made as that is NOT an authentic VSP version, so there is no need to reference them here, but it did make an interesting and confusing reading.

With everything I am working on, and the mismatch of configured servers, the last issue being delt with is an issue generating the awards due to lack of accuracy tracking within quake 3 arena. I see your logs have something in them, but cannot determine how they got there as my log does not have this though we are using E+ 2.3. So I am unsure where to go at this point as I have spent countless hours in as many days in as many weeks trying to figure this issue out. Your server logs have TELEFRAGS in them from the item Holdable Teleport (teleport is disabled on my servers, but fixed) and there are "UNKNOWN" kills in your log files playing havoc with an Authentic VSP. Otherwise, it is working 100% perfectly (see the attached image below). The issue just appears to be with YOUR log file, as I generated a few myself, ran the Authentic VSP against the log file, NO ERRORS? 

Can you send me the changed file(s) you think you corrected from your conflicted quake-3a-VSP? Sorry my files keep getting corrupted. I did manage to get the media files back for all Q3A mods, BTW. I have ran your logs so many times with the same database it was up to 360 MB of data until today, I emptied the database tonight is now 19.9MB, except the generated awards issue. There should be a fallback of some sorts. The more I fix, the more I wake up the code.  A bit of a domino effect.

One thing I will not compromise is my CS Player stats database as it is over 1 GB with 19-20 years of player stats. Don't think it is live right now. And some time next year I will be filing a DMCA takedown with github for violations of the license agreement as these guys are using VSP 0.45 core and they are in violation of the license agreement, I wrote to them, they refused, now it is time to play Mr. Badguy!

[Fragenstein]

PM'd you a link to the changed file.

[Krillin]

You will be happy to know, after getting to work on the issue with VSP™ Q3A issue. I have FINALLY got it working 100% error free with Q3A/TA server log files. I had a few of them laying around or recovered from 2008. Once I stopped using your log file, there wasn't any issues. There are an "UNKNOWN" kills in your log files and I cannot handle them as I do not know exactly what they are.

I will be releasing VSP-CORE-v1.1.52 as I just got it done about 3 hours ago, but I am not ready to release it yet  until I get it tested with ExcessivePlus 2.3. I am running a test server with E+ now with BOTS playing in to get a decent server log file. So, we will soon find out if VSP™ v1.1.52 will work, once again with Q3A with E+.