Thread Abfrage nicht vollständig, benötige Hilfe (14 answers)
Opened by Gast at 2007-09-27 14:45

Gast Gast
 2007-09-27 15:14
#100062 #100062
Hi,

so gehts leider auch nicht:

Code (perl): (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
my $dbh = DBI->connect("$db_name","$db_user","$db_pass") || die "Database connection not made: $DBI::errstr";
my $sth = $dbh->prepare("SELECT * FROM gtchat_pm_in WHERE pm_to = '$nick' AND new = '1' ORDER BY date DESC");    
$sth->execute();

my $count = $dbh->selectrow_array(q{SELECT COUNT(1) FROM gtchat_pm_in WHERE pm_to=? and new=1}, undef, $nick);
my $output = $main->createInfoOutput('newmails',{mails => $count});


return [$output];

$sth->finish();
$dbh->disconnect();

}

View full thread Abfrage nicht vollständig, benötige Hilfe