Most recent last chaos database from kor dev server, dumped on february 2016:
2

This is the only one db with correct encoding, if you are curious why public databases have broken encoding, read this:
2

ps. skip "-unused" files while importing, they are useless.

/monthly_2021_01/1.png.889ae27574b49e04cfdd2d291311f5f7.png" />

Hey Guys,

i have a problem with my server, i want auto refill expb like in normal Ep4. I Editet the Expb in Itemall editor but it wont work ^^ it just shows the frame but doesnt refill 

I use the Reza June Windows files 

22

This is a basic Oauth 2 for discord, you will need to know php to get it to work on your sites



<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
ini_set('max_execution_time', 300); //300 seconds = 5 minutes. In case if your CURL is slow and is loading too much (Can be IPv6 problem)
error_reporting(E_ALL);
 
// SETTINGS ----------------------------------
define('OAUTH2_CLIENT_ID', 'Your client Id'); //Your client Id
define('OAUTH2_CLIENT_SECRET', 'Your secret client code'); //Your secret client code
$Yoursite = 'YOUR WEBSITE LINK'; //Your website link
//--------------------------------------------
 
 
$authorizeURL = 'https://discordapp.com/api/oauth2/authorize';
$tokenURL = 'https://discordapp.com/api/oauth2/token';
$apiURLBase = 'https://discordapp.com/api/users/@me';
session_start();
// Start the login process by sending the user to Discord's authorization page
if(get('action') == 'login') {
  $params = array(
    'client_id' => OAUTH2_CLIENT_ID,
    'redirect_uri' => $Yoursite,
    'response_type' => 'code',
    'scope' => 'identify guilds'
  );
  // Redirect the user to Discord's authorization page
  header('Location: https://discordapp.com/api/oauth2/authorize' . '?' . http_build_query($params));
  die();
}

// When Discord redirects the user back here, there will be a "code" and "state" parameter in the query string
if(get('code')) {
  // Exchange the auth code for a token
  $token = apiRequest($tokenURL, array(
    "grant_type" => "authorization_code",
    'client_id' => OAUTH2_CLIENT_ID,
    'client_secret' => OAUTH2_CLIENT_SECRET,
    'redirect_uri' => $Yoursite,
    'code' => get('code')
  ));
  $logout_token = $token->access_token;
  $_SESSION['access_token'] = $token->access_token;

  header('Location: ' . $_SERVER['PHP_SELF']);
}

echo "Welcome to the new Discord login<br /><br />";

if(session('access_token')) {

  $user = apiRequest($apiURLBase);
 
 
            echo '<h3>Logged In</h3>';
            echo '<h4>Welcome, ' . $user->id . '</h4>';
            echo '<img src="https://cdn.discordapp.com/avatars/'.$user->id.'/'.$user->avatar.'.png"><br /><br />';
            echo '<pre>';
            print_r($user);
            echo '</pre>';
            

    } else {
  echo '<h3>Not logged in</h3>';
  echo '<p><a href="?action=login">Log In</a></p>';
}

function apiRequest($url, $post=FALSE, $headers=array()) {
  $ch = curl_init($url);
  curl_setopt($ch, CURLOPT_IPRESOLVE, CURL_IPRESOLVE_V4);
  curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
  $response = curl_exec($ch);

  if($post)
    curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post));
  $headers[] = 'Accept: application/json';
  if(session('access_token'))
    $headers[] = 'Authorization: Bearer ' . session('access_token');
  curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
  $response = curl_exec($ch);
  return json_decode($response);
}
function get($key, $default=NULL) {
  return array_key_exists($key, $_GET) ? $_GET[$key] : $default;
}
function session($key, $default=NULL) {
  return array_key_exists($key, $_SESSION) ? $_SESSION[$key] : $default;
}
?>
 

delete

Hi, everyone help me with title system

2021-01-09 18:10:58,431 INFO  - no row : query[SELECT a_index FROM t_express_system WHERE a_char_index=262 AND now() < a_expire_date LIMIT 1]

