[SQL] USP_MAIL_SEND (with items + /giveitem)

[fasa2008]

Ah, fix is coming!
Posted via Mobile Device

Sorry bother, I thought nobody had noticed this error I mentioned above ... Thanks!

[sky0165]

And what about the Pang Pouch ? '-'

[chreadie]

After some testing i found no error.

Try this:

"You may need to insert a value into dbo.TA_PARTS_GRP_LIMIT otherwise you might not be able to obtain items from mails."

[fasa2008]

After some testing i found no error.

Try this:

"You may need to insert a value into dbo.TA_PARTS_GRP_LIMIT otherwise you might not be able to obtain items from mails."

I do not know what values to insert in this table

[chreadie]

I dont remember exactly but itemgroup and how many of that type of item an user is allowed to have is what its for. Play around some!
Posted via Mobile Device

[Liphe_xD]

when I try to send a larger amount of items you do not receive a once only, example: sending 50 Streenght Boost for the person having command of gm ...

is not possible to receive, gives error.

how to solve?

[chreadie]

Check the limit table discussed in this thread
Posted via Mobile Device

[Sonict]

I have given up on trying to figure out what to put in the table since I know I'll be guessing forever. I have little knowledge on SQL to begin with. Now... What would be nice is if someone took a screenshot of what should be in that table.

Thanks!

[chreadie]

The table TA_PARTS_GRP_LIMIT wants the values:

GRP (which is group id, 6 for consumables)
GRP_LIMIT (How many items in this group should an user be able to hold in its inventory?)
USE_YN (dunno, i put Y here)
IN_DATE (dunno i have null here)

so to be able to use /giveitem with strength boosters you have to input (limit is up to you):

GRP - GRP_LIMIT - USE_YN
6 2000 Y

[Sonict]

Thanks... However, Whatever I send ends up lost in the mail... :/

Actually... It is because I am a GM so it never works for me!

I used two test accounts and at least for regular items... It works now!

[fasa2008]

The table TA_PARTS_GRP_LIMIT wants the values:

GRP (which is group id, 6 for consumables)
GRP_LIMIT (How many items in this group should an user be able to hold in its inventory?)
USE_YN (dunno, i put Y here)
IN_DATE (dunno i have null here)

so to be able to use /giveitem with strength boosters you have to input (limit is up to you):

GRP - GRP_LIMIT - USE_YN
6 2000 Y

Thanks friends, problem solved ...

[chreadie]

Fixed sending of Pang Pocket (TypeID: 436207632)

[Diovannel2]

Hm... what about gifts?
I Trough with mail working gifts on the shop would work too, but it isn't.

[chreadie]

I get an error about password beeing wrong when i try to send gifts, probably nothing to do with this sp
Posted via Mobile Device

[top1]

Why Pang Pocket can only add 20k pang per a time ?
How can i increase it ?