Seite 3 von 5

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 18:26
von franki
Fast :wink:

Wenn Du jetzt noch hier

Code: Alles auswählen

         <div id="wrapheader">
            <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
das

Code: Alles auswählen

            <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
löschen würdest sollte es funktionieren.

Sorry hatte es vergessen zu löschen :oops:

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 19:14
von Latza
Wie im anderen Thread schon gesagt. Die meldung kommt bei mir :
Parse error: syntax error, unexpected $end in /users/fck-recorder/www/cache/tpl_melankolia_overall_header.html.php on line 298

overall_header aktuell:

Code: Alles auswählen

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">
<head>

<meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
<meta http-equiv="content-language" content="{S_USER_LANG}" />
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="imagetoolbar" content="no" />
<meta name="resource-type" content="document" />
<meta name="distribution" content="global" />
<meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group" />
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
{META}
<title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>
<!-- IF S_ENABLE_FEEDS -->
	<!-- IF S_ENABLE_FEEDS_OVERALL --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_NEW}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_ACTIVE}" href="{U_FEED}?mode=topics_active" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
	<!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
<!-- ENDIF -->
<!-- INCLUDE reimg_content.html -->
<link rel="stylesheet" href="{T_STYLESHEET_LINK}" type="text/css" />
<link href="{T_THEME_PATH}/bbcodebox3.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
// <![CDATA[
<!-- IF S_USER_PM_POPUP -->
	if ({S_NEW_PM})
	{
		popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');
	}
<!-- ENDIF -->

function popup(url, width, height, name)
{
	if (!name)
	{
		name = '_popup';
	}

	window.open(url.replace(/&/g, '&'), name, 'height=' + height + ',resizable=yes,scrollbars=yes,width=' + width);
	return false;
}

function jumpto()
{
	var page = prompt('{LA_JUMP_PAGE}:', '{ON_PAGE}');
    var per_page = '{PER_PAGE}';
	var base_url = '{A_BASE_URL}';

	if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)
	{
		if (base_url.indexOf('?') == -1)
		{
			document.location.href = base_url + '?start=' + ((page - 1) * per_page);
		}
		else
		{
			document.location.href = base_url.replace(/&/g, '&') + '&start=' + ((page - 1) * per_page);
		}
	}

}

/**
* Find a member
*/
function find_username(url)
{
	popup(url, 760, 570, '_usersearch');
	return false;
}

/**
* Mark/unmark checklist
* id = ID of parent container, name = name prefix, state = state [true/false]
*/
function marklist(id, name, state)
{
	var parent = document.getElementById(id);
	if (!parent)
	{
		eval('parent = document.' + id);
	}

	if (!parent)
	{
		return;
	}

	var rb = parent.getElementsByTagName('input');
	
	for (var r = 0; r < rb.length; r++)
	{
		if (rb[r].name.substr(0, name.length) == name)
		{
			rb[r].checked = state;
		}
	}
}

<!-- IF ._file -->

	/**
	* Play quicktime file by determining it's width/height
	* from the displayed rectangle area
	*
	* Only defined if there is a file block present.
	*/
	function play_qt_file(obj)
	{
		var rectangle = obj.GetRectangle();

		if (rectangle)
		{
			rectangle = rectangle.split(',')
			var x1 = parseInt(rectangle[0]);
			var x2 = parseInt(rectangle[2]);
			var y1 = parseInt(rectangle[1]);
			var y2 = parseInt(rectangle[3]);

			var width = (x1 < 0) ? (x1 * -1) + x2 : x2 - x1;
			var height = (y1 < 0) ? (y1 * -1) + y2 : y2 - y1;
		}
		else
		{
			var width = 200;
			var height = 0;
		}

		obj.width = width;
		obj.height = height + 16;

		obj.SetControllerVisible(true);

		obj.Play();
	}
<!-- ENDIF -->

/**
*  Code-Spoiler BBCode by Nerdy [3]
*  www.phpbb3bbcodes.com | BCForum.eu
*/
function select_codespoiler(a)
{
   var e = a.parentNode.parentNode.getElementsByTagName('code')[0];
   if (window.getSelection)
   {
      var s = window.getSelection();
      if (s.setBaseAndExtent)
      {
         s.setBaseAndExtent(e, 0, e, e.innerText.length - 1);
      }
      else
      {
         var r = document.createRange();
         r.selectNodeContents(e);
         s.removeAllRanges();
         s.addRange(r);
      }
   }
   else if (document.getSelection)
   {
      var s = document.getSelection();
      var r = document.createRange();
      r.selectNodeContents(e);
      s.removeAllRanges();
      s.addRange(r);
   }
   else if (document.selection)
   {
      var r = document.body.createTextRange();
      r.moveToElementText(e);
      r.select();
   }
}
function toggle_codespoiler(a, s)
{
   var e = a.parentNode.parentNode.getElementsByTagName('dd')[0];

   if (!s)
   {
      s = (e.style.display == '' || e.style.display == 'block') ? -1 : 1;
   }
   e.style.display = (s == 1) ? 'block' : 'none';
}

