Jump to content

Connecting MySQL Login to IPS Community Suite Forums!


FlyingSpoon

Recommended Posts

Posted

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?

Posted

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 

Posted
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.

If I help you in a thread and you need further assistance, please don't PM me - use the thread you created instead. This way everyone on the forum can take advantage of it.

Posted
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" :|

Nothing is impossible when you acquire the knowledge
 
Posted
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

Nothing is impossible when you acquire the knowledge
 
Posted

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/

Do you require a paid scripter? Contact me! (Unavailable) Currently I am experienced in Lua, PHP, HTML, CSS, SQL and JS.

Developer and owner of

https://projectbea.st - Project Beast
Posted

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

Do you require a paid scripter? Contact me! (Unavailable) Currently I am experienced in Lua, PHP, HTML, CSS, SQL and JS.

Developer and owner of

https://projectbea.st - Project Beast

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...