Static Pages

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
User avatar
MattF
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5175
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: Static Pages

Post by MattF »

venki4560 wrote:hi plz help me. i just instaled this mod. :D .but tell me hw can i create a static page. where do i need to go. hw will i get the link to that page? :D plz help. i stuck :oops:
Finish the instructions:

1. Go to ACP :: System :: Modules (Administration Control Panel)
2. Click the .MODs category and create a module category under it named ACP_PAGES
3. From the drop-down box select the Manage Pages module - add it and enable it
4. Now just go over to the MODs tab to see your new module.
Formerly known as VSEMy ExtensionsPlease do not PM me for support.
venki4560
Registered User
Posts: 9
Joined: Fri Aug 14, 2009 3:42 pm

Re: Static Pages

Post by venki4560 »

but i cannot found manage pages in drop down box
frantic
Registered User
Posts: 2
Joined: Thu Aug 20, 2009 7:11 pm

Re: Static Pages

Post by frantic »

first let me say what a great mod. so simple yet so effective. My question is that i have primetime portal and it comes with its own custom pages mod. It makes edits to the same php_pages table and uses the ACP_PAGES module thing in the drop down menu. When installed togther primetime always overtakes the static pages mod. Like i'll go into the .mod thing and primetime custom pages will be their instead of static pages. Is their anyways i can get it were static pages will work with primetime installed? Problem is primetime is the only portal that will do what i need it to. But this is mod is so great that i was wondering if their was a workaround so they don't interfer with each other.
coogs
Registered User
Posts: 117
Joined: Wed Jul 01, 2009 5:21 pm

Re: Static Pages

Post by coogs »

coogs wrote:Hi

After did everything exactly told in the install file
I add the module in ACP

When i click on PAGE CREATOR tab
I got this error

SQL ERROR [ mysqli ]

Table 'bpro_deepak.PAGES_TABLE' doesn't exist [1146]

SQL

SELECT p.page_id, p.page_title, p.page_desc, p.page_author, p.page_display, p.page_url, u.username, u.user_colour FROM PAGES_TABLE p, phpbb_users u WHERE u.user_id = p.page_author ORDER BY p.page_order ASC, p.page_id ASC

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_pages.php
LINE: 284
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_pages->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


Please help

Can you help me on this please
frantic
Registered User
Posts: 2
Joined: Thu Aug 20, 2009 7:11 pm

Re: Static Pages

Post by frantic »

venki4560 wrote:but i cannot found manage pages in drop down box

its in the middle, read carefully, its their. You can always try to reinstall and try again if you don't see it.
gkazanci
Registered User
Posts: 43
Joined: Sun Oct 07, 2007 1:04 pm

Re: Static Pages

Post by gkazanci »

Hi,

As shown in the link there, it is necessary to do to make multiple pages. So at the bottom of a page with the scroll buttons can be advanced as a_1 and a_2 want to do something.

http://www.phpbb.com/community/viewtopi ... #p10369415
User avatar
imkingdavid
Former Team Member
Posts: 2672
Joined: Sun Jul 26, 2009 7:59 pm
Location: EST
Name: David King

Re: Static Pages

Post by imkingdavid »

frantic wrote:first let me say what a great mod. so simple yet so effective. My question is that i have primetime portal and it comes with its own custom pages mod. It makes edits to the same php_pages table and uses the ACP_PAGES module thing in the drop down menu. When installed togther primetime always overtakes the static pages mod. Like i'll go into the .mod thing and primetime custom pages will be their instead of static pages. Is their anyways i can get it were static pages will work with primetime installed? Problem is primetime is the only portal that will do what i need it to. But this is mod is so great that i was wondering if their was a workaround so they don't interfer with each other.
I answered this on the Primetime support website, but I'll go ahead and answer it here to in case someone else has this issue.

I had the same problem and because I didn't have enough time to fix it, I just uninstalled this MOD because, tbh, Primetime is higher on my list of important MODs (and it has its own page function, even though I like this one better).

