Posts by AeroXbird

AeroXbird

had ik al gecheckt, klopt als een bus

AeroXbird

PHP

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/exfclan.nl/htdocs/beta/memberlist.php

alstu

AeroXbird

Hallo criminalspoint,
ik heb net een memberlist uit een criminals even bewerkt om deze te laten werken in mijn cms maar ik krijg een mysql error

PHP

<table width=100%>
  <tr><td align="center">
	<form action="memberlist.php" method="get">
	Voorbeeld: "<b>a*</b>" zal een lijst geven van namen die beginnen met een A<br>
	<input type="hidden" name="s" value="search"><input type="text" name="q" value="<?php echo $_REQUEST['q']; ?>"> <input type="submit" value="Zoek!"><br>
	</form>
  </td></tr>
</table>
<table width=100%>
  <tr><td align="center" class="subTitle" style="letter-spacing: normal;" width=20><b>#</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center"><a href="memberlist.php?s=login"><b>Nickname</a></b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><a href="list.php?s=type"><b>Type</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><a href="list.php?s=type"><b>E-mail</b></a></td>
<?php /* ------------------------- */


  $begin				= ($_GET['p'] >= 0) ? $_GET['p']*30 : 0;
  if($_GET['s'] == "login") {
       $dbres				= mysql_query("SELECT `login`,UNIX_TIMESTAMP(`signup`) AS `signup`,`type`,`email` FROM `users` ORDER BY `login` ASC LIMIT $begin,30");
}else
    $dbres				= mysql_query("SELECT `id`, UNIX_TIMESTAMP(`signup`) AS `signup`, `login`, `email`, UNIX_TIMESTAMP(`online`) AS `online`, `type`, `pass`, `ip`, FROM `users` WHERE `login` ORDER BY `id` ASC LIMIT $begin,30");


  for($j=$begin+1; $info = mysql_fetch_object($dbres); $j++) { #hierzo krijg ik een mysql error
    $login				= $info->login;


    $type				= Array("","Drugsdealer","Wetenschapper","Agent");
    $type				= $type[$info->type];
	$type				= $info->email;




    print <<<ENDHTML
  <tr><td align="center" class="mainTxt" width=20>$j</td>
	<td class="mainTxt"><a href="profile.php?x={$info->login}">$login</a></td>
	<td align="center" class="mainTxt" width=150>$type</td>
	<td align="center" class="mainTxt" width=150>$Email</td>
ENDHTML;


  }


  if($_GET['s'] == "online" && $data->level & 0x80)
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  else if($_GET['s'] == "online")
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  else if($_GET['s'] == "admin")
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE `level` & 0x80 AND UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 ORDER BY `login` LIMIT $begin,30");
  else if($_GET['s'] == "search") {
    $dbres				= mysql_query("SELECT `id` FROM `users` WHERE `login` LIKE '{$_GET['q']}' ORDER BY `login`");
    $_GET['q']				= preg_replace('/%/','*',$_GET['q']);
  }
  else
    $dbres				= mysql_query("SELECT id FROM `users`");
  print "</table>\n\n<table width=100%>\n  <tr><td class=\"mainTxt\" align=\"center\">";
  if(mysql_num_rows($dbres) <= 30)
    print "< 1 ></td></tr></table>\n";
  else {
    if($begin/30 == 0)
      print "<< ";
    else
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/30-1) ."\"><<</a> ";


    for($i=0; $i<mysql_num_rows($dbres)/30; $i++) {
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=$i\">". ($i+1) ."</a> ";
    }


    if($begin+30 >= mysql_num_rows($dbres))
      print ">> ";
    else
      print "<a href=\"memberlist.php?s={$_GET['s']}&q={$_GET['q']}&p=". ($begin/30+1) ."\">>></a>";
  }


  $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  $online				= mysql_num_rows($dbres);
  $dbres				= mysql_query("SELECT `id` FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300");
  $anonymous				= mysql_num_rows($dbres);
?>
</table>
<table width=100%>


  </tr>
</table>

Toon Meer

de lijn is gemarkeerd

mvg, AeroXbird :cheer:

AeroXbird

