Club Arnage

Club Arnage => General Discussion => Topic started by: DJet on October 03, 2025, 04:54:55 pm

Title: Forum software updated
Post by: DJet on October 03, 2025, 04:54:55 pm
Having done several (more than 5!) upgrades on a clone of this server in my virtual environment, I have just tried the same on the active server - and after a bit of unexpected issues, I believe the theme is now sort-of working.  Let me know if you think otherwise.

This is only the FIRST STEP - the next will be to migrate to my new(er) server, which is a major switch in both operating system and web service system - but then the forum softyware can be upgraded to the newest version.


DJet / Lennart Sorth, CAforum admin.
Title: Re: Forum software updated
Post by: adinsen on October 04, 2025, 03:47:40 pm
It's alive  :D
Title: Re: Forum software updated
Post by: DJet on October 04, 2025, 03:57:24 pm
It's alive  :D
It is indeed, and I just modified the stylesheet a little so the top bar looks more familiar.

Next step: The major move to a other server .... :-) 

Thanks for testing !

/L
Title: Re: Forum software updated
Post by: TobyAnscombe on October 04, 2025, 04:41:19 pm
Blimey. Even renders well on a phone!
Title: Re: Forum software updated
Post by: smokie on October 04, 2025, 07:04:41 pm
Looks fine to me, what's he eventual goal and purpose? Just updating software?
Title: Re: Forum software updated
Post by: smokie on October 04, 2025, 08:28:33 pm
DJet have you received a private message from me? If not, it's broken!
Title: Re: Forum software updated
Post by: DJet on October 05, 2025, 10:52:34 am
Looks fine to me, what's he eventual goal and purpose? Just updating software?

PM's indeed work :-)

Well, my last many years at work (I am now retired!!) I was awfully busy in great ways - but it meant I never felt I was on top of the forum software to an extent where I could update and fix any issues that almost inevitably comes along (themes etc)

So we were still running embarrassingly old software - and still are (!). This version 2.0.19 is the newest possible on the old OS on the server itself, but 2.0.19 is a LOT better securitywise than the 1.1.21 we were running up until now.

I have a much newer and much more powerful server installed in the datacentre, more or less ready to take over. This runs current OS and a brand new way of separating the websites (for security reasons).

I have two SMF forums (this and the www.matrasport.dk) on it, and 5-6 more static websites plus some email systems, but once I feel like taking the plunge, I will swap IP address of the servers.

Title: Re: Forum software updated
Post by: Kev_mk3 on October 05, 2025, 04:12:07 pm
Was a shock to log in and see all the changes. Several spam bots posted which ill report as I see them.
Title: Re: Forum software updated
Post by: smokie on October 05, 2025, 09:01:28 pm
Yeah thanks Kev, we had a sudden influx of new registrations which must have been bottled up in the old version. I've deleted the accounts but keep reporting if more turn up.

DJet, can we implement two step registration where an application needs to be approved by a mod? Would help with our compliance with the new UK Online Safety Act also.
Title: Re: Forum software updated
Post by: Kev_mk3 on October 06, 2025, 03:52:25 pm
No problem here to help
Title: Re: Forum software updated
Post by: DJet on October 08, 2025, 10:18:37 am
DJet, can we implement two step registration where an application needs to be approved by a mod? Would help with our compliance with the new UK Online Safety Act also.

oh yes we can - in fact that’s how my Matrasport.dk/forum has always run - but it obviously puts more load on you moderators.

Also, the last few years the server has lost its email forwarder, without which it requires admin logging in and checking (rather than receiving an email)

For matrasport I *do* get emails, but that’s because it lives inside the same server - I don’t think the old server can send emails as it is - though I thought I saw evidence of this new version somehow overcoming that. Do you receive emails from the forum when PM’s arrive or similar ?

I prefer completing the switch to the (much) newer physical server and get the email sorted there, before we change the registration stuff. That will also put us on the newest SMF version, where dealing with the newest legislation is easier.

/Djet (aka Lennart)
Title: Re: Forum software updated
Post by: Bob U on October 08, 2025, 03:55:08 pm
DJet, can we implement two step registration where an application needs to be approved by a mod?

Ha ha. In retrospect would you have approved some of the drunken reprobates you had the pleasure/misfortune of meeting over the years?
Title: Re: Forum software updated
Post by: DJet on October 13, 2025, 11:37:45 am
DJet, can we implement two step registration where an application needs to be approved by a mod?

Ha ha. In retrospect would you have approved some of the drunken reprobates you had the pleasure/misfortune of meeting over the years?

Certainly - though as this old server still has problems sending emails, it means admins  will have to keep looking for new members and approve as required.

We also used to have a couple of benign questions that requires knowing what Club Arnage is about, which had been cleared by the upgrade.

I have thus re-established them - and new members musty answer right to two of the three:

How many hours does the event run for ?
In which country does the event happen ?
What’s the name of the event city ?

I think that keeps a fair bit of automated spam-bots away.

/Lennart

Title: Re: Forum software updated
Post by: DJet on October 16, 2025, 06:15:16 pm
IP test
Title: Re: Forum software updated
Post by: DJet on October 16, 2025, 06:17:45 pm
Yay - I modified Sources/Load.php to force the code to use HTTP_X_FORWARDED_FOR rather than REMOTE_ADDR, which seems to have fixed the logged IP address on posts at least.

There is still a QueryString.php file which has many places I could do the same, but it doesn't seem to be required for what we need.

Lets see if new registrations gets logged with a real IP rather than 127.0.0.1
Title: Re: Forum software updated
Post by: DJet on October 16, 2025, 06:35:07 pm
Lets see if new registrations gets logged with a real IP rather than 127.0.0.1

YEP,  new registrations gets logged with their correct IP now (I registered a user named "IP test" - checked the IP was logged, then I approved it, and deleted it)

Title: Re: Forum software updated
Post by: smokie on October 27, 2025, 08:45:46 pm
Thanks, that is all a vast improvement from a mods point of view, and along with Dave's revised T&Cs helps us comply with the new Act.

Thanks for your work on this.
Title: Re: Forum software updated
Post by: DJet on October 28, 2025, 12:59:37 am
ok, by cross-referencing the Apache log, with the varnish (proxy/cache) enormous log, I have updated the IP address of the user registrations that got listed as 127.0.0.1 (until I patched the SMF files).

That means now we can at least see where they came from in admin/members.

There are a number og Russian and Middle-East ones - to save you the lookup, I include the table here (you need a wide screen):