However, the fix can't be too hard. Theoretically, it would be to: (this is more indepth than I posted on the primetime site, now that I think about it):
1) Uninstall Static Pages
2) Before installing, change the instructions for creating the DB table to make it create a table called phpbb_static_pages instead of phpbb_pages
3) When editing constants.php (I think that's the right one), instead of making "define('PAGES_TABLE', 'phpbb_pages');" make it say "define('STATIC_PAGES_TABLE', 'phpbb_static_pages');".
4) Any time any of the Static Pages MOD files or edits calls PAGES_TABLE, change it to STATIC_PAGES_TABLE.
5) To change the ACP Module, in the Static Pages language file, find ACP_PAGES and change it to ACP_STATIC_PAGES.
6) Now, when adding the Module to the ACP, instead of inserting ACP_PAGES, insert ACP_STATIC_PAGES.
7) IF any of the files (such as "page.php") are the same, alter the file name and then any time it's linked in any of the files, change it accordingly. (I don't think this was an issue, but if it is it could take a lot of work to fix. :|)

That should solve your compatibility issue, but I haven't tested it so it would be best to first try it on a test server (install primetime, make these changes to the install files/instructions, and then install Static Pages) and see if it works well together.

I'll update my post on the Primetime site and with this more detailed help. :)
Don't forget to smile today. :)
Please do NOT contact for support via PM or email.
User avatar
kber
Registered User
Posts: 986
Joined: Sun May 07, 2006 9:22 am
Location: Egypt
Contact:

Re: Static Pages

Post by kber »

coogs wrote:
coogs wrote:Hi

After did everything exactly told in the install file
I add the module in ACP

When i click on PAGE CREATOR tab
I got this error

SQL ERROR [ mysqli ]

Table 'bpro_deepak.PAGES_TABLE' doesn't exist [1146]

SQL

SELECT p.page_id, p.page_title, p.page_desc, p.page_author, p.page_display, p.page_url, u.username, u.user_colour FROM PAGES_TABLE p, phpbb_users u WHERE u.user_id = p.page_author ORDER BY p.page_order ASC, p.page_id ASC

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_pages.php
LINE: 284
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_pages->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


Please help

Can you help me on this please
this sql is fot phpbb_ prefix if your database got another name , you have to change it
Hello All
coogs
Registered User
Posts: 117
Joined: Wed Jul 01, 2009 5:21 pm

Re: Static Pages

Post by coogs »

kber wrote:
coogs wrote:
coogs wrote:Hi

After did everything exactly told in the install file
I add the module in ACP

When i click on PAGE CREATOR tab
I got this error

SQL ERROR [ mysqli ]

Table 'bpro_deepak.PAGES_TABLE' doesn't exist [1146]

SQL

SELECT p.page_id, p.page_title, p.page_desc, p.page_author, p.page_display, p.page_url, u.username, u.user_colour FROM PAGES_TABLE p, phpbb_users u WHERE u.user_id = p.page_author ORDER BY p.page_order ASC, p.page_id ASC

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_pages.php
LINE: 284
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_pages->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


Please help

Can you help me on this please
this sql is fot phpbb_ prefix if your database got another name , you have to change it
Can you tell me exactly what i need to change
Please tell me step by step instruction
User avatar
kber
Registered User
Posts: 986
Joined: Sun May 07, 2006 9:22 am
Location: Egypt
Contact:

Re: Static Pages

Post by kber »

in the sql , change

Code: Select all

CREATE TABLE phpbb_pages
to

Code: Select all

CREATE TABLE bpro_deepak_pages
Hello All
User avatar
spaceace
Registered User
Posts: 1985
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: Static Pages

Post by spaceace »

this should be default in phpbb3 :D

super easy install and works perfectly :D
coogs
Registered User
Posts: 117
Joined: Wed Jul 01, 2009 5:21 pm

