Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #61  
Old 19 Jul 2012, 17:14
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
Hi Kevin

Have you been able to work on this mod lately? Curious to know where you are at with it
Reply With Quote
  #62  
Old 19 Jul 2012, 17:33
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I haven't made much progress but I haven't forgotten about it - I'll get to it soon.

Have you solved all your email problems?
Reply With Quote
  #63  
Old 19 Jul 2012, 20:12
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
As far as the host knows I have I'm actually just waiting for this mod as (assuming it does everything we've discussed) it's a complete solution for unsubscribing
Reply With Quote
  #64  
Old 02 Aug 2012, 19:47
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
I remember it being brought up on the first page, were you going to incorporate and option to move the unsubscribers to a different user group? I think that should be an option so we can see how many people are unsubscribing
Reply With Quote
  #65  
Old 02 Aug 2012, 20:06
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Hey John - I kind of figured you had given up on this since I saw that you had posted in one of the other mods. Anyway, I asked Simon Lloyd if he wanted to take over working on this (so it might actually get done), but I think he's been too busy.
Reply With Quote
  #66  
Old 03 Aug 2012, 00:31
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
Send me what you have and I'll fiddle around with it I only posted in that other mod to help that guy. This mod here (this thread) is the one I'm after

--------------- Added 03 Aug 2012 at 06:08 ---------------

Ok all I have left to do is code the move to a different user group and code the options for the ACP. I worked out how to change existing subscriptions to "through control panel only"

I'll wait and see what you've got before I continue as I'm quite tired tonight.
Reply With Quote
  #67  
Old 03 Aug 2012, 16:24
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Hi John, Kevin's right, i haven't had time at the moment, i've been looking at the product that Kevin uploaded here and he's pretty6 much got it down except the re-subscribe or keeping a record of what the user unsubscribed from, or allowing a page where all the things they unsubscribed from are present to resubscribe, i cant say when i'll have time at the moment as i have many things going on on along with 7 day working at the moment.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #68  
Old 03 Aug 2012, 22:16
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
That's alright I've been working on it myself However I'm a bit stumped. Trying to add the option (I add them one at a time to make trouble shooting my screw ups easier ) to change new thread subscriptions to "through control panel only" and when I import the XML I get the following error;

XML Error: XML_ERR_NAME_REQUIRED at Line 153

Line 153

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Every solution I have seen says it's the & not being parsed (which I have none), so that's where I'm stumped, it looks fine to me.

The setting looks like (followed Kevin's format obviously)

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #69  
Old 03 Aug 2012, 22:40
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Originally Posted by John Lester View Post
Send me what you have and I'll fiddle around with it
The last one posted here is pretty much all I have.


...and when I import the XML I get the following error;

XML Error: XML_ERR_NAME_REQUIRED at Line 153

Line 153

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

What does the line before that look like?
Reply With Quote
  #70  
Old 04 Aug 2012, 00:53
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
Line 152

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #71  
Old 04 Aug 2012, 01:12
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Hmm...that doesn't help. Look at the surrounding line for missing quote or unusual characters.
Reply With Quote
  #72  
Old 04 Aug 2012, 03:10
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
It was a missing ! in the following line
Reply With Quote
  #73  
Old 04 Aug 2012, 10:51
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
I'm about to head to bed after staring at this damn mod for 2 hours trying to find my error.

It imports just fine and the settings work, but when I go to /mics.php?do=unsubscribe all I get is the smiley page. No errors.

So I'm going to attach it here and maybe someone can find the error for me

It's not complete yet, still have to do the user group stuff, the resubscribe stuff, and find a way to store the existing thread subscriptions. The plan for the subscriptions is to create another table to copy the users subscriptions to and the query to take the data from the backup table and repopulate the original.

EDIT: It was a simple typo in the template name So with no errors I can now work on the user group stuff

Last edited by John Lester; 05 Aug 2012 at 02:14.
Reply With Quote
  #74  
Old 12 Aug 2012, 11:33
John Lester's Avatar
John Lester John Lester is offline
 
Join Date: Nov 2004
Ok I'm a bit stuck and a little confused (and not about the same thing ).

I basically followed Kevin's "select" and "update" queries to add the other options to be changed. However I'm a little confused why the "select" query selects username and userid when the "update" query doesn't use those variables.

Select query

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Update query

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Now to the part I'm stuck on.... thread subscriptions. When I use my "select" query it triggers this if statment:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This is the select query

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

I have other issues with thread subscriptions, but I figure I should find out what's wrong with my select query first

Is it because the subscribethread table doesn't have an email column?

Last edited by John Lester; 12 Aug 2012 at 12:00.
Reply With Quote
  #75  
Old 12 Aug 2012, 13:45
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I don't remember why the query included username and userid, I suppose I thought I needed them (or might need them) for one of the other features we talked about. But it also doesn't hurt anything to have them there.

You're right, the subscription table doesn't include email, so there's no reason to check for that field being blank. Also I don't think you're checking correctly for multiple values of emailupdate. I think you want something like:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


I think have "OR 2 OR 3" on the end of the query like that will cause it to return every row.

Oh, that brings up another issue - since you want to return every record of a user's subscriptions, you can't use query_first(), you need to use query_read() and then use a loop to get each record.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Administrative and Maintenance Tools Email Rules - Require that users' email addresses match a regular expression Analogpoint vBulletin 3.8 Add-ons 15 03 May 2013 13:26



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:09.

Layout Options | Width: Wide Color: