Mir2 2.3 Server Files

[Onuris]

Really this is a noob question. Can any1 help me setting up SQL Server add me to msn pls: [email protected]

Thx!

 

[Robert]

OR you could read the hundereds of posts on it in this thread, HELL even i made a guide on how to set sql up..

 

[dapoldi]

12

 

[Nightwolf]

well in the M2 it does have EXEC before the name from them i posted above

 

[dapoldi]

12

 

[Primal]

never mind...............

 

[Primal]

.. Edited, see if my idea works

did it work?
/20 charrss

 

[dapoldi]

12

 

[Primal]

Yup it does.. got it writing n fetching now, working is something else tho

now to find out precisely which data(and types) the server expects back on his Execs though..

msg-ed xs for some info, unless he created them himself already.. (which should be easy with the source around)

could you explain what u mean by 'got it writing n fetching now...' and also tell us what u did so we can work on it too cheers

 

[Elvin]

Yup it does.. got it writing n fetching now, working is something else tho

now to find out precisely which data(and types) the server expects back on his Execs though..

msg-ed xs for some info, unless he created them himself already.. (which should be easy with the source around)

and also explain by what you mean as the sources are around cos as far as im aware this is a 2.3 server thread and not the DM2 thread ....

also dm2 files are different as far as im aware even if they are sources...

 

[spunky05]

and also explain by what you mean as the sources are around cos as far as im aware this is a 2.3 server thread and not the DM2 thread ....

also dm2 files are different as far as im aware even if they are sources...

Think he's talking about xsoffee who has the source for the 2.3 files

 

[dapoldi]

12

 

[xsoffee]

the storage procedures i'll create its.

 

[dapoldi]

12

 

[Primal]

@elvin, see spunks post.. thats what I mean. no DM2 involved.

@Badboy:
What you'll have to do is create the required stored procedures in SQL (the UM_'s night posted before), these UM_'s are executed by the M2 server when using the TM, based on the actions you're going through in the TM different UM's will be executed, the thing is.. we'll have to find the right sequence, and contents for the UM's to be executed.

f.e. the server will exec the UM_LOAD_USERNAME with parameters (Marketname and username), the procedure thus will have to contain an sql query that accepts those 2 parameters and.. returns the desired information, here comes the "I think" factor in.. (cogito ergo sum inc.)

The UM_LOAD_USERNAME is executed when I request to see my personal for sale items (market_100), parameters are marketname / username
So.. UM_LOAD_USERNAME should be a query that @ least Fetches all rows for the user 'me' @ market 'x' (marketname = servername_npc name)
this in sql this would be a

SELECT * FROM TBL_MARKETITEMS WHERE (FLD_MARKETNAME = @param1) AND (FLD_SELLWHO = @param2)

where @param1 and @param2 are declared vars.

Thing is tho.. i dont know if the server want the * (aka.. the lot) returned.. or .. just a few fields.. department of trial n error.

If you just want to test a write with it, change the query to an insert statement, you'll see the the UM = executed and both given parameters are written to the fields you entered in the stored procedure.

You can check which parameters are sent by the server by looking @ the server error msgs on trying to use the TM without the procedure's or an incorrect procedure ..

And.. for every UM its a different story.. the Names give their function away tho..

hope this gets some of us started.
VC

i notice 1 place where your going wrong and thats you have TBL_MARKETITEMS whereas it should be TBL_ITEMMARKET

 

[dapoldi]

12

 

[Primal]

.. just a typo which, only exists in that post lol
but, i think you figured that for yourself already..

Hope thats not the most useful thing you managed to get from that post tho, kinda defeats the effort of typing it.

lol i'm tryin it out now ty for post tho
was just pointing out that if u had an error maybe that was why but obviously not.
thanks agen

 

[dapoldi]

12

 

[Primal]

Well this is what i have so far:
UM_LOAD_ITEMSET

CREATE PROCEDURE [dbo].[UM_LOAD_ITEMSET]
@param1 nvarchar(50)='',@param2 nvarchar(50)=''
AS
SELECT * FROM TBL_ITEMMARKET
WHERE FLD_MARKETNAME = '@param1' AND FLD_SELLWHO = '@param2'
ORDER BY FLD_SELLDATE
GO

when i have this info in it stops coming up with the
Exception) TFrmSql.LoadPageUserMarket -> Open (1)
:EXEC UM_LOAD_ITEMSET 'DRAGON_GTMAN',1
SUCCESS DBSQL CONNECTION
DBSQL Reconnected...
error in the M2server also i can now click + insert text into the find field in the merchant thing but no items are loading up just yet

 

[dapoldi]

12