Nu merge crea_item.php și aș dori o soluție[rezolvat!]

echinoxm · 22 Dec 2014, 05:07

Salut ! am si eu un servar de metin si am incercat sa bag scriptul pentru modate si imi zice

Conectare la baza de date in curs...
Conexiune stabilita!
Baza de date selectata ...
Scriere valori in curs...
Itemul nu a fost creat!

Ma puteti ajuta !!!
Mentionez ca am servarul de la lcs phpMyAdmin.

PS: Daca am gresit sectiunea rog un moderator sa-l mute, nu am stiut exact unde sa postez .

[Rezolvat!]

Gr1mjoww · 22 Dec 2014, 08:11

Configureaza scriptul pentru serverul tau,cu datele lui.

echinoxm · 22 Dec 2014, 12:33

L-am configurat si nu odata de 10 ori cel putin tot nu reusesc !
Si imi zice ca conesiunea la server a fost facuta

Cod: Selectaţi tot

Conectare la baza de date in curs...
Conexiune stabilita!
Baza de date selectata ...
Scriere valori in curs...
Itemul nu a fost creat!

Imi zi ca conexiunea a fost stabilita
Sau poate nam bagat eu parola ca astia de la LCS mi-au dat 4 parole , parola nu e aia de la navicat(situ-l MySQL cum am eu)?

Nazir a.k.a. Zorke · 22 Dec 2014, 13:25

Parola e aceea de la navicat, incearca sa intri in navicat -> player si pe tabelul item dai click dreapta -> design table si pe prima linie ai asa la NAME " id" lasi asa si mai in dreapta ai TYPE la tine e " int " selecteaza acolo " bigint " salveaza dai reboot si incearca sa faci itemul cand contul tii offline.

constantin99 · 22 Dec 2014, 20:23

Quest complet! Nu modifica navicatul ca pierzi tot.

