I'm making a board.

[Deospeon]

http://fantasycore.heliohost.org/forums/

 

D: I have a problem, my login system wont work.

Login says : some invalid Mysql syntax blah blah.. look at the second post.

 

 

Please download the source code and figure out my problem.

http://fantasycore.heliohost.org/forums/source_forums.zip

 

sql for table users:

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(255) NOT NULL,
  `name` varchar(64) NOT NULL,
  `admin` int(11) NOT NULL default '0',
  `time` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

IM : deospeon@live.com or crediter_braz@yahoo.com

[Deospeon]

I've done the login script now.

 

It works fine. except for one big error now.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''test'' at line 1

 

Try to login with the username "Test" and password "Test"..

[AverageJoe]

Did you create your own forum software or are you using a pre-existing open source alternative such as phpBB or smf? Please include some more details.

 

Also another tip, allow people to be able to see the forum without having to register. It will draw more people and help with search indexes.

 

 

Joe

[Deospeon]

I'm creating my own forums. Not using any opensource shiz.

 

Dude, I've only started with the login thing. So there is no Forums till now.

 

I plan on making an admin system in which I can directly add a forum.

[kvhc128]

If I were you, I would not be making my own forum. There are hundreds of them out there and I would not believe that you do not like any of them. If you actually successfully make one, I would like to try it out though

[esay]

Yeah i think it is a bit prestigious trying to make your own forum. Just use SMF. its very good and not to hard to use.