Danke für die superschnelle Antwort ...habe das ausgeführt und nun kommt das hier....
UPDATE accounts SET acctid='14', name='`7Sc`vha`Vtt`ven`7di`veb`Vin `vT`7í`vr`Va ', sex='1', specialty='3', darkarts='0', magic='0', thievery='0', experience='0', charisma='0', seenlover='0', gold='0', weapon='Fists', armor='T-Shirt', seenmaster='0', level='15', defence='1', attack='1', alive='1', goldinbank='60000', marriedto='0', playerkills='1', spirits='0', laston='2007-05-27 12:39:24', hitpoints='10', maxhitpoints='10', gems='0', weaponvalue='0', armorvalue='0', location='32', turns='31', title='`7Sc`vha`Vtt`ven`7di`veb`Vin', password='d6b904031a80e4c15044733ce3efbf30', darkartuses='0', magicuses='0', thieveryuses='1', badguy='', allowednavs='a:14:{s:23:\"chapel.php?op=eintreten\";b:1;s:35:\"chapel.php?op=eintreten&comscroll=0\";b:1;s:36:\"chapel.php?op=merrylist&c=455-123924\";b:1;s:37:\"chapel.php?op=hochzeiten&c=455-123924\";b:1;s:40:\"chapel.php?op=klingelbeutel&c=455-123924\";b:1;s:46:\"kindersystem-chapel.php?op=taufen&c=455-123924\";b:1;s:32:\"chapel.php?op=beten&c=455-123924\";b:1;s:33:\"chapel.php?op=beicht&c=455-123924\";b:1;s:28:\"beichtstuhl.php?c=455-123924\";b:1;s:35:\"chapel.php?op=priester&c=455-123924\";b:1;s:33:\"chapel.php?op=putzen&c=455-123924\";b:1;s:23:\"chapel.php?c=455-123924\";b:1;s:24:\"gardens.php?c=455-123924\";b:1;s:16:\"viewpetition.php\";b:1;}', output='
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//DE\">
<html>
<head>
<title>Kapelle von Valandor</title>
<link href=\'templates/yarbrough.css\' rel=\'stylesheet\' type=\'text/css\'>
<script language=\"JavaScript\" type=\"text/javascript\">
<!--
document.onkeypress=keyevent;
function keyevent(e){
var c;
var target;
var altKey;
var ctrlKey;
if (window.event != null) {
c=String.fromCharCode(window.event.keyCode).toUpperCase();
altKey=window.event.altKey;
ctrlKey=window.event.ctrlKey;
}else{
c=String.fromCharCode(e.charCode).toUpperCase();
altKey=e.altKey;
ctrlKey=e.ctrlKey;
}
if (window.event != null)
target=window.event.srcElement;
else
target=e.originalTarget;
if (target.nodeName.toUpperCase()==\'INPUT\' || target.nodeName.toUpperCase()==\'TEXTAREA\' || altKey || ctrlKey){
}else{
if (c == \'P\') { window.location=\'chapel.php?op=merrylist&c=455-123924\';; return false; }
if (c == \'B\') { window.location=\'chapel.php?op=hochzeiten&c=455-123924\';; return false; }
if (c == \'K\') { window.location=\'chapel.php?op=klingelbeutel&c=455-123924\';; return false; }
if (c == \'T\') { window.location=\'kindersystem-chapel.php?op=taufen&c=455-123924\';; return false; }
if (c == \'E\') { window.location=\'chapel.php?op=beten&c=455-123924\';; return false; }
if (c == \'I\') { window.location=\'chapel.php?op=beicht&c=455-123924\';; return false; }
if (c == \'D\') { window.location=\'beichtstuhl.php?c=455-123924\';; return false; }
if (c == \'S\') { window.location=\'chapel.php?op=priester&c=455-123924\';; return false; }
if (c == \'V\') { window.location=\'chapel.php?op=putzen&c=455-123924\';; return false; }
if (c == \'A\') { window.location=\'chapel.php?c=455-123924\';; return false; }
if (c == \'Z\') { window.location=\'gardens.php?c=455-123924\';; return false; }
}
}
//-->
</script> <script type=\"text/javascript\">
<!--
function appoencode(data) {
var Fundstelle = -1;
var tag = \'\';
var append = \'\';
var output = \'<br />Vorschau: \';
var openspan = false;
while ((Fundstelle = data.search(/`/)) != -1) {
tag = data.substr(Fundstelle+1, 1);
append = data.substr(0,Fundstelle);
append = append.replace(/</,\'<\');
append = append.replace(/>/,\'>\');
output = output+ append;
if (data.length >= Fundstelle+2) data = data.substring(Fundstelle+2,data.length);
else data = \'\';
switch (tag) {
case \"0\":
if (openspan) output= output+\"</span>\";
openspan = false;
break;
case \"1\":
if (openspan) output= output+\"</span>\"; else openspan = true;
output= output+\"<span class=\'colDkBlue\'>\";
break;
case \"2\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkGreen\'>\";
break;
case \"3\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkCyan\'>\";
break;
case \"4\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkRed\'>\";
break;
case \"5\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkMagenta\'>\";
break;
case \"6\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkYellow\'>\";
break;
case \"7\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkWhite\'>\";
break;
case \"8\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLime\'>\";
break;
case \"9\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colBlue\'>\";
break;
case \"!\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtBlue\'>\";
break;
case \"@\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtGreen\'>\";
break;
case \"#\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtCyan\'>\";
break;
case \"$\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtRed\'>\";
break;
case \"%\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtMagenta\'>\";
break;
case \"^\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtYellow\'>\";
break;
case \"&\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtWhite\'>\";
break;
case \"~\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colBlack\'>\";
break;
case \"Q\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkOrange\'>\";
break;
case \"q\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colOrange\'>\";
break;
case \"r\":
case \"R\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colRose\'>\";
break;
case \"V\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colBlueViolet\'>\";
break;
case \"v\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'coliceviolet\'>\";
break;
case \"g\":
case \"G\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colXLtGreen\'>\";
break;
case \"T\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colDkBrown\'>\";
break;
case \"t\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colLtBrown\'>\";
break;
case \"?\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colWhiteBlack\'>\";
break;
case \"*\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colBack\'>\";
break;
case \"A\":
case \"a\":
if (openspan) output= output+\"</span>\"; else openspan=true;
output= output+\"<span class=\'colAttention\'>\";
break;
case \"`\":
output= output+\"`\";
break;
default:
output= output+\"`\"+tag;
}
}
output += data;
if (openspan) output += \'</span>\';
return output;
}
//-->
</script>
</head>
<body bgcolor=\'#000000\' text=\'#CCCCCC\'>
<table border=\'0\' cellpadding=4 cellspacing=0 width=\'100%\'>
<tr>
<td colspan=2 class=\'pageheader\' valign=\'top\'> <img src=\'images/title.gif\' align=\'right\'><span class=\'pagetitle\'><br>
Kapelle von Valandor </span></td>
</tr>
<tr>
<td width=190 bgcolor=\'#433828\' valign=\'top\' align=\'center\'> <img src=\'images/uscroll.GIF\' width=\'182\' height=\'11\' alt=\'\'>
<table cellspacing=\'0\' cellpadding=\'0\' class=\'nav\'>
<tr>
<td><a href=\"chapel.php?op=merrylist&c=455-123924\" accesskey=\"P\" class=\'nav\' ><span class=\'navhi\'>P</span>aare mit Aufgebot<br></a>
<a href=\"chapel.php?op=hochzeiten&c=455-123924\" accesskey=\"B\" class=\'nav\' ><span class=\'navhi\'>B</span>isherige Hochzeiten<br></a>
<a href=\"chapel.php?op=klingelbeutel&c=455-123924\" accesskey=\"K\" class=\'nav\' ><span class=\'navhi\'>K</span>lingelbeutel<br></a>
<a href=\"kindersystem-chapel.php?op=taufen&c=455-123924\" accesskey=\"T\" class=\'nav\' ><span class=\'navhi\'>T</span>aufen<br></a>
<a href=\"chapel.php?op=beten&c=455-123924\" accesskey=\"e\" class=\'nav\' >B<span class=\'navhi\'>e</span>ten<br></a>
<a href=\"chapel.php?op=beicht&c=455-123924\" accesskey=\"i\" class=\'nav\' >Be<span class=\'navhi\'>i</span>chten<br></a>
<a href=\"beichtstuhl.php?c=455-123924\" accesskey=\"D\" class=\'nav\' ><span class=\'navhi\'>D</span>er Beichtstuhl<br></a>
<a href=\"chapel.php?op=priester&c=455-123924\" accesskey=\"S\" class=\'nav\' ><span class=\'navhi\'>S</span>chrein des Priesters<br></a>
<a href=\"chapel.php?op=putzen&c=455-123924\" accesskey=\"V\" class=\'nav\' >Aufräumen - <span class=\'navhi\'>V</span>ORSICHT<br></a>
<a href=\"chapel.php?c=455-123924\" accesskey=\"A\" class=\'nav\' ><span class=\'navhi\'>A</span>ktualisieren<br></a>
<a href=\"gardens.php?c=455-123924\" accesskey=\"Z\" class=\'nav\' ><span class=\'navhi\'>Z</span>urück zum Garten<br></a>
</td>
</tr>
</table>
<img src=\'images/lscroll.GIF\' width=\'182\' height=\'11\'> <br>
<a href=\'motd.php\' target=\'_blank\' onClick=\"window.open(\'motd.php\',\'motdphp\',\'scrollbars=yes,resizable=yes,width=550,height=300\');return false;\" class=\'motd\'><b>*Neuigkeiten*</b></a> <br>
<a href=\'mail.php\' target=\'_blank\' onClick=\"window.open(\'mail.php\',\'mailphp\',\'scrollbars=yes,resizable=yes,width=550,height=300\');return false;\" class=\'motd\'>Ye Olde Mail: 0 neu, 1 alt</a> <br>
<a href=\'petition.php\' onClick=\"window.open(\'petition.php\',\'petitionphp\',\'scrollbars=yes,resizable=yes,width=550,height=300\');return false;\" target=\'_blank\' align=\'right\' class=\'motd\'>Hilfe anfordern</a> <br>
<a href=\'http://valandor.iphpbb.com\' target=\'_blank\' class=\'motd\'>~Valandors Forum~</a> <br>
<a href=\'chat.php\' target=\'_blank\' class=\'motd\' onClick=\"window.open(\'chat.php\',\'chatphp\',\'scrollbars=yes,resizable=yes,width=550,height=300\');return false;\">Chat</a> </td>
<td width=\'100%\' rowspan=2 valign=\'top\' bgcolor=\'#352D20\'><table align=\'right\' border=\'0\'><tr><td><table align=\"center\"><tr><td><form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\" target=\"_blank\">
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\">
<input type=\"hidden\" name=\"business\" value=\"nahdude81@hotmail.com\">
<input type=\"hidden\" name=\"item_name\" value=\"Legend of the Green Dragon Author Donation from Schattendiebin Tíra \">
<input type=\"hidden\" name=\"item_number\" value=\"Tíra:www.valandor.de//chapel.php?op=eintreten\">
<input type=\"hidden\" name=\"no_shipping\" value=\"1\">
<input type=\"hidden\" name=\"cn\" value=\"Your Character Name\">
<input type=\"hidden\" name=\"cs\" value=\"1\">
<input type=\"hidden\" name=\"currency_code\" value=\"USD\">
<input type=\"hidden\" name=\"tax\" value=\"0\">
<input type=\"image\" src=\"images/paypal1.gif\" border=\"0\" name=\"submit\" alt=\"Donate!\">
</form></td></tr></table></td></tr></table>
<table border=0><tr><td valign=\'top\'></td><td valign=\'top\'>
<br />
Du betrittst das imposante und majestetische Gebäude, das weithin bekannt ist als die Kapelle von Valandor.
Wie immer bist Du fasziniert von der wunderschönen Einrichtung, den Ornamenten in der Decke, den glänzenden Kronleuchtern und
der riesigen Orgel in der Ecke.<br />
Möchtest Du nicht auch langsam mal hier stehen und heiraten?
</td></tr></table>
<br />
<br />
Leise hörst Du die Anwesenden miteinander flüstern:<br />
<br />
<br />
<br />
Hier ist niemand ausser dir.<br />
<br />
<form action=\"chapel.php?op=eintreten\" method=\'POST\'><span style=\'color: #00FF00;\'>Flüster zu den Anwesenden<br />
<input name=\'insertcommentary[Kapelle]\' size=\'40\' maxlength=\'4981\' onkeyup=\"document.getElementById(\'chatpreview\').innerHTML = appoencode(this.value);\"><input type=\'hidden\' name=\'talkline\' value=\'flüstert\'><input type=\'hidden\' name=\'section\' value=\'Kapelle\'><input type=\'submit\' class=\'button\' value=\'Hinzufügen\'><span id=\'chatpreview\'></span><br />
</span><br />
</form>
<a href=\"chapel.php?op=eintreten&comscroll=0\">Aktualisieren</a>
<table border=\'0\' cellpadding=\'5\' cellspacing=\'0\' align=\'right\'><tr><td><b><a href=\'viewpetition.php\'>Anfragen</a>:</b> 0 Ungelesen, 0 Gelesen, 0 Geschlossen.</td></tr></table>
</td>
</tr>
<tr>
<td width=\'190\' valign=\'top\' bgcolor=\'#433828\'><img src=\'images/uscroll.GIF\' width=\'182\' height=\'11\' alt=\'\'>
<table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' class=\'vitalinfo\'>
<tr>
<td> <table cellpadding=2 cellspacing=0 class=\'charinfo\' width=\'150\'>
<tr><td class=\'charhead\' colspan=\'2\'><b>Char Info</b></td></tr>
<tr><td class=\'charinfo\'><b>Name</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'><span style=\'color: #B0B0B0;\'>Sc</span><span style=\'color: #AABBEE;\'>ha</span><span style=\'color: #9A5BEE;\'>tt</span><span style=\'color: #AABBEE;\'>en</span><span style=\'color: #B0B0B0;\'>di</span><span style=\'color: #AABBEE;\'>eb</span><span style=\'color: #9A5BEE;\'>in </span><span style=\'color: #AABBEE;\'>T</span><span style=\'color: #B0B0B0;\'>í</span><span style=\'color: #AABBEE;\'>r</span><span style=\'color: #9A5BEE;\'>a </td></tr>
<tr><td class=\'charinfo\'><b>ID</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'>14</td></tr>
<tr><td class=\'charinfo\'><b>RPG-Punkte</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'>523</td></tr>
<tr><td class=\'charinfo\'><b>Runden</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'>31</td></tr>
<tr><td class=\'charinfo\'><b>Charme</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'>20</td></tr>
<tr><td class=\'charinfo\'><b>Nächster Tag</b></td><td class=\'charinfo\'></span><span style=\'color: #FFFF00;\'>1h, 20m, 36s </td></tr>
</table>
</td>
</tr>
</table>
<img src=\'images/lscroll.GIF\' width=\'182\' height=\'11\'></td>
</tr>
<tr>
<td colspan=2 class=\'footer\'>
<table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' width=\'100%\' class=\'noborder\'>
<tr>
<td class=\'noborder\'>Copyright 2002-2003, Game: Eric Stevens, Design: Chris Yarbrough (Seitengenerierung: 0.02s, Schnitt: 0.08s; DB: 10 in 0.01s) </td>
<td align=\'right\' class=\'noborder\'><a href=\'source.php?url=/chapel.php\' target=\'_blank\'>Source</a></td>
</tr>
<tr class=\'noborder\'><td colspan=\'2\'>Version: 0.9.7+jt ext (GER)</td></tr>
</table>
</td>
</tr>
</table>
</body>
</html>
', loggedin='1', resurrections='2', superuser='3', weapondmg='0', armordef='0', age='316', charm='20', specialinc='', specialmisc='', login='Tíra', slainby='', lastmotd='2007-05-27 10:58:44', playerfights='3', lasthit='2007-05-27 12:00:21', seendragon='0', dragonkills='0', drunkenness='0', locked='0', jailtime='0', restorepage='chapel.php?op=eintreten', seenbard='0', hashorse='0', petid='0', petfeed='0000-00-00 00:00:00', bufflist='a:0:{}', gentime='1596.19715734', gentimecount='19989', lastip='82.82.143.178', uniqueid='5ae42c819af463109f9b6b0a596bba91', dragonpoints='a:0:{}', boughtroomtoday='0', emailaddress='info@valandor.de', emailvalidation='', killedin='', sentnotice='0', prefs='a:11:{s:11:\"emailonmail\";s:1:\"0\";s:10:\"systemmail\";s:1:\"0\";s:10:\"dirtyemail\";s:1:\"0\";s:8:\"nosounds\";s:1:\"0\";s:8:\"textfeld\";s:1:\"0\";s:16:\"commenttalkcolor\";s:0:\"\";s:17:\"commentemotecolor\";s:0:\"\";s:12:\"chatvorschau\";s:1:\"0\";s:10:\"editbutton\";s:1:\"0\";s:5:\"xmote\";s:1:\"0\";s:10:\"timestamps\";s:1:\"1\";}', pvpflag='0000-00-00 00:00:00', transferredtoday='0', hauntpoints='0', soulpoints='125', gravefights='10', hauntedby='', deathpower='0', gensize='652588434', recentcomments='2007-05-27 10:18:51', donation='3523', donationspent='3000', donationconfig='a:1:{s:12:\"forestfights\";a:0:{}}', referer='0', refererawarded='0', bio='`n`n`c<a href=\"http://imageshack.us\"><img src=\"http://img179.imageshack.us/img179/6956/schrifttira2ih5.gif\" border=\"0\" alt=\"Image Hosted by ImageShack.us\" /></a>`n
dann wieder meine bio...
und ganz unten :
Unknown column 'whereuser' in 'field list'
|
:)