X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=bin%2Fimport_ward_data;h=560650a517eb92d278497134d91b111962cd114d;hb=e9ca9544dc03c8e3e554c619d1a5dcf8599cb65a;hp=f2fa90ba2464b6248755ce5f9c84ef24ea371f79;hpb=428f6a4f9c29acce79cd2a94081185bd3fd262d9;p=eq%2F.git

diff --git a/bin/import_ward_data b/bin/import_ward_data
index f2fa90b..560650a 100755
--- a/bin/import_ward_data
+++ b/bin/import_ward_data
@@ -109,7 +109,7 @@ sub print_hash
 #| Field       | Type             | Null | Key | Default | Extra          |
 #+-------------+------------------+------+-----+---------+----------------+
 #| individual  | int(16) unsigned |      | PRI | NULL    | auto_increment |
-#| mls_indiv_id| int(16) unsigned |      |     | NULL    |                |
+#| mls_id      | int(16) unsigned |      |     | NULL    |                |
 #| name        | varchar(60)      | YES  |     | NULL    |                |
 #| phone       | varchar(12)      | YES  |     | NULL    |                |
 #| email       | varchar(120)     | YES  |     | NULL    |                |
@@ -181,7 +181,7 @@ sub update_tc_individual_table
 			$sth->execute or die "-E- DB error: $DBI::errstr\n";
 			$sth = $dbh->prepare("update tc_individual set attending='$attending' where name=\"$individual_name\"");
 			$sth->execute or die "-E- DB error: $DBI::errstr\n";
-			$sth = $dbh->prepare("update tc_individual set mls_indiv_id='$id' where name=\"$individual_name\"");
+			$sth = $dbh->prepare("update tc_individual set mls_id='$id' where name=\"$individual_name\"");
 			$sth->execute or die "-E- DB error: $DBI::errstr\n";
 			$sth = $dbh->prepare("update tc_individual set priesthood='$priesthood' where name=\"$individual_name\"");
 			$sth->execute or die "-E- DB error: $DBI::errstr\n";
@@ -546,7 +546,7 @@ sub check_for_changed_ids
 
 	foreach $oldindex (keys %$oldhashref)
 	{
-		$mls_indiv_id = $oldhashref->{$oldindex}{'Indiv ID'};
+		$mls_id = $oldhashref->{$oldindex}{'Indiv ID'};
 		$hofh_id  = $oldhashref->{$oldindex}{'HofH ID'};
 		$full_name = $oldhashref->{$oldindex}{'Full Name'};
 		$hh_position = $oldhashref->{$oldindex}{'HH Position'};
@@ -555,9 +555,9 @@ sub check_for_changed_ids
 		foreach $newindex (keys %$newhashref)
 		{
 			if($newhashref->{$newindex}{'Full Name'} eq $full_name &&
-			   $mls_indiv_id != $newhashref->{$newindex}{'Indiv ID'})
+			   $mls_id != $newhashref->{$newindex}{'Indiv ID'})
 			{
-				print "-W- Indiv ID for $full_name changed from $mls_indiv_id to $newhashref->{$newindex}{'Indiv ID'}\n";
+				print "-W- Indiv ID for $full_name changed from $mls_id to $newhashref->{$newindex}{'Indiv ID'}\n";
 				$found_problem = 1;
 			}