Content of post_text field in database

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders » Thu Oct 26, 2017 3:37 pm

Joshy,

I didn't say "it's none of your business" - I simply don't have an answer yet as to what the 'correct format' for the destination (another forum's database) is yet.

I'm not sure how knowing that would help you explain what phpBB does anyway....

User avatar
JoshyPHP
Code Contributor
Posts: 752
Joined: Mon Jul 11, 2011 12:28 am

Re: Content of post_text field in database

Post by JoshyPHP » Thu Oct 26, 2017 4:46 pm

radders wrote:
Thu Oct 26, 2017 3:35 pm
<!-- s:!: --><img src="{SMILIES_PATH}/icon_exclaim.gif" alt=":!:" title="Exclamation" /><!-- s:!: -->
That's from phpBB 3.1. There's a cron job in 3.2 that progressively converts those to XML. Alternatively, they can be converted all at once in CLI using the reparser module.
I wrote the thing that does the BBCodes in 3.2. Unless it broke yours, in which case it was somebody else with a similar name.

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 47974
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Content of post_text field in database

Post by stevemaury » Thu Oct 26, 2017 6:03 pm

No matter how much info you accumulate as to how that field is created, what you are trying to do will not work. You cannot successfully import just posts into another database.
For REALLY good and VERY inexpensive hosting CLICK HERE

All unsolicited PMs will be ignored.

User avatar
AmigoJack
Registered User
Posts: 4984
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Content of post_text field in database

Post by AmigoJack » Fri Oct 27, 2017 6:59 am

Why don't you just let all posts be output in HTML, so you have a format you know?
The worst thing about censorship is ███████████

radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders » Fri Oct 27, 2017 8:10 am

That's from phpBB 3.1
Apologies. I will re-post my question in the correct forum. Thanks for your time.
...import just posts...
Of course. I will need to import other tables too - but those ones are straightforward....

radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Content of post_text field in database

Post by radders » Fri Oct 27, 2017 8:17 am

Hello,
I need to ascertain exactly how the post_text field is constructed when a user adds an image, smilie, text formatting, etc.

This is because I need to extract all the existing posts, and add them to another forum's database.
I will need to modify/remove/replace the phpBB formatting of these artefacts,
so I need to understand exactly what formatting is being applied.

Please point me in the direction of the technical documentation for this,
or can someone explain them please?

Examples of phpBB format I am interested in include:

a colour:
[color=#0000BF:2p33qpi0]text[/color:2p33qpi0]

a smilie:
<!-- s:!: --><img src="{SMILIES_PATH}/icon_exclaim.gif" alt=":!:" title="Exclamation" /><!-- s:!: -->

a URL:
<!-- m --><a class="postlink" href="http://www.xxx.uk/frames/set_prod.htm"> ... rod.htm</a><!-- m -->

These seem quite complex to me - more so than other forums use.

What are the strings like:
<!-- s:!: --> and <!-- m --> and :2p33qpi0 for, and what other similar structures are there?

Thanks in advance. Dave R

User avatar
AmigoJack
Registered User
Posts: 4984
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Content of post_text field in database

Post by AmigoJack » Sat Oct 28, 2017 3:24 am

As I said. I also think you'll achieve nothing by just repeating what you already posted.
The worst thing about censorship is ███████████

User avatar
3Di
Registered User
Posts: 11864
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: Content of post_text field in database

Post by 3Di » Sat Oct 28, 2017 3:37 am

radders wrote:
Wed Oct 25, 2017 12:01 pm
Correct. I need to copy all the users' posts from the phpBB forum database,
and add them to another forum database.
I need to know how to handle the special encoding which phpBB uses for colours, smilies, etc.,
so that I can convert these into the correct equivalent in the destination database.
Vague, not enough data to work with in order to help you further. What's the other forum?
To handle in which manner, using C#, PHP, Assembler?
Usually that's a job a converter does, there is a plethora of converters from which you could take inspiration from and write your own. What you are trying to do leads to nowhere, to a failure and a waste of time for you and everybody else. That's why you are not getting the answer you are looking for iMO.

That's simply not the way the things work.
You my scrape the output as HTML, and - in fact - get the HTML as it is. That has been already told you as well. But the right way to make it working is a converter.
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades

radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders » Mon Oct 30, 2017 9:56 am

Vague, not enough data to work with in order to help you further
What is "vague" about "what does <!-- s:!: --> mean"? Nothing. It is a very specific and closed question.

Every answer I have received has either asked for irrelevant further info, or been dismissive saying it can't/won't work. Deflection and utter BS.

It WILL work - I'll make it work. It'll just take me a bit longer because I'll have to scan through thousands of posts looking for these strange strings, because you WILL NOT give the list of them.

I don't know why you are being so defensive about not revealing details. Protecting you IPRs?
So much for Open Source - you're worse than Microsoft at hiding information.

User avatar
JoshyPHP
Code Contributor
Posts: 752
Joined: Mon Jul 11, 2011 12:28 am

Re: Content of post_text field in database

Post by JoshyPHP » Mon Oct 30, 2017 10:33 am

You got it all wrong and you're approaching this topic with the worst attitude possible. Do you think people are hiding their secret intellectual property? Look at the file blame, most of that code was written 10 to 15 years ago and it's not even used in phpBB 3.2 anymore.

Do yourself a favor and just do the thing everybody told you to do: revert the parsed text to plain text and then do whatever you want to do with it. Nobody here even knows what you want to do with it.

Anyway, you don't have to reply to this post.
I wrote the thing that does the BBCodes in 3.2. Unless it broke yours, in which case it was somebody else with a similar name.

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7078
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Content of post_text field in database

Post by JimA » Tue Oct 31, 2017 10:08 am

radders wrote:
Mon Oct 30, 2017 9:56 am
I don't know why you are being so defensive about not revealing details. Protecting you IPRs?
So much for Open Source - you're worse than Microsoft at hiding information.
As Joshy pointed out, that's ridiculous. Just because something you asked for isn't readily available, doesn't mean people are intentionally trying not to help you or to hide information. What I see in this topic is people trying to understand you in order to help. Your attitude towards them certainly doesn't help. ;)

Now, some of the weird characters that you see, e.g. [color=#0000BF:2p33qpi0]text[/color:2p33qpi0]. That's called BBCode UID. Here are some useful links on why and how it is/was being used.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders » Wed Dec 06, 2017 10:16 am

Thanks JimA. Your links answered my question. That was all I wanted.
Nobody here even knows what you want to do with it
I think I stated my objective in the OP - I want to put the content of the phpBB posts* into another forum database.
So my question was around the formatting of those posts within phpBB.
Your attitude ... doesn't help
I apologise if I was a bit blunt, but was frustrated because nobody would answer my question.
JimA managed to, so I'm grateful to him for that.

*And users, topics, etc., obviously...

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 39 guests

cron