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

Apr 1, 2008, 9:02 AM

Andy

Veteran / Moderator (16033 posts)

Apr 1, 2008, 9:02 AM

Post #101 of 210

Shortcut

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

Hi,

Can you open up ULTRAGlobals.pm, and find (in the Last_Links_By_Category function, near the bottom of the file):

Code:
 my $cond = GT::SQL::Condition->new('CategoryID', 'IN', $all_ids); 
 my $cond2 = GT::SQL::Condition->new('isValidated','=','Yes'); 
 my $sth = $db_obj->select (['Links.*'], $cond, $cond2 ) || die $GT::SQL::error;

..add this after:

Code:
 print $IN->header; 
 print $sth->query;

Then save, and refresh your page. What query is it showing?

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

Apr 1, 2008, 9:06 AM

Matthias70

Enthusiast (607 posts)

Apr 1, 2008, 9:06 AM

Post #102 of 210

Shortcut

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

Andy wrote:

Then save, and refresh your page. What query is it showing?

That's the query

Code:
SELECT glinks_Links.* FROM glinks_CatLinks,glinks_Category,glinks_Links WHERE glinks_CatLinks.LinkID = glinks_Links.ID AND glinks_CatLinks.CategoryID = glinks_Category.ID AND ((glinks_CatLinks.CategoryID = '598') AND (glinks_Links.isValidated = 'Yes'))

Matthias

Matthias
gpaed.de

Apr 1, 2008, 9:33 AM

Andy

Veteran / Moderator (16033 posts)

Apr 1, 2008, 9:33 AM

Post #103 of 210

Shortcut

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

Hi,

Try commenting out (in Last_Links_By_Category):

Code:
 my $db_obj = $DB->table('Links','CatLinks','Category'); 
    $db_obj->select_options ("ORDER BY ID DESC Limit $limit"); 

 my $sth = $db_obj->select (['Links.*'], GT::SQL::Condition->new(['CategoryID', 'IN', $all_ids], ['isValidated', '=', 'Yes'] ) ) || die $GT::SQL::error;

Does that work then?

Cheers

Andy (mod)
andy@ultranerds.com

Apr 1, 2008, 9:39 AM

Matthias70

Enthusiast (607 posts)

Apr 1, 2008, 9:39 AM

Post #104 of 210

Shortcut

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

Andy wrote:

Hi,

Try commenting out (in Last_Links_By_Category):

Code:
 my $db_obj = $DB->table('Links','CatLinks','Category');  
    $db_obj->select_options ("ORDER BY ID DESC Limit $limit");  

 my $sth = $db_obj->select (['Links.*'], GT::SQL::Condition->new(['CategoryID', 'IN', $all_ids], ['isValidated', '=', 'Yes'] ) ) || die $GT::SQL::error;

Does that work then?

Cheers

That shows an error!
Global symbol "$db_obj" requires explicit package name

Matthias
gpaed.de

Apr 1, 2008, 9:59 AM

Andy

Veteran / Moderator (16033 posts)

Apr 1, 2008, 9:59 AM

Post #105 of 210

Shortcut

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

Hi,

Sorry, I mean't comment this line:

Code:
 my $sth = $db_obj->select (['Links.*'], GT::SQL::Condition->new(['CategoryID', 'IN', $all_ids], ['isValidated', '=', 'Yes'] ) ) || die $GT::SQL::error;

..not the 2 lines before that - sorry about that (was multi-tasking :P)

Cheers

Andy (mod)
andy@ultranerds.com

Apr 1, 2008, 10:47 AM

Matthias70

Enthusiast (607 posts)

Apr 1, 2008, 10:47 AM

Post #106 of 210

Shortcut

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

Hi Andy,
when I comment out this line, it's working fine Smile

Thanks
Matthias

Matthias
gpaed.de

Apr 2, 2008, 1:24 AM

Andy

Veteran / Moderator (16033 posts)

Apr 2, 2008, 1:24 AM

Post #107 of 210

Shortcut

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

Hi,

Cool, I'll get that fixed up. I guess the "LIMIT" is being accessed once, and then gets removed.

I'll get a fixed version up (and also fix up another function, which I based that global on - as that's prob got the same problem :))

Cheers

Andy (mod)
andy@ultranerds.com

Apr 2, 2008, 3:49 AM

Andy

Veteran / Moderator (16033 posts)

Apr 2, 2008, 3:49 AM

Post #108 of 210

Shortcut

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

Hi,

Version 2.2.3 is now available from our site. This includes the LIMIT bug fix.

Cheers

Andy (mod)
andy@ultranerds.com

Apr 9, 2008, 1:35 AM

Andy

Veteran / Moderator (16033 posts)

Apr 9, 2008, 1:35 AM

Post #109 of 210

Shortcut

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

Hi,

I just spotted a pretty major flaw in the NL_2_BR() function <G> (I was using it on a clients site, and was wondering why the data wasn't being returned, yet the tag existed).

The solution is:

1) Update to the new version on our site (NB, I didn't bother updating the version number)
..or:
2) Open up /admin/Plugins/ULTRAGlobals.pm, and find:

Code:
sub NL_2_BR { 
  my $in = $_[0]; 
  $in =~ s/\r?\n/\<br \/\>/sg; 
  return; 
}

..replace with:

Code:
sub NL_2_BR { 
  my $in = $_[0]; 
  $in =~ s/\r?\n/\<br \/\>/sg; 
  return $in; 
}

Cheers

Andy (mod)
andy@ultranerds.com

Apr 9, 2008, 2:24 AM

Wychwood

User (182 posts)

Apr 9, 2008, 2:24 AM

Post #110 of 210

Shortcut

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

Don't know why you insist on escaping brackets. It's not needed.

Code:
sub NL_2_BR {    
    my $in = $_[0];    
    $in =~ s|\r?\n|<br />|sg;    
    return $in;  
}

Apr 9, 2008, 2:29 AM

Andy

Veteran / Moderator (16033 posts)

Apr 9, 2008, 2:29 AM

Post #111 of 210

Shortcut

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

Hi,

Yeah, not sure why I did either (in that global) .... normally I don't =) Appart from in stuff like:

Code:
if ($var =~ m/something/) { 
 ... 
}

..which doesn't seem to work using:

Code:
if ($var =~ m|something|) { 
  .. 
}

(at least, it doesn't seem to match values for me, in prior cases).

Cheers

Andy (mod)
andy@ultranerds.com

Apr 13, 2008, 11:20 PM

Wychwood

User (182 posts)

Apr 13, 2008, 11:20 PM

Post #112 of 210

Shortcut

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

The two examples you just gave are identical and should behave the same way. Anyhow I wasn't referring to that anyway, I was talking about stuff like:

\<br \/\>

It doesn't matter whenter you use m|| or m// or whatever, you don't need all the escapes infront of angledbrackets!!

Apr 14, 2008, 12:13 AM

Andy

Veteran / Moderator (16033 posts)

Apr 14, 2008, 12:13 AM

Post #113 of 210

Shortcut

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

Hi,

Quote:

The two examples you just gave are identical and should behave the same way

Yeah, thats what I would have thought. Just didn't seem to like doing m|| from inside an if() statement - odd (maybe was just a bad regex then)

Regarding:

Quote:

Anyhow I wasn't referring to that anyway, I was talking about stuff like:

\<br \/\>

It doesn't matter whenter you use m|| or m// or whatever, you don't need all the escapes infront of angledbrackets!!

Yup, I know :P

I actually got that global from one of my old sites (which I did a few years ago - should have just re-written it, but was trying to get a nice collection of globals into version 1 of this plugin =))

Now, I just use the format you have (you should be able to see it being used in other parts of ULTRAGlobals, not to mention globals I provide for free on the forum =))

Cheers

Andy (mod)
andy@ultranerds.com

Apr 14, 2008, 6:59 AM

nir

User (305 posts)

Apr 14, 2008, 6:59 AM

Post #114 of 210

Shortcut

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

Hi

Two new global that may help :) are
Counting word
Counting signs

Apr 14, 2008, 7:06 AM

Andy

Veteran / Moderator (16033 posts)

Apr 14, 2008, 7:06 AM

Post #115 of 210

Shortcut

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

Hi,

With the word one, are you meaning something like:

Quote:

this is a test

...would return 4.

Quote:

Counting signs

Not sure what you mean by this?

Cheers

Andy (mod)
andy@ultranerds.com

Apr 14, 2008, 7:14 AM

nir

User (305 posts)

Apr 14, 2008, 7:14 AM

Post #116 of 210

Shortcut

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

Sorry, It look like I forget to write it
Like you write
"this is a test" -- would return -- Counting word 4
"this is a test" -- would return -- Counting sings 11 (t+h+i+s+i+s…)

Apr 14, 2008, 7:26 AM

Andy

Veteran / Moderator (16033 posts)

Apr 14, 2008, 7:26 AM

Post #117 of 210

Shortcut

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

Hi,

Try the new version 2.3.0 (from our site)

This now has:

Code:
<%Plugins::ULTRAGlobals::Count_Words($Field)%> 
<%Plugins::ULTRAGlobals::Count_Chars($Field)%>

As always, this is documented in the Readme Smile

Cheers

Andy (mod)
andy@ultranerds.com

Apr 14, 2008, 7:51 AM

Matthias70

Enthusiast (607 posts)

Apr 14, 2008, 7:51 AM

Post #118 of 210

Shortcut

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

nir wrote:

Sorry, It look like I forget to write it
Like you write
"this is a test" -- would return -- Counting word 4
"this is a test" -- would return -- Counting sings 11 (t+h+i+s+i+s…)

Hi nir,
for what are you using this globals?

Thanks

Matthias
gpaed.de

May 11, 2008, 6:48 AM

Alba

Enthusiast (557 posts)

May 11, 2008, 6:48 AM

Post #119 of 210

Shortcut

Re: [ ULTRAGlobals ] Ideas please In reply to

Quote:

[/url]# Random_Links[/url]

[/url]

Random links without setting category ID is returning duplicate records if they are entered in more than one category. Don't know if there is a solution?

May 11, 2008, 6:58 AM

Andy

Veteran / Moderator (16033 posts)

May 11, 2008, 6:58 AM

Post #120 of 210

Shortcut

Re: [Alba] Ideas please In reply to

Hi,

Mmm.. not easily :/

Would be possible to do it with DISTINCT(LinkID), *but* it would double the work - cos it would need to do something like:

Get list of Distinct ID's (random)
Get the record for each of the ID's grabbed

..instead of just:

get the list of ID's

Cheers

Andy (mod)
andy@ultranerds.com

May 11, 2008, 7:16 AM

Alba

Enthusiast (557 posts)

May 11, 2008, 7:16 AM

Post #121 of 210

Shortcut

Re: [Andy] Ideas please In reply to

OK, thanks. I'll make another category and call the random links dependent on them being in that category, that will be easier.

May 12, 2008, 2:01 AM

Andy

Veteran / Moderator (16033 posts)

May 12, 2008, 2:01 AM

Post #122 of 210

Shortcut

Re: [Alba] Ideas please In reply to

Hi,

2.3.3 is now available from our site.

This includes AdCode_Randomly_In_Cat() .. which lets you show adverts randomly in a category (between a link).

Enjoy <G>

Cheers

Andy (mod)
andy@ultranerds.com

May 12, 2008, 4:21 AM

Alba

Enthusiast (557 posts)

May 12, 2008, 4:21 AM

Post #123 of 210

Shortcut

Re: [Andy] Ideas please In reply to

Suggestion:

Could you possibly put the 'add date' &/or 'modified date' against all the plugins in the download area? It would make it much simpler to see what was updated.

Thanks

May 12, 2008, 4:25 AM

Andy

Veteran / Moderator (16033 posts)

May 12, 2008, 4:25 AM

Post #124 of 210

Shortcut

Re: [Alba] Ideas please In reply to

Hi,

Do you mean in the "Members Area" - i.e for the paid plugins?

Cheers

Andy (mod)
andy@ultranerds.com