vBulletin SOAP API

sorry for my bad english


Changes:

v. 1.0.7
Bugfix in the updateUser function
added getOnlineUsers() function, to get the list of the logged in users

v. 1.0.6
updateUser uand deleteUser updated, now is posible to call it with userid or other field from user table
getStats() funktion added, to get forum stats


v. 1.0.5
Added updateUser, deleteUser to update user data ( email/password, username )
or delete user

v. 1.0.4
Added doActivateSession function to let vbulletin accept sessionid

v. 1.0.3
functions to get userdata and postdata are now done
postmessage returns as formated html

v. 1.0.2
added support for vbulletin "session"
the server can now send all needed cookies, to the client, last 2 optional:
(PREFIXsessionhash/lastvisit/lastactivity/(userid/password))

v. 1.0.1
rename login funtion to doLogin
add placeholder for getUser/setUser, getPost/setPost, getThread/setThread functions
change URL in the WSDL file to relative URL




this is a beta version !!

what this hack do:

this hack provide a soap api to access vbulletin functions over internet
( for example: ebay, amazon or google have they webservices api to access is over soap )

this hack has at the moment this functions

1. login to vbulletin
you must give username and password, as response you get userid and password as md5 ( with salt ) hash

so that you can set vbulletin cookie on your application

2.
a. last X post from the forum
b. last X post from the forum, which the user ( which is loged in, see 1. ) can see

3. manipulate a user, get user information , create users or delete then

4.
get forum statistics from vbulletin ( Sponsored by 1Agency (www.1agency.de) )
you will get new user, max threads/posts and some other stuff as result

5.
get all logged in users in vbulletin


what can you do with this hack ?

you can make common login with your application ( written in PHP/ASP(.NET)/JAVA/C or any language which supports SOAP calls ( for example mozilla firefox ^^)).
to make common login, you must set vbulletin cookie, see 1.

or you can write firefox extension to get last 10 thread from your forum, with threads that you can see

or synchronise users from your application and vbulletin ( this feauture is on development )

other planced feautures are:
write comment
write thread
get thread ( with all comments )


whis SOAP-SERVER is written in PHP5 with SOAP - extension
so that you need to be php5 and soap extension installed on your server
( all new destributions provides php5 and soap extensions as rpm packages )

it is posible to write this server in php4 oder php5 without soap extension ( with nuSOAP or PEAR::SOAP ) but this is not planed at the time, sorry
php
Clients can be written in Java, ASP or PHP, with all language which supports soap
so that you can make common login between an ASP or JSP CMS and Vbulletin


how to install

unpack the package, move the "soap" folder in your forum root
and install the product with product installer

to test the functionality i have included some test files in /soap/examples

you must change the url and username/password and the key in this files


later i will make some examples for typo3/joomla/xoops to access and login into vbulletin

i will accept every help and feedback to make this extension better

updated example is in the "soap" folder

[leonsio]

by which methode?

maybe you should disable the wsdl cache

[jliu]

The fault was shown for the doLogin. Just disabled the wsdl cache, restarted apache, it is still the same. I am running on Windows.

[jliu]

Originally Posted by jliu

The fault was shown for the doLogin. Just disabled the wsdl cache, restarted apache, it is still the same. I am running on Windows.

It is working now -- I had my php.ini error reporting changed to "report errors only" and the problem disappeared.

If I login using the examples/session/login.php, then go to my forum. The forum does not show the user is logged in. Is there anyhting else I need to do to achieve this?

By the way, it would be nice to add a few more methods in the API:

a) check user is logged in or not
b) if user is logged in, get their userid and/or group id

Thanks!

[leonsio]

if you have cookies ( from the server ) the user is logged in
getUsersmethode returns all user details ( groups included too)

[twitch]

Originally Posted by leonsio

one use has created vwar module for my connector for joomla
its the same as vbulletin connector, i will port the module in the next weeks for vbulletin

to use it with this connector and vbulletin

http://forum.joomla.org/index.php/to...html#msg125646

release thread of the connector for vbulletin

so it is posible to have common login between joomla<->vbulletin->vwar ( or vbulletin<->joomla->vwar )

it will be only one login needed

Very cool! Keep us posted on the progress

[oojacoboo]

jliu, I am having the same problem you have. I finally got rid of that first error by defining the absolute path in the server.php file for CDW. I changed it to

path/to/forum/soap

I also defined the absolute /path/to/forum in the /includes/config.php file to be certain.

I now get this returned from the login.php file...

login=> tester:tester
cookies from the server
Array
(
[cookies] =>
)
get the last 10 messages which the user can see

