Printable View
Table Prefixes...
I was wondering about the table prefix I have, it's not the defaults.
Will this cause problems if I simply change them in the sql? Or do I have to also find them in the pages and adjust them there somewhere as well.
If so, could you please advise which files will need to be modified.
Finally, I'm running 1.3.7, not 1.3.8... Please tell me that won't be an issue... ;)
Ray
If you set up the prefixes as part of your initial install of Zen Cart, then you should be able to just run the sql statement from admin -> tools -> install sql patches without problems.Quote:
Originally Posted by RayDube
The same would also apply for the the pages which query the database.
I would appreciate it if people did not use my link exchange as a test to see whether they want to install it themsleves. This happened last night and its not welcome. Cheers.
Quote:
Originally Posted by Crooked_Halo
You could always set links manager so that only registered customers could submit links.
admin -> configuration -> links manager
On the Admin->Extras->Links Categories page the Sort Order works properly and the categories are displayed in sort order. However, when viewing the categories list from the catalog they are listed in alphabetical order.
I have looked in the configurations but have not been able to locate any options for this display.
Open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.phpQuote:
Originally Posted by Asgoroth
find the following line of code (around line 19):
and replace it with this line:PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_name");
PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lcd.link_categories_sort_order");
I tried this fix on 2 sitesQuote:
Originally Posted by clydejones
it fixes the sort order for the online catalog, but no in the admin area:(
both site also get this error when you click on "view all link" :no:
1054 Unknown column 'lcd.link_categories_sort_order' in 'order clause'
in:
[select lc.link_categories_id, lcd.link_categories_name, lcd.link_categories_description, lc.link_categories_image from link_categories lc, link_categories_description lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '1' order by lcd.link_categories_sort_order]
revert back to the original line of code and I'll check out the error message.Quote:
Originally Posted by fvb
This line of code will eliminate the error:Quote:
Originally Posted by clydejones
PHP Code:$categories_query = $db->Execute("select lc.link_categories_id, lcd.link_categories_name, lc.link_categories_sort_order, lcd.link_categories_description, lc.link_categories_image from " . TABLE_LINK_CATEGORIES . " lc, " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd where lc.link_categories_id = lcd.link_categories_id and lc.link_categories_status = '1' and lcd.language_id = '" . (int)$_SESSION['languages_id'] . "' order by lc.link_categories_sort_order");
thanks, I will try it tonight and let you knowQuote:
Originally Posted by clydejones
that fixed the error, and the sort order in the on line catalog :clap:Quote:
Originally Posted by clydejones
but did not fix the sort order in the admin/extras/links :huh:
The code as presently written (admin side) will order categories by sort order and name.Quote:
Originally Posted by fvb
What happens when you edit a category and change the sort order?
(When checking this, on 4 different sites, the categories are ordered by sort order)
when I edit a category and change the sort order, the order changes like it shouldQuote:
Originally Posted by clydejones
I was hoping to change the sort order of the admin/extras/links so the new ones that need approval would come up first
open admin/links.phpQuote:
Originally Posted by fvb
find this line of code (around line 556)
and replace with this linePHP Code:$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by ld.links_title, l.links_url";
PHP Code:$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by l.links_date_added DESC, ld.links_title, l.links_url";
[FONT=Times New Roman]Thanks, the code changed the sort order for the Admin/extras/links:bigups:[/FONT]Quote:
Originally Posted by clydejones
[FONT=Times New Roman]Should this be controlled by the settings in Admin/configuration/linksManager [/FONT][FONT=Times New Roman]Select links sort order. When I change the sort order number it does not change the sort order back and forth in the admin/extras/links[/FONT]
[FONT=Times New Roman]I guess I can keep 2 copies of links.php:blink:[/FONT]
Admin/configuration/linksManager Select links sort orderQuote:
Originally Posted by fvb
This setting controls the sort order of the links that are displayed within a category on the catalog side and has nothing to do with the sort order of the links in the admin panel (admin/extras/links).
ok, thanksQuote:
Originally Posted by clydejones
I'm getting a lot of link swap requests that look like this for there link back page
site.domain.com
does google see this as being the same domain as www.domain.com
or are these two completely different domains?
my guess is that they are different, and they are just trying to get one way links to there site
They could be linking to a "link farm site" and that will only show their link and not a reciprocal link with your site information.Quote:
Originally Posted by fvb
Hi Clyde
First of all - many thanks for your efforts.
I have just installed the Link Manager - latest version.
I have created categories back end but I am unable to create links within these categories. I can get the page to fill in the new link details but at the bottom wher I should submit - it says under options:
Status:
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /home/*****/public_html/shop/admin/includes/functions/html_output.php on line 333
using Database: MySQL 4.1.22-standard
PHP 5.2.5
Have you any idea what this problem might be?
ta
:o)
Hey Clyde
Forget that last post - I just found the answer in a previous post - turns out it was a php5.2 thing.
Anyway - like I said - top contribution - thanks mate!
:o)
Quote:
Originally Posted by tigerbalm
Hi Clyde
I just found out that when I approved a new link, it didn't show up. I then manually added a new link in the admin and approved it. However it still didn't show up. You previously helped me import a long list of links from phplinks. I can see all these links. Please advise. Thanks.
Make sure that the category(ies) those particular links belong to is/are also activated.Quote:
Originally Posted by dealbyethan.com
admin -> extras -> link categories click the green button on the category you wish to activate.
Hi,
Thanks for your quick response. The category is activated. But the newly added link is still not showing up.
I can see three active categories on your links page.Quote:
Originally Posted by dealbyethan.com
Accommodation & Travel
Shopping
Society & Community
if your new links are in any of these categories they should show up after approval.
If they are in a different category (one that is not activated) then they won't show up until the category is activated.
I added a new link in Accommodation & Travel and approved it, but when I go to the links page, it didn't show up. Very strange. What could cause this to happen?
I tried changing the newly added link to the second category, it didn't show up. I changed it to the third category, it did show up. But this is the wrong category. What's going on?
What link am I looking for?Quote:
Originally Posted by dealbyethan.com
I see 19 links in the third category (all on one page)
I see 27 links in the first category (on two pages)
I see 172 links in the second category (on 9 pages)
Title: ###### Hotel
URL: http://www.gaypedia.com/
Category: Accommodation & Travel
Description: GayPedia.com: Optimum information for
###### hotels and ############## hotels, when you
are looking for a complete visit for ######
or ############## entertainment places
I have put it back to the desired category but it does not show up.
Try this and see if it makes a difference:Quote:
Originally Posted by dealbyethan.com
just unzip the file and upload the entire admin folder to your server.
Attachment 4085
I uploaded the file into the admin folder. But nothing has changed. I still can't add and show a link.
Quote:
Originally Posted by dealbyethan.com
check your PM
Is there a way to set the number of links to be listed per page? I would like to limit it to 5 or so per page to decrease load time.
Thanks!!!
it is set up to display the maximum number of results which is set inQuote:
Originally Posted by MeltDown
admin -> configuration -> maximum values -> Search Results Per Page
The default value for this setting in Zen Cart is 20.
To make the change you are looking for would require modifying the configuration settings in admin -> configuration -> links manager as well as rewriting several lines of code in the links manager files.
Thanks Clyde - No need to do anything drastic such as rewriting, this piece of advice did the trick: admin -> configuration -> maximum values -> Search Results Per PageQuote:
Originally Posted by clydejones
Clyde, I have modified this mod to be used to upload recipes. No images are necessary for the recipes, so can you tell me how to turn off the message stack error "Warning: no file uploaded"? See here http://www.ncwheatmontanacoop.com/or...e=links_submit
I got rid of the default banner message but can't figure out how to get rid of the other one.
Also, is there a way for the recipes to keep their formatting without me having to go into the admin and format it with HTML? It's all coming out one big blob of text with no line breaks. Our recipe submitters don't all know HTML.
Thanks!
Amy,Quote:
Originally Posted by Doodlebuckets
I'm not sure which files you've modified (and/or whether you changed the names of the files) but I can give you a general outline of what you need to do based on the original Link Manager file names and locations.
first you'll need to modify includes/modules/pages/links_submit/header_php.php
at about line 14 delete/comment out the following line of code:
Next delete the folllowing section of code beginning at around line 81 - 98Code:require(DIR_WS_CLASSES . 'upload.php');
save the file and upload to your server.Code:// BOF Upload an image when form field is filled in by user
if ($links_image = new upload('links_image_url')) {
$links_image->set_destination(DIR_WS_IMAGES . LINK_IMAGE_DIRECTORY);
if ($links_image->parse() && $links_image->save()) {
$links_image_name = LINK_IMAGE_DIRECTORY . $links_image->filename;
}
if ($links_image->filename != '') {
$db->Execute("update " . TABLE_LINKS . "
set links_image_url = '" . $links_image_name . "'
where links_id = '" . (int)$links_id . "'");
}else { // Use default image if form field is left blank
$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');
}
}
Next open includes/modules/YOUR_TEMPLATE/link_listing.php
Find the following section of code at around line 73 - 76
replace this section with the following code:Code:if (DISPLAY_LINK_DESCRIPTION_AS_LINK == 'true') {
$lc_text = '<a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_title'] . '</a><br /><a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_description'] . '</a>';
} else {
$lc_text = '<a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_title'] . '</a><br />' . $listing_query->fields['links_description']; }
Save the file and upload to your server.Code:if (DISPLAY_LINK_DESCRIPTION_AS_LINK == 'true') {
$lc_text = '<a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_title'] . '</a><br /><a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . nl2br($listing_query->fields['links_description']) . '</a>';
} else {
$lc_text = '<a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_title'] . '</a><br />' . nl2br($listing_query->fields['links_description']); }
Let me know if you need additional assistance.
Clyde, I did not change any file name! I didn't want to work that hard and I probably would have broken it! Your fix worked perfectly. I am going to tinker with the display page and see if I can get it to look like I need it to. I'll let you know if I booger any thing up or need some help :o) Thanks! Your influence is far and wide :D
Quote:
Originally Posted by clydejones
By display page I'm guessing you mean the page with the categories/imagesQuote:
Originally Posted by Doodlebuckets
I'd suggest that you make the images all the same size height x width (i.e. the default for links manager for category images is 80 x 80) doin this will insure that all the images line up correctly and you shouldn't get the gaps that are showing up now.
Just a suggestion.
Yep, that's next on my list. I have tried to get the page to display as I want it to, but I don't know how to get what I need, so if you could teach me how that would be great!Quote:
Originally Posted by clydejones
http://www.ncwheatmontanacoop.com/or...ain_page=links
For the above page (and all others eventually), I would like where it says "Recipes" in bold, just above "Our Members' tried and true recipes!", I want it to say the category title...in this case, "Yeast Breads".
Next, I need for the titles to be non-clickable, larger font, and in bold. Also, the line at the top of the page, if that could show up between each Recipe to separate them, that would be great.
I have gone around and around with this, but this is a part of code that I don't yet understand. I know this is not a Links Manager application, but I sure appreciate your help! Maybe when it's all done, you could upload it as another contrib...
Quote:
Originally Posted by Doodlebuckets
Not a problem.
Lets do the easy part first (Also, the line at the top of the page, if that could show up between each Recipe to separate them, that would be great.)
open includes/templates/YOUR_TEMPLATE/css/links.css
find the following declarations:
Replace them with:Code:.productListing-even .linkListing-data{padding:5px;font-size:1em;;background:ivory;color:#000;}
.productListing-odd .linkListing-data{padding:5px;font-size:1em;color:#000;}
Save the file and upload to your serverCode:.productListing-even .linkListing-data{padding:5px;font-size:1em;;background:ivory;color:#000;border-top:1px solid #000;}
.productListing-odd .linkListing-data{padding:5px;font-size:1em;color:#000;border-top:1px solid #000;}
Now the next one (I would like where it says "Recipes" in bold, just above "Our Members' tried and true recipes!", I want it to say the category title...in this case, "Yeast Breads".)
open includes/modules/pages/links/header_php.php
find the following section of code lines 27 - 32
replace this section with the following:Code:if ($display_mode == 'links') {
$breadcrumb->add(NAVBAR_TITLE, zen_href_link(FILENAME_LINKS, '', 'NONSSL'));
$breadcrumb->add($link_categories_query->fields['link_categories_name']);
} else {
$breadcrumb->add(NAVBAR_TITLE);
}
save the file and upload to your serverCode:if ($display_mode == 'links') {
$breadcrumb->add(NAVBAR_TITLE, zen_href_link(FILENAME_LINKS, '', 'NONSSL'));
$breadcrumb->add($link_categories_query->fields['link_categories_name']);
$subtitle = '<h2>' . $link_categories_query->fields['link_categories_name'] . '</h2>';
} else {
$breadcrumb->add(NAVBAR_TITLE);
}
Now open includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.php
find at around line 105:
<?php echo HEADING_TITLE; ?>
immediately below this line add the following:
<?php echo $subtitle; ?>
Save the file and upload to your server
Now the last one (I need for the titles to be non-clickable, larger font, and in bold.)
open includes/templates/YOUR_TEMPLATE/css/links.css
add the following declaration:
h4.linkTitle {
font-size: 1.1em;
font-weight:bold;
}
Save the file and upload to your server
Now open includes/modules/YOUR_TEMPLATE/link_listing.php
find the following line of code at around line 76
replace this with the following:Code:$lc_text = '<a href="' . zen_get_links_url($listing_query->fields['links_id']) . '" target="_blank">' . $listing_query->fields['links_title'] . '</a><br />' . $listing_query->fields['links_description']; }
Save the file and upload to your server.Code:$lc_text = '<h4 class="linkTitle">' . $listing_query->fields['links_title'] . '</h4><br />' . $listing_query->fields['links_description']; }
I think this will give you the look you wanted (or at least close to it.)
http://www.ncwheatmontanacoop.com/or...ain_page=links
Something broke, but I dunno what. Thanks for all the help!
Nevermind! I replaced the wrong line of code in link_listing.php! I appreciate everything!!!Quote:
Originally Posted by Doodlebuckets
Glad to help!Quote:
Originally Posted by Doodlebuckets
Sigh, there's one more thing: Status:Quote:
Originally Posted by clydejones
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in C:\Sites\Single18\kennybranch\webroot\order\admin\includes\functions\html_output .php on line 333
I reuploaded my admin folder but still get this error. Did I do something that caused this when I changed some of the defines?
The code in line 333 isQuote:
Originally Posted by Doodlebuckets
if that helps...Quote:
if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);
in what part of admin is this error showing up?Quote:
Originally Posted by Doodlebuckets
Sorry! on the admin links (new link add) page ieQuote:
Originally Posted by clydejones
http://www.ncwheatmontanacoop.com/or...e=1&action=new
I can't really tell without knowing what you changed in the file.Quote:
Originally Posted by Doodlebuckets
Can you zip up the file and post it here so I can take a look.
Hello:
Recently i upgrade the link manager but i have a problem.
I have a shop whit two languages English and Spanish and a see only the box links in the english language no in the spanish, i think copy all files in the two diferent languages and i comprobate then and i think all is right.
Any Ideas? Your help will be very aprecited.
http://www.expomueble.es
Thank you very much
Quote:
Originally Posted by jmeca
This should help:
Just unzip the file, make sure to change the YOUR_TEMPLATE folders to match the name of your custom template (classic)
upload the entire includes folder to your server.
Attachment 4206
Hello Clide:
Thank you very much for you help and your time, i copy all files lñike you say me in the includes directory but sill the problem.
I can't see the links box in the spanish language, i don't what is the problem.
Another question. Can I install your module in my shop http://www.expomueble.es whit two languages althoug i traduce the spanish front?
Thank You very much for you help.:yes:
Yes by all means go ahead and translate the files.Quote:
Originally Posted by jmeca
You may need to update the links in admin -> extras -> links
and you may need to update the categories in admin -> extras -> Link Categories
Here are the language files for the admin
Attachment 4209
Hello Clyde:
Thak you very much for your help i tried todo whit the admin and now work ok.
I refer before the module Order Step if can i install in my shop whit two languages?
Thank you very much
You should be able to do that.Quote:
Originally Posted by jmeca
There is only on file that would need to be translated.
includes/languages/english/extra_definitions/order_steps_defines.php
Just copy the file to:
includes/languages/spanish/extra_definitions/order_steps_defines.php
Save the file and upload to your server.
What file are you referring to? I only changed the defining text.Quote:
Originally Posted by clydejones
You said you were getting this error on the admin side - Where/When exactly is this error occurring?Quote:
Originally Posted by Doodlebuckets
Catchable fatal error: Object of class queryFactoryResult could not be converted to string in C:\Sites\Single18\kennybranch\webroot\order\admin\includes\functions\html_output .php on line 333
http://www.ncwheatmontanacoop.com/or...e=1&action=newQuote:
Originally Posted by clydejones
It's on this page, where I am trying to make an entry via the admin.
No login information so I can't check.Quote:
Originally Posted by Doodlebuckets
Are you using ZC 1.3.7 or 1.3.8
PHP version?
check out this thread:
www.zen-cart.com/forum/showthread.php?t=74677
Clyde, the modified admin html_output file fixed it! Thanks for looking into this. I searched and searched but couldn't fix the answer. You da bes :o)Quote:
Originally Posted by clydejones
Glad everything worked out.Quote:
Originally Posted by Doodlebuckets
Hy Clyde:
I try the link manager but when i go to Admin->Extras->Links->New Link a formulary to add new link open ok, but no button create or update de the new link.
Is possible i forgot to up and archive or something like this?
Is posible to to desactivate send new links for customer only send for the admin?
Because i wnat only put my own links.
Regards and thank you very much.
Just download Link Manager 3.4.1. Found two folders New install and Upgrade. Which one should I install? I'm just not sure.
Depends on whether you are installing Links Manager for the first time or if you are upgrading from a previous version.Quote:
Originally Posted by miles
If you are installing Links Manager for the first time then you'll want to install the files from the new install folder and run the install_links_manager.sql
If you are upgrading from a previous version then you'll want to install the files from the upgrade folder and run the update_links_manager.sql
Check your PMQuote:
Originally Posted by jmeca
In links_submit.css I try to make the links help popup background to white because I have a dark background. So I did this.
But nothing's change. Any idea?Code:#popupLinksHelp {
background: #FFF;
background-image: none;
}
Try adding it to your stylesheet.cssQuote:
Originally Posted by miles
Thanks Clyde! Need to clear cache too.
Clyde, I was getting probably 100 spam link submittals in my directory each week and I just added CAPTCHA and I've blocked the rascals! :clap: It was the same one time and time again. I had to fiddle around withe a_berezin's mod though because the link_submit part of it is not up to date with the changes you've made. Just thought I'd let you know...I'd be happy to post the code here if anyone wants to add it as well.
Quote:
Originally Posted by Doodlebuckets
I would love that, please post it
OK, I've just updated the whole post and attached here. Make sure to rename the YOUR_TEMPLATE folders to match your template. The files that I had to change were the header.php file in includes/modules/pages/links_submit folder and the tpl_links_submit_default.php file in includes/templates/YOUR_TEMPLATE/templates folder.Quote:
Originally Posted by fvb
Thanks, I will check it outQuote:
Originally Posted by Doodlebuckets
Quote:
Originally Posted by Doodlebuckets
This fix works with a_berezin's capcha mod. It updates the link_submit files to work with the most recent version of Links Manager(3.4.1).Quote:
Originally Posted by fvb
Unzip the file, rename the YOUR_TEMPLATE folder (includes/templates/YOUR_TEMPLATE) to match the name of your custom template.
upload the entire includes folder to your server.
Make sure you have already installed the captcha mod.
Attachment 4275
Hello,
I am new to Zen cart and am trying to install the link manager add on. When I past the code into the query filed and press send I receive the following error msg - Precondition Failed
The precondition on the request for the URL /store/admin/sqlpatch.php evaluated to false.
Since this is my first attempt at an add on I am sure that I am doing something crazy here, but would appreciate guidance.
Thank you,
Jennifer
This is the first time I've come across this error. It is most likely connected with mod_security settings.Quote:
Originally Posted by jgardner
You'll have to check with your hosting company because essentially your web server thinks your browser didn't send something it should have.
Quick question:
How do I quickly locate new submitted links? I received emails telling me a link has been submitted on my website but I don't know how to locate it. Please advise. Thanks.
look in admin -> extras -> linksQuote:
Originally Posted by dealbyethan.com
Check the status of your links - if any of them have a yellow highlighted button they are the ones needing approval.
Is this the quickest way to locate it? What if I have hundreds of pages of links?
Individual links have to be approved before they show up on your links page, so you'll have to access admin -> extras -> links in order to approve them.Quote:
Originally Posted by dealbyethan.com
This way you can judge whether links submitted to you are legitimate links that you would want to display or spam.
Quote:
Originally Posted by dealbyethan.com
the code change on page 102 post 1014 helped me for the same problemQuote:
Originally Posted by clydejones
Hi,
Thanks for your suggestion. Are you saying that I should work out the sort order of links by displaying the newest pending links first on the admin page? I went to the page you told me to look at. Is this what I am supposed to do? Please advise.
open admin/links.php
find this line of code (around line 556)
and replace with this lineCode:$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by ld.links_title, l.links_url";
##############################___Code:$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_status from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on l.links_id = ld.links_id where ld.language_id = '" . $_SESSION['languages_id'] . "'" . $search . " order by l.links_date_added DESC, ld.links_title, l.links_url";
yes, thats what I did and it works greatQuote:
Originally Posted by dealbyethan.com
Hi, I added the links manager to my site, thank you for this add on! I want to take the box off my page though, and just have "View All Links" without "submit link." I would also like to change the "view all links" text to "resources." I cannot figure out how to do this! Can you help?
Thanks!
www.theshoppingboutique.com
For part 1 try this fix:Quote:
Originally Posted by abcoombe
Attachment 4358
Unzip the file:
run this sql patch using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)
copy-and-paste the code into the query field and press 'Send'.
rename the YOUR_TEMPLATE folder to match the name of your custom template
upload the entire includes folder to your server.
In admin -> configuration -> links manager
Links Box - Display Links in Sidebox (set to false)
Links Box - Display Submit Link (set to false)
------
For part 2:
open includes/languages/english/extra_definitions/YOUR_TEMPLATE/links_manager_defines.php
find the following:
define('BOX_INFORMATION_VIEW_ALL_LINKS', 'View All Links');
Change the highlighted portion to whatever you need.
Save the file and upload to your server.
Clyde,
Thank you so much for your help. It worked perfectly, except the "Resources" link is now way below my other items in my information column. Can I change that?
www.theshoppingboutique.com
It sits in its own sidebox and you've modified that sidebox so that the heading has been eliminated. (That's why it appears as it does.)Quote:
Originally Posted by abcoombe
Okay, apparently I'm confused about the difference between a sidebox and a link that appears in my information list. Is there a way to alter what I have to make it part of that list, or do I need to be using something different? Sorry I'm being difficult, I'm in a little over my head...
Thanks!
If you want just a link in your information box then you need to do the following:Quote:
Originally Posted by abcoombe
open includes/modules/sideboxes/YOUR_TEMPLATE/information.php
add the following where you wish the link to appear
$information[] = '<a href="' . zen_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_VIEW_ALL_LINKS . '</a>';
Save the file and upload to your server.
Thank you so much Clyde, I appreciate your help. It's amazing to me that you just know where to find everything!
If you are in the Springs, we are only about 20 minutes north of you! I'm in Castle Rock today. I'm originally from the Springs, so it's nice to see it on here!
Glad you got it sorted.Quote:
Originally Posted by abcoombe
Working with Zen Cart and answering questions on the forum will do that.
There a few coloradians on the forum.
Hi Clyde,
I hope you can help me resolve this problem. I've been trying to install link manager with Captcha but haven't been successful.
I am running zen 1.3.8a using captcha v 2.8. I only want to use captcha on the link submit page. So have selectively uploaded the files:
fonts
includes/
modules/pages/links_submit/header_php.php
templates/my_template/templates/tpl_links_submit_default.php
all other files associated with captcha including sql patch.
When I run the captcha_test.php it works. When I click on the submit link page, I get a blank screen.
So I reverted to original files. Then started to install again and test.
When tpl_links_submit_default.php was uploaded, the submit page is still there without the captcha.
When links_submit/header_php.php was uploaded, the submit page dissappears.
On Admin, all other pages have been turned to false for captcha except for the submit link page.
Can't figure out what the problem is.
I have used the link submit fix posted here to update the tpl and header files but it didn't fix it. I still get a blank screen.
Any ideas what is causing it?
try this:Quote:
Originally Posted by Decostyle
Just unzip the file and upload the entire includes folder to your server.
Attachment 4387
Hi Clyde,
Added your contribution. Mostly OK. However, unable to get banner image to display or load.
I am wondering if it is a write permission problem. But don't know what file/ s should be altered.
R u able to help?
Gairneybank
URL for your siteQuote:
Originally Posted by gairneybank
My site urlQuote:
Originally Posted by clydejones
http://www.messageonabottle.biz/zencart/
I just submitted a test link. It appears that the banner image option is working properly.Quote:
Originally Posted by gairneybank
Check the link in admin -> extras -> links
Your default image should show up.
Quote:
Originally Posted by clydejones
Hi Clyde,Quote:
Originally Posted by clydejones
Yes it has worked with the default image. However, when you try to submit a banner image you get the following: Error: destination not writeable.
Also if you try to add the image url from admin, it displays there correctly, but not in the online catalogue.
Gairneybank
Further to: Whilst your submission displays the default image online, the default image does not display in admin.Quote:
Originally Posted by gairneybank
make sure images/links_image has a cmod of 777 (this will make the directory writable.Quote:
Originally Posted by gairneybank
Hello Clyde!Quote:
Originally Posted by clydejones
Thank you!!! It worked!! :clap: I do not know much about PHP but when I looked at the difference of the two files, it seems that the only thing changed was an added carraige to line 30:
// EOF Captcha
if (isset($_GET['action']) && ($_GET['action'] == 'send')) {
Is this something that affects PHP coding? Just curious.