X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=blobdiff_plain;f=Commands%2FPA.pm;h=52fb3a007a1241c3cdc9e234f3c244cc3defde45;hp=2dcb00671d0c90ccc3355f138606ffd50ce7100d;hb=a7e034b3599d41cdf5a158b14bd1715451f89a0c;hpb=87ddd7d37d6f5880757a71bfedd3459f4a511d2b diff --git a/Commands/PA.pm b/Commands/PA.pm index 2dcb006..52fb3a0 100644 --- a/Commands/PA.pm +++ b/Commands/PA.pm @@ -126,8 +126,8 @@ sub xp my ($avalue,$ascore) = $c->model->selectrow_array(q{ SELECT value,score FROM current_planet_stats -WHERE pid = (SELECT pid FROM users WHERE hostmask ILIKE ?) - }, undef, $c->host); +WHERE pid = (SELECT pid FROM users WHERE uid = ?) + }, undef, $c->uid); my ($tvalue,$tscore,$tsize) = $c->model->selectrow_array(q{ SELECT value,score,size FROM current_planet_stats WHERE x = ? AND y = ? and z = ? @@ -167,8 +167,8 @@ sub fco my ($value,$score) = $c->model->selectrow_array(q{ SELECT value,score FROM planet_stats WHERE tick = $2 AND - pid = (SELECT pid FROM users WHERE hostmask ILIKE $1) - }, undef, $c->host,$tick); + pid = (SELECT pid FROM users WHERE uid = $1) + }, undef, $c->uid,$tick); unless ($value){ $c->reply("You don't have a planet registered."); return;