Jump to content

Radian

Members
 View Profile  See their activity

  • Posts

    1546

  • Joined

  • Last visited

  • Days Won

    19

 Content Type 

Posts posted by Radian

    Achievement

    in Database Support

    Posted · Edited by Radian

    2 hours ago, Aleos said:

    You need to specify the count along with the mob ID. 

    
  - ID: 400041
    Group: "AG_BATTLE"
    Name: "Legendary Killing Part 1"
    Target:
      - MobID: 1086
        Count: 1
      - MobID: 1115
        Count: 1
      - MobID: 1150
        Count: 1
      - MobID: 1159
        Count: 1
      - MobID: 1112
        Count: 1
      - MobID: 1583
        Count: 1
      - MobID: 1492
        Count: 1
      - MobID: 1046
        Count: 1
      - MobID: 1252
        Count: 1
      - MobID: 1418
        Count: 1
    Reward:
       ItemID: 32609
       Amount: 10
    Score: 100

    This achievement will require these 10 monsters to be killed (in no order).

    Thank you @Aleos for this information.. so its doesn't matter which of those monster will be killed first.

     

    Edit -- I tested it ---

    Hi, I tested it and it didnt work out.. i followed what you suggest 

      - ID: 400041
    Group: "AG_BATTLE"
    Name: "Legendary Killing Part 1"
    Target:
      - MobID: 1086
        Count: 1
      - MobID: 1115
        Count: 1
      - MobID: 1150
        Count: 1
      - MobID: 1159
        Count: 1
      - MobID: 1112
        Count: 1
      - MobID: 1583
        Count: 1
      - MobID: 1492
        Count: 1
      - MobID: 1046
        Count: 1
      - MobID: 1252
        Count: 1
      - MobID: 1418
        Count: 1
    Reward:
       ItemID: 32609
       Amount: 10

    I even restart the server reloadachievementdb

    Achievement

    in Database Support

    Posted

    Need a little help and information about the achievement system...

    What I want to know is would this settings work? 

      - ID: 400041
    Group: "AG_BATTLE"
    Name: "Legendary Killing Part 1"
    Target:
      - MobID: 1086
      - MobID: 1115
      - MobID: 1150
      - MobID: 1159
      - MobID: 1112
      - MobID: 1583
      - MobID: 1492
      - MobID: 1046
      - MobID: 1252
      - MobID: 1418
    Reward:
       ItemID: 32609
       Amount: 10
    Score: 100

    10 monsters requirements..

    Katar Type Weapon Issue

    in Database Support

    Posted

    Hey guys, So while I'm editing my database and changing things for example, Making Katars one-handed and I thought everything was okay...

    Until a player told me he can equipped Katar + Dagger at the same time.. and I was shocked about this one...

    I know Sniper/Archery or bows can be one handed and when attempt to equip a another weapon (ex: dagger) it will replaced the bow and equipped the dagger.

    Now my question is how can I make Katar type weapons to work like the bow method.

    BG Consume Script Help

    in Scripting Support

    Posted

    Hi everyone, can I request to change/modify and make it more like the dynamic shop. thank you!

    here's the script :  

    //===== eAthena Script =======================================
//= BattleGround Supplier
//===== By: ==================================================
//= Brian
//===== Current Version: =====================================
//= 1.0
//===== Compatible With: =====================================
//= eAthena SVN (+ source edits)
//===== Description: =========================================
//= Sells consumables that can ONLY be used on 'bg_consume' maps.
//===== Additional Comments: =================================
//= http://www.eathena.ws/board/index.php?showtopic=268355
//= 1. To use, create a char named "Battleground"
//= 2. edit the #define BG_CHARID in battleground.h
//= 3. edit the 'set .@BG_CHARID' in this file (line 43)
//============================================================