Unde scriu eu stergi pana la ` si modifici cu ce zic eu in acele``
Creeaza un fisier cu ce nume vrei in webhost cu extensia .php
pui acest quest acolo , modifici in felul care zic eu acolo.
si intri pe site-ul tau dupa site pui /aici numele fisierului creat.php

<?php
/*
Site tau

Cod: Selectaţi tot

<?php
/*
metin2remix.com
*/
$host_db=`ip .100`;
$Login_db='root';
$pwd_db='123456';
$bdd_name='account';
if(isset($_POST['owner_id'])){
$owner_id=$_POST['owner_id'];
$window=$_POST['window'];
$pos=$_POST['pos'];
$count=$_POST['count'];
$vnum=$_POST['vnum'];
$socket0=$_POST['socket0'];
$socket1=$_POST['socket1'];
$socket2=$_POST['socket2'];
$socket3=$_POST['socket3'];
$socket4=$_POST['socket4'];
$socket5=$_POST['socket5'];
$attrtype0=$_POST['attrtype0'];
$attrtype1=$_POST['attrtype1'];
$attrtype2=$_POST['attrtype2'];
$attrtype3=$_POST['attrtype3'];
$attrtype4=$_POST['attrtype4'];
$attrtype5=$_POST['attrtype5'];
$attrtype6=$_POST['attrtype6'];
$attrvalue0=$_POST['attrvalue0'];
$attrvalue1=$_POST['attrvalue1'];
$attrvalue2=$_POST['attrvalue2'];
$attrvalue3=$_POST['attrvalue3'];
$attrvalue4=$_POST['attrvalue4'];
$attrvalue5=$_POST['attrvalue5'];
$attrvalue6=$_POST['attrvalue6'];
echo("Conectarea la baza de date MySQL in curs de desfasurare ...<br>");
mysql_connect($host_db,$Login_db,$pwd_db);
echo("Conectare stabilita!<br>");
mysql_select_db($bdd_name);
echo("Baza de date selctata ...<br>Introducere valori in curs...<br>");
$request="INSERT INTO `player`.`item` (`id`, `owner_id`, `window`, `pos`, `count`, `vnum`, `socket0`, `socket1`, `socket2`, `socket3`, `socket4`, `socket5`, `attrtype0`, `attrvalue0`, `attrtype1`, `attrvalue1`, `attrtype2`, `attrvalue2`, `attrtype3`, `attrvalue3`, `attrtype4`, `attrvalue4`, `attrtype5`, `attrvalue5`, `attrtype6`, `attrvalue6`) VALUES ('NULL', '$owner_id', '$window', '$pos', '$count', '$vnum', '$socket0', '$socket1', '$socket2', 'NULL', 'NULL', 'NULL', '$attrtype0', '$attrvalue0', '$attrtype1', '$attrvalue1', '$attrtype2', '$attrvalue2', '$attrtype3', '$attrvalue3', '$attrtype4', '$attrvalue4', '$attrtype5', '$attrvalue5', '$attrtype6', '$attrvalue6');";

	if(mysql_query($request)){ echo("Item creeat cu succes!<br> Script by Wufe, Tradus in romana de sTyx pentru forumul -cenzurat-.net!"); } else { echo("Eroare: itemul nu a fost creeat :("); }

}else{

 
	echo "	<FORM action='crea_item.php' method='post' name='form01'>
	
			<center><table border='0' width='95%' align='center'>
            <tr>


            <td>Id cont</td><td> 
            <input tabindex='1' name='owner_id' class='application' size='30' /></td>
            </tr>

            <td>Unde pozitionez itemul?</td><td> 
            <select name='window'>
			<option value='MALL'>Item Shop</option>
			<option value='SAFEBOX'>Magazin</option>
			</select>
			</td>
            </tr>

            <td>Pozitie</td><td> 
            <input tabindex='1' name='pos' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Cantitate</td><td> 
            <select name='count'>
			<option value='1'>1</option>
			<option value='25'>25</option>
			<option value='50'>50</option>
			<option value='100'>100</option>
			<option value='150'>150</option>
			<option value='200'>200</option>
			</select>
			</td>
            </tr>

            <tr>
            <td>Cod item</td><td> 
            <input tabindex='2' name='vnum' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Piatra n°1</td><td> 
            <select name='socket0'>
			<option> </option>
			<option value='28030'>Piatra Patrunderii +0</option>
			<option value='28130'>Piatra Patrunderii +1</option>
			<option value='28230'>Piatra Patrunderii +2</option>
			<option value='28330'>Piatra Patrunderii +3</option>
			<option value='28430'>Piatra Patrunderii +4</option>
			<option value='28530'>Piatra Patrunderii +5</option>
			<option value='28630'>Piatra Patrunderii +6</option>
			<option>-----------</option>
			<option value='28031'>Piatra Loviturii Critice +0</option>
			<option value='28131'>Piatra Loviturii Critice +1</option>
			<option value='28231'>Piatra Loviturii Critice +2</option>
			<option value='28331'>Piatra Loviturii Critice +3</option>
			<option value='28431'>Piatra Loviturii Critice +4</option>
			<option value='28531'>Piatra Loviturii Critice +5</option>
			<option value='28631'>Piatra Loviturii Critice +6</option>
			<option>-----------</option>
			<option value='28032'>Piatra Regenerarii +0</option>
			<option value='28132'>Piatra Regenerarii +1</option>
			<option value='28232'>Piatra Regenerarii+2</option>
			<option value='28332'>Piatra Regenerarii +3</option>
			<option value='28432'>Piatra Regenerarii +4</option>
			<option value='28532'>Piatra Regenerarii +5</option>
			<option value='28632'>Piatra Regenerarii +6</option>
			<option>-----------</option>
			<option value='28033'>Piatra Anti-Warrior +0</option>
			<option value='28133'>Piatra Anti-Warrior +1</option>
			<option value='28233'>Piatra Anti-Warrior +2</option>
			<option value='28333'>Piatra Anti-Warrior +3</option>
			<option value='28433'>Piatra Anti-Warrior +4</option>
			<option value='28533'>Piatra Anti-Warrior +5</option>
			<option value='28633'>Piatra Anti-Warrior +6</option>
			<option>-----------</option>
			<option value='28034'>Piatra Anti-Ninja +0</option>
			<option value='28134'>Piatra Anti-Ninja +1</option>
			<option value='28234'>Piatra Anti-Ninja +2</option>
			<option value='28334'>Piatra Anti-Ninja +3</option>
			<option value='28434'>Piatra Anti-Ninja +4</option>
			<option value='28534'>Piatra Anti-Ninja +5</option>
			<option value='28634'>Piatra Anti-Ninja +6</option>
			<option>-----------</option>
			<option value='28035'>Piatra Anti-Sura +0</option>
			<option value='28135'>Piatra Anti-Sura +1</option>
			<option value='28235'>Piatra Anti-Sura +2</option>
			<option value='28335'>Piatra Anti-Sura +3</option>
			<option value='28435'>Piatra Anti-Sura +4</option>
			<option value='28535'>Piatra Anti-Sura +5</option>
			<option value='28635'>Piatra Anti-Sura +6</option>
			<option>-----------</option>
			<option value='28036'>Piatra Anti-Saman +0</option>
			<option value='28136'>Piatra Anti-Saman +1</option>
			<option value='28236'>Piatra Anti-Saman +2</option>
			<option value='28336'>Piatra Anti-Saman +3</option>
			<option value='28436'>Piatra Anti-Saman +4</option>
			<option value='28536'>Piatra Anti-Saman +5</option>
			<option value='28636'>Piatra Anti-Saman +6</option>
			<option>-----------</option>
			<option value='28037'>Piatra Monstrilor +0</option>
			<option value='28137'>Piatra Monstrilor+1</option>
			<option value='28237'>Piatra Monstrilor +2</option>
			<option value='28337'>Piatra Monstrilor +3</option>
			<option value='28437'>Piatra Monstrilor +4</option>
			<option value='28537'>Piatra Monstrilor +5</option>
			<option value='28637'>Piatra Monstrilor +6</option>
			<option>-----------</option>
			<option value='28038'>Piatra Eschivei +0</option>
			<option value='28138'>Piatra Eschivei +1</option>
			<option value='28238'>Piatra Eschivei +2</option>
			<option value='28338'>Piatra Eschivei +3</option>
			<option value='28438'>Piatra Eschivei +4</option>
			<option value='28538'>Piatra Eschivei +5</option>
			<option value='28638'>Piatra Eschivei +6</option>
			<option>-----------</option>
			<option value='28039'>Piatra anti-sageti +0</option>
			<option value='28139'>Piatra anti-sageti +1</option>
			<option value='28239'>Piatra anti-sageti +2</option>
			<option value='28339'>Piatra anti-sageti +3</option>
			<option value='28439'>Piatra anti-sageti +4</option>
			<option value='28539'>Piatra anti-sageti +5</option>
			<option value='28639'>Piatra anti-sageti +6</option>
			<option>-----------</option>
			<option value='28040'>Piatra Magiei +0</option>
			<option value='28140'>Piatra Magiei +1</option>
			<option value='28240'>Piatra Magiei +2</option>
			<option value='28340'>Piatra Magiei +3</option>
			<option value='28440'>Piatra Magiei +4</option>
			<option value='28540'>Piatra Magiei +5</option>
			<option value='28640'>Piatra Magiei +6</option>
			<option>-----------</option>
			<option value='28041'>Piatra Vitalitatii +0</option>
			<option value='28141'>Piatra Vitalitati +1</option>
			<option value='28241'>Piatra Vitalitati +2</option>
			<option value='28341'>Piatra Vitalitati +3</option>
			<option value='28441'>Piatra Vitalitati +4</option>
			<option value='28541'>Piatra Vitalitati +5</option>
			<option value='28641'>Piatra Vitalitati +6</option>
			<option>-----------</option>
			<option value='28042'>Piatra Protectiei +0</option>
			<option value='28142'>Piatra Protectiei +1</option>
			<option value='28242'>Piatra Protectiei +2</option>
			<option value='28342'>Piatra Protectiei +3</option>
			<option value='28442'>Piatra Protectiei +4</option>
			<option value='28542'>Piatra Protectiei +5</option>
			<option value='28642'>Piatra Protectiei +6</option>
			<option>-----------</option>
			<option value='28043'>Piatra Grabei +0</option>
			<option value='28143'>Piatra Grabei +1</option>
			<option value='28243'>Piatra Grabei +2</option>
			<option value='28343'>Piatra Grabei +3</option>
			<option value='28443'>Piatra Grabei +4</option>
			<option value='28543'>Piatra Grabei +5</option>
			<option value='28643'>Piatra Grabei +6</option>
			<option>-----------</option>
			<option value='28000'>Piatra Mintii +0</option>
			<option value='28100'>Piatra Mintii +1</option>
			<option value='28104'>Piatra Terorii +1</option>
			<option value='28200'>Piatra Mintii +2</option>
			<option value='28300'>Piatra Mintii +3</option>
			</select>
			</td>
            </tr>

            <tr>
            <td>Piatra n°2</td><td> 
                        <select name='socket1'>
						<option> </option>
			<option value='28030'>Piatra Patrunderii +0</option>
			<option value='28130'>Piatra Patrunderii +1</option>
			<option value='28230'>Piatra Patrunderii +2</option>
			<option value='28330'>Piatra Patrunderii +3</option>
			<option value='28430'>Piatra Patrunderii +4</option>
			<option value='28530'>Piatra Patrunderii +5</option>
			<option value='28630'>Piatra Patrunderii +6</option>
			<option>-----------</option>
			<option value='28031'>Piatra Loviturii Critice +0</option>
			<option value='28131'>Piatra Loviturii Critice +1</option>
			<option value='28231'>Piatra Loviturii Critice +2</option>
			<option value='28331'>Piatra Loviturii Critice +3</option>
			<option value='28431'>Piatra Loviturii Critice +4</option>
			<option value='28531'>Piatra Loviturii Critice +5</option>
			<option value='28631'>Piatra Loviturii Critice +6</option>
			<option>-----------</option>
			<option value='28032'>Piatra Regenerarii +0</option>
			<option value='28132'>Piatra Regenerarii +1</option>
			<option value='28232'>Piatra Regenerarii+2</option>
			<option value='28332'>Piatra Regenerarii +3</option>
			<option value='28432'>Piatra Regenerarii +4</option>
			<option value='28532'>Piatra Regenerarii +5</option>
			<option value='28632'>Piatra Regenerarii +6</option>
			<option>-----------</option>
			<option value='28033'>Piatra Anti-Warrior +0</option>
			<option value='28133'>Piatra Anti-Warrior +1</option>
			<option value='28233'>Piatra Anti-Warrior +2</option>
			<option value='28333'>Piatra Anti-Warrior +3</option>
			<option value='28433'>Piatra Anti-Warrior +4</option>
			<option value='28533'>Piatra Anti-Warrior +5</option>
			<option value='28633'>Piatra Anti-Warrior +6</option>
			<option>-----------</option>
			<option value='28034'>Piatra Anti-Ninja +0</option>
			<option value='28134'>Piatra Anti-Ninja +1</option>
			<option value='28234'>Piatra Anti-Ninja +2</option>
			<option value='28334'>Piatra Anti-Ninja +3</option>
			<option value='28434'>Piatra Anti-Ninja +4</option>
			<option value='28534'>Piatra Anti-Ninja +5</option>
			<option value='28634'>Piatra Anti-Ninja +6</option>
			<option>-----------</option>
			<option value='28035'>Piatra Anti-Sura +0</option>
			<option value='28135'>Piatra Anti-Sura +1</option>
			<option value='28235'>Piatra Anti-Sura +2</option>
			<option value='28335'>Piatra Anti-Sura +3</option>
			<option value='28435'>Piatra Anti-Sura +4</option>
			<option value='28535'>Piatra Anti-Sura +5</option>
			<option value='28635'>Piatra Anti-Sura +6</option>
			<option>-----------</option>
			<option value='28036'>Piatra Anti-Saman +0</option>
			<option value='28136'>Piatra Anti-Saman +1</option>
			<option value='28236'>Piatra Anti-Saman +2</option>
			<option value='28336'>Piatra Anti-Saman +3</option>
			<option value='28436'>Piatra Anti-Saman +4</option>
			<option value='28536'>Piatra Anti-Saman +5</option>
			<option value='28636'>Piatra Anti-Saman +6</option>
			<option>-----------</option>
			<option value='28037'>Piatra Monstrilor +0</option>
			<option value='28137'>Piatra Monstrilor+1</option>
			<option value='28237'>Piatra Monstrilor +2</option>
			<option value='28337'>Piatra Monstrilor +3</option>
			<option value='28437'>Piatra Monstrilor +4</option>
			<option value='28537'>Piatra Monstrilor +5</option>
			<option value='28637'>Piatra Monstrilor +6</option>
			<option>-----------</option>
			<option value='28038'>Piatra Eschivei +0</option>
			<option value='28138'>Piatra Eschivei +1</option>
			<option value='28238'>Piatra Eschivei +2</option>
			<option value='28338'>Piatra Eschivei +3</option>
			<option value='28438'>Piatra Eschivei +4</option>
			<option value='28538'>Piatra Eschivei +5</option>
			<option value='28638'>Piatra Eschivei +6</option>
			<option>-----------</option>
			<option value='28039'>Piatra anti-sageti +0</option>
			<option value='28139'>Piatra anti-sageti +1</option>
			<option value='28239'>Piatra anti-sageti +2</option>
			<option value='28339'>Piatra anti-sageti +3</option>
			<option value='28439'>Piatra anti-sageti +4</option>
			<option value='28539'>Piatra anti-sageti +5</option>
			<option value='28639'>Piatra anti-sageti +6</option>
			<option>-----------</option>
			<option value='28040'>Piatra Magiei +0</option>
			<option value='28140'>Piatra Magiei +1</option>
			<option value='28240'>Piatra Magiei +2</option>
			<option value='28340'>Piatra Magiei +3</option>
			<option value='28440'>Piatra Magiei +4</option>
			<option value='28540'>Piatra Magiei +5</option>
			<option value='28640'>Piatra Magiei +6</option>
			<option>-----------</option>
			<option value='28041'>Piatra Vitalitatii +0</option>
			<option value='28141'>Piatra Vitalitati +1</option>
			<option value='28241'>Piatra Vitalitati +2</option>
			<option value='28341'>Piatra Vitalitati +3</option>
			<option value='28441'>Piatra Vitalitati +4</option>
			<option value='28541'>Piatra Vitalitati +5</option>
			<option value='28641'>Piatra Vitalitati +6</option>
			<option>-----------</option>
			<option value='28042'>Piatra Protectiei +0</option>
			<option value='28142'>Piatra Protectiei +1</option>
			<option value='28242'>Piatra Protectiei +2</option>
			<option value='28342'>Piatra Protectiei +3</option>
			<option value='28442'>Piatra Protectiei +4</option>
			<option value='28542'>Piatra Protectiei +5</option>
			<option value='28642'>Piatra Protectiei +6</option>
			<option>-----------</option>
			<option value='28043'>Piatra Grabei +0</option>
			<option value='28143'>Piatra Grabei +1</option>
			<option value='28243'>Piatra Grabei +2</option>
			<option value='28343'>Piatra Grabei +3</option>
			<option value='28443'>Piatra Grabei +4</option>
			<option value='28543'>Piatra Grabei +5</option>
			<option value='28643'>Piatra Grabei +6</option>
			<option>-----------</option>
			<option value='28000'>Piatra Mintii +0</option>
			<option value='28100'>Piatra Mintii +1</option>
			<option value='28104'>Piatra Terorii +1</option>
			<option value='28200'>Piatra Mintii +2</option>
			<option value='28300'>Piatra Mintii +3</option>
			</select>
			</td>
            </tr>

            <tr>
            <td>Piatra n°3</td><td> 
                        <select name='socket2'>
						<option> </option>
			<option value='28030'>Piatra Patrunderii +0</option>
			<option value='28130'>Piatra Patrunderii +1</option>
			<option value='28230'>Piatra Patrunderii +2</option>
			<option value='28330'>Piatra Patrunderii +3</option>
			<option value='28430'>Piatra Patrunderii +4</option>
			<option value='28530'>Piatra Patrunderii +5</option>
			<option value='28630'>Piatra Patrunderii +6</option>
			<option>-----------</option>
			<option value='28031'>Piatra Loviturii Critice +0</option>
			<option value='28131'>Piatra Loviturii Critice +1</option>
			<option value='28231'>Piatra Loviturii Critice +2</option>
			<option value='28331'>Piatra Loviturii Critice +3</option>
			<option value='28431'>Piatra Loviturii Critice +4</option>
			<option value='28531'>Piatra Loviturii Critice +5</option>
			<option value='28631'>Piatra Loviturii Critice +6</option>
			<option>-----------</option>
			<option value='28032'>Piatra Regenerarii +0</option>
			<option value='28132'>Piatra Regenerarii +1</option>
			<option value='28232'>Piatra Regenerarii+2</option>
			<option value='28332'>Piatra Regenerarii +3</option>
			<option value='28432'>Piatra Regenerarii +4</option>
			<option value='28532'>Piatra Regenerarii +5</option>
			<option value='28632'>Piatra Regenerarii +6</option>
			<option>-----------</option>
			<option value='28033'>Piatra Anti-Warrior +0</option>
			<option value='28133'>Piatra Anti-Warrior +1</option>
			<option value='28233'>Piatra Anti-Warrior +2</option>
			<option value='28333'>Piatra Anti-Warrior +3</option>
			<option value='28433'>Piatra Anti-Warrior +4</option>
			<option value='28533'>Piatra Anti-Warrior +5</option>
			<option value='28633'>Piatra Anti-Warrior +6</option>
			<option>-----------</option>
			<option value='28034'>Piatra Anti-Ninja +0</option>
			<option value='28134'>Piatra Anti-Ninja +1</option>
			<option value='28234'>Piatra Anti-Ninja +2</option>
			<option value='28334'>Piatra Anti-Ninja +3</option>
			<option value='28434'>Piatra Anti-Ninja +4</option>
			<option value='28534'>Piatra Anti-Ninja +5</option>
			<option value='28634'>Piatra Anti-Ninja +6</option>
			<option>-----------</option>
			<option value='28035'>Piatra Anti-Sura +0</option>
			<option value='28135'>Piatra Anti-Sura +1</option>
			<option value='28235'>Piatra Anti-Sura +2</option>
			<option value='28335'>Piatra Anti-Sura +3</option>
			<option value='28435'>Piatra Anti-Sura +4</option>
			<option value='28535'>Piatra Anti-Sura +5</option>
			<option value='28635'>Piatra Anti-Sura +6</option>
			<option>-----------</option>
			<option value='28036'>Piatra Anti-Saman +0</option>
			<option value='28136'>Piatra Anti-Saman +1</option>
			<option value='28236'>Piatra Anti-Saman +2</option>
			<option value='28336'>Piatra Anti-Saman +3</option>
			<option value='28436'>Piatra Anti-Saman +4</option>
			<option value='28536'>Piatra Anti-Saman +5</option>
			<option value='28636'>Piatra Anti-Saman +6</option>
			<option>-----------</option>
			<option value='28037'>Piatra Monstrilor +0</option>
			<option value='28137'>Piatra Monstrilor+1</option>
			<option value='28237'>Piatra Monstrilor +2</option>
			<option value='28337'>Piatra Monstrilor +3</option>
			<option value='28437'>Piatra Monstrilor +4</option>
			<option value='28537'>Piatra Monstrilor +5</option>
			<option value='28637'>Piatra Monstrilor +6</option>
			<option>-----------</option>
			<option value='28038'>Piatra Eschivei +0</option>
			<option value='28138'>Piatra Eschivei +1</option>
			<option value='28238'>Piatra Eschivei +2</option>
			<option value='28338'>Piatra Eschivei +3</option>
			<option value='28438'>Piatra Eschivei +4</option>
			<option value='28538'>Piatra Eschivei +5</option>
			<option value='28638'>Piatra Eschivei +6</option>
			<option>-----------</option>
			<option value='28039'>Piatra anti-sageti +0</option>
			<option value='28139'>Piatra anti-sageti +1</option>
			<option value='28239'>Piatra anti-sageti +2</option>
			<option value='28339'>Piatra anti-sageti +3</option>
			<option value='28439'>Piatra anti-sageti +4</option>
			<option value='28539'>Piatra anti-sageti +5</option>
			<option value='28639'>Piatra anti-sageti +6</option>
			<option>-----------</option>
			<option value='28040'>Piatra Magiei +0</option>
			<option value='28140'>Piatra Magiei +1</option>
			<option value='28240'>Piatra Magiei +2</option>
			<option value='28340'>Piatra Magiei +3</option>
			<option value='28440'>Piatra Magiei +4</option>
			<option value='28540'>Piatra Magiei +5</option>
			<option value='28640'>Piatra Magiei +6</option>
			<option>-----------</option>
			<option value='28041'>Piatra Vitalitatii +0</option>
			<option value='28141'>Piatra Vitalitati +1</option>
			<option value='28241'>Piatra Vitalitati +2</option>
			<option value='28341'>Piatra Vitalitati +3</option>
			<option value='28441'>Piatra Vitalitati +4</option>
			<option value='28541'>Piatra Vitalitati +5</option>
			<option value='28641'>Piatra Vitalitati +6</option>
			<option>-----------</option>
			<option value='28042'>Piatra Protectiei +0</option>
			<option value='28142'>Piatra Protectiei +1</option>
			<option value='28242'>Piatra Protectiei +2</option>
			<option value='28342'>Piatra Protectiei +3</option>
			<option value='28442'>Piatra Protectiei +4</option>
			<option value='28542'>Piatra Protectiei +5</option>
			<option value='28642'>Piatra Protectiei +6</option>
			<option>-----------</option>
			<option value='28043'>Piatra Grabei +0</option>
			<option value='28143'>Piatra Grabei +1</option>
			<option value='28243'>Piatra Grabei +2</option>
			<option value='28343'>Piatra Grabei +3</option>
			<option value='28443'>Piatra Grabei +4</option>
			<option value='28543'>Piatra Grabei +5</option>
			<option value='28643'>Piatra Grabei +6</option>
			<option>-----------</option>
			<option value='28000'>Piatra Mintii +0</option>
			<option value='28100'>Piatra Mintii +1</option>
			<option value='28104'>Piatra Terorii +1</option>
			<option value='28200'>Piatra Mintii +2</option>
			<option value='28300'>Piatra Mintii +3</option>
			</select>
			</td>
            </tr>

            <tr>
            <td>Bonus n°1</td><td> 
            <select name='attrtype0'>
			<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select>			
			</td>
            </tr>

            <tr>
            <td>Valoare Bonus n°1</td><td> 
            <input tabindex='2' name='attrvalue0' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°2</td><td> 
                        <select name='attrtype1'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valore Bonus n°2</td><td> 
            <input tabindex='2' name='attrvalue1' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°3</td><td> 
                        <select name='attrtype2'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valore Bonus n°3</td><td> 
            <input tabindex='2' name='attrvalue2' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°4</td><td> 
                        <select name='attrtype3'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valore Bonus n°4</td><td> 
            <input tabindex='2' name='attrvalue3' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°5</td><td> 
                        <select name='attrtype4'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valroe Bonus n°5</td><td> 
            <input tabindex='2' name='attrvalue4' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°6</td><td> 
                        <select name='attrtype5'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valore Bonus n°6</td><td> 
            <input tabindex='2' name='attrvalue5' class='application' size='30' /></td>
            </tr>

            <tr>
            <td>Bonus n°7</td><td> 
                        <select name='attrtype6'>
						<option> </option>
			<option value='72'>Paguba Medie</option>
			<option value='71'>Paguba Competentei</option>
			<option value='17'>Semi-oameni</option>
			<option value='1'>Max HP</option>
			<option value='9'>Valoarea Magiei</option>
			<option value='13'>Posbilitatea a ametire</option>
			<option value='12'>Posibilitatea de otravire</option>
			<option value='14'>Posibilitatea incetinirii</option>
			<option value='5'>STR</option>
			<option value='15'>Posibilitatrea la Lovituri Critice</option>
			<option value='16'>Posibilitatrea la Lovituri Patrunzatoare</option>
			<option value='4'>INT</option>
			<option value='48'>Imun la ameteala</option>
			<option value='8'>Viteaza de miscare</option>
			<option value='21'>Puternic impotriva zombie</option>
			<option value='41'>Resisteza la otrava</option>
			<option value='7'>Viteza de atac</option>
			<option value='10'>Regenerare HP</option>
			<option value='29'>Aparare cu Sabia</option>
			<option value='30'>Aparare cu doua maini</option>
			<option value='31'>Aparare Pumnal</option>
			<option value='34'>Rezistenta la Sageti</option>
			<option value='38'>Rezistenta Vantului</option>
			<option value='32'>Rezistenta Lumina</option>
			<option value='37'>Rezistenta la Magie</option>
			<option value='6'>DEX</option>
			<option value='27'>Posibilitatea de a reflecta atacul corporal</option>
			</select></td>
            </tr>

            <tr>
            <td>Valore Bonus n°7</td><td> 
            <input tabindex='2' name='attrvalue6' class='application' size='30' /></td>
            </tr>


            <tr>
            
            </tr>

            </table>
			<center><button tabindex='6' name='submit' value='submit' class='eingabe-button' type='submit'>Trimite</button></td></center>
			</FORM>";
}
?>

Nazir a.k.a. Zorke · 22 Dec 2014, 20:42

Ce sa piarda frate? daca nu stii nu baga vrajelii ... ce am spus eu acolo e sa mareasca spatiul de stocare a itemelor , la el intra un numar finit de iteme pe cand big int are miliarde de numere.. unde se pot stoca memoriile itemelor.. nu pierde nimic daca modifica ce am zis eu

Metin2Mirage · 22 Dec 2014, 23:29

Am avut si eu la lcs net si si nu iti da acces la navicat , iti da linkul ala insuportabil, si cred ca de aia nu functioneaza... Intra in pglhpmyadmin si creaza-ti un user extern(pt navicat) apoi fa legatura cu datele userului exter.
Sincer nu sunt sigur daca va merge asa dar nu ai nimic de pierdut , incearca.
Sper ca te-am ajutat.

[ Mesaj scris via Android ] Imagine

echinoxm · 23 Dec 2014, 00:56

Va multumesc mult !! Pana la urma l-am rezolvat pe ala de pe site original.
Lam inlocuit cu asta . Il las aici poate mai are nevoie cineva de el.

Cod: Selectaţi tot

<?PHP
  if($_SESSION['user_admin']>=$adminRights['itemerstellung']) {
?>
<h2>Administrare - modare iteme</h2>
<?PHP
 
    if(isset($_POST['submit']) && $_POST['submit']=="Creaza") {
   
      if(checkInt($_POST['aid'])) {
        $sqlCmd = "SELECT COUNT(*) AS checkIn FROM account.account WHERE id='".$_POST['aid']."' LIMIT 1";
        $getCount = mysql_fetch_object(mysql_query($sqlCmd,$sqlServ));
        if($getCount->checkIn==1) {
         
          if(!empty($_POST['window']) && checkInt($_POST['position']) && !empty($_POST['itemtyp']) && checkInt($_POST['stufe']) && checkInt($_POST['stapelmenge'])) {
            if(!empty($_POST['vnum']) && checkInt($_POST['vnum'])) {
              $avnum=$_POST['vnum'];
            }
            else {
              if($_POST['itemtyp']>=11971 && $_POST['itemtyp']<=11974) {
                $_POST['stufe']=0;
              }
              $avnum=$_POST['itemtyp']+$_POST['stufe'];
            }
            $sqlCmd="INSERT INTO player.item
              (owner_id,window,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6)
              VALUES
              ('".$_POST['aid']."','".$_POST['window']."','".$_POST['position']."','".$_POST['stapelmenge']."','".$avnum."','".$_POST['socket0']."','".$_POST['socket1']."','".$_POST['socket2']."','".$_POST['boni0']."','".$_POST['boniv0']."','".$_POST['boni1']."','".$_POST['boniv1']."','".$_POST['boni2']."','".$_POST['boniv2']."','".$_POST['boni3']."','".$_POST['boniv3']."','".$_POST['boni4']."','".$_POST['boniv4']."','".$_POST['boni5']."','".$_POST['boniv5']."','".$_POST['boni6']."','".$_POST['boniv6']."')";
            $sqlQry = mysql_query($sqlCmd,$sqlServ) or die(mysql_error());
            if($sqlQry) {
              echo'<p class="meldung">Itemul a fost modat cu succes.</p>';
            }
          }
          else { echo'<p class="meldung">Modarea a e&#351;uat. A&#355;i introdus date incorecte.</p>'; }         
        }
        else { echo'<p class="meldung">Nu a&#355;i introdus nici un ID!</p>'; }
      }
      else { echo'<p class="meldung">ID-ul nu este valid.</p>'; }
   
    }
 
 
 
?>
<form action="" method="POST">
  <table>
    <tr>
      <th class="topLine">AccountID:</th>
      <td class="tdunkel"><input type="text" name="aid" size="11" value="<?PHP echo $_GET['acc']; ?>" maxlength="11" class="iRg_input"/></td>
    </tr>
    <tr>
      <th class="topLine">Loc:</th>
      <td class="thell">
        <select name="window" class="iRg_input">
          <option value="SAFEBOX">Depozit</option>
          <option value="MALL">Depozit ItemShop</option>
          <!-- <option value="INVENTORY">Inventar</option> -->
        </select>
      </td>
    </tr>
    <tr>
      <th class="topLine">Pozitie (Max. 44)</th>
      <td class="tdunkel"><input name="position" type="text" size="20" value="0" maxlength="20"  class="iRg_input"/></td>
    </tr>
    <tr>
      <th class="topLine">Item:</th>
      <td class="thell">
           <input type="text" name="itemtyp" size="11" value="" maxlength="11"  class="iRg_input"/>
        <select name="stufe" class="iRg_input">
          <?PHP
            for($i=0;$i<10;$i++) {
           
              echo "<option value=\"$i\">+$i</option>";
           
            }
          ?>
        </select>
      
      </td>
    </tr>
    <tr>
      <th class="topLine">Numar de iteme:</th>
      <td class="tdunkel"><input type="text" name="stapelmenge" size="20" maxlength="20" value="1"  class="iRg_input"/></td>
    </tr>
    <tr>
      <th class="topLine">Stone #1:</th>
      <td class="thell">
        <select name="socket0"  class="iRg_input">
          <?PHP
            foreach($itemSteine AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
      </td>
    </tr>
    <tr>
      <th class="topLine">Stone #2:</th>
      <td class="tdunkel">
        <select name="socket1"  class="iRg_input">
          <?PHP
            foreach($itemSteine AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
      </td>
    </tr>
    <tr>
      <th class="topLine">Stone #3:</th>
      <td class="thell">
        <select name="socket2"  class="iRg_input">
          <?PHP
            foreach($itemSteine AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #1:</th>
      <td class="tdunkel">
        <select name="boni0"  class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv0" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #2:</th>
      <td class="thell">
        <select name="boni1"  class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv1" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #3:</th>
      <td class="tdunkel">
        <select name="boni2" class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv2" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #4:</th>
      <td class="thell">
        <select name="boni3"  class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv3" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #5:</th>
      <td class="tdunkel">
        <select name="boni4" class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv4" size="6" maxlength="6"  class="iRg_input"/>

      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #6:</th>
      <td class="thell">
        <select name="boni5"  class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv5" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine">Bonus #7:</th>
      <td class="tdunkel">
        <select name="boni6"  class="iRg_input">
          <?PHP
            foreach($itemBoni AS $aKey => $aValue) {
              echo'<option value="'.$aKey.'">'.$aValue.'</option>';
            }
          ?>
        </select>
        <input type="text" name="boniv6" size="6" maxlength="6"  class="iRg_input"/>
      </td>
    </tr>
    <tr>
      <th class="topLine" colspan="2" style="text-align:center;">
      <br /><input type="submit" value="Creaza" name="submit" class="buton"/> &bull; <input type="reset" value="Reset" class="buton"/></th>
    </tr>
  </table>
</form>
<?php } else { echo error("Zona restrictionata.Drepturi de acces insuficiente.");}?><a href="index.php?page=panou-admin">&laquo; Inapoi la panou administrare</a>

[Rezolvat!]

Nazir a.k.a. Zorke · 23 Dec 2014, 09:45

Marcat ca si rezolvat !

Nu merge crea_item.php și aș dori o soluție[rezolvat!]

Nu merge ... și aș dori o soluție !

Nu merge ... și aș dori o soluție

Nu merge laucherul și aș dori o soluție

Nu merge questu acesta și aș dori o soluție

Cine este conectat