Jump to content
The Web Section is Now Read-Only
  • 0

Xantara's Flux Renewal setting issue

Bin4ry

Asked by Bin4ry,

 Share

Question

Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
Posted (edited)

9OZFi.png

GZxm4.png

my RO schema

Npe3v.png

'CharMapServers' => array(
array(
'ServerName'	  => 'Flarism RO',
'Renewal'		 => true,
'MaxCharSlots'	=> 9,
'DateTimezone'	=> 'Asia/Kuala_Lumpur', // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)

If I use turn 'Renewal' => false it wouldn't show any error, my server is definitely the latest SVN with renewal enabled. Any solution?

Thanks in advance.

Edit: Updated more images.

Edited by darristan
Link to comment
Share on other sites

13 answers to this question

Recommended Posts

jhonix Poring

jhonix

Posted
  • Group:  Members
  • Topic Count:  1
  • Topics Per Day:  0.00
  • Content Count:  57
  • Reputation:   0
  • Joined:  05/20/12
  • Last Seen:  
Posted

try to check those files in the directories given in the exception..and look for the function that has been declared, you need some error tracking,maybe those functions will not be working once you've change "Renewal" into true since its working on the opposite condition...

Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

Does your user have 'replace' and 'insert' permissions for the item_db_re table?

Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted

xiVxq.png

If not mistaken I think it has every privileges.

Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

Ah, it's the CP code. It seems like rAthena doesn't read item_db anymore when renewal is updated (since r16523) causing a conflict with the temporary tables. I'll commit a fix soon. Thanks! =)

EDIT: Well, its true that the code doesn't need to read item_db anymore for renewal anymore.. But that doesn't seem like the solution for this problem since I can't reproduce your error with the current code...

Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted (edited)

I could upload my whole webdocs + flux sql for you if you need to troubleshoot.

Edited by darristan
Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

I could upload my whole webdocs + flux sql for you if you need to troubleshoot.

How about using TeamViewer instead?

Anyways, I've updated the code: r1146 / 2ad4a01569. Please update and see if that fixes things.

Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted (edited)

wIhlu.png

I guess it is basicly solved but since I manually diffed the update, the old sql query fetched still remain? Where did Flux store the caches?

Edit: Tried to use [Add Item] to add a dummy item, it works -> did send new query to item_db_re but the fetched cache file is my problem :P

Edited by darristan
Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

It doesn't.

I wonder why I can't reproduce. Please check your cp/data/logs/mysql/errors/ and cp/data/logs/errors/exceptions/ for any error print outs. Also set 'DebugMode' to true in cp/config/applications.php and $showExceptions to true in cp/config/error.php.

Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted (edited) 

<?php exit('Forbidden'); ?>
[2012-09-07 10:09:35] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 10:09:36] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 12:43:26] [sqlSTATE=01000] Err 1265: Data truncated for column 'attack' at row 565
[2012-09-07 12:55:22] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:24] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:24] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:28] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:55:28] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:12] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:12] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:14] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:17] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:56:20] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 12:59:33] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:00:05] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:00:09] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'
[2012-09-07 13:01:33] [sqlSTATE=42S22] Err 1054: Unknown column 'attack' in 'field list'

Guess is the RE update with attack:matk in the same column :P

Edited by darristan
Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted

Hmm.. Yea, I had a feeling that was it. I don't know why mine doesn't complain tho =s

Trying to figure out if there is a way to do operations (>, =, <) on atk:matk because of the delimiter. I might have to scrap that from the search otherwise =( I'll also have to update elv. But that has a delimiter now too! Meh, lol. Anyways, I'll commit a fix for this soon - might not be today tho but it is on my TODO list. Thanks for posting this!

Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted

Thank you for the awesome script too! Would also like to ask how the 'DropRates' => array( works in your original idea if you don't mind answering.

Link to comment
Share on other sites
Xantara Poring

Xantara

Posted
  • Group:  Members
  • Topic Count:  20
  • Topics Per Day:  0.00
  • Content Count:  243
  • Reputation:   206
  • Joined:  11/28/11
  • Last Seen:  
Posted (edited)

I'm not sure what you mean by "original idea". But, the values in the DropRates array should match with whatever you put in svn/conf/battle/drops.conf

For example, if you used the following settings in your (SVN) drops.conf:

// The rate at which cards are dropped
// Cards drop at 25x and Boss cards drop at 5x
item_rate_card: 2500
item_rate_card_boss: 500

Then you would do the same in the (CP) servers.php:

// The rate at which cards are dropped
'Card'		=> 2500,
'CardBoss'	=> 500,

This will allow your CP to show the same rates as if you did @mobinfo in-game. It currently does not support Renewal Drop (RENEWAL_DROP in svn/src/config/renewal.h) yet.

EDIT:

Should be fixed in r1147 / 717fea7285

Edited by Xantara
Link to comment
Share on other sites
Bin4ry Poring

Bin4ry

Posted
  • Group:  Members
  • Topic Count:  30
  • Topics Per Day:  0.01
  • Content Count:  782
  • Reputation:   82
  • Joined:  01/01/12
  • Last Seen:  
  • Author
Posted (edited)

Hmmm... I use the Min/Max value also that's why it doesn't work for me. If you do mind adding a little TODO for ur next update which is array of Min/Max value :P

Edited by darristan
Link to comment
Share on other sites
 Share
Go to question listing
×
×
  • Create New...