Mir2 2.3 Server Files

[Primal]

WOOOT PROGRESS FTW!!:
I now have it so when u click Consign it comes up with the window to put your item in, then you select how much u wish to sell for and click ok, but then theres an error
[INFO FOR Stored Procedure]
UM_READYTOSELL_NEW

CREATE PROCEDURE [dbo].[UM_READYTOSELL_NEW]
@param1 nvarchar(50)='',@param2 nvarchar(50)=''
AS 
SELECT count(*) FROM TBL_ITEMMARKET
INSERT INTO [LOM2Market].[dbo].[TBL_ITEMMARKET] 
( [FLD_MARKETNAME],
 [FLD_SELLWHO])
VALUES(@param1,@param2)
GO

This inserts the Servername_NPCname into FLD_Marketname
and inserts the charname into FLD_SELLWHO

 

[Nightwolf]

maybe to beable to sell items you prob need this one UM_CHECK_INDEX not sure tho

 

[Primal]

heres the error i get after clicking ok after inserting the price ect.

 

[dapoldi]

12

 

[Primal]

heres where i am up to:

CREATE PROCEDURE [dbo].[UM_READYTOSELL_NEW]
@param1 nvarchar(50)='',@param2 nvarchar(50)='',@param8 nvarchar(50)=''
AS 
SELECT count(*) FROM TBL_ITEMMARKET
INSERT INTO [LOM2Market].[dbo].[TBL_ITEMMARKET] 
	 ( [FLD_MARKETNAME],
	 [FLD_SELLWHO],
	 [FLD_SELLDATE])
VALUES (@param1,
@param2,
@param8)
GO

