Raised This Month: $12 Target: $400
 3% 

Changing a table's field


Post New Thread Reply   
 
Thread Tools Display Modes
8088
Veteran Member
Join Date: Jan 2008
Old 06-29-2010 , 14:14   Re: Changing a table's field
Reply With Quote #11

Argh. Remove the ) on line 28.
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
DruGzOG
Veteran Member
Join Date: Nov 2007
Location: Unknown
Old 06-29-2010 , 14:18   Re: Changing a table's field
Reply With Quote #12

PHP Code:
validUPDATE smf_members SET steam_id 'STEAM_0:0:4195929' WHERE  member_name 'levin' AND passwd =  'hidden'

You provided  non-matching data
__________________
DruGzOG is offline
Send a message via AIM to DruGzOG
8088
Veteran Member
Join Date: Jan 2008
Old 06-29-2010 , 14:23   Re: Changing a table's field
Reply With Quote #13

I take it you replaced the hashed password with 'hidden' in the query? There's no need to do that, because it's not reversible. Anyway, after glancing at LoginOut.php of SMF 2.0.3 RC, the used hashing method of the password looks correct.
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
DruGzOG
Veteran Member
Join Date: Nov 2007
Location: Unknown
Old 06-29-2010 , 14:35   Re: Changing a table's field
Reply With Quote #14

Yeah I replaced it. Didn't know it was not able to be reversible.

Either way it's not working. I have no clue why and the error_logs don't have anything.
__________________
DruGzOG is offline
Send a message via AIM to DruGzOG
8088
Veteran Member
Join Date: Jan 2008
Old 06-29-2010 , 14:43   Re: Changing a table's field
Reply With Quote #15

There are no errors logged since there are no errors. The script 'works', but it doesn't what you need it to do. The only thing we can conclude safely is that user 'levin' does not have the password that was provided after hashing it. It's probably best to continue your quest on the SMF forums, as there will be more people knowledgeable about how SMF works (I clearly have no idea).

Another thing you could consider, depending on your goal, is to add your code as a plugin. This way you won't have to check user credentials the hard way and can leave it up to SMF itself. It will then also not break after an update in which they've changed the hashing.
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
DruGzOG
Veteran Member
Join Date: Nov 2007
Location: Unknown
Old 06-29-2010 , 14:46   Re: Changing a table's field
Reply With Quote #16

Alright, Thank you for your help
__________________
DruGzOG is offline
Send a message via AIM to DruGzOG
8088
Veteran Member
Join Date: Jan 2008
Old 06-29-2010 , 14:52   Re: Changing a table's field
Reply With Quote #17

No problem. Good luck :)
__________________
steamID converter with OpenSearch browser plugin
8088 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:53.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode