lock new topic on submit

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
spaceace
Registered User
Posts: 1993
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: lock new topic on submit

Post by spaceace »

just for everyone's information, yes, it has been tested and works just fine with phpBB3.0.6RC-1 ;)
John Leeuwis
Registered User
Posts: 20
Joined: Mon Sep 28, 2009 3:08 pm
Location: Netherlands
Name: John Leeuwis
Contact:

Re: lock new topic on submit

Post by John Leeuwis »

And with RC2

Is it possible to make "closed" the default in only one specific topic.
We have a 'to buy' topic with I would like to be closed on submit.
However, each topic has to pass the moderation queue.
Then, when approved, it would has been locked on submit
User avatar
spaceace
Registered User
Posts: 1993
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: lock new topic on submit

Post by spaceace »

John Leeuwis wrote:And with RC2

Is it possible to make "closed" the default in only one specific topic.
We have a 'to buy' topic with I would like to be closed on submit.
However, each topic has to pass the moderation queue.
Then, when approved, it would has been locked on submit
this is only for members with moderator permissions to be able to lock a new topic.
John Leeuwis
Registered User
Posts: 20
Joined: Mon Sep 28, 2009 3:08 pm
Location: Netherlands
Name: John Leeuwis
Contact:

Re: lock new topic on submit

Post by John Leeuwis »

Understand.
I hoped I would be abble to use it (as moderator) in the moderation que when approving new topics.
After approval I've to return to the new topic to close it anyway.
Hoped I could skip the last step with this.
User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: lock new topic on submit

Post by Neuropass »

does it work on phpbb 3.06 final?
User avatar
spaceace
Registered User
Posts: 1993
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: lock new topic on submit

Post by spaceace »

Neuropass wrote:does it work on phpbb 3.06 final?
yes, it works just :D fine
User avatar
Coert
Registered User
Posts: 151
Joined: Mon May 18, 2009 7:16 pm
Location: Switzerland

Re: lock new topic on submit

Post by Coert »

Great solve!
Thanks

Version: 3.0.0
User avatar
spaceace
Registered User
Posts: 1993
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: lock new topic on submit

Post by spaceace »

it has come to my attention that my mod causes an error with JRSweets Arcade Mod.

the error is an sql error. here's the error that i have produced on my localhost machine
General Error
SQL ERROR [ mysql4 ]

Column 'topic_status' cannot be null [1048]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, topic_status) VALUES (2, 1265642987, 1265642987, '3', 0, 1, '[GAME RELEASE] Crash Test Dummy High Jump', 'spaceace', 'AA0000', 0, 0, 0, NULL)

BACKTRACE

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

FILE: includes/functions_posting.php
LINE: 1965
CALL: dbal_mysql->sql_query()

FILE: includes/arcade/arcade_admin_class.php
LINE: 1745
CALL: submit_post()

FILE: includes/acp/acp_arcade_games.php
LINE: 106
CALL: arcade_admin->create_announcement()

FILE: includes/acp/acp_arcade_games.php
LINE: 45
CALL: acp_arcade_games->add_games()

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

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
this error only happens if the arcade is set to announce game releases by making a release post

thanks to Ashley.S.'s(don't know if it's the same member here) post here http://www.jeffrusso.net/forum/viewtopi ... 523#p21523 there is a fix already available :D

open includes/arcade/arcade_admin_class.php
find

Code: Select all

'topic_title'       => $subject,
after add

Code: Select all

'topic_status'		=> false,
User avatar
Ashley.S.
Registered User
Posts: 469
Joined: Mon Aug 04, 2008 6:01 pm
Location: Falmouth, Cornwall, UK
Name: Ashley .S.
Contact:

Re: lock new topic on submit

Post by Ashley.S. »

yes, I'm the same person spaceace and no problem ;)
Regards,
-Ashley.S. [ PurephpBB Founder ]
User avatar
Coert
Registered User
Posts: 151
Joined: Mon May 18, 2009 7:16 pm
Location: Switzerland

Re: lock new topic on submit

Post by Coert »

I had this with a bets/bookmaker MOD.
I changed the topic_status in MySQL so it would support Null.
Is there any danger in this?
User avatar
spaceace
Registered User
Posts: 1993
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: lock new topic on submit

Post by spaceace »

Coert wrote:I had this with a bets/bookmaker MOD.
I changed the topic_status in MySQL so it would support Null.
Is there any danger in this?
i'm not aware of any issues that would cause.
User avatar
Ahri89
Registered User
Posts: 524
Joined: Sat Apr 07, 2007 2:53 pm
Location: Spain
Contact:

Re: lock new topic on submit

Post by Ahri89 »

Installed on 3.0.7 and works perfect with Automod.
MODs translated to Spanish: ACP Add User MOD, ACP Announcement Centre, Advertisement Management, Custom Profile Fields, Update Reminder, Flood time setting per forum, MOD Version Check, Posting template, Prune Log, Simple Trash Bin, TinyPic Plugin, User Reminder, View Profile, View your topics, and more...

Sorry for my bad english xD
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26842
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: lock new topic on submit

Post by Paul »

MOD Updated to version 1.0.4
See first post for Download Link
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development
Locked

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