Gossamer Forum: Products: Gossamer Links: Development, Plugins and Globals: [NEW] TodaysRandomFact v1

Jul 20, 2005, 12:59 AM

Andy

Veteran / Moderator (17366 posts)

Jul 20, 2005, 12:59 AM

Post #1 of 14

Shortcut

[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

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 12, 2005, 2:49 PM

ccunet

User (353 posts)

Aug 12, 2005, 2:49 PM

Post #2 of 14

Shortcut

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 (17366 posts)

Aug 13, 2005, 12:54 AM

Post #3 of 14

Shortcut

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

Feb 27, 2008, 12:22 PM

DeadMan

User (474 posts)

Feb 27, 2008, 12:22 PM

Post #4 of 14

Shortcut

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 (17366 posts)

Feb 28, 2008, 12:22 AM

Post #5 of 14

Shortcut

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

Feb 28, 2008, 1:05 AM

DeadMan

User (474 posts)

Feb 28, 2008, 1:05 AM

Post #6 of 14

Shortcut

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 (17366 posts)

Feb 28, 2008, 1:17 AM

Post #7 of 14

Shortcut

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

Feb 29, 2008, 12:39 PM

DeadMan

User (474 posts)

Feb 29, 2008, 12:39 PM

Post #8 of 14

Shortcut

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

Shortcut

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 (17366 posts)

Mar 1, 2008, 3:53 AM

Post #10 of 14

Shortcut

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

Mar 6, 2008, 12:44 PM

DeadMan

User (474 posts)

Mar 6, 2008, 12:44 PM

Post #11 of 14

Shortcut

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 (17366 posts)

Mar 7, 2008, 12:16 AM

Post #12 of 14

Shortcut

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