[PHP] HabSys V2 [by m0nsta.]

[Markshall]

HabSys V2​

If you're active around the Habbo section you maye have noticed a project I have been working on for the past few months called HabSys. You may have also seen the

You must be registered for see links

.

Well, this version is much more secure, advanced and has a few new features which I will list below:

• I have used mysql_real_escape_string() to make it more secure
• There is a AJAX search bar, when you type someones name, it gives you suggestions (can be seen in screenshots)
• You can now post on users profiles
• The Private Messaging page is more advanced
• HabSig V1 has been implemented into user profiles
• Nice new layout from FansiteDEV.com - uses PHPGD headers.
• The navigation bar uses Volter text, but is also PHPGD.
• You can add your own ranks through phpMyAdmin
• The members page and 'users under spotlight' page now have pagination
• The search bar is more advanced
• Uses a custom made CAPTCHA for registration

Screenshots

Download

You must be registered for see links

You must be registered for see links

You must be registered for see links

Password
Code:
m0nstadot
Live Demo

You must be registered for see links

Please leave some credits to me for coding this.

SQL CODE:

CREATE TABLE IF NOT EXISTS `config` (
`url` varchar(300) NOT NULL,
`title` varchar(40) NOT NULL,
`email` varchar(150) NOT NULL,
`admin` varchar(40) NOT NULL,
`maintainance` varchar(1) NOT NULL DEFAULT '0',
`forum` varchar(1) NOT NULL DEFAULT '0',
`forumlink` varchar(100) NOT NULL DEFAULT 'forum.php',
`admin_notes` mediumtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `config` (`url`, `title`, `email`, `admin`, `maintainance`, `forum`, `forumlink`, `admin_notes`) VALUES
('http://mark-eriksson.com/habsysv2', 'HabSys', '[email protected]', 'Mark Eriksson', '0', '0', 'forum.php', '');

CREATE TABLE IF NOT EXISTS `news` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`title` varchar(40) NOT NULL,
`content` longtext NOT NULL,
`author` varchar(90) NOT NULL,
`comments` varchar(90) NOT NULL DEFAULT '0',
`date` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


INSERT INTO `news` (`id`, `title`, `content`, `author`, `comments`, `date`) VALUES
(1, 'HabSys V2!', 'Thanks for using HabSys V2!', '1', '2', 'Jul, 27th 2010 - 9:38 pm');


CREATE TABLE IF NOT EXISTS `news_comments` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`news_id` varchar(90) NOT NULL,
`by` varchar(90) NOT NULL,
`comment` mediumtext NOT NULL,
`date` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `pm` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`to` varchar(30) NOT NULL,
`from` varchar(30) NOT NULL,
`subject` varchar(40) NOT NULL,
`content` longtext NOT NULL,
`date` varchar(100) NOT NULL,
`read` varchar(1) NOT NULL DEFAULT '0',
`tdelete` varchar(1) NOT NULL DEFAULT '0',
`fdelete` varchar(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `ranks` (
`level` varchar(10) NOT NULL,
`rank_name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ranks` (`level`, `rank_name`) VALUES
('1', 'Member'),
('2', 'Administrator');

CREATE TABLE IF NOT EXISTS `spotlight` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`habbo_name` varchar(30) NOT NULL,
`habbo_hotel` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `users` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`email` varchar(150) NOT NULL,
`password` varchar(1000) NOT NULL,
`password_u` varchar(40) NOT NULL,
`habbo_name` varchar(30) NOT NULL,
`habbo_hotel` varchar(10) NOT NULL,
`messages` varchar(10) NOT NULL DEFAULT '0',
`rank` varchar(90) NOT NULL DEFAULT 'Member',
`joindate` varchar(100) NOT NULL,
`ip` varchar(100) NOT NULL,
`page_visits` varchar(1000) NOT NULL DEFAULT '0',
`wall_posts` varchar(1000) NOT NULL DEFAULT '0',
`about_me` longtext NOT NULL,
`msn` varchar(150) NOT NULL,
`yahoo` varchar(150) NOT NULL,
`facebook_username` varchar(100) NOT NULL,
`twitter_username` varchar(100) NOT NULL,
`website` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `wall` (
`id` int(90) NOT NULL AUTO_INCREMENT,
`to` varchar(30) NOT NULL,
`from` varchar(30) NOT NULL,
`date` varchar(100) NOT NULL,
`comment` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
​

PS: IF YOU FIND ANY BUGS, PLEASE PM ME OR POST THEM IN THIS THREAD AND I WILL FIX THEM AS SOON AS I GET TIME.
ALSO, IF YOU HAVE ANY IDEAS YOU ARE F TO PM ME OR POST THEM HERE.

Thanks,
- m0nsta.

 

[Sledmore]

This is excellent, Love this, Thanks, Also, Change the v1 thread link, it links to anther forum.