vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBulletin SOAP API (https://vborg.vbsupport.ru/showthread.php?t=100559)

leonsio 02-20-2006 04:00 PM

it seems to be working

if you want to have automaticaly login, try to enable the "Send password and userid cookie?" option

latest threads can be displayed only if the forum is active

the example scripts does not set any cookies, it displays only the cookies that you get from the server, this cookies can be set and your user should be logged in

( on disable forums it can only work if you are administrator )

oojacoboo 02-20-2006 07:45 PM

I know this isn't the right place to discuss the application connector and the joomla com_connector, but thats what I am ultimately trying to get to work.

How can I test to make sure that this SOAP API is actually working the way it is intended. I am afraid I am wasting my time trying to get the other connectors working when the SOAP API is the culprit.

I am trying this login.php script again, b/c I feel like its the best one for testing. The forums are turned off, but I am testing with a admin log and pass as well. That last one I sent was just an example. Although, with the admin log and pass it appears the same as the other one, but I can't see the last 10 posts. Shouldn't I be able to even with the forums off?

I did try forcing the SOAP server to pass the cookie and session. However, that doesn't log me into the forums with the script either.

Also, When I attempt that login.php I get this error returned to my email...

Quote:

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 @ 04:38:52 PM
Script : http://www(dot)macmod(dot)com/forum/soap/server.php
Referrer :
IP Address : 72.36.175.243
Username :
Classname : vB_Database
It appears that testman is being passed instead of the title of the column, (username, login, logid, or whatever its called). Whats the deal here? Any ideas?

Again, many thanks.

leonsio 02-20-2006 07:55 PM

which method have you called

i have changed the api in 7 to 8 version on update/delete/ user functions
so that examples can be "buggy"

oojacoboo 02-20-2006 08:23 PM

this is the login.php I am using...

PHP Code:

<?php
session_start
();
echo 
"<pre>";

try
{
    
$connect= new SoapClient('http://www(dot)macmod(dot)com/forum/soap/server.php?wsdl');
    if(isset(
$_SESSION['cookies']))
        
$connect->_cookies=$_SESSION['cookies'];

        
$params=array(  'key'           =>      'thecorrectkey',
                       
'password'      =>      'password',
                       
'username'      =>      'testman'
                                
);

        
// make login
        
echo "login=> tester:tester\n";
        
$result=$connect->__call('doLogin'$params);
    
// get the answer 
        
print_r($result);
    if(!isset(
$_SESSION['cookies']))
        
$_SESSION['cookies']=$connect->_cookies;
}
catch( 
SoapFault $ex)
{
    
// error message
    
print_r($ex);
}

echo 
"cookies from the server\n";
print_r($_SESSION);


?>
<a href="latest10.php">get the last 10 messages which the user can see</a>

I am guessing that it uses the SOAP API and posts to the soap/server.php for processing. I am using the one that is attached to the first post of this thread. I assume the latest one.

BTW, I can produce that error in the previous post by "Logging Out" of the system. It will generate that error everytime.

oojacoboo 02-22-2006 02:18 PM

im guessing that there is something in the server.php file that is incorrect as, I get the error from vbulletin when I process a "log out" from the fourm itself. Any ideas here?

leonsio 02-22-2006 02:44 PM

which error?

oojacoboo 02-22-2006 03:31 PM

this one from the previous post.

Quote:

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 @ 04:38:52 PM
Script : http://www(dot)macmod(dot)com/forum/soap/server.php
Referrer :
IP Address : 72.36.175.243
Username :
Classname : vB_Database

leonsio 02-23-2006 09:51 AM

Quote:

BTW, I can produce that error in the previous post by "Logging Out" of the system. It will generate that error everytime.
wait a second, where no function logout in this API....

maybe you call a wrong function?

oojacoboo 02-23-2006 10:44 PM

I haven't customized anything. I have installed it exactly like the instructions. Do you think you could make the instructions maybe a little more clear? They are missing lots of steps for the install, and kinda confusing.

Maybe its not on a logout, I don't know. But I do get this error from the SOAP API script. As you can see the url has the server.php as the script.

Why is testman=testman? Shouldn't it be like "username=testman" ? Whats the deal with this?

leonsio 02-24-2006 05:01 AM

i have asked you some posts before, which methode call do you use?

which example script?

it is allways right with the api, it can be that the scripts are out of date


All times are GMT. The time now is 08:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01421 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete