Untitled

 

<jive>

  <adminConsole>

    <port>9090</port>  

    <securePort>9091</securePort>

  </adminConsole>  

  <admin>

    <authorizedUsernames>admin</authorizedUsernames>

  </admin>  

  <locale>en</locale>  

  <jdbcProvider>

    <driver>com.mysql.jdbc.Driver</driver>  

    <connectionString>jdbc:mysql://x13-corp.dk/forum?user=forum&amp;password=forum</connectionString>

  </jdbcProvider>  

  <database>

    <defaultProvider>

      <driver>com.mysql.jdbc.Driver</driver>  

      <serverURL>jdbc:mysql://x13-corp.dk:3306/jabber</serverURL>  

      <username>jabber</username>  

      <password>jabber</password>  

      <testSQL>select 1</testSQL>  

      <testBeforeUse>true</testBeforeUse>  

      <testAfterUse>true</testAfterUse>  

      <minConnections>5</minConnections>  

      <maxConnections>25</maxConnections>  

      <connectionTimeout>1.0</connectionTimeout>

    </defaultProvider>

  </database>

  <provider>

    <auth>

      <className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className>

    </auth>  

    <user>

      <className>org.jivesoftware.openfire.user.JDBCUserProvider</className>

    </user>  

    <group>

      <className>org.jivesoftware.openfire.group.JDBCGroupProvider</className>

    </group>

  </provider>  

  <jdbcAuthProvider>

    <passwordSQL>SELECT user_password FROM phpbb_users WHERE username_clean=?</passwordSQL>  

    <passwordType>md5</passwordType>

  </jdbcAuthProvider>  

  <jdbcUserProvider>

    <loadUserSQL>SELECT username_clean,user_email FROM phpbb_users WHERE username_clean=?</loadUserSQL>  

    <userCountSQL>SELECT COUNT(*) FROM phpbb_users</userCountSQL>  

    <allUsersSQL>SELECT username_clean FROM phpbb_users</allUsersSQL>  

    <searchSQL>SELECT username_clean FROM phpbb_users WHERE</searchSQL>  

    <userGroupsSQL>SELECT group_name FROM phpbb_groups WHERE group_id in (SELECT group_id FROM phpbb_user_group WHERE user_id in (SELECT user_id FROM phpbb_users WHERE username=?))</userGroupsSQL>  

    <usernameField>username_clean</usernameField>  

    <nameField>username</nameField>  

    <groupField>group_name</groupField>  

    <emailField>user_email</emailField>

  </jdbcUserProvider>  

  <jdbcGroupProvider>

    <groupCountSQL>SELECT count(*) FROM phpbb_groups where group_name != 'BOTS'</groupCountSQL>  

    <allGroupsSQL>SELECT group_name FROM phpbb_groups where group_name != 'BOTS'</allGroupsSQL>  

    <userGroupsSQL>SELECT group_name FROM phpbb_groups WHERE group_id in (SELECT group_id FROM phpbb_user_group WHERE user_id in (SELECT user_id FROM phpbb_users WHERE username=?))</userGroupsSQL>  

    <descriptionSQL>SELECT group_desc FROM phpbb_groups WHERE group_name=?</descriptionSQL>  

    <loadMembersSQL>SELECT username FROM phpbb_users WHERE user_id in (SELECT user_id FROM phpbb_user_group WHERE group_leader=0 and group_id in (SELECT group_id FROM phpbb_groups WHERE group_name != 'BOTS' and group_name=?))</loadMembersSQL>  

    <loadAdminsSQL>SELECT username FROM phpbb_users WHERE user_id in (SELECT user_id FROM phpbb_user_group WHERE group_leader=1 and group_id in (SELECT group_id FROM phpbb_groups WHERE group_name != 'BOTS' and group_name=?))</loadAdminsSQL>

  </jdbcGroupProvider>  

  <connectionProvider>

    <className>org.jivesoftware.database.DefaultConnectionProvider</className>

  </connectionProvider>  

  <setup>true</setup>