vb.org Archive

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

webgeek247 04-22-2008 07:46 PM

Another thing I just seen that vbseo also have http://www.vbseo.com/wiki/vBSEO_Comp...k:Downloads_II

Not exactly sure what it does, will have to look into it more. Though I wonder if that rewrite rule format is something to go by to get ldm to work with vbseo

Rouzbeh1 04-22-2008 09:16 PM

Quote:

Originally Posted by AndrewD (Post 1496669)
Sorry, I'd missed the capitals and spaces. Here's a modified version of includes/local_links_include.php

this solved the caps and spaces problem. thanks
Quote:

Originally Posted by AndrewD (Post 1496669)
If you set seo_friendly to 2, you need a different set of mod_rewrite rules. These are the ones I am using as test. If you also set seo_title, then you need to replace local_links in the first part of each rule by your seo_title:

Code:

RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)$        $1local_links.php?catid=$2 [R,L]
RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)/([0-9]+)$                $1local_links.php?catid=$2&linkid=$3 [R,L]
RewriteRule (.*)local_links/jump/c-[^/]+-([0-9]+)/([0-9]+)$        $1local_links.php?action=jump&catid=$2&id=$3 [R,L]
RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)$        $1local_links.php?action=play&catid=$2&linkid=$3 [R,L]
RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)(\?page=[0-9]+)$        $1local_links.php?catid=$2&page=$3        [R,L]
RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)(\?page=[0-9]+)$        $1local_links.php?action=play&catid=$2&linkid=$3&page=$4        [R,L]


i tried it in many different ways but it didn't work

webgeek247 04-22-2008 09:53 PM

Andrew,

I tried to get help on vbseo to get the ldm alphanumeric urls to work with vbseo, but it turns out that even with vbseo turned off they still dont work. You check out that vbseo thread if you like. Im totaly baffled by it now heh

Aye at least the ldm numeric urls works with vbseo. Would be great to get the alphanumeric urls to work properly though

AndrewD 04-23-2008 03:29 AM

Quote:

Originally Posted by Rouzbeh1 (Post 1496846)
i tried it in many different ways but it didn't work

Are you using the mod_rewrite approach? I had to debug things by turning on logging (log level 2) and then watching what was happening.

I have an English board working fine with the rules I posted.

GrendelKhan{TSU 04-23-2008 04:40 AM

great job as usual andrew :D

found some bugs (at least on mine)
- 2.2.9 RC
- vb3.7.0 RC1

1)
-- cat_icon_new
-- cat_icon_new
-- subcat_icon
still not showing up. :( its not reading the "forums/" folder and gets an error (doubles up the forums directory) if you put it in manually eg:
Quote:

The following settings are invalid:
cat_icon (/forums/linksdownloads/icons/xxxxxxxxx .jpg) Cannot find icon 'htt p://www. xxxxx. com/forums/forums/linksdownloads/icons/music-to-frag-to-Clan-TSU.jpg' - specify relative to forum directory or use full url
- ldm no cat icons

2) template_linkbit (short: title+thumb): TITLE is not appearing. :(
bug (at least for me): ldm no title

3) also, would be nice to see a bullet or something next to the items in the statistics. (or as an options).

too hard to read individual items otherwise. (don't know where one starts and another ends).

- LDM (right side stats)


still awesome stuff. :)

itsblack 04-23-2008 05:19 AM

Hi Andrew, I have installed 2.2.9 RC. Thank you.

I got mysql error when I search the multiple words such as "Cambridge Companions" with the option "all words" or "exact phrase". There's no problem with the option "any word".

PHP Code:

Invalid SQL:

        
SELECT
            link
.linkid AS linkidlink.linkname AS linknamelink.linkdoi AS linkdoi,
            
link.linkuserid AS linkuseridlink.linkusername AS linkusername,
            
link.linkurl AS linkurllink.linkimg AS linkimg,
            
link.linkimgthumb AS linkimgthumblink.linkimgthumbsize AS linkimgthumbsizelink.linkforum AS linkforum,
            
link.linkdesc AS linkdesclink.numrate AS numratelink.totrate AS totrate,
            
link.linkhits AS linkhitslink.linksize AS linksizelink.linkstatus AS linkstatus,
            
link.linkdate AS linkdatelink.linkmoderate AS linkmoderatelink.linkmoddate AS linkmoddate,
            
link.linkreviewfreq AS linkreviewfreq,
            
ltoc.catid AS linkcatidltoc.displayorder AS linkdorder
            
            
ltoc2.catid AS linkcatid2
            
            
lkeys.keyword AS linkkey
            FROM local_linkslink 
AS link
            LEFT JOIN local_linksltoc 
AS ltoc ON link.linkid ltoc.linkid
            
            
            
    
            LEFT JOIN local_linksltoc 
AS ltoc2
            ON link
.linkid ltoc2.linkid
        
            LEFT JOIN local_linksltok 
AS ltok
            ON link
.linkid ltok.linkid
            LEFT JOIN local_linkskeys 
AS lkeys
            ON ltok
.keyid lkeys.keyid
         WHERE link
.linkforum NOT IN (0)  AND (link.linkid IN () OR link.linkid IN (-1,355,425,427,428,429,430,431,436,439,483,673,723,801,1051,1063,1079,1118,1129,1159,1161,1160,1179,1180,1321,1371,1410,1578,1579,1580,1584,1593,1594,1595,1646,1687,1771) OR link.linkid IN (-1)) 
            
ORDER BY   linkdate DESClinkname ASClinkcatid ASC;

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ') OR link.linkid IN (-1,355,425,427,428,429,430,431,436,439,483,673,723,801,1051' at line 28
ERROR       
1064 

My mysql version is 5.0.45. Now what can I do?

Rouzbeh1 04-23-2008 02:48 PM

Quote:

Originally Posted by AndrewD (Post 1497000)
Are you using the mod_rewrite approach? I had to debug things by turning on logging (log level 2) and then watching what was happening.

I have an English board working fine with the rules I posted.

i used both vbseo AND also mod_rewrite
i have also tested it on my test board with only mod_rewrite + ldm internal function
none of them worked

AndrewD 04-23-2008 06:34 PM

Quote:

Originally Posted by itsblack (Post 1497046)
Hi Andrew, I have installed 2.2.9 RC. Thank you.

I got mysql error when I search the multiple words such as "Cambridge Companions" with the option "all words" or "exact phrase". There's no problem with the option "any word".

My mysql version is 5.0.45. Now what can I do?

Interesting, that bug has been there for quite some time but has only just been hit. I think this version of local_links_search.php fixes the bug.


I'm now going to have to see how to deal with the 3.6.10/3.7.0RC4 changes.

[edited: attachment removed - now in the release code]

AndrewD 04-23-2008 07:09 PM

Quote:

Originally Posted by Rouzbeh1 (Post 1497300)
i used both vbseo AND also mod_rewrite
i have also tested it on my test board with only mod_rewrite + ldm internal function
none of them worked

This is the relevant section of my http-vhosts file

Code:

<VirtualHost *:80>
        ServerName vb37
        DocumentRoot "r:/websites/vb37"

#        RewriteLog "C:/Program Files/Apache Software Foundation/Apache2.2-ssl/logs/rewrite.log"
#        RewriteLogLevel 2

        RewriteEngine on
#        RewriteEngine off

# - normal mode

#        RewriteRule (.*)local_links/links/([^0-9].+)$                                                $1$2                                                                                                        [R,L]
#        RewriteRule (.*)local_links/links/([0-9]+)$                                                        $1local_links.php?catid=$2                                                                [R,L]
#        RewriteRule (.*)local_links/links/([0-9]+)/([0-9]+)$                                $1local_links.php?catid=$2&linkid=$3                                        [R,L]
#        RewriteRule (.*)local_links/jump/([0-9]+)/([0-9]+)$                                        $1local_links.php?action=jump&id=$2&catid=$3                        [R,L]
#        RewriteRule (.*)local_links/play/([0-9]+)/([0-9]+)$                                        $1local_links.php?action=play&catid=$2&linkid=$3                [R,L]
#        RewriteRule (.*)local_links/links/([0-9]+)(\?page=[0-9]+)$                        $1local_links.php?catid=$2&page=$3                                                [R,L]
#        RewriteRule (.*)local_links/play/([0-9]+)/([0-9]+)(\?page=[0-9]+)$        $1local_links.php?action=play&catid=$2&linkid=$3&page=$4        [R,L]

# -- extended mode

        RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)$                                        $1local_links.php?catid=$2                                                                [R,L]
        RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)/([0-9]+)$                $1local_links.php?catid=$2&linkid=$3                                        [R,L]
        RewriteRule (.*)local_links/jump/c-[^/]+-([0-9]+)/([0-9]+)$                        $1local_links.php?action=jump&catid=$2&id=$3                        [R,L]
        RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)$                        $1local_links.php?action=play&catid=$2&linkid=$3                [R,L]
        RewriteRule (.*)local_links/links/c-[^/]+-([0-9]+)(\?page=[0-9]+)$        $1local_links.php?catid=$2&page=$3                                                [R,L]
        RewriteRule (.*)local_links/play/c-[^/]+-([0-9]+)/([0-9]+)(\?page=[0-9]+)$        $1local_links.php?action=play&catid=$2&linkid=$3&page=$4        [R,L]
        Options +ExecCGI
</VirtualHost>

Maybe you can post what you have tried?

Alfa1 04-24-2008 12:49 AM

How can I:
- get rid of the 'my recent LDM hits' box on profile?
- get rid of the mentions of LDM in the 'About me'tab on profile?
- change the phrase of 'My recent LDM entries'?
- add a section on the 'statistics' tab on profile to display: 'total documents', 'total video's' and 'total audio'? Note that video, documents and audio are separate categories in my LDM.

Does the swf uploader use a different url, than local_links.php?action=addlink ? I was just wondering, because I don't get it to work from local_links.php?action=addlink


All times are GMT. The time now is 08:06 AM.

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.02810 seconds
  • Memory Usage 1,802KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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