bat_room,165,146,3	script	Telma	701,{
	mes "[Telma]";
	mes "Welcome, mighty warrior.";
	mes "Do you need supplies for your battles?";
	mes "I can exchange supplies for your badges...";
	next;
	
	switch(select("150 Battleground's Condensed White Potion:90 Battleground's Blue Potion:3 Battleground's Poison Bottle:30 Battleground's Fire Bottle:30 Battleground's Acid Bottle:30 Battleground's Plant Bottle:30 Battleground's Marine Sphere Bottle:15 Battleground's Glistening Coat:50 Battleground's Yellow Gemstone:50 Battleground's Red Gemstone:100 Battleground's Blue Gemstone:5 Battleground's Speed Potion:20 Battleground's Cobweb")) {
		case 1:		callsub S_BuyConsumableBG,547,150;	// Condensed White Potion
		case 2:		callsub S_BuyConsumableBG,505,90;	// Blue Potion
		case 3:		callsub S_BuyConsumableBG,678,3;	// Poison Bottle
		case 4:		callsub S_BuyConsumableBG,7135,30;	// Fire Bottle
		case 5:		callsub S_BuyConsumableBG,7136,30;	// Acid Bottle
		case 6:		callsub S_BuyConsumableBG,7137,30;	// Plant Bottle
		case 7:		callsub S_BuyConsumableBG,7138,30;	// Marine Sphere Bottle
		case 8:		callsub S_BuyConsumableBG,7139,15;	// Glistening Coat
		case 9:		callsub S_BuyConsumableBG,715,50;	// Yellow Gemstone
		case 10:	callsub S_BuyConsumableBG,716,50;	// Red Gemstone
		case 11:	callsub S_BuyConsumableBG,717,100;	// Blue Gemstone
		case 12:	callsub S_BuyConsumableBG,12016,5;	// Speed Potion
		case 13:	callsub S_BuyConsumableBG,1025,20;	// Cobweb
	}
	end;

S_BuyConsumableBG:
	set .@BG_CHARID, 4; // character named "Battleground"
S_BuyConsumable:
	set .@item_id, getarg(0);
	set .@amt, getarg(1);
	
	mes "[Telma]";
	mes "How many sets of ^0000FF"+ .@amt +" "+ getitemname(.@item_id) +"s^000000 do you want?";
	mes "1 = "+ .@amt   +" supplies = 1 badge";
	mes "2 = "+ .@amt*2 +" supplies = 2 badges";
	mes "3 = "+ .@amt*3 +" supplies = 3 badges";
	mes "etc..";
	next;
	input .@sets;
	mes "[Telma]";
	if (.@sets < 1) {
		mes "Enter a positive amount, greater than zero.";
		close;
	}
	mes "So you want ^0000FF"+ (.@amt*.@sets) +" "+ getitemname(.@item_id) +"s^000000...";
	if (.@BG_CHARID) mes "Remember these can only be used in Battlegrounds.";
	mes "It will cost you "+ .@sets +" badge(s)...";
	next;
	switch(select("Give her "+ .@sets +" Bravery Badge(s):Give her "+ .@sets +" Valor Badge(s):Give her "+ (3*.@sets) +" Heroism Badges")) {
		case 1: set .@badge,7828; set .@cost,1; break;
		case 2: set .@badge,7829; set .@cost,1; break;
		case 3: set .@badge,7773; set .@cost,3; break;
	}
	mes "[Telma]";
	if (countitem(.@badge) < (.@cost*.@sets)) {
		mes "You do not have enough ^FF0000"+getitemname(.@badge)+"s^000000 to buy "+(.@amt*.@sets)+" "+getitemname(.@item_id)+"s.";
	} else if (!checkweight(.@item_id, .@amt*.@sets)) {
		mes "You are overweight or have too many items in your inventory.";
	} else {
		delitem .@badge, .@cost*.@sets;
		if (.@BG_CHARID) { // Battleground's Consumables
			getitem2 .@item_id,(.@amt*.@sets),1,0,0, 254, 0, .@BG_CHARID & 0xFFFF, .@BG_CHARID >> 0x10;
		} else {
			getitem .@item_id,(.@amt*.@sets);
		}
		mes "Here are your: ^0000FF"+(.@amt*.@sets)+" "+getitemname(.@item_id)+"s^000000!";
		if (.@BG_CHARID) mes "Remember, they can only be used in Battlegrounds.";
	}
	close;
}

     

    Having Issue with a script

    in Scripting Support

    Posted · Edited by Radian

    10 minutes ago, Skorm said:

    At some point query_sql was changed to return -1 instead of zero when failing. 

    
