Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

News Center Creation / Freelance Oppty.

Mar 1, 2000, 5:44 PM
DigitalWorlds
Novice (35 posts)
Mar 1, 2000, 5:44 PM
Post #1 of 6
Views: 1425
Shortcut
Quote Reply
News Center Creation / Freelance Oppty.
Greetings gang!

I'm doing some research into getting dbman to do something not that difficult (i hope) and perhaps someone already has figured this out or wants to earn a few $$ to help me get this new project going.

I want to create a news database that would work via SSI. I'd like the format to appear like this:

CATEGORY NAME
Date | Time | Headline (hyperlink)
Date | Time | Headline (hyperlink)

whereby the headline would link to a record ID# for reading the news article (with mnost recent on top).

I can create the database it self (with lil difficulty) but past that I'm hopeless without a mod or someone who wants to freelance for me Smile

Please post any starting points or places I can check for mods (i've already checked the resource center) of email me if interested in some freelance dbman programming Smile

Paul

Mar 1, 2000, 6:26 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Mar 1, 2000, 6:26 PM
Post #2 of 6
Views: 1447
Shortcut
Quote Reply
Re: News Center Creation / Freelance Oppty. In reply to
Guess you haven't figured out the Resource Center yet...

Wink

Go here:

NewsMan [Mod]
http://www.gossamer-threads.com/...rces/jump.cgi?ID=847

Regards,



------------------
Eliot Lee....
Former Handle: Eliot
* Check Resource Center
* Search Forums
Mar 1, 2000, 7:22 PM
DigitalWorlds
Novice (35 posts)
Mar 1, 2000, 7:22 PM
Post #3 of 6
Views: 1397
Shortcut
Quote Reply
Re: News Center Creation / Freelance Oppty. In reply to
As I said before...I saw it - not impressed with it - not what I want Smile

Offer still stands for freelance oppty or to lend me a crutch if you're "expert" with dbman.

Thanks!
Mar 1, 2000, 7:28 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Mar 1, 2000, 7:28 PM
Post #4 of 6
Views: 1383
Shortcut
Quote Reply
Re: News Center Creation / Freelance Oppty. In reply to
AS I mentioned in your other Topic you created for this topic...you should consider contacting one of the Installers in the Resource Center.

Regards,

------------------
Eliot Lee....
Former Handle: Eliot
* Check Resource Center
* Search Forums
Mar 5, 2000, 7:51 AM
DigitalWorlds
Novice (35 posts)
Mar 5, 2000, 7:51 AM
Post #5 of 6
Views: 1383
Shortcut
Quote Reply
Re: News Center Creation / Freelance Oppty. In reply to
The freelance oppty still stands. Please email me if interested.
Mar 5, 2000, 6:56 PM
oldmoney
User (431 posts)
oldmoney's avatar
Mar 5, 2000, 6:56 PM
Post #6 of 6
Views: 1388
Shortcut
Quote Reply
Re: News Center Creation / Freelance Oppty. In reply to
To get a jump start on the SSI part, take a look at Eliot's records.cgi... it's the best solution out there. As for the latest headlines (records), I use...
Code:
open (DB, "<$db_file_name") or &cgierr("error in modify_records. unable to open db file: $db_file_name.\nReason: $!");
if ($db_use_flock) { flock(DB, 1); }
my @lines = <DB>; # Slurp the database into @lines..
close DB;
my $LASTX = 4; # How many headlines do you want?
for ($i=$#lines; $i>=($#lines - $LASTX); $i--) {
chomp $lines[$i];
@data = split(/\|/,$lines[$i]);
$latest .= qq|<A HREF="$db_script_url?db=database&uid=$db_uid&ID=$data[1]&view_records=1">$data[3] (by $data[0])</A><BR>|;
#$data[0] is author, $data[1] is record ID, $data[3] is title in my DB
}
print $latest;
To get these sorted by category will take an extra step which I haven't used yet... I would probably start by slurping the DB into categories first before counting off the last N records.


------------------
The Immuatable Order of Modding
-=-=-=-=-=-=-=-
1. Read the FAQ, 2. Search the board, 2a. Search the board again, 3. ask the question, 4. back-up, 5. experiment, 6. rephrase question (or better yet, post solution to original question)



[This message has been edited by oldmoney (edited March 05, 2000).]