|
You last visited: Today at 22:43
Advertisement
[Release].php SQL zu XML Converter
Discussion on [Release].php SQL zu XML Converter within the Metin2 PServer Guides & Strategies forum part of the Metin2 Private Server category.
02/10/2012, 18:49
|
#1
|
elite*gold: 0 
Join Date: Dec 2009
Posts: 105
Received Thanks: 124
|
[Release].php SQL zu XML Converter
Hey ho,
ich hab mir mal die Mühe gemacht *hust* und habe einen .php Script erstellt, mit welchem man Items & Monster ( item_proto & mob_proto ) aus der Datenbank in das XML Format umwandelt.
Wozu man das braucht?
Quote:
Originally Posted by lfcmaus
die xml kannste dann packen XD und in den clienten einfügen
somit stimmen dann serverside und clientside item_proto und mob_proto überein
|
Wenn ihr "locale_name" habt:
item_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.item_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($item_proto = mysql_fetch_object($sqlQry))
{
$vnum = $item_proto->vnum;
$name = $item_proto->name;
$locale_name = $item_proto->locale_name;
$type = $item_proto->type;
$subtype = $item_proto->subtype;
$weight = $item_proto->weight;
$size = $item_proto->size;
$antiflag = $item_proto->antiflag;
$flag = $item_proto->flag;
$wearflag = $item_proto->wearflag;
$immuneflag = $item_proto->imuneflag;
$gold = $item_proto->gold;
$buy_price = $item_proto->shop_buy_price;
$limittype0 = $item_proto->limittype0;
$limitvalue0 = $item_proto->limitvalue0;
$limittype1 = $item_proto->limittype1;
$limitvalue1 = $item_proto->limitvalue1;
$applytype0 = $item_proto->applytype0;
$applyvalue0 = $item_proto->applyvalue0;
$applytype1 = $item_proto->applytype1;
$applyvalue1 = $item_proto->applyvalue1;
$applytype2 = $item_proto->applytype2;
$applyvalue2 = $item_proto->applyvalue2;
$value0 = $item_proto->value0;
$value1 = $item_proto->value1;
$value2 = $item_proto->value2;
$value3 = $item_proto->value3;
$value4 = $item_proto->value4;
$value5 = $item_proto->value5;
$socket0 = $item_proto->socket0;
$socket1 = $item_proto->socket1;
$socket2 = $item_proto->socket2;
$socket3 = $item_proto->socket3;
$socket4 = $item_proto->socket4;
$socket5 = $item_proto->socket5;
$refine_vnum = $item_proto->refined_vnum;
$refine_set = $item_proto->refine_set;
$magic_pct = $item_proto->magic_pct;
$specular = $item_proto->specular;
$socket_pct = $item_proto->socket_pct;
?><p><Item
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
subtype="<?php echo($subtype) ?>"
weight="<?php echo($weight) ?>"
size="<?php echo($size) ?>"
antiflag="<?php echo($antiflag) ?>"
flag="<?php echo($flag) ?>"
wearflag="<?php echo($wearflag) ?>"
immuneflag="<?php echo($imuneflag) ?>"
gold="<?php echo($gold) ?>"
buy_price="<?php echo($buy_price) ?>"
limittype0="<?php echo($limittype0) ?>"
limitvalue0="<?php echo($limitvalue0) ?>"
limittype1="<?php echo($limittype1) ?>"
limitvalue1="<?php echo($limitvalue1) ?>"
applytype0="<?php echo($applytype0) ?>"
applyvalue0="<?php echo($applyvalue0) ?>"
applytype1="<?php echo($applytype1) ?>"
applyvalue1="<?php echo($applyvalue1) ?>"
applytype2="<?php echo($applytype2) ?>"
applyvalue2="<?php echo($applyvalue2) ?>"
value0="<?php echo($value0) ?>"
value1="<?php echo($value1) ?>"
value2="<?php echo($value2) ?>"
value3="<?php echo($value3) ?>"
value4="<?php echo($value4) ?>"
value5="<?php echo($value5) ?>"
socket0="<?php echo($socket0) ?>"
socket1="<?php echo($socket1) ?>"
socket2="<?php echo($socket2) ?>"
socket3="<?php echo($socket3) ?>"
socket4="<?php echo($socket4) ?>"
socket5="<?php echo($socket5) ?>"
refine_vnum="<?php echo($refine_vnum) ?>"
refine_set="<?php echo($refine_set) ?>"
magic_pct="<?php echo($magic_pct) ?>"
specular="<?php echo($specular) ?>"
socket_pct="<?php echo($socket_pct) ?>"
/><p><?php
}
?>
</html>
mob_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.mob_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($mob_proto = mysql_fetch_object($sqlQry))
{
$vnum = $mob_proto->vnum;
$name = $mob_proto->name;
$locale_name = $mob_proto->locale_name;
$type = $mob_proto->type;
$rank = $mob_proto->rank;
$battle_type = $mob_proto->battle_type;
$level = $mob_proto->level;
$event_type = $mob_proto->on_click;
$mob_color = $mob_proto->mob_color;
?><p><Mob
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
rank="<?php echo($rank) ?>"
battle_type="<?php echo($battle_type) ?>"
level="<?php echo($level) ?>"
event_type="<?php echo($event_type) ?>"
mob_color="<?php echo($mob_color) ?>"
/><p><?php
}
?>
</html>
Wenn ihr "gb2312name" habt:
item_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.item_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($item_proto = mysql_fetch_object($sqlQry))
{
$vnum = $item_proto->vnum;
$name = $item_proto->name;
$locale_name = $item_proto->gb2312name;
$type = $item_proto->type;
$subtype = $item_proto->subtype;
$weight = $item_proto->weight;
$size = $item_proto->size;
$antiflag = $item_proto->antiflag;
$flag = $item_proto->flag;
$wearflag = $item_proto->wearflag;
$immuneflag = $item_proto->imuneflag;
$gold = $item_proto->gold;
$buy_price = $item_proto->shop_buy_price;
$limittype0 = $item_proto->limittype0;
$limitvalue0 = $item_proto->limitvalue0;
$limittype1 = $item_proto->limittype1;
$limitvalue1 = $item_proto->limitvalue1;
$applytype0 = $item_proto->applytype0;
$applyvalue0 = $item_proto->applyvalue0;
$applytype1 = $item_proto->applytype1;
$applyvalue1 = $item_proto->applyvalue1;
$applytype2 = $item_proto->applytype2;
$applyvalue2 = $item_proto->applyvalue2;
$value0 = $item_proto->value0;
$value1 = $item_proto->value1;
$value2 = $item_proto->value2;
$value3 = $item_proto->value3;
$value4 = $item_proto->value4;
$value5 = $item_proto->value5;
$socket0 = $item_proto->socket0;
$socket1 = $item_proto->socket1;
$socket2 = $item_proto->socket2;
$socket3 = $item_proto->socket3;
$socket4 = $item_proto->socket4;
$socket5 = $item_proto->socket5;
$refine_vnum = $item_proto->refined_vnum;
$refine_set = $item_proto->refine_set;
$magic_pct = $item_proto->magic_pct;
$specular = $item_proto->specular;
$socket_pct = $item_proto->socket_pct;
?><p><Item
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
subtype="<?php echo($subtype) ?>"
weight="<?php echo($weight) ?>"
size="<?php echo($size) ?>"
antiflag="<?php echo($antiflag) ?>"
flag="<?php echo($flag) ?>"
wearflag="<?php echo($wearflag) ?>"
immuneflag="<?php echo($imuneflag) ?>"
gold="<?php echo($gold) ?>"
buy_price="<?php echo($buy_price) ?>"
limittype0="<?php echo($limittype0) ?>"
limitvalue0="<?php echo($limitvalue0) ?>"
limittype1="<?php echo($limittype1) ?>"
limitvalue1="<?php echo($limitvalue1) ?>"
applytype0="<?php echo($applytype0) ?>"
applyvalue0="<?php echo($applyvalue0) ?>"
applytype1="<?php echo($applytype1) ?>"
applyvalue1="<?php echo($applyvalue1) ?>"
applytype2="<?php echo($applytype2) ?>"
applyvalue2="<?php echo($applyvalue2) ?>"
value0="<?php echo($value0) ?>"
value1="<?php echo($value1) ?>"
value2="<?php echo($value2) ?>"
value3="<?php echo($value3) ?>"
value4="<?php echo($value4) ?>"
value5="<?php echo($value5) ?>"
socket0="<?php echo($socket0) ?>"
socket1="<?php echo($socket1) ?>"
socket2="<?php echo($socket2) ?>"
socket3="<?php echo($socket3) ?>"
socket4="<?php echo($socket4) ?>"
socket5="<?php echo($socket5) ?>"
refine_vnum="<?php echo($refine_vnum) ?>"
refine_set="<?php echo($refine_set) ?>"
magic_pct="<?php echo($magic_pct) ?>"
specular="<?php echo($specular) ?>"
socket_pct="<?php echo($socket_pct) ?>"
/><p><?php
}
?>
</html>
mob_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.mob_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($mob_proto = mysql_fetch_object($sqlQry))
{
$vnum = $mob_proto->vnum;
$name = $mob_proto->name;
$locale_name = $mob_proto->gb2312name;
$type = $mob_proto->type;
$rank = $mob_proto->rank;
$battle_type = $mob_proto->battle_type;
$level = $mob_proto->level;
$event_type = $mob_proto->on_click;
$mob_color = $mob_proto->mob_color;
?><p><Mob
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
rank="<?php echo($rank) ?>"
battle_type="<?php echo($battle_type) ?>"
level="<?php echo($level) ?>"
event_type="<?php echo($event_type) ?>"
mob_color="<?php echo($mob_color) ?>"
/><p><?php
}
?>
</html>
Zwar gibt es das schon als Anwendung, nur hat diese leider viele Bugs, sodass man die daraus bekomme .xml erst korrigieren musst/e. Dazu gab es das nur für die item_proto 
Für die, die nicht wissen was man mit dem Script macht:
1. Speichert das Script in eine .php Datei.
2. Passt die Verbindungsdaten an.
3. Holt euch XAMPP oder Sonstiges
4. Haut die .php Datei in den "htdocs" Ordner.
5. Startet XAMPP und und tippt in eueren Browser in die Adressleiste: "localhost/*dateiname*.php ein
6. Tada Was man damit dann macht muss ich denke ich mal nicht erklären
PS: Die Spalten dazwischen sind unwichtig. Der Archiver ignoriert sie. Also keine Sorgen darum machen
Für ein Thanks würde ich mich freuen, ist aber kein muss
Und wer das als seins ausgibt ... soll sich einen Keks kaufen und daran ersticken <.<
Grüße,
XxMeuchelxX
|
|
|
|
02/10/2012, 19:43
|
#2
|
elite*gold: 0
Join Date: Sep 2011
Posts: 1,218
Received Thanks: 706
|
Nice danke das du es mit uns Teilst ^_^
|
|
|
|
|
02/10/2012, 19:50
|
#3
|
elite*gold: 205
Join Date: Jun 2010
Posts: 5,334
Received Thanks: 2,510
|
und was ist fail?
Quote:
|
<Item vnum="1" name="'µ·²Ù·¯¹Ì '" gb2312name="" type="9" subtype="0" weight="0" size="1" antiflag="0" flag="0" wearflag="0" immuneflag="" gold="0" buy_price="100" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="0" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="-1" socket1="-1" socket2="-1" socket3="-1" socket4="-1" socket5="-1" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
|
geht bis zum ende weiter das gb2312 name fehlt
mob_proto schaut komplett so aus...
Quote:
<Mob vnum="101" name="'??'" gb2312name="" type="0" rank="0" battle_type="0" level="1" event_type="0" mob_color="0" />
<Mob vnum="102" name="'??'" gb2312name="" type="0" rank="0" battle_type="0" level="3" event_type="0" mob_color="0" />
|
|
|
|
|
|
02/10/2012, 19:51
|
#4
|
elite*gold: 40
Join Date: Apr 2010
Posts: 626
Received Thanks: 289
|
ich verstehe nicht, was es bringen soll, wenn man ne XML davon hat ?
|
|
|
|
|
02/10/2012, 19:53
|
#5
|
elite*gold: 205
Join Date: Jun 2010
Posts: 5,334
Received Thanks: 2,510
|
Quote:
Originally Posted by Freaqiichen
ich verstehe nicht, was es bringen soll, wenn man ne XML davon hat ?
|
die xml kannste dann packen XD und in den clienten einfügen
somit stimmen dann serverside und clientside item_proto und mob_proto überein
|
|
|
|
|
02/10/2012, 20:38
|
#6
|
elite*gold: 0
Join Date: Dec 2009
Posts: 105
Received Thanks: 124
|
Quote:
Originally Posted by lfcmaus
und was ist fail?
geht bis zum ende weiter das gb2312 name fehlt
mob_proto schaut komplett so aus...
|
Kann es sein, dass du in der DB anstatt "locale_name" "gb2312name" hast?
Wenn ja, dann:
item_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.item_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($item_proto = mysql_fetch_object($sqlQry))
{
$vnum = $item_proto->vnum;
$name = $item_proto->name;
$locale_name = $item_proto->gb2312name;
$type = $item_proto->type;
$subtype = $item_proto->subtype;
$weight = $item_proto->weight;
$size = $item_proto->size;
$antiflag = $item_proto->antiflag;
$flag = $item_proto->flag;
$wearflag = $item_proto->wearflag;
$immuneflag = $item_proto->imuneflag;
$gold = $item_proto->gold;
$buy_price = $item_proto->shop_buy_price;
$limittype0 = $item_proto->limittype0;
$limitvalue0 = $item_proto->limitvalue0;
$limittype1 = $item_proto->limittype1;
$limitvalue1 = $item_proto->limitvalue1;
$applytype0 = $item_proto->applytype0;
$applyvalue0 = $item_proto->applyvalue0;
$applytype1 = $item_proto->applytype1;
$applyvalue1 = $item_proto->applyvalue1;
$applytype2 = $item_proto->applytype2;
$applyvalue2 = $item_proto->applyvalue2;
$value0 = $item_proto->value0;
$value1 = $item_proto->value1;
$value2 = $item_proto->value2;
$value3 = $item_proto->value3;
$value4 = $item_proto->value4;
$value5 = $item_proto->value5;
$socket0 = $item_proto->socket0;
$socket1 = $item_proto->socket1;
$socket2 = $item_proto->socket2;
$socket3 = $item_proto->socket3;
$socket4 = $item_proto->socket4;
$socket5 = $item_proto->socket5;
$refine_vnum = $item_proto->refined_vnum;
$refine_set = $item_proto->refine_set;
$magic_pct = $item_proto->magic_pct;
$specular = $item_proto->specular;
$socket_pct = $item_proto->socket_pct;
?><p><Item
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
subtype="<?php echo($subtype) ?>"
weight="<?php echo($weight) ?>"
size="<?php echo($size) ?>"
antiflag="<?php echo($antiflag) ?>"
flag="<?php echo($flag) ?>"
wearflag="<?php echo($wearflag) ?>"
immuneflag="<?php echo($imuneflag) ?>"
gold="<?php echo($gold) ?>"
buy_price="<?php echo($buy_price) ?>"
limittype0="<?php echo($limittype0) ?>"
limitvalue0="<?php echo($limitvalue0) ?>"
limittype1="<?php echo($limittype1) ?>"
limitvalue1="<?php echo($limitvalue1) ?>"
applytype0="<?php echo($applytype0) ?>"
applyvalue0="<?php echo($applyvalue0) ?>"
applytype1="<?php echo($applytype1) ?>"
applyvalue1="<?php echo($applyvalue1) ?>"
applytype2="<?php echo($applytype2) ?>"
applyvalue2="<?php echo($applyvalue2) ?>"
value0="<?php echo($value0) ?>"
value1="<?php echo($value1) ?>"
value2="<?php echo($value2) ?>"
value3="<?php echo($value3) ?>"
value4="<?php echo($value4) ?>"
value5="<?php echo($value5) ?>"
socket0="<?php echo($socket0) ?>"
socket1="<?php echo($socket1) ?>"
socket2="<?php echo($socket2) ?>"
socket3="<?php echo($socket3) ?>"
socket4="<?php echo($socket4) ?>"
socket5="<?php echo($socket5) ?>"
refine_vnum="<?php echo($refine_vnum) ?>"
refine_set="<?php echo($refine_set) ?>"
magic_pct="<?php echo($magic_pct) ?>"
specular="<?php echo($specular) ?>"
socket_pct="<?php echo($socket_pct) ?>"
/><p><?php
}
?>
</html>
mob_proto:
PHP Code:
<html>
<?PHP
$sqlServ = mysql_connect('adresse', 'login', 'passwort');
$sqlCmd = "SELECT * FROM player.mob_proto";
$sqlQry = mysql_query($sqlCmd,$sqlServ);
while($mob_proto = mysql_fetch_object($sqlQry))
{
$vnum = $mob_proto->vnum;
$name = $mob_proto->name;
$locale_name = $mob_proto->gb2312name;
$type = $mob_proto->type;
$rank = $mob_proto->rank;
$battle_type = $mob_proto->battle_type;
$level = $mob_proto->level;
$event_type = $mob_proto->on_click;
$mob_color = $mob_proto->mob_color;
?><p><Mob
vnum="<?php echo($vnum) ?>"
name="'<?php echo($name) ?>'"
gb2312name="<?php echo($locale_name) ?>"
type="<?php echo($type) ?>"
rank="<?php echo($rank) ?>"
battle_type="<?php echo($battle_type) ?>"
level="<?php echo($level) ?>"
event_type="<?php echo($event_type) ?>"
mob_color="<?php echo($mob_color) ?>"
/><p><?php
}
?>
</html>
EDIT: Hab es in meinen ersten Post eingefügt
|
|
|
|
|
02/10/2012, 21:15
|
#7
|
elite*gold: 0
Join Date: Aug 2009
Posts: 962
Received Thanks: 97
|
bitre andersrum
|
|
|
|
|
02/10/2012, 21:47
|
#8
|
elite*gold: 0
Join Date: Dec 2009
Posts: 105
Received Thanks: 124
|
Quote:
Originally Posted by lautlosertot
bitre andersrum |
Das ist bisschen komplizierter
Mal schauen ...
|
|
|
|
|
06/14/2012, 16:09
|
#9
|
elite*gold: 0
Join Date: Oct 2009
Posts: 382
Received Thanks: 161
|
thank you dude
|
|
|
|
 |
