anpera.net https://anpera.homeip.net/phpbb3/ |
|
SQL Hilfe https://anpera.homeip.net/phpbb3/viewtopic.php?f=34&t=3115 |
Seite 1 von 1 |
Autor: | Öhm, der Unternerd [ Fr 17 Nov, 2006 19:15 ] |
Betreff des Beitrags: | SQL Hilfe |
Hallo nocheinmal, ich würde mich freuen wenn mir noch einmal weitergeholfen werden könnte ![]() Ich hab vor kurzem den Baum des Todes und die Hölle in mein LogD integriert und wurde nach kurzer Zeit von einem User darauf hingewiesen das eine Fehlermeldung auftaucht wenn man eine Frucht von Baum des Todes nimmt. Die Fehlermeldung lautet wie folgt: $this->bbcode_second_pass_code('', ' UPDATE accounts SET acctid='9', name='Bauernmädchen Mephis', sex='1', specialty='3', darkarts='0', magic='0', thievery='1', experience='586', charisma='0', seenlover='0', gold='0', weapon='Harke', armor='Rüschenunterhosen', seenmaster='0', level='1', defence='2', attack='2', alive='', goldinbank='478', marriedto='0', playerkills='1', spirits='-6', laston='2006-11-17 13:01:26', hitpoints='0', maxhitpoints='10', gems='3', weaponvalue='48', armorvalue='48', location='0', turns='10', title='Bauernmädchen', password='f0cacc017670f791809b7bbd352f4d89', darkartuses='0', magicuses='0', thieveryuses='1', badguy='', allowednavs='a:1:{s:23:\"thehell.php?c=92-130126\";b:1;}', output=' <!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//DE\"> <html> <head> <title>Der Baum des Todes</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 == \'Z\') { window.location=\'thehell.php?c=92-130126\';; return false; } } } //--> </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> Der Baum des Todes </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=\"thehell.php?c=92-130126\" accesskey=\"Z\" class=\'nav\' ><span class=\'navhi\'>Z</span>urück zur Hölle<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>MoTD</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, 0 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://www.blacknight-logd.de.vu\' target=\'_blank\' class=\'motd\'>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 Bauernmädchen Mephis\"> <input type=\"hidden\" name=\"item_number\" value=\"Mephis:www.jesper-lerch.de//logd/treeofdeath.php?op=pickfruit&c=91-130124\"> <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> <img src=\'images/uscroll.GIF\' width=\'195\' height=\'11\' alt=\'\'><br> <table border=\'0\' cellpadding=\'0\' cellspacing=\'0\' class=\'vitalinfo\'> <tr><td><tr><td><b><span class=\'colDkYellow\'> Hier anwesend:</span></b></td></tr><tr><td> <a href=\'mail.php?op=write&to=Mephis\' target=\'_blank\' onClick=\"window.open(\'mail.php?op=write&to=Mephis\',\'mailphpopwritetoMephis\',\'scrollbars=yes,resizable=yes,width=550,height=300\');return false;\"><img src=\'images/newscroll.GIF\' width=\'16\' height=\'16\' alt=\'Mail schreiben\' border=\'0\'></a> Bauernmädchen Mephis</td></tr></td></tr></table> <img src=\'images/lscroll.GIF\' width=\'195\' height=\'11\'></td></tr></table> <div align=\'center\'> <span class=\'colLtRed\'> Der Baum des Todes</div><br> <br> <br> <br> </span><span class=\'colBlue\'>Du versuchst etwas vom </span><span class=\'colLtRed\'> Baum des Todes </span><span class=\'colBlue\'>zu nehmen und findest....<br> <br> </span><span class=\'colLtYellow\'> einen kleinen Beutel, der sich in einem Ast verschlungen hat.<br> <br> Als du den Beutel öffnest funkelt dir ein </span><span class=\'colLtRed\'> Edelstein </span><span class=\'colLtYellow\'> entgegen!! </font> </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>Vital Info</b></td></tr> <tr><td class=\'charinfo\'><b>Name</b></td><td class=\'charinfo\'><span class=\'colLtYellow\'>Bauernmädchen Mephis</td></tr> <tr><td class=\'charinfo\'><b>Seelenpunkte</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>55<table cellspacing=\"0\" style=\"border: solid 1px #000000\" width=\"70\" height=\"5\"><tr><td width=\"100%\" bgcolor=\"#00AA00\"></td><td width=\"0%\" bgcolor=\"#00AA00\"></td></tr></table></td></tr> <tr><td class=\'charinfo\'><b>Foltern</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>0</td></tr> <tr><td class=\'charinfo\'><b>Stimmung</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'><b>TOT</b></td></tr> <tr><td class=\'charinfo\'><b>Level</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'><b>1</b></td></tr> <tr><td class=\'charinfo\'><b>Psyche</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>10</td></tr> <tr><td class=\'charinfo\'><b>Geist</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>10</td></tr> <tr><td class=\'charinfo\'><b>Edelsteine</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>3</td></tr> <tr><td class=\'charhead\' colspan=\'2\'><b>Weitere Infos</b></td></tr> <tr><td class=\'charinfo\'><b>Gold</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>0</td></tr> <tr><td class=\'charinfo\'><b>Erfahrung</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'><font face=\"verdana\" size=1>586<br><table cellspacing=\"0\" style=\"border: solid 1px #000000\" width=\"70\" height=\"5\"><tr><td width=\"586%\" bgcolor=\"#00AA00\"></td><td width=\"-486%\" bgcolor=\"#00AA00\"></td></tr></table></font></td></tr> <tr><td class=\'charinfo\'><b>Waffe</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>Harke</td></tr> <tr><td class=\'charinfo\'><b>Rüstung</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>Rüschenunterhosen</td></tr> <tr><td class=\'charinfo\'><b>Nächster Tag</b></td><td class=\'charinfo\'></span><span class=\'colLtYellow\'>0h, 58m, 34s </td></tr> <tr><td class=\'charinfo\' colspan=\'2\'><b>Aktionen:</b><br> <span class=\'colLtYellow\'>Keine</span></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.03s) </td> <td align=\'right\' class=\'noborder\'><a href=\'source.php?url=/logd/treeofdeath.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='8', superuser='0', weapondmg='1', armordef='1', age='11', charm='0', specialinc='', specialmisc='', login='Mephis', slainby='', lastmotd='2006-11-14 15:47:51', playerfights='3', lasthit='2006-11-17 13:00:43', seendragon='0', dragonkills='0', drunkenness='0', locked='0', jailtime='0', restorepage='treeofdeath.php?op=pickfruit&c=91-130124', seenbard='0', hashorse='5', bufflist='a:0:{}', gentime='31.4765915881', gentimecount='1191', lastip='87.123.248.0', uniqueid='19f2eb7dd91ab5d2092d0dccbe8e3a2c', dragonpoints='a:0:{}', boughtroomtoday='0', emailaddress='meike_bausch@web.de', emailvalidation='', killedin='', sentnotice='0', prefs='', pvpflag='0000-00-00 00:00:00', transferredtoday='0', hauntpoints='0', soulpoints='55', gravefights='0', hauntedby='', deathpower='84', gensize='13772888', recentcomments='2006-11-17 12:58:28', donation='14', donationspent='0', donationconfig='a:1:{s:12:\"forestfights\";a:0:{}}', referer='5', refererawarded='0', bio='', race='3', superuser2='0', banoverride='0', buffbackup='', biotime='0000-00-00 00:00:00', history='', bounty='0', amountouttoday='0', pk='0', dragonage='0', bestdragonage='0', lastwebvote='0000-00-00', bounties='0', ctitle='', usedouthouse='0', beta='0', avatar='', fedmount='0', gotfreeale='0', house='0', housekey='0', lottery='0', reputation='8', punch='27', witch='0', message='', msgdate='0000-00-00 00:00:00', battlepoints='0', seenAcademy='0', birthday='5.1.0000', hellwheel='0', room='0', roomid='0', deadtreepick='1' WHERE acctid = 9 Unknown column 'deadtreepick' in 'field list' ') Der Fehler scheint wohl in der allerletzten Zeile der Meldung zu stecken aber ich weiß nicht genau was zu tun ist in diesem Fall. Danke im Voraus Öhm, der Unternerd |
Autor: | Darkness [ Fr 17 Nov, 2006 19:18 ] |
Betreff des Beitrags: | |
$this->bbcode_second_pass_code('', 'Unknown column 'deadtreepick' in 'field list' ') kann es sein, dass du den sql-befehl vom "baum des todes" nicht ausgeführt hast? |
Autor: | -DoM [ Fr 17 Nov, 2006 19:33 ] |
Betreff des Beitrags: | |
$this->bbcode_second_pass_code('', ' ALTER TABLE accounts ADD deadtreepick TINYINT(1) NOT NULL default '0'; ') |
Autor: | Öhm, der Unternerd [ Fr 17 Nov, 2006 19:49 ] |
Betreff des Beitrags: | |
Stimmt, das habe ich nicht gemacht. Ich hab die beiden PHP Files in einem RAR Archiv runtergeladen und das erste mal "ganz ohne andere Hilfe" oder Anleitung eingebunden. Aber von diesem Befehl stand da auch nichts o_o Ich werds mal eben machen, vielen Dank! ![]() Gruß Öhm, der Unternerd |
Seite 1 von 1 | Alle Zeiten sind UTC + 1 Stunde |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |