"; print ""; print ""; print ""; print ""; print ""; print ""; $gbvar="Select * FROM gbook order by ID DESC LIMIT " . $start . ", $numentries"; //retrieve entries from sql $row=mysql_query($gbvar); $formatcount=0; //color display counter while($gbvalues=mysql_fetch_array($row)) { $gbvalues[comment]=htmlspecialchars($gbvalues[comment]); $gbvalues[name]=htmlspecialchars($gbvalues[name]); $gbvalues[country]=htmlspecialchars($gbvalues[country]); $gbvalues[comment]=BBCode($gbvalues[comment]); $gbvalues[comment]=smile($gbvalues[comment]); if ($formatcount%2==0) { print ""; print ""; $formatcount++; } else { print ""; print ""; $formatcount++; } } print "

GuestBook	"; print ""; print " "; if(!isset($_GET['start'])) { $start=0; } else { $start=$_GET['start']; } $order="SELECT * from gbook"; $order2=mysql_query($order) or die(mysql_error()); $d=0; $f=0; $g=1+$d/$numentries; $num=mysql_num_rows($order2); print "Page: "; $prev=$start-$numentries; $next=$start+$numentries; if($start>=$numentries) { print "<< "; } while($order3=mysql_fetch_array($order2)) { if($f>=$start-3*$numentries&&$f<=$start+7*$numentries) { if($f%$numentries==0) { print "$g "; } } $d=$d+1; $g=1+$d/$numentries; $f++; } if($start<=$num-$numentries) { print ">> "; } print " "; print "[Sign Guestbook]"; print " "; print "
"; print ""; print "$gbvalues[realtime] "; print "$gbvalues[name] "; print "$gbvalues[country] "; if($gbvalues[homepage]) { $pos = strpos($gbvalues[homepage], '/'); if ($pos === false) { print " "; } else { print " "; } } if($gbvalues[mail]) { print " "; } if($gbvalues[aim]) { print " "; } if($gbvalues[icq]) { print " "; } if($gbvalues[msn]) { print " "; } if($gbvalues[yim]) { print " "; } if(isset($_SESSION['username'])) { print" IP: $gbvalues[IP]"; } print "	"; print ""; $gbvalues[comment] = wordwrap( $gbvalues[comment], 19, "\n", 1); print "$gbvalues[comment]"; if(isset($_SESSION['username'])) { print " Edit  Delete"; } print "
"; print ""; print "$gbvalues[realtime] "; print "$gbvalues[name] "; print "$gbvalues[country] "; if($gbvalues[homepage]) { $pos = strpos($gbvalues[homepage], '/'); if ($pos === false) { print " "; } else { print " "; } } if($gbvalues[mail]) { print " "; } if($gbvalues[aim]) { print " "; } if($gbvalues[icq]) { print " "; } if($gbvalues[msn]) { print " "; } if($gbvalues[yim]) { print " "; } if(isset($_SESSION['username'])) { print" IP: $gbvalues[IP]"; } print "	"; print ""; $gbvalues[comment] = wordwrap( $gbvalues[comment], 19, "\n", 1); print "$gbvalues[comment]"; if(isset($_SESSION['username'])) { print " Edit  Delete"; } print "

"; ?> tags $Text = nl2br($Text); // Set up the parameters for a URL search string $URLSearchString = " a-zA-Z0-9\:\/\-\?\&\.\=\_\~\#\'"; // Set up the parameters for a MAIL search string $MAILSearchString = $URLSearchString . " a-zA-Z0-9\.@"; // Perform URL Search $Text = preg_replace("/\[url\]([$URLSearchString]*)\[\/url\]/", '$1', $Text); $Text = preg_replace("(\[url\=([$URLSearchString]*)\]([$URLSearchString]*)\[/url\])", '$2', $Text); $Text = preg_replace("/\[URL\]([$URLSearchString]*)\[\/URL\]/", '$1', $Text); $Text = preg_replace("(\[URL\=([$URLSearchString]*)\]([$URLSearchString]*)\[/URL\])", '$2', $Text); // Perform MAIL Search $Text = preg_replace("(\[mail\]([$MAILSearchString]*)\[/mail\])", '$1', $Text); $Text = preg_replace("/\[mail\=([$MAILSearchString]*)\](.+?)\[\/mail\]/", '$2', $Text); // Check for bold text $Text = preg_replace("(\[b\](.+?)\[\/b])is",'$1',$Text); // Check for Italics text $Text = preg_replace("(\[i\](.+?)\[\/i\])is",'$1',$Text); // Check for Underline text $Text = preg_replace("(\[u\](.+?)\[\/u\])is",'$1',$Text); // Check for strike-through text $Text = preg_replace("(\[s\](.+?)\[\/s\])is",'$1',$Text); // Check for over-line text $Text = preg_replace("(\[o\](.+?)\[\/o\])is",'$1',$Text); // Check for colored text $Text = preg_replace("(\[color=(.+?)\](.+?)\[\/color\])is","$2",$Text); // Check for sized text $Text = preg_replace("(\[size=(.+?)\](.+?)\[\/size\])is","$2",$Text); // Check for list text $Text = preg_replace("/\[list\](.+?)\[\/list\]/is", '

$1

' ,$Text); $Text = preg_replace("/\[list=1\](.+?)\[\/list\]/is", '

$1

' ,$Text); $Text = preg_replace("/\[list=i\](.+?)\[\/list\]/s", '

$1

' ,$Text); $Text = preg_replace("/\[list=I\](.+?)\[\/list\]/s", '

$1

' ,$Text); $Text = preg_replace("/\[list=a\](.+?)\[\/list\]/s", '

$1

' ,$Text); $Text = preg_replace("/\[list=A\](.+?)\[\/list\]/s", '

$1

' ,$Text); $Text = str_replace("[*]", "

", $Text); // Check for font change text $Text = preg_replace("(\[font=(.+?)\](.+?)\[\/font\])","$2",$Text); // Images // [img]pathtoimage[/img] $Text = preg_replace("/\[IMG\](.+?)\[\/IMG\]/", '', $Text); $Text = preg_replace("/\[img\](.+?)\[\/img\]/", '', $Text); // [img=widthxheight]image source[/img] $Text = preg_replace("/\[img\=([0-9]*)x([0-9]*)\](.+?)\[\/img\]/", '', $Text); return $Text; } ?> "", ':(' => "", ':p' => "", ';)' => "", ';smirk' => "", ':blush' =>"", ':angry' =>"", ':shocked'=> "", ':ninja'=>"", ':cool'=>"", '(!)'=>"", '(?)'=>"", '(heart)'=>"", ':{blink}'=>"", '{clover}'=>"", ':[glasses]'=>"", ':[barf]'=>"", ':[reallymad]'=>"", ':[evil]'=>"" ); $post=str_replace(array_keys($smilies), array_values($smilies), $post); return $post; } ?>