Bei den News liegt es daran, dass du keine Sonderzeichen benutzen darfst. Also kein "'" undso.
Die User kann man doch ganz einfach in der Db bearbeiten?
CTRL + Q to Enable/Disable GoPhoto.it
CTRL + Q to Enable/Disable GoPhoto.it
liegt an der Datenbank !
Junge, die erzählen alle irgendein Dreck das liegt nicht an db oder an dem HK sondern an MySQL.
am besten du installierst MySQL neu oder noch besser alles auf dem Server neu.
P.S. bei mir gings gleich nach neuinstallation.
Have fun.
Nur MySQL, Server neuinstallieren sollte auch klappen.
Und funktioniert es nun?
Waegi , es liegt an der DB & MySQL
DB hat fehlende dateien oder so & das HK verarbeitet es net weil die MySQL wege fehlen.
Neue DB und dann geht die scheiße auch 
Hi Waegi,
dein Housekeeping tragt Sonderzeichen in die Tabelle 'Stafflogs' ein.
Ersetz mal die folgende News.php mit deiner und versuche es noch mal:
<?php
if($user_rank > 5){
if($hkzone !== true){ header("Location: index.php?throwBack=true"); exit; }
if(!session_is_registered(acp)){ header("Location: index.php?p=login"); exit; }
$pagename = "News bearbeiten";
$pageid = "news";
$page = FilterText($_GET['page']);
$posts = mysql_evaluate("SELECT COUNT(*) FROM cms_news");
$pages = ceil(($posts + 0) / 50);
if($page > $pages || $page < 1){
$page = 1;
}
if($_POST['site']){
header("location: ".$adminpath."/index/p/news&page=".$_POST['page']."");
}
if($_POST['site2']){
header("location: ".$adminpath."/index/p/news&page=".$_POST['page2']."");
}
if($do == "delete" && is_numeric($key)){
$check = mysql_query("SELECT id FROM cms_news WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($check) > 0){
mysql_query("DELETE FROM cms_news WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
mysql_query("INSERT INTO stafflogs (action,message,note,userid,targetid,timestamp) VALUES ('Housekeeping','News geloescht','news.php','".$my_id."','0','".$date_full."')") or die(mysql_error());
$msg = "<div class='rounded rounded-green'><center>News wurde erfolgreich gelöscht. <img src=\"./images/check.gif\"></center></div>";
} else {
$msg = "<div class='rounded rounded-red'><center>Fehler - News konnten nicht gelöscht werden. <img src=\"./images/del.gif\"></center></div>";
}
} elseif($do == "edit" && is_numeric($key)){
$check = mysql_query("SELECT * FROM cms_news WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($check) > 0){
$article = mysql_fetch_assoc($check);
$editor_mode = true;
} else {
$msg = "<div class='rounded rounded-red'><center>Fehler - News konnten nicht gelöscht werden. <img src=\"./images/del.gif\"></center></div>";
}
} elseif($do == "save" && is_numeric($key) && isset($_POST['image'])){
$check = mysql_query("SELECT id FROM cms_news WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($check) > 0){
$newsdata = mysql_fetch_assoc($check);
if($_POST['comments'] == true){ $checked = '1'; }else{ $checked = '0'; }
mysql_query("UPDATE cms_news SET title = '".$_POST['title']."', image = '".$_POST['image']."', shortstory = '".$_POST['shortstory']."', longstory = '".$_POST['longstory']."', author = '".$_POST['author']."' WHERE id = '".$key."' LIMIT 1") or die(mysql_error());
mysql_query("INSERT INTO stafflogs (action,message,note,userid,targetid,timestamp) VALUES ('Housekeeping','News wurde Bearbeitet','news.php','".$my_id."','0','".$date_full."')") or die(mysql_error());
$msg = "<div class='rounded rounded-green'><center>News wurde erfolgreich bearbeitet. <img src=\"./images/check.gif\"></center></div>";
$editor_mode = false;
} else {
$msg = "<div class='rounded rounded-red'><center>Fehler - Dieser News Artikel existiert nichtmehr! <img src=\"./images/check.gif\"></center></div>";
}
} elseif($do == "add"){
$editor_mode = true;
if($_POST['submit']){
mysql_query("INSERT INTO stafflogs (action,message,note,userid,targetid,timestamp) VALUES ('Housekeeping','News wurde hinzugefuegt','news_add.php','".$my_id."','0','".$date_full."')") or die(mysql_error());
mysql_query("INSERT INTO cms_news (title,longstory,shortstory,published,image,campaign,campaignimg,author) VALUES ('".$_POST['title']."','".$_POST['shortstory']."','".$_POST['longstory']."','".time()."','".$_POST['image']."','0','0','".$_POST['author']."')") or die(mysql_error());
$msg = "<div class='rounded rounded-green'><center>News wurde erfolgreich hinzugefügt</center></div>";
$editor_mode = false;
}
}
@include('subheader.php');
if(isset($msg)){ ?><p><strong><?php echo $msg; ?></strong></p><?php } ?>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<?php if($editor_mode !== true){ ?>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<form action='<?php echo $adminpath; ?>/index/p/news&do=save' method='post' name='theAdminForm' id='theAdminForm'>
<div class='tableborder'>
<div class='tableheaderalt'><center>News - Übersicht
<select name="page">
<?php for ($i = 1; $i <= $pages; $i++){ ?>
<option value="<?php echo $i; ?>"<?php if($i == $page){ echo' selected="selected"'; } ?>><?php echo $i; ?></option>
<?php } ?>
</select>
<input type="submit" name="site" value="Weiter »"> <span class='fauxbutton'><a href='./index/p/news&do=add'>News Hinzufügen</a></span>
</div>
</center>
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='1%' align='center'>ID</td>
<td class='tablesubheader' width='20%'>Title</td>
<td class='tablesubheader' width='12%' align='left'>Datum</td>
<td class='tablesubheader' width='10%' align='left'>Author</td>
<td class='tablesubheader' width='1%' align='center'>Bearbeiten</td>
<td class='tablesubheader' width='1%' align='center'>Löschen</td>
</tr>
<?php
$query_min = ($page * 50) - 50;
if($query_min < 0){ // Page 1
$query_min = 0;
}
$get_articles = mysql_query("SELECT * FROM cms_news ORDER BY id DESC LIMIT ".$query_min.", 50") or die(mysql_error());
while($row = mysql_fetch_assoc($get_articles)){
?>
<tr>
<td class='tablerow1' align='center'><?php echo $row['id']; ?></td>
<td class='tablerow2'><strong><?php echo HoloText($row['title']); ?></strong><div class='desctext'><?php echo $row['longstory']; ?></div></td>
<td class='tablerow2' align='left'><?php echo date('d.m.Y, H:i', $row['published']); ?> Uhr</td>
<td class='tablerow2' align='left'><?php echo $row['author']; ?></td>
<td class='tablerow2' align='center'><a href='<?php echo $adminpath; ?>/index/p/news&do=edit&key=<?php echo $row['id']; ?>'><img src='./images/edit.gif' alt='Edit'></a></td>
<td class='tablerow2' align='center'><a href='<?php echo $adminpath; ?>/index/p/news&do=delete&key=<?php echo $row['id']; ?>'><img src='./images/del.gif' alt='Delete'></a></td>
</tr>
<?php } ?>
</table>
<div class='tableborder'>
<div class='tableheaderalt'><center>News - Übersicht
<select name="page2">
<?php for ($i = 1; $i <= $pages; $i++){ ?>
<option value="<?php echo $i; ?>"<?php if($i == $page){ echo' selected="selected"'; } ?>><?php echo $i; ?></option>
<?php } ?>
</select>
<input type="submit" name="site2" value="Weiter »"> <span class='fauxbutton'><a href='./index/p/news&do=add'>News Hinzufügen</a></span>
</div>
</div>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<?php }elseif($do == "add"){ ?>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<form action='<?php echo $adminpath; ?>/index/p/news&do=add' method='post' name='theAdminForm' id='theAdminForm'>
<div class='tableborder'>
<div class='tableheaderalt'><center>News erstellen!</center></div>
<table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Title</b><div class='graytext'>Wie soll der Title heissen?</div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='title' value="" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Contenido</b><div class='graytext'>Contenido de la noticia<br /><font color="green"><a href="http://fibbox.org">Ediciones FibboX.</a></font></div></td>
<td class='tablerow2' width='60%' valign='middle'><textarea id="story" name="shortstory" cols='60' rows='8' style="width: 8%"><?php echo $article['shortstory']; ?></textarea></td>
</tr>
<script type="text/javascript" src="./tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
language : "es",
// General options
mode : "exact",
elements : "story",
theme : "advanced",
plugins : "autolink,lists,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,wordcount,advlist,autosave",
// Theme options
theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,code,|,forecolor,backcolor",
theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak,restoredraft,|,insertdate,inserttime,preview",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_statusbar_location : "bottom",
theme_advanced_resizing : true,
width: "750px",
// Example content CSS (should be your site CSS)
content_css : "./tiny_mce/css/content.css",
// Drop lists for link/image/media/template dialogs
template_external_list_url : "./tiny_mce/lists/template_list.js",
external_link_list_url : "./>tiny_mce/lists/link_list.js",
external_image_list_url : "./tiny_mce/lists/image_list.js",
media_external_list_url : "./tiny_mce/lists/media_list.js",
// Style formats
style_formats : [
{title : 'Bold text', inline : 'b'},
{title : 'Red text', inline : 'span', styles : {color : '#ff0000'}},
{title : 'Red header', block : 'h1', styles : {color : '#ff0000'}},
{title : 'Example 1', inline : 'span', classes : 'example1'},
{title : 'Example 2', inline : 'span', classes : 'example2'},
{title : 'Table styles'},
{title : 'Table row 1', selector : 'tr', classes : 'tablerow1'}
],
// Replace values for the template plugin
template_replace_values : {
username : "Some User",
staffid : "991234"
}
});
</script>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Beschreibung</b><div class='graytext'>News Beschreibung<br /><font color="green">HTML is erlaubt.</font></div></td>
<td class='tablerow2' width='60%' valign='middle'><textarea name='longstory' cols='60' rows='5' wrap='soft' id='sub_desc' class='multitext'></textarea></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Topstory</b><div class='graytext'>News-Topstory Bilder findest du <a href="http://www.habbotimes.net/fancenter/pixxelsearch/topstory_gallery" target="_new">Hier</a></div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='image' value="" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Author</b><div class='graytext'>Wer hat die News geschrieben?</div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='author' value="" size='30' class='textinput'></td>
</tr>
<tr>
<tr><td align='center' class='tablesubheader' colspan='2' ><input type='submit' name='submit' value='News Speichern' class='realbutton' accesskey='s'></td></tr>
</table>
</div>
</div>
</form>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<?php } elseif($do == "edit" && is_numeric($key)) { ?>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<form action='<?php echo $adminpath; ?>/index/p/news&do=save&key=<?php echo $article['id']; ?>' method='post' name='theAdminForm' id='theAdminForm'>
<div class='tableborder'>
<div class='tableheaderalt'><center>News <u><?php echo $articlen['title']; ?></u> (ID: <?php echo $article['id']; ?>) wird bearbeitet <img src="./images/edit.gif"></center></div>
<table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Title</b><div class='graytext'>Wie soll der Title heissen?</div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='title' value="<?php echo $article['title']; ?>" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Kurz-Beschreibung</b><div class='graytext'>Was soll in den News stehen?</div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='longstory' value="<?php echo $article['longstory']; ?>" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Beschreibung</b><div class='graytext'>News Beschreibung<br /><font color="green">HTML is erlaubt.</font></div></td>
<td class='tablerow2' width='60%' valign='middle'><textarea name='shortstory' cols='60' rows='5' wrap='soft' id='sub_desc' class='multitext'><?php echo $article['shortstory']; ?></textarea></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Topstory</b><div class='graytext'>News-Topstory Bilder findest du <a href="http://habbotimes.net/fancenter/topstory_gallery" target="_new">Hier</a></div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='image' value="<?php echo $article['image']; ?>" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>Author</b><div class='graytext'>Wer hat die News geschrieben?</div></td>
<td class='tablerow2' width='60%' valign='middle'><input type='text' name='author' value="<?php echo $article['author']; ?>" size='30' class='textinput'></td>
</tr>
<tr>
<td class='tablerow1' width='40%' valign='middle'><b>News Kommentare</b><div class='graytext'>Wenn du News Kommentare einstellen willst, dann klick auf die Checkbox</div></td>
<td class='tablerow2' width='60%' valign='middle'><input tabindex="6" type="checkbox" name="comments" id="comments" <?php if($article['comments'] == 1){ ?>checked="checked" <?php } ?>value="true"/></td>
</tr>
<tr><td align='center' class='tablesubheader' colspan='2' ><input type='submit' value='News Bearbeiten' class='realbutton' accesskey='s'></td></tr>
</form></table></div><br />
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
<?php } ?>
<?php //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ?>
</div><!-- / RIGHT CONTENT BLOCK -->
</td></tr>
</table>
</div><!-- / OUTERDIV -->
<?php require_once('footer.php'); } else { require_once('error.php'); exit; } ?>du schreibst "Ersetz mal die fplgende News.php mit DEINER und versuche es nochmal:"
Du meinst mit deiner oder?
Sorry, ich weiß leider nicht was du meinst.
Du sollst den ganzen Code in deiner News.php einfügen.
Royal , er meint welche news.php er mit was ersetzten soll.
So schwer?
Seid ihr echt so dumm? - Die können dir erzählen was sie wollen über HK oder Db oder sonst was das liegt an MySQL.
Es liegt am HK da es die Daten nicht an die DB weiter vermittelt und deswegen Error.
Keine Mysql wege da also auch kein ''OK'' .
Entweder Db is down oder du kannst es aufgeben weil bei dir nichts geht ..
Weder Login noch regi
Also Leude:
Der Error:
Data too long for column 'details' at row 1
sagt aus, das der Wert, den das HK in die Tabelle einträgt, zu lang ist. Googlen sollte helfen^^
und der hier:
Incorrect string value: '\xFCgt' for column 'message' at row 1
Sagt aus, das entweder dieses Zeichen nicht erkannt bzw. nicht erlaubt ist, oder aber MySQL einen Fehler bzw. Einschränkung in der my.ini hat.
Ich hoffe das ich dir geholfen habe.
PS: Angelfire, zu nem Teil hattest du Recht^^
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!