Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: [ FREE PLUGIN ] ULTRAGlobals - Collection of Globals and routines: Page 6

May 12, 2008, 4:54 AM

Andy

Veteran / Moderator (16033 posts)

May 12, 2008, 4:54 AM

Post #126 of 210

Shortcut

Re: [Alba] Ideas please In reply to

Hi,

Done.

Next to each download, you should see stuff like:

Quote:

last updated: Sat May 10 06:27:09 2008

Hopefully thats ok Smile

Cheers

Andy (mod)
andy@ultranerds.com

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

May 12, 2008, 5:44 AM

Alba

Enthusiast (557 posts)

May 12, 2008, 5:44 AM

Post #127 of 210

Shortcut

Re: [Andy] Ideas please In reply to

Quote:

Next to each download, you should see stuff like:

That is a great help, thanks.

Jun 23, 2008, 1:39 AM

Andy

Veteran / Moderator (16033 posts)

Jun 23, 2008, 1:39 AM

Post #128 of 210

Shortcut

Re: [Andy] [ ULTRAGlobals ] Ideas please In reply to

Hi,

Version 3.3.4 has just been uploaded to our site.

http://www.ultranerds.com/...s/ULTRAGlobals_L217/

This includes a new feature - Split_Up_Paragraphs()

This lets you do any of 3 things:

1) Split the Description into Description1 (the first paragraph), and Description2 (the remaining paragraphs)
2) Split the Description into one tag per paragraph (i.e Description1,Description2,Description3,Description4, etc)
3) Split at the "half way" point of the Description, into Description1 and Description2.

Its all tested fine my end - but if anyone finds any problems, please let me know.

Cheers

Andy (mod)
andy@ultranerds.com

Sep 27, 2008, 12:26 PM

Matthias70

Enthusiast (607 posts)

Sep 27, 2008, 12:26 PM

Post #129 of 210

Shortcut

Re: [Andy] [ ULTRAGlobals ] Ideas please In reply to

Hi Andy,
perhaps I'm searching with the wrong searchwords,
but is there a global that shows the 10 most reviewed links?

Would be great to have this global in the ultra globals plugin!

Thanks

Matthias
gpaed.de

Sep 27, 2008, 12:35 PM

Andy

Veteran / Moderator (16033 posts)

Sep 27, 2008, 12:35 PM

Post #130 of 210

Shortcut

Re: [Matthias70] [ ULTRAGlobals ] Ideas please In reply to

Hi,

Nope, there isn't anything in there that does that. I'll try to add it in tomorrow/monday. Got a few other things that I need to get done first though =)

Cheers

Andy (mod)
andy@ultranerds.com

Sep 28, 2008, 12:36 AM

Andy

Veteran / Moderator (16033 posts)

Sep 28, 2008, 12:36 AM

Post #131 of 210

Shortcut

Re: [Matthias70] [ ULTRAGlobals ] Ideas please In reply to

Hi,

I just wrote this - should work fine (tested it ok)

xx_reviews

Code:
sub { 

  my $db = $DB->table('Reviews'); 
     $db->select_options( "GROUP BY Review_LinkID","ORDER BY review_count DESC","LIMIT 5"); 
  my $sth = $db->select("Review_LinkID", "COUNT(*) as review_count") or die "Query Error: $GT::SQL::error"; 

  my $back; 
  my @loop; 
  while (my ($s, $c) = $sth->fetchrow_array) { 
   #  my $url = $CFG->{db_cgi_url} . "/review.cgi?username=$s"; 
    my $link = $DB->table('Links')->get( { ID => $s } ); 

    if (!$link->{isValidated}) { next; } 

    push  @loop, { %$link, ReviewCount => $c } 
    #$back .= qq| <a href="$CFG->{db_cgi_url}/reviews.cgi?ID=$s">$link->{Title}</a> ($c reviews) <br />|; 
  } 

  # return \$back; 
  return { Most_Reviewed_Links => \@loop }   

}

..then call in any template with:

Code:
<%xx_reviews%> 

<%loop Most_Reviewed_Links%> 
  <a href="<%config.db_cgi_url%>/reviews.cgi?ID=<%ID%>"><%Title%></a> (<%ReviewCount%> reviews) <br /> 
<%endloop%>

I've gotta go out now - but will look at adding it to the plugin later on =)

Cheers

Andy (mod)
andy@ultranerds.com

Sep 28, 2008, 9:30 AM

Matthias70

Enthusiast (607 posts)

Sep 28, 2008, 9:30 AM

Post #132 of 210

Shortcut

Re: [Andy] [ ULTRAGlobals ] Ideas please In reply to

Hi Andy,
it's working perfect ;-)
Just one thing

Code:
<%xx_reviews%>  

