Jump to content

Cash Shop Sale System

Aleos

By Aleos
in Development News

 Share

Recommended Posts

Lai Poring

Lai

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

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

Great job @Lemongrass

 

  • Upvote 1
Link to comment
Share on other sites
rakuzas Poring

rakuzas

Posted
  • Group:  Members
  • Topic Count:  152
  • Topics Per Day:  0.03
  • Content Count:  459
  • Reputation:   7
  • Joined:  06/29/12
  • Last Seen:  
Posted
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
Jezu Poring

Jezu

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

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
fictionx Poring

fictionx

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  122
  • Reputation:   17
  • Joined:  12/10/12
  • Last Seen:  
Posted (edited)
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
Capuche Poporing

Capuche

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

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

  • Upvote 1
Link to comment
Share on other sites
Lemongrass Drops

Lemongrass

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

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
fictionx Poring

fictionx

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  122
  • Reputation:   17
  • Joined:  12/10/12
  • Last Seen:  
Posted
2 hours ago, Capuche said:

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

Oh, thank you :D !

Link to comment
Share on other sites
  • 2 weeks later...
Radian Drops

Radian

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

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
Lemongrass Drops

Lemongrass

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

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

  • Upvote 1
Link to comment
Share on other sites
  • 1 month later...
Felten Poring

Felten

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

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
Inkfish Poring

Inkfish

Posted
  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   2
  • Joined:  11/29/11
  • Last Seen:  
Posted
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
Lemongrass Drops

Lemongrass

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

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
Inkfish Poring

Inkfish

Posted
  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  3
  • Reputation:   2
  • Joined:  11/29/11
  • Last Seen:  
Posted
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
Lemongrass Drops

Lemongrass

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

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...
Kakaroto Metaling

Kakaroto

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

this system is fantastic, congratulations on the release.

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to topic listing
×
×
  • Create New...