Already done:
- SMTP class for sending emails
- Full register
- Full me page except group stats
- Full community
- Articles / sort op category
- My account as far as possible
- Quickmenu full finished except groups
- Identity page full fisished
- Ability to switch and add (between) users ~ safe
- Ability to use `forgot password`
- Ability to change your password
- Habbo credits
- Habbo club
- Making cache system for (Menu,News,Champaing...)
To-Do:
- Rechecking codes ~ 50/50
- Housekeeping
- Making more habblets (Ingame news/safe link ...)
- Home/Groups
Average query count: 3 max 11 for cache
Code:
Query optimised!
BrickPHP Minimail:
SELECT `site_minimail`.*,`users`.`username` AS `sender_name`,`users`.`look` AS `sender_look` FROM `site_minimail` INNER JOIN `users` ON `users`.`id` = `site_minimail`.`sender_id` WHERE `folder` = "'.$folder.'" AND `receiver_id` = "'.USER_ID.'"'.$unread_plus.' ORDER BY `id` DESC
UberCMS Minimail:
SELECT * FROM site_minimail WHERE folder = '" . $folder . "' AND receiver_id = '" . USER_ID . "'" . $isReadClause . " ORDER BY id DESC
-For every minimail item:
SELECT username,look FROM users WHERE id = '" . $message['sender_id'] . "' LIMIT 1
Explain
You got 4 message: Uber must run 5 queries for it, BrickPHP runs 1 query :D
Me page snippet:
PHP Code:
<?php
define('PAGE', 1);
define('PARENT', 4);
define('MUSTLOGGEDIN', true);
require './global.php';
$tpl = new tpl('Home');
$tpl->AddFile('head');
$tpl->AddDefault();
$tpl->AddFile('head-end');
$tpl->SetParam('body_id', 'home');
new CommunityMenu();
$tpl->AddTemplate(CommunityMenu::GetTemplate());
$tpl->AddLine('<div id="column1" class="column">');
//Content column 1
$userinfo = new tpl('userinfo');
$userinfo->SetParam('look', User::GetUserData('look'));
$userinfo->SetParam('motto', User::GetUserData('motto'));
$userinfo->SetParam('last_login', User::GetUserData('last_alive'));
$userinfo->SetParam('pixels', User::GetUserData('pixels'));
$userinfo->SetParam('credits', User::GetUserData('credits'));
$userinfo->AddFile('comp-userinfo');
$tpl->AddTemplate($userinfo);
new HabbletUserSelect();
$tpl->AddTemplate(HabbletUserSelect::GetTemplate());
new CommunityCampaigns();
$tpl->AddTemplate(CommunityCampaigns::GetTemplate());
new HabbletMinimail();
$tpl->AddTemplate(HabbletMinimail::GetTemplate());
$tpl->AddFile('comp-habbosearch');
$tpl->AddLine('</div>');
$tpl->AddLine('<div id="column2" class="column">');
//Content column 2
new SideNews(4, 2);
$tpl->AddTemplate(SideNews::GetTemplate());
$tpl->SetParam('twitter_username', Core::$config['twitter']);
$tpl->AddFile('comp-twitter');
$tpl->AddLine('</div>');
$tpl->AddFile('community-column3');
$tpl->AddFile('footer');
echo $tpl;
?>