Hallo Community kann mir einer erklären wie ich hier für eine Query für Navicat anpassen zb . INSERT INTO ....
PHP Code:
<Item vnum="71123" name="'¼ö·æºñ´Ã'" gb2312name="Drachenschuppe" type="5" subtype="0" weight="0" size="1" antiflag="0" flag="4" wearflag="0" immuneflag="0" gold="0" buy_price="0" 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="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71124" name="'¹é»çÀÚÀÌ¿ë±Ç'" gb2312name="Weißer Löwe" type="16" subtype="2" weight="0" size="1" antiflag="74112" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="2400" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71125" name="'ÈæÀú½ÅÀÌ¿ë±Ç'" gb2312name="Kriegskeiler-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="20" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71126" name="'Èæ»ê°ß½ÅÀÌ¿ë±Ç'" gb2312name="Streitwolf-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="20" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71127" name="'ÈæÅõÁö¹üÀÌ¿ë±Ç'" gb2312name="Sturmtiger-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="74112" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="20" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71128" name="'Èæ»çÀÚÀÌ¿ë±Ç'" gb2312name="Schlachtenlöwen-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="74112" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="1" limitvalue0="20" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71129" name="'¼ö·æ¹ßÅé'" gb2312name="Drachenkralle" type="5" subtype="0" weight="0" size="1" antiflag="0" flag="4" wearflag="0" immuneflag="0" gold="0" buy_price="0" 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="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71130" name="'ÅëÇàÁõ¸í¼*'" gb2312name="Passierschein" type="5" subtype="0" weight="0" size="1" antiflag="0" flag="4" wearflag="0" immuneflag="0" gold="0" buy_price="0" 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="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71131" name="'È渶¼Òȯ±Ç'" gb2312name="Rappen-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="106880" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="30" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71132" name="'È渶¼Òȯ±Ç'" gb2312name="Rappen-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="106880" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="60" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71133" name="'È渶¼Òȯ±Ç'" gb2312name="Rappen-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="106880" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="120" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71134" name="'È渶¼Òȯ±Ç'" gb2312name="Rappen-Siegel" type="16" subtype="2" weight="0" size="1" antiflag="106880" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="180" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71135" name="'Ãʽ´ÞÀÇ ¹ÝÁö'" gb2312name="Halbmondring" type="16" subtype="0" weight="0" size="1" antiflag="106880" flag="0" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="7" 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="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71136" name="'ÇÒ·ÎÀ© »çÅÁ'" gb2312name="Lolli" type="16" subtype="0" weight="0" size="1" antiflag="106624" flag="0" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="7" 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="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71137" name="'ûÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel(blau)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71138" name="'ÁøÀûÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel (rot)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71139" name="'ȲÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel(gold)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71140" name="'³ìÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel(grün)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71141" name="'ÈæÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel(grau)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
<Item vnum="71142" name="'¹éÀÇÀü°©¿ø¼Òȯ±Ç'" gb2312name="Königstiger-Siegel(weiß)" type="16" subtype="2" weight="0" size="1" antiflag="33024" flag="9216" wearflag="128" immuneflag="0" gold="0" buy_price="0" limittype0="0" limitvalue0="0" limittype1="0" limitvalue1="0" applytype0="0" applyvalue0="0" applytype1="0" applyvalue1="0" applytype2="0" applyvalue2="0" value0="28800" value1="0" value2="0" value3="0" value4="0" value5="0" socket0="0" socket1="64992" socket2="127" socket3="64976" socket4="21631" socket5="4855" refine_vnum="0" refine_set="0" magic_pct="0" specular="0" socket_pct="0" />