<%loop Most_Reviewed_Links%>  
<a href="<%config.db_cgi_url%>/reviews.cgi?ID=<%ID%>"><%Title%></a> (<%ReviewCount%> reviews) <br />  
<%endloop%>

should be

Code:
<%xx_reviews%>  

<%loop Most_Reviewed_Links%>  
<a href="<%config.db_cgi_url%>/review.cgi?ID=<%ID%>"><%Title%></a> (<%ReviewCount%> reviews) <br />  
<%endloop%>

Thanks

Matthias
gpaed.de

Last edited by:

Matthias70: Sep 28, 2008, 9:57 AM

Sep 28, 2008, 11:20 AM

Andy

Veteran / Moderator (16033 posts)

Sep 28, 2008, 11:20 AM

Post #133 of 210

Shortcut

Re: [Matthias70] [ ULTRAGlobals ] Ideas please In reply to

Hi,

Cool, I've released the new version (2.3.5), and this can be downloaded from our site now :)

Cheers

Andy (mod)
andy@ultranerds.com

Sep 29, 2008, 2:25 AM

Wychwood

User (182 posts)

Sep 29, 2008, 2:25 AM

Post #134 of 210

Shortcut

Re: [Andy] [ ULTRAGlobals ] Ideas please In reply to

Obviously you know nothing about relational queries. If you have the Link ID in the Reviews table then you should be using a RELATIONAL query to retrieve the link record and not selecting the ID from the Reviews table and then performing a second query to fetch the record from the Links table.

Sep 29, 2008, 4:18 AM

Andy

Veteran / Moderator (16033 posts)

Sep 29, 2008, 4:18 AM

Post #135 of 210

Shortcut

Re: [Wychwood] [ ULTRAGlobals ] Ideas please In reply to

Well yeah, you COULD - but we don't want the review stuff in the loop! (only the link stuff, and review count)

Doing it the way I did it is perfectly fine!

Andy (mod)
andy@ultranerds.com

Oct 1, 2008, 10:09 PM

katakombe

User (99 posts)

Oct 1, 2008, 10:09 PM

Post #136 of 210

Shortcut

The most popular categories In reply to

How to display i.e. top 10 categories or subcategories with most links, kind of:

Subcategory C - 45 links
Subcategory L - 30 links
Maincategory F - 25 links (without links in subcategories)

?

Oct 1, 2008, 11:18 PM

Andy

Veteran / Moderator (16033 posts)

Oct 1, 2008, 11:18 PM

Post #137 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Hi,

Sorry, I'm afraid I'm not sure what you are asking for :/

Cheers

Andy (mod)
andy@ultranerds.com

Oct 2, 2008, 2:17 AM

Wychwood

User (182 posts)

Oct 2, 2008, 2:17 AM

Post #138 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Code:
$DB->relation('Reviews', 'Links')->select("Links.*")->fetchrow_hashref

Last edited by:

Wychwood: Oct 2, 2008, 2:19 AM

Oct 2, 2008, 9:00 AM

katakombe

User (99 posts)

Oct 2, 2008, 9:00 AM

Post #139 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Andy wrote:

Hi,

Sorry, I'm afraid I'm not sure what you are asking for :/

Cheers

Andy, let us say that we have only 2 main categories: A & B.

Category A has 2 subcategories: A1 & A2; Category B has 4 subcategories: B1, B2, B3 & B4.

Category A has 50 links in total, but when you click on it, there is no link at all - links are in A1: 40 and in A2: 10

Category B has 100 links in total and they all resist under the main category, all 4 subcategories are empty.

Now, the global should display the following:

B: 100 links
A1: 40 links
A2: 10 links

Note that there is no "A: 50 links" because in fact the main category is empty.

Oct 2, 2008, 9:32 AM

Andy

Veteran / Moderator (16033 posts)

Oct 2, 2008, 9:32 AM

Post #140 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Hi,

Ok, so let me just get this straight =)

Basically, if a link only 0 links in it (not including the sub-categories too), then you want to get the links from the sub-categories? Is that correct?

Cheers

Andy (mod)
andy@ultranerds.com

Oct 2, 2008, 9:25 PM

katakombe

User (99 posts)

Oct 2, 2008, 9:25 PM

Post #141 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Andy wrote:

Hello Andy!

Yes, that's right Cool

The global should list them in descending order sorted by the number of links in them, no matter if they are categories or subcategories. The only thing that counts is number of links - not total number including subcategories, just simple links visible after clicking on category/subcategory.

Oct 2, 2008, 11:58 PM

Andy

Veteran / Moderator (16033 posts)

Oct 2, 2008, 11:58 PM

Post #142 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Hi,

Ok, I'm confused again as to what you want?

