Search results

Just had a look in phpmyadmin, and notices, actually you can export quite easily there So go to phpmyadmin -> select your database -> click the "SQL" tab In there you paste SELECT title, category, tot_pv_overall, alexa_rank FROM VL_sites sites, VL_stats stats WHERE sites.username =...

For anyone who might have downloaded the zip already. There was an issue with 1 file and missing css ( you might need to clear your cache after upload ) And the zip is now updated with fixed code EDIT:: Zip removed since it comes into Visiolist 1.7

Not with visiolist itself, no. We only export full sql in admin. Also not using phpmyadmin, since it only does exports using columns from same table ( not cross table like you need ) as far as i know. For that you need to write a custom mysql dump/export php script May i ask for what reason...

That is odd, it works on my dev list. Can you set me up a test ftp account? and admin password? via PM You can delete ftp user after im done and change admin pass via http://visiolist.com/community/threads/i-want-to-change-my-admin-password.518/

Good to hear, nice

I asked to test with the zip but without the plugin modification. The zip has nothing to do with the plugin, perse, it just add the tag feature to VL Did you tested with or without the zip?

Thats not possible, i suspect you may have another plugin which modifies the where? That part if pretty clear and it will only select sites with tot_pv_overall > OR alexa_rank > 0 Im at my limit with helping from distance here, any more would need ftp/cpanel access to do some live testing

Does it work without the plugin file? We need to strip down where the error lays then. So just replace the zip contents and try email ( only put a test user in the queue list ) "Hello {$username}"

Like i said, you already have plugin for the rank overall/category stuff right? make the file there and put that content in that file Not sure what you mean here? Go to admin - > email members and write your email with the tags include

Ok I finished this feature for visiolist 1.7 Unzip the attached file and upload the contents to your toplist root. 1) Now by default you can use in subject and email body any tag as your used to from templates. That means any database column from VL_sites or VL_stats table. e.g 2) The email...

Basti updated Disqus Comments with a new update entry: More settings Read the rest of this update entry...

Added another setting for the rankings comment count, so it can enabled/disabled. Default is enabled. if disabled will not load the required javascript to speed up pageload

You will need a cron. Else alexa not really makes much sense, you want it regulary updated. Cron runs a different php version it looks like than your hosting site. And that error means you need to check your other php versions php.ini If I remember correctly you can do that within cpanel ->...

Just for info, this change is now integrated with 1.7

That happens automatically by visiolist. Check post #18 again http://visiolist.com/community/threads/alexa-plugin.2220/#post-13897 on new day it checks if any zero, sends them mail, and once a month resets the mail marker for those still with zero, so they are emailed again

$TMPL['no_pageviews_text'] = ''; if ($TMPL['tot_pv_overall'] == 0) { $TMPL['no_pageviews_text'] = 'No link code attach in the owner site'; }

For the email part, hmm. You might could do this then. 1) you need a new field in VL_sites - alexa_emailed, make it a tinyint field with default value of 0 ( zero ) 2) Now, so we don't email them each and every day, we have set this new field to 1 once they have been emailed. - then you could...

Oh I see, I guess you can keep that on then. Don't know how it will react to be honest though, so got to try out I guess. Was just a quick guess on my end. Oh right its a bit wrong code, try this $where_extra .= " AND (tot_{$ranking_method}_overall > 0 OR alexa_rank > 0)";

Skip on ranking if both is zero: in your plugin - rankings_extend_where.php $where_extra .= " AND tot_{$ranking_method}_overall > 0 AND alexa_rank > 0"; For this to work, you need to have the admin setting disabled. Make it 0 Now your cron for alexa: unzip attached file and upload in...

Then it does not works ;) Did you made sure you disabled your other ranking plugins? Lets say you plugin "a" which is this one, and plugin "b" which also modify sorting. "b" would overwrite "a"