Jump to content
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×

Cash Shop Sale System


Aleos

Recommended Posts


  • Group:  Members
  • Topic Count:  6
  • Topics Per Day:  0.00
  • Content Count:  58
  • Reputation:   4
  • Joined:  11/22/11
  • Last Seen:  

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

Great job @Lemongrass

 

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  152
  • Topics Per Day:  0.03
  • Content Count:  459
  • Reputation:   7
  • Joined:  06/29/12
  • Last Seen:  

  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.. ^_^

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  29
  • Topics Per Day:  0.01
  • Content Count:  566
  • Reputation:   34
  • Joined:  11/17/11
  • Last Seen:  

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 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  122
  • Reputation:   17
  • Joined:  12/10/12
  • Last Seen:  

  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  

:(

screen_Keyron000.jpg

Edited by fictionx
Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  2407
  • Reputation:   616
  • Joined:  07/05/12
  • Last Seen:  

Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  547
  • Reputation:   270
  • Joined:  11/08/11
  • Last Seen:  

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

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  122
  • Reputation:   17
  • Joined:  12/10/12
  • Last Seen:  

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

Oh, thank you :D !

Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.04
  • Content Count:  1546
  • Reputation:   192
  • Joined:  07/23/14
  • Last Seen:  

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
Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  547
  • Reputation:   270
  • Joined:  11/08/11
  • Last Seen:  

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

  • Upvote 1
Link to comment
Share on other sites

  • 1 month later...

  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  104
  • Reputation:   15
  • Joined:  01/18/16
  • Last Seen:  

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.
 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   2
  • Joined:  11/29/11
  • Last Seen:  

  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.

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  547
  • Reputation:   270
  • Joined:  11/08/11
  • Last Seen:  

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.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   2
  • Joined:  11/29/11
  • Last Seen:  

  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

  • Upvote 1
Link to comment
Share on other sites


  • Group:  Developer
  • Topic Count:  28
  • Topics Per Day:  0.01
  • Content Count:  547
  • Reputation:   270
  • Joined:  11/08/11
  • Last Seen:  

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
Link to comment
Share on other sites

  • 6 months later...

  • Group:  Members
  • Topic Count:  99
  • Topics Per Day:  0.02
  • Content Count:  638
  • Reputation:   95
  • Joined:  05/11/12
  • Last Seen:  

this system is fantastic, congratulations on the release.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...