Você fez algo errado, porque testei e te mandei tudo certinho....
está usando a ultima pagina modificada que te enviei?
Olhe na sua database na tabela "videos" se tem algum registro lá

usei aquela que você me mandou, 

n achei nenhum vídeo não

você segiu o tutorial certinho?
porque o erro está ai, não está "inserindo" nada na database

sim, vou refazer passo a passo de novo e ja ti falo

esse arquivo é pra mim criar um arquivo.php com qual nome ? 

\/

?PHP

$main_content .= '

 

 

Videos

 

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

width="525">

 

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.
';
?>
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 .= '









Selecione uma categoria.

Ultimos 5 | WAR | QUEST | HUNT | OTHERS
Click aqui para enviar seu video, somente videos do youtube por gentileza.

';
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 .= '













Postado por: '.$charnick.' ('.$server.') };
}
if($cat == ''){
$main_content .= '

Ultimos videos postados



';

$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 .= '










[Categoria : '.$categoria.'] - Postado por: '.$charnick.' ('.$server.') };

};

}
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 .= '




















  Submit YouTube Videos Char: ';
$main_content .= '
';$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 .= ''.$player->getName().'';}}else{$main_content .= 'You don\'t have any character on your account.';}$main_content .= '';

$main_content .= ' Link YouTube:
Video Name:
Categoria::
WARQuestHuntOthers Server: Avenger Global


';
}
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!

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.

Obrigado!

';

$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 .= '<< Voltar ';


$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 .= '
















Posted on: '.$charnick.' ('.$server.') Comment: '.$comentario.' ";
} else {
$owner = "0";
$delmsg = "";
}

$main_content .= '



















- Posted by: };


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 .= '




Make comment:











 

Comment with the character: ';

$main_content .= '
';$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 .= ''.$player->getName().'';}}else{$main_content .= 'You don\'t have any character on your account.';}$main_content .= '';

$main_content .= ' Comment:

';
$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.
Create an account if you do not have one yet.

Account Login

Account Number: Password:

 

 

';
}

}
$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 " Video deleted successfully! ";

$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");
}
}
}
?>

 

 

Edit:

Bom refiz passo a passo, só que agora quando aperto em Submit olha o error que aparece

 

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

Editado Outubro 19, 2013 11 anos por Gustavo Marques (veja o histórico de edições)