Free custom user system, YES FREE!!

[-::Mr.Dave::-]

Hi guys

Im releasing this usersystem free, We use it on habboattic.co.uk and thanks should go to me and Bomb-Head who spent much time getting it working

It is a nicely modified techtuts system and can probably be modded further

Its opensource so you are free to use it and develop it and redistribute as you want but you cannot claim it as yours as it will always be a techtuts system. This could become the opensource Habboxforum user system and people who help to develop it further will be greatly appreciated, A profile system next will be nice

to download go to:
http://habboattic.co.uk/usersystem.zip

Best Regards,
Dave

[Despect$]

Sweet, this is exactly what ive been looking for, thanks

[-::Mr.Dave::-]

No problem

There's to many things people are paying for so i decided to release this free

I will work on it further when i get some time

[omgDAN!]

Thanks I'll put it to good use.

[ebay]

very good, any chance of a demo in future

[-::Mr.Dave::-]

Just look on habboattic.co.uk ;)

[Despect$]

I uploaded to my site and it doesnt seem to work..

[tekni]

It doesn't work on Habboattic.

[-::Mr.Dave::-]

I will find the SQL for it

[-::Mr.Dave::-]

You will need this in a MYSQL database:


-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 03, 2006 at 03:12 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `habboatt_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `pmessages`
--
CREATE TABLE `pmessages` (
`title` varchar(255) NOT NULL default 'Untitled Message',
`message` text NOT NULL,
`touser` varchar(255) NOT NULL default '',
`from` varchar(255) NOT NULL default '',
`unread` varchar(255) NOT NULL default 'unread',
`date` date NOT NULL default '0000-00-00',
`id` int(15) NOT NULL auto_increment,
`reply` varchar(15) NOT NULL default 'no',
`sticky` char(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `pmessages`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`msn` varchar(250) NOT NULL default 'Not Specified',
`aim` varchar(250) NOT NULL default 'Not Specified',
`picture` varchar(250) NOT NULL default 'http://www.habboattic.co.uk/images1/nopic.gif',
`location` varchar(36) NOT NULL default 'Not Specified',
`level` int(1) default '1',
`online` varchar(12) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;
--
-- Dumping data for table `users`
--

[:Blobbed]

You will need:


-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net (http://www.phpmyadmin.net/)
--
-- Host: localhost
-- Generation Time: Dec 03, 2006 at 03:12 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `habboatt_users`
--
-- --------------------------------------------------------
--
-- Table structure for table `pmessages`
--
CREATE TABLE `pmessages` (
`title` varchar(255) NOT NULL default 'Untitled Message',
`message` text NOT NULL,
`touser` varchar(255) NOT NULL default '',
`from` varchar(255) NOT NULL default '',
`unread` varchar(255) NOT NULL default 'unread',
`date` date NOT NULL default '0000-00-00',
`id` int(15) NOT NULL auto_increment,
`reply` varchar(15) NOT NULL default 'no',
`sticky` char(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `pmessages`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(30) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`email` varchar(40) NOT NULL default '',
`msn` varchar(250) NOT NULL default 'Not Specified',
`aim` varchar(250) NOT NULL default 'Not Specified',
`picture` varchar(250) NOT NULL default 'http://www.habboattic.co.uk/images1/nopic.gif',
`location` varchar(36) NOT NULL default 'Not Specified',
`level` int(1) default '1',
`online` varchar(12) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `users`
--

Otherwise the user will start with the id 47 and the other thing 9.

[nets]

If your server has magic_quotes_gpc disabled and you're using this script, you are open to SQL Injection attacks. I suggest everyone using this script edits the file "config.php", and replaces:


$logged = MYSQL_QUERY("SELECT * from users WHERE id='$_COOKIE[id]' AND password = '$_COOKIE[pass]'");

With:



function sanitize($str) {
if (get_magic_quotes_gpc()) {
$str = stripslashes($str);
}
return mysql_real_escape_string($str);
}

$SQL = sprintf("SELECT * FROM users WHERE id='%d' AND password='%s'",
$_COOKIE['id'],
sanitize($_COOKIE['pass']));

$logged = MYSQL_QUERY($SQL);

I haven't tested this. I can't assure anyone it will resolve the problem, and I don't know if there's any other security issues.

[-::Mr.Dave::-]

Well it is the basic techtuts system taken further lol
Our system has been safe

[Jae]

So, your just re-releasing a tech tuts system, its not even your code ? Seriously, thats just making people abuse the tutorial even more.



thanks should go to me and Bomb-Head who spent much time getting it working


No, its Tech-Tuts.Not yours!

[nets]

Our system has been safe
You're waiting for someone to hack it until you patch it? Sure, it might be fine if magic_quotes_gpc is enabled, but that could be changed at any time.. I believe in the latest version of PHP, it's disabled by default.

[-::Mr.Dave::-]

I dont know we made and modified this system a while back, sometime in mau june

[Flisker]

i knew it was techtuts all along as basicly EVERY usersystem that someone has made on this forum is tech tuts LOL, nice tho ;]