config.php - Aonde se encontra as config do meu script (Ex.: DB, user, pass)
<?
$host = 'localhost';
$user = 'luiz';
$pass = 'luiz';
$banco = 'fotolog';
$pasta = 'c:\\easyphp\www\\fotolog\\';
?>
instal.php - Qndo entra nessa pagina mostra uma pagina com um monte de formulario aonde fica as config do fotolog (Ex.: Título, Cores, E-mail, senha, etc...), após terminar de preencher os dados e clicar em prosseguir o script é instalado
<?
$controle = $HTTP_POST_VARS['controle'];
$senha = $HTTP_POST_VARS['senha'];
$senha1 = $HTTP_POST_VARS['senha1'];
$titulo = $HTTP_POST_VARS['titulo'];
$email = $HTTP_POST_VARS['email'];
$display = $HTTP_POST_VARS['display'];
$cidade = $HTTP_POST_VARS['cidade'];
$estado = $HTTP_POST_VARS['estado'];
$pais = $HTTP_POST_VARS['pais'];
$sexo = $HTTP_POST_VARS['sexo'];
$dianas = $HTTP_POST_VARS['dianas'];
$mesnas = $HTTP_POST_VARS['mesnas'];
$anonas = $HTTP_POST_VARS['anonas'];
$pagina = $HTTP_POST_VARS['pagina'];
$obs = $HTTP_POST_VARS['obs'];
$bgcol = $HTTP_POST_VARS['bgcol'];
$textcol = $HTTP_POST_VARS['textcol'];
$linkcol = $HTTP_POST_VARS['linkcol'];
$textsize = $HTTP_POST_VARS['textsize'];
if($textsize>10 || $textsize<1){
$textsize=10;
}
$navcol = $HTTP_POST_VARS['navcol'];
$guestmail = $HTTP_POST_VARS['guestmail'];
if($controle=="instalar"){
if($senha==$senha1){
$senha=md5($senha);
if($email!=NULL && $display!=NULL && $cidade!=NULL && $estado!=NULL && $pais!=NULL && $bgcol!=NULL && $textcol!=NULL && $linkcol!=NULL && $textsize!=NULL && $navcol!=NULL && $guestmail!=NULL)
{
include "classe.php";
$objeto = new conexaobd();
$objeto->conectar();
$objeto2 = new consulta();
$objeto2->query2("create table flashflog(titulo varchar(100), data timestamp, tipo int(3) not null, comentario blob, primary key(data));");
$objeto2->query2("create table guestlog(data timestamp, datapost timestamp, nome varchar(100) not null, link varchar(255) not null, comentario blob not null)");
$objeto2->query2("create table linklog(alias varchar(100), endereco varchar(255));");
$objeto2->query2("create table pessoalog(titulo varchar(100), senha varchar(32) not null,email varchar(100) not null, display int(1) not null, cidade varchar(100) not null, estado varchar(2) not null, pais varchar(100) not null, sexo int(1), dianas int(2), mesnas int(2) not null, anonas int(4), pagina varchar(255), obs blob, bgcol varchar(6) not null, textcol varchar(6) not null, linkcol varchar(6) not null, textsize int(2) not null, navcol int(2) not null, guestmail int(1) not null);");
$objeto2->query2("create table acessolog(id int(20) not null, primary key(id));");
$objeto2->query2("insert into pessoalog (titulo, senha, email, display, cidade, estado, pais, sexo, dianas, mesnas, anonas, obs, bgcol, textcol, linkcol, textsize, navcol, guestmail) values ('$titulo', '$senha', '$email' , $display, '$cidade', '$estado', '$pais', $sexo, $dianas, $mesnas, $anonas, '$obs', '$bgcol', '$textcol', '$linkcol', $textsize, $navcol, $guestmail);");
echo "<BR>Agora apague este arquivo.";
}else{
echo "Algum campo Obrigatório vazio";
}
}else{
echo "Senha Inválida";
}
}else{
?>
<HTML>
<HEAD>
<TITLE>
Instalando o Flashflog
</TITLE>
</HEAD>
<BODY>
<FORM METHOD=POST ACTION="instal.php">
<INPUT TYPE="hidden" NAME="controle" value="instalar">
<TABLE>
<TR>
<TD>Titulo:</TD>
<TD><INPUT TYPE="text" NAME="titulo"></TD>
</TR>
<TR>
<TD>* Senha:</TD>
<TD><INPUT TYPE="password" NAME="senha"></TD>
</TR>
<TR>
<TD>* Repita a senha:</TD>
<TD><INPUT TYPE="password" NAME="senha1"></TD>
</TR>
<TR>
<TD>* Email:</TD>
<TD><INPUT TYPE="text" NAME="email"></TD>
</TR>
<TR>
<TD>* Deseja Mostrar o Email:</TD>
<TD>Sim: <INPUT TYPE="radio" NAME="display" value=1> Não: <INPUT TYPE="radio" NAME="display" value=0 CHECKED></TD>
</TR>
<TR>
<TD>* Cidade:</TD>
<TD><INPUT TYPE="text" NAME="cidade"></TD>
</TR>
<TR>
<TD>* Estado:</TD>
<TD>
<select name="estado">
<option value="AC">AC</option>
<option value="AL">AL</option>
<option value="AM">AM</option>
<option value="AP">AP</option>
<option value="BA">BA</option>
<option value="CE">CE</option>
<option value="DF">DF</option>
<option value="ES">ES</option>
<option value="GO">GO</option>
<option value="MA">MA</option>
<option value="MG">MG</option>
<option value="MS">MS</option>
<option value="MT">MT</option>
<option value="PA">PA</option>
<option value="PB">PB</option>
<option value="PE">PE</option>
<option value="PI">PI</option>
<option value="PR">PR</option>
<option value="RJ">RJ</option>
<option value="RN">RN</option>
<option value="RO">RO</option>
<option value="RR">RR</option>
<option value="RS">RS</option>
<option value="SC">SC</option>
<option value="SE">SE</option>
<option value="SP">SP</option>
<option value="TO">TO</option>
</select>
</TD>
</TR>
<TR>
<TD>* Pais:</TD>
<TD><INPUT TYPE="text" NAME="pais" value=Brasil></TD>
</TR>
<TR>
<TD>Sexo:</TD>
<TD>Mas: <INPUT TYPE="radio" NAME="sexo" value=1> Fem: <INPUT TYPE="radio" NAME="sexo" value=0></TD>
</TR>
<TR>
<tr>
<td>Data do Nascimento:</td>
<td><SELECT NAME="dianas">
<OPTION> </OPTION>
<OPTION SELECTED VALUE="01">01</OPTION>
<OPTION value="02">02</OPTION>
<OPTION value="03">03</OPTION>
<OPTION value="04">04</OPTION>
<OPTION value="05">05</OPTION>
<OPTION value="06">06</OPTION>
<OPTION value="07">07</OPTION>
<OPTION value="08">08</OPTION>
<OPTION value="09">09</OPTION>
<OPTION value="10">10</OPTION>
<OPTION value="11">11</OPTION>
<OPTION value="12">12</OPTION>
<OPTION value="13">13</OPTION>
<OPTION value="14">14</OPTION>
<OPTION value="15">15</OPTION>
<OPTION value="16">16</OPTION>
<OPTION value="17">17</OPTION>
<OPTION value="18">18</OPTION>
<OPTION value="19">19</OPTION>
<OPTION value="20">20</OPTION>
<OPTION value="21">21</OPTION>
<OPTION value="22">22</OPTION>
<OPTION value="23">23</OPTION>
<OPTION value="24">24</OPTION>
<OPTION value="25">25</OPTION>
<OPTION value="26">26</OPTION>
<OPTION value="27">27</OPTION>
<OPTION value="28">28</OPTION>
<OPTION value="29">29</OPTION>
<OPTION value="30">30</OPTION>
<OPTION value="31">31</OPTION>
</SELECT>
<SELECT NAME="mesnas">
<OPTION> </OPTION>
<OPTION VALUE="1">01</OPTION>
<OPTION value="2">02</OPTION>
<OPTION value="3">03</OPTION>
<OPTION value="4">04</OPTION>
<OPTION value="5">05</OPTION>
<OPTION value="6">06</OPTION>
<OPTION value="7">07</OPTION>
<OPTION value="8">08</OPTION>
<OPTION value="9">09</OPTION>
<OPTION value="10">10</OPTION>
<OPTION value="11">11</OPTION>
<OPTION value="12">12</OPTION>
</SELECT>
<input type="text" name="anonas" size=4 MAXLENGHT=4>
</td>
</tr>
<TR>
<TD>Sobre Você:</TD>
<TD><TEXTAREA NAME="obs" ROWS="" COLS=""></TEXTAREA></TD>
</TR>
<TR>
<TD>* Cor de Fundo #:</TD>
<TD><INPUT TYPE="text" NAME="bgcol" value="FFFFFF"></TD>
</TR>
<TR>
<TD>* Cor do Texto #:</TD>
<TD><INPUT TYPE="text" NAME="textcol" value="000000"></TD>
</TR>
<TR>
<TD>* Cor do Link #:</TD>
<TD><INPUT TYPE="text" NAME="linkcol" value="0000FF"></TD>
</TR>
<TR>
<TD>* Tamanho da Fonte do Título: (max 10)</TD>
<TD><INPUT TYPE="text" NAME="textsize" value="2" size=2 MAXLENGHT=2></TD>
</TR>
<TR>
<TD>* Barra de Navegação:</TD>
<TD><SELECT NAME="navcol">
<OPTION VALUE=1>Cinza</OPTION>
<OPTION VALUE=0>Seguir o esquema do fotolog</OPTION>
</SELECT></TD>
</TR>
<TR>
<TD>* Email quando comentar:</TD>
<TD>Sim: <INPUT TYPE="radio" NAME="guestmail" value=1> Não: <INPUT TYPE="radio" NAME="guestmail" value=0 CHECKED></TD>
</TR>
<TD><INPUT TYPE="submit" value="Enviar"></TD>
<TD><INPUT TYPE="reset" value="Limpar"></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
<?
}
?>
index.php - É a pagina principal do script, aonde seria preciso fazer com que seja um index para todos os fotolog, sendo assim qndo precisar de modificar os index de todos os usuarios, basta modificar este.
<?
include("classe.php");
$objeto = new conexaobd();
$objeto->conectar();
$objeto2 = new consulta();
$data=$_GET["data"];
$acao=$_POST["acao"];
$dataguest=$_POST["dataguest"];
$nomeguest=$_POST["nomeguest"];
$linkguest=$_POST["linkguest"];
$comentguest=$_POST["comentguest"];
$datapostguest=date("YmdHis");
if($data==NULL){
$flashflog=$objeto2->query("select * from flashflog ORDER BY data DESC");
}else{
$flashflog=$objeto2->query("select * from flashflog where data=$data");
}
$queryflashf=@mysql_fetch_array($flashflog);
$titulo=$queryflashf["titulo"];
$pessoal=$objeto2->query("select * from pessoalog");
$queryflashf=@mysql_fetch_array($pessoal);
$bgcol=$queryflashf["bgcol"];
$display=$queryflashf["display"];
$guestmail=$queryflashf["guestmail"];
if($display==1){
$email=$queryflashf["email"];
}
$textcol=$queryflashf["textcol"];
$linkcol=$queryflashf["linkcol"];
$textsize=$queryflashf["textsize"];
$navcol=$queryflashf["navcol"];
if($bgcol!=NULL && $titulo!=NULL){
?>
<HTML>
<HEAD>
<TITLE>
<? echo $titulo; ?>
</TITLE>
</HEAD>
<BODY BGCOLOR=<? echo "#$bgcol"; ?> LINK=<? echo"#$linkcol"; ?> VLINK=<? echo"#$linkcol"; ?> ALINK=<? echo"#$linkcol"; ?>><CENTER>
<?
@session_start('admin');
if(!(session_is_registered('admin') AND session_is_registered('passad'))) {
}else{
if($navcol==1){
$navb script: sobre = window.open('sobre.php','sobre', 'toolbar=no,scrollbars=yes,width=400,height=400'); sobre.focus() ;">Sobre</A>
</TD>
</TR>
<TR>
<TD VALIGN=TOP ALIGN=CENTER WIDTH=20%>
<FONT FACE=VERDANA SIZE=3 COLOR=<? echo "#$textcol"; ?>>
</FONT><BR><BR>
<?
$flashflog=$objeto2->query("select * from flashflog ORDER BY data DESC LIMIT 6");
while($queryflashf=mysql_fetch_array($flashflog)){
$datada=$queryflashf["data"];
$tipada=$queryflashf["tipo"];
if($tipada==0){
if($data==NULL){
$borda=3;
$corado=$textcol;
$data=-1;
}elseif($data==$datada){
$borda=3;
$corado=$textcol;
}else{
$borda=0;
$corado=$bgcol;
}
?>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0>
<TR>
<TD VALIGN=CENTER ALIGN=CENTER>
<? if($corado!=$textcol){ ?>
<A HREF=<? echo "index.php?data=$datada"; ?>>
<? } ?>
<IMG SRC=<? echo "thumb/$datada.jpg"; ?> WIDTH=100 HEIGHT=75 BORDER=<? echo $borda;?>>
<? if($corado!=$textcol){ ?>
</A>
<? } ?>
</TD>
<TD VALIGN=CENTER ALIGN=CENTER>
</TD>
</TR>
</TABLE>
<?
}else{
if($data==NULL){
$borda=3;
$corado=$textcol;
$data=-1;
}elseif($data==$datada){
$borda=3;
$corado=$textcol;
}else{
$borda=0;
$corado=$bgcol;
}
?>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0>
<TR>
<TD VALIGN=CENTER ALIGN=CENTER>
<? if($corado!=$textcol){ ?>
<A HREF=<? echo "index.php?data=$datada"; ?>>
<? } ?>
<IMG SRC=<? echo "flash/$datada.swf"; ?> WIDTH=100 HEIGHT=75 BORDER=<? echo $borda;?>>
<? if($corado!=$textcol){ ?>
</A>
<? } ?>
</TD>
<TD VALIGN=CENTER ALIGN=CENTER>
</TD>
</TR>
</TABLE>
<?
}
?>
<CENTER><FONT FACE=VERDANA SIZE=2 COLOR=<? echo "#$textcol"; ?>> <? echo "$datada[6]$datada[7]/$datada[4]$datada[5]/$datada[0]$datada[1]$datada[2]$datada[3]"; ?> <BR><BR></FONT></CENTER>
<?
}
?>
<A HREF="tudo.php">mais</A></FONT>
</TD>
<TD VALIGN=TOP ALIGN=CENTER WIDTH=60%> <BR>
<TABLE CELLPADDING=0 CELLSPACING=0 WIDTH=500 BORDER=0>
<TR>
<TD ALIGN=CENTER>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%>
<TR>
<TD WIDTH=15% ALIGN=LEFT>
<FONT FACE=VERDANA SIZE=2 COLOR=<? echo "#$textcol"; ?>>
<?
$flashflog=$objeto2->query("select data from flashflog ORDER BY data ASC");
$queryflashf=mysql_fetch_array($flashflog);
$dataprev=$queryflashf["data"];
$flashflog=$objeto2->query("select data from flashflog ORDER BY data DESC");
$linha=mysql_num_rows($flashflog);
$queryflashf=mysql_fetch_array($flashflog);
$datault=$queryflashf["data"];
if($data==-1)
$datala=$datault;
else
$datala=$data;
$flashflog=$objeto2->query("select * from flashflog where data<$datala ORDER BY data ASC");
$queryflashf=mysql_fetch_array($flashflog);
$datant=$queryflashf["data"];
if($linha>1 && $datala!=$dataprev){
?>
<A HREF=<? echo "index.php?data=$datant"; ?>><< <font size=2>anterior</A>
<?
}
?>
</FONT>
</TD>
<TD WIDTH=70% ALIGN=CENTER>
<FONT FACE=VERDANA SIZE=2 COLOR=<? echo "#$textcol"; ?>>
<A HREF=<? echo "email.php?data=$datala"; ?>>Envie esta foto</A><BR>
</FONT>
</TD>
<TD WIDTH=15% ALIGN=RIGHT>
<FONT FACE=VERDANA SIZE=2 COLOR=<? echo "#$textcol"; ?>>
<?
$flashflog=$objeto2->query("select data from flashflog ORDER BY data DESC");
$queryflashf=mysql_fetch_array($flashflog);
$dataprev=$queryflashf["data"];
$flashflog=$objeto2->query("select data from flashflog ORDER BY data ASC");
$linha=mysql_num_rows($flashflog);
$queryflashf=mysql_fetch_array($flashflog);
$datault2=$queryflashf["data"];
if($data==-1)
$datala=$datault;
else
$datala=$data;
$flashflog=$objeto2->query("select * from flashflog where data>$datala ORDER BY data DESC");
$queryflashf=mysql_fetch_array($flashflog);
$datant=$queryflashf["data"];
if($linha>1 && $datala!=$dataprev){
?>
<A HREF=<? echo "index.php?data=$datant"; ?>><< <font size=2>próxima</A>
<?
}
?>
</FONT>
</TD>
</TR>
</TABLE><BR>
<?
if($data==-1){
$flashflog=$objeto2->query("select * from flashflog ORDER BY data DESC");
$queryflashf=mysql_fetch_array($flashflog);
$data=$queryflashf["data"];
$tipado=$queryflashf["tipo"];
$coment=$queryflashf["comentario"];
}
else{
$flashflog=$objeto2->query("select * from flashflog where data=$data");
$queryflashf=mysql_fetch_array($flashflog);
$tipado=$queryflashf["tipo"];
$coment=$queryflashf["comentario"];
}
if($tipado==0){
?>
<IMG SRC=<? echo "fotos/$data.jpg"; ?> BORDER=0>
<?
}else{
?>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macr...ersion=7,0,2,0" width="500" height="375">
<param name=movie value=<? echo "flash/$data.swf"; ?>>
<param name=quality value=high>
<embed src=<? echo "flash/$data.swf"; ?> quality=high pluginspage="http://www.macromedi...ShockwaveFlash" type="application/x-shockwave-flash" width="500" height="375">
</embed> </object>
<?
}
?>
<DIV ALIGN="LEFT">
<FONT FACE=VERDANA SIZE=<? echo $textsize; ?> COLOR=<? echo "#$textcol> $data[6]$data[7]/$data[4]$data[5]/$data[0]$data[1]$data[2]$data[3]"; ?> <BR><BR><? echo $coment; ?><HR>
</FONT>
</DIV>
</TD>
</TR>
<TR>
<TD ALIGN=LEFT>
<CENTER>
<FONT FACE=VERDANA SIZE=<? echo $textsize; ?> COLOR=<? echo "#$textcol"; ?>><B>Livro de Visitas</B><BR><BR></FONT></CENTER>
<?
@session_start('admin');
if(!(session_is_registered('admin') AND session_is_registered('passad'))) {
$delete=1;
}else{
$delete=0;
}
$guest=$objeto2->query("select * from guestlog where data=$data");
while($queryguest=mysql_fetch_array($guest)){
$nome=htmlspecialchars($queryguest["nome"]);
$datada=htmlspecialchars($queryguest["datapost"]);
$link=htmlspecialchars($queryguest["link"]);
$coment=htmlspecialchars($queryguest["comentario"]);
if($coment!=NULL){
if($link==NULL){
echo "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%><TR><TD WIDTH=50% ALIGN=LEFT><FONT FACE=VERDANA SIZE=$textsize COLOR='#$textcol'><A NAME='$datada'><I>$nome @</A> $datada[6]$datada[7]/$datada[4]$datada[5]/$datada[0]$datada[1]$datada[2]$datada[3] $datada[8]$datada[9]:$datada[10]$datada[11]:$datada[12]$datada[13]</I></TD><TD><TD WIDTH=50% ALIGN=RIGHT>";
if($delete==0){
echo "<A HREF='apagar.php?datapost=$datada&data=$data'>Apagar</A>";
}else{
echo " ";
}
echo "</TD></TR></TABLE>$coment</FONT><HR>";
}else{
echo "<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH=100%><TR><TD WIDTH=50% ALIGN=LEFT><FONT FACE=VERDANA SIZE=$textsize><I><A NAME='$datada' HREF='http://$link' target='_blank'>$nome</A> @ $datada[6]$datada[7]/$datada[4]$datada[5]/$datada[0]$datada[1]$datada[2]$datada[3] $datada[8]$datada[9]:$datada[10]$datada[11]:$datada[12]$datada[13]</I></TD><TD><TD WIDTH=50% ALIGN=RIGHT>";
if($delete==0){
echo "<A HREF='apagar.php?datapost=$datada&data=$data'>Apagar</A>";
}
echo "</TD></TR></TABLE>$coment</FONT><HR>";
}
}
}
?>
<BR>
<FORM ACTION='enviado.php' METHOD=POST><FONT FACE=VERDANA <? echo "SIZE=$textsize COLOR='#$textcol'"; ?>>
<INPUT TYPE='HIDDEN' NAME='dataguest' VALUE=<? echo $data; ?>>
<INPUT TYPE='HIDDEN' NAME='acao' VALUE='comentar'>
<INPUT TYPE='HIDDEN' NAME='guestmail' VALUE='<? echo $guestmail; ?>'>
<INPUT TYPE='HIDDEN' NAME='email' VALUE='<? echo $email; ?>'>
Nome:<BR>
<INPUT TYPE='TEXT' NAME='nomeguest' SIZE='58'><BR>
http:// <INPUT TYPE='TEXT' NAME='linkguest' value='' SIZE='51'><BR>
Comentário:<BR>
<TEXTAREA NAME="comentguest" ROWS="4" COLS="50"></TEXTAREA><BR>
<INPUT TYPE="submit" VALUE='COMENTAR'>
</FONT>
</FORM>
</TD>
</TR>
</TABLE>
<TD VALIGN=TOP ALIGN=CENTER WIDTH=20%> <BR>
<FONT FACE=VERDANA SIZE=3 COLOR=<? echo "#$textcol"; ?>>
<B><A HREF="links.php">Links</A></B><BR><BR>
</FONT>
<?
$linklog=$objeto2->query("select * from linklog LIMIT 6");
while($querylink=mysql_fetch_array($linklog)){
$alias=$querylink["alias"];
$endereco=$querylink["endereco"];
echo "<A HREF='http://$endereco' ALT='$alias' target='_blank'>$alias</A><BR><BR>";
}
?>
</TD>
</TR>
</TABLE>
<BR>
<FONT FACE=VERDANA SIZE=2 COLOR=<? echo $textcol; ?>>
LUIZ GUSTAVO
PORTALCATALAO.COM.BR
</CENTER>
</BODY>
</HTML>
<? }else{
if($navcol==1){
$navb script:history.back()>Voltar</a><br>";
}
else
{
echo "Query executado com sucesso.<br>";
}
return $query2;
}
function query($sql)
{
$query2 = mysql_query($sql);
if (!$query2)
{
echo "Falha ao executar consulta <a href=java script:history.back()>Voltar</a><br>";
}
return $query2;
}
}
?>
Além desses arquivos .php existem outros, mais eu acho que não há a necessidade de utilizar ele, caso seja necessário, é so dizer.
Edição feita por: MisterFoot, 15/10/2004, 20:49.