Cash Shop Sale System

[Lai]

STFU to all drama, we are all stealing stuff from Gravity, so  

Great job @Lemongrass

 

[rakuzas]

  On 1/2/2017 at 9:30 AM, Lai said:

STFU to all drama, we are all stealing stuff from Gravity, so  

Great job @Lemongrass

 

Expand  

Yup.. And I keep reading from the top..

BTW.. Thanks @Lemongrass too.. And all of you guys here..

[Jezu]

Seriously guys? fighting over credit? It's 2017 now! We're on the same client feature and we're stealing it from Gravity. Aside from that, why we always get drama here XD the fact that this is only a small feature (I guess) but, let's move on guys. We are not kids anymore. 

 

To @Lemongrass excellent job bruh ~  

[fictionx]

  On 12/29/2016 at 1:43 AM, fictionx said:

How can i fix this?

 

: DB error - Column count doesn't match value count at row 1

	[Debug]: at cashshop.c:296 - INSERT INTO `sales`(`nameid`,`start`,`end`,`amount`) VALUES ( '919', FROM_UNIXTIME(1482976800), FROM_UNIXTIME(1482980400), '100', '1' )

when i try to put a item in the window the console give me that error.

Expand  

Edited January 5, 2017 by fictionx

[Capuche]

Did you update your branch ? https://github.com/rathena/rathena/pull/1825/commits/d2f8852a56f6e2510b9cd0b5f9afac36ec6c6063

[Lemongrass]

Make sure you have animal skin in your item_cash_db with type 8. It will not work otherwise.

[fictionx]

  On 1/6/2017 at 2:40 PM, Capuche said:

Did you update your branch ? https://github.com/rathena/rathena/pull/1825/commits/d2f8852a56f6e2510b9cd0b5f9afac36ec6c6063

Expand  

Oh, thank you !

[Radian]

Hi im having this issue everytime i tried to search
 

if( SQL_ERROR == Sql_Query(mmysql_handle, "INSERT INTO `%s`(`nameid`,`start`,`end`,`amount`) VALUES ( '%d', FROM_UNIXTIME(%d), FROM_UNIXTIME(%d), '%d' )", sales_table, nameid, (uint32)from, (uint32)to, count) ){ 

and I got new issue I tried to add an limited item

[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484568000), FROM_UNIXTIME(1485352800), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484568000), FROM_UNIXTIME(1484654400), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484568000), FROM_UNIXTIME(1484654400), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484521200), FROM_UNIXTIME(1484607600), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484521200), FROM_UNIXTIME(1484528400), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484521200), FROM_UNIXTIME(1484524800), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484521200), FROM_UNIXTIME(1484737200), '30', '15' )
[SQL]: DB error - Unknown column 'price' in 'field list'
[Debug]: at cashshop.c:307 - INSERT INTO `sales`(`nameid`,`start`,`end`,`price`,`amount`) VALUES ( '32046', FROM_UNIXTIME(1484521200), FROM_UNIXTIME(1484737200), '30', '99' )

 

Edited January 15, 2017 by Radian

[Lemongrass]

This issue was already fixed. Please merge the latest updates.

[Felten]

Every time i try to set a new sale, my character disconnect.

[Warning]: clif_parse: Received unsupported packet (packet 0x0a3d, 18 bytes received), disconnecting session #8.

[Info]: Character 'Felten' logged off.
 

[Inkfish]

  On 2/21/2017 at 10:55 PM, Felten said:

Every time i try to set a new sale, my character disconnect.

[Warning]: clif_parse: Received unsupported packet (packet 0x0a3d, 18 bytes received), disconnecting session #8.

[Info]: Character 'Felten' logged off.
 

Expand  

when i test with 2015-10-29 RE client, i encounter this too. just change the "saleopen" packet to 0xa3d, and extend the length to 18 will make registration work. i suppose  they just use 2 bits to send item amount.

however i doubt 0x9b2 and 0x9c4 still works.

[Lemongrass]

Please note that the packets we added are for the main client and not for the sakray client.

The feature was working fine for me on the 2015-11-04 Ragexe. I will look into it next week and see if I can guess what changed though.

[Inkfish]

  On 2/25/2017 at 9:12 PM, Lemongrass said:

Please note that the packets we added are for the main client and not for the sakray client.

The feature was working fine for me on the 2015-11-04 Ragexe. I will look into it next week and see if I can guess what changed though.

Expand  

nvm, tested. 0x9b2 and 0x9c4 work

[Lemongrass]

Added in Git Hash: 7ecaf8b and the typo follow up Git Hash: 43ba736.
RE clients seem to support more hours than main clients.
Well the main clients have the packet too, but they do not send it... :-/

[Kakaroto]

this system is fantastic, congratulations on the release.