Aleos

Cash Shop Sale System

Recommended Posts

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

Great job @Lemongrass

 

  • Upvote 1

Share this post


Link to post
Share on other sites
4 hours ago, Lai said:

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

Great job @Lemongrass

 

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

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

Share this post


Link to post
Share on other sites

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 ~ /no1 

Share this post


Link to post
Share on other sites
On 28-12-2016 at 10:43 PM, 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.

:(

screen_Keyron000.jpg

Edited by fictionx

Share this post


Link to post
Share on other sites

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

  • Upvote 1

Share this post


Link to post
Share on other sites

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 by Radian

Share this post


Link to post
Share on other sites

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

  • Upvote 1

Share this post


Link to post
Share on other sites

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.
 

Share this post


Link to post
Share on other sites
On ‎2017‎年‎2‎月‎22‎日 at 6:55 AM, 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.
 

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.

  • Upvote 1

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
8 hours ago, 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.

nvm, tested. 0x9b2 and 0x9c4 work

  • Upvote 1

Share this post


Link to post
Share on other sites

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... :-/

  • Upvote 1

Share this post


Link to post
Share on other sites

this system is fantastic, congratulations on the release.

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.