Jump to content

Displaying a date from a registered field


zelig

Recommended Posts

Okay, I have a field called "created" in my `users` table, and I'd like to be able to view it in-game on an administrator panel. However, it's being captured in a long number format (i.e. 1335076320) which, I believe, has to deal with seconds and such.

 

How can I take that number and convert it to an actual date/time output?

 

Here's how I currently have it coded in my php form:


<tr><td width="20%">Registered On:</td><td>{{created}}</td></tr>

 

So, obviously it's not converting it to any format, rather just pulling that 1335076320 number out.

 

Thanks in advance!

Link to comment
Share on other sites

Okay, so I need to pull a second query just on the `created` field to be able to present it in the right format?

 

I have an initial query that pulls everything from the `users` table, as I'm trying to make it so that the administrators can see everything as it relates to that specific user.

 

Here's my whole code. Maybe that will help.

 

function edituser($id) {
    
global $player;
    if (isset($_POST["submit"])) {
        
        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($email == "") { $errors++; $errorlist .= "Email is required.<br />"; }
        if ($hometown == "") { $errors++; $errorlist .= "Hometown is required.<br />"; }
        if ($password == "") { $errors++; $errorlist .= "Password is required.<br />"; }
        if ($race == "") { $errors++; $errorlist .= "Race is required.<br />"; }
        if ($class == "") { $errors++; $errorlist .= "Class is required.<br />"; }
        if ($rank == "") { $errors++; $errorlist .= "Rank is required.<br />"; }
        if ($gender == "") { $errors++; $errorlist .= "Gender is required.<br />"; }
        if ($eyes == "") { $errors++; $errorlist .= "Eyes is required.<br />"; }
        if ($hair == "") { $errors++; $errorlist .= "Hair is required.<br />"; }
        if ($skin == "") { $errors++; $errorlist .= "Skin is required.<br />"; }
        if ($build == "") { $errors++; $errorlist .= "Build is required.<br />"; }
        if ($height == "") { $errors++; $errorlist .= "Height is required.<br />"; }
        if ($gender == "") { $errors++; $errorlist .= "Gender is required.<br />"; }
        
        if ($hp == "") { $errors++; $errorlist .= "Current HP is required.<br />"; }
        if ($mp == "") { $errors++; $errorlist .= "Current MP is required.<br />"; }
        if ($energy == "") { $errors++; $errorlist .= "Current energy is required.<br />"; }
        if ($maxhp == "") { $errors++; $errorlist .= "Max HP is required.<br />"; }

        if ($maxmp == "") { $errors++; $errorlist .= "Max MP is required.<br />"; }
        if ($maxenergy == "") { $errors++; $errorlist .= "Max energy is required.<br />"; }
        
        if (!is_numeric($hp)) { $errors++; $errorlist .= "Current HP must be a number.<br />"; }
        if (!is_numeric($mp)) { $errors++; $errorlist .= "Current MP must be a number.<br />"; }
        if (!is_numeric($energy)) { $errors++; $errorlist .= "Current energy must be a number.<br />"; }
        if (!is_numeric($maxhp)) { $errors++; $errorlist .= "Max HP must be a number.<br />"; }
        if (!is_numeric($maxmp)) { $errors++; $errorlist .= "Max MP must be a number.<br />"; }
        if (!is_numeric($maxenergy)) { $errors++; $errorlist .= "Max energy must be a number.<br />"; }

        if ($errors == 0) { 
$updatequery = <<<END
UPDATE users SET
email="$email", admin="$admin", hometown="$hometown", password="$password", race="$race", class="$class", rank="$rank", gender="$gender", eyes="$eyes", hair="$hair", skin="$skin", build="$build", height="$height", spouse="$spouse", fame="$fame", gfame="$gfame", quests="$quests", flags="$flags", gold="$gold", credits="$credits", bank="$bank", hp="$hp", maxhp="$maxhp", energy="$energy", maxenergy="$maxenergy", mp="$mp", maxmp="$maxmp", plevel="$plevel", experience="$experience", strength="$strength", agility="$agility", vitality="$vitality", wisdom="$wisdom", escape="$escape", interest="$interest", minecount="$minecount", stat_bonus="$stat_bonus" WHERE id="$id"
END;
		$query = doquery($updatequery, "users");
            admindisplay("User updated.","Edit Users");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Edit Users");
        }        
        
    }   
        
    $query = doquery("SELECT * FROM users WHERE id='$id'", "users");
    $row = mysql_fetch_array($query);
$iclass = $player->class;
    global $controlrow;

$page = <<<END
<b><u>Edit Users</u></b><br /><br />
<form action="admin_panel.php?do=edituser:$id" method="post">
<table width="90%">
<tr><td width="20%">ID:</td><td>{{id}}</td></tr>
<tr><td width="20%">Username:</td><td>{{username}}</td></tr>
<tr><td width="20%">Email:</td><td><input type="text" name="email" size="30" maxlength="100" value="{{email}}" /></td></tr>
<tr><td width="20%">Password:</td><td><input type="text" name="password" size="30" maxlength="8" value="{{password}}" /></td></tr>
<tr><td width="20%">Admin Level:</td><td><input type="text" name="admin" size="30" maxlength="30" value="{{admin}}" /></td></tr>
<tr><td width="20%">Registered On:</td><td>{{created}}</td></tr>
<tr><td width="20%">Last Online:</td><td>{{last_login}}</td></tr>
<tr><td width="20%">Last IP:</td><td>{{ip}}</td></tr>
<tr><td width="20%">Flags:</td><td><input type="text" name="flags" size="30" maxlength="1055" value="{{flags}}" /></td></tr>

<tr><td colspan="2" style="background-color:#cccccc;"> </td></tr>

<tr><td width="20%">Hometown:</td><td><input type="text" name="hometown" size="15" maxlength="30" value="{{hometown}}" /></td></tr>
<tr><td width="20%">Race:</td><td><input type="text" name="race" size="10" maxlength="30" value="{{race}}" /></td></tr>
<tr><td width="20%">Class:</td><td><input type="text" name="class" size ="10" maxlength="30" value="{{class}}" /></td></tr>
<tr><td width="20%">Rank:</td><td><input type="text" name="rank" size="15" maxlength="15" value="{{rank}}" /></td></tr>
<tr><td width="20%">Gender:</td><td><input type="text" name="gender" size="15" maxlength="25" value="{{gender}}" /></td></tr>
<tr><td width="20%">Eyes:</td><td><input type="text" name="eyes" size="15" maxlength="30" value="{{eyes}}" /></td></tr>
<tr><td width="20%">Hair:</td><td><input type="text" name="hair" size="15" maxlength="30" value="{{hair}}" /></td></tr>
<tr><td width="20%">Skin:</td><td><input type="text" name="skin" size="15" maxlength="30" value="{{skin}}" /></td></tr>
<tr><td width="20%">Build:</td><td><input type="text" name="build" size="15" maxlength="30" value="{{build}}" /></td></tr>
<tr><td width="20%">Height:</td><td><input type="text" name="height" size="15" maxlength="30" value="{{height}}" /></td></tr>
<tr><td width="20%">Spouse:</td><td><input type="text" name="spouse" size="15" maxlength="30" value="{{spouse}}" /></td></tr>

<tr><td colspan="2" style="background-color:#cccccc;"> </td></tr>

<tr><td width="20%">Fame:</td><td><input type="text" name="fame" size="5" maxlength="10" value="{{fame}}" /></td></tr>
<tr><td width="20%">GFame:</td><td><input type="text" name="gfame" size="5" maxlength="2" value="{{gfame}}" /></td></tr>
<tr><td width="20%">Quests:</td><td><input type="text" name="quests" size="5" maxlength="5" value="{{quests}}" /></td></tr>
<tr><td width="20%">Gold:</td><td><input type="text" name="gold" size="5" maxlength="6" value="{{gold}}" /></td></tr>
<tr><td width="20%">Bank:</td><td><input type="text" name="bank" size="5" maxlength="30" value="{{bank}}" /></td></tr>
<tr><td width="20%">Interest:</td><td><input type="text" name="interest" size="5" maxlength="3" value="{{bank}}" /></td></tr>
<tr><td width="20%">Credits:</td><td><input type="text" name="credits" size="5" maxlength="3" value="{{credits}}" /></td></tr>

<tr><td colspan="2" style="background-color:#cccccc;"> </td></tr>

<tr><td width="20%">Current Player Level:</td><td><input type="text" name="plevel" size="5" maxlength="6" value="{{plevel}}" /></td></tr>
<tr><td width="20%">Current HP:</td><td><input type="text" name="hp" size="5" maxlength="6" value="{{hp}}" /></td></tr>
<tr><td width="20%">Max HP:</td><td><input type="text" name="maxhp" size="5" maxlength="6" value="{{maxhp}}" /></td></tr>
<tr><td width="20%">Current MP:</td><td><input type="text" name="mp" size="5" maxlength="6" value="{{mp}}" /></td></tr>
<tr><td width="20%">Max MP:</td><td><input type="text" name="maxmp" size="5" maxlength="6" value="{{maxmp}}" /></td></tr>
<tr><td width="20%">Current Energy:</td><td><input type="text" name="energy" size="5" maxlength="6" value="{{energy}}" /></td></tr>
<tr><td width="20%">Max Energy:</td><td><input type="text" name="maxenergy" size="5" maxlength="6" value="{{maxenergy}}" /></td></tr>
<tr><td width="20%">Strength:</td><td><input type="text" name="strength" size="5" maxlength="5" value="{{strength}}" /></td></tr>
<tr><td width="20%">Agility:</td><td><input type="text" name="agility" size="5" maxlength="5" value="{{agility}}" /></td></tr>
<tr><td width="20%">Vitality:</td><td><input type="text" name="vitality" size="5" maxlength="5" value="{{vitality}}" /></td></tr>
<tr><td width="20%">Wisdom:</td><td><input type="text" name="wisdom" size="5" maxlength="5" value="{{wisdom}}" /></td></tr>
<tr><td width="20%">Escape:</td><td><input type="text" name="escape" size="5" maxlength="5" value="{{escape}}" /></td></tr>
<tr><td width="20%">Bonus:</td><td><input type="text" name="stat_bonus" size="5" maxlength="3" value="{{stat_bonus}}" /></td></tr>

<tr><td colspan="2" style="background-color:#cccccc;"> </td></tr>

<tr><td width="20%">Description:</td><td>{{description}}</td></tr>
<tr><td width="20%">Weapon:</td><td>{{weapon}}</td></tr>
<tr><td width="20%">Head:</td><td>{{head}}</td></tr>
<tr><td width="20%">Neck:</td><td>{{neck}}</td></tr>
<tr><td width="20%">Body:</td><td>{{body}}</td></tr>
<tr><td width="20%">Shield:</td><td>{{shield}}</td></tr>
<tr><td width="20%">Shoulders:</td><td>{{shoulders}}</td></tr>
<tr><td width="20%">Arms:</td><td>{{arm}}</td></tr>
<tr><td width="20%">Hands:</td><td>{{hands}}</td></tr>
<tr><td width="20%">Fingers:</td><td>{{finger}}</td></tr>
<tr><td width="20%">Wrists:</td><td>{{wrists}}</td></tr>
<tr><td width="20%">Legs:</td><td>{{legs}}</td></tr>
<tr><td width="20%">Feet:</td><td>{{feet}}</td></tr>
<tr><td width="20%">Guild:</td><td>{{guild}}</td></tr>

<tr><td colspan="2" style="background-color:#cccccc;"> </td></tr>
<tr><td width="20%">Frozen:</td><td>{{frozen}}</td></tr>
<tr><td width="20%">Muted:</td><td>{{muted}}</td></tr>
<tr><td width="20%">Deaf:</td><td>{{deaf}}</td></tr>

</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;
    
    $page = parsetemplate($page, $row);
    admindisplay($page, "Edit Users");
    
}

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.