2021-01-09 18:10:58,433 INFO  - no row : query[SELECT a_msg_type, a_item_index, a_item_count FROM t_tradeagent_after_sell_returned WHERE a_char_index = 262]

2021-01-09 18:11:00,674 INFO  - query : query[INSERT INTO t_syndicate_jewel_point VALUES(0, 0, 0, 0),(1, 0, 0, 0),(2, 0, 0, 0),(3, 0, 0, 0)]

2021-01-09 18:11:00,674 INFO  - RVR System Save. K_Jewel_Point : 0, K_UserCount : 0, D_Jewel_Point : 0, D_UserCount : 0

2021-01-09 18:11:00,766 INFO  - DB INSERT TO TITLE LIST >  : CHAR_INDEX : 262 : TITLE_INDEX : 23 : CUSTOM_TITLE_INDEX : -1

2021-01-09 18:11:00,767 ERROR - query error (mysql_real_query) : error[Unknown column 'a_custom_title_index' in 'field list'] query[INSERT DELAYED INTO t_titlelist(a_char_index, a_title_index, a_endtime, a_custom_title_index) values(262, 23, 1610849460, -1)]

 

and i use this: 2

And i cant title on userbar any title has broken or .... ?

 

 

Hello guis ! Please help me ? Please tell me where else is indicated drop from monsters ? In t_npc ( a_item_0-19) no no items that sometimes drop from monsters. In t_npc_drop_all too ( since we are talking about ordinary monsters )...For example, monsters in Juno sometimes drop armor books 17+ - lvl, etc., where this drop is indicated. And please tell me how to accurately specify the % drop of the item from the monster ( I thought that 10000 is 100%, but for some reason it is not so: ( ). Sorry for my English and thank you for your help. Have a nice day, everyone ?

nor as I can not compile files for the client, can anyone help and compile files without requesting an id for the Russian client?

Cooldown System which work from 0 to 100%
Server

Skill.cpp

// New System without %
reusetime = reusetime * (150.00 / (150 + prob)) * (100.00 / (100 + prob));

// Old System with %
reusetime -= reusetime * prob / 100;

// Around 17 lines after the resuetime variable also change this one
if (!IS_PC(ch)){
if (reusetime < 1){
reusetime = 0;
}
}

Client

MyInfoSkill.cpp > Function > DOUBLE MyInfoSkill::GetReuseSkill( int nIndex )
Replace the Complete Function

DOUBLE MyInfoSkill::GetReuseSkill( int nIndex )
{
CSkill& rSkill = _pNetwork->GetSkillData(nIndex);

int nCoolTimeReductionRate = 0;
int SkillReuseTime = 0;
DOUBLE dCoolTime = 0.0;
DOUBLE dDelayTime;
DOUBLE dReuseTime = 0.0;
int nReuseTime = 0;

// <<< Old CoolDownSystem with EP4 Features by DamonA
dDelayTime = DOUBLE( rSkill.GetReUseTime() + _pNetwork->MyCharacterInfo.magicspeed ) / 10.0;
nCoolTimeReductionRate= UIMGR()->GetCoolTimeReductionRate();

if (rSkill.GetJob() != PET_JOB && rSkill.GetJob() != WILDPET_JOB &&
!(rSkill.GetFlag() & SF_GUILD))
{
if (!(rSkill.Skill_Data.appState & SCT_NOCOOLTIME))
{
if( nCoolTimeReductionRate > 100 )
{
nCoolTimeReductionRate = 100;
}
if( nCoolTimeReductionRate > 0 )
{
dDelayTime *= DOUBLE(100-nCoolTimeReductionRate)/100.0f;
}
}
}

return dDelayTime;
// >>> OldCoolDownSystem with EP4 Features by DamonA

if (rSkill.GetJob() != PET_JOB && rSkill.GetJob() != WILDPET_JOB &&
!(rSkill.GetFlag() & SF_GUILD))
{
// ½ºÅ³ ÄðŸÀÓ ¿É¼ÇÀº ij¸¯ÅÍ¿¡°Ô¸¸ ºÙ´Â´Ù.
if (!(rSkill.Skill_Data.appState & SCT_NOCOOLTIME))
{
nCoolTimeReductionRate = UIMGR()->GetCoolTimeReductionRate();
dCoolTime = ( 150.0 / (150.0 + nCoolTimeReductionRate ) * 100.0 / (100.0 + nCoolTimeReductionRate) );
}
}

if(rSkill.GetReUseTime())
{
dReuseTime = DOUBLE( rSkill.GetReUseTime() + _pNetwork->MyCharacterInfo.magicspeed ) / 10.0 * (nCoolTimeReductionRate ? dCoolTime : 1);

return dReuseTime;
}

return 0.0;
}

 

GameServer/doFuncTrigerEvent.cpp

Line:1522

void do_ExRaidSceneTodoTakeItem(CPC* ch, CNetMsg::SP& msg)
{
if(ch == NULL || ch->m_pArea == NULL)
return ;
int index, data;
RefMsg(msg) >> index
>> data;

if (ch->m_pZone->m_index !=ZONE_AKAN_TEMPLE)
{

ch->m_desc->Close("Akan Item Dupe");
return;
}
if (data != 6101)
{
if (data != 6102)
{
ch->m_desc->Close("Akan Item Dupe");
return;
}
}
CItem* pItem = gserver->m_itemProtoList.CreateItem(data, -1, 0, 0, 1);
if(pItem == NULL)
return ;

if(ch->m_pArea->m_RaidInfoList[ch->m_pArea->m_RaidDifficulty].GetSavePoint() < 4)
{
if (ch->m_inventory.addItem(pItem))
{
GAMELOG << init("ADD TO INVENTORY AKAN TEMPLE RAID ITEM", ch) << itemlog(pItem) << end;

ch->m_pArea->m_RaidInfoList[ch->m_pArea->m_RaidDifficulty].SetTheObjectState(OBJECT_ITEM, index, 0); //object »уЕВ јіБ¤
{
CNetMsg::SP rmsg(new CNetMsg);
SendRaidSceneObjectRefreshMsg(rmsg, ch, OBJECT_ITEM, index, 0);
ch->m_pArea->SendToAllClient(rmsg);
}
ch->m_pArea->m_RaidInfoList[ch->m_pArea->m_RaidDifficulty].ExcuteTodo(TAKE_ITEM, index, data, ch);
}
else
{
delete pItem;

// АОєҐАМ °ЎµжВчј­ ѕЖАМЕЫ ЅАµж єТ°Ў.
{
CNetMsg::SP rmsg(new CNetMsg);
SysFullInventoryMsg(rmsg, 0);
SEND_Q(rmsg, ch->m_desc);
}
{
CNetMsg::SP rmsg(new CNetMsg);
SendRaidSceneObjectRefreshMsg(rmsg, ch, OBJECT_ITEM, index, 1);
ch->m_pArea->SendToAllClient(rmsg);
}

return ;
}
}
}

 

GameServer/NPCProto.cpp

Line: 87

 

#ifdef PREMIUM_CHAR
//XX - 프리미엄캐릭터 : 몬스터를 죽였을때 획득하는 EXP/SP 10% 증가
int CNPCProto::getExpForPremiumChar( int premium_type )
{
int ori_exp = m_exp;
int exp = 0;

switch (premium_type)
{
case PREMIUM_CHAR_TYPE_FIRST:
exp = (int)(ori_exp * 1.1f); //10% EXP change here
break;

default:
exp = ori_exp;
break;
}

// LOG_DEBUG("TEST (exp) : %d - %d", ori_exp, exp);

return exp;
}

int CNPCProto::getSkillPointForPremiumChar( int premium_type )
{
int ori_skillpoint = m_skillPoint;
int skillpoint = 0;

switch (premium_type)
{
case PREMIUM_CHAR_TYPE_FIRST:
skillpoint = (int)(ori_skillpoint * 1.1f); //10% SP change here
break;

default:
skillpoint = ori_skillpoint;
break;
}

// LOG_DEBUG("TEST (sp) : %d - %d", ori_skillpoint, skillpoint);

return skillpoint;
}
#endif