Really this is a noob question. Can any1 help me setting up SQL Server add me to msn pls: [email protected]
Thx!
Thx!
Mir2 2.3 Server Files
- Thread starter MiloFoxburr
- Start date
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 toodapoldi said: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)
cheers
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 ....dapoldi said: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)
also dm2 files are different as far as im aware even if they are sources...
i notice 1 place where your going wrong and thats you have TBL_MARKETITEMS whereas it should be TBL_ITEMMARKETdapoldi said:@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
lol i'm tryin it out nowdapoldi said:.. just a typo
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.
ty for post thowas just pointing out that if u had an error maybe that was why but obviously not.
thanks agen
Well this is what i have so far:
UM_LOAD_ITEMSET
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
UM_LOAD_ITEMSET
Code:
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
GOException) 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