\n"; if ($config['password'] == '' && $_GET['action'] != 'install') {header("Location: $thisprogram?action=install"); exit;} // AUTOMATICALLY ADD THE NEW OPTIONS PARAMETERS FOR USERS WHO ARE UPGRADING FROM AN OLDER VERSION if (!isset($config['icode_req'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_req` INT( 1 ) DEFAULT '1' NOT NULL ;"); } if (!isset($config['icode_font'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_font` TINYTEXT NOT NULL ;"); mysql_query("UPDATE `pblguestbook_config` SET `icode_font` = 'actionj.ttf'"); } if (!isset($config['icode_bgimg'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_bgimg` TINYTEXT NOT NULL ;"); mysql_query("UPDATE `pblguestbook_config` SET `icode_bgimg` = 'imgcodebg.gif'"); } if (!isset($config['icode_fontsize'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_fontsize` TINYTEXT NOT NULL ;"); mysql_query("UPDATE `pblguestbook_config` SET `icode_fontsize` = '30'"); } if (!isset($config['icode_fontcolor'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_fontcolor` TINYTEXT NOT NULL ;"); mysql_query("UPDATE `pblguestbook_config` SET `icode_fontcolor` = '#000000'"); } if (!isset($config['icode_bgcolor'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `icode_bgcolor` TINYTEXT NOT NULL ;"); mysql_query("UPDATE `pblguestbook_config` SET `icode_bgcolor` = '#FFFFFF'"); } if (!isset($config['appfirst'])) { @mysql_query("ALTER TABLE `pblguestbook_config` ADD `appfirst` INT( 1 ) DEFAULT '0' NOT NULL ;"); @mysql_query("ALTER TABLE `pblguestbook_posts` ADD `app` INT( 1 ) DEFAULT '1' NOT NULL ;"); } if ($config['icode_req'] == '1') { require ("imgcode.php"); } if ($_GET['action'] == 'view') { if ($_GET['start'] == '' || $_GET['start'] == '0') { $start = '0'; } else { $start = $_GET['start']; $back = "« " . $mes['previous'] . ""; $back = str_replace("&start=0","",$back); } $end = $start + $config['perpage']; $totalres = mysql_query("SELECT * FROM `pblguestbook_posts`"); $totalposts = mysql_num_rows($totalres); if ($totalposts > $end) { $next = "" . $mes['next'] . " »"; } if ($back != '' && $next != '') {$div = " · ";} $picount = 0; $maxpages = $totalposts / $config['perpage']; if (ereg("\.",$maxpages)) { list ($maxpages,$remainder) = split("\.",$maxpages); $maxpages++; } for ($i = 1; $i <= $maxpages; $i++) { if ($i > 1) { $picount += $config['perpage']; } if ($picount == $start) { $isipage = "SELECTED"; } else { $isipage = ""; } $piurl = "$thisprogram?action=view&start=$picount"; $piurl = str_replace("&start=0","",$piurl); $pilist .= ""; } $title = str_replace('$booktitle',$booktitle,$mes['page_view_title']); $predata .= "
"; $predata .= "\n"; $predata .= "$booktitle » " . strtoupper($mes['view']); $predata .= " (" . $mes['sign']; $predata .= ") | $back$div$next |
\n"; $enditem = $config['perpage']; $result = mysql_query("SELECT `id` FROM `pblguestbook_posts` WHERE `app` = '1' ORDER BY `time` DESC LIMIT $start,$enditem"); while ($myrow = mysql_fetch_array($result)) { $pdata = make_post($myrow['id']); $data .= ontable($pdata) . "\n
\n";
}
}
elseif ($_GET['action'] == 'sign')
{
$_POST['website'] = str_replace("http://","",$_POST['website']);
$lastres = mysql_query("SELECT * FROM `pblguestbook_posts` ORDER BY `time` DESC LIMIT 1");
$lr = mysql_fetch_array($lastres);
$newtime = time();
$newtime += ($config['timezone'] * 3600);
if (($newtime - $lr['time']) <= $config['hamsecs'] && $lr['ip'] == $_SERVER['REMOTE_ADDR'] && $config['hammer'] == '1')
{
$hammer = 'y';
}
if ($_POST['name'] != '' && $hammer != 'y' && $_POST['preview'] == '' && strtoupper($_POST['icode']) == get_image_code())
{
foreach ($_POST as $name => $value)
{
$_POST["$name"] = str_replace("\n","
",$value);
}
foreach ($_POST as $name => $value)
{
$_POST["$name"] = str_replace("\t","",$value);
}
foreach ($_POST as $name => $value)
{
$_POST["$name"] = str_replace("\r","",$value);
}
foreach ($_POST as $name => $value)
{
$_POST["$name"] = str_replace('|',"¦",$value);
}
foreach ($_POST as $name => $value)
{
$_POST["$name"] = preg_replace("/\