Gossamer Forum
Home : Gossamer Threads Inc. : Custom Modification Jobs :

Re: *LinksSQL 2* How much to convert my text db>MySQL?

Quote Reply
Re: *LinksSQL 2* How much to convert my text db>MySQL? In reply to
What I'm thinking is a hack to nph-build.cgi in sub _build_category, something like this:

Code:
while (my ($id, $name) = $sth->fetchrow_array) {
unless($id = nn){ #where nn is the numeric value for category Unassigned
$clean_name = $db->as_url($name);
$page = $CFG->{build_root_path} . "/" . $clean_name . '/' . $CFG->{build_index};
$url = $CFG->{build_root_url} . "/" . $clean_name . '/' . $CFG->{build_index};
$USE_HTML ?
print "\tBuilding category <a href='$url' target='_blank'>$name</a> ... \n" :
print "\tBuilding category $name ... \n";
_build_dir ($clean_name);
}
$total = $catlink_db->count ( { 'CatLinks.CategoryID' => $id, isValidated => 'Yes' } );
print "\t\tLinks: $total\n";
Am I on the right track?

Mark Brasche
http://SurfSafely.com/
Subject Author Views Date
Thread *LinksSQL 2* How much to convert my text db>MySQL? HomerUSA 11193 Mar 26, 2001, 1:32 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10986 Mar 26, 2001, 4:10 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
HomerUSA 10999 Mar 26, 2001, 5:03 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10979 Mar 26, 2001, 5:07 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
HomerUSA 10897 Mar 26, 2001, 5:23 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Paul 10912 Mar 26, 2001, 5:29 AM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10870 Apr 8, 2001, 4:56 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10901 Apr 12, 2001, 12:19 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10779 Apr 12, 2001, 1:34 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
Stealth 10763 Apr 12, 2001, 2:08 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10821 Apr 12, 2001, 4:12 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10746 Apr 12, 2001, 4:27 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10811 Apr 12, 2001, 6:07 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10670 Apr 14, 2001, 5:51 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Mel_g 10700 Apr 17, 2001, 8:59 AM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10678 Apr 17, 2001, 12:17 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10668 Apr 17, 2001, 1:26 PM
Thread Re: *LinksSQL 2* How much to convert my text db>MySQL?
Alex 10700 Apr 18, 2001, 3:39 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10589 Apr 18, 2001, 4:57 PM
Post Re: *LinksSQL 2* How much to convert my text db>MySQL?
surfsafely 10560 Apr 18, 2001, 9:07 PM