Re: Static Pages

Post by coogs »

kber wrote:in the sql , change

Code: Select all

CREATE TABLE phpbb_pages
to

Code: Select all

CREATE TABLE bpro_deepak_pages

should i uninstall first installation and install it again as you said ?
User avatar
kber
Registered User
Posts: 986
Joined: Sun May 07, 2006 9:22 am
Location: Egypt
Contact:

Re: Static Pages

Post by kber »

coogs wrote:
kber wrote:in the sql , change

Code: Select all

CREATE TABLE phpbb_pages
to

Code: Select all

CREATE TABLE bpro_deepak_pages

should i uninstall first installation and install it again as you said ?
no . just drop the phpbb_pages table
Hello All
coogs
Registered User
Posts: 117
Joined: Wed Jul 01, 2009 5:21 pm

Re: Static Pages

Post by coogs »

kber wrote:
coogs wrote:
kber wrote:in the sql , change

Code: Select all

CREATE TABLE phpbb_pages
to

Code: Select all

CREATE TABLE bpro_deepak_pages

should i uninstall first installation and install it again as you said ?
no . just drop the phpbb_pages table

As you said i dropped the table phpbb_pages in PhpMyadmin

Than i went ot ACP and Under Page Creator

I found this error

Code: Select all

SQL ERROR [ mysqli ]

Table 'bpro_deepak.PAGES_TABLE' doesn't exist [1146]

SQL

SELECT p.page_id, p.page_title, p.page_desc, p.page_author, p.page_display, p.page_url, u.username, u.user_colour FROM PAGES_TABLE p, phpbb_users u WHERE u.user_id = p.page_author ORDER BY p.page_order ASC, p.page_id ASC

BACKTRACE


FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_pages.php
LINE: 284
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_pages->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Please help again

i think this code need to be entered in my database (below code) which is given in mod

Code: Select all

CREATE TABLE phpbb_pages (
  page_id int(11) unsigned NOT NULL auto_increment,
  page_title varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  page_desc mediumtext character set utf8 collate utf8_bin NOT NULL,
  page_content mediumtext character set utf8 collate utf8_bin NOT NULL,
  page_url varchar(255) character set utf8 collate utf8_bin NOT NULL,
  bbcode_uid varchar(8) character set utf8 collate utf8_bin NOT NULL,
  bbcode_bitfield varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  page_time int(11) unsigned NOT NULL default '0',
  page_order int(11) unsigned NOT NULL default '0',
  page_display tinyint(1) unsigned NOT NULL default '0',
  page_display_guests tinyint(1) unsigned NOT NULL default '0',
  page_author mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (page_id)
);
If am i right how to insert this

Please look at both codes and help me where i am stuck

Thanks a lot in advance
User avatar
kber
Registered User
Posts: 986
Joined: Sun May 07, 2006 9:22 am
Location: Egypt
Contact:

Re: Static Pages

Post by kber »

Enter this in your database

Code: Select all

    CREATE TABLE bpro_deepak_pages(
      page_id int(11) unsigned NOT NULL auto_increment,
      page_title varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
      page_desc mediumtext character set utf8 collate utf8_bin NOT NULL,
      page_content mediumtext character set utf8 collate utf8_bin NOT NULL,
      page_url varchar(255) character set utf8 collate utf8_bin NOT NULL,
      bbcode_uid varchar(8) character set utf8 collate utf8_bin NOT NULL,
      bbcode_bitfield varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
      page_time int(11) unsigned NOT NULL default '0',
      page_order int(11) unsigned NOT NULL default '0',
      page_display tinyint(1) unsigned NOT NULL default '0',
      page_display_guests tinyint(1) unsigned NOT NULL default '0',
      page_author mediumint(8) unsigned NOT NULL,
      PRIMARY KEY  (page_id)
    );
Hello All
Locked

Return to “[3.0.x] MOD Database Releases”