Forum

Results 1 to 2 of 2
  1. #1
    Join Date
    June 2009
    Location
    Washington
    Posts
    10

    SMF v1.1 Integration

    I have this working with MySql now. And I realize it's still in beta... but anyone have any idea how I can integrate it with my SMF 1.1 forum so it's one shared user/pwd? (And I'd need to do it without triggers, if possible)

  2. #2
    Join Date
    May 2009
    Location
    canada
    Posts
    21
    i got teamspeak2 integrated into my VBforum by editing the sql files.

    Code:
    SELECT
     userid as i_client_id,
     if(username='virus',0,1) as i_client_server_id,
     (membergroupids REGEXP '(^|,)(35)(,|$)')*-1 AS b_client_privilege_serveradmin,
     username as s_client_name,
     password as s_client_password,
     dt_crapfield as dt_client_created,
     dt_crapfield as dt_client_lastonline
    FROM
     forums3.user
    WHERE
        membergroupids regexp '(^|,)(12)(,|$)' = 1
    AND usergroupid NOT IN ( 1, 3, 4, 8 )
    AND username = :sName
    AND password= MD5(CONCAT(MD5(:sPassword),salt))
    that is the sql called when a user tries to log in.

    i imagine it would be similar to get it working in ts3. although at a first glance there are 4 different client_get_by_ files. and im not sure which(if any) of them is used when logging in.

    also you should note that TS3 doesnt use a username/password(as far as i have seen). it assigns unique ids to each person connecting to the server. and i have no idea how those ids are generated.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vBulletin Integration
    By FeverVirus in forum Windows
    Replies: 3
    Last Post: December 30th, 2009, 02:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •