Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2022-07-21 16:50:18

tahanson43206
Member
Registered: 2020-01-07
Posts: 26

20220721 Help finding length of post before download

First, thanks again for assistance provided in the past!

We are continuing to work on cleanup of the FluxBB/MySql database.

Spammer created ID's have been salvaged and converted for use by members.

We've progressed to removing artifacts left over from a previous forum package. We've completed nearly 70K posts of 78K known to contain artifacts.

The process is automated, with manual oversight, when FluxBB objects to bbcode our authors back in 2002 tossed into the post.  Apparently the earlier forum let them pass, but FluxBB is not as forgiving.

The purpose of ** this ** post is to ask if there is a query a Mod can run that shows the length of a post. The automated process is packed with fail safe features, but there is a weak point.

If FluxBB is asked to deliver a post, it makes a good faith effort, but every now and then the post that shows up in the edit window is not complete.  Is there a query  a Mod can run to reveal how long that post was before the download request was issued?

We have the post ID to work with, and are using the query to fetch each post by ID.

Is there (?possibly?) a way to modify that query to show just the length?

Thanks!

To see the history of our little project, you're welcome to visit newmars.com/forums, and look at the Housekeeping topic.

(th)

Last edited by tahanson43206 (2022-07-21 16:51:30)

Offline

#2 2022-07-26 14:16:15

JamesDean2
New member
Registered: 2022-07-20
Posts: 4

Re: 20220721 Help finding length of post before download

for any of the MySQL versions:

SELECT LENGTH(FIELD_NAME) FROM TABLE_NAME

use

SELECT LEN(FIELD_NAME) FROM TABLE_NAME

for any of the MSSQL versions

If you post your existing SQL query, I can help you edit the query to include the LENGTH(FIELD_NAME) directly into the existing query so that it appears directly into the existing results, but it is NOT a good idea to run multiple quires within a function ( meaning, don't run a selection statement with an additional selection statement based on the results of the previous. )

Offline

#3 2022-08-11 13:34:59

tahanson43206
Member
Registered: 2020-01-07
Posts: 26

Re: 20220721 Help finding length of post before download

For JamesDean2 re #2

Thanks for your reply, and for the promising looking suggestion!

It will be interesting to see if this concept can be adapted at the moderator level.

I suspect that the moderator is limited to running "approved" queries, such as login.php, edit.php, misc.php,
index.php, userlist.php, search.php, register.php and the queries created by the forms on admin_users.php, admin_bans.php, admin_index.php and admin_reports.php

***
We are within a few days of completing the editing of 78,000 posts.  If I were ever asked to tackle something like this again, I would ask for a new query with the code you've suggested, but the webmaster has a lot more going on than just our forum.

For the record, in case anyone working on FluxBB happens to see this post, the challenge we've faced is to pull 78000 posts down using automation, edit them to remove artifacts from an earlier forum package, and replace them.  A weak point in the procedure is not knowing how long the original post was.  Data is occasionally lost in the transit between the FluxBB MySQL data base and the memory of the client PC where the editing is done.

An Admin (moderator) level query option to show the length of a post would be helpful, but the need for such a capability is so rare I can't imagine it would pass prioritization review.  Never-the-less, if ** I ** were a webmaster in this situation, I would probably have added the code you suggested.

Thanks again!

Reminder to all ... the code we've developed is "open source" and available to anyone who might have a similar problem.  I'd like to see it converted to other languages, although it runs reasonably well as is.

(th)

Offline

Board footer

Powered by FluxBB