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
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders »

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: 1288
Joined: Mon Jul 11, 2011 12:28 am

Re: Content of post_text field in database

Post by JoshyPHP »

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 library that handles markup in phpBB 3.2+.
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52768
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 »

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.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
AmigoJack
Registered User
Posts: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Content of post_text field in database

Post by AmigoJack »

Why don't you just let all posts be output in HTML, so you have a format you know?
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
radders
Registered User
Posts: 19
Joined: Tue Aug 22, 2017 2:35 pm

Re: Content of post_text field in database

Post by radders »

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 »

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: 6108
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: Content of post_text field in database

Post by AmigoJack »

As I said. I also think you'll achieve nothing by just repeating what you already posted.
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
  • "My reaction is not to everyone, especially to you." Raptiye, 2021-02-28
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Content of post_text field in database

Post by 3Di »

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.
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º 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 »

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: 1288
Joined: Mon Jul 11, 2011 12:28 am

Re: Content of post_text field in database

Post by JoshyPHP »

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 library that handles markup in phpBB 3.2+.
User avatar
JimA
Former Team Member
Posts: 7833
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 »

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.
Jim Mossing Holsteyn - Former 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 »

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...
Locked

Return to “[3.1.x] Support Forum”