CK little

Indította Zeratul, 2016-07-10, 07:26:24

2016-07-10, 07:26:24 Utolsó szerkesztés: 2016-07-10, 08:06:11 Szerző: 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?
Még kezdÅ' vagyok de igyekszek tanulni :-) !

Néma gyereknek..

Mutasd a PHP-t.

2016-07-10, 07:53:25 #2 Utolsó szerkesztés: 2017-04-06, 11:35:11 Szerző: [MOD]Jerry
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;} ?>

<?phpecho "<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>";//DROPecho "<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
   
Még kezdÅ' vagyok de igyekszek tanulni :-) !

2016-07-10, 07:56:20 #3 Utolsó szerkesztés: 2016-07-10, 07:58:20 Szerző: Heaven™
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;} ?>

<?phpecho "<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>";//DROPecho "<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.

2016-07-10, 07:59:16 #4 Utolsó szerkesztés: 2016-07-10, 08:39:19 Szerző: 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:
Még kezdÅ' vagyok de igyekszek tanulni :-) !

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