Connecting MySQL Login to IPS Community Suite Forums!

[FlyingSpoon]

I have my login, but I have no idea how to connect it to my IPS Community Suite Forums.

I saw IP.Board Forums on MTA Forums before, but I cant find anything related to IPS Community Suite Forums.

Any idea how I can do this?

I have put the mta_sdk.php on my forums, but I dont know what to do next.

I connected my login to my Forum database, what shall I do next?

[DBY]

You want log in your server with IPBoard info? If this is so use my code (For earlier versions of IPBoard 4)

->Code:

function lowermd5(val) 
    return string.lower(md5(val)) 
end 
  
-- HOST, DATABASE, USER, PASSWORD, PORT 
local mysqlForumInfo = {"localhost", "testforo", "root", "root", 3306} --Here you should put your MYSQL connection data. 
  
function PlayerLogin(username, password) 
    local host, database, user, pass, port = unpack(mysqlForumInfo) 
    local db = dbConnect( "mysql", "host=" .. host .. ";port=" .. port .. ";dbname=" .. database, user, pass, "share=1", "autoreconnect=1" ) 
    if db then 
        local query = dbQuery(db, "SELECT members_pass_hash, members_pass_salt FROM boardmembers WHERE name = '" .. username .. "' ") 
        local query = dbPoll(query, -1) 
        if #query ~= 0 then 
            local data = query[1] 
            local hash = lowermd5(lowermd5(data.members_pass_salt) .. lowermd5(password)) 
            if hash == data.members_pass_hash then 
                outputDebugString("Correct") 
            else 
                outputDebugString("Incorrect") 
            end 
        else 
            outputDebugString("User not found") 
        end 
    end 
    destroyElement(db) 
end 

[FlyingSpoon]

That's for IP.Board I am looking for IPS Community Suite -

https://www.invisionpower.com/

I tried that code, but it didn't work.

[Dealman]

That's for IP.Board I am looking for IPS Community Suite -

https://www.invisionpower.com/

I tried that code, but it didn't work.

...Aren't they the same? IP.Board is forum software developed by IPS.

[FlyingSpoon]

I think the password decrypt is wrong, because it keeps debugging/outputting 'Incorect'!

[DBY]

With my database, work perfectly. From IPBoard 3.x to 4.x change the password security. I think this change too from IPBoard to IPSuite

[FlyingSpoon]

What do you mean change the password security?

[Syntrax#]

With my database, work perfectly. From IPBoard 3.x to 4.x change the password security. I think this change too from IPBoard to IPSuite

If you install IPB 4.x directly you won't be able to connect since they use a new way to decrypt the files called "Blowfish"

[FlyingSpoon]

So what can I do to connect to my IPS Community Suite board?

[Syntrax#]

So what can I do to connect to my IPS Community Suite board?

try installing IPB 3.x and make your account,try to connect with the older IPB

[GTX]

Do you have IPB 4.x? I found this link and it might be helpful. https://github.com/sijad/IPS4RemoteLogin

Put remote.php into root folder of IPB and see example.php for examples.

Also, there are inbuilt libraries:

https://community.invisionpower.com/4do ... dlers-r97/

https://community.invisionpower.com/4do ... n-sso-r98/

[Ruzy]

Do you have IPB 4.x? I found this link and it might be helpful. https://github.com/sijad/IPS4RemoteLogin

Put remote.php into root folder of IPB and see example.php for examples.

Thanks for the information, is it needed to use PHP SDK for this? And it can be done with fetchRemote?

[FlyingSpoon]

Is PHP SDK need for this? And can it be done with fetchRemote or callRemote?

[GTX]

Yes, but not fetchRemote. MTA PHP SDK is needed to send username and password and then authenticate using sources I gave you. Use callRemote.