aaa

Bom, no meu site, cada ticket que o usuário compra, é adicionado 1 registro no sql.

Explicando:

Se o usuário comprar 1 ticket, adicionar isso 1 vez:

$insert['player_id'] = $player->id;
$query = $db->autoexecute('lottery', $insert, 'INSERT');

Se o usuário comprar 50 tickets, adiciona isso 50 vezes:

$insert['player_id'] = $player->id;
$query = $db->autoexecute('lottery', $insert, 'INSERT');

Como posso fazer isso?

Cada ticket que o usuário compra é 1 registro a mais no banco de dados

Se ele for comprar 50 tikets, tem que inserir 50 registros.

Depois ele sorteia um registro e mostra o ganhador.

resolvido

Olá!

Preciso de um código que, se o usuário for arqueiro, não poderá comprar escudos.

$item = $query->fetchrow();
if ($item['type'] == `shield` and $player->voc == `archer`)
{
include("templates/private_header.php");
echo "<b>Vendedor:</b><br />\n";
echo "<i>Desculpe, mas arqueiros não podem usar escudos!</i><br /><br />\n";
echo "<a href=\"shop.php\">Retornar a loja</a>";
include("templates/private_footer.php");
break;
}

O erro está na parte em negrito, mas eu não sei qual é =/

Olá, no meu site os usuários pode escolher um avatar... até ai tudo bem.
No meu site o avatar aparece assim: http://img352.images...67/antesvd5.jpg
Mas eu queria que ele aparece-se assim, com uma imagem no fundo: http://img352.images...4/depoislb9.jpg

Por favor me ajude, preciso muitíssimo disso!

Olá, preciso muito desse script de forum, mas está dando o seguinte erro:

Fatal error: Call to a member function execute() on a non-object in /home/a5787961/public_html/forum.php on line 19


A linha 19 está em negrito:::::

<?php
include("lib.php");
define("PAGENAME", "Forum");
$player = check_user($secret_key, $db);
include("templates/private_header.php");

if (isset($_GET["do"])) {
$do = explode(":",$_GET["do"]);

if ($do[0] == "thread") { showthread($do[1], $do[2]); }
elseif ($do[0] == "new") { newthread(); }
elseif ($do[0] == "reply") { reply(); }
elseif ($do[0] == "list") { donothing($do[1]); }

} else { donothing(0); }

function donothing($start=0) {

$query = $db->execute("select * from `forum` where `parent`=`0` order by `newpostdate` desc limit 20");
$page = "<table width=\"100%\"><tr><td style=\"padding:1px; background-color:black;\"><table width=\"100%\" style=\"margins:0px;\" cellspacing=\"1\" cellpadding=\"3\"><tr><th colspan=\"3\" style=\"background-color:#dddddd;\"><center><a href=\"forum.php?do=new\">New Thread</a></center></th></tr><tr><th width=\"50%\" style=\"background-color:#dddddd;\">Thread</th><th width=\"10%\" style=\"background-color:#dddddd;\">Replies</th><th style=\"background-color:#dddddd;\">Last Post</th></tr>\n";
$count = 1;
if (mysql_num_rows($query) == 0) {
$page .= "<tr><td style=\"background-color:#ffffff;\" colspan=\"3\"><b>No threads in forum.</b></td></tr>\n";
} else {
while ($row = mysql_fetch_array($query)) {
if ($count == 1) {
$page .= "<tr><td style=\"background-color:#ffffff;\"><a href=\"forum.php?do=thread:".$row["id"].":0\">".$row["title"]."</a></td><td style=\"background-color:#ffffff;\">".$row["replies"]."</td><td style=\"background-color:#ffffff;\">".$row["newpostdate"]."</td></tr>\n";
$count = 2;
} else {
$page .= "<tr><td style=\"background-color:#eeeeee;\"><a href=\"forum.php?do=thread:".$row["id"].":0\">".$row["title"]."</a></td><td style=\"background-color:#eeeeee;\">".$row["replies"]."</td><td style=\"background-color:#eeeeee;\">".$row["newpostdate"]."</td></tr>\n";
$count = 1;
}
}
}
$page .= "</table></td></tr></table>";

display($page, "Forum");

}

function showthread($id, $start) {

$query = $db->execute("SELECT * FROM `forum` WHERE `id`='$id' OR parent='$id' ORDER BY id LIMIT $start,15");
$query2 = $db->execute("SELECT `title` FROM `forum` WHERE `id`='$id' LIMIT 1");
$row2 = mysql_fetch_array($query2);
$page = "<table width=\"100%\"><tr><td style=\"padding:1px; background-color:black;\"><table width=\"100%\" style=\"margins:0px;\" cellspacing=\"1\" cellpadding=\"3\"><tr><td colspan=\"2\" style=\"background-color:#dddddd;\"><b><a href=\"forum.php\">Forum</a> :: ".$row2["title"]."</b></td></tr>\n";
$count = 1;
while ($row = mysql_fetch_array($query)) {
if ($count == 1) {
$page .= "<tr><td width=\"25%\" style=\"background-color:#ffffff; vertical-align:top;\"><span class=\"small\"><b>".$row["author"]."</b><br /><br />".prettyforumdate($row["postdate"])."</td><td style=\"background-color:#ffffff; vertical-align:top;\">".nl2br($row["content"])."</td></tr>\n";
$count = 2;
} else {
$page .= "<tr><td width=\"25%\" style=\"background-color:#eeeeee; vertical-align:top;\"><span class=\"small\"><b>".$row["author"]."</b><br /><br />".prettyforumdate($row["postdate"])."</td><td style=\"background-color:#eeeeee; vertical-align:top;\">".nl2br($row["content"])."</td></tr>\n";
$count = 1;
}
}
$page .= "</table></td></tr></table><br />";
$page .= "<table width=\"100%\"><tr><td><b>Reply To This Thread:</b><br /><form action=\"forum.php?do=reply\" method=\"post\"><input type=\"hidden\" name=\"parent\" value=\"$id\" /><input type=\"hidden\" name=\"title\" value=\"Re: ".$row2["title"]."\" /><textarea name=\"content\" rows=\"7\" cols=\"40\"></textarea><br /><input type=\"submit\" name=\"submit\" value=\"Submit\" /> <input type=\"reset\" name=\"reset\" value=\"Reset\" /></form></td></tr></table>";

display($page, "Forum");

}

function reply() {

global $userrow;
extract($_POST);
$query = doquery("INSERT INTO 'forum' SET id='',postdate=NOW(),newpostdate=NOW(),author='".$userrow["charname"]."',parent='$parent',replies='0',title='$title',content='$content'", "forum");
$query2 = doquery("UPDATE 'forum' SET newpostdate=NOW(),replies=replies+1 WHERE id='$parent' LIMIT 1", "forum");
header("Location: forum.php?do=thread:$parent:0");
die();

}

function newthread() {

global $userrow;

if (isset($_POST["submit"])) {
extract($_POST);
$query = doquery("INSERT INTO 'forum' SET id='',postdate=NOW(),newpostdate=NOW(),author='".$userrow["charname"]."',parent='0',replies='0',title='$title',content='$content'", "forum");
header("Location: forum.php");
die();
}

$page = "<table width=\"100%\"><tr><td><b>Make A New Post:</b><br /><br/ ><form action=\"forum.php?do=new\" method=\"post\">Title:<br /><input type=\"text\" name=\"title\" size=\"50\" maxlength=\"50\" /><br /><br />Message:<br /><textarea name=\"content\" rows=\"7\" cols=\"40\"></textarea><br /><br /><input type=\"submit\" name=\"submit\" value=\"Submit\" /> <input type=\"reset\" name=\"reset\" value=\"Reset\" /></form></td></tr></table>";
display($page, "Forum");

}

?>