Forum/Форум для новичков[JAVA]/Donation System

Donation System

2 replies157 viewsCurrently viewing: 1

Евгений

User

Бывалый

Posts: 164

На форуме с: 10/06/2009

Репутация: +122

Рейтинг: 0

· 10/23/2009, 10:41 AM

Вещь добавляет,но в инвентаре она не появляется.
У меня не работает скрипт.

Раскрывающийся текст

<?php
$username = "phozik"; // username
$password = " "; // password

if ($_SERVER["PHP_AUTH_USER"] != $username || $_SERVER["PHP_AUTH_PW"] != $password) {
header("WWW-Authenticate: basic realm='Protected Area'");
header("HTTP/1.0 401 Unauthorized");
echo "This is a Password Protected Area, Only Administrators can Access it !"; //Invalid Login
exit;
}
?>
<?
session_start();

include("config.php");
$acao = addslashes(htmlentities($_GET['acao']));
$sacao = addslashes(htmlentities($_GET['sacao']));
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Donation System</title>
<style type="text/css">

</style>
</head>

<body>
<form id="form1" name="form1" method="get">
<div>
<div align="center"><img src="http://i40.tinypic.com/2bbehi.jpg" border="0" alt="Photobucket"></div>
</div>
<p>
<input type="hidden" name="acao" value="buscar" />
<?
if($_GET['t'] == "weapon") {
$w = " selected";
}elseif($_GET['t'] == "armor") {
$a = " selected";
}else{
$i = " selected";
}
?>
</p>
<table width="100%" border="0" class="style1">
<tr>
<td width="40%">Donating for:</td>
<td width="60%">
<select name="t" class="style1" id="t">
<option value="etcitem"<?php echo $i; ?>>Item</option>
<option value="weapon"<?php echo $w; ?>>Weapon</option>
<option value="armor"<?php echo $a; ?>>Armor</option>
</select>
</td>
</tr>
<tr>
<td>Item Name: </td>
<td><input name="item" type="text" class="style1" id="item" value="<?php echo $_GET['item']; ?>" size="30" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" class="style1" value="Check" /></td>
</tr>
</table>
</form>
<p>
<hr />
</p>
<?

//BUSCANDO ITEM

if($acao == "buscar") {

$tabela = addslashes(htmlentities($_GET['t']));
$item = addslashes(htmlentities($_GET['item']));

$sql = mysql_query("SELECT * FROM ".$tabela." WHERE name LIKE '%".$item."%' ORDER BY name") or die(mysql_error());
$contar = mysql_num_rows($sql);
$cor = 0;

if($contar < 1) {
?>
<table width="100%" border="0" class="style1">
<tr>
<td align="center">Nenhum ítem encontrado com o nome de: <strong><?php echo $item; ?></strong></td>
</tr>
</table>

<?
}else{
?>
<table width="100%" border="0">
<tr bgcolor="#666666" class="style2">
<td> </td>
<td width="7%" align="center"><strong>Item ID</strong></td>
<td width="53%" align="center"><strong>Item Name: </strong></td>
<td width="6%" align="center"><strong>Grade # :</strong></td>
<td width="15%" align="center"><strong>Type: </strong></td>
<td width="19%" align="center"><strong>Action:</strong></td>
</tr>
<?
while($c = mysql_fetch_array($sql)) {
$cor = $cor + 1;
if ($cor % 2 == 0) {
$bg = '#F7F7F7';
} else {
$bg = '#E7E7E7';
}

$c['name'] = str_replace("_", " ", $c['name']);

if(file_exists("items/5-".$c['item_id'].".gif")) {
$img = "<img src=\"items/5-".$c['item_id'].".gif\" alt=\"".$c['name']."\">";
}else{
$img = "<img src=\"items/sem_img.gif\" alt=\"Sem imagem para este нtem.\">";
}

?>

<tr class="style1" bgcolor="<?php echo $bg; ?>">
<td><?php echo $img; ?></td>
<td align="center"><?php echo $c['item_id']; ?></td>
<td><?php echo ucwords(strtolower($c['name'])); ?></td>
<td align="center"><?php echo ucwords($c['crystal_type']); ?></td>
<td><?php echo $c['bodypart']; ?></td>
<td><a href="?acao=doar&t=<?php echo $tabela; ?>&id=<?php echo $c['item_id']; ?>">ADD donated Item</a> </td>
</tr>
<?
}
}
?>
</table>
<?
}

