<?xml version="1.0"?>
<rss version="2.0">
    <channel>
        <title>Gossamer Forum</title>
        <link>http://www.gossamer-threads.com/forum/</link>
        <language>en-us</language>
        <managingEditor>gforum@gossamer-threads.com</managingEditor>
        <pubDate>Tue, 21 May 2013 13:29:48 GMT</pubDate>
        <generator>Gossamer Forum by Gossamer Threads, Inc.</generator>
        <docs>http://www.rssboard.org/rss-specification</docs>
        <image>
            <url>http://static.gossamer-threads.com/forum/images/gforum-logo.png</url>
            <title>Gossamer Forum</title>
            <link>http://www.gossamer-threads.com/forum/</link>
            <width>50</width>
            <height>50</height>
        </image>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314998/?page=unread#314998</link>
            <description>Alba wrote:
error &#039; Unable to load plugin &#039;ModuleEnv&#039;: No Install.pm file found in tar!&#039;

Sorry about that. We had some issues with corrupt files when moving to the .co.uk domain. I thought I&#039;d fixed them up , but guess that one got through the net. It should work now

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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>364e53593517f06f56f6ce86d6670603</guid>
            <pubDate>May 20, 2013, 10:00 AM</pubDate>
        </item>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314997/?page=unread#314997</link>
            <description>error &#039; Unable to load plugin &#039;ModuleEnv&#039;: No Install.pm file found in tar!&#039;</description>
            <guid>add3ccb08c90d316fe0dd95d6587eb2f</guid>
            <pubDate>May 20, 2013, 3:42 AM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Creating_a_dynamic_zip_file_P314996/?page=unread#314996</link>
            <description>Used that before, now I remember. Will be emailing you access and more detailed info.</description>
            <guid>1e8a1dfeaa93f2cd34a04ef2fb097360</guid>
            <pubDate>May 20, 2013, 3:39 AM</pubDate>
        </item>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314995/?page=unread#314995</link>
            <description>Hi,

The easiest way is just to use this plugin:

http://www.ultranerds.co.uk/..._0_x/ModuleEnv_L248/

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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>201cdf1df47c0b74b05e2368f237530b</guid>
            <pubDate>May 20, 2013, 3:34 AM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Creating_a_dynamic_zip_file_P314994/?page=unread#314994</link>
            <description>Remind me how to check and see which perl modules are installed so we have a place to start please?</description>
            <guid>7c962944af40615aa76e86547d74e7d3</guid>
            <pubDate>May 20, 2013, 3:31 AM</pubDate>
        </item>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314993/?page=unread#314993</link>
            <description>Sure

As far as I know there is nothing like that that exists (at least I havn&#039;t written anything like that). I can&#039;t see it being too much work to do though.

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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>558c9e231cce5dfde8a71cd02b8662d5</guid>
            <pubDate>May 20, 2013, 3:13 AM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Creating_a_dynamic_zip_file_P314992/?page=unread#314992</link>
            <description>Andy wrote:
Ok - are you asking me to code this for you? Sounds more like a custom job
You know me, I&#039;m quite happy to pay for a custom job, was just making sure it didn&#039;t already exist seeing as I&#039;ve just returned to using GLinks and haven&#039;t really caught up first. Plugin?</description>
            <guid>6940c2a7205afd6caa7278cb94e1f26e</guid>
            <pubDate>May 20, 2013, 3:09 AM</pubDate>
        </item>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314991/?page=unread#314991</link>
            <description>Ok - are you asking me to code this for you? Sounds more like a custom job

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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>fbf49a3fd331594b481810e6a0efb99f</guid>
            <pubDate>May 20, 2013, 2:57 AM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAndy%5D_Creating_a_dynamic_zip_file_P314990/?page=unread#314990</link>
            <description>Andy wrote:
Then you would either do a &amp;quot;location&amp;quot; redirect to this new file (and remove it after say 10 mins) ... or actually get the script to print out the contents itself (this means you can actually remove the file right after its been downloaded)

Probably the latter. The filenames of files to be &#039;zipped&#039; would relate directly to the Links IDs contained within the Category/sub category or the search results. ie: Link ID 300, filename 300.jpg and so on.

Therefore category &#039;hotels&#039; would contain 20 links with 20 files and the generated zip file would contain the 20 files and be downloaded immediately. Because the site is dynamic, there may be 22 links 10 minutes later and then the zip file would contain all 22 files.

Similar with search results.</description>
            <guid>7170307075fc6bfa7a3216ef048ca1f4</guid>
            <pubDate>May 20, 2013, 2:55 AM</pubDate>
        </item>
        <item>
            <title>Re: [Alba] Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Re%3A_%5BAlba%5D_Creating_a_dynamic_zip_file_P314988/?page=unread#314988</link>
            <description>Hi,

You wanna create a ZIP file, based on a selection of files? Normally you would move them into a temp folder, then do a zip file from it:



Code:
zip files.zip *

Then you would either do a &amp;quot;location&amp;quot; redirect to this new file (and remove it after say 10 mins) ... or actually get the script to print out the contents itself (this means you can actually remove the file right after its been downloaded)

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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>4be98ff7dd9ae1c05edc60eb651c5377</guid>
            <pubDate>May 20, 2013, 2:32 AM</pubDate>
        </item>
        <item>
            <title>Creating a dynamic zip file</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Creating_a_dynamic_zip_file_P314986/?page=unread#314986</link>
            <description>Has anyone created a dynamic zip file from attached files stored in Links database?</description>
            <guid>19d1610774bc10dfa8ee95aa6982cf96</guid>
            <pubDate>May 19, 2013, 7:00 AM</pubDate>
        </item>
        <item>
            <title>Re: [patricktarget] Sort By Functionality</title>
            <link>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</link>
            <description>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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>aa202d1aeaa3a5a077e92635e0114afd</guid>
            <pubDate>May 16, 2013, 11:36 PM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Sort By Functionality</title>
            <link>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</link>
            <description>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?</description>
            <guid>04433dd9d540aff2576842a78e22025d</guid>
            <pubDate>May 16, 2013, 1:22 PM</pubDate>
        </item>
        <item>
            <title>Re: [patricktarget] Sort By Functionality</title>
            <link>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</link>
            <description>Hi,

1) Using sb in category pages won&#039;t work. You need to update the category sort order defined in Setup &amp;gt; 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 &amp;quot;ReviewRating&amp;quot; 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 &#039;/path/to/admin&#039;;
use Links qw/$PLG $IN $DB/;

