/    Sign up×
Community /Pin to ProfileBookmark

Private Message (PM) Store

Copy linkTweet thisAlerts:
Mar 14.2008

Hi,

I have downloaded the phpBB full package from [URL=”http://downloads.sourceforge.net/phpbb/phpBB-3.0.0.zip?download”]http://downloads.sourceforge.net/phpbb/phpBB-3.0.0.zip?download[/URL] and am intrigued to find out how the forum stores private messages sent by users, as if you view the “privmsgs” table contained in the database, it doesn’t contain the message entered?

Why is this, where is the message stored?

to post a comment
PHP

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@DysanauthorMar 15.2008 — Upon looking through the "phpbb_privmsgs" table, I found a "message_text" field, but all it contains is: [B][BLOB - 21 B][/B]

Where's the actual message kept? ?
Copy linkTweet thisAlerts:
@HuevoosMar 15.2008 — The actual message is there, stored as a binary large object that is 21bytes in size (so much for large&#8230?
Copy linkTweet thisAlerts:
@toenailsinMar 15.2008 — BLOB - Binary Large Object

if you go into one of the table rows, you should see the message.
Copy linkTweet thisAlerts:
@DysanauthorMar 15.2008 — Why not display it as normal text?

What is the row field used for?
×

Success!

Help @Dysan spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.15,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...