I thought you just wanted a global - which would get the sub-links, in a category if it didn't have any links itself?

i.e

Test_Cat2 (0 links)
Test_Cat2/Sub 3 (1 link)
Test_Cat2/Sub 4 (3 link)
Test_Cat2/Sub 4/Test (1 link)

...so, if they were viewing the "Test_Cat" category (i.e which doesn't have any links in it, on its own level), then it would get the links from Test_Cat2/Sub 3, Test_Cat2/Sub 4 and Test_Cat2/Sub 4/Test (which would make a total of 5 links showing in "Test_Cat2")

Is that still what you are after?

Cheers

Andy (mod)
andy@ultranerds.com

Oct 3, 2008, 8:30 AM

katakombe

User (99 posts)

Oct 3, 2008, 8:30 AM

Post #143 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Hello Andy!

No, I want to display i.e. 10 links to those categories or subcategories which simply have most links. I don't care if on first place is a main category or a subcategory from -10 level in the directory.

The only thing which is important is that the first link goes to a category/subcategory with most links and so on in descending order.

I don't want to see i.e. "Category A: 250 links" and there is in fact only 5 links and 245 are in subcategories which belongs to that main category, in this case "Category A".

To clarify even more, those links will be displayed on a separate page produced by PageBuilder plugin and that page has nothing to do with the rest of directory. That's a page on it's own.

Oct 5, 2008, 4:32 AM

Andy

Veteran / Moderator (16033 posts)

Oct 5, 2008, 4:32 AM

Post #144 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Hi,

Sorry, been a bit busy over the last few days.

I still don't understand what you are after, sorry Pirate

Cheers

Andy (mod)
andy@ultranerds.com

Oct 6, 2008, 9:37 AM

katakombe

User (99 posts)

Oct 6, 2008, 9:37 AM

Post #145 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Hi Andy!

Here are categories and subcategories on the main page:

Category A: 20 links
--Category A-1: 5 links
--Category A-2: 12 links

Category B: 50 links
--Category B-1: 30 links
----Category B-1-1: 24 links
--Category B-2: 4 links

Now, the global should display the following:

1.) B-1-1: 24 links
2.) B: 16 links
3.) A-2: 12 links
4.) B-1: 6 links
5.) A-1: 5 links
6.) B-2: 4 links
7.) A: 3 links

Smile

Oct 6, 2008, 9:48 AM

Andy

Veteran / Moderator (16033 posts)

Oct 6, 2008, 9:48 AM

Post #146 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Ok, that still doesn't make any sense ://

Quote:

2.) B: 16 links

..but you have:

Quote:

Category B: 50 links

..and

Quote:

4.) B-1: 6 links

..but you have:

Quote:

--Category B-1: 30 links

What am I missing? =)

Cheers

Andy (mod)
andy@ultranerds.com

Oct 6, 2008, 11:03 AM

Wychwood

User (182 posts)

Oct 6, 2008, 11:03 AM

Post #147 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

If I understand correctly katakombe wants a "Top 10" of categories with the most links but if the top level category has no links then you look under the sub-categories etc. So it's not a Top 10 of top-level categories - it can include sub-categories too.

Last edited by:

Wychwood: Oct 6, 2008, 11:05 AM

Oct 6, 2008, 9:29 PM

katakombe

User (99 posts)

Oct 6, 2008, 9:29 PM

Post #148 of 210

Shortcut

Re: [Wychwood] The most popular categories In reply to

Wychwood wrote:

Finally!

Oct 6, 2008, 9:35 PM

katakombe

User (99 posts)

Oct 6, 2008, 9:35 PM

Post #149 of 210

Shortcut

Re: [Andy] The most popular categories In reply to

Andy wrote:

Ok, that still doesn't make any sense ://

Quote:

2.) B: 16 links

..but you have:

Quote:

Category B: 50 links

..and

Quote:

4.) B-1: 6 links

..but you have:

Quote:

--Category B-1: 30 links

What am I missing? =)

Cheers

You are missing that i.e. B have 50 links in total, but 30 (B-1) + 4 (B-2) = 34 links in subcategories, so there are only 16 links directly in B etc ...

Oct 6, 2008, 10:49 PM

Andy

Veteran / Moderator (16033 posts)

Oct 6, 2008, 10:49 PM

Post #150 of 210

Shortcut

Re: [katakombe] The most popular categories In reply to

Right ok - thanks for clearing that up Wychwood =)

I'm busy for today (got a few large jobs on), but I'll see if I can take a look tonight/tomorrow for you.

Cheers

Andy (mod)
andy@ultranerds.com

[ FREE PLUGIN ] ULTRAGlobals - Collection of Globals and routines

(Page 6 of 9)

Last edited by:

Last edited by:

Last edited by: