Jump to content

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.04
  • Content Count:  459
  • Reputation:   6
  • Joined:  06/29/12
  • Last Seen:  

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

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


  • Group:  Developer
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  2407
  • Reputation:   613
  • 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:  

2 hours ago, Capuche said:

Oh, thank you :D !

Link to comment
Share on other sites

  • 2 weeks later...

  • Group:  Members
  • Topic Count:  162
  • Topics Per Day:  0.05
  • 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 ‎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
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:  

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
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:  623
  • Reputation:   94
  • 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...