| blast007 | there's not a huge rush to support PHP 8, if that's what you're referring to. Debian 11 still gets official support until roughly July 2024, and then LTS support until roughly June 2026. | 00:12 |
|---|---|---|
| blast007 | Debian 12, which has PHP 8.2 right now, won't be released until at least July | 00:13 |
| TimRiker | true. changes should all be backwards compatible. might as well do them, no? | 00:13 |
| *** I_Died_Once <I_Died_Once!~I_Died_On@c-73-184-170-223.hsd1.ga.comcast.net> has quit IRC (Read error: Connection reset by peer) | 01:56 | |
| allejo | i'd really rather not go down the approach of making the main website not be static anymore. we can serve out own separate service that gets player stats and then we can embed those stats on the main website via javascript | 01:57 |
| *** I_Died_Once <I_Died_Once!~I_Died_On@c-73-184-170-223.hsd1.ga.comcast.net> has joined #bzflag | 02:00 | |
| *** Cobra_Fast_ is now away: vacant | 02:30 | |
| *** Cobra_Fast_ is back | 02:30 | |
| blast007 | agreed | 02:31 |
| blast007 | or even just *not* embedding it on the main site | 02:32 |
| *** Cobra_Fast_ is now away: vacant | 02:59 | |
| *** Cobra_Fast_ is back | 02:59 | |
| TimRiker | What's been the experience with the old live site vs the current static site? | 03:32 |
| blast007 | static sites are considerably less CPU/memory intensive to serve | 03:37 |
| TimRiker | agreed. they are also less engaging. | 03:40 |
| allejo | the main website is 99% informational. any other applications should be developed stand alone and separate. ideally avoiding a giant monolith | 03:40 |
| allejo | i do however feel like our websites should have a consistent look and feel, which is why I started an early attempt here https://github.com/BZFlag-Dev/style-guide but never had the opportunity to continue it | 03:41 |
| TimRiker | are the extra tables needed for bzfls listed anywhere? | 03:54 |
| TimRiker | server_advert_groups does not exist, and I'm not sure how to create it. | 04:13 |
| TimRiker | looks like I need servers and serverbans too. | 04:15 |
| blast007 | https://static.bzexcess.com/bzfls.sql | 04:15 |
| TimRiker | got it. thx. | 04:16 |
| TimRiker | CHARSET=latin1 ? really? | 04:16 |
| blast007 | as opposed to utf8mb4? | 04:20 |
| TimRiker | or anything that would accept non-latin1 usernames, yes. | 04:21 |
| blast007 | that game itself doesn't | 04:21 |
| TimRiker | but the forums do | 04:21 |
| TimRiker | the game should, but agreed, it does not, yet. | 04:21 |
| blast007 | the game shouldn't until there's better admin UI | 04:22 |
| TimRiker | probably also true. | 04:23 |
| TimRiker | also, using MyISAM on purpose? or should InnoDB work? | 04:25 |
| blast007 | these tables haven't changed since they were created | 04:25 |
| TimRiker | so it's my fault? :) probably is. | 04:26 |
| blast007 | MyISAM might have been less memory hungry as well, which was a problem on the old bzflag.bz server | 04:26 |
| blast007 | going forward, I'm planning to use Postgresql for new sites | 04:27 |
| TimRiker | phpBB had issues with postgresql last I looked. | 04:27 |
| blast007 | can't migrate phpBB to a new database program AFAIK | 04:28 |
| blast007 | I wouldn't necessarily keep phpBB though | 04:28 |
| TimRiker | utf8mb4_0900_ai_ci is probably what we should be using in MySQL. | 04:35 |
| TimRiker | is there a sql dump for images around? Not sure what to work on first, but I'd like to be able to see what we have. | 04:36 |
| blast007 | that uses sqlite | 04:37 |
| TimRiker | http://my.bzflag.org/listkeys/ should probably redirect to https | 04:37 |
| TimRiker | oh! will it create it's own db? | 04:37 |
| blast007 | yup | 04:37 |
| blast007 | my.bzflag.org itself will redirect to HTTPS once I flip that switch, which will kill off clients older than 2.4.4 and systems older than Vista | 04:38 |
| blast007 | here's an apache config snippet for the image site: https://static.bzexcess.com/images.apache.txt | 04:45 |
| TimRiker | why not just redirect the stuff that new clients and users use? Then again, what's the downside? are there older clients that still support the current servers? | 04:45 |
| blast007 | 2.4.0 and 2.4.2 still support the current servers | 04:47 |
| blast007 | but before 2.4.4 there were a lot of remotely exploitable bugs | 04:48 |
| TimRiker | I believe that. | 04:48 |
| TimRiker | page comes up, but with errors... https://images-dev.bzflag.org/ | 04:50 |
| TimRiker | create_function is no longer around in php 8 | 04:51 |
| blast007 | Smarty 2.x is designed for PHP 4 or 5 :) | 04:53 |
| TimRiker | yep. there are new releases, but the api has changed too. | 04:54 |
| blast007 | their 2->3 upgrade notes area 404 as well | 04:54 |
| blast007 | are a* | 04:54 |
| blast007 | Also note that I'm using MariaDB, not MySQL. I'm seeing mentions that utf8mb4_0900_ai_ci is only in MySQL. | 05:01 |
| TimRiker | ah. could be. Does maria have a generic text display and sort that handles utf8 4 byte values? | 05:02 |
| blast007 | https://dba.stackexchange.com/a/314442 | 05:03 |
| TimRiker | unicode_520_ci looks like the best at present for cross-vendor support. alas, not with other sql platforms... | 05:05 |
| TimRiker | I wonder what happens with non-ascii usernames manually entered in the config... | 05:11 |
| TimRiker | It seems to preserve my motto, though not display the non-ascii characters. | 05:12 |
| TimRiker | where is the source for the BZFlag Server Key Management ? I don't see it in bzflag-bzfls | 06:53 |
| TimRiker | ah https://github.com/BZFlag-Dev/bzflag-listkeymgr | 06:57 |
| TimRiker | looks like I can't commit to bzflag-bzfls | 07:21 |
| BZNotify | master @ bzflag-listkeymgr: timriker pushed 2 commits (https://github.com/BZFlag-Dev/bzflag-listkeymgr/compare/f97e61c6702f...991c71e17fac): | 07:24 |
| BZNotify | master @ bzflag-listkeymgr: timriker 59c490: unix (https://github.com/BZFlag-Dev/bzflag-listkeymgr/commit/59c4904f27c2b272817d22232969f1be02b57738) | 07:24 |
| BZNotify | master @ bzflag-listkeymgr: timriker 991c71: copyright (https://github.com/BZFlag-Dev/bzflag-listkeymgr/commit/991c71e17fac24b029f4ddd5e1f17ca8811cf9ea) | 07:24 |
| BZNotify | master @ bzflag-listkeymgr: timriker pushed 1 commit (https://github.com/BZFlag-Dev/bzflag-listkeymgr/compare/991c71e17fac...ab6a0b89ca78): | 07:35 |
| BZNotify | master @ bzflag-listkeymgr: timriker ab6a0b: use hostname instead of hard coding (https://github.com/BZFlag-Dev/bzflag-listkeymgr/commit/ab6a0b89ca788f5c871089e42ff31193642b5263) | 07:35 |
| *** Sgeo <Sgeo!~Sgeo@user/sgeo> has quit IRC (Read error: Connection reset by peer) | 07:54 | |
| *** I_Died_Once <I_Died_Once!~I_Died_On@c-73-184-170-223.hsd1.ga.comcast.net> has quit IRC (Ping timeout: 256 seconds) | 08:01 | |
| *** spldart <spldart!~spldart@2601:2c5:c600:8fc0:3210:b3ff:fef0:93af> has quit IRC (Ping timeout: 252 seconds) | 08:30 | |
| *** spldart <spldart!~spldart@2601:2c5:c600:8fc0:3210:b3ff:fef0:93af> has joined #bzflag | 08:43 | |
| *** blast007[m] <blast007[m]!~blast007m@2001:470:69fc:105::7ec> has quit IRC (Quit: You have been kicked for being idle) | 09:00 | |
| *** FastLizard4 is back | 09:02 | |
| *** FastLizard4 is now away: AWAY from keyboard | 10:55 | |
| *** FastLizard4 is now away: GONE - Screen Detached and Disconnected from IRC (I'm probably asleep, at work, or doing something in real life) | 11:15 | |
| blast007 | I fixed the access roles on the bzfls and submitimages repos | 11:32 |
| *** blast007[m] <blast007[m]!~blast007m@2001:470:69fc:105::7ec> has joined #bzflag | 11:32 | |
| *** I_Died_Once <I_Died_Once!~I_Died_On@c-73-184-170-223.hsd1.ga.comcast.net> has joined #bzflag | 14:23 | |
| *** Sgeo <Sgeo!~Sgeo@user/sgeo> has joined #bzflag | 15:15 | |
| *** blast007[m] <blast007[m]!~blast007m@2001:470:69fc:105::7ec> has quit IRC (Quit: You have been kicked for being idle) | 16:00 | |
| TimRiker | thanks! | 18:40 |
| *** blast007[m] <blast007[m]!~blast007m@2001:470:69fc:105::7ec> has joined #bzflag | 18:40 | |
| BZNotify | master @ bzflag-bzfls: timriker pushed 4 commits (https://github.com/BZFlag-Dev/bzflag-bzfls/compare/b5294608cda8...c2002235d70d): | 18:42 |
| BZNotify | master @ bzflag-bzfls: timriker dc26cc: copyrights, string {} to [] (https://github.com/BZFlag-Dev/bzflag-bzfls/commit/dc26ccde8929e5462b3bed4c55a4441d50740b68) | 18:42 |
| BZNotify | master @ bzflag-bzfls: timriker c785f2: unix (https://github.com/BZFlag-Dev/bzflag-bzfls/commit/c785f23352c532172eb3dd7c8ee3ae34d403bfbe) | 18:42 |
| BZNotify | master @ bzflag-bzfls: timriker eb5cad: copyrights (https://github.com/BZFlag-Dev/bzflag-bzfls/commit/eb5cad7e4cd57cc7fad3a6d71be055d53540a756) | 18:42 |
| BZNotify | master @ bzflag-bzfls: timriker c20022: mime types, json (https://github.com/BZFlag-Dev/bzflag-bzfls/commit/c2002235d70d128ca3b6ab8b9fcdf6199b08add5) | 18:42 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!