call MSSQL stored procedure

Results 1 to 4 of 4
  1. #1
    Enthusiast Tocher is offline
    MemberRank
    Feb 2010 Join Date
    30Posts

    call MSSQL stored procedure

    I want to call mssql stored procedure by php/sql script, i try this, but it dosen`t help.
    PHP Code:
    $msconnect=mssql_connect("ip","user","pass");
    $msdb=mssql_select_db("MuOnline",$msconnect);
    $stmt mssql_init('WZ_****');
    mssql_bind($stmt'@memb___id',  $account,  SQLVARCHAR,  false,  false,  10);
    mssql_execute($stmt);
    mssql_free_statement($stmt); 


  2. #2
    Kingdom of Shadows [RCZ]ShadowKing is offline
    MemberRank
    Jul 2007 Join Date
    1,644Posts

    Re: call MSSQL stored procedure

    PHP Code:
    mssql_query("EXEC ProcedureName(param1, param2,....)"); 

  3. #3
    Enthusiast Tocher is offline
    MemberRank
    Feb 2010 Join Date
    30Posts

    Re: call MSSQL stored procedure

    i test the code and it work, but player stil playing (procedure - DISCONNECT) how to disconnect player from web?
    in online players he don`t show.

  4. #4
    Kingdom of Shadows [RCZ]ShadowKing is offline
    MemberRank
    Jul 2007 Join Date
    1,644Posts

    Re: call MSSQL stored procedure

    You can't(by default), you need to send disconnect packet to joinserver in order to disconnect a player.
    If you make custom packet in joinserver which will be able to disconnect the player you can use sockets in order to communicate with joinserver.



Advertisement