Register for your free account! | Forgot your password?

You last visited: Today at 03:40

  • Please register to post and access all features, it's quick, easy and FREE!


[Release] New Flyff Website

Reply
 
Old 01/17/2018, 15:28   #91
 
elite*gold: 0
Join Date: Aug 2011
Posts: 361
Received Thanks: 23
hallo hab da mal eine frage hier im treath nicht wirklich fündig geworden



kann mir hiermit jemand weiterhelfen bekomme das irgenwdie nicht weg ^^



Mr.Greenthumb is offline  
Old 01/21/2018, 04:43   #92
 
elite*gold: 0
Join Date: May 2012
Posts: 857
Received Thanks: 643
Meld dich mal via Skype.


xsrf is offline  
Old 05/06/2018, 05:04   #93
 
elite*gold: 0
Join Date: Aug 2014
Posts: 488
Received Thanks: 121
Quote:
Originally Posted by xsrf View Post
Entschuldige, hier ist der wirkliche fix:

PHP Code:
<?php 

class Ranking extends Database {
    
/* Player Ranking Functions */
    
public static function GetClassIcon($classID) {
        
$class Flyff::GetClassName($classID);
        if(!
$class[1]){
            
$class $class[0];
        }else {
            
$class $class[0] . ' ' $class[1];;
        }
        return 
$class;
    }
    
    public static function 
GetClassName($classID) {
        
$class Flyff::GetClassName($classID);
        
$class $class[0];
        return 
$class;
    }
    
    public function 
GetPlayerList($limit) {
        
$get self::Select(array('m_szName''m_nJob''m_nLevel''TotalPlayTime'), 'Character''CHARACTER_TBL', array('m_chAuthority' => 'F''isblock' => 'F'), ' ORDER BY [m_nLevel] DESC, [TotalPlayTime] DESC''TOP '.$limit.' ', array('=''='));
        if(
$get['Rows'] > 0){
            
$get['bool'] = true;
            return 
$get;
        }else {
            
$get['bool'] = false;
            return array(
'danger''There are no ranked players yet.');
        }
    }
    
    public function 
SelectGuildIDByPlayer($player){
        
$guildID self::Select(array('m_idGuild'), 'Character''GUILD_MEMBER_TBL', array('m_idPlayer' => $player), null);
        if(
$guildID['Rows'] > 0){
            
$guildID $guildID['Result'][1]['m_idGuild'];
        }else {
            
$guildID 'Guildless';
        }
        return 
$guildID;
    }
    
    private function 
SelectGuildNameByGuildID($guildID){
        
$guildName $guildID;
        if(
$guildName !== 'Guildless'){
            
$guildName self::Select(array('m_szGuild'), 'Character''GUILD_TBL', array('m_idGuild' => $guildID), null);
            
$guildName $guildName['Result'][1]['m_szGuild'];
        }
        return 
$guildName;
    }
    
    private function 
SetMultiserverView($multiserver){
        if(
$multiserver === '1'){
            return 
'Online';
        }else {
            return 
'Offline';
        }
    }
    
    public function 
GetPlayerRanking($limit){
        if(
gettype($limit) === 'integer'){
            
$player self::Select(array('m_idPlayer''m_szName''m_nJob''m_nLevel''TotalPlayTime''Multiserver'), 'Character''CHARACTER_TBL', array('m_chAuthority' => 'F''isblock' => 'F'), ' ORDER BY [m_nLevel] DESC, [TotalPlayTime] DESC''TOP '.$limit.' '0, array('=''='));
            
$rows $player['Rows'];
            if(
$rows 0){
                
$player $player['Result'];
                for(
$i 1;$i <= $rows;$i++){
                    
$player[$i]['m_szGuild'] = self::SelectGuildNameByGuildID(self::SelectGuildIDByPlayer($player[$i]['m_idPlayer']));
                    
$player[$i]['Multiserver'] = self::SetMultiserverView($player[$i]['Multiserver'] );
                }
                
$player['bool'] = true;
                return 
$player;
            }else {
                return array(
'danger''Actually we have no registered players.''bool' => false, );
            }
        }else {
            return array(
'danger''Please stop forging the values.''bool' => false, );
        }
    }
    
    
/* Guild Ranking Functions */
    
    
private function CheckGuildMemberAuthority($guildID){
        
$response 1;
        
$playerID self::Select(array('m_idPlayer'), 'Character''GUILD_MEMBER_TBL', array('m_idGuild' => $guildID));
        
$authority = array();
        for(
$i 1;$i <= $playerID['Rows'];$i++){
            
$authority[$i] = self::Select(array('m_chAuthority'), 'Character''CHARACTER_TBL', array('m_idPlayer' => $playerID['Result'][$i]['m_idPlayer']));
            if(
$authority[$i]['Result'][1]['m_chAuthority'] !== 'F'){
                
$response 0;
            }
        }
        return 
$response;
    }
    
    private function 
SelectLeaderNameByGuildID($leaderID){
        
$leaderName self::Select(array('m_szName'), 'Character''CHARACTER_TBL', array('m_idPlayer' => $leaderID), null'TOP 1 ');
        return 
$leaderName['Result'][1]['m_szName'];
    }
    