local $SIG{__DIE__} = \&amp;amp;Links::fatal;

Links::init(&#039;/path/to/admin&#039;);

my $Reviews = $DB-&amp;gt;table(&amp;quot;Reviews&amp;quot;);
my $Links	= $DB-&amp;gt;table(&amp;quot;Links&amp;quot;);
my $sth = $Links-&amp;gt;select( [&#039;ID&#039;], { isValidated =&amp;gt; &amp;quot;Yes&amp;quot; } );
while (my $id = $sth-&amp;gt;fetchrow) {
$Links-&amp;gt;update( { ReviewRating =&amp;gt; $Reviews-&amp;gt;select( [&#039;AVG(Review_Rating)&#039;], { Review_LinkID =&amp;gt; $id } )-&amp;gt;fetchrow }, { ID =&amp;gt; $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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>98082edb8fb4de5edf6e7887ccbf2b75</guid>
            <pubDate>May 14, 2013, 11:59 PM</pubDate>
        </item>
        <item>
            <title>Re: [patricktarget] Sort By Functionality</title>
            <link>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</link>
            <description>Hi,

For 1), To use &amp;amp;sb=Title&amp;amp;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</description>
            <guid>bc1c6fe46d02e7e713fcc82d82eaa74b</guid>
            <pubDate>May 14, 2013, 6:47 PM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Sort By Functionality</title>
            <link>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</link>
            <description>Thanks for the help Andy.

I have a couple of more questions...

1. For some reason, when I add the &amp;amp;sb=Title or &amp;amp;sb=Title DESC to the url for the category pages on glinks, it doesn&#039;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!</description>
            <guid>089b29e0501f388b27dd7c705a745ddb</guid>
            <pubDate>May 14, 2013, 1:33 PM</pubDate>
        </item>
        <item>
            <title>Re: [patricktarget] Sort By Functionality</title>
            <link>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</link>
            <description>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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>96f88c48696b61fc416f933f0c6c5bdc</guid>
            <pubDate>May 14, 2013, 6:34 AM</pubDate>
        </item>
        <item>
            <title>Re: [Andy] Sort By Functionality</title>
            <link>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</link>
            <description>Oops. I have posted it in the Gossamer Links forum.</description>
            <guid>81af075b0688574ef0ced0925cfa7b02</guid>
            <pubDate>May 14, 2013, 5:20 AM</pubDate>
        </item>
        <item>
            <title>Re: [patricktarget] Sort By Functionality</title>
            <link>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</link>
            <description>Hi,

Are you talking about Gossamer Links, or Gossamer Forum? (thats the forum you&#039;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 &amp;quot;value&amp;quot; $3,325 &amp;amp; rising, for just $350)| GLinks ULTRA Package PRO (plugins total &amp;quot;value&amp;quot; $5,625 &amp;amp; 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</description>
            <guid>1cd726771da78913986844aeb583e687</guid>
            <pubDate>May 13, 2013, 10:17 PM</pubDate>
        </item>
        <item>
            <title>Sort By Functionality</title>
            <link>http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Links_C5/Development%2C_Plugins_and_Globals_F20/Sort_By_Functionality_P314973/?page=unread#314973</link>
            <description>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?</description>
            <guid>a479777b7612253c956d84461d8fac6b</guid>
            <pubDate>May 13, 2013, 10:04 AM</pubDate>
        </item>
    </channel>
</rss>
