Sziasztok!
Beraktam a regoldalamba a Cucc kreátort csak 1 baj van hogy a raktárba beraktam 1 vértet de hiába nyomokrá hogy frissítés nem adja be a tárgy nevét hogy tudjam optolni mi lehet a baj?
Néma gyereknek..
Mutasd a PHP-t.
Itt van:
div id="content"> <div class="postui2 text-title">
<h2>
Cucc Kreátor (A raktárost zárd be optolás közben!)
</h2>
<>
<div class="postui2 text-con">
<div class="con-wrap">
<?php if(empty($_SESSION['user_id'])) {echo"Regisztrájl vagy jelentkezz be."; echo $endpage; exit;} ?>
<?php
echo "<title>Metin2 Staff-TradeAnalyzer</title>";
show_searchpanel($_POST['selected_gm']);
if (isset($_GET["search"]))
{
show_resultlist($_POST['selected_gm']);
}
function show_searchpanel($actual_gm) {
global $db_ip;
global $db_login;
global $db_pw;
$con = mysql_connect($db_ip, $db_login, $db_pw);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("account", $con);
$result = mysql_query("SELECT * FROM account");
echo "
<BR CLEAR=HEIGHT>
<div id='gmtrade'><form name='post' method='post' action='index.php?s=user&search'>
<table frame='box' width='100%' align='left' class=''>
<tr valign='left'>
<td class='tbl2' align='left'>
<select name = selected_gm style='visibility:hidden;'>
";
while($row = mysql_fetch_array($result))
{
$gm = $_SESSION['user_name'];
if ($gm == $actual_gm)
{
echo "<option value ='".$gm."' selected='selected'>".$gm."</option>";
}
else
{
echo "<option value ='".$gm."'>".$gm."</option>";
}
}
echo "
</select>
<input name='search' value='Frissítés' type='submit' class='button'>
</td>
</tr>
</table>
<>
";
}
function show_resultlist($gmName){
global $db_ip;
global $db_login;
global $db_pw;
$con = mysql_connect($db_ip, $db_login, $db_pw);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("account", $con);
$result = mysql_query("SELECT * FROM account WHERE login ='".$gmName."'");
while($row = mysql_fetch_array($result))
{
$gm_playerID = $_SESSION['user_id'];
}
mysql_select_db("player", $con);
$result_exchange = mysql_query("SELECT * FROM item WHERE window = 'SAFEBOX' AND owner_id = '".$gm_playerID."'");
$result_drop = mysql_query("SELECT * FROM item WHERE window = 'MALL' AND owner_id = '".$gm_playerID."'");
$result_item = mysql_query("SELECT * FROM item WHERE id='".$what."'");
while($row = mysql_fetch_array($result_item))
mysql_select_db("player", $con);
echo "
<table width='100%' align='left' border='1' cellspacing='0' cellpadding='0'>
<tr>
<th align='left' colspan='7'>Raktár</th>
</tr>
<tr>
<th>Item-ID</th>
<th>Tárgy</th>
</tr>
";
while($row = mysql_fetch_array($result_exchange))
{
$hint = $row['window'];
$vnum = $row['vnum'];
$what = $row['id'];
$red_mark = "";
mysql_select_db("common", $con);
$result_partner_gm = mysql_query("SELECT * FROM gmlist WHERE mName='".$partner_name."'");
while($row = mysql_fetch_array($result_partner_gm))
{
$red_mark = "";
}
if ($partner_name == "-------"){$red_mark = "";}
mysql_select_db("player", $con);
$result_item_name = mysql_query("SELECT * FROM item_proto WHERE vnum ='".$vnum."'");
while($row = mysql_fetch_array($result_item_name))
{
$item_name = $row['locale_name'];
$item_type = $row['type'];
$item_subtype = $row['subtype'];
}
mysql_select_db("player", $con);
echo "
<tr>
<td>".$vnum."</td>
<td><a href='index.php?s=item_manager_new&id=".$what."&t=".$item_type."&st=".$item_subtype."'>".$item_name."</a> "; if($_SESSION['user_admin']>5){echo" ---> <a href='index.php?s=item_manager_admin&id=".$what."&t=".$item_type."&st=".$item_subtype."'>ADMIN</a>";}echo" </td>
</tr>
";
}
echo "</table>";
//DROP
echo "
<br>
<table width='100%' align='left' border=0>
<tr>
<th align='left' height='25px'></th>
</tr>
</table>
<br>
<table width='100%' align='left' border='1' cellspacing='0' cellpadding='0'>
<tr>
<th align='left' colspan='8'>Boltraktár</th>
</tr>
<tr>
<th>Item-ID</th>
<th>Tárgy</th>
</tr>
";
while($row = mysql_fetch_array($result_drop))
{
$vnum = $row['vnum'];
$what = $row['id'];
mysql_select_db("player", $con);
$result_item_name = mysql_query("SELECT * FROM item_proto WHERE vnum ='".$vnum."'");
while($row = mysql_fetch_array($result_item_name))
{
$item_name = $row['locale_name'];
}
mysql_select_db("player", $con);
mysql_select_db("common", $con);
$result_partner_gm = mysql_query("SELECT * FROM gmlist WHERE mName='".$picker_name_gm."'");
while($row = mysql_fetch_array($result_partner_gm))
{
$red_mark = "";
}
if ($picker_name == "-------"){$red_mark = "";}
echo "
<tr".$red_mark.">
<td>".$vnum."</td>
<td><a href='index.php?s=item_manager_new&id=".$what."'>".$item_name."</a></td>";
}
echo "</table>";
echo "<br>
<TABLE align='center' WIDTH='100%'>
<tr>
<th align='left' height='25px'></th>
</tr>
<TR>
<TD align='left'><small>optimized for <a href='http://www.mozilla-europe.org/de/firefox/' target='_blank'>Mozilla Firefox</a></small></TD>
<TD align='right'><small>© musicinstructor, 2010</small></TD>
</TR>
</TABLE>
";
}
?>
<>
<>
<div class="postui2 text-end">
<><>
Használd lécíves legközelebb a code-t [MOD]Jerry
Idézetet írta: Zeratul Dátum 2016-07-10, 07:53:25
Itt van:
div id="content"> <div class="postui2 text-title">
<h2>
Cucc Kreátor (A raktárost zárd be optolás közben!)
</h2>
<>
<div class="postui2 text-con">
<div class="con-wrap">
<?php if(empty($_SESSION['user_id'])) {echo"Regisztrájl vagy jelentkezz be."; echo $endpage; exit;} ?>
<?php
echo "<title>Metin2 Staff-TradeAnalyzer</title>";
show_searchpanel($_POST['selected_gm']);
if (isset($_GET["search"]))
{
show_resultlist($_POST['selected_gm']);
}
function show_searchpanel($actual_gm) {
global $db_ip;
global $db_login;
global $db_pw;
$con = mysql_connect($db_ip, $db_login, $db_pw);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("account", $con);
$result = mysql_query("SELECT * FROM account");
echo "
<BR CLEAR=HEIGHT>
<div id='gmtrade'><form name='post' method='post' action='index.php?s=user&search'>
<table frame='box' width='100%' align='left' class=''>
<tr valign='left'>
<td class='tbl2' align='left'>
<select name = selected_gm style='visibility:hidden;'>
";
while($row = mysql_fetch_array($result))
{
$gm = $_SESSION['user_name'];
if ($gm == $actual_gm)
{
echo "<option value ='".$gm."' selected='selected'>".$gm."</option>";
}
else
{
echo "<option value ='".$gm."'>".$gm."</option>";
}
}
echo "
</select>
<input name='search' value='Frissítés' type='submit' class='button'>
</td>
</tr>
</table>
<>
";
}
function show_resultlist($gmName){
global $db_ip;
global $db_login;
global $db_pw;
$con = mysql_connect($db_ip, $db_login, $db_pw);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("account", $con);
$result = mysql_query("SELECT * FROM account WHERE login ='".$gmName."'");
while($row = mysql_fetch_array($result))
{
$gm_playerID = $_SESSION['user_id'];
}
mysql_select_db("player", $con);
$result_exchange = mysql_query("SELECT * FROM item WHERE window = 'SAFEBOX' AND owner_id = '".$gm_playerID."'");
$result_drop = mysql_query("SELECT * FROM item WHERE window = 'MALL' AND owner_id = '".$gm_playerID."'");
$result_item = mysql_query("SELECT * FROM item WHERE id='".$what."'");
while($row = mysql_fetch_array($result_item))
mysql_select_db("player", $con);
echo "
<table width='100%' align='left' border='1' cellspacing='0' cellpadding='0'>
<tr>
<th align='left' colspan='7'>Raktár</th>
</tr>
<tr>
<th>Item-ID</th>
<th>Tárgy</th>
</tr>
";
while($row = mysql_fetch_array($result_exchange))
{
$hint = $row['window'];
$vnum = $row['vnum'];
$what = $row['id'];
$red_mark = "";
mysql_select_db("common", $con);
$result_partner_gm = mysql_query("SELECT * FROM gmlist WHERE mName='".$partner_name."'");
while($row = mysql_fetch_array($result_partner_gm))
{
$red_mark = "";
}
if ($partner_name == "-------"){$red_mark = "";}
mysql_select_db("player", $con);
$result_item_name = mysql_query("SELECT * FROM item_proto WHERE vnum ='".$vnum."'");
while($row = mysql_fetch_array($result_item_name))
{
$item_name = $row['locale_name'];
$item_type = $row['type'];
$item_subtype = $row['subtype'];
}
mysql_select_db("player", $con);
echo "
<tr>
<td>".$vnum."</td>
<td><a href='index.php?s=item_manager_new&id=".$what."&t=".$item_type."&st=".$item_subtype."'>".$item_name."</a> "; if($_SESSION['user_admin']>5){echo" ---> <a href='index.php?s=item_manager_admin&id=".$what."&t=".$item_type."&st=".$item_subtype."'>ADMIN</a>";}echo" </td>
</tr>
";
}
echo "</table>";
//DROP
echo "
<br>
<table width='100%' align='left' border=0>
<tr>
<th align='left' height='25px'></th>
</tr>
</table>
<br>
<table width='100%' align='left' border='1' cellspacing='0' cellpadding='0'>
<tr>
<th align='left' colspan='8'>Boltraktár</th>
</tr>
<tr>
<th>Item-ID</th>
<th>Tárgy</th>
</tr>
";
while($row = mysql_fetch_array($result_drop))
{
$vnum = $row['vnum'];
$what = $row['id'];
mysql_select_db("player", $con);
$result_item_name = mysql_query("SELECT * FROM item_proto WHERE vnum ='".$vnum."'");
while($row = mysql_fetch_array($result_item_name))
{
$item_name = $row['locale_name'];
}
mysql_select_db("player", $con);
mysql_select_db("common", $con);
$result_partner_gm = mysql_query("SELECT * FROM gmlist WHERE mName='".$picker_name_gm."'");
while($row = mysql_fetch_array($result_partner_gm))
{
$red_mark = "";
}
if ($picker_name == "-------"){$red_mark = "";}
echo "
<tr".$red_mark.">
<td>".$vnum."</td>
<td><a href='index.php?s=item_manager_new&id=".$what."'>".$item_name."</a></td>";
}
echo "</table>";
echo "<br>
<TABLE align='center' WIDTH='100%'>
<tr>
<th align='left' height='25px'></th>
</tr>
<TR>
<TD align='left'><small>optimized for <a href='http://www.mozilla-europe.org/de/firefox/' target='_blank'>Mozilla Firefox</a></small></TD>
<TD align='right'><small>© musicinstructor, 2010</small></TD>
</TR>
</TABLE>
";
}
?>
<>
<>
<div class="postui2 text-end">
<><>
[ code ] taget használd légyszíves..
MySQL-ben nézd meg, hogy az item_proto-dban van-e locale_name oszlop.
de azt hogy hasznájam?
Üzenet összefésülés: 2016-07-10, 08:36:09
van benne locale_name oszlop
Üzenet összefésülés: 2016-07-10, 08:39:19
Másik regoldalnál meg ez jön be:
Fő könytárba tedd be az "attr_list" mappát és azon belül az "attr_list_kard.txt" "attr_list_plus.txt" és a további kellő txt fájlokat.
(hát ha még valakinek jól jön az infó..) :)
Csatolom a txt-ket.
LÉCCÍÍÍÍ(LE)VES HASZNÁLJATOK KÓÓÓÓDOT!!!! :'( :'(
by: Dzséérry