vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Links and Downloads Manager (https://vborg.vbsupport.ru/showthread.php?t=119041)

Slave 08-06-2007 07:44 AM

One thing I've noticed about the Tag Cloud .. it only seems to show keywords that anyone can see, it doesn't take into account words that are added into an area that are protected by forum permissions. Any chance this could be changed?

AndrewD 08-06-2007 04:13 PM

Quote:

Originally Posted by itsblack (Post 1310584)
I've tried what you said, it took no effect.
Actually after upgraded to the later versions, there are already some entries which the linkthread column are set, but even with these entries the comment doesn't work.
It's weird.

I'm at a loss with this. I set up a board using your Chinese translation, created various new entries to get threads created and tried adding comments.

a) the standard process with 2.2.8 code worked fine
b) when I tried killing the linkthread value, the standard release code did not work, for reasons I understand, but the simplified regular expression worked just fine.

I saw that you've modified the ldm_thread_create_relink message, which is what is generated/tested. In your version, there are extra bbcodes inside the thread bbcode, but even so, the following code:

Code:

        elseif ($forumid>0 and preg_match("/\[thread=(\d+)\]/", $row['linkdesc'], $match)) {
picks up the threadid fine.

AndrewD 08-06-2007 05:33 PM

Quote:

Originally Posted by Slave (Post 1310986)
One thing I've noticed about the Tag Cloud .. it only seems to show keywords that anyone can see, it doesn't take into account words that are added into an area that are protected by forum permissions. Any chance this could be changed?

This isn't how it works, unless I'm missing something. Depending on whether you're weighting by hits or just frequency of use, keywords will only be displayed a) if they are used or b) if they've actually been hit.

Slave 08-07-2007 08:36 AM

Quote:

Originally Posted by AndrewD (Post 1311293)
This isn't how it works, unless I'm missing something. Depending on whether you're weighting by hits or just frequency of use, keywords will only be displayed a) if they are used or b) if they've actually been hit.

Yeah .. but could forum permissions be taken into account?

At the moment, a normal register user could see a tag word in the cloud that when clicked takes him to a blank search page as all the items using that tag word are hidden from him as he doesn't have the permission to see that forum which those items are linked to.

See what I mean?

AndrewD 08-07-2007 08:53 AM

Quote:

Originally Posted by Slave (Post 1311747)
Yeah .. but could forum permissions be taken into account?

At the moment, a normal register user could see a tag word in the cloud that when clicked takes him to a blank search page as all the items using that tag word are hidden from him as he doesn't have the permission to see that forum which those items are linked to.

See what I mean?

Sorry, I misunderstood you. Will take a look

Slave 08-07-2007 09:15 AM

Quote:

Originally Posted by AndrewD (Post 1311758)
Sorry, I misunderstood you. Will take a look

Cool .. ta :)

Alfa1 08-07-2007 10:35 AM

Andrew; are you planning to add inline moderation to LDM?

AndrewD 08-07-2007 10:38 AM

Quote:

Originally Posted by Alfa1 (Post 1311803)
Andrew; are you planning to add inline moderation to LDM?

It's something to do at some time, but it hadn't been given a very high priority. I'm gradually trying to make things more friendly in these ways, without breaking anything.

Alfa1 08-07-2007 10:58 AM

Thanks.

I would like to request the option to handle comments with a vbulletin thread. I prefer this above auto thread creation, because auto thread creation means duplication of the discussion.

minimalize 08-07-2007 01:23 PM

Hi Andrew,

when i have a link like http://rapidshare.de/afile_name.mp3 the system tries to play the link with the mediaplayer. But this is the rapidshare url. Is there an option to turn the mediaplayer off for external links?

obmob 08-07-2007 01:46 PM

Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery :eek:

Thanks :p

AndrewD 08-07-2007 03:23 PM

Quote:

Originally Posted by obmob (Post 1311883)
Hmm... well, finally installed the new script... how do i enable the filmstrip to show the upcoming download link?

You know, that thing I asked for some months ago? That looks similar as vbgallery :eek:

Thanks :p

It's provided in the 'extras' directory - have you installed it and read the 'readme' file?