// ]]>
</script>
<link href="{T_THEME_PATH}/web/style.css" rel="stylesheet" type="text/css" media="screen, projection" />
</head>
<body class="{S_CONTENT_DIRECTION}">
<div class="outside">
   <div class="top-left"></div>
   <div class="top-center"></div>
   <div class="top-right"></div>
   <div class="inside">
      <div class="notopgap">
         <a name="top"></a>
         <div id="wrapheader">
               <div id="logodesc">
                  <a class="logo" href="{U_INDEX}"><img src="{T_IMAGESET_PATH}/site-logo-{SITE_LOGO_RANDOM}.png" alt="Logo" title="Logo" /></span></a>
               </div>
         </div>
         <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
            <br />
            <table class="tablebg" cellspacing="1" width="100%">
               <tr>
                  <td class="row1" height="60px" width="73%">
                     <p class="breadcrumbs">
                        <a href="{U_INDEX}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_INDEX}</strong></a>
                        <!-- BEGIN navlinks --> &#187; <strong><strong></strong>&nbsp;<a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks -->
                        <br /><!-- IF TOPIC_TITLE -->
                           <!-- IF U_VIEW_TOPIC --><img src="{T_IMAGESET_PATH}/folder2.gif" alt="#" /><a class="topictitle" href="{U_VIEW_TOPIC}">{TOPIC_TITLE}</a><!-- ENDIF -->
                        <!-- ENDIF -->
                     </p>
                     <div align="center">
                        <p>
                           <!-- IF U_RESTORE_PERMISSIONS --> &nbsp;<a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a><!-- ENDIF -->
         <!-- ENDIF -->
                           <!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN --> &nbsp;<span style="color: red;">{L_BOARD_DISABLED}</span><!-- ENDIF -->
         <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU --></p></div>
                  </td>
                  <td class="row2" height="60px" width="27%">
                     <!-- IF not S_USER_LOGGED_IN and not S_IS_BOT -->
                        <form method="post" action="{S_LOGIN_ACTION}" style="float:left;position:relative;">
                        <table width="100%" cellspacing="0">
                           <tr>
                              <!-- IF SCRIPT_NAME == 'index' -->
                                 <td width="50%"><span class="genmed">{L_USERNAME}:</span><br /><span class="genmed">{L_PASSWORD}:</span></td>
                                 <td width="50%"><input tabindex="100" class="post" type="text" name="username" size="10" /><br /><input tabindex="101" class="post" type="password" name="password" size="10" /></td>
                                 <td width="50%"  nowrap="nowrap"> <!-- IF S_AUTOLOGIN_ENABLED --><span class="genmed">Speichern</span> <input tabindex="102" type="checkbox"  class="radio" name="autologin" /><!-- ENDIF --><br /><input tabindex="103" type="submit" class="btnmain" name="login" value="{L_LOGIN}" /></td>
                              <!-- ELSE -->
                                 <span class="genmed"><a href="{U_LOGIN_LOGOUT}"><strong>{L_LOGIN_LOGOUT}</strong></a>
                                    <!-- IF not S_IS_BOT -->
                                       <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) -->&nbsp;|&nbsp;<a href="{U_REGISTER}"><strong>{L_REGISTER}</strong></a><!-- ENDIF -->
                                    <!-- ENDIF -->
                                 </span>
                              <!-- ENDIF -->
                           </tr>
                        </table>
                        {S_FORM_TOKEN}
                        </form>
                     <!-- ENDIF -->

                     <table width="100%" cellspacing="0">
                        <tr>
                           <td class="genmed">
                              <!-- IF not S_IS_BOT -->
                                 <!-- IF S_USER_LOGGED_IN -->
                                    <strong>Hi,&nbsp;{S_USERNAME}</strong>&nbsp;<b>(</b><a href="{U_LOGIN_LOGOUT}">{L_LOGOUT}</a><b>)</b><br />
                                    {LAST_VISIT_DATE}<br />
                                 <!-- ENDIF -->
                                 <!-- IF S_DISPLAY_PM --><a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a><!-- ENDIF -->
                                 <!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->{PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF -->
                              <!-- ENDIF -->
                           </td>
                        </tr>
                     </table>
                  </td>
               </tr>
            </table>
            <!-- IF not S_USER_LOGGED_IN -->
               <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
                  <tr align="center">
                     <!-- IF not S_IS_BOT -->
                        <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><td class="menu2"> <a href="{U_REGISTER}" >{L_REGISTER}</a></td><!-- ENDIF -->
                        <td class="menu2"><a href="{U_LOGIN_LOGOUT}" rel="nofollow">{L_LOGIN}</a></td><!-- ENDIF -->
                        <!-- IF S_DISPLAY_SEARCH --><td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td><!-- ENDIF -->
                        <td class="menu2"><a href="{U_FAQ}">{L_FAQ}</a></td>
                  </tr>
               </table>

               <!-- IF S_USER_LOGGED_IN -->
                  <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
                     <tr align="center">
                        <td class="menu2"><a href="{U_PROFILE}" rel="nofollow">{L_PROFILE}</a></td>
                        <!-- IF S_DISPLAY_SEARCH -->
                           <td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
                           <td class="menu2"><a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a></td>
                           <td class="menu2"><a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></td>
                           <td class="menu2"><a href="/viewtopic.php?p=144#p144">Video Status</a></td>
                        <!-- ENDIF -->
                        <td class="menu2"><a href="/viewtopic.php?p=55#p55">{L_FAQ}</a></td>
                     </tr>
                  </table>
               <!-- ENDIF -->
               <br />

               <br style="clear: both;" />
         <!-- ENDIF -->

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 19:24
von Latza
@Franki
Ich glaub das was du mir gezeigt hast war falsch. Du weißt ja das es hier um das Bord3 Portal geht wenn du die erste seite gelesen hast.
Und du hast die ganzen änderungen rückgängig gemacht.
Kann mir jemand mal weiterhelfen was ich jetzt machen soll?

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 19:45
von winnetou
Hallo Latza,
versuche es mal mit der, mache aber vorher eine Sicherung ohne Gewähr:
und nicht vergessen Style im ACP zu aktualisieren und cache löschen!

Code: Alles auswählen

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">
<head>

<meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
<meta http-equiv="content-language" content="{S_USER_LANG}" />
<meta http-equiv="content-style-type" content="text/css" />
<meta http-equiv="imagetoolbar" content="no" />
<meta name="resource-type" content="document" />
<meta name="distribution" content="global" />
<meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group" />
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
{META}
<title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>
<!-- IF S_ENABLE_FEEDS -->
   <link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" />
   <!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
   <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
   <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_TOPICS}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
   <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
   <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
