Search found 6315 matches

by AmigoJack
Fri Feb 23, 2024 3:15 pm
Forum: General Discussion
Topic: Anyone considering becoming a 3.0.x refugee?
Replies: 165
Views: 138423

Re: Anyone considering becoming a 3.0.x refugee?

Almost 2400 users not having posted once, but with a website filled into their profile, which is most likely a great SEO thing . The prime member has been away for 10 months and his posts aren't that professional/helpful either. I remember in 2015 Danielx64 and DionDesigns were members I talked to;...
by AmigoJack
Tue Feb 20, 2024 1:35 pm
Forum: [3.3.x] Support Forum
Topic: File count vs database table rows
Replies: 4
Views: 340

Re: File count vs database table rows

ProFTP which is the FTP service running on the server. . How do you know it's that particular software? Even selecting to download the files directory itself will fail to download all the files. Because the FTP client does nothing else than listing "all" the content of that folder, which ...
by AmigoJack
Tue Feb 20, 2024 1:28 pm
Forum: phpBB Custom Coding
Topic: SALT Value for creating Passwords
Replies: 5
Views: 587

Re: SALT Value for creating Passwords

new to this business For me this is too vague: does "this" mean phpBB? PHP? Passwords? Hashes? Programming in general? Databases? Conversions? So I have to draw the line somewhere and guess you'll reply when you're stuck with specific problems. I should even have the phpBB1 somewhere, so ...
by AmigoJack
Mon Feb 19, 2024 5:46 pm
Forum: [3.3.x] Support Forum
Topic: File count vs database table rows
Replies: 4
Views: 340

Re: File count vs database table rows

Is it possible that Filezilla is limiting how many files it displays Most likely the FTP server limits this. But never your FTP client. 7998 files (or entries in general) + 2 entries for the current ( . ) and the parent folder ( .. ) = 8000 is a perfect straight number coming from a setting. You ca...
by AmigoJack
Mon Feb 19, 2024 4:20 pm
Forum: phpBB Custom Coding
Topic: SALT Value for creating Passwords
Replies: 5
Views: 587

Re: SALT Value for creating Passwords

re-encrypting the passwords that were stored in plain text Neither is that "re"encryption, nor does phpBB encrypt password - it stores a hash of it, that's also where salt starts to make sense. Where can I read out the required SALT value? It differs per used algorithm (driver) and per us...
by AmigoJack
Sat Feb 17, 2024 10:27 pm
Forum: phpBB Custom Coding
Topic: If I update username thru sql, what tables would be affected ?
Replies: 14
Views: 874

Re: If I update username thru sql, what tables would be affected ?

My post here demonstrates that your username now resides in my post text, too. No it doesn't. Only the userid is there. That's also not true. And never has been. Otherwise I wouldn't be able to search for the keyword exemplary1 and get my own post as result . One doesn't quote with the username and...
by AmigoJack
Thu Feb 15, 2024 4:14 pm
Forum: phpBB Custom Coding
Topic: If I update username thru sql, what tables would be affected ?
Replies: 14
Views: 874

Re: If I update username thru sql, what tables would be affected ?

Are updating username & username_clean in table phpbb_users enough ? My post here demonstrates that your username now resides in my post text, too. Would you now consider that by far much more columns/tables would need to be addressed? When doing it per ACP, phpBB executes mostly \includes\func...
by AmigoJack
Mon Jan 29, 2024 10:48 am
Forum: [3.3.x] Support Forum
Topic: How to remove password confirmation input?
Replies: 1
Views: 249

Re: How to remove password confirmation input?

Are you sure you want your preference to force on everyone else? Also keep in mind that the registration is not the only place where the password needs to be given twice - are you sure you still want it only on the registration?
by AmigoJack
Thu Jan 04, 2024 2:13 am
Forum: phpBB Custom Coding
Topic: Modifying quotes in MySQL and "re-submitting" the posts
Replies: 6
Views: 1258

Re: Modifying quotes in MySQL and "re-submitting" the posts

you need to use a regex That should be: UPDATE phpbb_posts SET post_text= REGEXP_REPLACE ( post_text , '\\[quote="([^"]+)" [^\\]]+\\]' -- capturing the username, match all quotes that have more than only a username , '[quote="\\1"]' -- substitute previously captured usernam...
by AmigoJack
Fri Dec 22, 2023 11:09 pm
Forum: phpBB Discussion
Topic: Who is running MySQL 8?
Replies: 10
Views: 2101

Re: Who is running MySQL 8?

Guys, you mix up server and client: nd is " native driver ", and i is " improved " - both are just clients=drivers whose version is unbound to the version of the actual running DBMS. ACP > System > General Tasks > PHP information lists all modules active with PHP, thus only SQL c...
by AmigoJack
Mon Dec 18, 2023 12:19 pm
Forum: phpBB Custom Coding
Topic: PHP script to execute custom MYSQL commands on PHPBB db?
Replies: 6
Views: 1628

Re: PHP script to execute custom MYSQL commands on PHPBB db?

returning no error though This can't be true, as you ended a string literal and then 127.0.0.1 unexpectingly comes after that, being no valid PHP code. How did you conclude no error was yielded? The code should properly escape apostrophes, not globalize variables which are global already, not copy ...
by AmigoJack
Sun Nov 12, 2023 9:29 pm
Forum: phpBB Discussion
Topic: .heic support
Replies: 7
Views: 4187

Re: .heic support

Embedding animated HEIC: http://nokiatech.github.io/heif/content/image_sequences/starfield_animation.heic Embedding still HEIC: https://github.com/tigranbs/test-heic-images/raw/master/image1.heic Embedding animated AVIFS: https://github.com/link-u/avif-sample-images/raw/master/star-10bpc.avifs Embe...
by AmigoJack
Mon Oct 23, 2023 8:54 am
Forum: General Discussion
Topic: Finding location of ip address
Replies: 10
Views: 4603

Re: Finding location of ip address

using an email ... how you'll detect? Oh, that's easy: since nowadays people are naive enough to always use browsers for reading/sending emails their true IP address can easily leak through WebRTC ( further explanation and test ), which is only one of multiple ways. sending emails from Public inter...
by AmigoJack
Sun Oct 22, 2023 8:34 am
Forum: General Discussion
Topic: Finding location of ip address
Replies: 10
Views: 4603

Re: Finding location of ip address

don't believe what you see on TV about how you can be traced by the IP you are using at any given time It's a different thing tho when police/government requires the ISP to hand out what they know - those certainly know when which IP address was assigned to which person paying for internet access m...
by AmigoJack
Sun Oct 22, 2023 12:18 am
Forum: General Discussion
Topic: Finding location of ip address
Replies: 10
Views: 4603

Re: Finding location of ip address

VPN SCORE: 100 PROXY SCORE: 94 THREAT SCORE: 21 TRUST SCORE: 28 Well, such assumptions happen when IP addresses are changed every 24 hours by your ISP (which has been common practice for 3+ decades already), but whoever calculates your score isn't aware of such facts: I'm made liable for what has b...

Go to advanced search