ty amber :)
ty amber :)
great release bro ! 10/10
thanks grandcriminal
me ridez bykes
It's alright, not the best though. 7/10.
~Sean
thanks for commenting :) . PHPretro Rules page V2 - Rules editable with Housekeeping coming soon .
What You Mean? i made ranks SQL for u and then u imported... and u got looks From My UberCMS i should be getting 10% really or 5% -.-Originally Posted by StronGCoder
Nice Release. 9/10.
i can there the screenshots bud
this has nothing to do with ranks ? this is not staff page or how to make more ranks .
---------- Post added at 03:36 AM ---------- Previous post was at 03:32 AM ----------
i didnt look from ur uberCMS apps page . i made it myself . it's all different . and plus in uberCMS apps page i did the layout and u pasted it and edited somethings .
No You Didnt Really... I Did it u were just on teamviewer... yeah... so.. yahh..this has nothing to do with ranks ? this is not staff page or how to make more ranks .
---------- Post added at 03:36 AM ---------- Previous post was at 03:32 AM ----------
i didnt look from ur uberCMS apps page . i made it myself . it's all different . and plus in uberCMS apps page i did the layout and u pasted it and edited somethings .
Wow, sorry mate but has no one honestly noticed the massive security holes in this script? Hes inserting variables directly into a sql query, if the data isnt escaped theres sql injection right in front of your eyes!!
The thread its messed up. talk to a MOD for get the first post back (yeah)
Here it is :
Not messed up for meHey ragezone :)
This is the final version of phpretro staff applications by StronGCoder .
It is MySQL - Housekeeping - Different - Housekeeping page (with some changes)
in the housekeeping page the white background doesnt show in the values only in the name . You will see it below .
Screenies :
Attachment 82285 Attachment 82286 Attachment 82287
Hope you like it more than V2 and V1.
staff_apps.start.php :
staff_apps.sent.php :PHP Code:<?php
/*
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> PHPretro Staff Applications V3 <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> Made by StronGCoder <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
*/
require_once('./includes/core.php');
require_once('./includes/session.php');
$data = new me_sql;
$lang->addLocale("home.me");
$page['id'] = "appsv3";
$page['name'] = "Staff Applications V3";
$page['bodyid'] = "";
$page['cat'] = "community";
require_once('./templates/community_header.php');
?>
<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix pixellightblue ">
<h2 class="title">Staff Applications</span>
</h2>
<form action="staff_apps.sent.php" method="post">
<img src="http://www.habborator.org/badges/badges/ADM.gif" align="left"><img src="http://www.habborator.org/badges/badges/ADM.gif" align="right"></a>
<br><center><b>Name</b><br>
<input type="text" name="name">
<br><br>
<b>Username</b><br>
<input type="text" name="username"><br>
<br>
<b>Age</b><br>
<input type="text-number" name="age"><br>
<br>
<b>Email</b><br>
<input type="email" name="email"><br><br>
<b>I am applying for ...</b><br>
<input type="text" name="rank"><br>
<br>
<b>Country</b><br>
<input type="text" name="country"><br><br>
<b>Users you can bring on ?</b><br>
<input type="text-numer" name="users_can_bring_on"><br><br>
<b>Why do you want join the team ?</b>
<textarea rows="5" cols="50" name="why_u_want_join">
</textarea><br><br>
<b>Why can you improve ?</b>
<textarea rows="5" cols="50" name="improve">
</textarea>
<br><br>
<input type="submit" value="Submit">
</form>
</div></div></div>
<div id="column2" class="column">
<div class="habblet-container ">
<div class="cbb clearfix pixeldarkblue ">
<h2 class="title">Did i spent ?</span>
</h2>
<center>We wish you best luck in your application . We will alert you in the hotel , site or email if you spent .<br>Thank you for using our form</center>
</div></div></div>
<?php require_once('./templates/community_footer.php');
Insert to Database :PHP Code:<?php
$con = mysql_connect("localhost","root","YOUR PASSWORD HERE");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("DATABASE NAME", $con);
$sql="INSERT INTO staff_applications_v3 (name, username, age, email, applyfor, country, users_can_bring, why_u_want_join, improve)
VALUES
('$_POST[name]','$_POST[username]','$_POST[age]','$_POST[email]','$_POST[rank]','$_POST[country]','$_POST[users_can_bring_on]','$_POST[why_u_want_join]','$_POST[improve]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "";
mysql_close($con)
?>
<?php
/*
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> PHPretro Staff Applications V3 <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> Made by StronGCoder <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
*/
require_once('./includes/core.php');
require_once('./includes/session.php');
$data = new me_sql;
$lang->addLocale("home.me");
$page['id'] = "appsv3";
$page['name'] = "Staff Applications V3";
$page['bodyid'] = "";
$page['cat'] = "community";
require_once('./templates/community_header.php');
?>
<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix pixellightblue ">
<h2 class="title">Sent</span>
</h2>
<center>Your application at <?php ECHO SHORTNAME; ?> hotel has sent successfully . Please check back later , we will alert you in email , site or hotel if you got your rank .</center>
</div></div></div>
<?php require_once('./templates/community_footer.php'); ?>
this goes at housekeeping folder - appsv3.phpPHP Code:CREATE TABLE staff_applications_v3
(
name varchar(1000),
username varchar(1000),
age int,
email varchar(1000),
applyfor varchar(1000),
country varchar(1000),
users_can_bring int,
why_u_want_join varchar(10000),
improve varchar(10000)
)
this goes at templates folder :housekeeping_header.php (replace) :PHP Code:<?php
/*
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> PHPretro Staff Applications V3 <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
---+---> Made by StronGCoder <---+---
---+---+---+---+---+---+---+---+---+---+---+---+---+---+
*/
$page['dir'] = '\housekeeping';
$page['housekeeping'] = true;
$page['rank'] = 7;
require_once('../includes/core.php');
require_once('./includes/hksession.php');
$lang->addLocale("housekeeping.bans");
$data = new housekeeping_sql;
$page['name'] = Staff Applications V3;
$page['category'] = "users";
require_once('./templates/housekeeping_header.php');
?>
<body>
<?php
$con = mysql_connect("localhost","root","YOUR PASSWORD HERE");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("DATABASE NAME", $con);
$result = mysql_query("SELECT * FROM staff_applications_v3");
echo "<style type=text/css>
table,th,td
{
border:1px solid red;
}
</style>
<style type=text/css>
table, td, th
{
border:1px solid black;
}
th
{
background-color:white;
color:black;
}
</style>
<style type=text/css>
h1
{
background-color:white;
}
</style>
<table border='1'>
<tr>
<th>Name</th>
<th>Username</th>
<th>Age</th>
<th>Email</th>
<th>Applying for ...</th>
<th>Country</th>
<th>Users can bring on :</th>
<th>He wants to join team because :</th>
<th>Can improve those things:</th>
</tr>";
?>
<?php
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<style type=text/css>
table,th,td
{
border:1px solid red;
}
</style>
<style type=text/css>
table, td, th
{
border:1px solid black;
}
th
{
background-color:white;
color:black;
}
</style>
<style type=text/css>
h1
{
background-color:white;
}
</style><td> " . $row['name'] . "</td>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['age'] . " </td>";
echo "<td>" . $row['email'] . " </td>";
echo "<td>" . $row['applyfor'] . " </td>";
echo "<td>" . $row['country'] . " </td>";
echo "<td>" . $row['users_can_bring'] . " </td>";
echo "<td>" . $row['why_u_want_join'] . " </td>";
echo "<td>" . $row['improve'] . " </td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>
</body>
</html>
<?php require_once('./templates/housekeeping_footer.php'); ?>
Hope you like it. rate rel pls 0/10PHP Code:<?php
/*================================================================+\
|| # PHPRetro - An extendable virtual hotel site and management
|+==================================================================
|| # Copyright (C) 2009 Yifan Lu. All rights reserved.
|| # http://www.yifanlu.com
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved.
|| # http://www.meth0d.org
|| # All images, scripts, and layouts
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved.
|+==================================================================
|| # PHPRetro is provided "as is" and comes without
|| # warrenty of any kind. PHPRetro is free software!
|| # License: GNU Public License 3.0
|| # http://opensource.org/licenses/gpl-license.php
\+================================================================*/
$version = version();
$lang->addLocale("housekeeping.header");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>PHPRetro Housekeeping: <?php echo $page['name']; ?></title>
<link rel="shortcut icon" href="<?php echo PATH; ?>/housekeeping/favicon.ico" type="image/vnd.microsoft.icon" />
<link rel="stylesheet" href="<?php echo PATH; ?>/housekeeping/images/styles/style.css" type="text/css">
<link rel="stylesheet" href="<?php echo PATH; ?>/housekeeping/images/styles/boxes.css" type="text/css">
<?php if($page['scrollbar'] == true){ ?>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScroller.js"></script>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScrollbar.js"></script>
<script type="text/javascript">
var scroller = null;
var scrollbar = null;
</script>
<?php } ?>
<?php if($page['second_scrollbar'] == true){ ?>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScroller2.js"></script>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScrollbar2.js"></script>
<script type="text/javascript">
var scroller2 = null;
var scrollbar2 = null;
</script>
<?php } ?>
<script type="text/javascript">
window.onload = function(){
<?php if($page['scrollbar'] == true){ ?>
scroller = new jsScroller(document.getElementById("listview"), 244, 96);
scrollbar = new jsScrollbar (document.getElementById("Scrollbar-Container"), scroller, false);
<?php } ?>
<?php if($page['second_scrollbar'] == true){ ?>
scroller2 = new jsScroller2(document.getElementById("listview2"), 244, 96);
scrollbar2 = new jsScrollbar2 (document.getElementById("Scrollbar2-Container"), scroller2, false);
<?php } ?>
};
</script>
<meta name="build" content="PHPRetro <?php echo $version['version']." ".$version['stable']; ?>" />
</head>
<body>
<div class="panel">
<div class="header_left"> <br /> <br /> <br /><a href="http://www.phpretro.com/"><img src="<?php echo PATH; ?>/housekeeping/images/header_logo.png" alt="PHPRetro"></a></div>
<div class="header_right"><img src="<?php echo PATH; ?>/housekeeping/images/header_tm1.gif"></div>
<div class="panel_title">
<span class="text">PHPRetro <?php echo $version['major'].".".$version['minor']; ?> <?php echo $lang->loc['housekeeping']; ?></span>
<div class="close_button"><a href="<?php echo PATH; ?>/housekeeping/logout"><img src="<?php echo PATH; ?>/housekeeping/images/button_close.gif" alt="<?php echo $lang->loc['logout']; ?>"></a></div>
</div>
<?php if($page['category'] != "login"){ ?>
<div class="panel_header">
<ul <?php if($page['category'] == "dashboard"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['dashboard']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/dashboard"><?php echo $lang->loc['home']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/updates"><?php echo $lang->loc['updates']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/logs"><?php echo $lang->loc['logs']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/about"><?php echo $lang->loc['about']; ?></a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "settings"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['settings']; ?></a></div></li>
<?php $sql = $db->query("SELECT id,name FROM ".PREFIX."settings_pages ORDER BY `order` ASC");
while($row = $db->fetch_row($sql)){ echo "<li class=\"item\"><a href=\"".PATH."/housekeeping/settings/".$row[0]."\">".$row[1]."</a></li>\n"; }
?>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/cache"><?php echo $lang->loc['cache']; ?></a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "tools"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['tools']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/banners"><?php echo $lang->loc['banners']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/campaigns"><?php echo $lang->loc['campaigns']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/catalogue"><?php echo $lang->loc['catalogue']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/collectables"><?php echo $lang->loc['collectables']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/faq"><?php echo $lang->loc['faq']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/news"><?php echo $lang->loc['news']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/newsletter"><?php echo $lang->loc['newsletter']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/recommended"><?php echo $lang->loc['recommended']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/vouchers"><?php echo $lang->loc['vouchers']; ?></a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "users"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['users']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/users"><?php echo $lang->loc['users']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/bans"><?php echo $lang->loc['bans']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/alerts"><?php echo $lang->loc['alerts']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/help"><?php echo $lang->loc['help']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/appsv3">Applications V3</a></li>
</ul>
<div class="border"></div>
</div>
<div class="clear"></div>
<?php } ?>
<div class="topborder"></div>
Credits goes to Yifan lu for phpretro and me for coding .
This is releases section --->DONT ARGUE<---
--->HERE IT IS<---
---+--->I AM BACK<---+---
Sorry for spam . i just wanted to tell peoples in my own thread that i am back (unbanned)
