ACP Announcement Centre

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.
Locked
YOUAREtehSCENE
Registered User
Posts: 178
Joined: Wed Feb 11, 2009 3:35 am
Location: Boston, Mass
Contact:

Re: ACP Announcement Centre

Post by YOUAREtehSCENE »

DUDE EPIC!!!! THANKS!!!

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Announcement Centre

Post by lefty74 »

your welcome :)
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Bobster60
Registered User
Posts: 30
Joined: Tue Jan 27, 2009 10:58 am

Re: ACP Announcement Centre

Post by Bobster60 »

hate to sound a total numpty an all. but how do I do the SQL bit of the edit.

damn damn damn
I did a restore to just before I did the update as I was getting all sorts of errors now I get

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_ads' already exists [1050]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
any suggestions on what to do now it took me all day to get the edits done yup Im slow very slow lol
Will I have to do a complete install and restore old database?
my MOD's and addons advertisement management, activity stats, tracelogs, Browser language detector, Announcement centre, ZB block, Anti Bot question, Bots Mod, Project Honeypot, Faq manager, check spammers, RSS feeder, new message adviser for Acp.

jshell2009
Registered User
Posts: 9
Joined: Thu Feb 19, 2009 3:36 am

SQL help..

Post by jshell2009 »

When i installed the mod then went to the .mod page, i recieved an error (table 'board4.annoucments..... does not exit.
I searched the forum and found the INSTALL file to update my SQL database. During that install an error came up "table 'phpbb_annoc.... already exist'
I know very little about SQL, but it sounds like i have to rename the table from phpbb to board4. Is this correct and how do i do this?

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Announcement Centre

Post by lefty74 »

Bobster60 wrote:hate to sound a total numpty an all. but how do I do the SQL bit of the edit.
http://www.phpbb.com/community/viewtopi ... 0&t=588697
above link shows you how to execute the sql. alternatively, you can make use of the installer mentioned in the third post of this topic.
damn damn damn
I did a restore to just before I did the update as I was getting all sorts of errors now I get

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_ads' already exists [1050]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
any suggestions on what to do now it took me all day to get the edits done yup Im slow very slow lol
Will I have to do a complete install and restore old database?
not sure what you did or were trying to do when you got that error message but this phpbb_ads table appears to be from a mod other then this one.
jshell2009 wrote:When i installed the mod then went to the .mod page, i recieved an error (table 'board4.annoucments..... does not exit.
I searched the forum and found the INSTALL file to update my SQL database. During that install an error came up "table 'phpbb_annoc.... already exist'
I know very little about SQL, but it sounds like i have to rename the table from phpbb to board4. Is this correct and how do i do this?
if i recall correctly the install file tries to drop the announcement centre table first, then recreates it.
i would recommend to have a look at your database via phpMyAdmin and delete and announcement_centre tables you see there and then try to run the install file again.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Bobster60
Registered User
Posts: 30
Joined: Tue Jan 27, 2009 10:58 am

Re: ACP Announcement Centre

Post by Bobster60 »

Thanks for that lefty, good job I DL all the files I edited, Managed to get ACP back up and running, Ill get around to doing the SQL in the morning, I say I got admin back but all php's to Members has vanished ie: if I click on the manage members it brings up a blank page, so evidantly somehow I(the numpty managed to do something to that page any suggestions what page I need to upload etc
this is the page it goes to
http://mywebsite/tlc/adm/index.php?sid= ... e=overview
but its a blank white page ooooooooooooopppppppps
Ill try searching the forum for the answer but I doubt my logic works lol
my MOD's and addons advertisement management, activity stats, tracelogs, Browser language detector, Announcement centre, ZB block, Anti Bot question, Bots Mod, Project Honeypot, Faq manager, check spammers, RSS feeder, new message adviser for Acp.

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Announcement Centre

Post by lefty74 »

not 100% sure but would think it's includes/acp/acp_users.php.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Bobster60
Registered User
Posts: 30
Joined: Tue Jan 27, 2009 10:58 am

Re: ACP Announcement Centre

Post by Bobster60 »

Finally got it installed, looks brilliant thanks Lefty, just one problem then I'm sorted, Ive tried all sorts to correct this but no luck.
My problem is I can either have the MODs announcement center OR I can post a reply not both.
when I try to reply to a post or make a new topic all that comes up is the smillies and a blank page

this is the code that I get this problem with on line 22 if I do not put your extra coding in which is

Code: Select all

$acp_announce = false)

Code: Select all

* Fill smiley templates (or just the variables) with smilies, either in a window or inline
*/
function generate_smilies($mode, $forum_id, $acp_announce = false)
{
	global $auth, $db, $user, $config, $template;
	global $phpEx, $phpbb_root_path;

	if ($mode == 'window')
	{
		if ($forum_id)
		{
			$sql = 'SELECT forum_style
				FROM ' . FORUMS_TABLE . "
				WHERE forum_id = $forum_id";
			$result = $db->sql_query_limit($sql, 1);
			$row = $db->sql_fetchrow($result);
			$db->sql_freeresult($result);

			$user->setup('posting', (int) $row['forum_style']);
		}
		else
did that make sense
my MOD's and addons advertisement management, activity stats, tracelogs, Browser language detector, Announcement centre, ZB block, Anti Bot question, Bots Mod, Project Honeypot, Faq manager, check spammers, RSS feeder, new message adviser for Acp.

Unleashedkb
Registered User
Posts: 29
Joined: Thu Feb 26, 2009 2:26 pm

Re: ACP Announcement Centre

Post by Unleashedkb »

well i installed this mod on 3.0.4. The installation went right. I am able to even submit the annoucement but I am not able to see the annoucement.

If anyone could guide this to me then it would be great.

jshell2009
Registered User
Posts: 9
Joined: Thu Feb 19, 2009 3:36 am

Re: ACP Announcement Centre

Post by jshell2009 »

Still cant get it installed. I think my pronlem is with the SQL. When i go to the .MOD tab in the acp, i get teh following error:
General Error
SQL ERROR [ mysql4 ]

Table 'board4.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

SELECT * FROM ANNOUNCEMENTS_CENTRE_TABLE

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_announcements_centre.php
LINE: 114
CALL: dbal_mysql->sql_query()

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

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

I went into MySQL manager and deleted the annoucment table. I tried to reinstall it and got the following error message:
General Error
SQL ERROR [ mysql4 ]

Table 'board4.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

INSERT INTO ANNOUNCEMENTS_CENTRE_TABLE (announcement_enable_guests, announcement_show, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_text_bbcode_uid, announcement_text_bbcode_bitfield, announcement_text_bbcode_options, announcement_draft, announcement_draft_bbcode_uid, announcement_draft_bbcode_bitfield, announcement_draft_bbcode_options, announcement_title_guests, announcement_text_guests, announcement_text_guests_bbcode_uid, announcement_text_guests_bbcode_bitfield, announcement_text_guests_bbcode_options, announcement_show_group) VALUES (1, 1, 0, 0, 'Site Announcements', '[color=red:1ni98ynr][b:1ni98ynr]Site Announcements[/b:1ni98ynr][/color:1ni98ynr] can be seen here!! <!-- s:mrgreen: --><img src=\"{SMILIES_PATH}/icon_mrgreen.gif\" alt=\":mrgreen:\" title=\"Mr. Green\" /><!-- s:mrgreen: -->', '1ni98ynr', 'Qg==', 7, '[color=red:1dynrqhh][b:1dynrqhh]Draft Announcements[/b:1dynrqhh][/color:1dynrqhh] can be seen here!! <!-- s:mrgreen: --><img src=\"{SMILIES_PATH}/icon_mrgreen.gif\" alt=\":mrgreen:\" title=\"Mr. Green\" /><!-- s:mrgreen: -->', '1dynrqhh', 'Qg==', 7, 'Guest Announcements', '[color=green:1r1lr5fd][b:1r1lr5fd]Guest Announcements[/b:1r1lr5fd][/color:1r1lr5fd] can be seen here!! :wink:', '1r1lr5fd', 'Qg==', 7, '2')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: install/index.php
LINE: 80
CALL: dbal_mysql->sql_query()

When i go back to MySQL and look, the annoucment table is there again.
I recently upgraded from phpBB2.xx to 3.0.4
The only other mod installed is the antibot question mod.
I used Automod when i installed the announcment center. All the files were installed except for the subsilver files which i added myself.
Any ideas?

User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: ACP Announcement Centre

Post by Gremlinn »

That looks like the include/constants.php file isn't updated.

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Announcement Centre

Post by lefty74 »

Bobster60 wrote:Finally got it installed, looks brilliant thanks Lefty, just one problem then I'm sorted, Ive tried all sorts to correct this but no luck.
My problem is I can either have the MODs announcement center OR I can post a reply not both.
when I try to reply to a post or make a new topic all that comes up is the smillies and a blank page

this is the code that I get this problem with on line 22 if I do not put your extra coding in which is

Code: Select all

$acp_announce = false)

Code: Select all

* Fill smiley templates (or just the variables) with smilies, either in a window or inline
*/
function generate_smilies($mode, $forum_id, $acp_announce = false)
{
	global $auth, $db, $user, $config, $template;
	global $phpEx, $phpbb_root_path;

	if ($mode == 'window')
	{
		if ($forum_id)
		{
			$sql = 'SELECT forum_style
				FROM ' . FORUMS_TABLE . "
				WHERE forum_id = $forum_id";
			$result = $db->sql_query_limit($sql, 1);
			$row = $db->sql_fetchrow($result);
			$db->sql_freeresult($result);

			$user->setup('posting', (int) $row['forum_style']);
		}
		else
did that make sense
that edit looks ok to me, whats the error message you are getting?
Unleashedkb wrote:well i installed this mod on 3.0.4. The installation went right. I am able to even submit the annoucement but I am not able to see the annoucement.

If anyone could guide this to me then it would be great.
you would need to provide some more information, have you doublechecked your edits, especially the template ones. did you purge your cache and refreshed your templates? i am assuming the announcement centre is turned on.
jshell2009 wrote:Still cant get it installed. I think my pronlem is with the SQL. When i go to the .MOD tab in the acp, i get teh following error:
General Error
SQL ERROR [ mysql4 ]

Table 'board4.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

SELECT * FROM ANNOUNCEMENTS_CENTRE_TABLE

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_announcements_centre.php
LINE: 114
CALL: dbal_mysql->sql_query()

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

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

I went into MySQL manager and deleted the annoucment table. I tried to reinstall it and got the following error message:
General Error
SQL ERROR [ mysql4 ]

Table 'board4.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

When i go back to MySQL and look, the annoucment table is there again.
I recently upgraded from phpBB2.xx to 3.0.4
The only other mod installed is the antibot question mod.
I used Automod when i installed the announcment center. All the files were installed except for the subsilver files which i added myself.
Any ideas?
Gremlinn wrote:That looks like the include/constants.php file isn't updated.
i would say the same thing, doublecheck that your includes/constant.php file is a. edited and b. uploaded.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Bobster60
Registered User
Posts: 30
Joined: Tue Jan 27, 2009 10:58 am

Re: ACP Announcement Centre

Post by Bobster60 »

Thats the thing Lefty there is no error message. the page is blank white with the smilies in a line.
if I place the original fuctions_posting.php back up I get :

Parse error: syntax error, unexpected ',', expecting '{' in /home/content/mysite/html/tlc/includes/functions_posting.php on line 22

Smilies
:D :) ;) :( :o :shock: :? 8-) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :!: :?: :idea: :arrow: :| :mrgreen: :geek: :ugeek:
Close window
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group

just like above but with a blank white background


MODS installed
Advertisment mod
Activity MOD
Trace Logs
Browser Language MOD
and this mod
would it be best if I put the whole page coding up here, or do you think it would be another page?
thanks for the replies...you guys are work aholics lol but carry on the good work :D
my MOD's and addons advertisement management, activity stats, tracelogs, Browser language detector, Announcement centre, ZB block, Anti Bot question, Bots Mod, Project Honeypot, Faq manager, check spammers, RSS feeder, new message adviser for Acp.

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: ACP Announcement Centre

Post by lefty74 »

could you please doublecheck your posting.php and includes/functions_posting.php edits one more time?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Bobster60
Registered User
Posts: 30
Joined: Tue Jan 27, 2009 10:58 am

Re: ACP Announcement Centre

Post by Bobster60 »

will do Lefty....got permision from the boss of the house lol so will do that now
my MOD's and addons advertisement management, activity stats, tracelogs, Browser language detector, Announcement centre, ZB block, Anti Bot question, Bots Mod, Project Honeypot, Faq manager, check spammers, RSS feeder, new message adviser for Acp.

Locked

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