if($acao == "doar") {

$t = addslashes(htmlentities($_GET['t']));
$id = intval($_GET['id']);

?>
<form method="get">
<input type="hidden" name="sacao" value="conta" />
<input type="hidden" name="acao" value="doar" />
<input type="hidden" name="t" value="<?php echo $t; ?>" />
<input type="hidden" name="id_item" value="<?php echo $id; ?>" />
<table width="100%" border="0" class="style1">
<tr>
<td width="32%" align="right">Login of the Player: </td>
<td width="68%"><input name="conta" type="text" class="style1" id="conta" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" class="style1" value="Do It!" /></td>
</tr>
</table>
</form>
<?
//lol where is the charID...? :P so the script has error.. and we find that lol
if($sacao == 'conta') {
$t = addslashes(htmlentities($_GET['t']));
$id_item = intval($_GET['id_item']);

$conta = addslashes(htmlentities($_GET['conta']));
$co = mysql_query("SELECT * FROM characters WHERE account_name = '".$conta."'") or die(mysql_error());
$contar = mysql_num_rows($co);

if($contar < 1) {
echo "No Chars found !";
}else{
?>
<table width="100%" border="0" class="style1">
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF" class="style1"><hr /></td>
</tr>
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF" class="style1">List of the chars: <strong><?php echo $conta; ?></strong></td>
</tr>
<tr bgcolor="#666666">
<td width="35%" class="style2"><span class="style5">Name of char:</span></td>
<td width="45%" class="style2"><span class="style5">Level of char:</span></td>
<td width="20%" class="style2"><strong>Action:</strong></td>
</tr>
<?
$cor = 0;
while($c = mysql_fetch_object($co)) {
$cor = $cor + 1;
$bg = $cor % 2 == 0 ? '#F7F7F7' : '#E7E7E7';

?>
<tr bgcolor="<?php echo $bg; ?>">
<td><?php echo $c->char_name; ?></td>
<td><?php echo $c->level; ?></td>
<td>
<a href="?acao=add&charId=<?php echo $c->obj_Id; ?>&t=<?php echo $t; ?>&id_item=<?php echo $id_item; ?>">
ADD Item
</a>
</td>
</tr>
<?
}
?>
</table>
<?
}
}
}

if($acao == 'add') {
$charId = intval($_GET['charId']);
$id_item = intval($_GET['id_item']);
$t = addslashes(htmlentities($_GET['t']));
?>
<form method="get">
<input type="hidden" name="sacao" value="addi" />
<input type="hidden" name="acao" value="add" />
<input type="hidden" name="charId" value="<?php echo $charId; ?>" />
<input type="hidden" name="id_item" value="<?php echo $id_item; ?>" />
<input type="hidden" name="t" value="<?php echo $t; ?>" />

<table width="100%" border="0" class="style1">
<tr>
<td width="36%">Enchant of the Item: </td>
<td width="64%"><input name="enchant" type="text" class="style1" id="enchant" /></td>
</tr>
<tr>
<td>Quantity:</td>
<td><input name="qtd" type="text" class="style1" id="qtd" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" class="style1" value="Do It!" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<?

if($sacao == 'addi') {
$charId = intval($_GET['charId']);
$id_item = intval($_GET['id_item']);
$t = addslashes(htmlentities($_GET['t']));
$enchant = intval($_GET['enchant']);
$qtd = intval($_GET['qtd']);
$caracteres = '0123456789';
$numch = 7;
$oid = '';
for($i=0;$i<$numch;$i++) {
$oid.=$caracteres[rand(0,strlen($caracteres)-1)];
}

for($i = 1; $i <= $qtd; $i++) {

$qt = $qtd > 1 ? '1' : $qtd;

mysql_query("INSERT INTO items (owner_id, object_id, item_id, count, enchant_level, loc)
VALUES
('".$charId."', '".$oid.$i."', '".$id_item."', '".$qt."', '".$enchant."', 'INVENTORY')") or die(mysql_error());
}

echo "Item Added!";

}
}
?>
</body>
</html>

Сразу говорю в таблице characters у меня колонка charId.
Вот скрин как добовляется в таблицу items:

[/URL]
И сразу видно что в столбик owner_id не добовляется charId.
Помогите сделать так чтоб в owner_id добавлялся charId.

iZen

User

Участник

Posts: 80

На форуме с: 01/23/2009

Репутация: +44

Рейтинг: 0

· 10/23/2009, 11:44 AM

А что у тебя сдесь выдаетса

Код

...
<a href="?acao=add&charId=<?php echo $c->obj_Id; ?>&t=<?php echo $t; ?>&id_item=<?php echo $id_item; ?>">
...

???
Пример покажи

А вообще перепиши под хранимку, надежнее будет)))

