[TuT] (PHP) Konwertowanie Item Proto Z Serwera Do Clienta

[Lyons]

<h2>Konwertowanie Item Proto Z Serwera Do Clienta</h2>
<center>
<form method=post>
<table border=0>
<tr bgcolor=#000>
 <td width=100>IP Serwera</td>
 <td width=80>Użytkownik</td>
 <td width=60>Hasło</td>
</tr>
<tr>
 <td align=left><input type="text" name="SQL_HOST_ITEM_PROTO" size=15 maxlength=15></td>
 <td align=left><input type="text" name="SQL_USER_ITEM_PROTO" size=10 maxlength=15></td>
 <td align=left><input type="text" name="SQL_PASSWORD_ITEM_PROTO" size=10 maxlength=32></td>
</tr>
<tr>
 <td colspan=2 align=right><input type="submit" value=" Generuj Listę "></td>
</tr>
</table>
</form>
</center>
<?
$SQL_HOST = $_POST['SQL_HOST_ITEM_PROTO'];
$SQL_USER = $_POST['SQL_USER_ITEM_PROTO'];
$SQL_PASSWORD = $_POST['SQL_PASSWORD_ITEM_PROTO'];
$con = mysql_connect($SQL_HOST, $SQL_USER, $SQL_PASSWORD);
if (!$con)
 {
 die('Błąd Z połączeniem ' . mysql_error());
 }
if (isset($_GET["name"])){$result_items = mysql_query('SELECT * FROM player.item_proto WHERE locale_name LIKE "%'.$_GET["name"].'%" ORDER BY vnum', $con);}
else {$result_items = mysql_query('SELECT * FROM player.item_proto ORDER BY vnum', $con);}
if (mysql_num_rows($result_items) == 0) {exit("Błąd! Podane Dane Są Nie Poprawne!");}
echo "<textarea type='text' name='xml_code' wrap='off' class='textbox' style='width: 100%; height: 80%;'>";
while($row = mysql_fetch_array($result_items))
{
$local_name = $row['name'];
while(substr($local_name, -1, 1) == " "){
 $local_name = substr($local_name, 0, -1);
}
$name = $row['locale_name'];
while(substr($name, -1, 1) == " "){
 $name = substr($name, 0, -1);
}
$xml = ' <Item vnum="'.$row['vnum'].'" name="'.$local_name.'" gb2312name="'.$name.'" type="'.$row['type'].'" subtype="'.$row['subtype'].'" weight="'.$row['weight'].'" size="'.$row['size'].'" antiflag="'.$row['antiflag'].'" flag="'.$row['flag'].'" wearflag="'.$row['wearflag'].'" immuneflag="'.$row['immuneflag'].'" gold="'.$row['gold'].'" buy_price="'.$row['shop_buy_price'].'" limittype0="'.$row['limittype0'].'" limitvalue0="'.$row['limitvalue0'].'" limittype1="'.$row['limittype1'].'" limitvalue1="'.$row['limitvalue1'].'" applytype0="'.$row['applytype0'].'" applyvalue0="'.$row['applyvalue0'].'" applytype1="'.$row['applytype1'].'" applyvalue1="'.$row['applyvalue1'].'" applytype2="'.$row['applytype2'].'" applyvalue2="'.$row['applyvalue2'].'" value0="'.$row['value0'].'" value1="'.$row['value1'].'" value2="'.$row['value2'].'" value3="'.$row['value3'].'" value4="'.$row['value4'].'" value5="'.$row['value5'].'" socket0="'.$row['socket0'].'" socket1="'.$row['socket1'].'" socket2="'.$row['socket2'].'" socket3="'.$row['socket3'].'" socket4="'.$row['socket4'].'" socket5="'.$row['socket5'].'" refine_vnum="'.$row['refined_vnum'].'" refine_set="'.$row['refine_set'].'" magic_pct="'.$row['magic_pct'].'" specular="'.$row['specular'].'" socket_pct="'.$row['socket_pct'].'" />';
$xml = htmlspecialchars($xml);
echo $xml;
echo "\n";
}
echo "</textarea>";
mysql_close($con);
?>

 

 

Jeżeli coś nie pasi to wy... : )

[Lyons]

f5

[Lyons]

Cześć można prosić o jakiś mini tut do tego tematu tutaj na pw

http://www.mpcforum....era-do-clienta/

 

1. Zapisujemy skrypt jako np generowanie.php

2. Dajemy skrypt na hosting

3. wpisujemy domena/generowanie.php

4. Uzupełniamy dane w odpowiednie miejsca jakie wyskocza

5. YEAH! Gratulacje działa

[Kuń]

http://www.inforge.net/community/metin2-howto-addon-server-privati/268912-release-convertitore-item_proto-sql-xml-%7Bpiu-veloce-e-megliorato%7D.html#post2652324

pozdro jestes zerem.

[Lyons]

Zero to Ty masz pomiędzy nogami.

 

Dziwne ale skrypt jest bardzo podobny... Ps ten skrypt leży u mnie z rok i na Quentus był z 8 miesięcy temu...