hydn 08-07-2007 09:02 PM

We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

obmob 08-07-2007 10:23 PM

Quote:

Originally Posted by AndrewD (Post 1311959)
It's provided in the 'extras' directory - have you installed it and read the 'readme' file?

mwahaha! no... thought it was embedded in the templates, so, i was searching all over there. :eek:

Will test tonight, thanks Andrew. :D

AndrewD 08-08-2007 04:07 AM

Quote:

Originally Posted by hydn (Post 1312203)
We avg 50,000 downloads per month and the table... local_links_downloads eventually grew to over 700,000 rows. Which cause huge CPU spikes on our MYSQL server.

After truncating the local_links_downloads table. The CPU spike were gone (after 3 month of trying to find this worsening problem).

So my question, is there anyway to set an auto cut off for the stats to stop incrementing?

Or this means every few months we have to manually truncate the table. Can Links and Downloads Manager be set to only keep say the last 30 days of download stats?

Thanks very much for any support you can provide.

Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.

Alfa1 08-08-2007 09:14 AM

How can I see the number of downloads per month?

AndrewD 08-08-2007 09:32 AM

Quote:

Originally Posted by Alfa1 (Post 1312540)
How can I see the number of downloads per month?

It does not get tabulated by month, but if you go to ldm/admin/hits you can do an analysis for any range of dates for which you still have information in your downloads table.

Rouzbeh1 08-08-2007 03:40 PM

hi Andrew,
just wanted to thank you and report that BW usage is working fine now ;)

btw. i have read that you are implementing a server load management for mirror sites. is that correct? :D

hydn 08-08-2007 04:58 PM

Quote:

Originally Posted by AndrewD (Post 1312403)
Go to LDM/admin/settings and set prune_downloadtable to the number of days you want to keep, e.g. 30. Note that detailed usage statistics are only available for those days where the downloads table is populated, but the overall statistics (total hits on entries) are retained when the table is pruned. Hope this helps.

THanks. That does help. However, I logged in / clicked administer / then clicked settings / ...

But can't find that prune_downloadtable.

I'm on version 2.1.0

Is this an option I can set with a Mysql query maybe? Or other solution(s)?

Thanks much.

BuRaCh 08-08-2007 05:03 PM

thank you good hack;)

AndrewD 08-08-2007 06:37 PM

Quote:

Originally Posted by hydn (Post 1312866)
THanks. That does help. However, I logged in / clicked administer / then clicked settings / ...

But can't find that prune_downloadtable.

I'm on version 2.1.0

Is this an option I can set with a Mysql query maybe? Or other solution(s)?

Thanks much.

Goodness, version 2.1.0.

You're in luck - that part of the code has not changed very much in two years :) Take a copy of the file include/local_links_include.php. Edit, and go to line 1078, which reads:

Code:

function record_hit($id, $url, $status, $size=0) {
        global $vbulletin, $links_permissions, $links_defaults;

        if ($links_permissions["can_bypass_hit_recording"]) {

Change to:

Code:

function record_hit($id, $url, $status, $size=0) {
        global $vbulletin, $links_permissions, $links_defaults;

        $when = TIMENOW-24*60*60*XXX;
        $vbulletin->db->query_write("
                DELETE FROM ".THIS_TABLE."linksdownloads
                WHERE usertime<'".$when."'
        ");

        if ($links_permissions["can_bypass_hit_recording"]) {

where XXX is the number of days you want to retain in the table, e.g. 30.

Ipuck 08-08-2007 07:28 PM

AndrewD, thank you for the 2.2.8 version is working great, tagcluod, mirror site. Excellent work and the upgrade was simple as before..

One small question, I'm not sure if I'm missing this, but how do I search downloads by username? I know I can go the "hits" and then search page by page until I found the username, but iss there any other way? your mod has so many options that I get lost.

AndrewD 08-09-2007 04:22 AM

Quote:

Originally Posted by Ipuck (Post 1312994)
AndrewD, thank you for the 2.2.8 version is working great, tagcluod, mirror site. Excellent work and the upgrade was simple as before..

One small question, I'm not sure if I'm missing this, but how do I search downloads by username? I know I can go the "hits" and then search page by page until I found the username, but iss there any other way? your mod has so many options that I get lost.

Maybe I'm missing the question - apologies if so.

You go to ldm/admin/hits. Then you use the pull down menus to select the dates of interest and 'username'. That produces aggregated information sorted by username. You then click on one of the usernames and you get a full tabulation of that user's activity.

I just discovered that the 2.2.8 code includes a debug statement in the javascript which I forgot to remove. As a result, when you use these pull down menus you'll get a couple of annoying alert boxes pop up. You can dismiss those - they don't matter. Will eb tidied up in the final release.

AndrewD 08-09-2007 04:24 AM

Quote:

Originally Posted by Rouzbeh1 (Post 1312810)
hi Andrew,
just wanted to thank you and report that BW usage is working fine now ;)

btw. i have read that you are implementing a server load management for mirror sites. is that correct? :D

It would be nice to do this, but I'm not sure that I know how to so it reliably.

obmob 08-09-2007 03:52 PM

Hmm... hello, finally installed the filmstrip, it works really good... but i was wondering if it's possible to move it below the linkbit and if there is a template i can edit to add some css style to it? :p
Thanks Andrew!

Those who take a little time to install and learn more about LDM can't deny is the best addon for vbulletin! :D

apokphp 08-09-2007 03:53 PM

Quote:

Originally Posted by AndrewD (Post 1307763)
I took a look at your site, and I think I finally understood your question.

Please check your vb/admincp/languages and phrases. I think that you will find that you have modified the phrase "ll_recent" at some time in the past.

*edit*
Andrew, I think I may have fixed it, just by copy/pasting...can you check to see if it looks how it should look? If so, disregard the indented text below. I do have a 2nd challenge at the bottom of the post though.

Thanks for your time and devotion to this hack, I absolutely love it, it is truly one of the best mods for vbulletin! :)

I don't recall modifying any phrases. I did install this a while back, but I uninstalled it prior to installing the updated version.

In my phrase manager, when I do a search, I have 2 versions of ll_recent.

One is the English translation, the other is the Standard translation. Copy paste from the phrase manager after the search, it isn't formatted well, sorry.

ll_recent English (US) Translation

During the last {1} days:<br />&middot; {2} new entries [<span class="smallfont"><a href="{4}.php?catid=-8">what's new</a></span>]<br />&middot; {3} hits [<span class="smallfont"><a href="{4}.php?catid=-7">what's hot</a></span>]


ll_recent Standard Phrase

{2} new entries {3}since {1}

Is the wrong one being used? How do I get rid of it, or fix the problem?

Any time I try to edit the "standard phrase" one, it goes to the English phrase after clicking "edit". That is...

During the last {1} days:<br />&middot; {2} new entries [<span class="smallfont"><a href="{4}.php?catid=-8">what's new</a></span>]<br />&middot; {3} hits [<span class="smallfont"><a href="{4}.php?catid=-7">what's hot</a></span>]

...appears in the text box for both the English and Standard phrases when I try to edit either.
_______________________________________________

Also, a bug or another problem that I've found...

The system considers this url: http://classics.mit.edu/Browse/index.html to be an offsite download.

This is the result of clicking that link from the system, when off site downloads are turned off:

http://www.onlinedebate.net/forums/l...&id=80&catid=1

Internal Server Error (500)

This is the result of clicking that link from the system, when off site downloads are turned on:

http://www.onlinedebate.net/forums/l...&id=80&catid=1

Sorry, off-site downloads have been disabled.



Not sure why the internal server error is occurring.

AndrewD 08-09-2007 06:16 PM

Quote:

Originally Posted by apokphp (Post 1313764)
*edit*
Andrew, I think I may have fixed it, just by copy/pasting...can you check to see if it looks how it should look? If so, disregard the indented text below. I do have a 2nd challenge at the bottom of the post though.

Looks ok to me - not sure how this has happened .

Quote:

Originally Posted by apokphp (Post 1313764)
Also, a bug or another problem that I've found...

The system considers this url: http://classics.mit.edu/Browse/index.html to be an offsite download.

This is the result of clicking that link from the system, when off site downloads are turned off:

http://www.onlinedebate.net/forums/l...&id=80&catid=1

Internal Server Error (500)

This is the result of clicking that link from the system, when off site downloads are turned on:

http://www.onlinedebate.net/forums/l...&id=80&catid=1

Sorry, off-site downloads have been disabled.

Not sure why the internal server error is occurring.

This is weird. Are you by any chance using the internal LDM mod_rewrite facility? Looking at the code, I can only assume that the url is getting patched to something else.

AndrewD 08-09-2007 06:42 PM

Quote:

Originally Posted by obmob (Post 1313763)
Hmm... hello, finally installed the filmstrip, it works really good... but i was wondering if it's possible to move it below the linkbit and if there is a template i can edit to add some css style to it? :p
Thanks Andrew!

Those who take a little time to install and learn more about LDM can't deny is the best addon for vbulletin! :D

Glad to hear this is close to what you wanted.

Currently, any changes have to be made by editing the plugin itself, which may seem a bit hairy.

The placement is quite easy. Go to vb/admin/products and plugins/plugin manager. and look for the Links and Downloads Manager - Filmstrip plugin that is attached to the ldm_maindisplay_end hook. Edit this plugin. Find the line that reads:

Code:

        $includeinmain['postfeat'] .= '
You can move the feature around the page by changing 'postfeat'.

Going from the top of the page down, these are your options:

'precat'
'postcat'
'prefeat'
'postfeat'
'prelink'
'postlink'
'prestats'
'poststats'

I imagine you want 'postlink'.

The lines which build the table for the filmstrip are immediately below this line in the code - the html is embedded into the plugin. You can edit the css there. Be careful - this is similar but not identical to a template, and you need to keep the syntax valid.

minimalize 08-09-2007 08:51 PM

Quote:

Originally Posted by minimalize (Post 1311873)
Hi Andrew,

when i have a link like http://rapidshare.de/afile_name.mp3 the system tries to play the link with the mediaplayer. But this is the rapidshare url. Is there an option to turn the mediaplayer off for external links?

could you please have a look at this? its very important for me to get this working. half off the links in my ldm are rapidshare links!

obmob 08-09-2007 09:53 PM

Quote:

Originally Posted by AndrewD (Post 1313870)
Glad to hear this is close to what you wanted.

Currently, any changes have to be made by editing the plugin itself, which may seem a bit hairy.

The placement is quite easy. Go to vb/admin/products and plugins/plugin manager. and look for the Links and Downloads Manager - Filmstrip plugin that is attached to the ldm_maindisplay_end hook. Edit this plugin. Find the line that reads:

Code:

        $includeinmain['postfeat'] .= '
You can move the feature around the page by changing 'postfeat'.

Going from the top of the page down, these are your options:

'precat'
'postcat'
'prefeat'
'postfeat'
'prelink'
'postlink'
'prestats'
'poststats'

I imagine you want 'postlink'.

The lines which build the table for the filmstrip are immediately below this line in the code - the html is embedded into the plugin. You can edit the css there. Be careful - this is similar but not identical to a template, and you need to keep the syntax valid.

Oh, it is hairy! :eek:

Well, it's awesome, it was indeed the 'postlink' part, I don't know how this works, but is it possible to add a selectable menu in the filmstrip setting to select where we want to show it? Oh, and this kind of information is added to your wiki? It is quite useful. :D

Maybe for 2.2.9 or 2.3 :p

Thanks

hydn 08-09-2007 10:09 PM

Quote:

Originally Posted by AndrewD (Post 1312946)
Goodness, version 2.1.0.

You're in luck - that part of the code has not changed very much in two years :) Take a copy of the file include/local_links_include.php. Edit, and go to line 1078, which reads:

Code:

function record_hit($id, $url, $status, $size=0) {
        global $vbulletin, $links_permissions, $links_defaults;

        if ($links_permissions["can_bypass_hit_recording"]) {

Change to:

Code:

function record_hit($id, $url, $status, $size=0) {
        global $vbulletin, $links_permissions, $links_defaults;

        $when = TIMENOW-24*60*60*XXX;
        $vbulletin->db->query_write("
                DELETE FROM ".THIS_TABLE."linksdownloads
                WHERE usertime<'".$when."'
        ");

        if ($links_permissions["can_bypass_hit_recording"]) {

where XXX is the number of days you want to retain in the table, e.g. 30.

Worked like a charm!!!

Where/how can I send you a donation. This is wonderful support!

apokphp 08-09-2007 10:51 PM

Quote:

Originally Posted by AndrewD (Post 1313859)
This is weird. Are you by any chance using the internal LDM mod_rewrite facility? Looking at the code, I can only assume that the url is getting patched to something else.

No, that field is blank.

Ipuck 08-10-2007 03:11 AM

Quote:

You go to ldm/admin/hits. Then you use the pull down menus to select the dates of interest and 'username'. That produces aggregated information sorted by username. You then click on one of the usernames and you get a full tabulation of that user's activity.
The 2.2.8 have an option to search by username, but is not working properly I get an error. (I'm sure that will be fix with the final release, I don't care for now)

the 2.2.7 does not have the option to search by username.

I have two sites, one with 2.2.7 and one with 2.2.8 and I was looking at the one with 2.2.7 when I post the question, without realizing the you add that feature with the 2.2.8. I'll just wait until the final release is ready to start using it.

Thanks for your time :up:

AndrewD 08-10-2007 04:48 AM

Quote:

Originally Posted by minimalize (Post 1313961)
could you please have a look at this? its very important for me to get this working. half off the links in my ldm are rapidshare links!

I will try to get this sorted out at the weeked.

AndrewD 08-10-2007 04:48 AM

Quote:

Originally Posted by apokphp (Post 1314041)
No, that field is blank.

Do you mind if I take a detailed look at your site? I'll need admin privs to VB and LDM.

Daisy EE8 08-10-2007 07:29 AM

I have a problem and no clue whats going on. :(

After installing the product ist says that:
Quote:

Warning open_basedir is set to /srv/www/htdocs/web25/html/:/srv/www/htdocs/web25/phptmp/:/srv/www/htdocs/web25/files/:/srv/www/htdocs/web25/atd/ in your PHP installation
Please refer to the hack instructions for information on this setting
I think i have to contact my Admin-C to make some changes in the php.ini file - but what?
Cant get the problem here - whats this message saying to me?

AndrewD 08-10-2007 08:05 AM

Quote:

Originally Posted by Daisy EE8 (Post 1314238)
I have a problem and no clue whats going on. :(

After installing the product ist says that:


I think i have to contact my Admin-C to make some changes in the php.ini file - but what?
Cant get the problem here - whats this message saying to me?

This is only a warning, not necessarily an error. The "open_basedir" setting in your web site's php.ini file restricts the parts of your web site where it is possible for php scripts to read/write. It is a security setting. Your current setting is probably ok, especially if vBulletin is working fine. You will see if there are any difficulties if (e.g.) uploads fail or if you wanted to store files completely outside the web site's directories.

Daisy EE8 08-10-2007 02:19 PM

Ah ok - thanks for the help.
So everything should be fine. But:
If i head to the local_links_admin the side has a weird look. I cant see everything.
The "ok" button e.g. is empty - just a grey box.

Here is a screenshot of what I mean:

AndrewD 08-10-2007 03:08 PM

Quote:

Originally Posted by Daisy EE8 (Post 1314462)
Ah ok - thanks for the help.
So everything should be fine. But:
If i head to the local_links_admin the side has a weird look. I cant see everything.
The "ok" button e.g. is empty - just a grey box.

Here is a screenshot of what I mean:

Definitely not right! Do you want me to take a look? - if so send me a PM with site details and an admin username and password

minimalize 08-10-2007 06:11 PM

Quote:

Originally Posted by AndrewD (Post 1314172)
I will try to get this sorted out at the weeked.

ok thanks to you andrew


All times are GMT. The time now is 10:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07422 seconds
  • Memory Usage 1,878KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_code_printable
  • (29)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete