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

[NEW] TodaysRandomFact v1

Jul 20, 2005, 12:59 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Jul 20, 2005, 12:59 AM
Post #1 of 14
Views: 7601
Shortcut
Quote Reply
[NEW] TodaysRandomFact v1
Hi,

As per a request from someone on this forum, I've now written a "Random Fact" system for LinksSQL 2.x > and GLinks 3.x).

Full details can be found here (screenshots to come at some point <G>)

http://ultranerds.com/...bin/details/153.html

Price: $15
Ease of Installation: Very easy Smile

If you have any questions, please don't hesitate to ask.

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Aug 12, 2005, 2:49 PM
ccunet
User (353 posts)
Aug 12, 2005, 2:49 PM
Post #2 of 14
Views: 7381
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
Andy,
Is this is the pro package?

CCUnet
my Christian web
Aug 13, 2005, 12:54 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Aug 13, 2005, 12:54 AM
Post #3 of 14
Views: 7385
Shortcut
Quote Reply
Re: [ccunet] [NEW] TodaysRandomFact v1 In reply to
Hi,

Yup, should be Smile

http://ultranerds.com/...packages.cgi?p=Ultra gives a full list of them. Should also have a few new ones out today too <G>

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Feb 27, 2008, 12:22 PM
DeadMan
User (497 posts)
DeadMan's avatar
Feb 27, 2008, 12:22 PM
Post #4 of 14
Views: 7110
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
Is is possible just to display random facts no matter of date?

Let say, I put 20 facts in database, put code on page, and those fact are random display every day (or even every time someone visit site).

UnReal Network
Feb 28, 2008, 12:22 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Feb 28, 2008, 12:22 AM
Post #5 of 14
Views: 7149
Shortcut
Quote Reply
Re: [deadroot] [NEW] TodaysRandomFact v1 In reply to
Hi,

It does that already Smile

Code:
$tbl->select_options('ORDER BY RAND()');

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Feb 28, 2008, 1:05 AM
DeadMan
User (497 posts)
DeadMan's avatar
Feb 28, 2008, 1:05 AM
Post #6 of 14
Views: 7131
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
So I really don't need to add Date when adding fact?

UnReal Network
Feb 28, 2008, 1:17 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Feb 28, 2008, 1:17 AM
Post #7 of 14
Views: 7150
Shortcut
Quote Reply
Re: [deadroot] [NEW] TodaysRandomFact v1 In reply to
Sorry, my mistake. You DO need the Date.

To get a random entry, just add this global:

get_random_fact

Code:
sub {
my $tbl = $DB->table('Facts');
$tbl->select_options('ORDER BY RAND()');
my $fact = $tbl->select()->fetchrow_hashref;
return $fact->{Fact};
}

Then call with:

Fact: <%get_random_fact%>

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Feb 29, 2008, 12:39 PM
DeadMan
User (497 posts)
DeadMan's avatar
Feb 29, 2008, 12:39 PM
Post #8 of 14
Views: 7101
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
Cool. That worked.

Also, is it possible to change charset for the added fact in database? When I try to add fact to database it wont' save with chars (local chars) I put in field for input.

UnReal Network
Mar 1, 2008, 3:24 AM
Wychwood
User (182 posts)
Mar 1, 2008, 3:24 AM
Post #9 of 14
Views: 7118
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
Surely that query is selecting ALL data because you didn't use LIMIT?
Mar 1, 2008, 3:53 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 1, 2008, 3:53 AM
Post #10 of 14
Views: 7133
Shortcut
Quote Reply
Re: [Wychwood] [NEW] TodaysRandomFact v1 In reply to
Hi,

Oops - you've got a point!

deadroot, use this instead:

Code:
sub {
my $tbl = $DB->table('Facts');
$tbl->select_options('ORDER BY RAND()','LIMIT 1');
my $fact = $tbl->select()->fetchrow_hashref;
return $fact->{Fact};
}

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 6, 2008, 12:44 PM
DeadMan
User (497 posts)
DeadMan's avatar
Mar 6, 2008, 12:44 PM
Post #11 of 14
Views: 7089
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
Any idea how to display local chars from facts that are put in database?

Or how to save in database with special chars...

Regards.

UnReal Network
Mar 7, 2008, 12:16 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 7, 2008, 12:16 AM
Post #12 of 14
Views: 7137
Shortcut
Quote Reply
Re: [DeadMan] [NEW] TodaysRandomFact v1 In reply to
Hi,

Not sure what you mean? I just tried on your site with "tražilica|2007-10-20" as bulk add - and it added it fine , with characters :

Quote:
ID 6
Fact 2007-10-20
Date tražilica

..or am I missing something?

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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Mar 7, 2008, 10:58 AM
DeadMan
User (497 posts)
DeadMan's avatar
Mar 7, 2008, 10:58 AM
Post #13 of 14
Views: 7042
Shortcut
Quote Reply
Re: [Andy] [NEW] TodaysRandomFact v1 In reply to
did you tried "ć"?

Instead "ć" I got "?"

Regards.

UnReal Network
Mar 7, 2008, 11:07 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 7, 2008, 11:07 AM
Post #14 of 14
Views: 7085
Shortcut
Quote Reply
Re: [DeadMan] [NEW] TodaysRandomFact v1 In reply to
Mmmm.. not sure, I see what you mean 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 | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!