Hey guys,
Well if you remember I released the Gang Page ages ago, which is located below:
http://forum.ragezone.com/f353/rp-ga...e-page-666465/
And now I am going to release my Stock Exchange page that i made for Obbo hotel, I have lost interest to pixel games now tbh, i enjoy coding though lol...
Anyways Screenshot see at the attachment.
ALSO, MAKE A FOLDER CALLED IMAGES INSIDE THAT PUT A FOLDER CALLED BADGES, OR JUST DOWNLOAD MY ZIP WITH SOME BADGES IN BELOW!!
SQL:
(You're thinking SQL WDF? Well, i added badges to this ;') )
Code:
CREATE TABLE IF NOT EXISTS `jobs_corps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`corp_name` varchar(100) NOT NULL,
`corp_balance` int(7) NOT NULL DEFAULT '0',
`owner` int(11) NOT NULL,
`badge` varchar(100) NOT NULL DEFAULT 'nobadge',
`description` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=564 ;
Right now the PHP file...
PHP:
PHP 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
\+================================================================*/
$page['allow_guests'] = true;
require_once('./includes/core.php');
require_once('./includes/session.php');
$data = new community_sql;
$lang->addLocale("community.news");
$page['id'] = "stockexchange";
$page['name'] = "Stock Exchange";
$page['bodyid'] = "news";
$page['cat'] = "bussiness";
require_once('./templates/community_header.php');
?>
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix green ">
<h2 class="title">Corporations Listings
</h2>
<div id="article-archive">
<table cellspacing="1" align="left" width="50%">
<?php
$myinfo_query = mysql_query("SELECT * FROM users WHERE name = '".$_SESSION['username']."'");
$myinfo = mysql_fetch_array($myinfo_query);
$getinfo = mysql_query("SELECT * FROM jobs_corps WHERE owner = owner + 'user'");
while($r = mysql_fetch_array($getinfo)) {
?>
<tr>
<td align="left"><a href="jobs_info?id=<?php echo $r['id']; ?>"><?php echo $r['corp_name']; ?></a></td>
<?php
}
?>
</table>
</div></div></div></div>
<div id="column2" class="column">
<div class="cbb clearfix green ">
<h2 class="title">Top 30 Corporations
</h2>
<table cellspacing="3" align="center" width="75%">
<?php
$myinfo_query = mysql_query("SELECT * FROM users WHERE name = '".$_SESSION['username']."'");
$myinfo = mysql_fetch_array($myinfo_query);
$getinfo = mysql_query("SELECT * FROM jobs_corps WHERE owner = owner + 'user'");
$myinfo_query = mysql_query("SELECT * FROM users WHERE name = '".$_SESSION['username']."'");
$myinfo = mysql_fetch_array($myinfo_query);
$corp_balance = mysql_query("SELECT * FROM jobs_corps WHERE corp_balance ORDER BY corp_balance DESC LIMIT 30");
while($r= mysql_fetch_array($corp_balance)) {
?>
<tr>
<td align="center"><img src='./images/badges/<?php echo $r['badge'].".gif"; ?>'</td>
<td align="center"><a href="jobs_info?id=<?php echo $r['id']; ?>"><?php echo $r['corp_name']; ?></a><br /> Balance: <?php echo $r['corp_balance']; ?><br />stock value: ----<br /></td>
<td align="center"><a class="new-button fill" onclick="habboclub.buttonClick(3,'" href="#"><b>What to go here?</b><i></i></a></td>
<?php
}
?>
</table></p>
</div></div>
<?php require_once('./templates/community_footer.php'); ?>
Enjoy :')
IF YOU LIKE THIS CLICK THE THANKS BUTTON!
Mirror:
http://dev-studios.co.uk/stockexchange.zip (the file and imaegs are in here not the sql)
![[RP] Stock Exchange Page!](http://ragezone.com/hyper728.png)
Originally Posted by habbzorp
Re: [RP] Stock Exchange Page!
