Member Mangement

[Jack!]

I'm looking for a script that can help me;

What I need is a script, where I can add a list of members to the system, and add notes to there account, and also there rank.

I also need to be able to allow a certain amount of accounts for logins (About 3) It all needs to be able to be edited from the panel (accounts, members, notes and ranks)

Anyone know any free scripts that can do this, dont need to be majorly secure.

[Sam]

Umm if i have a spare few hours this evening i'll try and whip something up. If i do, you'll have it for morning :)

Am i right in assuming you just want a database with 3 fields. Member Name, Notes, Rank. Then have a login for 3 or more users who can add new people to the list?

[Jack!]

Umm if i have a spare few hours this evening i'll try and whip something up. If i do, you'll have it for morning :)

Am i right in assuming you just want a database with 3 fields. Member Name, Notes, Rank. Then have a login for 3 or more users who can add new people to the list?

Yeah, they can add new people and edit the existing.

[Sam]

Finished the script last night but I'm about to get a 5 hour train so will pm you it when I get in :)

[Jack!]

Finished the script last night but I'm about to get a 5 hour train so will pm you it when I get in :)

Okay, thank you.

[Sam]

Finished and PM'd.

[Jack!]

Would it be possible to add to things, please?

I know there really simple to add, but I havent looked through your code and how you do it soo.

Would it be possible to have a page to show members, listed from highest rank to lowest? Show username, rank and notes, nothing else.

And have 7 ranks? instead of 3?

[Sam]

Yeah will add them now quick :)

[Jack!]

Yeah will add them now quick :)

Thanks :)

[Sam]

Revised members database:



-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 28, 2011 at 02:47 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `minithing`
--

-- --------------------------------------------------------

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`membername` varchar(25) NOT NULL,
`notes` text NOT NULL,
`rank` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `members`
--




New files viewmembers.php: ( I havent put it in a table, figured i'd leave you to arrange it to suit your layout )



<?php

////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////// Created by Sam of HbxF
////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////

session_start();

if(isset($_SESSION['username'])) {

include ("connect.php");

$display = mysql_query ("

SELECT * FROM members ORDER BY rank

");

$check = mysql_num_rows($display);

if ($check != 0) {

while ($row = mysql_fetch_array($display)) {

$dbmembername = $row['membername'];
$dbnotes = $row['notes'];
$dbrank = $row['rank'];

echo "
<b><u>Member Name:</b></u><br/>" .$dbmembername. " <br/>
<b><u>Notes:</b></u><br/>" . $dbnotes . " <br/>
<b><u>Rank:</b></u><br/>" . $dbrank ."<br/>
";
}
}
else { echo "There are no users to display!";

}

echo " <a href='panel.php'>Click Here to go Back!</a>";

}

else
die ("You are not logged in! <a href='index.php'>Click Here to Log In!</a>");




?>


Revised Panel.php:



<?php

////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////// Created by Sam of HbxF
////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////


session_start();

if(isset($_SESSION['username'])) {

$username = $_SESSION['username'];

echo "Hello there, ".$username."!";
echo "<br/><br/>What can we do for you today?<br/><br/>";
echo "<a href='addmember.php'>Add a Member</a><br/>
<a href='editmember.php'>Edit a Member</a><br/>
<a href='viewmembers.php'>View All Members</a><br/>
<a href='registeradmin.php'>Register an Admin</a><br/>
<a href='changepassword.php'>Change Password</a><br/>
<br/>
<a href='logout.php'>Logout</a>



";


}

else {

die("You need to be logged in to view this page!");


}

?>


Think thats all, i did it at like 2am whilst half asleep so let me know if any issues.