Videos do Youtube no Site do OTserver usando gesior 0.3.8

Postado Outubro 17, 2013 11 anos

Tentei por um submenu no meu site contendo Vídeos do pessoal, porém quando coloco pra carregar o vídeo ele aparece essa mensagem :There was an error in recording data, please click back and check the required fields! Alguém poderia me ajudar ?

Citar

Mention

Respostas 28
Visualizações 3.1k
Created 11 anos11 anos
Última resposta 11 anos11 anos

Popular Days

Postado Outubro 17, 2013 11 anos

Use tags em html para colocar os videos, assim não dará nenhum erro.

Ou se você fez/achou a pagina pronta, poste-a para que eu possa analisar se contem algum erro.

Te ajudei?
Se você achar que eu mereço, me dê uma "rep+" e selecione meu post como "melhor resposta"

Skype: JoadsonAion

Citar

Mention

Postado Outubro 17, 2013 11 anos

Autor

vou postar o que está no arquivo que eu coloquei na pasta do Xampp em htdocs

<?PHP

$main_content .= '<h4 style="" id="pt">

<br>

<center><h2><b> Videos</b></h2></center><br><br>

<center><object height="350" width="425"><img

src="http://icons.iconarchive.com/icons/thiago-silva/palm/256/Videos-icon.png" height="700"

width="525"></object></center><br>

<b></b><center><b>Nessa secao voce pode postar o video de uma war bem legal, ou uma quest ou voce com seu time cacando, os melhores videos serao divulgados aqui!

Fique de olho no canal sempre tem videos de eventos e de voces.

<?php

if($logged)

{

$account_login = $account_logged->getName();

$account_players = $account_logged->getPlayers();

foreach($account_players as $player)

{

$player = $player->getName();

$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));

}

include('videossql.php');

$videoid = $_GET["videoid"];

$cat = $_GET["cat"];

$main_content .= '

<font size="4px"><strong>Selecione uma categoria.</strong></font><br />

<strong><a href="index.php?subtopic=videos">Ultimos 5</a></strong> | <strong><a href="index.php?subtopic=videos&cat=WAR">WAR</a></strong> | <strong><a href="index.php?subtopic=videos&cat=QUEST">QUEST</a></strong> | <strong><a href="index.php?subtopic=videos&cat=HUNT">HUNT</a></strong> | <strong><a href="index.php?subtopic=videos&cat=others">OTHERS</a></strong>

</TD>

</TR>

Click aqui para enviar seu video, somente videos do youtube por gentileza.

</a></em></TD>

</TR>

</TABLE>

<br />';

if($action == ''){

if($cat != ''){

include('videossql.php');

$sql = "SELECT * FROM videos WHERE categoria='$cat' AND aprovado='1' ORDER BY data DESC";

$limite = mysql_query("$sql");

while ($sql = mysql_fetch_array($limite)) {

$videoid = $sql["id"];

$charnick = $sql["charnick"];

$comentario = $sql["comentario"];

$categoria = $sql["categoria"];

$link = $sql["link"];

$data = $sql["data"];

$data2 = date('d/m/Y - H:i', $data);

$server = $sql["server"];

$link = str_replace('http://www.youtube.com/watch?v=' '', $link);

$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '

<TD CLASS=white COLSPAN=3><B>Postado por: '.$charnick.' ('.$server.')</B></TD>

</TR>

<TD bgcolor="#F1E0C6"><a href="?subtopic=videos&action=view&videoid='.$videoid.'">Nome do video: '.$comentario.'</a></TD>

</TR>

<TD align="right" bgcolor="#D4C0A1">Postado dia: '.$data2.'</TD>

</TR>

</TR>

</TABLE>';

};

}

if($cat == ''){

$main_content .= '

<font size="4px"><strong>Ultimos videos postados</strong></font>

<br />

$sql = "SELECT * FROM videos WHERE aprovado='1' ORDER BY data DESC LIMIT 5";

$limite = mysql_query("$sql");

{

$videoid = $sql["id"];

$charnick = $sql["charnick"];

$comentario = $sql["comentario"];

$categoria = $sql["categoria"];

$link = $sql["link"];

$data = $sql["data"];

$server = $sql["server"];

$link = str_replace('http://www.youtube.com/watch?v=' '', $link);

$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>

<TD CLASS=white COLSPAN=3><B> [Categoria : '.$categoria.'] - Postado por: '.$charnick.' ('.$server.')</B></TD>

</TR>

<TD bgcolor="#F1E0C6"><a href="?subtopic=videos&action=view&videoid='.$videoid.'">Nome do video: '.$comentario.'</a></TD>

</TR>

<TD align="right" bgcolor="#D4C0A1">Postado dia: '.$data2.' - <i>'.$categoria.'</i>

</TD>

</TR>

</TABLE>';

};

}

if($action == 'add'){

if($logged)

{

$account_login = $account_logged->getName();

$account_players = $account_logged->getPlayers();

foreach($account_players as $player)

{

$player = $player->getName();

$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));

}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>

<TD CLASS=white COLSPAN=3><B>Submit YouTube Videos</B></TD>

</TR>

<TD bgcolor="#F1E0C6">Char: ';

$main_content .= '

<select name="charnick" id="charnick">';

$players_from_logged_acc = $account_logged->getPlayersList();

if(count($players_from_logged_acc) > 0)

{

$players_from_logged_acc->orderBy('name');

foreach($players_from_logged_acc as $player)

{

$main_content .= '

<option>'.$player->getName().'</option>';

}

else

{

$main_content .= 'You don\'t have any character on your account.';

}

$main_content .= '

</select>';

$main_content .= '</TD>

</TR>

<TD bgcolor="#D4C0A1">Link YouTube:

</TR>

<TD bgcolor="#F1E0C6">Video Name:

</TR>

<TD bgcolor="#D4C0A1">Categoria::

<option>Quest</option>

<option>Others</option>

</select></TD>

</TR>

<TD bgcolor="#F1E0C6">Server: <select name="server" id="server">

<option>Avenger Global</option>

</select></TD>

</TR>

</TABLE><BR>

</form>';

}

else

{

$main_content .= 'To add videos, you need to log into your account.';

}

if($action == 'add1'){

$charnick = $_POST["charnick"];

$link = $_POST["link"];

$comentario = $_POST["comentario"];

$server = $_POST["server"];

$categoria = $_POST["categoria"];

$aprovado = "1";

$data = time();

include('videossql.php');

$sql = "INSERT INTO videos (id, charnick, link, comentario, categoria, server, aprovado, data) VALUES ('', '$charnick', '$link', '$comentario', '$categoria', '$server', '$aprovado', '$data')";

$main_content .= '

Video Enviado!<strong><a href="index.php?subtopic=videos&cat=OUTROS"></a></strong>

</center></TD>

</TR>

<TD COLSPAN=3 bgcolor="#D4C0A1" CLASS=black><p>Your video was sent as soon as approved by our GM, will be posted automatically if something goes wrong with the video, we will contact In-Game.</p>

<p>Obrigado!</p></TD>

</TR>

</TABLE>';

$sql = mysql_query($sql)

or die ("There was an error in recording data, please click back and check the required fields!");

};

if($action == 'view'){

$videoid = $_GET["videoid"];

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>

</center></TD>

</TR>

</TABLE>';

$sql = "SELECT * FROM videos WHERE id='$videoid' AND aprovado='1' LIMIT 1";

$limite = mysql_query("$sql");

while ($sql = mysql_fetch_array($limite)) {

$charnick = $sql["charnick"];

$comentario = $sql["comentario"];

$categoria = $sql["categoria"];

$link = $sql["link"];

$data = $sql["data"];

$server = $sql["server"];

$link = str_replace('http://www.youtube.com/watch?v=' '', $link);

$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>

<TD CLASS=white COLSPAN=3><B>Posted on: '.$charnick.' ('.$server.')</B></TD>

</TR>

<TD bgcolor="#F1E0C6">Comment: '.$comentario.'</TD>

</TR>

</TR>

<TD bgcolor="#F1E0C6">Posted on: '.$data2.' - <i>'.$cat.'</i></TD>

</TR>

</TR>

</TABLE>';

};

$sql = "SELECT * FROM comentarios WHERE videoid='$videoid' ORDER BY data ASC";

$limite = mysql_query("$sql");

while ($sql = mysql_fetch_array($limite)) {

$id = $sql["id"];

$videoid = $sql["videoid"];

$charnick = $sql["charnick"];

$servidor = $sql["servidor"];

$comentariox2 = $sql["comentario"];

$account_comment = $sql["account"];

$data = $sql["data"];

$data2 = date('d/m/Y - H:i:s', $data);

if ($account_login == $account_comment){

$owner = "1";

$delmsg = "<a href='?subtopic=videos&action=delcomment&videoid=$videoid&idcoment=$id'><img src=layouts/tibiacom/images/news/delete.png />";

} else {

$owner = "0";

$delmsg = "";

}

$main_content .= '

</tr>

<td bgcolor="#F1E0C6">Posted by: <a href="index.php?subtopic=characters&name='.$charnick.'"> <i>'.$charnick.'</i></a> | Server: <i>'.$servidor.'</i></td>

</tr>

<tr>

<td bgcolor="#D4C0A1">Comment:</td>

</tr>

<tr>

<td bgcolor="#F1E0C6"><b>'.$comentariox2.'</b></td>

</tr>

<tr>

<td bgcolor="#D4C0A1">Data: '.$data2.' - '.$delmsg.'</td>

</tr>

<tr>

</tr>

</table>';

};

if($logged)

{

$account_login = $account_logged->getName();

$account_players = $account_logged->getPlayers();

foreach($account_players as $player)

{

$player = $player->getName();

$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));

}

$main_content .= '

<TD CLASS=white><b>Make comment:</b></TD>

</TR>

</table>

Comment with the character: ';

$main_content .= '

<select name="charnick" id="charnick">';

$players_from_logged_acc = $account_logged->getPlayersList();

if(count($players_from_logged_acc) > 0)

{

$players_from_logged_acc->orderBy('name');

foreach($players_from_logged_acc as $player)

{

$main_content .= '

<option>'.$player->getName().'</option>';

}

else

{

$main_content .= 'You don\'t have any character on your account.';

}

$main_content .= '

</select>';

$main_content .= '

</td>

</tr>

<tr>

<td align="center" valign="top" bgcolor="#D4C0A1">Comment:

</tr>

<tr>

</form></td>

</tr>

</table>';

$coment = $_GET["coment"];

if ($coment == "add"){

echo $_POST['comentariox1'];

$charnick2 = "$player";

$servidor2 = "Heoria";

$comentariox1 = $_POST['comentariox1'];

$data2 = time();

$videoid2 = $_GET["videoid"];

include('videossql.php');

$comentariox1=strtr($comentariox1, '\'', '*');

if ($comentariox1 != ""){

$sql = "INSERT INTO comentarios (id, videoid, charnick, servidor, comentario, data, account) VALUES ('', '$videoid', '$charnick2', '$servidor2', '$comentariox1', '$data2', '$account_login')";

} else {

$msgerro = "Empty Comments!";

$erro = "?subtopic=videos&action=view&videoid=$videoid&msg=$msgerro";

header("Location: $erro");

}

if(!mysql_query($sql)){

$erro = mysql_error();

echo "Ocorreu o seguinte erro: ", '"', $erro, '"';

} else {

$sucesso = "Comment Sucessfull!";

$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=$sucesso";

header("Location: $sucesso");

}

else

{

$main_content .= 'Please enter your account number and your password.<br/><a href="?subtopic=createaccount" >Create an account</a> if you do not have one yet.<br/><br/><form action="?subtopic=videos&action=view&videoid='.$videoid.'" method="post" ><div class="TableContainer" > <table class="Table1" cellpadding="0" cellspacing="0" > <div class="CaptionContainer" > <div class="CaptionInnerContainer" > <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span> <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span> <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);" ></span> <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></span> <div class="Text" >Account Login</div> <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></span> <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);" ></span> <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span> <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span> </div> </div> <tr> <td> <div class="InnerTableContainer" > <table style="width:100%;" ><tr><td class="LabelV" ><span >Account Number:</span></td><td style="width:100%;" ><input type="password" name="account_login" SIZE="10" maxlength="10" ></td></tr><tr><td class="LabelV" ><span >Password:</span></td><td><input type="password" name="password_login" size="30" maxlength="29" ></td></tr> </table> </div> </table></div></td></tr><br/><table width="100%" ><tr align="center" ><td><table border="0" cellspacing="0" cellpadding="0" ><tr><td style="border:0px;" ><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></td><tr></form></table></td><td><table border="0" cellspacing="0" cellpadding="0" ><form action="?subtopic=lostaccount" method="post" ><tr><td style="border:0px;" ><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Account lost?" alt="Account lost?" src="'.$layout_name.'/images/buttons/_sbutton_accountlost.gif" ></div></div></td></tr></form></table></td></tr></table>';

}

$idcoment = $_GET["idcoment"];

$idcoment=strtr($idcoment, '\'', '*');

if (($action == "delcomment") && ($idcoment != "")){

$sql = "SELECT * FROM comentarios WHERE id=$idcoment LIMIT 1";

$limite = mysql_query("$sql");

while ($sql = mysql_fetch_array($limite)) {

$accountvideo = $sql["account"];

if ($account_login == $accountvideo){

$vidx = "DELETE FROM comentarios WHERE id='$idcoment'";

$resultado = mysql_query($vidx)

or die ("Unable to perform the deletion of data.");

echo "<h1>Video deleted successfully!</h1>";

$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=Deleted";

header("Location: $sucesso");

} else {

$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=ERRO";

header("Location: $sucesso");

}

Citar

Mention

Postado Outubro 17, 2013 11 anos

Aqui a nova pagina, teste e me diga se funcionou.
a pagina continha alguns erros de "programação"

aqui use esta aqui

<?PHP

$main_content .= '<h4 style="" id="pt">
<br>
<center><h2><b> Videos</b></h2></center><br><br>

<center><object height="350" width="425"><img

src="http://icons.iconarc...Videos-icon.png" height="700"

width="525"></object></center><br>

<br><br> </h4>

<b></b><center><b>Nessa secao voce pode postar o video de uma war bem legal, ou uma quest ou voce com seu time cacando, os melhores videos serao divulgados aqui!
Fique de olho no canal sempre tem videos de eventos e de voces.
';
?>
<?php
if($logged)
{
    $account_login = $account_logged->getName();
    $account_players = $account_logged->getPlayers();
    foreach($account_players as $player)
    {
        $player = $player->getName();
$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));
                    }
}

include('videossql.php');

$videoid = $_GET["videoid"];
$cat = $_GET["cat"];

$main_content .= '

<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#F1E0C6">
<TD COLSPAN=3 CLASS=red>
<font size="4px"><strong>Selecione uma categoria.</strong></font><br />
<strong><a href="index.php?subtopic=videos">Ultimos 5</a></strong> | <strong><a href="index.php?subtopic=videos&cat=WAR">WAR</a></strong> | <strong><a href="index.php?subtopic=videos&cat=QUEST">QUEST</a></strong> | <strong><a href="index.php?subtopic=videos&cat=HUNT">HUNT</a></strong> | <strong><a href="index.php?subtopic=videos&cat=others">OTHERS</a></strong>
</TD>
</TR>
<TR BGCOLOR="#505050">
<TD COLSPAN=3 bgcolor="#D4C0A1" CLASS=white style="font-size:11px"><em><a href="index.php?subtopic=videos&action=add">
Click aqui para enviar seu video, somente videos do youtube por gentileza.
</a></em></TD>
</TR>
</TABLE>
<br />';
if($action == ''){
if($cat != ''){
include('videossql.php');
$sql = "SELECT * FROM videos WHERE categoria='$cat' AND aprovado='1' ORDER BY data DESC";
$limite = mysql_query("$sql");
while ($sql = mysql_fetch_array($limite)) {

$videoid = $sql["id"];
$charnick = $sql["charnick"];
$comentario = $sql["comentario"];
$categoria = $sql["categoria"];
$link = $sql["link"];
$data = $sql["data"];
$data2 = date('d/m/Y - H:i', $data);
$server = $sql["server"];
$link = str_replace('http://www.youtube.com/watch?v=' $link);
$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#505050">
<TD CLASS=white COLSPAN=3><B>Postado por: '.$charnick.' ('.$server.')</B></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6"><a href="?subtopic=videos&action=view&videoid='.$videoid.'">Nome do video: '.$comentario.'</a></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD align="right" bgcolor="#D4C0A1">Postado dia: '.$data2.'</TD>
</TR>
                <TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6"><a href="?subtopic=videos&action=view&videoid='.$videoid.'"></a></TD>
</TR>
</TABLE>';
};
}
if($cat == ''){
$main_content .= '

<font size="4px"><strong>Ultimos videos postados</strong></font>
<br />

';

$sql = "SELECT * FROM videos WHERE aprovado='1' ORDER BY data DESC LIMIT 5";
$limite = mysql_query("$sql");
{

$videoid = $sql["id"];
$charnick = $sql["charnick"];
$comentario = $sql["comentario"];
$categoria = $sql["categoria"];
$link = $sql["link"];
$data = $sql["data"];
$server = $sql["server"];
$link = str_replace('http://www.youtube.com/watch?v=' $link);
$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#505050">
<TD CLASS=white COLSPAN=3><B> [Categoria : '.$categoria.'] - Postado por: '.$charnick.' ('.$server.')</B></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6"><a href="?subtopic=videos&action=view&videoid='.$videoid.'">Nome do video: '.$comentario.'</a></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD align="right" bgcolor="#D4C0A1">Postado dia: '.$data2.' - <i>'.$categoria.'</i>
</TD>
</TR>

</TABLE>';
};

};

}
if($action == 'add'){
if($logged)
{
    $account_login = $account_logged->getName();
    $account_players = $account_logged->getPlayers();
    foreach($account_players as $player)
    {
        $player = $player->getName();
$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));
   }

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<form action="/index.php?subtopic=videos&action=add1" method="POST"><input type="hidden" name="videos" value="">
<TR BGCOLOR="#505050">
<TD CLASS=white COLSPAN=3><B>Submit YouTube Videos</B></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6">Char: ';
                 $main_content .= '
<select name="charnick" id="charnick">';

$players_from_logged_acc = $account_logged->getPlayersList();
            if(count($players_from_logged_acc) > 0)
            {
              $players_from_logged_acc->orderBy('name');
              foreach($players_from_logged_acc as $player)
              {
                $main_content .= '
<option>'.$player->getName().'</option>';

              }
            }
            else
            {
              $main_content .= 'You don\'t have any character on your account.';
             }

               $main_content .= '
</select>';

$main_content .= '</TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#D4C0A1">Link YouTube:
   <input name="link" type="text" id="link" size="40" /></TD>
</TR>
                <TR BGCOLOR=#F1E0C6>
<TD bgcolor="#F1E0C6">Video Name:
<input name="comentario" type="text" id="comentario" size="50" /></TD>
</TR>
                <TR BGCOLOR=#D4C0A1>
<TD bgcolor="#D4C0A1">Categoria::
<select name="categoria" id="categoria">
   <option>WAR</option>
   <option>Quest</option>
   <option>Hunt</option>
   <option>Others</option>
     </select></TD>
</TR>
                <TR BGCOLOR=#F1E0C6>
<TD bgcolor="#F1E0C6">Server: <select name="server" id="server">
   <option>Avenger Global</option>
     </select></TD>
</TR>

</TABLE><BR>
<center><input type="image" value="submit" src="layouts/tibiacom/images/buttons/sbutton_submit.gif"/>
</form>';
}
else
{
        $main_content .= 'To add videos, you need to log into your account.';
}

}
if($action == 'add1'){
$charnick = $_POST["charnick"];
$link = $_POST["link"];
$comentario = $_POST["comentario"];
$server = $_POST["server"];
$categoria = $_POST["categoria"];
$aprovado = "1";
$data = time();

include('videossql.php');
$sql = "INSERT INTO videos (id, charnick, link, comentario, categoria, server, aprovado, data) VALUES ('', '$charnick', '$link', '$comentario', '$categoria', '$server', '$aprovado', '$data')";
$main_content .= '
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#505050">
<TD COLSPAN=3 CLASS=white><center>
Video Enviado!<strong><a href="index.php?subtopic=videos&cat=OUTROS"></a></strong>
</center></TD>
</TR>
<TR BGCOLOR="#505050">
<TD COLSPAN=3 bgcolor="#D4C0A1" CLASS=black><p>Your video was sent as soon as approved by our GM, will be posted automatically if something goes wrong with the video, we will contact In-Game.</p>
     <p>Obrigado!</p></TD>
</TR>
</TABLE>';

$sql = mysql_query($sql)
or die ("There was an error in recording data, please click back and check the required fields!");
};

if($action == 'view'){
$videoid = $_GET["videoid"];

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#F1E0C6">
<TD COLSPAN=3 CLASS=red><center>
<strong><a href="javascript:history.back(1)"><< Voltar</a></strong>
</center></TD>
</TR>
</TABLE>';

$sql = "SELECT * FROM videos WHERE id='$videoid' AND aprovado='1' LIMIT 1";
$limite = mysql_query("$sql");
while ($sql = mysql_fetch_array($limite)) {

$charnick = $sql["charnick"];
$comentario = $sql["comentario"];
$categoria = $sql["categoria"];
$link = $sql["link"];
$data = $sql["data"];
$server = $sql["server"];
$link = str_replace('http://www.youtube.com/watch?v=' $link);
$link = str_replace('&feature=player_embedded', '', $link);

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="#505050">
<TD CLASS=white COLSPAN=3><B>Posted on: '.$charnick.' ('.$server.')</B></TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6">Comment: '.$comentario.'</TD>
</TR>
<TR BGCOLOR=#D4C0A1>
<TD bgcolor="#D4C0A1"><center><object width="480" height="385"><param name="movie" value="http://www.youtube.com/watch?v='.$link.'?fs=1&hl=pt_BR&rel=0&color1=0x3a3a3a&color2=0x999999"></param><param name="allowFullScreen" value="true"></param><param name="allowscriptaccess" value="always"></param><embed src="http://www.youtube.com/watch?v='.$link.'?fs=1&hl=pt_BR&rel=0&color1=0x3a3a3a&color2=0x999999" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="480" height="385"></embed></object></center></TD>
</TR>
                <TR BGCOLOR=#D4C0A1>
<TD bgcolor="#F1E0C6">Posted on: '.$data2.' - <i>'.$cat.'</i></TD>
</TR>
                <TR BGCOLOR=#D4C0A1>
<TD> </TD>
</TR>

</TABLE>';
};

$sql = "SELECT * FROM comentarios WHERE videoid='$videoid' ORDER BY data ASC";
$limite = mysql_query("$sql");
while ($sql = mysql_fetch_array($limite)) {

$id = $sql["id"];
$videoid = $sql["videoid"];
$charnick = $sql["charnick"];
$servidor = $sql["servidor"];
$comentariox2 = $sql["comentario"];
$account_comment = $sql["account"];

$data = $sql["data"];
$data2 = date('d/m/Y - H:i:s', $data);

if ($account_login == $account_comment){
$owner = "1";
$delmsg = "<a href='?subtopic=videos&action=delcomment&videoid=$videoid&idcoment=$id'><img src=layouts/tibiacom/images/news/delete.png />";
} else {
$owner = "0";
$delmsg = "";
}

$main_content .= '
<table width="100%" border="0" cellpadding="0" cellspacing="0">
                                <tr BGCOLOR="#505050">
                                        <TD CLASS=white><b>-</b></TD>
                                </tr>
<tr bgcolor="#D4C0A1">
    <td bgcolor="#F1E0C6">Posted by: <a href="index.php?subtopic=characters&name='.$charnick.'"> <i>'.$charnick.'</i></a> | Server: <i>'.$servidor.'</i></td>
</tr>
<tr>
    <td bgcolor="#D4C0A1">Comment:</td>
</tr>
<tr>
    <td bgcolor="#F1E0C6"><b>'.$comentariox2.'</b></td>
</tr>
<tr>
    <td bgcolor="#D4C0A1">Data: '.$data2.' - '.$delmsg.'</td>
</tr>
<tr>
    <td bgcolor="#F1E0C6"></td>
</tr>
</table>';
};

if($logged)
{

    $account_login = $account_logged->getName();
    $account_players = $account_logged->getPlayers();
    foreach($account_players as $player)
    {
        $player = $player->getName();
$player2 = str_replace(strtoupper("'"),"+",strtoupper($player));
   }

$main_content .= '
   <table width="100%" border="0" cellspacing="0" cellpadding="0">
<TR BGCOLOR="#505050">
<TD CLASS=white><b>Make comment:</b></TD>
</TR>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form id="fazercomentario" name="fazercomentario" method="post" action="?subtopic=videos&action=view&videoid='.$videoid.'&coment=add">
<tr bgcolor="#D4C0A1">
    <td bgcolor="#F1E0C6">

Comment with the character: ';

                                                  $main_content .= '
                                                                          <select name="charnick" id="charnick">';

$players_from_logged_acc = $account_logged->getPlayersList();
            if(count($players_from_logged_acc) > 0)
            {
              $players_from_logged_acc->orderBy('name');
              foreach($players_from_logged_acc as $player)
              {
                $main_content .= '
                                <option>'.$player->getName().'</option>';

              }
            }
            else
            {
              $main_content .= 'You don\'t have any character on your account.';
                                      }

                                                $main_content .= '
                                </select>';

$main_content .= '
</td>
</tr>
<tr>
    <td align="center" valign="top" bgcolor="#D4C0A1">Comment:
      <label for="comentariox1"></label>
    <textarea name="comentariox1" id="comentariosx1" cols="60" rows="5"></textarea></td>
</tr>
<tr>
    <td align="center" bgcolor="#F1E0C6"><input type="submit" name="button" id="button" value="Enviar" />
    </form></td>
</tr>
</table>';
$coment = $_GET["coment"];
if ($coment == "add"){
echo $_POST['comentariox1'];
$charnick2 = "$player";
$servidor2 = "Heoria";
$comentariox1 = $_POST['comentariox1'];
$data2 = time();
$videoid2 = $_GET["videoid"];
include('videossql.php');
$comentariox1=strtr($comentariox1, '\'', '*');
if ($comentariox1 != ""){
$sql = "INSERT INTO comentarios (id, videoid, charnick, servidor, comentario, data, account) VALUES ('', '$videoid', '$charnick2', '$servidor2', '$comentariox1', '$data2', '$account_login')";
} else {
$msgerro = "Empty Comments!";
$erro = "?subtopic=videos&action=view&videoid=$videoid&msg=$msgerro";
header("Location: $erro");
}
if(!mysql_query($sql)){
    $erro = mysql_error();
    echo "Ocorreu o seguinte erro: ", '"', $erro, '"';
} else {
$sucesso = "Comment Sucessfull!";
$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=$sucesso";
header("Location: $sucesso");
}

}
}
else
{
        $main_content .= 'Please enter your account number and your password.<br/><a href="?subtopic=createaccount" >Create an account</a> if you do not have one yet.<br/><br/><form action="?subtopic=videos&action=view&videoid='.$videoid.'" method="post" ><div class="TableContainer" > <table class="Table1" cellpadding="0" cellspacing="0" >    <div class="CaptionContainer" >      <div class="CaptionInnerContainer" >        <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span>        <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span>        <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);" ></span>        <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></span>        <div class="Text" >Account Login</div>        <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></span>        <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);" ></span>        <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span>        <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></span>      </div>    </div>    <tr>      <td>        <div class="InnerTableContainer" >          <table style="width:100%;" ><tr><td class="LabelV" ><span >Account Number:</span></td><td style="width:100%;" ><input type="password" name="account_login" SIZE="10" maxlength="10" ></td></tr><tr><td class="LabelV" ><span >Password:</span></td><td><input type="password" name="password_login" size="30" maxlength="29" ></td></tr>          </table>        </div> </table></div></td></tr><br/><table width="100%" ><tr align="center" ><td><table border="0" cellspacing="0" cellpadding="0" ><tr><td style="border:0px;" ><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif" ></div></div></td><tr></form></table></td><td><table border="0" cellspacing="0" cellpadding="0" ><form action="?subtopic=lostaccount" method="post" ><tr><td style="border:0px;" ><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)" ><div onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" ><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);" ></div><input class="ButtonText" type="image" name="Account lost?" alt="Account lost?" src="'.$layout_name.'/images/buttons/_sbutton_accountlost.gif" ></div></div></td></tr></form></table></td></tr></table>';
}

}
$idcoment = $_GET["idcoment"];
$idcoment=strtr($idcoment, '\'', '*');
if (($action == "delcomment") && ($idcoment != "")){
$sql = "SELECT * FROM comentarios WHERE id=$idcoment LIMIT 1";
$limite = mysql_query("$sql");
while ($sql = mysql_fetch_array($limite)) {
$accountvideo = $sql["account"];

if ($account_login == $accountvideo){
$vidx = "DELETE FROM comentarios WHERE id='$idcoment'";
$resultado = mysql_query($vidx)
or die ("Unable to perform the deletion of data.");
echo "<h1>Video deleted successfully!</h1>";

$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=Deleted";
header("Location: $sucesso");
} else {
$sucesso = "?subtopic=videos&action=view&videoid=$videoid&msg=ERRO";
header("Location: $sucesso");
}
}
}
?>

Te ajudei?
Se você achar que eu mereço, me dê uma "rep+" e selecione meu post como "melhor resposta"

Skype: JoadsonAion

Citar

Mention

Postado Outubro 17, 2013 11 anos

Autor

agora deu outro erro, quando vou clicar no submenu ele aparece :

Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\videos.php on line 67

Citar

Mention

Participe da conversa

Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

https://tibiaking.com/topic/28630-videos-do-youtube-no-site-do-otserver-usando-gesior-038/

Seguidores

Ir para a lista de tópicos

Nenhum usuário registrado visualizando esta página.

Tópicos 96.9k
Posts 519.6k

Respostas 28
Visualizações 3.1k
Created 11 anos11 anos
Última resposta 11 anos11 anos

Entrar

Videos do Youtube no Site do OTserver usando gesior 0.3.8

Featured Replies

Top Posters In This Topic

Popular Days

Participe da conversa

Quem Está Navegando 0

Estatísticas dos Fóruns

Top Posters In This Topic

Popular Days

Informação Importante

Account

Navigation

Pesquisar