Module: Anonymous Newflags
Posted by Martijn van Maasakkers
All files from this thread
File Name | File Size | Posted by | Date | ||
---|---|---|---|---|---|
anonymous_newflags.zip | 8.9 KB | open | download | Martijn van Maasakkers | 06/03/2010 | Read message |
Module: Anonymous Newflags July 10, 2008 04:16AM |
Registered: 15 years ago Posts: 31 |
This module allow anonymous users to use newflags to see what messages they've already read. This works on the index, list and read views. You can link to a markread event to let anonymous users mark entire forums as read. This module uses 2 tables which are installed on activation.
The old newmessages should not be used anymore due to no checking of cookie length.
Version 1.1: Added masterquery flags for mysqli_replication compatibility
Version 1.2: Fixed error that was caused by an empty message_id string given to a select query when a forum is empty
Edited 3 time(s). Last edit at 06/03/2010 06:49AM by Martijn van Maasakkers.
The old newmessages should not be used anymore due to no checking of cookie length.
Version 1.1: Added masterquery flags for mysqli_replication compatibility
Version 1.2: Fixed error that was caused by an empty message_id string given to a select query when a forum is empty
Edited 3 time(s). Last edit at 06/03/2010 06:49AM by Martijn van Maasakkers.
Re: Module: New messages July 10, 2008 05:29AM |
Admin Registered: 19 years ago Posts: 8,532 |
That looks good. It will surely help the people that want to run anonymous posting forums. I have seen requests for a feature like this several time, so thank you for this mod!
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Re: Module: Anonymous Newflags December 02, 2008 04:23AM |
Registered: 15 years ago Posts: 31 |
This module allow anonymous users to use newflags to see what messages they've already read. This works on the index, list and read views. You can link to a markread event to let anonymous users mark entire forums as read. This module uses 2 tables which are installed on activation. The 1.1 version works with mysqli replication as well because masterquery flags are added to the queries.
The old newmessages should not be used anymore due to no checking of cookie length.
The old newmessages should not be used anymore due to no checking of cookie length.
Re: Module: Anonymous Newflags May 27, 2010 01:00PM |
Registered: 14 years ago Posts: 8 |
Hi - we recently installed 5.2 and we get the following error when trying to create a new forum until we uninstalled anonymous newflags:
Sorry, a Phorum database error occurred.
Please try again later!
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (1064): SELECT user_hash, forum_id, message_id FROM phorum_anonymous_newflags WHERE user_hash = '1bac58728eff02ef7b85c5d6cc77b8a0' AND forum_id = '25' AND message_id IN ()
Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysqli.php:212
----
Function phorum_db_interact called at
{path to Phorum}/mods/anonymous_newflags/db.php:137
----
Function anonymous_newflags_db_get_newflags called at
{path to Phorum}/mods/anonymous_newflags/anonymous_newflags.php:107
----
Function anonymous_newflags_list called
----
Function call_user_func_array called at
{path to Phorum}/common.php:1692
----
Function phorum_hook called at
{path to Phorum}/list.php:474
----------------------------------------
Any idea what the problem could be?
Sorry, a Phorum database error occurred.
Please try again later!
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (1064): SELECT user_hash, forum_id, message_id FROM phorum_anonymous_newflags WHERE user_hash = '1bac58728eff02ef7b85c5d6cc77b8a0' AND forum_id = '25' AND message_id IN ()
Backtrace:
Function phorum_database_error called at
{path to Phorum}/include/db/mysql/mysqli.php:212
----
Function phorum_db_interact called at
{path to Phorum}/mods/anonymous_newflags/db.php:137
----
Function anonymous_newflags_db_get_newflags called at
{path to Phorum}/mods/anonymous_newflags/anonymous_newflags.php:107
----
Function anonymous_newflags_list called
----
Function call_user_func_array called at
{path to Phorum}/common.php:1692
----
Function phorum_hook called at
{path to Phorum}/list.php:474
----------------------------------------
Any idea what the problem could be?
Re: Module: Anonymous Newflags June 03, 2010 06:50AM |
Registered: 15 years ago Posts: 31 |
Re: Module: Anonymous Newflags June 07, 2010 09:24AM |
Registered: 14 years ago Posts: 8 |
Re: Module: Anonymous Newflags June 09, 2010 09:30AM |
Registered: 15 years ago Posts: 3 |
Sorry, only registered users may post in this forum.