http://www.gossamer-threads.com/forum/ en-us gforum@gossamer-threads.com Sat, 18 May 2013 14:01:29 GMT Gossamer Forum by Gossamer Threads, Inc. http://www.rssboard.org/rss-specification http://static.gossamer-threads.com/forum/images/gforum-logo.png http://www.gossamer-threads.com/forum/ 50 50 http://www.gossamer-threads.com/forum/General_C8/Chit_Chat_F26/Benefits_of_Online_Supplement_Stores_P314984/?page=unread#314984 N/A N/A May 18, 2013, 1:40 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bpatricktarget%5D_Sort_By_Functionality_P314982/?page=unread#314982 Hi, I *think* you can sort categories by doing: page.cgi?g=Category_Name/Foo_Bar;sb=The_Field;so=ASC Hope that helps Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates aa202d1aeaa3a5a077e92635e0114afd May 16, 2013, 11:36 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Sort_By_Functionality_P314981/?page=unread#314981 Hi Andy, Is there anyway to use the sort functionality in the category page in the url? I have a sort by dropdown on the page and it would be ideal to have this work through the url. They can sort by the title and others. Is this possible? 04433dd9d540aff2576842a78e22025d May 16, 2013, 1:22 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bpatricktarget%5D_Sort_By_Functionality_P314980/?page=unread#314980 Hi, 1) Using sb in category pages won't work. You need to update the category sort order defined in Setup > Build Options . sb is only effeective for things like review.cgi / search.cgi 2) As Tandat said, this is used by the rate.cgi system. I would leave that alone. Just add a new one called "ReviewRating" or something (as a FLOAT)...then make a script to simply go through each link and get the average rating nightly: Code: #!/usr/local/bin/perl use strict; use CGI::Carp qw(fatalsToBrowser); use lib '/path/to/admin'; use Links qw/$PLG $IN $DB/; local $SIG{__DIE__} = \&Links::fatal; Links::init('/path/to/admin'); my $Reviews = $DB->table("Reviews"); my $Links = $DB->table("Links"); my $sth = $Links->select( ['ID'], { isValidated => "Yes" } ); while (my $id = $sth->fetchrow) { $Links->update( { ReviewRating => $Reviews->select( ['AVG(Review_Rating)'], { Review_LinkID => $id } )->fetchrow }, { ID => $id }) || die $GT::SQL::error; } Untested, but should work =) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 98082edb8fb4de5edf6e7887ccbf2b75 May 14, 2013, 11:59 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bpatricktarget%5D_Sort_By_Functionality_P314979/?page=unread#314979 Hi, For 1), To use &sb=Title&so=desc should be working. For 2), the Rating is used for link, at least in rate.cgi. So, can add another field for your purpose. Hope that helps! Cheers, Dat Programming and creating plugins and templates Blog bc1c6fe46d02e7e713fcc82d82eaa74b May 14, 2013, 6:47 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Sort_By_Functionality_P314978/?page=unread#314978 Thanks for the help Andy. I have a couple of more questions... 1. For some reason, when I add the &sb=Title or &sb=Title DESC to the url for the category pages on glinks, it doesn't sort the items as it should. Is there something that I am missing? 2. Related to my previous question, I noticed a field called Rating in the database table. Is there any functionality that uses that field for the data? I was thinking of making it so that it would update the rating number every time a new review has been approved and then just sort by that field. Thanks! 089b29e0501f388b27dd7c705a745ddb May 14, 2013, 1:33 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bpatricktarget%5D_Sort_By_Functionality_P314977/?page=unread#314977 Hi, No problem. The simplest way to sort by an average review score, is to have a script run once a night that goes through each link, gets the average rating... and then stores it in the Links table. That way you can just sort by it. Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 96f88c48696b61fc416f933f0c6c5bdc May 14, 2013, 6:34 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Forum_C7/Discussion_F22/Sort_By_Functionality_P314976/?page=unread#314976 N/A N/A May 14, 2013, 5:20 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Sort_By_Functionality_P314975/?page=unread#314975 Oops. I have posted it in the Gossamer Links forum. 81af075b0688574ef0ced0925cfa7b02 May 14, 2013, 5:20 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bpatricktarget%5D_Sort_By_Functionality_P314974/?page=unread#314974 Hi, Are you talking about Gossamer Links, or Gossamer Forum? (thats the forum you're in ) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 1cd726771da78913986844aeb583e687 May 13, 2013, 10:17 PM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Sort_By_Functionality_P314973/?page=unread#314973 I currently have the ability to use the sort by functionality using the sb tag in the url for the search results. I wanted to include the average review for the link as part of the sorting capabilities. Since the current system uses the sb function by sorting with the field name in the db, it makes it hard to sort by the average review, which is all stored in a separate table. Is there a way to get the average review sort by functionality to work? a479777b7612253c956d84461d8fac6b May 13, 2013, 10:04 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_%5BUPDATE%5D_Ace_News_v_3_P314972/?page=unread#314972 Yaha, OK - no, that one that I have downloaded is dated 11/5 and that one is 3.0.1 - I will change it to 3.2.0 during the next weekend Thanks for info Andy 961627c08d1a3f760b7de2fd3a538df9 May 13, 2013, 9:05 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bkatakombe%5D_%5BUPDATE%5D_Ace_News_v_3_P314971/?page=unread#314971 Mmm, not for me? Quote: 3.2.0 - Mon May 13 01:16:23 2013 Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 7dfe157033a0bf529e7d46274474e563 May 13, 2013, 9:01 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_%5BUPDATE%5D_Ace_News_v_3_P314970/?page=unread#314970 11 maj 2013 10:18:58 534651982e32b28f577be5b6f8dfd585 May 13, 2013, 8:59 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bkatakombe%5D_%5BUPDATE%5D_Ace_News_v_3_P314969/?page=unread#314969 I only put it up this morning Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 4c9707d6e274ffce247a011c54c7161a May 13, 2013, 8:55 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_%5BUPDATE%5D_Ace_News_v_3_P314968/?page=unread#314968 Yea, few days ago .. fce9f9e26e299c6d9a347187d2b3cd4f May 13, 2013, 8:54 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bkatakombe%5D_%5BUPDATE%5D_Ace_News_v_3_P314967/?page=unread#314967 From the Members Area? Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 977bfed207c6081db122886b6f643cf4 May 13, 2013, 8:50 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_%5BUPDATE%5D_Ace_News_v_3_P314966/?page=unread#314966 OK, this one is 3.0.1 ab55e62eff62bcb1820e443c675f32ed May 13, 2013, 8:50 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5Bkatakombe%5D_%5BUPDATE%5D_Ace_News_v_3_P314965/?page=unread#314965 NP BTW - you may want to update it to 3.0.2, as there was a mess up with the WYSIWYG editor on the install as well :) Cheers Andy (mod) andy@ultranerds.co.uk ---------------------------------------------------------------------- Want to give me something back for my help? Please see my Amazon Wish List GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500) Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins! Compare our different Plugin packages *new* Free CSS Templates 08ea97892de70e630a612afe0bf73492 May 13, 2013, 8:42 AM http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_%5BUPDATE%5D_Ace_News_v_3_P314964/?page=unread#314964 Perfect , thank you Andy f4be1c61b87e47366cfd5bdda18faa9d May 13, 2013, 8:41 AM