[plugin] Display message open statistics

[H2B2]

You have an instalation guide?
It works with version 2.10.2?

There is some explanation on how to use it in the first post of this thread. But you'd perhaps best read the whole thread.

I think it will work with phplist 2.10.2 as I haven't seen any message stating it wouldn't, but haven't checked it myself.

[H2B2]

Installation instructions:

Statistics plugin for PHPlist

I have developed a plugin that gives open & bounce statistics for a message. Also shows you exactly who has viewed the message (and who hasn't... as far as it's possible to tell). It only works for HTML messages - it's not possible to know who opened text messages.

To enable open statistics you need to put the placeholder [USERTRACK] somewhere in your HTML message. A good idea is to put it in your default message footer via the configure page. See this topic.

Installation

To install, delete all the current contents of lists/admin/plugins. Unzip the plugins.zip file, being careful to keep the directory structure intact & copy all the files to lists/admin/plugins. That's it.

You will need to know the message id for the message you want info on. You can get this from the "messages" page - click "view" on the message you're interested in.

Paul Brett


changes in config.php

Keep in mind that if you want to see the links to your plugins in the admin backend, you have to enable the plugin directory in your config.php file, by uncommenting this line (remove the #) and making sure this directory actually exists on your server:

Code: Select all

# define("PLUGIN_ROOTDIR","plugins");

You should now see links to your plugins in the Admin main page.

---
Update note by tnnr

The problem with this plugin by default is that is does not use the table prefix's. So if you use a prefix other than the default it will not work... this update pulls the correct prefix from the general config.

The statistics plugin can be downloaded from viewtopic.php?p=10108#p10108 . You have to sign in on this board to be able to see the download link.

[Musi]

Hi all !

unfortunately, there´s no link to the modified messaages.php.

could you please tell me, where to get this file ?!

thanks a lot !

[H2B2]

Did you try downloading the plugin from viewtopic.php?p=10108#p10108 ?

You have to be logged in on this board to be able to see the download link.

[Musi]

thanks für your answer !

the problem ist not to get the Plugin, but to get the modified "message.php"

the Plugin works fine - i just would like to use it as easy as possible

[H2B2]

Ah, yes. I now see you are referring to this file:

You will need to know the message id for the message you want info on. You can get this from the "messages" page - click "view" on the message you're interested in. If you're feeling brave you can download a modified version of lists/admin/messages.php here in zip form. This displays a link to the correct statistics directly next to the message.

Paul Brett's link is broken unfortunately, but you might try sending a a PM to some of the users in this thread and ask them to post the modified messages.php here.
For instance
rdbartz: viewtopic.php?p=2743#2743
abaykamau: viewtopic.php?p=5982#5982
Aurelien: viewtopic.php?p=15749#15749

[Musi]

thanks a lot - i did wrote to all of them.
swo let´s wait and see.....


cheers,
musi

[markio]

I like this script very much. I slightly modified the script so you won't have to look up the message id by clicking the messages button to see whick id's are available.

changed line 18 from:

Code: Select all

print 'Enter message number: <input>';

to:

Code: Select all

$message = Sql_query("SELECT id,subject FROM ".$tables["message"]);
echo '<select>'."\n";
echo '  <option>select a message</option>'."\n";
while ($field = mySql_fetch_array($message)) {
  $m_id      = $field["id"];
  $m_subject = $field["subject"];
  $selected = ($m_id == $id)?' selected="selected" ':' ';
  echo '<option>'.$m_id.' ['.$m_subject.']</option>'."\n";
}
echo '</select>'."\n";

[Musi]

Hey Markio !

thanks a Lot for this - it helped me a lot !

keep on rockin´ - and do more of stuff like this !

cheers,

musi

[Musi]

Hey Markio,

unfortunately i do have some Problems with your script.

after changing the script, i´ve found the dropdown-menu, but i was unable to select a message. all that happend was - guess what: nothing.....

do you have an idea ?

thanks,
musi

[markio]

Did you leave the "go" button where it was? Because that one is still needed to confirm your selection.

It should be working fine but if you continue experiencing problems with it I'll attatch the entire changed file.

[hardwired]

I cleaned up markio's code snippet and the pulldown works for me now :

Code: Select all

$message = Sql_query("SELECT id,subject FROM ".$tables["message"]);
echo '<select>'."\n";
echo '  <option>select a message</option>'."\n";
while ($field = mySql_fetch_array($message)) {
  $m_id      = $field["id"];
  $m_subject = $field["subject"];
  $selected = ($m_id == $id)?' selected="selected" ':' ';
  echo '<option>'.$m_id.' ['.$m_subject.']</option>'."\n";
}
echo '</select>'."\n";


Hey Markio,

unfortunately i do have some Problems with your script.

after changing the script, i´ve found the dropdown-menu, but i was unable to select a message. all that happend was - guess what: nothing.....

do you have an idea ?

thanks,
musi

[jagsv]

Thanks to everyone who has added their posts, links and codes, because this helps us and everyone to make PHPList to work as we like to have it.

Althou... i have some questions regarding this hack or mod, I have done basically as you said... except that i didnt delete all the content of the plugins folder, just added the folder to the plugins folder and changed the codes route to

# This code has been insterted to track statistics in a whole new level
define ("PLUGIN_ROOTDIR","/plugins/statistics_plugin/statistics.php");

I do understand that it should work by doing it like this, but the problem is that where can i see that information...where can i access to a page where i type the ID of the message i want to track...for example i go to messages and i find the id of the message but cant get a page where to view the statistics....

Appreciate help and support.

[H2B2]

Are you sure you correctly installed the plugin?
Ref:
viewtopic.php?p=23672#p23672
viewtopic.php?p=15749#p15749

[freqz]

Ok, I'm having a bit of a problem here. I've tried the code from Markio and I've also tried the code posted just below him from Hardwired.

Same result each time, I hit "GO" and nothing happens, just looks like the screen refreshes.

Can anyone point me to what I might be doing wrong ? Same thing happen with either code. The manually entering of the number does however work fine.

I am using 2.10.5 if that makes a difference ??

Do I need to get the modified messages.php to have this working ? IF so where do I find it ??