Раскрывающийся текст

Код

DELIMITER;;
CREATE FUNCTION `lf_Add_ItemToInv`(iCharName VARCHAR(255), iItemId INT(11), iItemCount BIGINT(20)) RETURNS tinyint(1)
BEGIN
    DECLARE xCharId, xObjID, xStartObjID, fFlag, xMaxObjID, xNewObjID, iNewObjID, oRes INTEGER;
    SET xCharId = 0;
    SET xObjID = 0;
    SET xStartObjID = 268500251;
    SET fFlag = 0;
    SET xMaxObjID = 999999999;
    SET xNewObjID = xStartObjID;
    SET iNewObjID = xStartObjID;
    SET oRes = FALSE;

    BEGIN
        DECLARE CONTINUE HANDLER FOR NOT FOUND SET xCharId = NULL;
        SELECT t.`charId` INTO xCharId FROM `characters` t WHERE t.`char_name` = iCharName AND t.`online` = 0  LIMIT 1;
    END;
    IF (xCharId IS NOT NULL) THEN

        BEGIN
            DECLARE CONTINUE HANDLER FOR NOT FOUND SET xObjID = NULL;
            SELECT c.`object_id` INTO xObjID FROM `items` c WHERE c.`item_id` = iItemId AND c.`owner_id` = xCharId LIMIT 1;
        END;
        IF (xObjID IS NOT NULL) THEN

            UPDATE `items` SET `count` = `count` + iItemCount WHERE `object_id` = xObjID;
            SET oRes = TRUE;
        ELSE

            WHILE fFlag = 0 DO

                SET xNewObjID = xNewObjID + 1;
                SET fFlag = 1;
                BEGIN
                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET iNewObjID = NULL;
                    SELECT d.`object_id` INTO iNewObjID FROM `items` d WHERE d.`object_id` = xNewObjID;
                END;
                IF (iNewObjID IS NOT NULL)AND(xNewObjID < xMaxObjID) THEN
                    SET fFlag = 0;
                END IF;
                BEGIN
                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET iNewObjID = NULL;
                    SELECT cd.`charId` INTO iNewObjID FROM `characters` cd WHERE cd.`charId` = xNewObjID;
                END;
                IF (iNewObjID IS NOT NULL)AND(xNewObjID < xMaxObjID) THEN
                    SET fFlag = 0;
                END IF;
                BEGIN
                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET iNewObjID = NULL;
                    SELECT cl.`clan_id` INTO iNewObjID FROM `clan_data` cl WHERE cl.`clan_id` = xNewObjID;
                END;
                IF (iNewObjID IS NOT NULL)AND(xNewObjID < xMaxObjID) THEN
                    SET fFlag = 0;
                END IF;
                BEGIN
                    DECLARE CONTINUE HANDLER FOR NOT FOUND SET iNewObjID = NULL;
                    SELECT tc.`object_id` INTO iNewObjID FROM `temporaryObjectTable` tc WHERE tc.`object_id` = xNewObjID;
                END;
                IF (iNewObjID IS NOT NULL)AND(xNewObjID < xMaxObjID) THEN
                    SET fFlag = 0;
                END IF;
            END WHILE;

            INSERT INTO `items`
                    (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`, `loc_data`, `custom_type1`, `custom_type2`, `mana_left`)
            VALUES  (xCharId, xNewObjID, iItemId, iItemCount, 0, 'INVENTORY', 0, 0, 0, -1);
            SET oRes = TRUE;
        END IF;
    END IF;
    RETURN oRes;
END;;
DELIMITER;

Войдите или зарегистрируйтесь чтобы ответить