[BC3] (subteam) IP registratie formulier - Dutch Power Cows

dinsdag 3 april 2001 09:38

Acties:

greedy as a pig

Topicstarter

Hoi Mede DPC''ers, op een regenachtige middag (niet vandaag:)) heb ik eens ooit een scriptje geschreven voor de registratie van IP''s van ons subteam..

Zoals menig pproxy beheerder wel weet is het mogelijk ipv hostnamen Nicknames te gebruiken zodat je mooie subteam stats kan maken. Nou is de registratie van al die IP adressen best lastig, helemaal met dynamische IP''s.

Om dit een stukje makkelijker te maken ben ik ff in PHP bezig geweest:<pre style="font-size: 10pt; font-family: verdana; margin-top: 0px; margin-left: 25px; margin-bottom: 0px;">php:<hr><code>
<?
<html>

<head>

<meta http-equiv="Content-Language" content="en-us">

<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">

<title>TFS Hostname Editor</title>

</head>

<body>

<?php

$Err_Mes = "";

$scriptname = "tfshostnames.php";

$teamname = "Team Frikandel Speciaal";

$dbname = "";

$host = getenv("REMOTE_ADDR");

$host2 = strtolower($host);

$link = mysql_connect("localhost", "", "")

 or die ("Could not connect to database");

mysql_select_db($dbname, $link) or die("Can''t open database");

if ((!ereg("^[A-Za-z0-9_ ]+$", $Login_Name)) AND $Login_Name)

{

 $Login_Name="";

 $Err_Mes = "Name contains illegal characters.";

}

if ((!ereg("^[A-Za-z0-9_ ]+$", $Login_Password)) AND $Login_Password)

{

 $Login_Password="";

 $Err_Mes = "Password contains illegal characters.";

}

if ((!ereg("^[A-Za-z0-9_ ]+$", $NickName)) AND $NickName)

{

 $NickName="";

 $Err_Mes = "Nick contains illegal characters.";

}

if ((!ereg("[A-Za-z0-9_-]+([\.]{1}[A-Za-z0-9_-]+)*@[A-Za-z0-9-]+([\.]{1}[A-Za-z0-9-]+)+",$New_Email)) AND $New_Email)

{

 $New_Email="";

 $Err_Mes = "Email address contains illegal characters.";

}

if(!$HTTP_POST_VARS["btRegister"])