<!-- ENDIF -->
<!-- INCLUDE reimg_content.html -->
<link rel="stylesheet" href="{T_STYLESHEET_LINK}" type="text/css" />
<link href="{T_THEME_PATH}/bbcodebox3.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
// <![CDATA[
<!-- IF S_USER_PM_POPUP -->
   if ({S_NEW_PM})
   {
      popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');
   }
<!-- ENDIF -->

function popup(url, width, height, name)
{
   if (!name)
   {
      name = '_popup';
   }

   window.open(url.replace(/&/g, '&'), name, 'height=' + height + ',resizable=yes,scrollbars=yes,width=' + width);
   return false;
}

function jumpto()
{
   var page = prompt('{LA_JUMP_PAGE}:', '{ON_PAGE}');
    var per_page = '{PER_PAGE}';
   var base_url = '{A_BASE_URL}';

   if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)
   {
      if (base_url.indexOf('?') == -1)
      {
         document.location.href = base_url + '?start=' + ((page - 1) * per_page);
      }
      else
      {
         document.location.href = base_url.replace(/&/g, '&') + '&start=' + ((page - 1) * per_page);
      }
   }

}

/**
* Find a member
*/
function find_username(url)
{
   popup(url, 760, 570, '_usersearch');
   return false;
}

/**
* Mark/unmark checklist
* id = ID of parent container, name = name prefix, state = state [true/false]
*/
function marklist(id, name, state)
{
   var parent = document.getElementById(id);
   if (!parent)
   {
      eval('parent = document.' + id);
   }

   if (!parent)
   {
      return;
   }

   var rb = parent.getElementsByTagName('input');
   
   for (var r = 0; r < rb.length; r++)
   {
      if (rb[r].name.substr(0, name.length) == name)
      {
         rb[r].checked = state;
      }
   }
}

<!-- IF ._file -->

   /**
   * Play quicktime file by determining it's width/height
   * from the displayed rectangle area
   *
   * Only defined if there is a file block present.
   */
   function play_qt_file(obj)
   {
      var rectangle = obj.GetRectangle();

      if (rectangle)
      {
         rectangle = rectangle.split(',')
         var x1 = parseInt(rectangle[0]);
         var x2 = parseInt(rectangle[2]);
         var y1 = parseInt(rectangle[1]);
         var y2 = parseInt(rectangle[3]);

         var width = (x1 < 0) ? (x1 * -1) + x2 : x2 - x1;
         var height = (y1 < 0) ? (y1 * -1) + y2 : y2 - y1;
      }
      else
      {
         var width = 200;
         var height = 0;
      }

      obj.width = width;
      obj.height = height + 16;

      obj.SetControllerVisible(true);

      obj.Play();
   }
<!-- ENDIF -->

/**
*  Code-Spoiler BBCode by Nerdy [3]
*  www.phpbb3bbcodes.com | BCForum.eu
*/
function select_codespoiler(a)
{
   var e = a.parentNode.parentNode.getElementsByTagName('code')[0];
   if (window.getSelection)
   {
      var s = window.getSelection();
      if (s.setBaseAndExtent)
      {
         s.setBaseAndExtent(e, 0, e, e.innerText.length - 1);
      }
      else
      {
         var r = document.createRange();
         r.selectNodeContents(e);
         s.removeAllRanges();
         s.addRange(r);
      }
   }
   else if (document.getSelection)
   {
      var s = document.getSelection();
      var r = document.createRange();
      r.selectNodeContents(e);
      s.removeAllRanges();
      s.addRange(r);
   }
   else if (document.selection)
   {
      var r = document.body.createTextRange();
      r.moveToElementText(e);
      r.select();
   }
}
function toggle_codespoiler(a, s)
{
   var e = a.parentNode.parentNode.getElementsByTagName('dd')[0];

   if (!s)
   {
      s = (e.style.display == '' || e.style.display == 'block') ? -1 : 1;
   }
   e.style.display = (s == 1) ? 'block' : 'none';
}

// ]]>
</script>
<link href="{T_THEME_PATH}/web/style.css" rel="stylesheet" type="text/css" media="screen, projection" />
</head>
<body class="{S_CONTENT_DIRECTION}">
<div class="outside">
<div class="top-left"></div><div class="top-center"></div><div class="top-right"></div>
<div class="inside">
<div class="notopgap">
<a name="top"></a>

<div id="wrapheader">
<div id="logodesc">
         <a class="logo" href="{U_INDEX}"><img src="{T_IMAGESET_PATH}/site-logo-{SITE_LOGO_RANDOM}.png" alt="Logo" title="Logo" /></span></a>
   </div>
</div>
<!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->


<br />
   <table class="tablebg" cellspacing="1" width="100%">
<tr>
<td class="row1" height="60px" width="73%">
         <p class="breadcrumbs"><a href="{U_INDEX}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_INDEX}</strong></a>
<!-- BEGIN navlinks --> &#187; <strong><strong></strong>&nbsp;<a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks -->
<br /><!-- IF TOPIC_TITLE --><!-- IF U_VIEW_TOPIC --><img src="{T_IMAGESET_PATH}/folder2.gif" alt="#" /><a class="topictitle" href="{U_VIEW_TOPIC}">{TOPIC_TITLE}</a><!-- ENDIF --><!-- ENDIF --></p>
<div align="center"> <p><!-- IF U_RESTORE_PERMISSIONS --> &nbsp;<a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a><!-- ENDIF -->
            <!-- ENDIF --><!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN --> &nbsp;<span style="color: red;">{L_BOARD_DISABLED}</span><!-- ENDIF --><!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->

