Link Manager 3.0 Support Thread

[clydejones]

Retesting viewing links. Clicking on view all links brings up category descriptions, clicking on one of them results in:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, MAX_DISPLAY_LINKS' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '8'order by ld.links_title limit -0, MAX_DISPLAY_LINKS]

Page numbering of the page is wacked: -4 -3 -2 -1 0

open includes/templates/YOUR_TEMPLATE/tpl_links_default.php

at around line 100 replace the existing line of code with the following

    $listing_sql = "select " . $select_column_list . " l.links_id from " . TABLE_LINKS_DESCRIPTION . " ld, " . TABLE_LINKS . " l, " . TABLE_LINKS_TO_LINK_CATEGORIES . " l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '" . (int)$_SESSION['languages_id'] . "' and l2lc.link_categories_id = '" . (int)$current_category_id . "'" . "order by $sortorder"; 

[Jeffey]

Thanks, unfortunately those are correctly set.

Just to make sure I just reinstalled everything again including the Captcha fix files as replacements and then ran the SQL which indicated the first one ran as written.

No changes to issues.

EDIT: Cross posted! Checking your next message now

[clydejones]

Thanks, unfortunately those are correctly set.

Just to make sure I just reinstalled everything again including the Captcha fix files as replacements and then ran the SQL which indicated the first one ran as written.

No changes to issues.

EDIT: Cross posted! Checking your next message now

You can allways PM me.

[Jeffey]

No change with edited line.

Would you rather I PM? Grateful for the help so what ever works best for you.

[clydejones]

No change with edited line.

Would you rather I PM? Grateful for the help so what ever works best for you.

Sure send me a PM

[Jeffey]

Thanks Clyde not only for the time here but also for being so willing to go offline and help me with a big chunk of your day!

Thought it certainly worthy of a public thanks though it's easy to see your dedication to the community

I'm making progress and got things working.
Problem with this kind of thing is that I'm of little help to others behind me since I tried so many things/installs/removals that I can't pinpoint what fixed the issue but only that it's fixed.

Thanks again for all of the over the top assistance, it kept me focused.

[Firedkm]

Clyde, I finally had someone do a link on my site. Now when I go into the links manager and click on the check link i get this error...
Link Check Result: Error Reading URL

Now if I copy and past the link into the web browser the link works fine.

Also the actual link on my site will work too.

Dale

[clydejones]

Clyde, I finally had someone do a link on my site. Now when I go into the links manager and click on the check link i get this error...
Link Check Result: Error Reading URL

Now if I copy and past the link into the web browser the link works fine.

Also the actual link on my site will work too.

Dale

The check link button is looking for your site (the Reciprocal link on the other web site)

check you setting for:

admin -> configuration -> links manager -> Links Check Phrase

[Firedkm]

That makes sense. Thank you Clyde

[davewest]

Hi Clyde,

I'm still using your mod with no problems, but I have something you or your readers may be interested in adding.

I wanted to do this ever seance I installed my link trade page on my classified site. That one use only web page thumbnails for the link image and some other interesting things. The easiest one to bring over was the web page thumbnail. Some easy edits and it works! I didn't take time to set up a better way of controlling the use of thumbnails, but I did set it up so that having a default image in Configuration ->Links Manager ->Default Link Image, will use the default and not the thumbnail shot. So to turn this on, leave the default image blank!

In includes\modules\YOUR_TEMPLATE\link_listing.php find line 82

$lc_text = TABLE_HEADING_LINKS_IMAGE;

and change it to this one

//$lc_text = TABLE_HEADING_LINKS_IMAGE;
$lc_text = '<div valign="top" class="thumbnail"><img src="http://open.thumbshots.org/image.pxf?url=' .zen_get_links_url($listing_query->fields['links_id']).'" style="vertical-align: middle;" border="1" width="120" height="90" alt="Thumbnail">&nbsp;</div>';

next in includes\modules\pages\links_submit\header_php.php find line 91

}else { // Use default image if form field is left blank

and change it to this one

          }else { // Use default image if form field is left blank
          //$links_image_name = DEFAULT_LINK_IMAGE;
                     if (DEFAULT_LINK_IMAGE !='') {
                     $links_image_name = LINK_IMAGE_DIRECTORY . DEFAULT_LINK_IMAGE; 
             $db->Execute("update " . TABLE_LINKS . "
                         set links_image_url = '" . $links_image_name . "'
                          where links_id = '" . (int)$links_id . "'");
                $messageStack->add_session('header', WARNING_DEFAULT_FILE_UPLOADED, 'success');    
                }else {    // no default image, use thumbnail of site
                     $links_image_name = '';
             $db->Execute("update " . TABLE_LINKS . "
                         set links_image_url = '" . $links_image_name . "'
                          where links_id = '" . (int)$links_id . "'");
                $messageStack->add_session('header', DEFAULT_THUMBNAIL, 'success');        
                }

next in includes\languages\english\extra_definitions\YOUR_TEMPLATE\links_manager_defines .php add this line to the bottom.

define('DEFAULT_THUMBNAIL', 'Your web site Thumbnail will be used for this link.');

And lastly, you need to register with thumbshots.org it's free, and you need to place a link back to them on your site. I did mine in the includes\languages\english\html_includes\YOUR_TEMPLATE\define_links.php page.

That's all there was to it, if they upload a image, no thumbnail, if you have a default image, no thumbnail, no image, thumbnail is used. In admin, if you edit the submitted link and add you default image there (links_image/links_default.jpg), then that will turn off thumbnails for that link. Same way, deleting the image link will turn on the thumbnail shot.