I think its okay.... here's what I have:
sub switch_to_bikereviews {
#----------------------------------------------
$cols = 'BikeID,Name,Email,State,Country,Date,Brand,Model,Review,Category,Rating,Userid,Validated';
@db_cols = split /,/,$cols;
$db_file_name = $db_script_path . "/data/bikereviews.db";
$db_sort{'Date'} = 'date';
$db_validated_field = 'Validated';
}
sub switch_to_comments_bikereviews {
#-----------------------------------------------------
$cols = 'ReviewID,commentsName,commentsEmail,commentsDate,commentsReview,commentsRating,commentsUserid,commentsValidated,BikeID';
@db_cols = split /,/,$cols;
$db_file_name = $db_script_path . "/data/comments_bikereviews.db";
$db_key_pos = 0;
$db_validated_field = 'commentsValidated';
}
omments .cfg:
ReviewID => [0, 'numer', 5, 8, 1, '', ''],
commentsName => [1, 'alpha', 20, 50, 1, '', ''],
commentsEmail => [2, 'alpha', 20, 50, 1, '', ''],
commentsDate => [3, 'date', 12, 15, 1, &get_date, ''],
commentsReview => [4, 'alpha', 0, 500, 1, '', ''],
commentsRating => [5,'alpha', 0, 50, 1, '', ''],
commentsUserid => [6,'alpha', -2, 15, 0, '', ''],
commentsValidated => [7,'alpha', 0, 3, 0, 'No', 'Yes|No'],
BikeID => [8, 'numer', 5, 8, 1, '', '']
bikereviews cfg:
BikeID => [0, 'numer', 5, 8, 1, '', ''],
Name => [1, 'alpha', 20, 50, 1, '', ''],
Email => [2, 'alpha', 20, 50, 1, '', ''],
State => [3, 'alpha', 20, 50, 1, '', ''],
Country => [4, 'alpha', 20, 50, 1, '', ''],
Date => [5, 'date', 12, 15, 1, &get_date, ''],
Brand => [6, 'alpha', 20, 75, 1, '', ''],
Model => [7, 'alpha', 20, 75, 1, '', ''],
Review => [8, 'alpha', 0, 500, 0, '', ''],
Category => [9, 'alpha', 0, 50, 1, '', ''],
Rating => [10,'alpha', 0, 50, 1, '', ''],
Userid => [11,'alpha', -2, 15, 0, '', ''],
Validated => [12,'alpha', 0, 3, 0, 'No', 'Yes|No']
-----------
Jason Dulberg
Extreme MTB
http://extreme.nas.net