newb
Members-
Posts
454 -
Joined
-
Last visited
Everything posted by newb
-
Making an access level? (Wont work need help)
newb replied to dual_alliance's topic in PHP Coding Help
i think you can only do usergroups in bitwise dude -
would help if u posted the full code
-
Making an access level? (Wont work need help)
newb replied to dual_alliance's topic in PHP Coding Help
usergroup levels are done in sessions? i thought they were done in bitwise? -
works! thanks a bunch dude!!1 i was starting to give up on here =[
-
it just renames them to 1.jpg, im assuming it does that because thats the id number in the first row. im fully aware my code is this: [code=php:0]$uid = $row['id']; rename("styles/$file_name", "styles/$uid$ext"); [/code] im guessing thats why it does that. however, i dont want it to rename a file to 1.jpg each time i upload something, and thats what its doing. is there a way to fix it??? any one can help??
-
eh i just told you in the post above. its suppose to rename the file to the exact id number as whats being generated in the id field on that table whenever i hit the submit button to upload something.
-
well, its suppose to rename the file to the next number. kinda like auto_incrementing on tables in sql. here's my sql table: [img]http://www.flickcabin.com/sessions/306f2f2b636bb59e1cf9d7d43b71c978a1eed72c/table.PNG[/img] whenever i upload a file, its suppose to rename that file to the exact id number as whats in the id field on that table, but its not doing that :(. however, whenever i upload something or a file, it inserts the data into the table just fine, but it doesnt rename the file to the same id number as in the table, it just renames it to something else.
-
Newbie needs help finding out why script is not working
newb replied to osdesignz's topic in PHP Coding Help
ur mysql config settings arent right. -
its ok, can you help me please?? i am prety newbie here =[
-
ur code didnt help.
-
ok i fixed the mysql database problem, but whenever i submit something it doesnt rename to the same id as whats in the database. i want the file name to be renamed to the same as the id number thats auto_generated in the database but its not!. please help!
-
someone pleasee help!111
-
i want the file name to be renamed to the same as the id number thats auto_generated in the database but its not!. [code] <?php if (move_uploaded_file($file_tmp,$upload_dir.$file_name)) { // success! include "dbconfig.php"; $query = mysql_query("SELECT * FROM `style_imgupload` ORDER BY id ASC LIMIT 2"); $row = mysql_fetch_array($query); $uid = $row['id']; rename("styles/$file_name", "styles/$uid$ext"); echo "File $i: ($uid$ext) Uploaded.<br>"; }else{ echo "File $i: Faild to upload.<br>"; }#end of (move_uploaded_file). }#end of (file_exists). }#end of (file_size). }#end of (limitedext). }#end of (!is_uploaded_file). }#end of (for loop). $id = mysql_insert_id(); $insert = mysql_query("INSERT INTO style_imgupload (id, active, author, author_url, ip_address) VALUES ('$id', '$active', '$author', '$author_url', '$ip_address')"); if (!$insert) { die('Invalid query: ' . mysql_error()); } ?> [/code] whenever i submit information it doesnt rename to the same id as whats generated in the database. please help!
-
[code] <?php if(session_id() == "") { session_start(); } $ses_id = session_id(); // ######################### Include Source Files ######################### require "sources/core/global.php"; $user = $_SESSION['username']; $username = $_POST['username']; $password = $_POST['password']; if ($action == "") { // if form hasn't been submitted // Load Header include $tpath."header.php"; $query = $libmysql->query("SELECT active FROM $table_blocks WHERE id=0"); $row = $libmysql->fetch_array($query); // Check if block is active $block_active = $row['active']; if ($block_active == 1) { { $query = $libmysql->query("SELECT data FROM $table_blocks WHERE id=0"); $row = $libmysql->fetch_row($query); $midlink = $row[0]; echo $midlink; $libmysql->free_result($query); } } else if($block_active == 0) { print "<!--Inactive Block (ID=0 - MIDLINK)!-->"; } // Load Body Template include $tpath."structure.php"; echo "Current Session Key: $ses_id<br /><br />"; echo "<form action='modules.php?name=member&action=login' method='post'> <table align='left' border='0' cellspacing='0' cellpadding='3'> <tr><td>Username:</td><td><input type='text' name='user' maxlength='30'></td></tr> <tr><td>Password:</td><td><input type='password' name='pass' maxlength='30'></td></tr> <tr><td colspan='2' align='left'><input type='checkbox' name='remember'> <font size='2'>Remember me next time</td></tr> <tr><td colspan='2' align='right'><input type='submit' name='sublogin' value='Login'></td></tr> <tr><td colspan='2' align='left'><a href='modules.php?name=signup'>Join</a></td></tr> </table> </form>"; // ######################### End of Registration Code ######################### // Load Body Template include $tpath."structure2.php"; // Begin Loading Footerlink Block $query = $libmysql->query("SELECT active FROM $table_blocks WHERE id=1"); $row = $libmysql->fetch_array($query); // Check if block is active $block_active = $row['active']; if ($block_active == 1) { { $query = $libmysql->query("SELECT data FROM $table_blocks WHERE id=1"); $row = $libmysql->fetch_row($query); $footerlink = $row[0]; echo $footerlink; $libmysql->free_result($query); } } else if($block_active == 0) { print "<!--Inactive Block (ID=1 - FOOTERLINK)!-->"; } // Begin Loading Copyright Block $query = $libmysql->query("SELECT active FROM $table_blocks WHERE id=2"); $row = $libmysql->fetch_array($query); // Check if block is active $block_active = $row['active']; if ($block_active == 1) { { $query = $libmysql->query("SELECT data FROM $table_blocks WHERE id=2"); $row = $libmysql->fetch_row($query); $copyright = $row[0]; echo $copyright; $libmysql->free_result($query); } } else if($block_active == 0) { print "<!--Inactive Block (ID=2 - COPYRIGHT)!-->"; } // Load Footer Template include $tpath."footer.php"; } // ######################### End Main Page Code ######################### else if ($action == "login") { /** * Checks whether or not the given username is in the * database, if so it checks if the given password is * the same password in the database for that user. * If the user doesn't exist or if the passwords don't * match up, it returns an error code (1 or 2). * On success it returns 0. */ function confirmUser($username, $password){ global $connection; /* Add slashes if necessary (for query) */ if(!get_magic_quotes_gpc()) { $username = addslashes($username); } /* Verify that user is in database */ $q = "select password from $table_users where username = '$username'"; $result = mysql_query($q,$connection); if(!$result || (mysql_numrows($result) < 1)){ return 1; //Indicates username failure } /* Retrieve password from result, strip slashes */ $dbarray = mysql_fetch_array($result); $dbarray['password'] = stripslashes($dbarray['password']); $password = stripslashes($password); /* Validate that password is correct */ if($password == $dbarray['password']){ return 0; //Success! Username and password confirmed } else{ return 2; //Indicates password failure } } /** * checkLogin - Checks if the user has already previously * logged in, and a session with the user has already been * established. Also checks to see if user has been remembered. * If so, the database is queried to make sure of the user's * authenticity. Returns true if the user has logged in. */ function checkLogin(){ /* Check if user has been remembered */ if(isset($_COOKIE['cookname']) && isset($_COOKIE['cookpass'])){ $_SESSION['username'] = $_COOKIE['cookname']; $_SESSION['password'] = $_COOKIE['cookpass']; } /* Username and password have been set */ if(isset($_SESSION['username']) && isset($_SESSION['password'])){ /* Confirm that username and password are valid */ if(confirmUser($_SESSION['username'], $_SESSION['password']) != 0){ /* Variables are incorrect, user not logged in */ unset($_SESSION['username']); unset($_SESSION['password']); return false; } return true; } /* User not logged in */ else{ return false; } } /** * Determines whether or not to display the login * form or to show the user that he is logged in * based on if the session variables are set. */ function displayLogin(){ global $logged_in; if($logged_in){ echo "<h1>Logged In!</h1>"; echo "Welcome <b>$_SESSION[username]</b>, you are logged in. <a href=\"modules.php?name=member&action=logout\">Logout</a>"; } else { } /** * Checks to see if the user has submitted his * username and password through the login form, * if so, checks authenticity in database and * creates session. */ if(isset($_POST['sublogin'])){ /* Check that all fields were typed in */ if(!$_POST['user'] || !$_POST['pass']){ die('You didn\'t fill in a required field.'); } /* Spruce up username, check length */ $_POST['user'] = trim($_POST['user']); if(strlen($_POST['user']) > 30){ die("Sorry, the username is longer than 30 characters, please shorten it."); } /* Checks that username is in database and password is correct */ $md5pass = md5($_POST['pass']); $result = confirmUser($_POST['user'], $md5pass); /* Check error codes */ if($result == 1){ die('That username doesn\'t exist in our database.'); } else if($result == 2){ die('Incorrect password, please try again.'); } /* Username and password correct, register session variables */ $_POST['user'] = stripslashes($_POST['user']); $_SESSION['username'] = $_POST['user']; $_SESSION['password'] = $md5pass; /** * This is the cool part: the user has requested that we remember that * he's logged in, so we set two cookies. One to hold his username, * and one to hold his md5 encrypted password. We set them both to * expire in 100 days. Now, next time he comes to our site, we will * log him in automatically. */ if(isset($_POST['remember'])){ setcookie("cookname", $_SESSION['username'], time()+60*60*24*100, "/"); setcookie("cookpass", $_SESSION['password'], time()+60*60*24*100, "/"); } /* Quick self-redirect to avoid resending data on refresh */ echo "<meta http-equiv=\"Refresh\" content=\"0;url=$HTTP_SERVER_VARS[PHP_SELF]\">"; return; /* Sets the value of the logged_in variable, which can be used in your code */ $logged_in = checkLogin(); } else if ($action == "logout") { // if logout session_start(); /** * Delete cookies - the time must be in the past, * so just negate what you added when creating the * cookie. */ if(isset($_COOKIE['cookname']) && isset($_COOKIE['cookpass'])){ setcookie("cookname", "", time()-60*60*24*100, "/"); setcookie("cookpass", "", time()-60*60*24*100, "/"); } if(!$logged_in){ echo "<h1>Error!</h1>\n"; echo "You are not currently logged in, logout failed. Back to <a href=\"main.php\">main</a>"; } else{ /* Kill session variables */ unset($_SESSION['username']); unset($_SESSION['password']); $_SESSION = array(); // reset session array session_destroy(); // destroy session. echo "<h1>Logged Out</h1>\n"; echo "You have successfully <b>logged out</b>. Back to <a href=\"main.php\">main</a>"; } } } } } ?>[/code] k i dont know much but when i submit the form it just goes to a blank page k please help i dont know what to do.
-
just to be sure, just ran the query in phpMyAdmin, and it executed properly...so its definitely something with php :s phpMyAdmin returned this: [quote] Inserted rows: 1 Inserted row id: 1 (Query took 0.0003 sec) SQL query: INSERT INTO p16_users( id, first_name, last_name, email_address, `username` , `password` , signup_date ) VALUES ( '$userid', '$first_name', '$last_name', '$email_address', '$username', '$mdpwd', '$today' ) [/quote]
-
didnt help, same error i believe. [quote]INSERT INTO (id, first_name, last_name, email_address, `username`, `password`, signup_date) VALUES('0', 'fgfgf', 'gfdg', 'gfdg', 'gfdg', 'c43f0cf37469a3f1b20342132b0451de', 'August 9, 2006, 10:02 pm')Error: 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 '(id, first_name, last_name, email_address, `username`, `password`, signup_date) ' at line 1 with query INSERT INTO (id, first_name, last_name, email_address, `username`, `password`, signup_date) VALUES('0', 'fgfgf', 'gfdg', 'gfdg', 'gfdg', 'c43f0cf37469a3f1b20342132b0451de', 'August 9, 2006, 10:02 pm')[/quote]
-
now i get this error message: [quote] INSERT INTO (id, first_name, last_name, email_address, username, password, signup_date) VALUES('0', 'fgfgf', 'gfdg', 'gfdg', 'gfdg', '4e9ebbae28f66d96998f49edc51ebcde', 'August 9, 2006, 9:58 pm')Error: 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 '(id, first_name, last_name, email_address, username, password, signup_date) VALU' at line 1 with query INSERT INTO (id, first_name, last_name, email_address, username, password, signup_date) VALUES('0', 'fgfgf', 'gfdg', 'gfdg', 'gfdg', '4e9ebbae28f66d96998f49edc51ebcde', 'August 9, 2006, 9:58 pm')[/quote]
-
i did, and it didnt echo anything heres my code: [code=php:0] $query = mysql_query("INSERT INTO $table_users (id, first_name, last_name, email_address, username, password, signup_date) VALUES('$userid', '$first_name', '$last_name', '$email_address', '$username', '$mdpwd', '$today')"); echo $query; $sql = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query); [/code]
-
now i get this error msg with ur modifcation: [quote]Error: Query was empty with query [/quote]
-
[code=php:0] $query = mysql_query("INSERT INTO $table_users (id, first_name, last_name, email_address, username, password, signup_date) VALUES('$userid', '$first_name', '$last_name', '$email_address', '$username', '$mdpwd', '$today')"); [/code] didnt help, still getting same error.