FluxCP for new SQL Table

[安赫尔 9]

global_reg_value

----------------------

global_acc_reg_num_db

global_acc_reg_str_db

 

 

char

------

char

char_reg_num_db

char_reg_str_db

 

acc_reg_num_db

acc_reg_str_db

 

 

How to change FluxCP for these new SQL Table? I found many error in Flux. 

 

ex. Character Info page, and Death count page.

[ossi0110 200]

Ok 

 

Open the modulesrankingdeath.php

 

and change

 

 

$sql .= "LEFT JOIN {$server->charMapDatabase}.`global_reg_value` AS reg ON reg.char_id = ch.char_id AND reg.str = 'PC_DIE_COUNTER' "; 

into

 

$sql .= "LEFT JOIN {$server->charMapDatabase}.`char_reg_num_db` AS reg ON reg.char_id = ch.char_id AND reg.key = 'PC_DIE_COUNTER' ";

 

 

 

now Open modulescharacterview.php

 

and change

 

$sql .= "LEFT OUTER JOIN {$server->charMapDatabase}.`global_reg_value` AS reg ON reg.char_id = ch.char_id AND reg.str = 'PC_DIE_COUNTER' ";

into

 

$sql .= "LEFT OUTER JOIN {$server->charMapDatabase}.`char_reg_num_db` AS reg ON reg.char_id = ch.char_id AND reg.key = 'PC_DIE_COUNTER' "; 

 

 

and errors are solved

 

[mleo1 36]

ossi is fast

[安赫尔 9]

Ok 

 

Open the modulesrankingdeath.php

 

and change

 

 

 

$sql .= "LEFT JOIN {$server->charMapDatabase}.`global_reg_value` AS reg ON reg.char_id = ch.char_id AND reg.str = 'PC_DIE_COUNTER' "; 

into

 

$sql .= "LEFT JOIN {$server->charMapDatabase}.`char_reg_num_db` AS reg ON reg.char_id = ch.char_id AND reg.key = 'PC_DIE_COUNTER' ";

 

 

 

now Open modulescharacterview.php

 

and change

 

$sql .= "LEFT OUTER JOIN {$server->charMapDatabase}.`global_reg_value` AS reg ON reg.char_id = ch.char_id AND reg.str = 'PC_DIE_COUNTER' ";

into

 

$sql .= "LEFT OUTER JOIN {$server->charMapDatabase}.`char_reg_num_db` AS reg ON reg.char_id = ch.char_id AND reg.key = 'PC_DIE_COUNTER' "; 

 

 

and errors are solved

thx so much

[pr3p 39]

Thanks Ossi   your the man

[mrlongshen 22]

@@ossi0110 thanks. its fix the death ranking. How about the alchemist and blacksmith ?