dat had ik al gedaan
geen van alle dingen die worden gezegt werken ik krijg nog steeds maar de informatie van één user te zien terwijl ik er 2 zou moeten zien

Nieuwe reactie samengevoegd met originele reactie op 28.11.09 14:49:08:
hierbij even mijn nieuwe code die nu helemaal niemand laat zien:

PHP

$dbres                = mysql_query("SELECT * FROM `users` ORDER BY `type`");
  $data				= mysql_fetch_object($dbres);


print "
<br>
<table width=100% border=\"0\">";






print <<<HTML


<table width=100% border="1">


  <tr>
    <td class="content" style="letter-spacing: normal;" width=20>-</td>
    <td class="subTitle" style="letter-spacing: normal;" width=20><b>#</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center"><b>Name</a></b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><b>Type</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><b>Email</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><b>IP</b></a></td>
	  <tr>
HTML;
while ($info = mysql_fetch_array($dbres)) 
{


	print <<<HTML
	  <td align="center" class="content" width=20><input type="radio" name="radio"></td>
	  <td align="center" class="mainTxt" width=20>{$info->id}</td>
	<td align="center" class="" width=100>{$info->login}</a></td>
	<td align="center" class="" width=150>{$info->type}</td>
	<td align="center" class="" width=100>{$info->email}</td>
	<td align="center" class="content" width=100>{$info->ip}</td>
HTML;


}
	print <<<HTML
	</table>
HTML;
    
    if($_POST['wijzig'])
    {
        $sql = "UPDATE `user` SET `type` = '".$_POST['status']."' WHERE `id` = '".$id."'";
        mysql_query($sql) or die(mysql_error());
    }
    
    else
    {
        echo "<form action=\"\" method=\"post\">";
        echo "Je hebt de member met ID nr. ".$id." en<br> als rank ".ucfirst($rank)." geselecteerd<br><br>";
        echo "Rank <select name=\"status\" style=\"width:50px;\">
                        <option value=\"".$rank."\">&nbsp;</option>
                        <option value=\"a\">a</option>
                        <option value=\"m\">m</option>
                        <option value=\"n\">n</option>
                    </select><br>
        ";
        echo "<input type=\"submit\" name=\"wijzig\" value=\"Wijzig Rank\">";
        echo "</form>";
    }
	print "


</td>


</p>
</table>";

Toon Meer

AeroXbird

nog steeds niet, hij laat steeds 1 account zien thats it

AeroXbird

Hallo criminalspoint, de laatste tijd ben ik bezig met mijn site en ik wil nu de mogelijkheid om mensen hun type(rank) te kunnen bewerken

PHP

$dbres				= mysql_query("SELECT * FROM `users` ORDER BY `type` DESC LIMIT 0,5");
  $data				= mysql_fetch_object($dbres);


print "
<br>
<table width=100% border=\"0\">";






print <<<HTML


<table width=100% border="1">


  <tr>
    <td class="content" style="letter-spacing: normal;" width=20>-</td>
    <td class="subTitle" style="letter-spacing: normal;" width=20><b>#</b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center"><b>Name</a></b></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=150><b>Type</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><b>Email</b></a></td>
	<td class="subTitle" style="letter-spacing: normal;" align="center" width=100><b>IP</b></a></td>
	  <tr>
HTML;
	  for($data->id=$begin+1; $info = mysql_fetch_object($dbres); $data->id++) {
    $login				= $info->login;
    $type				= Array("","Registered","Member","VIP","Mod","Admin");
    $type				= $type[$info->type];
    $id					= $info->id;
	$email				= $info->email;
	$ip					= $info->ip;
	
	print <<<HTML
	  <td align="center" class="content" width=20><input type="radio" name="radio"></td>
	  <td align="center" class="mainTxt" width=20>{$id}</td>
	<td align="center" class="" width=100>{$login}</a></td>
	<td align="center" class="" width=150>{$type}</td>
	<td align="center" class="" width=100>{$email}</td>
	<td align="center" class="content" width=100>{$ip}</td>
HTML;
	}
	print <<<HTML
	</table>