</p></div>
         </td>
<td class="row2" height="60px" width="27%"><!-- IF not S_USER_LOGGED_IN and not S_IS_BOT -->

<form method="post" action="{S_LOGIN_ACTION}" style="float:left;position:relative;">   
<table width="100%" cellspacing="0">
<tr>
<!-- IF SCRIPT_NAME == 'index' -->      
<td width="50%"><span class="genmed">{L_USERNAME}:</span><br /><span class="genmed">{L_PASSWORD}:</span></td>
       <td width="50%"><input tabindex="100" class="post" type="text" name="username" size="10" /><br /><input tabindex="101" class="post" type="password" name="password" size="10" /></td>
         
         
          <td width="50%"  nowrap="nowrap"> <!-- IF S_AUTOLOGIN_ENABLED --><span class="genmed">Remember me</span> <input tabindex="102" type="checkbox"  class="radio" name="autologin" /><!-- ENDIF --><br /><input tabindex="103" type="submit" class="btnmain" name="login" value="{L_LOGIN}" />
    </td>


<!-- ELSE --><span class="genmed"><a href="{U_LOGIN_LOGOUT}"><strong>{L_LOGIN_LOGOUT}</strong></a><!-- IF not S_IS_BOT -->
                <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) -->&nbsp;|&nbsp;<a href="{U_REGISTER}"><strong>{L_REGISTER}</strong></a><!-- ENDIF --><!-- ENDIF --></span><!-- ENDIF -->
  </tr>
</table>
   {S_FORM_TOKEN}
   </form>
<!-- ENDIF -->

