PHP - Server Management Software

Okay, well for a site i want to make a user managment system. but i have no idea how to.
ive already got the part where you type the user that you want to manage.

Code: [Select]
<?php 
/*
    Copyright (C) 2009  Murad <Murawd>
                  Josh L. <Josho192837>

    This program is free softwa  you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/

// Must rewrite
?>
   <fieldset>
      <legend>
         Manage User
      </legend>
      <table border='0' style="height:100%;width:570px;border:solid 1px #BBB">

      <tr class="navtitle" style="height:25px">

         <th style="width:auto">Manage A User</th>

      </tr>

      <tr>

         <td align="center" class="tdbox">

            Search for the profile name you wish to manage.

         </td>

      </tr>

      <tr>

         <td align="center">

            <form method="post" action=''>

               <input type="text" name="name" />

               <input type="submit" name="search" value="Search" />

            </form>

         </td>

      </tr>

      <tr style="height:25px">

         <td class="tdbox">

            <span style="float:left">

               <a href="?cype=admin">Back To Administration Control Panel</a>

            </span>


         </td>

      </tr>

   </table>

   </fieldset>
But thats just to find the user you want to edit, i want to make it so i can edit there name, how much money and such they have. instead of going into the db.

so if you could help or if you need more info just ask. i dont really no much to put up here.

Before reading: I already have a system in place for inventory management. I use it with a rpg_items database with a field called 'item_slot', etc and it works wonderfully.

My issue is. I think it would be intuitive if I were to store a basic 20 slot 0 iteration in a field under the users table for each character. So I can just check against that, instead of querying the whole rpg_user_items table, (which will have thousands, hundreds of thousands of users items) to just check if a user's inventory is full, that is not intuitive. I'd rather just check if a field name has no open 0's instead with php. (This ofcourse will be updated dynamically upon a user moving their items to different slots).


Let's say I have this array, and it's stored in a field called userinventory in the users table:
 

0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0

This is pretty easy to read. there is 20 slots, 5 on reach row. That's 20 inventory slots a user has access to.

This is supposed to represent something like this:



I can store this in the MYSQL field as 'userinventory'.

Now, how do I go about dynamically each specific 0 (ZERO) in this Block? I'm going to call this a block.

I will need to label it accordingly.

Paint time.

Here u go



How do I use PHP to dynamically update a block like this based upon user input? (A 1, A 2, A3, B2, B1, etc)

To check if a user's inventory is full would be easy. I can just explode them by ',' and use count to see if it's greater than 20. My problem is about updating each individual block to represent a users inventory.

So, if there is a 1 there, an item would be there. That's all I'm trying to do.

I could ofcourse, create what 20 (5x4) if functions to place them at each individual block, but that wouldn't be intuitive and be extremely confusing.
Edited by Monkuar, 23 January 2015 - 09:08 PM.

I have a general knowledge of PHP. I was wondering if anybody knew of a script that when a user logs in, they have their own unique page setup, but it is the same page.

Basically so a client could log in and see the information about their purchase, or website construction etc.

Any scripts to build off of?
Thanks

The idea:
an authorized web user (novice) uploads an Excel spreadsheet via FTP to a website.
The spreadsheet contains 9 rows and 5 columns, which will look something like this:
12345 | sky | blue | sunny | happy |
-------------------------------------------
54321 | water | green | cold | sad |
-------------------------------------------
etc ...

The script I'm looking for would show the first 3 of the 9 rows at the same time and rotate to the next 3 on refresh and so on.

The output of the script would look something like this:

<div><p><a href="http://www.xyz.com/12345.html>;<img src="http://www.xyz.com/12345.jpg" /></a><br />
<strong>sky</strong><br />blue<br />sunny<br />happy</p><br />
<p><a href="http://www.xyz.com/12345.html">Details</a></p></div><br />
<div><p><a href="http://www.xyz.com/54321.html>;<img src="http://www.xyz.com/54321.jpg" /></a><br />
<strong>water</strong><br />green<br />cold<br />sad</p><br />
<p><a href="http://www.xyz.com/54321.html">Details</a></p></div>

etc...

the script structure would always be the same but the values of each div would change based on the row values of the spreadsheet.
Can this be done?

Hi all,

I'm starting an new project where I'm making an Incident Management System and right from the start I don't know what to do.
Could anyone get me on my way. I need to make a script where if I open a new incident the new page opens and automatically gets a new Incident number. This number is offcourse 1 number higher every time you make a incident.
I thought about make a column with autoincremetn and then query the highest number. Problem with that is when you open a page at multiple computers at the same time they get the same number.

Does anyone have an idea?

Ryflex

I was wondering if there's any common method for user management.  I'm not talking about basic stuff like DB management stuff I'm talking about registering new users with captcha, validating email addresses, password resets, etc.  I can work all this stuff out by hand but it seems rather large and very repetitious so I was wondering if there's guides out there to develop this or a common script?

Trying to a. check if dir exists if not create it, and b. save an uploaded file to that directory.  Nothing however is working but I'm pulling no errors, heres the code:



$test_pic = $_POST['test_pic'];
// I've also tried       $test_pic = $_FILES["test_pic"];     : with no success
if (is_uploaded_file($test_pic)) {
if (!file_exists("tests/uploads/" . $test_name . "/")) {
$create_test_folder = (mkdir("tests/uploads/" . $test_name));
if (!$create_test_folder) {
echo "cant create folder";
die;
}
}
$target_path = ("tests/uploads/" . $test_name . "/" . $test_name . "_1");
if (($_FILES["test_pic"]["type"] == "image/gif")
   || ($_FILES["test_pic"]["type"] == "image/jpeg")
 || ($_FILES["test_pic"]["type"] == "image/jpg")
 || ($_FILES["test_pic"]["type"] == "image/png")
 && ($_FILES["test_pic"]["size"] < 50000)) {
if (!copy($test_pic, $target_path)) {
echo "cant copy picture";
die;
}
} else {
echo "file type or size bad";
die;
}
}


and I understand its not at all public-safe but I'm just wanting to get it to work before I throw in the security.  Thanks for the help!

I'm going to MAKE this task very simple for you. I am just not that experienced with php yet to conquer this specific task.

Let me get you started with some examples of how easy the client side of this is.

Copy and paste this and run it as index.php on your dev server:
 

<script src="http://code.interactjs.io/interact-1.2.2.min.js"></script>
<script>
	function qs(expr){return document.querySelector(expr)}
</script>
<style>
.fadeIn{animation-name:fadeIn;-webkit-animation-name:fadeIn;animation-duration:.7s;-webkit-animation-duration:.7s;animation-timing-function:ease-in-out;-webkit-animation-timing-function:ease-in-out;visibility:visible!important}@keyframes fadeIn{0%{transform:scale(0);opacity:0}60%{transform:scale(1.1)}100%{transform:scale(1);opacity:1}}@-webkit-keyframes fadeIn{0%{-webkit-transform:scale(0);opacity:0}60%{-webkit-transform:scale(1.1)}100%{-webkit-transform:scale(1);opacity:1}}
.InventoryTest{
	border:1px solid #D3D3D3;border-bottom:0;width:24px;height:24px;float:left;padding:3px;border-right:0;
}
.itemdrag{position:relative;z-index:1}
 
.InventoryTest:nth-child(9n+9){
	border-right:1px solid #D3D3D3
}
.InventoryTest:nth-last-child(-n+9){
 border-bottom:1px solid #D3D3D3;
}
.itemdrag{position:relative;z-index:1}
</style>
	<?php 
		error_reporting(E_ERROR);
		//Display 63 boxes (Fits with the css nth-child tags to look pretty! lol)
		for($i = 1; $i < 64; $i++){
			if ($i == 1){ // Slot positions 1 Dimensions: 3x3 (lengthXwidth)
				$item1 = '<div class="itemdrag" item_id='.$i.' data-cslot='.$i.'><img src=http://i.imgur.com/3azYLNf.png></div>';
			}elseif($i==4){ // Slot position 2 Dimensions 2x1 lengthXwidth)
				$item1 = '<div class="itemdrag" item_id='.$i.' data-cslot='.$i.'><img src=http://i.imgur.com/l3y0W7d.png></div>';
			}else{$item1 = '';}
			
			

			$inventoryboxes .= '<div class="InventoryTest" data-slot='.$i.'>'.$item1.'</div>';
		}
	?>
	<div style="width:300px">
	<?php echo $inventoryboxes ?>
</div>

<script>
	
	  
// target elements with the "draggable" class
interact('.itemdrag')
  .draggable({
  
    // enable inertial throwing
    inertia: true,
	onstart: function (event) {
		
		},
 
    // call this function on every dragmove event
    onmove: function (event) {
      var target = event.target,
          // keep the dragged position in the data-x/data-y attributes
          x = (parseFloat(target.getAttribute('data-x')) || 0) + event.dx,
          y = (parseFloat(target.getAttribute('data-y')) || 0) + event.dy;

 
      // translate the element
	  target.style.position = "relative";
	  target.style.zIndex="2500";
      target.style.webkitTransform = target.style.transform ='translate(' + x + 'px, ' + y + 'px)';
	
 
 
      // update the posiion attributes
      target.setAttribute('data-x', x);
      target.setAttribute('data-y', y);
    },
    // call this function on every dragend event
    onend: function (event) {
	  var target = event.target;
 
		target.removeAttribute("style");
		target.removeAttribute("data-x");
		target.removeAttribute("data-y");
  
    }
  });
  
interact('.InventoryTest').dropzone({
	
	
  // only accept elements matching this CSS selector
  accept: '.itemdrag',
  // Require a 75% element overlap for a drop to be possible
  overlap: 0.40,

  // listen for drop related events:

  ondropactivate: function (event) {
  var draggableid = event.relatedTarget;
    // add active dropzone feedback
	// Is this and item that can be equipped?

	if (event.relatedTarget.getAttribute('item-type') != "Misc"){
	 //qs('#shadow'+draggableid.getAttribute('item-type')+'').style.display='none';
	}
		
	
	
	
    event.target.classList.add('drop-ACCEPT');
  },
  ondragenter: function (event) {
    var draggableElement = event.relatedTarget,
        dropzoneElement = event.target;

    // feedback the possibility of a drop
	

    dropzoneElement.classList.add('drop-target');
    draggableElement.classList.add('can-drop');
    //draggableElement.textContent = 'Dragged in';
  },
  ondragleave: function (event) {
    // remove the drop feedback style
	
    event.target.classList.remove('drop-target');
    event.relatedTarget.classList.remove('can-drop');
    //event.relatedTarget.textContent = 'Dragged out';
  },
  ondrop: function (event) {
	var dragid = event.relatedTarget;
	if (event.target.hasChildNodes()) {
	//console.log(event.target.childNodes[1]);
	return;
	}
	
	var slotp = event.target.getAttribute("data-slot");
	var slotp2 = event.relatedTarget.getAttribute("data-cslot");
	var shadowid = qs('#shadow'+dragid.getAttribute('item-type')+'');
	var item_id = event.relatedTarget.getAttribute("item_id"); // <-- The one being dragged
	
	//We need to show the shadow gear again.
	(shadowid) ? shadowid.style.display='inline-block': '';
	

	
 
	
	
	qs('[data-slot="'+slotp2+'"]').innerHTML='';
	qs('[data-slot="'+slotp+'"]').appendChild(event.relatedTarget);
	
	event.target.childNodes[0].setAttribute("data-cslot", slotp);
	
	//We do our ajax functions here, just log the information for now:
	console.log(" item_id="+item_id+"&slot_go="+slotp+"  ");
 
 
	
	
	event.relatedTarget.className += ' fadeIn';
	

	
	
	//console.log(event.relatedTarget);
	//console.log(event.target);
    //event.relatedTarget.textContent = 'Dropped';
  },
  ondropdeactivate: function (event) {
    // remove active dropzone feedback
    event.target.classList.remove('drop-ACCEPT');
    event.target.classList.remove('drop-target');
  }
});
</script>


	

Now, go there and drag and move the belt around in the inventory. They should update accordingly. Example:


Press F12 and check your console. You should see upon each item being moved, it's logging their slot it was moved.

What I need?

I need this where items CANNOT overlap each other in the inventory. The items need to be piped from mysql and positioned to the appropriate position in the inventory. You need to be experienced in Javascript and PHP for this. InteractJS because if you check the example above, the armor is being dragged, but you cannot drop it on anything because interactjs doesn't know it's that big.

If you look at Diablo 2's inventory system, and Path of Exile's or Diablo 3's, you can get an idea of what I'm looking for. Let me know if you're interested in this and what price.

There is a field in my rpg_user_items table called slot_position and slot_size. slot_size represents the widthxheight of the item. (in this example and code above, it's 3x3 (armor) and 2x1 (belt).
Edited by Monkuar, 24 January 2015 - 08:39 PM.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=350218.0

Hi Guys,

have you got an idea how I can create a user management system with login and pw, please? I tried the below, but when I click on the "ADD NEW USER" button nothing happens 

<div>
         <fieldset>
          <legend>USER DETAILS</legend>
           <table>              
            <tr>
             <td align="right"><a title='NAME' href='user_edit.php?id=1'>NAME</a></td> 

                <td>
                 <input class="norm" type="text" name="name" id="name" /></div>
                </td>
                              
                <td align="right"><a title='SURNAME' href='user_edit.php?id=2'>SURNAME</a></td>
                
                <td>
                 <input class="norm" type="text" name="surname" id="surname" /></div>
                </td>
               </tr>
                          
               <tr>
                <td align="right"><a title='E-MAIL ADDRESS' href='user_edit.php?id=3'>E-MAIL ADDRESS</a></td>
              
            <td colspan="4">
             <input class="norm" type="text" size="57" name="e-mail" id="e-mail" /></div>
            </td>
           </tr>

           <tr>    
            <td align="right"><a title='LOGIN' href='user_edit.php?id=4'>LOGIN</a></td>
                
               <td>
                <input type="text" name="login" id="login" /></div>
               </td>
               
               <td align="right"><a title='PASSWORD' href='user_edit.php?id=5'>PASSWORD</a></td>
                  
                  <td>
                   <input class="norm" type="text" name="password" id="password" /></div>
                  </td>
                 </tr>
                </table>
               </fieldset>
              </div>

              <br />
        
              <div>
               <fieldset>
                <input type='submit' name='delete' value='DELETE USER' onclick='confirm("ARE YOU SURE?");'/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                <input type='submit' name='add' value='ADD NEW USER'/>
               </fieldset>
              </div>

cheers,

ozzo

Hey, all!

I posted a thread before about a content management system for my news, and so far the php script works fine. I would like to add additional features to this system, though, and was wondering if anyone could help.

Here's the code for all the files needed for the news content management system to work...

1.) First, is the mysql table, called "mynews" with the fields:

"id" - primary key; auto-increment. "title" - the title of the news article. "user" - the person who posted the article (would be me in all cases) "message" - the body of the article; this would contain the actual news. "url" - the url to the full article. "time" - time and date the article was posted, or added to database. "type" - the type of news, like 'update', or 'random'.
2.) Next, is the code to connect to the database in mysql, called "dbconnect.php":

Code: [Select]
<?php 
    $username = "your username"; //your username 
    $password = "your password"; //your password 
    $host = "your hostname"; //your mySQL server 
    $database = "your database name"; //The name of the database your table is in 

         mysql_connect($host,$username,$password) or die("Error connecting to Database!<br>" . mysql_error()); 
 //connect, but if there is a problem, display an error message telling why there is a problem
 
         mysql_select_db($database) or die("Cannot select database!<br>" . mysql_error()); 
 //Choose the database from your mySQL server, but if there is a problem, display an error telling why 
?>
3.) Third, is the forms for posting new articles, called "postnews.php":

Code: [Select]
<form action="process.php" method="post" id="news">
        <h1>Post New Article</h1>
        <p>Please fill out all of the following fields:</p>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td class="cmsNewsformText">Type*:</td>
            <td><font size="1">
              <input name="type" type="text" class="cmsNewforms" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">News Topic/Title*: </td>
            <td><font size="1">
              <input name="title" type="text" class="cmsNewforms" value="enter title of article" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Username*:</td>
            <td><font size="1">
              <input name="user" type="text" class="cmsNewforms" value="enter username" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Url*:</td>
            <td><font size="1">
              <input name="url" type="text" class="cmsNewforms" value="enter url of news article" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Message*:</td>
            <td><font size="1">
              <textarea name="message" cols="43" rows="10" class="cmsNewforms">enter body of article
      </textarea>
            </font></td>
          </tr>
        </table>
        <p> <font size="1">
          <input name="Submit" type="submit" class="Button1" value="Submit" />
        </font> </p>
      </form>
4.) Fourth, is process.php. This script sends the data entered by the administrator (me) on "postnews.php" to the database, and displays a message saying that the information was sent successfully.

Code: [Select]
<?php
 $user=$_POST['user']; 
 $title=$_POST['title']; 
 $message=$_POST['message']; 
 $type=$_POST['type']; 
 $url=$_POST['url']; 
 mysql_connect("your hostname", "your database name", "your password") or die(mysql_error()); 
 mysql_select_db("cmsnewsacp") or die(mysql_error()); 
 
 $sql = sprintf("INSERT INTO mynews (user, title, message, type, url)
VALUES ('%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($user),
mysql_real_escape_string($title),
mysql_real_escape_string($message),
mysql_real_escape_string($type),
mysql_real_escape_string($url));
$result = mysql_query($sql); 
 
 
 Print "The article has successfully been posted"; 
 ?>
5.) And lastly, here's the script for displaying the news on the home page:

Code: [Select]
<?
include("dbconnect.php"); //include the file to connect to the database
$getnews = mysql_query("SELECT * FROM mynews ORDER BY id DESC"); //query the database for all of the news

while($r=mysql_fetch_array($getnews)){ //while there are rows in the table
extract($r); //remove the $r so its just $variable

echo("
<span class=NewsID>$type</span> <span class=h2>$title</span><br><br>
<em>posted by <strong>$user</strong> on $time</em><br>
<span class$message<br><br />
<font color=0099FF><a href=$url>Read more - $url</a></font><br><br><p>");

}

?>
Now that you've got all the code, let's take a look back at the table "mynews" with its fields. See "url"? This variable would contain the url I type in the forms on "postnews.php" and would be called to form a "Read more" link at the end of each article displayed on the home page. The question I have here, is how can I modify this script to where everytime a new 'article' is added to the database, a new page is created with the article and the url I specified? Also, I want to limit the amount of characters of the article, so that it'll only display a little bit on the home page, with a "read more" link that takes them to that page.

Now last but not least, how in the bloody fudge do I script pagination into this script?

I've made a site for a client and they like it.  They asked me who does the updates me or them?  So I know they want to make the updates themselves.  Do anyone know the best place I can learn how to create a CMS? I would prefer video tutorials.  Thanks.

i downloaded this code for a web based project management system
 http://www.devshed.com/c/a/PHP/Project-Management-Overview/3/
i downloaded here
im a beginner
in php

i need some one to run this code i cant understand whether this executes or not
i have created all the datatbases required

the code is correct but i cannot make it run plzz guys need help some one when i login
error comes in login page



Deprecated: Function eregi() is deprecated in C:\wamp\www\Project_Management\functions.php on line 3

Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\Project_Management\login.php on line 33

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\Project_Management\login.php on line 33

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\Project_Management\login.php on line 34

I really need some serious help with the design of a PIN (Personal Identification Number) Management System.
When a user (with ID) logs in with the PIN (which already exist in my database), i want the system to assign that PIN to that user (ID) alone. No other user (ID)  can access that PIN, the PIN is only assigned to that User (ID).
I need the PHP codes, MySQL database tables, and some lil' explanation.

Thanks.

I am looking for a Script

1- which has a new user registeration and lhe can log to the site after "ADMIN  APROVAL"
2- Multiple levles ie, user had multiple levles under which he can register  on registration page ( Paid,Trial or Free) and after aproval of their registration  by admin they r redirected to thier respective area ie free page, paid page or Trial page

Thnks to all Seniour for Earilier help