HTML;
    
    if($_POST['wijzig'])
    {
        $sql = "UPDATE `inlogsysteem` SET `status` = '".$_POST['status']."' WHERE `id` = '".$id."'";
        mysql_query($sql) or die(mysql_error());
    }
    
    else
    {
        echo "<form action=\"\" method=\"post\">";
        echo "Je hebt de member met ID nr. ".$id." en<br> als rank ".ucfirst($rank)." geselecteerd<br><br>";
        echo "Rank <select name=\"status\" style=\"width:50px;\">
                        <option value=\"".$rank."\">&nbsp;</option>
                        <option value=\"a\">a</option>
                        <option value=\"m\">m</option>
                        <option value=\"n\">n</option>
                    </select><br>
        ";
        echo "<input type=\"submit\" name=\"wijzig\" value=\"Wijzig Rank\">";
        echo "</form>";
    }
	print "


</td>


</p>
</table>";

Toon Meer

nu moet ik alle spelers kunnen laten zien en eentje selecteren, zodra ik op hun radio knopje druk zou ik dan hun type moeten kunnen bewerken maar nu heb ik het probleem dat hij niet alle spelers laat zien, hij zou door de spelers moeten loopen en laten zien maar dat doet hij helaas niet daarom vraag ik jullie hulp

mvg, AeroXbird

AeroXbird

sorry, ik heb zelf in de tussentijd het probleem al opgelost :$ maar dankzij een paar "fixes" ben ik er zelf achter gekomen dus toch nog bedankt!

:slotje: graag dan maar

AeroXbird

ik probeer het nu op een andere manier, door de captcha te checken als hij FOUT is en op verzoek post ik hierbij mijn volledige code: http://pastebin.com/d6f5c5030

AeroXbird

AeroXbird

nee helaas niet, krijg nu een fout bij:

PHP

