X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2Fpart_export%2Fradiator.pm;fp=FS%2FFS%2Fpart_export%2Fradiator.pm;h=95f0a0b016b82d43a0733ea592edbe899a4b887f;hb=3502e0627909ea99683d1724adb0d4a3fee578b2;hp=8f4a92911b5ad63ca79cbf08b29525a1fad38e65;hpb=f1da1afefb2501e1514d267612fafa87f0ac8108;p=freeside.git diff --git a/FS/FS/part_export/radiator.pm b/FS/FS/part_export/radiator.pm index 8f4a92911..95f0a0b01 100644 --- a/FS/FS/part_export/radiator.pm +++ b/FS/FS/part_export/radiator.pm @@ -1,6 +1,6 @@ package FS::part_export::radiator; -use vars qw(@ISA %info); +use vars qw(@ISA %info $radusers); use Tie::IxHash; use FS::part_export::sqlradius; @@ -21,6 +21,8 @@ END @ISA = qw(FS::part_export::sqlradius); #for regular sqlradius accounting +$radusers = 'RADUSERS'; #MySQL is case sensitive about table names! huh + #sub export_username { # my($self, $svc_acct) = (shift, shift); # $svc_acct->email; @@ -99,7 +101,7 @@ sub radiator_insert { #subroutine, not method my %hash = @_; my $sth = $dbh->prepare( - 'INSERT INTO radusers ( '. join(', ', keys %hash ). ' ) '. + "INSERT INTO $radusers ( ". join(', ', keys %hash ). ' ) '. 'VALUES ( '. join(', ', map '?', keys %hash ). ' ) ' ) or die $dbh->errstr; $sth->execute( values %hash ) @@ -114,7 +116,7 @@ sub radiator_replace { #subroutine, not method my ( $old_username, %hash ) = @_; my $sth = $dbh->prepare( - 'UPDATE radusers SET '. join(', ', map " $_ = ?", keys %hash ). + "UPDATE $radusers SET ". join(', ', map " $_ = ?", keys %hash ). ' WHERE username = ?' ) or die $dbh->errstr; $sth->execute( values(%hash), $old_username ) @@ -128,7 +130,7 @@ sub radiator_delete { #subroutine, not method my ( $username ) = @_; my $sth = $dbh->prepare( - 'DELETE FROM radusers WHERE username = ?' + "DELETE FROM $radusers WHERE username = ?" ) or die $dbh->errstr; $sth->execute( $username ) or die $sth->errstr;