if(!query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS))

    Should be 

    
if(query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS) <= 0)

    I can't say that will fix your problem for sure though. Make sure your database is correct.

    I'll run a test on your suggestion..

     

    Edit -- 

    I still got the same result, And as you mention i checked the database and it is correct. for the other npc it is working

    at this part 

    	case 1:
		if(@WA_POINTS < 1 || !query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id`="+getcharid(0)+"",@WA_POINTS)) {
			mes "[ ^04B4AEArena Helper^000000 ]";
			mes "I required ^0000ff1WP^000000 for this service. Im sorry.";
		} else {			
			if((@WA_POINTS - 1) <= 0) {
				query_sql("DELETE FROM `wicked_ladder` WHERE `char_id` = '"+getcharid(0)+"'");
			} else {
				query_sql("UPDATE `wicked_ladder` SET `points` = '"+(@WA_POINTS - 1)+"' WHERE `char_id` = "+getcharid(0)+"");
			}
			skilleffect 28,2000;
			percentheal 100,100;
		}

     

    Having Issue with a script

    in Scripting Support

    Posted

    Hey guys, while I was checking a script i noticed that I cant exchange my points it keeps saying this part mes "You don't have enough points to exchange.";

    This is the part of the script, I got 15 points from my mysql. 

    		if(select("Exchange my points into coins:Cancel")==2) close;
		if(!query_sql("SELECT `points` FROM `wicked_ladder` WHERE `char_id` = "+getcharid(0)+"",@WA_POINTS))
			@WA_POINTS = 0;
		mes "[ ^04B4AEAvery^000000 ]";
		if(@WA_POINTS < $@WA_WP)
			mes "You don't have enough points to exchange.";
		else {
			mes "You currently have ^0000aa"+@WA_POINTS+"^000000 points. How much would you exchange?";
			input .@cb,$@WA_WP,@WA_POINTS;
			if(.@cb > @WA_POINTS) {
				mes "You want to exchange too much points.";
			} else {
				.@div = .@cb / $@WA_WP;
				getitem 32609,.@div;
				.@reste = .@cb - (.@cb % $@WA_WP);
				if((@WA_POINTS - .@reste) <= 0) {
					query_sql("DELETE FROM `wicked_ladder` WHERE `char_id` = '"+getcharid(0)+"'");
				} else {
					query_sql("UPDATE `wicked_ladder` SET `points` = '"+(@WA_POINTS - .@reste)+"' WHERE `char_id` = "+getcharid(0)+"");
				}
				mes "^00af00You got "+.@div+" Wicked Coin(s).^000000";
			}
		}

    No map error at all.

    NPC Reseller

    in Script Requests

    Posted

    Can I request a script that allow players to sell their specific items into the npc and NPC will resell it with a higher value.

    For example, Player 1 wants to sell a [4]Knife for 1k zeny into the npc, to confirm the offer of Player 1 a game master will verify it if its acceptable or not.

    Now the game master confirms the offer, and NPC will resell it for a double price or at least a little profit of the item.

    Alayne's Scripts Collection

    in Script Collections

    Posted

    5 minutes ago, Alayne said:

    No you can extract the function and copy it in the Prime Board script.

    Gonna remove the debug line.

    Edit: edited!

    Sorry, Alayne it will work if you server is on PK Mode. Right? and how does it work im trying to make it work right now.

    Is there a specific time?

    Alayne's Scripts Collection

    in Script Collections

    Posted · Edited by Radian

    Do I need the whole script or just the function?

    I got this debugged message, everytime I select Take a hunt = Killers. 

    [Debug]: script debug : 2000000 110270653 : SELECT `id`, `name`, `prime`, `hunterCount` FROM `prime_char` WHERE `killer`=0 AND `name`!='Radian' ORDER BY `karma` DESC

     

×
×
  • Create New...