Similar Threads
|
[Release] CFlyFF bin Converter
12/25/2013 - Flyff PServer Guides & Releases - 24 Replies
So Leute ....
Ich und ein paar andere ...
ich weiss nur von ein paar Amerikanern ...
sind an dieses Tool gekommen ....
Da sich einige Hart fühlen ...
Release ich es ...
Ich denke das Ding wurde anderswo eh schon Released .-..
|
[Release]Item_Proto Converter
03/16/2013 - Metin2 PServer Guides & Strategies - 43 Replies
Hi guys, i'm portuguese and my english isn't very good, so sorry for the english!!!
This is my first topic and sorry for anything, let's go to the release.
This is one program to convert the item_proto of the client for the item_proto of the navicat :) is good, i know, very people are searched for this program much time and now the program is there :). The program as translated to portuguese by me, so sorry for the this.
Screens:
http://img220.imageshack.us/img220/8830/upload1.p ng
...
|
[Release]DDS-Converter
01/20/2011 - Metin2 PServer Guides & Strategies - 22 Replies
Hey ich habe heute mal mein Desktop aufgeräumt :P und da fand ich plötzlich eine komische Datei. Aufeinmal stellte sich raus das es ein DDS-Converter war. Er wandelt DDS Dateien in jpg und png dateien um.
Da das für manche Client´s nützlich ist dachte ich ich stell es mal hier rein.
Virustotal Screen
http://img3.fotos-hochladen.net/uploads/virrustot al0t16k9zq.png
Screen vom Programm
http://img3.fotos-hochladen.net/uploads/programmn gw8demb.png
MfG Fun-Zocker
|
[RELEASE] DDS converter
08/18/2009 - EO PServer Guides & Releases - 9 Replies
Well, because this is a tool, i post it here and not on another section :bandit:
People were complaining they cant open or edit a dds file..
This tool, can convert the dds file to jpg,png,bmp,tga
and it can convert "to" dds :handsdown:
|
All times are GMT +1. The time now is 22:46.
|
|
![[Release].php SQL zu XML Converter](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-php-sql-zu-xml-converter_ltr.gif){kind=small}
