
Deospeon
Members-
Posts
29 -
Joined
-
Last visited
Everything posted by Deospeon
-
I said dman, thats no strong language is it? lol
-
^ needs teh banhammer I say, ATLEAST PUT A [bleeped!] index.html!
-
VLC FTW, I use Windows Media for music lol
-
What Operating System do you use?
Deospeon replied to kvhc128's topic in Technology and the Internet
Windows 7 and Linux Ubuntu now lol -
Yes I do, But at times I dont.
-
I'll go with Hotmail and HelloKitty HelloKitty is the best one so far.. EXTREME SPAM CONTROL FTW!
-
Ctrl+Alt+Del was always one of my favourites.
-
I second that!
-
Wordpress FTW. Joomla, PHPBB, SMF, there are alot, just google it. SMF IS WICKED!
-
The Dark KNight was....too dark
-
Well Explained.
-
I like Heliohost because ITS FUN BEING ON HELIONET!
-
D: MySQL! Why do you do this to me?
Deospeon replied to Deospeon's topic in Website Management and Coding
My Problem has been solved. I can now successfully log in. -
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 When test is a user. Login.php > <?php session_start(); include "./global.php"; ?> <html> <head> <title>Login - Fantasy Core Forums</title> </head> <style type="text/css"> body{ background-color:#373737; color:#FAFAFA; font-family:Tahoma, Geneva, sans-serif; font-size:10pt; margin-top:0px; } #holder{ background-color:#000; width:71%; color:#A5A5A5; font-family:"Trebuchet MS", Arial, Helvetica, sans-serif; border:solid 1px #000; padding-bottom: 10px; padding-left: 10px; padding-right: 10px; padding-top: 10px; text-align:left; } #userinfo{ width:99%; font-family:"Trebuchet MS", Arial, Helvetica, sans-serif; font-size:10px; color:#333; background-color:#F6F6F6; border: 1px solid #333; text-align:left; padding: 3px; padding-right: 3px; } a { font-size: 10px; text-decoration: none; } a:link { text-decoration: none; } a:visited { text-decoration: none; } a:hover { text-decoration: none; } a:active { text-decoration: none; } </style> <body> <center> <?php include "./header.php" ?> <div id="holder"> <div id="userinfo"> <? if($_SESSION['uid']){ echo "Sorry, You are already logged in. Please <a href=\"logout.php\">Logout<\a> or go to the <a href=\"index.php\">Index</a>.\a"; }else { if(!$_POST['submit']){ echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"0\">\n"; echo "<form method=\"post\" action=\"./login.php\">\n"; echo "<tr><td><font color=\"#4A4A4A\"><b>Username:</b></font></tr></td><tr><td><input type=\"text\" name=\"username\"></td></tr>\n"; echo "<tr><td><font color=\"#4A4A4A\"><b>Password:</b></font></tr></td><tr><td><input type=\"password\" name=\"password\"></tr></td>\n"; echo "<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Login\"></td><tr></form>\n"; }else { $user = mss($_POST['username']); $pass = $_POST['password']; if($user && $pass){ $query = "SELECT id FROM `users` WHERE `username`'".$user."'"; $res = mysql_query($query) or die(mysql_error()); if(mysql_num_rows($res) > 0){ $query2 = "SELECT id FROM `users` WHERE `username`='".$user."' AND `password`='".md5($pass)."'"; $res2 = mysql_query($query2) or die(mysql_error()); if(mysql_num_rows($res2) > 0){ $row = mysql_fetch_assoc($res2); $_SESSION['uid'] = $row['id']; echo "You have successfully Logged in as ".$user; }else { echo "The Username or Password You have Entered is Incorrect.\n"; } }else { echo "The Username that You have entered does not exist.\n"; } }else { echo "Please Fill in all fields correctly.\n"; } } } ?> </div> </div> </center> </body> </html> and global.php > <?php $con = mysql_connect("localhost","username","password") or die(mysql_error()); $db = mysql_select_db("database",$con); function mss($value){ return mysql_real_escape_string(trim(strip_tags($value))); } ?> Please inspect this code, and tell me about any errors. P.S If There is anything more you'd like to know about, please tell me.
-
I must agree with Saving Private Ryan. Another good one is Role Models. lol
-
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.
-
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"..
-
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
-
>< Im making my own PHP Forum! so
-
Yeah, I was joking lol. Waa.. I did not get you, You mean that, If We jump high, We would still live?
-
But WAIII? Invision Free.. kinda sucks. I used that for 4 Years and now its a fail. I've decided to make my own forums. WITH TEH ALMIGHTY POWER OF PHP!
-
Lol Thanks for the suggestions but: I'm 13, so I can't save up to $149.99 to buy a whole IPB Board. I have my own views on the others. PHPBB: Its good, but too many system/mysql errors MyBB: I personally hate the design. PunBB: I love it.. but.. I dont know why I dont want to use it. NextBB: Im kinda hating it, although I have'nt touched it. I'll try going with PunBB
-
Lol, So How do those Kung Fu People in China jump so high? xD So If Gravity would be less, we would have more chances of dying when we jump. Correct?
-
=) I will be learning Physics next year in the 9th Grade. Derek: So it basically means that if we're on Mount Everest, Gravity would be less...