{

$results = mysql_query("SELECT * FROM users WHERE BINARY users.name = ''$Login_Name'' AND BINARY users.password = ''$Login_Password''");

$UserNamePassword = mysql_num_rows($results);

If ($UserNamePassword)

{

 $myrow = MySQL_fetch_array($results);

 $nr = $myrow["nr"];

 $nick = $myrow["nick"];

 $admin = $myrow["admin"];

 if ($HTTP_POST_VARS["btSendNick"] AND ($NickName))

 {

 $results = mysql_query("UPDATE users SET users.nick = ''$NickName'' WHERE users.nr = ''$nr''");

 $nick = $NickName;

 }

 if ($HTTP_POST_VARS["btAddHost"] AND (($IP) OR ($UseCurrentIP)))

 {

 if ($UseCurrentIP)

 {

 $IP = $host2;

 }

 if (ereg("^([0-9]{1,3}\.)([0-9]{1,3}\.)([0-9]{1,3}\.)([0-9]{1,3})?$", $IP, $regs) AND ($regs[1]<=255) AND ($regs[2]<=255) AND ($regs[3]<=255) AND ($regs[4]<=255))

 {

 $results = mysql_query("SELECT * FROM hostnames WHERE hostnames.ip = ''$IP''");

 $res = mysql_num_rows($results);

 if (!$res)

 {

 $results = mysql_query("INSERT INTO hostnames (nr, ip, usernr) VALUES ('''', ''$IP'', ''$nr'')");

 }

 else

 {

 $Err_Mes = "Someone else already uses this IP.";

 }

 }

 else

 {

 $Err_Mes = "Bad IP.";

 }

 }

 if (($HTTP_POST_VARS["btDelHost"]) AND ($HTTP_POST_VARS["R1"]))

 {

 $iptodel = $HTTP_POST_VARS["R1"];

 $results = mysql_query("DELETE FROM hostnames WHERE hostnames.nr = $iptodel");

 }

}

if ($HTTP_POST_VARS["btNewMem"])

{

 if (($Login_Name) AND ($Login_Password) AND ($New_Email))

 {

 $results = mysql_query("SELECT * FROM users WHERE users.name = ''$Login_Name''");

 $reszqs = mysql_num_rows($results);

 if (!$reszqs)

 {

 $results = mysql_query("INSERT INTO users (nr, name, password, nick, admin, email) VALUES ('''', ''$Login_Name'', ''$Login_Password'', ''$Login_Name'',''0'',''$New_Email'')");

 }

 else

 {

 $Err_Mes = "Someone else already uses this username.";

 }

 }

}

}

 /*SELECT [hosts].[ip], [users].[name] FROM users INNER JOIN hosts ON [users].[id] =[hosts].[userid];*/

 if ($HTTP_POST_VARS["btShowAll"])

 {

 $results = mysql_query("SELECT hostnames.ip, users.nick FROM users INNER JOIN hostnames ON users.nr = hostnames.usernr");

 while($myrow=MySQL_fetch_array($results))

 {

 $hostip=$myrow["ip"];

 $hostname=$myrow["nick"];

 Echo $hostip.",".$hostname.",".date("d-m-Y")." ";

 }

 }

 Else

 {

 Echo ''<form method="POST" action="''.$php_self.''">'';

 Echo ''<table border="0" cellspacing="1" bgcolor="#F0F0FF">

 <tr><td width="15"> </td><td>''.$teamname.''\''s hostname editor</td><td width="15"> </td></tr>

 <tr><td width="15"> </td><td>'';

 if (!$HTTP_POST_VARS["btRegister"])

 {

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="596" bgcolor="#DEDCD0">Welcome ''.$Login_Name.''</td></tr>

 <tr><td width="596" bgcolor="#DEDCD0"><input type="text" name="Login_Name" size="40" tabindex="1" value = "''.$Login_Name.''">Name</td></tr>

 <tr><td width="596" bgcolor="#DEDCD0"><input type="password" name="Login_Password" size="40" tabindex="2" value = "''.$Login_Password.''">Password</td></tr>

 <tr><td width="596" bgcolor="#DEDCD0"><input type="submit" value="Login" name="btLogin" tabindex="3"></td></tr>

 </table><HR>'';

 If ($UserNamePassword)

 {

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="100%" bgcolor="#DEDCD0">Current IP : ''.$host2.''</td></tr>

 </table><HR>'';

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="100%" bgcolor="#DEDCD0">Edit your nickname</td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0"><input type="text" name="NickName" size="40" tabindex="4" value = "''.$nick.''"><input type="submit" value="Update" name="btSendNick" tabindex="5"></td></tr>

 </table><HR>'';

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="100%" colspan = 3 bgcolor="#DEDCD0">IP</td></tr>'';

 $results = mysql_query("SELECT * FROM hostnames WHERE hostnames.usernr = ".$nr." ORDER BY hostnames.nr ASC");

 while($myrow=MySQL_fetch_array($results))

 {

 $hostip=$myrow["ip"];

 $hostnr=$myrow["nr"];

 Echo ''<tr><td width="634" bgcolor="#DEDCD0">''.$hostip.''</td><td width="78" bgcolor="#DEDCD0" align="center"><input type="radio" name="R1" value="''.$hostnr.''"></td></tr>'';

 }

 Echo ''<tr><td width="634" bgcolor="#DEDCD0">Click the IP to delete</td><td width="78" bgcolor="#DEDCD0" align="center"><input type="submit" value="Del Host" name="btDelHost" tabindex="7"></td></tr>'';

 Echo ''</table><HR>'';

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="100%" bgcolor="#DEDCD0">Add an IP</td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0"><input type="text" name="IP" size="15" maxlength="15" tabindex="8"></td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0">Or use the name & IP from the computer I am currently working on</td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0"><input type="checkbox" name="UseCurrentIP" value="ON" tabindex="9">(use current IP)</td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0"><input type="submit" value="Add Host" name="btAddHost" tabindex="10"></td></tr>

 </table>'';

 if ($admin)

 {

 Echo ''<HR>'';

 Echo ''<table border="0" width="600" cellspacing="1">

 <tr><td width="100%" bgcolor="#DEDCD0">View all IP\''s</td></tr>

 <tr><td width="100%" bgcolor="#DEDCD0"><input type="submit" value="Show All" name="btShowAll" tabindex="11"></td></tr>

 </table>'';

 }

 }

 Echo ''<table border="0" width="600" cellspacing="1">

&n

..so be wary of any man who keeps a pig farm..

dinsdag 3 april 2001 09:38

Acties:

Verwijderd

Kun je misschien een downloadbare versie ergens neerzetten ?

Met knippen en plakken verkloot ie de hele boel

dinsdag 3 april 2001 09:38

Acties:

RobzQ

greedy as a pig

Topicstarter

Check :
http://members.brabant.chello.nl/~r.geerings00/hostnames.zip

..so be wary of any man who keeps a pig farm..

dinsdag 3 april 2001 09:38

Acties:

mythor

Held in opleiding

goed iedee, al is het al eerder gedaan.

ik vind je source wel een beetje erg omslachtig hoor

What you say?!

dinsdag 3 april 2001 09:38

Acties:

RobzQ

greedy as a pig

Topicstarter

Op dinsdag 03 april 2001 00:10 schreef mythor het volgende:
goed iedee, al is het al eerder gedaan.
ik vind je source wel een beetje erg omslachtig hoor

Als je de code korter/beter wil maken, be my guest

..so be wary of any man who keeps a pig farm..