|
 |
 |
|
|
 |
#!/usr/bin/perl
BEGIN {
open(STDERR, '>> error.log');
}
print "Content-type: text/html\n\n";
use DBI;
$dbh = DBI->connect("DBI:mysql:database=alvigo:host=localhost", "alvigo", "8432ujre");
my $sth = $dbh->table_info;
$sth->execute();
while (my @row = $sth->fetchrow_array ) {
if ($row[2] eq "News") {$table_ok = 1}
}
if (!$table_ok) {
print "creating db\n";
$dbh->do(<
 |
|;
$allservs = $dbh->prepare("SELECT News_ID, Time, IP, Administrator, Message FROM News WHERE Lang=1 ORDER BY Time DESC LIMIT 5");
$allservs->execute;
while(@st = $allservs->fetchrow_array) {
$row_date=&fdate($st[1]);
#if (length($st[4]) > 5) { $short_msg = substr($st[4], 5, length($st[4])-5) . " ..."; }
if (length($st[4]) > 64) { $short_msg = substr($st[4], 0, 64) . " ..."; }
else { $short_msg = $st[4]; }
@b=split(//, $short_msg);
foreach $a (@b) {
#print $_;
if ($a eq '*' && $wasb == 1) { $wasb=0; $a=''; }
elsif ($a eq '*' && $wasb == 0) { $wasb=1; $a=''; }
}
# print @b;
$short_msg=join('', @b);
print qq|[$row_date]
$short_msg
|;
}
print qq|
| |;
$dbh->disconnect;
sub fdate {
my ($ftime) = shift;
my (undef, undef, undef, $wday, $wmonth, $wyear) = localtime($ftime);
return sprintf "%02i.%02i.%04i", $wday, $wmonth+1, $wyear+1900;
}
|
|
|
|
|
|
|
|
|
|
|
|