which results in this in the TBL_ITEMMARKET
(only them 3 fields get something in them no other param's add anything- all rest = null)

 

[Primal]

Lo lo.. I had an INSERT status there aswell before, but i think (think..think) that the server actually does the insert @ the moment after you've given the amount, and click ok,

so, i figured the ready to sell new thingy prob (see nightwolf) does the checks to make sure you're not only selling something you actually Can sell in the TM, but also checks if its not item no 6 etc.
After doing those checks you can (or not) consign I think..

I think this because there's an insert in the m2server for the tbl

TBL_ITEMMARKET
INSERT INTO TBL_ITEMMARKET (FLD_MARKETNAME,FLD_SELLOK,FLD_ITEMTYPE,FLD_ITEMSET,FLD_ITEMNAME,FLD_SELLWHO,FLD_SELLPRICE,FLD_SELLDATE,FLD_MAKEINDEX,FLD_INDEX,FLD_DURA,FLD_DURAMAX,FLD_DESC0,FLD_DESC1,FLD_DESC2,FLD_DESC3,FLD_DESC4,FLD_DESC5,FLD_DESC6,FLD_DESC7,FLD_DESC8,FLD_DESC9,FLD_DESC10,FLD_DESC11,FLD_DESC12,FLD_DESC13,FLD_COLORR,FLD_COLORG,FLD_COLORB,FLD_PREFIX)
Values('',,,'','',GETDATE(),')

that bit..

And i think that because inserting on clicking agree will indeed result in 2 params being written away, but.. how would the server update that records afterwards? (would mean it'd create an unfinished record everytime you click on agree and then close the windows, corrupting the database with dupe records)

.. i could be totally of here tho, so.. keep posting your findings

just checked, the um_readytosell_new updates the marketname/sellwho/selldate as soon as u click consign so must have to use another code part when u put the item or sumthin in?

 

[Nightwolf]

yes it will also need to check the item index to which items can be sold so it would need to read another thing for that

 

[dapoldi]

12

 

[dapoldi]

12

 

[Nightwolf]

here the timestone scripts i did not had chance to full check them yet but they should be correct

 

[Onuris]

seems to be fine

20chars......

 

[Elvin]

any ideas why i keep getting this constantly in m2server

空各哩: SwordOma (613) 20:44:01
空各哩: SwordOma (62) 20:44:02
空各哩: SwordOma (62) 20:44:03
空各哩: SwordOma (62) 20:44:04
空各哩: SwordOma (621) 20:44:06
空各哩: SwordOma (621) 20:44:07
空各哩: SwordOma (622) 20:44:08
空各哩: SwordOma (622) 20:44:09
空各哩: SwordOma (622) 20:44:11
空各哩: SwordOma (63) 20:44:11
空各哩: SwordOma (63) 20:44:12
空各哩: SwordOma (63) 20:44:13
空各哩: SwordOma (63) 20:44:14
空各哩: SwordOma (63) 20:44:16
空各哩: SwordOma (64) 20:44:18
空各哩: SwordOma (64) 20:44:19
空各哩: SwordOma (64) 20:44:20
空各哩: SwordOma (64) 20:44:21
空各哩: SwordOma (66) 20:44:23
空各哩: SwordOma (66) 20:44:25
空各哩: SwordOma (66) 20:44:25
空各哩: SwordOma (66) 20:44:26

translated - 空各哩 + spacial each

 

[wazz]

Anyone aware of the following error in M2Server when you are in character screen and you click the start button?

invalid admission: "LPH?@<<AOQDKC?LmWCEwTcauUr=_UByhYBpS@]TMBmPNBlDVC\<K?\tDI_TmH_X^JOt]En<_GN\fGh_Q"

The screen just stays black and obviously doesn't let me in. If anyone has come across this before and knows of a possible way to fix it then it'd be much appriciated.

thanks.

 

[dapoldi]

12

 

[Nightwolf]

Anyone aware of the following error in M2Server when you are in character screen and you click the start button?

invalid admission: "LPH?@<<AOQDKC?LmWCEwTcauUr=_UByhYBpS@]TMBmPNBlDVC\<K?\tDI_TmH_X^JOt]En<_GN\fGh_Q"

The screen just stays black and obviously doesn't let me in. If anyone has come across this before and knows of a possible way to fix it then it'd be much appriciated.

thanks.

oops edited mpt the error i was thinking off

 

[IceMan]

any world of the new set files coming out?

 

[Nightwolf]

ye hopefully there be an updated db and loginserver aswell from what i heard oh here the full list of npc script commands to use within npc scripts.

SETLOVERFLAG
RESET
SETOPEN
SETUNIT
RESETUNIT
TAKE
GIVE
TAKEW
CLOSE
CLOSENOINVEN
MAPMOVE
MAP
BREAK
TIMERECALL
TIMERECALLGROUP
BREAKTIMERECALL
PARAM1
PARAM2
PARAM3
PARAM4
TAKECHECKITEM
MONGEN
MONCLEAR
MOV
INC
DEC
SUM
MOVR
EXCHANGEMAP
RECALLMAP
ADDBATCH
BATCHDELAY
BATCHMOVE
PLAYDICE
PLAYROCK
ADDNAMELIST
DELNAMELIST
RANDOMSETDAILYQUEST
SETDAILYQUEST
GIVEEXP
TAKEGRADEITEM
GOQUEST
ENDQUEST
GOTO
SOUND
SOUNDALL
CHANGEGENDER
KICK
MOVEALLMAP
MOVEALLMAPGROUP
RECALLMAPGROUP
WEAPONUPGRADE
SETALLINMAP
INCPKPOINT
DECPKPOINT
MOVETOLOVER
BREAKLOVER
USEFAMEPOINT
DECWEAPONBADLUCK
DECDONATION
SHOWEFFECT
MONGENAROUND
RECALLMOB
GUILDSECESSION
GIVETOLOVER
INCMEMORIALCOUNT
DECMEMORIALCOUNT
SAVEMEMORIALCOUNT
INSTANTPOWERUP
INSTANTEXPDOUBLE
HEALING
UNIFYITEM

 

[Zidio]

i was going to read this thread untill i saw it was 52 pages long >.< o well i think a mod should clean all the useless posts and just keep the helpfull posts just an idea?

 

[Elvin]

@ Elvin, Set the SwordOma lvl to 69, undead to 0.. (didnt check if lvl was necc aswell.. couldnt be arsed, but it does solve the error )

cheers m8 worked a treat

 

[Nightwolf]

here a couple of gt npcs i have done still got the steps in the palace todo