FluxCP for new SQL Table

[安赫尔]

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]

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]

ossi is fast

 

[安赫尔]

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]

Thanks Ossi 

 your the man

 

[mrlongshen]

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