thedigicraft / Atom.CMS

Atom.CMS
56 stars 52 forks source link

Part 60 - 61: Empft query and password error #87

Closed BloodWolf89 closed 9 years ago

BloodWolf89 commented 9 years ago

When I try to add a new user and make the passwords mismatch, I get an warning..

"Warning: mysqli_query(): Empty query in C:\wamp\www\STREAMER\admin\config\queries.php on line 92" The way I see this is that the $verify failed so there was no query. Is there a way to fix it? Can't I just do $q = "";

Also when I mismatch passwords during edit user, The user update is successful and the first password field is added to database as the user password.

My Files

users.php: http://pastebin.com/mDmiE8eh queries.php: http://pastebin.com/FeDj0MH6

BloodWolf89 commented 9 years ago

I think I fixed the query warning.. I just cut $r = mysqli_query($dbc, $q); and I put it with the query with the if(statements) cms1

el3302 commented 9 years ago

In the users.php line 82 you have a semi colon where there should not be one.

<?php if(isset($opened['id'])); 

Removing this should help.

BloodWolf89 commented 9 years ago

Thank you soo much! I dont know how you find that stuff lol. I was looking since I posted this. I am sorry for wasting your time...again...

The password verify for the update user is still not working. I am able to edit a password with 2 different passwords

BloodWolf89 commented 9 years ago

I fixed it i think. I mean.. It works but I hope I didn't break something else.

I wrapped the the query for update with if($verify == true){ $q = "UPDATE users SET first = '$first', last = '$last', $password status = $_POST[status], username = '$_POST[username]', email = '$_POST[email]', bio = '$bio' WHERE id = $_GET[id]"; $r = mysqli_query($dbc, $q); }

Can you verify.. is this all set?

el3302 commented 9 years ago

that should work. I have uploaded to pastebin the users query from my query.php file

BloodWolf89 commented 9 years ago

Thank you! :)