It isn't getting any cookies from the system and it isn't logging me in. I have about a dozen questions on this and the joomla connector. I know this isn't the place to ask the joomla questions, so I won't. BUT I WOULD REALLY LIKE TO SEE A SITE FOR THIS PROJECT! It is really hard to find the documentation and its scattered and very hard to follow. This is probably the 5th time I have offered to help with docs and a website, hosting, everything. I don't understand what the problem is?

So, my question is in regards to the "key"

Does this key need to be stored in a particular place? I have entered it in Joomla and in the "VB Connector" settings. But, I am not certain this is the ultimate location which this key should exist. Is it? Or where do I need to put it? Could this be the reason the user isn't getting logged into the system?

BTW: I recently upgraded our server to mysql 4.1 and php5. As a result the sql_module was broken. None of the posting features worked anymore. So, I decided to take the SOAP route as it was nicer anyway.

EDIT: Am I suppose to have an extra menu in my vbulletin/admincp for this SOAP Product? I have one for the Joomla Connector, but this one doesn't show up after an install. Maybe this is where the key is suppose to be entered...? Any idea why it wouldn't have installed properly?

I have removed it and reinstalled. I checked the xml file and there appears to be a large number of settings that would be the issue it seems. However, I can't find where to access these... What am I missing here? Maybe its just not writing to the database for some reason or another. I have tested the db from the admincp and it is writable. It just appears that the additional fields arn't being created with the table for this product.

EDIT2: Well it has occured to me that the XML file doesn't have any SQL commands to add the proper tables. In addition it is missing a few other necessary XML attributes to add it to the vbulletin admincp the way the application connector has been added. It is also missing the /admincp/.php file necessary. Are there any plans to include these? Are they required? How do I change the key and activate the soap server, etc.? I tried reinstalling after changing the default values in the xml, but that generated an error with vbulletin. Really hoping for some direction here. Thanks Lensio.

[leonsio]

wrong thread

this thread is only for SOAP API, not for problems with other modules
this module dont need any sql tables/changes

P.S. try to write my nickname right

[oojacoboo]

sorry about the nick leonsio, my question IS in regards to the SOAP API and really has nothing to do with anything else. Yes, I am trying to get it to work with Joomla, but thats besides the point now. At the moment I am trying to get it to work with the test files included. If you read my post you would see. Thanks for your time.

[leonsio]

the installer ( XML ) create new field unter vbulletin settings, called SOAP API
you can setup then the Key for the soap connection

more is not needed to have this addon work

maybe you should check if the forumpath under includes/config.php is set

for access joomla from vbulletin side, you must install "vbulletin application connector" which you can find here in forum

in the testfiles you must edit the URL to your soap api and the key
you can not access my forum with this examples ( IP is not allowed )

[oojacoboo]

thanks leonsio. I was able to change the settings now. So, it appears that it may be working properly now, but it doesn't log the user into the forums from the example login.php script. Here is the output that I am getting from the login.php script. Maybe you can tell me what it means the problem may be.

login=> tester:tester
stdClass Object
(
[password] => 99019c1952ef8e438c9baf620ad5819d
[userid] => 551
)
cookies from the server
Array
(
[cookies] => Array
(
[bbsessionhash] => Array
(
[0] => fa434a65ea074d20d0c75dc21db02367
[1] => /
[2] => www(dot)macmod(dot)com
)

[bblastvisit] => Array
(
[0] => 1140403824
[1] => /
[2] => www(dot)macmod(dot)com
)

[bblastactivity] => Array
(
[0] => 0
[1] => /
[2] => www(dot)macmod(dot)com
)

)

)
get the last 10 messages which the user can see

I have tried it with different usernames as well, and I have changed around the key to be sure that mine was compatible. I also tried loading the login.php with bad login info for testing and it lets me know its bad. It also tells me if the key is bad.

In addition I am getting vbulletin error outputs like...

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT userid
FROM user
WHERE testman='testman';

MySQL Error : Unknown column 'testman' in 'where clause'
Error Number : 1054
Date : Monday, February 20th 2006 @ 12:00:23 PM
Script : http://www(dot)macmod(dot)com/forum/soap/server.php
Referrer :
IP Address : 72.36.175.243
Username :
Classname : vB_Database

testman is a valid user in vbulletin as well. I get this vb output via email, as that is how I have specified. Any ideas here? I think I am getting close, just something small.

The files are located at the following...

site/forum/soap
http://www(dot)macmod(dot).com/forum...sion/login.php

I have changed the soapclient url and all the paramaters in the vbulletin options section for the SOAP API as well as the login.php script.

Thanks for all the help man, I really appreciate it, as well as everyone on our site. I am actually sure they will appreciate it more. Cheers.