[MODDB] Invisible replies until replied

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

Two questions to the teachers:
1. Who can set the topic to 'Invisible replies'?
2. Who can view replies even when not replied to these topics?
Image

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

Anyways:
[Update to 0.4.0]
Admins can only set replies invisible in this version, on a per topic basis. No more users and auth tables used, only topics table, so list of users gets deleted if topic gets deleted
Image

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

[Upgrade to 0.5.0]
[Release as Beta]
:D
Image

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

[Upgraded to 0.5.2]
Image

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Submitted! :D

Post by Lord Le Brand »

[Upgrade to 1.0.0]
[Submitted to database]
:D
Image

daxriggz
Registered User
Posts: 31
Joined: Thu May 06, 2004 9:32 am

Post by daxriggz »

I can't get the mod. When I click on the link it takes me to a white page that says 'Extern Linken -Filetype'.

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

That's odd, I never got that...

Try here:
http://www.yourfilehost.com/media.php?c ... _1.0.0.mod
Image

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

[Got denied]
[Upgrade to 1.1.0]
[Resubmitted]

If you are using this MOD, please update, big changes inside
Image

PizzaHuge
Registered User
Posts: 360
Joined: Sun Apr 10, 2005 3:36 am

Post by PizzaHuge »

I got this error when view topic which set invi-reply mode:

Code: Select all

Could not obtain topic information

DEBUG MODE

SQL Error : 1064 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 'WHERE t.topic_id = 19 AND r.topic_id = t.topic_id' at line 3

SELECT t.topic_id, t.no_seereply, r.user_replied, r.topic_id FROM phpbb_topics t, phpbb_topics_replied r, WHERE t.topic_id = 19 AND r.topic_id = t.topic_id

Line : 1895
File : functions.php
can some one please correct it, thanks

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

find
FROM " . TOPICS_TABLE . " t, " . TOPICS_REPLIED_TABLE . " r,
this should be
FROM " . TOPICS_TABLE . " t, " . TOPICS_REPLIED_TABLE . " r

just delete a comma, very sorry

and when at it, i upgraded the function and added editpost support...
[Upgrade to 1.1.1]
Image

PizzaHuge
Registered User
Posts: 360
Joined: Sun Apr 10, 2005 3:36 am

Post by PizzaHuge »

thannks, that error is solved, now i got this error:

Error in posting

DEBUG MODE

SQL Error : 1064 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 'WHERE user_replied = 2' at line 3

INSERT INTO phpbb_topics_replied SET topic_id = 19 WHERE user_replied = 2

Line : 660
File : functions_post.php

any idea?

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

yes, very sorry, wrong sql query, fixed in 1.1.1-a
Image

PizzaHuge
Registered User
Posts: 360
Joined: Sun Apr 10, 2005 3:36 am

Post by PizzaHuge »

do you have the update for the sql to fix my error?

thanks

Lord Le Brand
Registered User
Posts: 306
Joined: Fri May 26, 2006 8:28 pm
Location: The Netherlands (GMT+1)

Post by Lord Le Brand »

FIND:

Code: Select all

			$sql = "INSERT INTO " . TOPICS_REPLIED_TABLE . "
				SET  topic_id = $topic_id 
				WHERE user_replied = $user_id";
REPLACE WITH:

Code: Select all

			$sql = "INSERT INTO " . TOPICS_REPLIED_TABLE . " (topic_id, user_replied) VALUES ($topic_id, $user_id)";
Image

PizzaHuge
Registered User
Posts: 360
Joined: Sun Apr 10, 2005 3:36 am

Post by PizzaHuge »

it is fixed, you thew best thanks

Locked

Return to “[2.0.x] MODs in Development”