CK little

[Zeratul]

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?

[Heavenâ„¢]

Néma gyereknek..

Mutasd a PHP-t.

[Zeratul]

Itt van:

Kód Kijelölés Kibont

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
   

[Heavenâ„¢]

Itt van:

Kód Kijelölés Kibont





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.

[Zeratul]

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:

[Zorg]

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.

[D4RR3]

LÉCCÍÍÍÍ(LE)VES HASZNÁLJATOK KÓÓÓÓDOT!!!!

by: Dzséérry