Vanilla Forum integration

[GoogleCodeExporter]

Not a bug.  Our guild utilizes Vanilla Forum software and I'd like to integrate 
users from that into RaidPlanner.

I am not very good with php/sql or I would attempt to do it myself.

I can provide limited access to the SQL or full access to a test forum if it 
would help.

Is this something that could be added?

Original issue reported on code.google.com by roger.w....@gmail.com on 4 Apr 2013 at 6:34

[GoogleCodeExporter]

Do you mean this forum?
http://vanillaforums.org

Original comment by arne.cl...@gmail.com on 5 Apr 2013 at 7:20

• Changed state: NeedsMoreInfo

[GoogleCodeExporter]

Yes.  There is a hosted version and a version you can install on your own 
host(which is what we do).

Original comment by roger.w....@gmail.com on 5 Apr 2013 at 1:19

[GoogleCodeExporter]

Looks like they're doing some basic md5 rounds with prefixing when hashing and 
their code looks very readable (in contrast to other forums).
-> aka. "should be no problem".

I'll put that on the schedule for 0.9.8 as it will not introduce anything risky 
or UI related (besides a new tab in the setup panel)

Original comment by arne.cl...@gmail.com on 5 Apr 2013 at 3:42

• Added labels: FixScheduledFor-0.9.8

[GoogleCodeExporter]

Original comment by arne.cl...@gmail.com on 5 Apr 2013 at 3:42

• Changed state: Accepted

[GoogleCodeExporter]

Thank you.  Please let me know if I can assist in any way.

Original comment by roger.w....@gmail.com on 5 Apr 2013 at 3:55

[GoogleCodeExporter]

Full vanilla support has been integrated in 0.9.8.

1. To use it with version 0.9.7, download the attached file and copy the 
contents to your installation.

2. After this you will need to edit the file lib/config/config.vanilla.php to 
match your installation.
2.a. The config contained in the attached file will convert users with the 
"member" role to members and users with the "admin" role to raidleads.
2.b. If you want to change these values have a look at the vanilla-table 
"GDN_Roles" to retrieve the ids.

3. As a final step you need to update your raidplaner database and add the 
value "vanilla" to <prefix>_User.ExternalBinding.
Here is the command for the default installation values:
ALTER TABLE  `raids_User` CHANGE  `Group`  `Group` ENUM(  'admin',  'raidlead', 
 'member',  'none' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

Please keep in mind that changing the database might lead to a warning when 
updating from 0.9.7 to 0.9.8 once that version is released. This warning can be 
ignored though.

Original comment by arne.cl...@gmail.com on 21 Apr 2013 at 3:05

• Changed state: Fixed

Attachments:

• lib.zip

[GoogleCodeExporter]

Not officially released yet, so "done" is the correct status ^^

Original comment by arne.cl...@gmail.com on 21 Apr 2013 at 3:06

• Changed state: Done

[GoogleCodeExporter]

I copied the files as indicated, edited the config, and ran the sql command.  
All completed successfully, but I do not see any of my Vanilla users in the 
Settings - Users area using the admin account.

I verified all the users are set as Member in Vanilla and I am set as Admin.

When I look at setup I do not see a Vanilla options panel in the bindings tab 
which I found odd since it looked like the lib.zip you gave me would have added 
it.

I'm wondering if I am missing the script you talk about in step 2a?

Original comment by roger.w....@gmail.com on 23 Apr 2013 at 1:14

[GoogleCodeExporter]

Users will be added when they log in for the first time.
The setup tool changes are not included in the files posted above but will be 
part of 0.9.8.

Original comment by arne.cl...@gmail.com on 23 Apr 2013 at 6:25

[GoogleCodeExporter]

Oh - and I attached the wrong SQL line *whoops*

ALTER TABLE  `raids_user` CHANGE  `ExternalBinding`  `ExternalBinding` CHAR( 10 
) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

Original comment by arne.cl...@gmail.com on 23 Apr 2013 at 8:02

[GoogleCodeExporter]

Original comment by arne.cl...@gmail.com on 26 May 2013 at 9:41

• Changed state: Fixed