Storing Data in DB

[=cipher=]

Hello,

I would like to know how would I create a script so that I can enter information in the ACP and then store into my DB and output it on another. Can someone help me with this?

[Thatbitextra]

viewtopic.php?p=33883&highlight=#33883

[=cipher=]

Ya I looked. Those KB Articles didnt help me really. Doesnt say anything that I am wanting. I want to be able go to the ACP, input information like a description or something on the Configuration Page then output it on another page that the public can see. Can someone tell me how I can do this or where I can find the information to do this please and thanks!

[Thatbitextra]

Read what pentapenguin wrote. All the information you need is in that post.

[pentapenguin]

Look at my Adjust Gzip Compression Level MOD.
It does exactly what you want so just tweak it.

[=cipher=]

Hey,

Thanks! This is most appreciated.

[=cipher=]

I got one question though... in your MOD you have:

INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_level', '9');

Well ... In mine, I wnat to have the "9" part to be a large paragraph of words and etc that html can be used in also so that that information entered is outputted on another page. How do I do that?

[pentapenguin]

Just replace the 9 with your HTML.
Make sure you add a backslash before any single quotes like \'

[=cipher=]

Hey,

Thanks! But, how do I change that "HTML" or "9" with in the database?

[=cipher=]

Hey,

I have another question, how am I suppose to recode this:

$new['gzip_level'] = preg_replace("#[^0-9]#", '9', $new['gzip_level']);

... What should mine be?

[UseLess]

Greetings,

A couple of things...

1. You can only store a maximum of 255 chars in the config table
2. You should use 'prepare_message' so it will be stored in the db correctly and 'unprepare_message' when you want to display it again.

So you should really create another table and then use a field type of 'text' if you want to store more than 255 characters.

[=cipher=]

Hey,

Yes I want to store more then 255 characters. Thanks! but ... what about this thing? $new['gzip_level'] = preg_replace("#[^0-9]#", '9', $new['gzip_level']);??

[UseLess]

Greetings,

As you have stated that you want to store more than 255 characters then you won't be using the config table and you can therefore ignore that as you won't be using the $new array. Your going to have to create the sql queries in order to store the data in the table you create.

[=cipher=]

Hey,

Would this be the proper SQL Syntax to use to create a table with longtext ??

CREATE TABLE phpbb_exbb_portal (welcome message LONGTEXT NOT NULL);

[UseLess]

Greetings,

Well have you tried it and did it work?

Or did you get a complaint about: welcome message not being in quotes and a space in the middle?

This is what you should have;

Code: Select all

CREATE TABLE `phpbb_exbb_portal` (
     `welcome_message` longtext NOT NULL
   );