End-User Options - Inline (Ajax) Subscription Management

Inline Subscription Management
Version 1.0

What does this do?
This little mod allows your members to change their thread subscription options directly from the Forum Display page!

Flash-Demo you say? http://www.citconsultants.co.uk/demo...ger/index.html


Looks great! How do I install?
Installation is very simple. It involves uploading 1 Product XML and making 2 minor template edits. See the install.txt file inside the zip for full step-by-step instructions.


Important: Unfortunately, my leased vBulletin licence has now expired, and I won't be renewing it until September which means I will be unable to reply to this thread, or update this mod until then. I'm hopeful that the great vBulletin.org community will step in to answer any questions in my absence though See you all in early September!

[rmxs]

Fantastic

Byt i try to install it on 3.5.4 and doesnt work...i get sql error

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Handle the Ajax calls', 'ajax_complete', 'if ($_POST[\'do\'] == \'update_subs\')\r\n{\r\n\r\n $_POST[\'threadid\'] = convert_urlencoded_unicode($_POST[\'threadid\']);\r\n $_POST[\'changeto\'] = convert_urlencoded_unicode($_POST[\'changeto\']);\r\n \r\n $vbulletin->input->clean_array_gpc(\'p\', array(\r\n \'threadid\' => TYPE_UINT,\r\n \'changeto\' => TYPE_INT\r\n ));\r\n\r\n // -1 = Unsubscribe\r\n // 0 = None\r\n // 1 = Instant\r\n // 2 = Daily\r\n // 3 = Weekly\r\n\r\n $xml = new vB_AJAX_XML_Builder($vbulletin, \'text/xml\');\r\n\r\n if ($vbulletin->GPC[\'changeto\'] != -1)\r\n {\r\n $vbulletin->db->query_write(\"UPDATE \" . TABLE_PREFIX . \"subscribethread\r\n SET emailupdate = \" . $vbulletin->GPC[\'changeto\'] . \"\r\n WHERE threadid = \" . $vbulletin->GPC[\'threadid\'] . \"\r\n AND userid = \" . $vbulletin->userinfo[\'userid\']);\r\n\r\n $xml->add_tag(\'status\', \'updated\');\r\n }\r\n else \r\n {\r\n $vbulletin->db->query_write(\"DELETE FROM \" . TABLE_PREFIX . \"subscribethread\r\n WHERE threadid = \" . $vbulletin->GPC[\'threadid\'] . \"\r\n AND userid = \" . $vbulletin->userinfo[\'userid\'] . \"\r\n LIMIT 1\");\r\n\r\n $xml->add_tag(\'status\', \'deleted\');\r\n }\r\n\r\n $xml->print_xml();\r\n\r\n}', 'cit_inline_subscriptions');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Wednesday, June 21st 2006 @ 11:38:48 AM
Script : admincp/plugin.php
Referrer : admincp/plugin.php?do=productadd
IP Address : 213.5.51.167
Username : ***
Classname : **_database

[Alan @ CIT]

Hi,

I'm afraid that this hack is for 3.6 Beta 2 or above, not 3.5.4

Thanks,
Alan.

[rmxs]

LOL yeap i know byt i just try :P

can you conver it for 3.5.4 ???

[Alan @ CIT]

If you edit the Product XML and remove all of the executionorder="5" then install it, it may work, but I can't guarentee it as I haven't tested it

Thanks,
Alan.

[rmxs]

i konw that and if it not work??

You cannot port it to 3.5.4?? 3.6 its still in beta

[Alan @ CIT]

Sorry, but 3.5 is the past, 3.6 is the future All of my new hacks will only be supported on 3.6 from now on

Thanks,
Alan.

[C.Birch]

Originally Posted by Alan @ CIT

Being able to subscribe to a thread is on the todo list, but I can't think of a good way to do it

I need something (icon / button / etc) that is on every thread in forumdisplay for the user to click on to show up the Subscribe dropdown. Unfortunately, the only thing I could think of was the threadicon (status icon - opened, closed, etc) but that's being used by vB to open/close threads, so I just don't know

Thanks,
Alan.

how about icons like this i just done fast?
Attachment 49872

[-=Sniper=-]

I like the idea of inline subscription, but why would someone subscribe to something they have not read, a option when reading the thread is enough imho.

[Gaskell]

I tend to use a subscription without emails just to flag it in my CP that I wanted to read it or it might be useful sometime without actually reading it. Saves having loads of bookmarks for one forum

I like the idea

[C.Birch]

Originally Posted by -=Sniper=-

I like the idea of inline subscription, but why would someone subscribe to something they have not read, a option when reading the thread is enough imho.

They might have read it and gone out of the topic and it would save going back in to it.

People might have also posted a topic and after thinked about subscribin to it and so on.

Someone might have read the preview via mouse over and that also.