Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

[ FREE PLUGIN ] ULTRAGlobals - Collection of Globals and routines

(Page 10 of 10)
> >
Previous ThreadNext ThreadPrint ThreadView Threaded
Aug 29, 2011, 6:58 AM
MJ_
User (236 posts)
Aug 29, 2011, 6:58 AM
Post #226 of 241
Views: 440
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Hi Andy,

Type FLOAT would be correct for me (and in the DECIMAL ideal).

But, how to indicate the precision : FLOAT(7,4)?

I do not see how to do that in GL!

Thanks!

Mick
Aug 29, 2011, 8:17 AM
MJ_
User (236 posts)
Aug 29, 2011, 8:17 AM
Post #227 of 241
Views: 440
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
MySQLMan :)
Aug 29, 2011, 8:53 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Aug 29, 2011, 8:53 AM
Post #228 of 241
Views: 442
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
Quote:
For the decimal (FLOAT), could the separator be the dot (.) or the comma (,) ?

By standard, it will format the number (FLOAT) as 1234456787.55.

The Commify function will change that to:

Code:
1,234,456,787.55

You can use a different delimited, with something like:

Code:
<%Plugins::ULTRAGlobals::Commify("123456778.54"," ")%>

Which would use a space as the delimiter (for countries like france etc)

If you wanna format something like:

Code:
123 123 1234,44

...then you would need to tweak the code a little. Find this line:

Code:
if ($delim) { s/,/$delim/g; }

..and add this after it:

Code:
if (/\.\d+$/) { s/\.(\d+)$/,$1/g; }

I just tested it, and that works well Smile

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Aug 29, 2011, 8:54 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Aug 29, 2011, 8:54 AM
Post #229 of 241
Views: 437
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
MJ_ wrote:
MySQLMan :)

Yup Smile

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Aug 29, 2011, 10:03 AM
MJ_
User (236 posts)
Aug 29, 2011, 10:03 AM
Post #230 of 241
Views: 433
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Great ! :)

I will associate it with http://www.decorplanit.com/plugin/

Thanks again!

Mick
Aug 31, 2011, 7:27 AM
MJ_
User (236 posts)
Aug 31, 2011, 7:27 AM
Post #231 of 241
Views: 414
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Hi Andy,

I use this solution with Plugins::ULTRAGlobals::NL_2_BR to escape Tags HTML:

<%set Description_New = escape_html $Description%>
<%Plugins::ULTRAGlobals::NL_2_BR($Description_New)%>

But, would it be possible to integrate directly the function in your code?

I tested with:

Code:
# <%Plugins::ULTRAGlobals::NL_2_BR($Description)%>
sub NL_2_BR {
my $in = $_[0];
$in = GT::CGI::html_escape($in);
$in =~ s/\r?\n/\<br \/\>/sg;
return $in;
}
...but that does not function...

Thanks again!

Mick
Aug 31, 2011, 7:29 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Aug 31, 2011, 7:29 AM
Post #232 of 241
Views: 416
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
I think you probably want this, so it doesn't encode the charachters:

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

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Aug 31, 2011, 7:42 AM
MJ_
User (236 posts)
Aug 31, 2011, 7:42 AM
Post #233 of 241
Views: 414
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Great ! :)

I also added the function for Trim_Field:
$string = GT::CGI::html_escape($string);

Thanks!

Mick
Sep 2, 2011, 8:44 AM
MJ_
User (236 posts)
Sep 2, 2011, 8:44 AM
Post #234 of 241
Views: 380
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
Hi Andy,

I have a problem with Load_Link (<%detailed_url%>).

It gives me only the value of build_detail_format (in Build Options).

Whereas I use "build_detail_url/build_detail_format".

An idea?

Thank again!

Mick
Sep 3, 2011, 2:00 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Sep 3, 2011, 2:00 AM
Post #235 of 241
Views: 374
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
Hi,

Mmm, shouldn't be a problem. Try changing this:

Code:
sub Load_Link {
my $link = $DB->table('Links')->select( { ID => $_[0] } )->fetchrow_hashref;
$link->{detailed_url} = $CFG->{build_root_url} . "/" . $DB->table('Links')->detailed_url( $link->{ID} );
return $link;
}
..to:

Code:
sub Load_Link {
my $link = $DB->table('Links')->select( { ID => $_[0] } )->fetchrow_hashref;
$link = Links::SiteHTML::tags('link', $link);
return $link;
}

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Sep 9, 2011, 7:33 AM
MJ_
User (236 posts)
Sep 9, 2011, 7:33 AM
Post #236 of 241
Views: 329
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Hi Andy,

That functioned! :)

I have the same problem with Last_Links_By_Category.
I tried to add your code, but that does not function. :(

Thanks again.

Mick

Sep 9, 2011, 9:35 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Sep 9, 2011, 9:35 AM
Post #237 of 241
Views: 318
Shortcut
Quote Reply
Re: [MJ_] Ideas please In reply to
Hi,

In the ULTRAGlobals.pm file, for that function - find:

Code:
my @cats;
while (my $hit = $sth->fetchrow_hashref) {

if ($CFG->{build_detailed}) { $hit->{detailed_url} = $CFG->{build_root_url} . "/" . $DB->table('Links')->detailed_url( $hit->{ID} ); }

if ($hit->{isNew} eq "Yes") { $hit->{isNew} = 1; } else { $hit->{isNew} = 0; }
if ($hit->{isPopular} eq "Yes") { $hit->{isPopular} = 1; } else { $hit->{isPopular} = 0; }
if ($hit->{isChanged} eq "Yes") { $hit->{isChanged} = 1; } else { $hit->{isChanged} = 0; }

push @cats, $hit;
}

Try changing it to:

Code:
my @cats;
while (my $hit = $sth->fetchrow_hashref) {
$hit = Links::SiteHTML::tags('link', $hit);
push @cats, $hit;
}

That should do the trick.

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Sep 9, 2011, 9:55 AM
MJ_
User (236 posts)
Sep 9, 2011, 9:55 AM
Post #238 of 241
Views: 316
Shortcut
Quote Reply
Re: [Andy] Ideas please In reply to
Perfect! Smile
Nov 8, 2011, 7:43 AM
katakombe
User (127 posts)
katakombe's avatar
Nov 8, 2011, 7:43 AM
Post #239 of 241
Views: 232
Shortcut
Quote Reply
User_List In reply to
Hello Andy!

I'm not sure whether I missed something or I did something wrong, but I can not get "User_List" to work?

Is there any difference if users register through the "Gossamer Community"?

Many thanks in advance.
Nov 8, 2011, 7:48 AM
Andy
Veteran / Moderator (17366 posts)
Andy's avatar
Nov 8, 2011, 7:48 AM
Post #240 of 241
Views: 233
Shortcut
Quote Reply
Re: [katakombe] User_List In reply to
Hi,

I'm afraid it won't work with GComm (as its using the glinks_Users table, not the community tables/database)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
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
Nov 8, 2011, 7:51 AM
katakombe
User (127 posts)
katakombe's avatar
Nov 8, 2011, 7:51 AM
Post #241 of 241
Views: 234
Shortcut
Quote Reply
Re: [Andy] User_List In reply to
[
Andy wrote:
Hi,

I'm afraid it won't work with GComm (as its using the glinks_Users table, not the community tables/database)

Cheers

Frown oj ... sad, but okay Smile
> >
Previous ThreadNext ThreadPrint ThreadView Threaded