Jump to content

fictionx

Members
 View Profile  See their activity

  • Posts

    122

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by fictionx

    [Idea] Proyecto Traducción

    in Publicaciones

    Posted

    On 10/10/2020 at 9:18 PM, Johnnie said:

    Hola a todos no se en que habrá quedado la idea, tengo un proyecto que se ha encargado de traducir tanto cliente como servidor y esta actualizado a la última versión de rathena con terra gloria y varios scripts customs de nuestro proyecto, si les interesa podemos brindar a toda la comunidad hispana los archivos

    Uhm, creo que nunca tuvo mayor progreso. Aún así, deberíamos comenzar un proyecto de traducción.

    Daily quest command

    in Scripting Support

    Posted 

    prontera,155,181,5	script	Sample	4_F_KAFRA1,{
  
  OnClock0600:
  quest_random = 0;
  end;
  
	if (!quest_random) {
		quest_random = rand(1, 2);
		mes "You have been assigned with a new quest.";
		next;
	}
	switch(quest_random) {
		case 1:
			setarray .@reward, 4001, 1;
			setarray .@item, 512;
			setarray .@amount, 100;
			break;
		case 2:
			setarray .@reward, 4002, 1;
			setarray .@item, 501, 502, 503;
			setarray .@amount, 3, 1, 2;
			break;
		default:
			mes "invalid quest.";
			close;
	}
	mes "Quest Requirement(s):";
	.@size = getarraysize(.@item);
	for (.@i = 0; .@i < .@size; .@i++) {
		mes " > "+.@amount[.@i]+"x "+getitemname(.@item[.@i]);
		if (countitem(.@item[.@i]) < .@amount[.@i])
			.@fail++;
	}
	if (!.@fail) {
		next;
		if (select("Submit Quest", "Cancel") == 1) {
			for (.@i = 0; .@i < .@size; .@i++)
				delitem .@item[.@i], .@amount[.@i];
			getitem .@reward[0], .@reward[1];
			
		}
	}
	close;
  
  OnInit:
  quest_random = 0;
  end;
}

    Probably this should work.

    flux guide request

    in General Support

    Posted

    10 hours ago, domez86 said:

    I did not understand how he solves .....
    he says: I fixed the error, the problem was in cp_itemshop, for some reason in the instalation try to reinstall the same table trying to add the "use_existing". I manually removed the field and the problem has  fixed.
    but I didn't understand what I have to do ....

    patch it manually, the installation try to replace something that is already installed. The workaround that i did, it's eliminate the field and put it by my self.

    [PACKETVER 20180620] Client Release 2018-06-20eRagexeRE

    in Client Releases

    Posted · Edited by fictionx

    i'm using 2018 client version of ragnarok (i'm using this one). Other client that isn't manually patched by me, worked fine. The problem exist, when i diff by my self using nemo.

    10 minutes ago, MathReaper said:

    Make sure you're using all correct DLL and SYS files from kRO and have the latest updates in your rdata.grf.

    If this happens only in the Character Selection, probably your GRF is outdated or you are using a different LangType than 0 and aren't updating the "service_(langtype)" in your luafiles.

    Try enabling the patch "Always load Korea ExternalSettings lua file" in your client.

    I didn't change the current LangType, and try using your recommended patch, but didn't work. The client auto close when i enter to the character selector.

    Creating MvP Cards Ranking

    in Web Support

    Posted

    Hi, i wondering if someone can help me to fix the following code that i have from php.


    The problem that i have, it's that isn't counting the total card in the server, always stated in null valor.

    image.thumb.png.9bede79a82576ecd155bc7fe5efcd6e2.png

    Spoiler 
    
<?php
$data = $CACHE->get('MVPCard', FALSE, 1440);
$total = array();
if (!$data )
{
	$total = array();
	foreach( $GV->Global_MVPCard as $val )
	{

		$consult = 
		"
			SELECT 
				SUM(`INVENTARIO`+`CARRO`+`ALMACEN`+`RENTAALMACEN`+`GUILDSTORAGE`) AS `total` 
				FROM ( 
					SELECT (
						SELECT IFNULL(SUM(`amount`),0) 
						FROM `inventory` 
						WHERE `nameid` = ? OR `card1` = ?
					) AS `INVENTARIO`, 
					(
						SELECT IFNULL(SUM(`amount`),0) 
						FROM `cart_inventory` 
						WHERE `nameid` = ? OR `card1` = ?
					) AS `CARRO`, 
					(
						SELECT IFNULL(SUM(`amount`),0) 
						FROM `storage` 
						WHERE `nameid` = ? OR `card1` = ?
					) AS `ALMACEN`, 
					(
						SELECT IFNULL(SUM(`amount`),0) 
						FROM `rentstorage` 
						WHERE `nameid` = ? OR `card1` = ?
					) AS `RENTAALMACEN`, 
					(
						SELECT IFNULL(SUM(`amount`),0) 
						FROM `guild_storage` 
						WHERE `nameid` = ? OR `card1` = ?
					) AS `GUILDSTORAGE`) 
				AS T 
		";
		$filled_array = array_fill(0,10, $val[0]);
		$result = $DB->execute($consult, $filled_array);
		$row = $result->fetch();
		$DB->free($result);
		array_push($total, [
			'id'	=>	$val[0], 
			'total'	=>	$row['total']
		]);
	}
	$CACHE->put('MVPCard', $total);
	$data = $CACHE->get('MVPCard', FALSE, 1440);
}

echo '
	<div class="row">
		<h4 class="oboro_h4"><i class="fa fa-bar-chart fa-2x" style="vertical-align: middle;"> </i> <span> Cartas MvP en el Servidor</span></h4>
		<div class="text-align-center">¡Esta información es actualizada todo los días!</div>
		
';
foreach($data as $arr)
{
	echo "
		<div class='col-lg-2'>
			<img class='oboro_mvpimg' src=\"./images/mvpcards/".$arr["id"].".jpg\">
			<div><b>Cantidad</b>: ".$arr["total"]." Cartas</div>
		</div>
	";
}
echo "</div>";
?>

     

     

    Magnus Exorcismus (Activation)

    in Source Support

    Posted

    try this:

    In skill.cpp

            case UNT_MAGNUS:
                //if (!battle_check_undead(tstatus->race,tstatus->def_ele) && tstatus->race!=RC_DEMON)
                //    break;
                skill_attack(BF_MAGIC,ss,&unit->bl,bl,sg->skill_id,sg->skill_lv,tick,0);
                break;

     

    • Upvote 1
    • Love 1

    Exist a real solution 64khairstyle? | 2017+ clients

    in Client-side Support

    Posted

    Hi,

      i'm wondering if exist a real solution for the bug that have the clients 2017+ with the hairstyle who are above of the style 27.

    i tried using https://github.com/secretdataz/NEMO/commit/c88fbbb24f61458a6907da7f057754f62cfb2c97 but isn't working.

    The problem appear when you change your hairstyle and relog the character. The client crashes instantanly.

    I've tried it on:

    2017-06-14

    2017-05-17

    2017-12-28

     

    Greetings.-

    Flux CP Card Database

    in Web Requests

    Posted

    1 minute ago, Akkarin said:

    What exactly is a "ranking card"? Or do you mean to rank players by the cards they have? How exactly would you rank this?

    There is so much information missing from this topic.

    Hi, thank you for your response. This addon recollects the entire data of the MvP Cards that the players have.

    For example:

    In the menu display all the MvP Card with his bmp image, and below of this image it will appear a number (0) or (1,2,3,etc...), and that means that one or two, three, etc players of the server have that cards.

    Note: I'll edit the title of this topic.

     

    Greetings.-

    Card Seller

    in Scripting Support

    Posted · Edited by fictionx

    Oh, that is true, i'll try to fix that issue.

    So, the following syntax for try to recover data from normal, mvp and boss cards should be work right?. 

    query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid`  WHERE type = 6 group by name_japanese", .@id); 
    query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid`  WHERE mexp > 0 and type = 6 by name_japanese", .@MVP); 
    query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid`  WHERE mode & 32 and type = 6 by name_japanese", .@BOSS);

    Note: i'm using the following script : Link

    Greetings.-

×
×
  • Create New...