id    username            email                           IP(wrong)  Date-of-registration       real-IP            whois-info
4259  Claude-roand        claude.francoise@ggmail.website 127.0.0.1  Oct 13, 2025, 02:08:19 pm  95.221.198.192     Net By Net Holding LLC, Moscow, Russia
4258  Keithtaply          66@woldex.online                127.0.0.1  Oct 13, 2025, 08:46:05 am  91.84.115.213      SERVERS TECH FZCO, Ifza Business Park, Dubai
4257  Jaimenuddy          e1qrq1q1wr2qq1d@gmail.com       127.0.0.1  Oct 13, 2025, 07:09:11 am  31.130.137.252     LLC "AVANTA TELECOM", Russia
4256  Arthuroxift         salesx19@iartun.com             127.0.0.1  Oct 13, 2025, 02:47:55 am  185.247.184.90     GLOBAL INTERNET SOLUTIONS LLC, Russia
4255  Azerea              a@xelo.pro                      127.0.0.1  Oct 12, 2025, 10:38:37 pm  88.97.246.218      YouFibre, London, UK
4254  AnthonysBup         olga.grigor070797@gmail.com     127.0.0.1  Oct 12, 2025, 04:17:57 pm  192.109.138.145    RIPE, NL ...
4253  Romatriag           gasiogarit@gmail.com            127.0.0.1  Oct 12, 2025, 01:29:46 pm  109.107.186.56     SERVERS TECH FZCO, Ifza Business Park, Dubai
4252  PhillipCic          adv25@aolimo.com                127.0.0.1  Oct 12, 2025, 09:09:00 am  91.228.155.80      Fornex Hosting, Estepona, Spain
4251  123bzIply           123bv9@123bv1.it.com            127.0.0.1  Oct 12, 2025, 04:02:56 am  45.117.164.56      IRT-VNNIC-AP, Ha Noi, VietNam
4250  123bJoync           123bv9@123bv2.it.com            127.0.0.1  Oct 12, 2025, 01:44:52 am  103.151.53.189     IRT-VNNIC-AP, Ha Noi, VietNam
4249  123bEnelp           123bv7@123bv1.it.com            127.0.0.1  Oct 12, 2025, 01:23:07 am  103.188.242.81     IRT-VNNIC-AP, Ha Noi, VietNam
4248  BrianBut            mrtommyk@gmail.com              127.0.0.1  Oct 12, 2025, 12:14:22 am  5.143.41.95        PJSC Rostelecom, Russia
4247  TimothyRix          xrujujikis@anonmails.de         127.0.0.1  Oct 11, 2025, 12:05:49 pm  5.196.78.175       OVH SAS, Roubaix, France
4246  Williamanise        nikita356314@gmail.com          127.0.0.1  Oct 11, 2025, 08:39:01 am  46.8.221.114       Contel OOO, Bazhova, Moscow, 129128, Russia
4245  CharlesExone        ha.luongkim95@gmail.com         127.0.0.1  Oct 11, 2025, 08:00:41 am  192.73.244.36      NetActuate, Inc, Raleigh, NC
4244  muzxyz              dvfkpqulq@zvezdaforum.ru        127.0.0.1  Oct 10, 2025, 09:28:41 pm  188.130.211.102    Biterika Group LLC, Russia, Moscow
4243  ShopforMib          ejwfmfcc@cetakexpress.com       127.0.0.1  Oct 10, 2025, 07:20:53 pm  150.136.58.182     Oracle Corporation, Austin, TX
4242  xrbyjwbbm           bms@brandshield.com             127.0.0.1  Oct 10, 2025, 05:05:02 pm  194.62.55.202      SiberDC, Kavacik Mah. Fatih Sultan Mehmet Cad, TL
4241  evichepic           zarahsmallive64235o@ctive.org   127.0.0.1  Oct 10, 2025, 04:24:18 pm  158.173.3.3        RIPE, NL ...
4240  Louisreant          okna.master.vitebsk@gmail.com   127.0.0.1  Oct 10, 2025, 10:45:00 am  45.88.106.84       RIPE, NL ...
4239  Holographicomi      irishpolevaultmonkey@gmail.com  127.0.0.1  Oct 10, 2025, 09:47:36 am  98.188.47.132      Cox Comms, Atlanta, US
4238  Passneinc           gugloff.444@gmail.com           127.0.0.1  Oct 10, 2025, 02:18:13 am  146.103.106.124    RIPE, NL ...
4237  Independentvsa      michael.flynn@davispolk.com     127.0.0.1  Oct 10, 2025, 02:15:02 am  72.214.108.67      Cox Comms, Atlanta, US
4236  123bNig             123bv4@123bv2.it.com            127.0.0.1  Oct 10, 2025, 01:33:35 am  45.117.164.30      ODS Joint Stock Co, Ho Chi Minh city, Vietnam
4235  Artkameraru_Kib     building.sal.e.sru@gmail.com    127.0.0.1  Oct 09, 2025, 03:05:54 pm  95.27.42.178       CORBINA TELECOM Network Operations, Russia
4234  Josephdiste         adv@iartun.com                  127.0.0.1  Oct 09, 2025, 11:26:14 am  5.253.31.94        GEOHOSTING-NOC, Buharest, Romania
4233  NAERTREGE1187604NEWETREWT zaojhaxi@tubermail.com    127.0.0.1  Oct 09, 2025, 07:42:52 am  165.231.182.14     N I Team, Johannesburg, South Africa
4232  krakenruss          yourmnui8ail@gmail.com          127.0.0.1  Oct 09, 2025, 07:42:45 am  46.28.234.124      EUROHOSTER Ltd, 8000, Burgas, BULGARIA
4231  Awinroadads         wirople@igredan.fun             127.0.0.1  Oct 08, 2025, 11:10:11 pm  37.139.53.214      Kupriyanov Pavel Nikolaevich, Russia
4230  Normandjak          yourmail344@gmail.com           127.0.0.1  Oct 08, 2025, 05:45:18 pm  128.90.145.4       Unus Inc, Austin, TX, 78703, US
4229  Alfredpar           dser5857@gmail.com              127.0.0.1  Oct 08, 2025, 04:12:02 pm  192.73.244.36      NetActuate Inc, NC, 27605, US
4228  RichardVep          work777top@gmail.com            127.0.0.1  Oct 08, 2025, 02:06:37 pm  135.181.79.90      RIPE Network Coordination Centre (RIPE)
4227  123blouBy           123bv1@123bv2.it.com            127.0.0.1  Oct 08, 2025, 01:38:24 pm  103.188.242.20     BAO LONG MANAGEMENT CONSULTANT, Ha Noi, VietNam
4226  AlexanderNus        lev26971@gmail.com              127.0.0.1  Oct 08, 2025, 12:58:34 pm  212.192.55.206     193091 St.Petersburg Russia


My gut feeling is that most of these can be deleted - as they all occurred in a flush, just around the upgrade time, but I will let the moderators have a look.

/Lennart

Title: Re: Forum software updated
Post by: DJet on November 02, 2025, 03:40:41 pm
also, - I have updated the phrasing of that annoying database error you sometimes get at login (which just require you to reload your browser tab to continue) - so it now actually says so:

Before:
   The database value you're trying to insert does not exist: p_member_ip

now at least :
   The database value you're trying to insert does not exist: p_member_ip - please just reload your browser tab to continue

This will go away when we get to the newest forum version. I have had a look, but it seems too difficult to fix the error in this version, and also somewhat waste of time as we will soon get on the new version.