elseif($dead == true){

maar je sluit de if af waarbij alles goed is gelijk voor mijn captcha check af dus dan kan de query ook niet gestart worden

AeroXbird

dat klopt,
het probleem ligt onder :

PHP

print 'CAPTCHA PASSED!';

die else dus

AeroXbird

hallo criminalspoint, ik ben de laatste tijd bezig met een captcha script maar het lukt me nu niet echt om de verificatie in te voeren

PHP

else{
   //request everything
   $dead = false; //We make 'dead' if some fields are not filled in don't check for pass and name in db.
   $message = "<font face=verdana size=1>Pleas fill in all fields correctly:<br>";
   $username = $_POST['name'];
   $pass1 = $_POST['pass1'];
   $pass2 = $_POST['pass2'];
   $email = $_POST['email'];
   $ip = $_SERVER['REMOTE_ADDR'];
   $type = '1'; // level 1 = Non-official member | Level 2 =  Member | level 3 = Forum Mod | level 4 = ingame/forum moderator | level 5 = Administrator both ingame and forum |
   //begin search for errors
   if(strlen($username) <= 1 or strlen($username) >=15){
      $dead = true;
      $message = "Username (2-14)<br>";
   }
   if (strlen($email) < 6 or strlen($email) > 70){
   $dead = true;
   $message = 'U need to fill in an e-mail!';
   }
   if(strlen($pass1) < 6 or strlen($pass1) > 20 or $pass1 !== $pass2) {
      $dead = true;
      $message = "Password (6-20) or passwords does not match";
   }
   
   if($dead == false and md5($_POST['norobot']) == $_SESSION['randomnr2']){
      $username = strtolower(trim(strip_tags($username)));
      $pass1 = trim($pass1);
      $pass1 = md5($pass1);
      $query = mysql_query("SELECT * FROM users WHERE login ='$username'");
      $aantalrijen = mysql_num_rows($query);  
	  print 'CAPTCHA PASSED!';
	  else{
	  print 'Bad captcha, try again';
	  }
      if($aantalrijen == 1){         
         print "<font face=verdana size=1>Sorry, that username already exists.";         
      }
      else{
         $query1 = "INSERT INTO users(login, pass, ip, type, signup, email) VALUES ('$username','$pass1', '$ip','$type', 'NOW()', '$email')";
		 $query = mysql_query($query1) or die (mysql_error());
         if($query){
             print "<font face=verdana size=1>Welcome to The EXF clan, soon an admin of the clan may promote u to real member!<br><a href=login.php>Login now!</a>";
         } 
		 
   }
}     
elseif($dead == true){
         print $message;
   }        
}

Toon Meer

Error:

PHP

Parse error: syntax error, unexpected T_ELSE in /var/www/exfclan.nl/htdocs/beta/register.php on line 195

het script MOET checken of de captcha goed is, dan mag de query worden gestart, is de captcha fout, word er een foutmelding weergeven en de query NIET uitgevoerd

ik hoop dat jullie mij kunnen helpen 8-|
mvg,
AeroXbird

AeroXbird

Het werkt danku!
slotje graag

AeroXbird

je bedoelt het hele script neem ik aan(niet schrikken het is een zooitje en heel instabiel :P) :

PHP

<?php
session_start();
include('_include-config.php');
?>
<?
echo <<<HTML


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >




<head>
	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
	<meta name="author" content="ClanTemplates" />
	<meta name="keywords" content="Clan" />
	<meta name="description" content="Extreme 'n Freeroamin' " />
	<meta name="robots" content="all" />
	<title>[EXF]Extreme Freeroam Clan - Extreme 'n Freeroamin'</title>


	<style type="text/css" title="currentStyle" media="screen">
		 @import "style/stylesheet.css";
		 link rel="Shortcut Icon" type="image/x-icon" href="images/games/cod4.png" /
	</style>
	<script type="text/javascript"><!--//--><![CDATA[//><!--
	/* sfHover Function */
		hover = function() {
			var sfEls = document.getElementById("navigation").getElementsByTagName("LI");
			for (var i=0; i<sfEls.length; i++) {
				sfEls[i].onmouseover=function() {
					this.className+=" hover";
				}
				sfEls[i].onmouseout=function() {
					this.className=this.className.replace(new RegExp(" hover\\b"), "");
				}
			}
		}
		if (window.attachEvent) window.attachEvent("onload", hover);
	//--><!]]></script>
	<!--link rel="Shortcut Icon" type="image/x-icon" href="images/favicon.ico" /-->	
</head>
<body>


<div id="container">


	<div id="page-header">
		<div class="headerbar">
			<form method="post" action="">
				<fieldset id="forumlogin">
					<legend><span>Site Login</span></legend>
HTML;


  print <<<HTML
<a href="login.php"><b>Login</b></a>&nbsp;<a href="#" onmouseover="return overlib('U can login by clicking this link<br><b>Note: if u do not have an account please use register before u use login ;)</b><br>');" onmouseout="return nd();"><img border="0" src="images/icons/information.png" /></a>|&nbsp;
					<a href="register.php"><b>Register</b></a>&nbsp;<a href="#" onmouseover="return overlib('With this link u can register yourself to the site to be able use some badass functions!<br><b>Note: if u register  it does not mean u are an EXF member!</b>');" onmouseout="return nd();"><img border="0" src="images/icons/information.png" /></a>
					
				</fieldset>
			</form>
		</div>
	</div>
	
	<div id="wrapper">
		<div id="banner">
			<span class="corners-top"><span></span></span>
			 <h1 id="logo"><a href="#" title="ExTreme FreeRoam">EXF</a></h1> 
			<span class="corners-bottom"><span></span></span> 
		</div>
		<ul id="navigation">
			<li class="btn-homepage"><a href="index.php" title="Homepage">Homepage</a></li>
			<li class="btn-clannavigation">
				<a href="#" title="Clan Navigation">Clan Navigation</a>
				<ul class="dropdown">
					<li class="first"><a href="members.php" title="Members">Members</a></li>
					<li class="first"><a href="signup.php" title="Signup">Join!</a></li>
					<li class="first"><a href="history.php" title="history">History</a></li>


				</ul>				
			</li>
			<li class="btn-community"><a href="PHPBB3" title="Boards">Boards</a></li>
			<li class="btn-sponsors"><a href="#" title="Sponsors">Sponsors</a></li>
			<li class="btn-contact"><a href="#" title="Contact">Contact</a></li>
		</ul>


		<div id="main">
			<div id="content">
			<div class="article">
			
					<h4 class="headline"><a href="" title="Latest">Log-In</a></h4>
					<span class="postdate" title="LogIn">in <em>Log</em></span>
					<span class="author"> <a href="" title="user">{$author}</a></span>			
					<div class="story">
					<P>
					


<font face=verdana size=1>
HTML;




if($_SESSION['login'] == "true"){
   print " You already have an account."; //because your logged in stupid
}


include('_include-config.php');
if(!isset($_REQUEST['submit'])){
?>
<form method=post action="<?php $_SERVER['PHP_SELF'] ?>">
<table>
   <tr>
      <td>
         <font face=verdana size=1>Username:</font>
      </td>
      <td>
         <input type="text" name="name" maxlength="15">
      </td>
   </tr>
   <tr>
      <td>
         <font face=verdana size=1>Password:</font>
      </td>
      <td>
         <input type="password" name="pass1" value="<?$login?>">
      </td>
   </tr>
   <tr>
      <td>
         <font face=verdana size=1>Password Confirm:</font>
      </td>
      <td>
            <input type="password" name="pass2">
      </td>
   </tr>
   <tr>
	   <td>
		  <font face="verdana" size=1>Email:</font>
	   </td>
	   <td>
		  <input type="text" name="email" maxlength="90">
       </td> 
   </tr>
   <tr>
      <td>
         <input type="submit" value=submit name="submit">
      </td>
      <td>
         <input type="reset" value="reset">
      </td>
   </tr>
</table>
</form>
<?php
}else{
   //request everything
   $dead = false; //We make 'dead' if some fields are not filled in don't check for pass and name in db.
   $message = "<font face=verdana size=1>Pleas fill in all fields correctly:<br>";
   $username = $_POST['name'];
   $pass1 = $_POST['pass1'];
   $pass2 = $_POST['pass2'];
   $email = $_POST['email'];
   $ip = $_SERVER['REMOTE_ADDR'];
   $type = '1'; // level 1 = Non-official member | Level 2 =  Member | level 3 = Forum Mod | level 4 = ingame/forum moderator | level 5 = Administrator both ingame and forum |
   //begin search for errors
   if(strlen($username) <= 1 or strlen($username) >=15){
      $dead = true;
      $message = "Username (2-14)<br>";
   }
   if (strlen($email) < 6 or strlen($email) > 70){
   $dead = true;
   $message = 'U need to fill in an e-mail!';
   }
   if(strlen($pass1) < 6 or strlen($pass1) > 20 or $pass1 !== $pass2) {
      $dead = true;
      $message = "Password (6-20) or passwords does not match";
   }
   if($dead == false){
      $username = strtolower(trim(strip_tags($username)));
      $pass1 = trim($pass1);
      $pass1 = md5($pass1);
      $query = mysql_query("SELECT * FROM users WHERE login ='$username'");
      $aantalrijen = mysql_num_rows($query);                   
      if($aantalrijen == 1){         
         print "<font face=verdana size=1>Sorry, that username exists already.";         
      }
      else{
         $query1 = "INSERT INTO users(login, pass, ip, type, signup, email) VALUES ('$username','$pass1', '$ip','$type', 'NOW()', '$email')";
		 $query = mysql_query($query1) or die (mysql_error());
         if($query){
             print "<font face=verdana size=1>Welcome to The EXF clan, soon an admin of the clan may promote u to real member!<br><a href=login.php>Login now!</a>";
         }   
   }
}     
elseif($dead == true){
         print $message;
   }        




print <<<HTML
					</p>
					</div>


				</div>
				
			</div>
			<div id="left-sidebar">
				<div class="block clan-roster">
					<h3 class="block-title"><span>Clan Roster</span></h3>
					<ul class="roster">
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
						<li><a href="#" title="Username" onmouseover="ctRoster('protek', 'Agressions');" onmouseout="ctRosterClean();"><img src="images/users/user.jpg" alt="Username" /></a></li>
					</ul>
					<div id="user-name"><span id="namebox">Hover over a member</span></div>
				</div>
								<div class="block control-panel">
				<h3 class="block-title"><span>Control Panel</span></h3>
				<ul class="roster">
HTML;
 $dbres				= mysql_query("SELECT * FROM `users`");
  $data				= mysql_fetch_object($dbres);
  $username = $_SESSION['username'];


						if ($_SESSION["login"] == "true"){
						print "<b><font size=\"1\">Welcome,";
						if ($data->type == 2 or $data->type == 3 or $data->type == 4 or $data->type == 5) {
						print "
						<font color=\"red\">[EXF]{$username}</font></b></font><br>";
						}
						else{
						print "
						<font color=\"red\">{$username}</font></b></font><br>";
						}
						
						print "<b><font size=\"1\">NOTICE THIS PANEL IS NOT DONE YET!</b></font><br>";
						print "<b><font size=\"1\"><a href=\"memberlist.php\">Memberlist!</font></a></b><br>";
						if ($data->type == 5) {
						print "<br><b><h3>Admin Controls:</b></h2>";
						print "<b><font size=\"1\"><a href=\"admin-news.php\">Manage news items!</a></font></b><br>";
						print "<b><font size=\"1\"><a href=\"admin-type.php\">Manage users levels</a></font></b><br>";
						}
						print "<br><b><a href=\"logout.php\">Logout</a></b>";


						}
						
						else{
						print "<b><font color=\"red\" size=\"1\">u are NOT logged in.</b></font><br>";
						print "<p><b><font size=\"1\">Please login to use this control panel!</b></font></p><br>";
				}
				
				?>


				</ul>
				</div>
			</div>
			<div id="right-sidebar">
				<div class="block head-sponsor">
					<h3 class="block-title"><span>Head Sponsor</span></h3>
					<div class="sponsor-image"><a href="#" title="ClanTemplates.com"><img src="images/sponsors/clantemplates.png" alt="ClanTemplates.com" /></a></div>
					<div class="sponsor-image"><a href="http://www.busign.nl/" title="Busign"><img src="images/sponsors/busign.png" alt="Busign I.S" /></a></div>
				</div>
			</div>
			<div id="footer">
				<div class="copyright">
					<p>Copyright 2009 Extreme Freeroam Clan</p>
					<p>&copy; All Rights Reserved</p>
				</div>
			</div>
		</div>
	</div>
	
</div>


<script type="text/javascript" src="scripts/iepngfix_tilebg.js"></script>
<script type="text/javascript" src="scripts/roster.js"></script>


</body>
</html>

Toon Meer

alstu

AeroXbird

sorry, ik lig nog half in bed

PHP

Parse error: syntax error, unexpected $end in /var/www/exfclan.nl/htdocs/beta/register.php on line 280

ik heb er wat aan gesleuteld en nu krijg ik een $end error ik ben ergens een } vergeten denk ik, maar waar?

AeroXbird

hallo, criminalspoint
ik heb nu alweer een probleem:

PHP

else{
   //request everything
   $dead = false; //We make 'dead' if some fields are not filled in don't check for pass and name in db.
   $message = "<font face=verdana size=1>Pleas fill in all fields correctly:<br>";
   $username = $_POST['name'];
   $pass1 = $_POST['pass1'];
   $pass2 = $_POST['pass2'];
   $email = $_POST['email'];
   $ip = $_SERVER['REMOTE_ADDR'];
   $type = '1'; // level 1 = Non-official member | Level 2 =  Member | level 3 = Forum Mod | level 4 = ingame/forum moderator | level 5 = Administrator both ingame and forum |
   //begin search for errors
   if(strlen($username) <= 1 or strlen($username) >=15){
      $dead = true;
      $message = "Username (2-14)<br>";
   }
   if (strlen($email) < 6 or strlen($email) > 70){
   $dead = true;
   $message = 'U need to fill in an e-mail!';
   }
   if(strlen($pass1) < 6 or strlen($pass1) > 20 or $pass1 !== $pass2) {
      $dead = true;
      $message = "Password (6-20) or passwords does not match";
   }
   if($dead == false){
      $username = strtolower(trim(strip_tags($username)));
      $pass1 = trim($pass1);
      $pass1 = md5($pass1);
      $query = mysql_query("SELECT * FROM users WHERE login ='$username'");
      $aantalrijen = mysql_num_rows($query);                   
      if($aantalrijen == 1){         
         print "<font face=verdana size=1>Sorry, that username exists already.";         
      }
      else{
         $query1 = "INSERT INTO users(login, pass, ip, type, signup, email) VALUES ('$username','$pass1', '$ip','$type', 'NOW()', '$email')";
		 $query = mysql_query($query1) or die (mysql_error());
         if($query){
             print "<font face=verdana size=1>Welcome to The EXF clan, soon an admin of the clan may promote u to real member!<br><a href=login.php>Login now!</a>";
         }   
   }
}     
elseif($dead == true){
         print $message;
   }

Toon Meer

ik krijg steeds een elseif error op de lijn waar

PHP

elseif($dead == true){
         print $message;
   }

staat

ik hoop snel een reactie te krijgen 8-|

mvg, AeroXbird

AeroXbird

ik sta versteld van de snelheid van reageren hier, en hoe snel het gefixt is ik was namelijk aan het reageren op jannick zijn post toen darsstar en net voor reageerde en de code die darsstar gaf werkte en samen met jannick zijn code zit er ook nog een kleine beveiliging op bedankt! admins slotje graag

AeroXbird

wauw, dat is vreselijk snel met antwoorden, maar helaas werkt geen van bijde fixes ik heb de remove tussen haakjes gezet (") en de code vervangen door die jij hebt gepost maar nog geen resultaat

mvg, AeroXbird

AeroXbird

hallo criminalspoint, ik ben misschien een newb hier maar omdat criminalsfanaat gefuseerd is (helaas wel) heb ik me hier maar aangemeld, maar om terug te komen op het punt hier is het problematische stuk script:

PHP

elseif ($page == remove) {
    $dbres2				= mysql_query("SELECT * FROM `news` ORDER BY `id` DESC LIMIT 0,5");
  $data2				= mysql_num_rows($dbres2);
if (!isset($_POST['stuur'])) {
while ($row = mysql_fetch_array($dbres2)) {


   $id = $row['id'];
 $text = $row['text'];
 $author = $row['poster'];
 $type = $row['type'];
echo <<<HTML
<td class="story"><p>
<form action="admin-news.php?p=remove" method="post">
<br>
ID:
<input type="radio" name="radio" value="{$id}"/>{$id}&nbsp;&nbsp;&nbsp;&nbsp;Message:&nbsp;&nbsp;
HTML;
if ($type == 3) {
echo "<b><font color=\"red\">{$text}</b></font>";
					}
elseif ($type == 2){
echo "<b>{$text}</b>";


					}
elseif ($type == 1) {
echo "<p>{$text}</p>";


					}
echo "
<BR><BR>";
}


echo <<<HTML
<input type="submit" name="stuur" value="Delete">
</form>
</td>
</p>
HTML;
}
else{


    $query = "DELETE FROM `news` WHERE `id`='$id'"; 
    mysql_query($query) or die (mysql_error());
   echo '<b>Message successfully removed</b>';
	
}


exit;


}

Toon Meer

note: DIT IS ALLEEN EEN DEEL VAN HET SCRIPT
de problematische lijn is de query onderaan elke keer als ik een bericht probeer te verwijderen krijg ik netjes het bericht Message successfully removed maar als ik kijk op de homepage en op de remove pagina zelf staat het bericht er nog bij, ik denk persoonlijk dat het probleem de $id is maar het enige is ik zou echt niet weten hoe ik dit moet oplossen.

mvg, AeroXbird

AeroXbird

De layout opzicht ziet er wel goed uit maar de layout misvormd zich steeds als ik een link aanklik dit zal denk ik niet aan mij liggen want ik gebruik de laatste firefox

ICTscripters

Dé plek voor IT

Dé plek voor IT

Beta-testers gezocht voor Crypto-oefenplatform

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

350 Nieuwe Domeinnamen Januari 2026

321 Nieuwe Domeinnamen December 2025

Meerdere mafia game template te koop

Posts by AeroXbird

Memberlist

Memberlist

Memberlist

Type bewerken

Type bewerken

Type bewerken

captcha...

captcha...

captcha...

captcha...

captcha...

Probleempje :|

Probleempje :|

Probleempje :|

Probleempje :|

Probleem nieuws systeem

Probleem nieuws systeem

Probleem nieuws systeem

Hoeveel is deze site waard?

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2