Gossamer Forum
Home : Products : Links 2.0 : Customization :

Re: Script for adding new positing in X position od db?

Quote Reply
Re: Script for adding new positing in X position od db? In reply to
Try the following script. I haven't tested it, but it should work okay.

Code:
#!/usr/local/bin/perl
# -------------------------------------------
$ENV{'REQUEST_METHOD'} and (print "Content-type: text/plain\n\n");
open (DB, "<links.db") or
print "Unable to open links database 'links.db'. Reason: $!" and exit;
print "\tOpening output file . . .\n";
open (DBOUT, ">links2.db") or
print "Unable to open output database.
Make sure data dir is chmod 777 temporarily. Reason: $!" and exit;
print "\tProcessing records\n";
while (<DB> ) {
/^#/ and next LINE; # Skip comment Lines.
/^\s*$/ and next LINE; # Skip blank lines.
chomp; # Remove trailing new line.
@rec_in = &split_decode($_);
# Copy ID, Title, URL, Date and Category
for $i (0 .. 4) {
$rec_out[$i] = $rec_in[$i];
}
# Add New Field here
$rec_out[5] = ""; # add something between quotes if you have a default value
# Copy the rest of old links.db to new links2.db
for $i (5 .. 13) {
$rec_out[$i + 1] = $rec_in[$i];
}
print DBOUT &join_encode(&array_to_hash(0, @rec_out));
}
print "\tDone.\n\n";
close DB;
close DBOUT;
print "Database saved it as links2.db.\n";
print "Change permissions back to 755 on the data directory.\n\n";
print "You must rename 'links2.db' to 'links.db before using with Links v2.\n";
print "It is recommend you save the original 'links.db' before renaming.";

You can adjust the range in the two "for" loops and the field being added if the field numbers are different in your case.

I hope this helps.

[This message has been edited by Bobsie (edited March 30, 1999).]
Subject Author Views Date
Thread Script for adding new positing in X position od db? crisco 15558 Mar 29, 1999, 8:36 PM
Post Re: Script for adding new positing in X position od db?
Bobsie 15535 Mar 29, 1999, 10:16 PM
Post Re: Script for adding new positing in X position od db?
crisco 15546 Mar 29, 1999, 10:34 PM
Post Re: Script for adding new positing in X position od db?
crisco 15578 Mar 29, 1999, 10:50 PM
Post Re: Script for adding new positing in X position od db?
Bobsie 15520 Mar 30, 1999, 10:49 AM
Post Re: Script for adding new positing in X position od db?
socrates 15524 Mar 30, 1999, 9:05 PM
Post Re: Script for adding new positing in X position od db?
crisco 15522 Mar 30, 1999, 11:40 PM
Post Re: Script for adding new positing in X position od db?
Bobsie 15542 Mar 31, 1999, 10:50 AM
Post Re: Script for adding new positing in X position od db?
crisco 15544 Mar 31, 1999, 12:15 PM
Post Re: Script for adding new positing in X position od db?
theguy 15545 Aug 10, 1999, 2:10 AM
Post Re: Script for adding new positing in X position od db?
pugdog 15497 Aug 10, 1999, 4:46 AM
Post Re: Script for adding new positing in X position od db?
pugdog 15505 Aug 10, 1999, 4:47 AM
Post Re: Script for adding new positing in X position od db?
theguy 15541 Oct 25, 1999, 12:07 AM
Post Re: Script for adding new positing in X position od db?
herbalife 15588 Oct 25, 1999, 9:57 AM
Post Re: Script for adding new positing in X position od db?
herbalife 15525 Oct 25, 1999, 10:14 PM
Post Re: Script for adding new positing in X position od db?
theguy 15487 Oct 26, 1999, 12:00 AM
Post Re: Script for adding new positing in X position od db?
Kevin D 15542 Nov 22, 1999, 1:55 PM
Post Re: Script for adding new positing in X position od db?
theguy 15481 Nov 22, 1999, 2:18 PM
Post Re: Script for adding new positing in X position od db?
Denis 15571 Feb 29, 2000, 12:09 AM
Post Re: Script for adding new positing in X position od db?
Stealth 15535 Feb 29, 2000, 7:06 AM
Post Re: Script for adding new positing in X position od db?
Denis 15553 Feb 29, 2000, 8:57 PM
Post Re: Script for adding new positing in X position od db?
ffeingol 15530 Mar 1, 2000, 2:26 AM
Post Re: Script for adding new positing in X position od db?
Denis 15552 Mar 1, 2000, 9:10 AM
Post Re: Script for adding new positing in X position od db?
Denis 15509 Mar 1, 2000, 9:41 AM
Thread Re: Script for adding new positing in X position od db?
thefreebiesite 15492 May 3, 2000, 1:05 PM
Thread Re: Script for adding new positing in X position od db?
nubianz 4331 Oct 20, 2000, 9:35 PM
Post Re: Script for adding new positing in X position od db?
Stealth 4362 Oct 20, 2000, 9:40 PM