Unique Scrolls and _Memo Table

[blapanda]

I am facing the issues, that I cannot spawn any kind of scroll based unique/monster and as well the _Memo table doesn't work, too.


I am well experienced due adding stuff, creating custom things, etc.
but somehow, since the beginning of the clean vSRO 1.188 files, I am freaking not able to spawn the Automob (which is character and item sided activated!) or any kind of fortress unique via scroll.

Automob:
The item is at the shop, people can buy it, but upon usage, nothing happens. No "invalid target" msg nor anything else.
I can spawn the automob manually.
Same goes for unique scrolls at the fortress clerk.
I can forge the scrolls, can hold them at the inventory, but same crap here. I can manually spawn Tai Sui and few others of all. Most of the others won't work, no idea why.

_Memo Table:
Recording chats isn't working at all.
No matter how I modify the _Memo_Add procedure, I won't get any kind of progression saved at the _Memo table.

Manually executed:
exec _Memo_Add 'TargetPlayer','SenderPlayer','Message','99'

It will say, successfully executed, but still, I won't see any kind of change at the _Memo table.


Does anyone know how to fix these both issues?
Do I must make a trigger for this scroll-monster based crap?

Is the Memo stuff related to something else than database? E.g. ODBC?

[MentaL]

[blapanda]

#Push

[blapanda]

#Push ²

[blapanda]

#Push ...

[OutOfMemory]

exec _Memo_Add 'TargetPlayer','SenderPlayer','Message','99'

Does the SenderPlayer and target player characters is exist?

[blapanda]

Does the SenderPlayer and target player characters is exist?

It is working, if I add 2 existing characters with test msg and count, but it won't continue to progress and record.

[OutOfMemory]

It is working, if I add 2 existing characters with test msg and count, but it won't continue to progress and record.

who told you that? parameters must have a real character names to record at _Memo

I also tested it for you and when executed your query didn't record anything, just add a real character names.

[blapanda]

who told you that? parameters must have a real character names to record at _Memo

I also tested it for you and when executed your query didn't record anything, just add a real character names.

As already said, there will be an entrance to the table, but that's it.
Nothing else will happen serversided.

After using

USE SRO_VT_SHARD
exec _Memo_Add '[GM]Homie','[GM]Buddha','Test','1'

this will show up at the _Memo table:

1

8864

[GM]Buddha

Test

2014-05-07 18:41:00

0

1927

... any ideas? There won't be any other kind of recordings.

[Caosfox]

try with normal names, not [GM]´s
as far i know, only that table is edited/changed

[blapanda]

try with normal names, not [GM]´s
as far i know, only that table is edited/changed

Well, that won't be impossible, since I have few players playing on my server, but their messaging isn't saved either.

[OutOfMemory]

Well, that won't be impossible, since I have few players playing on my server, but their messaging isn't saved either.

Are you using default StoredProcedure [dbo].[_Memo_Add] ?

Are you using any edited database?
try to rest StoredProcedure [dbo].[_Memo_Add] to default

[blapanda]

Are you using default StoredProcedure [dbo].[_Memo_Add] ?

Are you using any edited database?
try to rest StoredProcedure [dbo].[_Memo_Add] to default

It is the default one (as far as I can say), since I didn't change anything on the procedure.

USE [SRO_VT_SHARD]GO
/****** Object:  StoredProcedure [dbo].[_Memo_Add]    Script Date: 07.05.2014 21:38:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
------------------------------------------------ 
-- # PROCEDURE   _Memo_Add ¼??� 
------------------------------------------------ 


ALTER   procedure [dbo].[_Memo_Add] 
                --CE?? ??¶?¹??? 
                 @TargetCharName varchar(64), 
                 @SenderCharName varchar(64), 
                 @message                varchar(300), 
                --?I�? ??¶?¹??? 
                 @Max_MEMO_COUNT int 
        as       


        begin transaction 
                declare  @Target_charid int 
                set  @Target_charid = (select CharID from _Char where CharName16 =  @TargetCharName) 
                if (@@error <> 0 or @@rowcount = 0 ) 
                begin 
                        --��·�¾?�A ¾?¾�~ 
                        rollback transaction 
                        return -1 
                end 


                declare  @memo_count int 
                select  @memo_count = count(*) from _Memo where CharID =  @Target_charid 
                /*if(  @memo_count >=  @Max_MEMO_COUNT ) 
                begin 
                        -- AE??COA? ²E??³�~ 
                        rollback transaction 
                        return -2 
                end*/ 


                --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 
                --              EUROPE_SYSTEM (??AIE�) 
                --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 
                declare  @ReFObjID int 
                select  @ReFObjID = RefObjID from _Char with (nolock) where CharName16 =  @SenderCharName 
                if (@@error <> 0 or @@rowcount = 0 ) 
                begin 
                        rollback transaction 
                        return -4 
                end 


                declare  @RecordDate  smalldatetime 
                set  @RecordDate = GetDate() 
                insert _Memo (CharID, FromCharName,Message,Date,Status,RefObjID)  values(  @Target_charid,  @SenderCharName,  @message,  @RecordDate, 0,  @ReFObjID ) 
                --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 
                --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 
                if (@@error <> 0 or @@rowcount = 0 ) 
                begin 
                        rollback transaction 
                        --E���!! 
                        return -3 
                end 
                                 
                commit transaction 
                return @@identity

PS the database was a clean one. Not modified with any special thing.

[blapanda]

#Push
I need to solve this issue.

[blapanda]

#Push <.<'

[blapanda]

#Push .
I still cannot use the automob (Protector) and fortress uniques.

_Memo fixed.