<table width="100%" cellspacing="0">
<tr>
<td class="genmed">
<!-- IF S_USER_LOGGED_IN -->
<strong>Hi,&nbsp;{S_USERNAME}</strong>&nbsp;<b>(</b><a href="{U_LOGIN_LOGOUT}">{L_LOGOUT}</a><b>)</b><br />
{LAST_VISIT_DATE}<br /><!-- ENDIF -->
<!-- IF S_DISPLAY_PM --><a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a><!-- ENDIF -->
<!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->{PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --><!-- ENDIF --><!-- ENDIF --></td></tr></table></td>
</tr>
</table>
   <!-- IF not S_USER_LOGGED_IN -->
<table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
   <tr align="center">
  <!-- IF not S_IS_BOT -->
  <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><td class="menu2"> <a href="{U_REGISTER}" >{L_REGISTER}</a></td><!-- ENDIF -->
<td class="menu2"><a href="{U_LOGIN_LOGOUT}" rel="nofollow">{L_LOGIN}</a></td><!-- ENDIF -->
    <!-- IF S_DISPLAY_SEARCH --><td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
   <!-- ENDIF -->

   <td class="menu2"><a href="{U_FAQ}">{L_FAQ}</a></td>
</tr></table>   
<!-- ENDIF -->

<!-- IF S_USER_LOGGED_IN -->
  <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
   <tr align="center">
   
    <td class="menu2"><a href="{U_PROFILE}" rel="nofollow">{L_PROFILE}</a></td>
   <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
     <!-- IF S_DISPLAY_SEARCH -->
     <td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
     <td class="menu2"><a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a></td>
     <td class="menu2"><a href="{U_SEARCH_SELF}">{L_SEARCH_SELF}</a></td>
   <td class="menu2"><a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></td>
   <td class="menu2"><a href="{U_SEARCH_UNREAD}">{L_SEARCH_UNREAD}</a></td>
        <!-- ENDIF -->
   <td class="menu2"><a href="/viewtopic.php?p=55#p55">{L_FAQ}</a></td>
</tr></table>
<!-- ENDIF --><br />

      <br style="clear: both;" />
	  <!-- ENDIF -->

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 19:48
von Latza
Ich hab meine overall_header von seite 2 genommen (vor den änderungen von franki) :

Code: Alles auswählen

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">
    <head>

    <meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
    <meta http-equiv="content-language" content="{S_USER_LANG}" />
    <meta http-equiv="content-style-type" content="text/css" />
    <meta http-equiv="imagetoolbar" content="no" />
    <meta name="resource-type" content="document" />
    <meta name="distribution" content="global" />
    <meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group" />
    <meta name="keywords" content="" />
    <meta name="description" content="" />
    <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
    {META}
    <title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>
    <!-- IF S_ENABLE_FEEDS -->
       <!-- IF S_ENABLE_FEEDS_OVERALL --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_NEW}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_ACTIVE}" href="{U_FEED}?mode=topics_active" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
    <!-- ENDIF -->
    <!-- INCLUDE reimg_content.html -->
    <link rel="stylesheet" href="{T_STYLESHEET_LINK}" type="text/css" />
    <link href="{T_THEME_PATH}/bbcodebox3.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
    // <![CDATA[
    <!-- IF S_USER_PM_POPUP -->
       if ({S_NEW_PM})
       {
          popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');
       }
    <!-- ENDIF -->

    function popup(url, width, height, name)
    {
       if (!name)
       {
          name = '_popup';
       }

       window.open(url.replace(/&/g, '&'), name, 'height=' + height + ',resizable=yes,scrollbars=yes,width=' + width);
       return false;
    }

    function jumpto()
    {
       var page = prompt('{LA_JUMP_PAGE}:', '{ON_PAGE}');
        var per_page = '{PER_PAGE}';
       var base_url = '{A_BASE_URL}';

       if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)
       {
          if (base_url.indexOf('?') == -1)
          {
             document.location.href = base_url + '?start=' + ((page - 1) * per_page);
          }
          else
          {
             document.location.href = base_url.replace(/&/g, '&') + '&start=' + ((page - 1) * per_page);
          }
       }

    }

    /**
    * Find a member
    */
    function find_username(url)
    {
       popup(url, 760, 570, '_usersearch');
       return false;
    }

    /**
    * Mark/unmark checklist
    * id = ID of parent container, name = name prefix, state = state [true/false]
    */
    function marklist(id, name, state)
    {
       var parent = document.getElementById(id);
       if (!parent)
       {
          eval('parent = document.' + id);
       }

       if (!parent)
       {
          return;
       }

       var rb = parent.getElementsByTagName('input');
       
       for (var r = 0; r < rb.length; r++)
       {
          if (rb[r].name.substr(0, name.length) == name)
          {
             rb[r].checked = state;
          }
       }
    }

    <!-- IF ._file -->

       /**
       * Play quicktime file by determining it's width/height
       * from the displayed rectangle area
       *
       * Only defined if there is a file block present.
       */
       function play_qt_file(obj)
       {
          var rectangle = obj.GetRectangle();

          if (rectangle)
          {
             rectangle = rectangle.split(',')
             var x1 = parseInt(rectangle[0]);
             var x2 = parseInt(rectangle[2]);
             var y1 = parseInt(rectangle[1]);
             var y2 = parseInt(rectangle[3]);

             var width = (x1 < 0) ? (x1 * -1) + x2 : x2 - x1;
             var height = (y1 < 0) ? (y1 * -1) + y2 : y2 - y1;
          }
          else
          {
             var width = 200;
             var height = 0;
          }

          obj.width = width;
          obj.height = height + 16;

          obj.SetControllerVisible(true);

          obj.Play();
       }
    <!-- ENDIF -->

    /**
    *  Code-Spoiler BBCode by Nerdy [3]
    *  www.phpbb3bbcodes.com | BCForum.eu
    */
    function select_codespoiler(a)
    {
       var e = a.parentNode.parentNode.getElementsByTagName('code')[0];
       if (window.getSelection)
       {
          var s = window.getSelection();
          if (s.setBaseAndExtent)
          {
             s.setBaseAndExtent(e, 0, e, e.innerText.length - 1);
          }
          else
          {
             var r = document.createRange();
             r.selectNodeContents(e);
             s.removeAllRanges();
             s.addRange(r);
          }
       }
       else if (document.getSelection)
       {
          var s = document.getSelection();
          var r = document.createRange();
          r.selectNodeContents(e);
          s.removeAllRanges();
          s.addRange(r);
       }
       else if (document.selection)
       {
          var r = document.body.createTextRange();
          r.moveToElementText(e);
          r.select();
       }
    }
    function toggle_codespoiler(a, s)
    {
       var e = a.parentNode.parentNode.getElementsByTagName('dd')[0];

       if (!s)
       {
          s = (e.style.display == '' || e.style.display == 'block') ? -1 : 1;
       }
       e.style.display = (s == 1) ? 'block' : 'none';
    }

    // ]]>
    </script>
    <link href="{T_THEME_PATH}/web/style.css" rel="stylesheet" type="text/css" media="screen, projection" />
    </head>
    <body class="{S_CONTENT_DIRECTION}">
    <div class="outside">
    <div class="top-left"></div><div class="top-center"></div><div class="top-right"></div>
    <div class="inside">
    <div class="notopgap">
    <a name="top"></a>

    <div id="wrapheader">
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
    <div id="logodesc">
             <a class="logo" href="{U_INDEX}"><img src="{T_IMAGESET_PATH}/site-logo-{SITE_LOGO_RANDOM}.png" alt="Logo" title="Logo" /></span></a>
       </div>
    </div>
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->

    <br />
       <table class="tablebg" cellspacing="1" width="100%">
    <tr>
    <td class="row1" height="60px" width="73%">
             <p class="breadcrumbs"><!-- IF U_PORTAL --><a href="{U_PORTAL}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_PORTAL}</strong></a><!-- ENDIF --><a href="{U_INDEX}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_INDEX}</strong></a>
    <!-- BEGIN navlinks --> &#187; <strong><strong></strong>&nbsp;<a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks -->
    <br /><!-- IF TOPIC_TITLE --><!-- IF U_VIEW_TOPIC --><img src="{T_IMAGESET_PATH}/folder2.gif" alt="#" /><a class="topictitle" href="{U_VIEW_TOPIC}">{TOPIC_TITLE}</a><!-- ENDIF --><!-- ENDIF --></p>
    <div align="center"> <p><!-- IF U_RESTORE_PERMISSIONS --> &nbsp;<a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a><!-- ENDIF -->
                <!-- ENDIF --><!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN --> &nbsp;<span style="color: red;">{L_BOARD_DISABLED}</span><!-- ENDIF --><!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU --></p></div>
             </td>
    <td class="row2" height="60px" width="27%"><!-- IF not S_USER_LOGGED_IN and not S_IS_BOT -->

    <form method="post" action="{S_LOGIN_ACTION}" style="float:left;position:relative;">   
    <table width="100%" cellspacing="0">
    <tr>
    <!-- IF SCRIPT_NAME == 'index' -->      
    <td width="50%"><span class="genmed">{L_USERNAME}:</span><br /><span class="genmed">{L_PASSWORD}:</span></td>
           <td width="50%"><input tabindex="100" class="post" type="text" name="username" size="10" /><br /><input tabindex="101" class="post" type="password" name="password" size="10" /></td>
             
             
              <td width="50%"  nowrap="nowrap"> <!-- IF S_AUTOLOGIN_ENABLED --><span class="genmed">Speichern</span> <input tabindex="102" type="checkbox"  class="radio" name="autologin" /><!-- ENDIF --><br /><input tabindex="103" type="submit" class="btnmain" name="login" value="{L_LOGIN}" />
        </td>


    <!-- ELSE --><span class="genmed"><a href="{U_LOGIN_LOGOUT}"><strong>{L_LOGIN_LOGOUT}</strong></a><!-- IF not S_IS_BOT -->
                    <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) -->&nbsp;|&nbsp;<a href="{U_REGISTER}"><strong>{L_REGISTER}</strong></a><!-- ENDIF --><!-- ENDIF --></span><!-- ENDIF -->
      </tr>
    </table>
       {S_FORM_TOKEN}
       </form>
    <!-- ENDIF -->

    <table width="100%" cellspacing="0">
    <tr>
    <td class="genmed">
    <!-- IF not S_IS_BOT -->
    <!-- IF S_USER_LOGGED_IN -->
    <strong>Hi,&nbsp;{S_USERNAME}</strong>&nbsp;<b>(</b><a href="{U_LOGIN_LOGOUT}">{L_LOGOUT}</a><b>)</b><br />
    {LAST_VISIT_DATE}<br />
    <!-- ENDIF -->
    <!-- IF S_DISPLAY_PM --><a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a><!-- ENDIF -->
    <!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->{PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --><!-- ENDIF --><!-- ENDIF --></td></tr></table></td>
    </tr>
    </table>
       <!-- IF not S_USER_LOGGED_IN -->
    <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
       <tr align="center">
      <!-- IF not S_IS_BOT -->
      <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><td class="menu2"> <a href="{U_REGISTER}" >{L_REGISTER}</a></td><!-- ENDIF -->
    <td class="menu2"><a href="{U_LOGIN_LOGOUT}" rel="nofollow">{L_LOGIN}</a></td><!-- ENDIF -->
        <!-- IF S_DISPLAY_SEARCH --><td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
       <!-- ENDIF -->

       <td class="menu2"><a href="{U_FAQ}">{L_FAQ}</a></td>
    </tr></table>   
    <!-- ENDIF -->

    <!-- IF S_USER_LOGGED_IN -->
      <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
       <tr align="center">
       
        <td class="menu2"><a href="{U_PROFILE}" rel="nofollow">{L_PROFILE}</a></td>
       
         <!-- IF S_DISPLAY_SEARCH -->
         <td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
         <td class="menu2"><a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a></td>
       <td class="menu2"><a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></td>
       <td class="menu2"><a href="/viewtopic.php?p=144#p144">Video Status</a></td>
            <!-- ENDIF -->
       <td class="menu2"><a href="/viewtopic.php?p=55#p55">{L_FAQ}</a></td>
    </tr></table>
    <!-- ENDIF --><br />

          <br style="clear: both;" />
        <!-- ENDIF -->
Jetzt funktioniert wieder alles. Die ist doch so richtig oder nicht?

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 19:50
von winnetou
wenn alles funzt ist se wohl richtig :wink:

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 21:34
von franki
Die Version der overall_header.html kann nicht funktionieren @winetou

Code: Alles auswählen

<div id="wrapheader">
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
    <div id="logodesc">
             <a class="logo" href="{U_INDEX}"><img src="{T_IMAGESET_PATH}/site-logo-{SITE_LOGO_RANDOM}.png" alt="Logo" title="Logo" /></span></a>
       </div>
    </div>
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->

    <br />
       <table class="tablebg" cellspacing="1" width="100%">
Hier hab ich weiter geschrieben

viewtopic.php?f=86&t=204843&p=1172145#p1172145

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 21:37
von Latza
Ja das hab ich mir durchgelesen. Aber es scheint auch so schon alles zu funktionieren.
Hier nochmal meine aktuelle overall_header.html Datei:

Code: Alles auswählen

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" dir="{S_CONTENT_DIRECTION}" lang="{S_USER_LANG}" xml:lang="{S_USER_LANG}">
    <head>

    <meta http-equiv="content-type" content="text/html; charset={S_CONTENT_ENCODING}" />
    <meta http-equiv="content-language" content="{S_USER_LANG}" />
    <meta http-equiv="content-style-type" content="text/css" />
    <meta http-equiv="imagetoolbar" content="no" />
    <meta name="resource-type" content="document" />
    <meta name="distribution" content="global" />
    <meta name="copyright" content="2000, 2002, 2005, 2007 phpBB Group" />
    <meta name="keywords" content="" />
    <meta name="description" content="" />
    <meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
    {META}
    <title>{SITENAME} &bull; <!-- IF S_IN_MCP -->{L_MCP} &bull; <!-- ELSEIF S_IN_UCP -->{L_UCP} &bull; <!-- ENDIF -->{PAGE_TITLE}</title>
    <!-- IF S_ENABLE_FEEDS -->
       <!-- IF S_ENABLE_FEEDS_OVERALL --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {SITENAME}" href="{U_FEED}" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_NEWS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_NEWS}" href="{U_FEED}?mode=news" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_FORUMS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_ALL_FORUMS}" href="{U_FEED}?mode=forums" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPICS --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_NEW}" href="{U_FEED}?mode=topics" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPICS_ACTIVE --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FEED_TOPICS_ACTIVE}" href="{U_FEED}?mode=topics_active" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_FORUM and S_FORUM_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_FORUM} - {FORUM_NAME}" href="{U_FEED}?f={S_FORUM_ID}" /><!-- ENDIF -->
       <!-- IF S_ENABLE_FEEDS_TOPIC and S_TOPIC_ID --><link rel="alternate" type="application/atom+xml" title="{L_FEED} - {L_TOPIC} - {TOPIC_TITLE}" href="{U_FEED}?f={S_FORUM_ID}&t={S_TOPIC_ID}" /><!-- ENDIF -->
    <!-- ENDIF -->
    <!-- INCLUDE reimg_content.html -->
    <link rel="stylesheet" href="{T_STYLESHEET_LINK}" type="text/css" />
    <link href="{T_THEME_PATH}/bbcodebox3.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
    // <![CDATA[
    <!-- IF S_USER_PM_POPUP -->
       if ({S_NEW_PM})
       {
          popup('{UA_POPUP_PM}', 400, 225, '_phpbbprivmsg');
       }
    <!-- ENDIF -->

    function popup(url, width, height, name)
    {
       if (!name)
       {
          name = '_popup';
       }

       window.open(url.replace(/&/g, '&'), name, 'height=' + height + ',resizable=yes,scrollbars=yes,width=' + width);
       return false;
    }

    function jumpto()
    {
       var page = prompt('{LA_JUMP_PAGE}:', '{ON_PAGE}');
        var per_page = '{PER_PAGE}';
       var base_url = '{A_BASE_URL}';

       if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)
       {
          if (base_url.indexOf('?') == -1)
          {
             document.location.href = base_url + '?start=' + ((page - 1) * per_page);
          }
          else
          {
             document.location.href = base_url.replace(/&/g, '&') + '&start=' + ((page - 1) * per_page);
          }
       }

    }

    /**
    * Find a member
    */
    function find_username(url)
    {
       popup(url, 760, 570, '_usersearch');
       return false;
    }

    /**
    * Mark/unmark checklist
    * id = ID of parent container, name = name prefix, state = state [true/false]
    */
    function marklist(id, name, state)
    {
       var parent = document.getElementById(id);
       if (!parent)
       {
          eval('parent = document.' + id);
       }

       if (!parent)
       {
          return;
       }

       var rb = parent.getElementsByTagName('input');
       
       for (var r = 0; r < rb.length; r++)
       {
          if (rb[r].name.substr(0, name.length) == name)
          {
             rb[r].checked = state;
          }
       }
    }

    <!-- IF ._file -->

       /**
       * Play quicktime file by determining it's width/height
       * from the displayed rectangle area
       *
       * Only defined if there is a file block present.
       */
       function play_qt_file(obj)
       {
          var rectangle = obj.GetRectangle();

          if (rectangle)
          {
             rectangle = rectangle.split(',')
             var x1 = parseInt(rectangle[0]);
             var x2 = parseInt(rectangle[2]);
             var y1 = parseInt(rectangle[1]);
             var y2 = parseInt(rectangle[3]);

             var width = (x1 < 0) ? (x1 * -1) + x2 : x2 - x1;
             var height = (y1 < 0) ? (y1 * -1) + y2 : y2 - y1;
          }
          else
          {
             var width = 200;
             var height = 0;
          }

          obj.width = width;
          obj.height = height + 16;

          obj.SetControllerVisible(true);

          obj.Play();
       }
    <!-- ENDIF -->

    /**
    *  Code-Spoiler BBCode by Nerdy [3]
    *  www.phpbb3bbcodes.com | BCForum.eu
    */
    function select_codespoiler(a)
    {
       var e = a.parentNode.parentNode.getElementsByTagName('code')[0];
       if (window.getSelection)
       {
          var s = window.getSelection();
          if (s.setBaseAndExtent)
          {
             s.setBaseAndExtent(e, 0, e, e.innerText.length - 1);
          }
          else
          {
             var r = document.createRange();
             r.selectNodeContents(e);
             s.removeAllRanges();
             s.addRange(r);
          }
       }
       else if (document.getSelection)
       {
          var s = document.getSelection();
          var r = document.createRange();
          r.selectNodeContents(e);
          s.removeAllRanges();
          s.addRange(r);
       }
       else if (document.selection)
       {
          var r = document.body.createTextRange();
          r.moveToElementText(e);
          r.select();
       }
    }
    function toggle_codespoiler(a, s)
    {
       var e = a.parentNode.parentNode.getElementsByTagName('dd')[0];

       if (!s)
       {
          s = (e.style.display == '' || e.style.display == 'block') ? -1 : 1;
       }
       e.style.display = (s == 1) ? 'block' : 'none';
    }

    // ]]>
    </script>
    <link href="{T_THEME_PATH}/web/style.css" rel="stylesheet" type="text/css" media="screen, projection" />
    </head>
    <body class="{S_CONTENT_DIRECTION}">
    <div class="outside">
    <div class="top-left"></div><div class="top-center"></div><div class="top-right"></div>
    <div class="inside">
    <div class="notopgap">
    <a name="top"></a>

    <div id="wrapheader">
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->
    <div id="logodesc">
             <a class="logo" href="{U_INDEX}"><img src="{T_IMAGESET_PATH}/site-logo-{SITE_LOGO_RANDOM}.png" alt="Logo" title="Logo" /></span></a>
       </div>
    </div>
    <!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU -->

    <br />
       <table class="tablebg" cellspacing="1" width="100%">
    <tr>
    <td class="row1" height="60px" width="73%">
             <p class="breadcrumbs"><!-- IF U_PORTAL --><a href="{U_PORTAL}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_PORTAL}</strong></a><!-- ENDIF --><a href="{U_INDEX}"><strong><img src="{T_IMAGESET_PATH}/folder.gif" alt="#" />{L_INDEX}</strong></a>
    <!-- BEGIN navlinks --> &#187; <strong><strong></strong>&nbsp;<a href="{navlinks.U_VIEW_FORUM}">{navlinks.FORUM_NAME}</a><!-- END navlinks -->
    <br /><!-- IF TOPIC_TITLE --><!-- IF U_VIEW_TOPIC --><img src="{T_IMAGESET_PATH}/folder2.gif" alt="#" /><a class="topictitle" href="{U_VIEW_TOPIC}">{TOPIC_TITLE}</a><!-- ENDIF --><!-- ENDIF --></p>
    <div align="center"> <p><!-- IF U_RESTORE_PERMISSIONS --> &nbsp;<a href="{U_RESTORE_PERMISSIONS}">{L_RESTORE_PERMISSIONS}</a><!-- ENDIF -->
                <!-- ENDIF --><!-- IF S_BOARD_DISABLED and S_USER_LOGGED_IN --> &nbsp;<span style="color: red;">{L_BOARD_DISABLED}</span><!-- ENDIF --><!-- IF not $S_IN_PORTAL or S_DISPLAY_PHPBB_MENU --></p></div>
             </td>
    <td class="row2" height="60px" width="27%"><!-- IF not S_USER_LOGGED_IN and not S_IS_BOT -->

    <form method="post" action="{S_LOGIN_ACTION}" style="float:left;position:relative;">   
    <table width="100%" cellspacing="0">
    <tr>
    <!-- IF SCRIPT_NAME == 'index' -->      
    <td width="50%"><span class="genmed">{L_USERNAME}:</span><br /><span class="genmed">{L_PASSWORD}:</span></td>
           <td width="50%"><input tabindex="100" class="post" type="text" name="username" size="10" /><br /><input tabindex="101" class="post" type="password" name="password" size="10" /></td>
             
             
              <td width="50%"  nowrap="nowrap"> <!-- IF S_AUTOLOGIN_ENABLED --><span class="genmed">Speichern</span> <input tabindex="102" type="checkbox"  class="radio" name="autologin" /><!-- ENDIF --><br /><input tabindex="103" type="submit" class="btnmain" name="login" value="{L_LOGIN}" />
        </td>


    <!-- ELSE --><span class="genmed"><a href="{U_LOGIN_LOGOUT}"><strong>{L_LOGIN_LOGOUT}</strong></a><!-- IF not S_IS_BOT -->
                    <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) -->&nbsp;|&nbsp;<a href="{U_REGISTER}"><strong>{L_REGISTER}</strong></a><!-- ENDIF --><!-- ENDIF --></span><!-- ENDIF -->
      </tr>
    </table>
       {S_FORM_TOKEN}
       </form>
    <!-- ENDIF -->

    <table width="100%" cellspacing="0">
    <tr>
    <td class="genmed">
    <!-- IF not S_IS_BOT -->
    <!-- IF S_USER_LOGGED_IN -->
    <strong>Hi,&nbsp;{S_USERNAME}</strong>&nbsp;<b>(</b><a href="{U_LOGIN_LOGOUT}">{L_LOGOUT}</a><b>)</b><br />
    {LAST_VISIT_DATE}<br />
    <!-- ENDIF -->
    <!-- IF S_DISPLAY_PM --><a href="{U_PRIVATEMSGS}">{PRIVATE_MESSAGE_INFO}</a><!-- ENDIF -->
    <!-- IF PRIVATE_MESSAGE_INFO_UNREAD -->{PRIVATE_MESSAGE_INFO_UNREAD}<!-- ENDIF --><!-- ENDIF --><!-- ENDIF --></td></tr></table></td>
    </tr>
    </table>
       <!-- IF not S_USER_LOGGED_IN -->
    <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
       <tr align="center">
      <!-- IF not S_IS_BOT -->
      <!-- IF S_REGISTER_ENABLED and not (S_SHOW_COPPA or S_REGISTRATION) --><td class="menu2"> <a href="{U_REGISTER}" >{L_REGISTER}</a></td><!-- ENDIF -->
    <td class="menu2"><a href="{U_LOGIN_LOGOUT}" rel="nofollow">{L_LOGIN}</a></td><!-- ENDIF -->
        <!-- IF S_DISPLAY_SEARCH --><td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
       <!-- ENDIF -->

       <td class="menu2"><a href="{U_FAQ}">{L_FAQ}</a></td>
    </tr></table>   
    <!-- ENDIF -->

    <!-- IF S_USER_LOGGED_IN -->
      <table class="menu2tb" cellpadding="6" cellspacing="0" border="0" width="100%" align="center" style="border-top-width:0px">
       <tr align="center">
       
        <td class="menu2"><a href="{U_PROFILE}" rel="nofollow">{L_PROFILE}</a></td>
       
         <!-- IF S_DISPLAY_SEARCH -->
         <td class="menu2"><a href="{U_SEARCH}"><strong>{L_SEARCH}</strong></a></td>
         <td class="menu2"><a href="{U_SEARCH_NEW}">{L_SEARCH_NEW}</a></td>
       <td class="menu2"><a href="{U_SEARCH_ACTIVE_TOPICS}">{L_SEARCH_ACTIVE_TOPICS}</a></td>
       <td class="menu2"><a href="/viewtopic.php?p=144#p144">Video Status</a></td>
            <!-- ENDIF -->
       <td class="menu2"><a href="/viewtopic.php?p=55#p55">{L_FAQ}</a></td>
    </tr></table>
    <!-- ENDIF --><br />

          <br style="clear: both;" />
        <!-- ENDIF -->
Funktioniert alles

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 21:58
von winnetou
Hallo Latza,
Du solltest eher schreiben "leider" läuft es. Wäre es eine grün/weiße Seite (du weiß ja der zukünftige Meister heißt Werder Bremen) dann wäre es perfekt!
Gruß
Jürgen

Re: Sql Error nach registrierung!?!

Verfasst: 02.04.2010 22:12
von franki
Wäre schön wenn man das mal im Forum sehen könnte :wink:

AeroRed hilft da nicht wirklich weiter :-?