    private function 
BetterGuildCreateFormat($creationDate$monthList){
        
$creationDate substr($creationDate0strlen($creationDate)-12);
        
$creationDate explode('-'$creationDate);
        
$creationDate[1] = $monthList[$creationDate[1]-1];
        
$creationDate $creationDate[1] . ', ' $creationDate[0];
        return 
$creationDate;
    }
    private function 
GetGuildMemberAmount($guildID){
        
$amount self::Select(array('m_idPlayer'), 'Character''GUILD_MEMBER_TBL', array('m_idGuild' => $guildID));
        return 
$amount['Rows'];
    }
    
    private function 
GetGuildLeader($guildID){
        
$leader self::Select(array('m_idPlayer''m_nMemberLv'), 'Character''GUILD_MEMBER_TBL', array('m_idGuild' => $guildID), ' ORDER by [m_nMemberLv]''TOP 1 ');
        
$leader self::SelectLeaderNameByGuildID($leader['Result'][1]['m_idPlayer']);
        return 
$leader;
    }
    
//in relation to slot amount + farbcodes
    
private function SplitSlotValues($slots$amount){
        
$unit $slots 4;
        
        if(
$amount <= $unit){
            return 
'50d3a9';
        }
        elseif(
$amount <= ($unit 2)){
            return 
'7bd350';
        }
        elseif(
$amount <= ($unit 3)){
            return 
'd3b050';
        }
        elseif(
$amount <= ($unit 4)){
            return 
'd35050';
        }
        
    }
    
    public function 
GetGuildRanking($limit$monthList$slots){
        if(
gettype($limit) === 'integer'){
            
$guild self::Select(array('m_idGuild''m_szGuild''m_nLevel''CreateTime'), 'Character''GUILD_TBL'null' ORDER BY [m_nLevel] DESC, [CreateTime] DESC''TOP '.$limit' ');
            
$rows $guild['Rows'];
            if(
$rows 0){
                
$guild $guild['Result'];
                
$a 0;
                for(
$i 1;$i <= $rows;$i++){
                    
$guild[$i]['Authority'] = self::CheckGuildMemberAuthority($guild[$i]['m_idGuild']);
                    if(
$guild[$i]['Authority'] === 1){
                        
$guild[$i]['MemberAmount'] = self::GetGuildMemberAmount($guild[$i]['m_idGuild']);
                        
$guild[$i]['CreateTime'] = self::BetterGuildCreateFormat($guild[$i]['CreateTime'],$monthList);
                        
$guild[$i]['GuildLeader'] = self::GetGuildLeader($guild[$i]['m_idGuild']);
                        
$guild[$i]['SlotSplitter'] = self::SplitSlotValues($slots$guild[$i]['MemberAmount']);
                        
$a++;
                    }else {
                        unset(
$guild[$i]);
                    }
                }
                
$mirror = array();
                foreach(
$guild as $key => $value){
                    
$mirror[] = $guild[$key];
                }
                
$mirror['bool'] = true;
                
$mirror['hide'] = $a;
                return 
$mirror;
            }else {
                return array(
'bool' => false'danger''There are actually none registered guilds.');
            }
        }
    }
    
}
hi this is my error in the ranking


can you please send it to me the fix? because i have lots of error
Ecrypter is offline  
Old 07/22/2018, 10:13   #94
 
elite*gold: 0
Join Date: Apr 2018
Posts: 82
Received Thanks: 4
i comment out (sedrika webshop) but when i try to buy an item this gave me an error : "There was an error while sending an item to your character"


xToffer is offline  
Old 10/03/2018, 15:10   #95
 
elite*gold: 0
Join Date: Oct 2018
Posts: 4
Received Thanks: 0
hello, i would like to ask if there's account database structure that is not included in v2?


Joichiroo is offline  
Old 10/03/2018, 16:32   #96
 
elite*gold: 0
Join Date: Aug 2005
Posts: 227
Received Thanks: 64
Quote:
Originally Posted by Joichiroo View Post
hello, i would like to ask if there's account database structure that is not included in v2?


try make new ingame account
trashee09 is offline  
Thanks
1 User
Old 10/04/2018, 20:43   #97
 
elite*gold: 0
Join Date: Aug 2010
Posts: 8
Received Thanks: 0
I got the same error as Joichiro creating an ingame account fix the problem but how to not display this error msg with no ingame account?

And what is the key for the Administration panel each times i try to use it i got 'Wrong Key"
robkil is offline  
Old 10/06/2018, 14:30   #98
 
elite*gold: 0
Join Date: Aug 2005
Posts: 227
Received Thanks: 64
Quote:
Originally Posted by robkil View Post
I got the same error as Joichiro creating an ingame account fix the problem but how to not display this error msg with no ingame account?

And what is the key for the Administration panel each times i try to use it i got 'Wrong Key"
make foreach or if/else then put return 'None'; if there's no data

go to sql database security table. you can get the key there
trashee09 is offline  
Thanks
1 User
Old 10/08/2018, 16:23   #99
 
elite*gold: 0
Join Date: Aug 2010
Posts: 8
Received Thanks: 0
Thanks u mate!


robkil is offline  
Reply



« [Release & Support] Sapphire FlyFF | [Release]Security Fixes »



All times are GMT +2. The time now is 03:40.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.