Jump to content

XenaNyx

Members
 View Profile  See their activity

  • Posts

    131

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by XenaNyx

    How to add some item in selling list with npc command

    in Scripting Support

    Posted

     Like this?

    The purpose was to exchange a costume in my inventory vs some items

    	setarray .costume_id0, 20000, 20001;// Item ID of the item in my inventory

    	setarray .item_exchangeID, 7539; // item ID gained - you can add more ID <item ID>, <item ID>,...
	setarray .item_count, 10; // item count gained - ( count of the item /element of array of .item_exchangeID )

     

    not like this, your script it's call buy window but i want call sell window.

    thanks for answer

     

    item_trade.txt and source modifications are the only options. The npcshop* commands trigger the labels after the shop window closes, so they can't modify the window itself.

    EDIT: Or you can try Capuche's script. XD

     

    i think can modify like buy window call itemid from sql.

     

    /kis  good to know 

     

    thanks a lot, i will try other way

    How to add some item in selling list with npc command

    in Scripting Support

    Posted

    no, i want to sell my item to npc.

     

    i use npc command to open sell window

     

    callshop "myshop",2;

     

    example

     

    i have item 501 502 503 in my inventory (alt+e) -> talk wite npc to callshop open sell window -> in selling list appear item 501 502 503 -> double click item 501 502 503 to sell to npc -> click sell button -> i get zeny

     

     

    my problem

     

    in my selling list after i talk with npc want to show item only 502 and 503 not show 501 , possible to check if in my inventory have item 501 not to show in selling list

    OnBuyItem not work when i call shop with cashshop?

    in Scripting Support

    Posted

    i try to write cashshop log like this

     

    npcshopattach "CASH_SEL_1,1;
callshop "CASH_SEL_1,1;


OnBuyItem:
    if(getarraysize(@bought_quantity) >= 1){
        query_sql ( "INSERT INTO `"+$SQLLOGDB$+"`.`cashshop_log` (`account_id`, `char_id`, `item_id`, `amount`, `cash_balance`, `time`) VALUES ( '"+getcharid(3)+"', '"+getcharid(0)+"', '"+@bought_nameid+"', '"+@bought_quantity+"', '"+#CASHPOINTS+"', 'NOW()');" );
    }


morroc,159,191,6    duplicate(CashShop)    Top#1    910
-    cashshop    CASH_SEL_1    -,501:-1
 

     

    when i put shop line to cashshop script at OnBuyItem not work but when i change cashshop to shop at OnBuyItem it's work, this's bug or not?

    how to select name with JOIN

    in Scripting Support

    Posted

    I tested it using the CREATE TABLE and INSERT statements in your 1st post and I didn't get any warnings.

    Did you add a `die_point` column to your `char` table? /hmm

    If you're not using it, you should drop that column.

    Or you can fully qualify the table.column names like this:

    SELECT `char`.`name`, pvp_ranking.kill_point, pvp_ranking.die_point, pvp_ranking.kill_point-pvp_ranking.die_point
FROM `pvp_ranking` LEFT JOIN `char` ON pvp_ranking.char_id=`char`.char_id
WHERE pvp_ranking.kill_point>0 ORDER BY (pvp_ranking.kill_point - pvp_ranking.die_point) DESC LIMIT 10;

    i add die_point already but i don't know why i have error

    you code it's work thanks a lot /kis

    how to select name with JOIN

    in Scripting Support

    Posted 

    query_sql "SELECT `char`.`name`, `kill_point`, `die_point`, `kill_point`-`die_point` FROM `pvp_ranking` LEFT JOIN `char` ON pvp_ranking.char_id=`char`.char_id WHERE kill_point>0 ORDER BY (kill_point-die_point) DESC LIMIT 10", .@name$, .@kill, .@die, .@total;

    same error

    SQL: DB error - Column 'die_point' in field list is ambiguous

    start storing the char name in the same table, much more efficient.

    i think too but i want to know how to write this script

    how to select name with JOIN

    in Scripting Support

    Posted

    i create my pvp_ranking

    CREATE TABLE `pvp_ranking` (
 `char_id` int(11) unsigned NOT NULL auto_increment,
 `kill_point` int(11) NOT NULL,
 `die_point` int(11) NOT NULL,
 PRIMARY KEY  (`char_id`)
) ENGINE=MyISAM  AUTO_INCREMENT=150007 ;

INSERT INTO `pvp_ranking` VALUES (150006, 0, 1);
INSERT INTO `pvp_ranking` VALUES (150000, 1, 15);

    but i want to show ranking like

    mes "[ Char Name ] Kill : xx points | Die : xx points | Total Kill - Die";

    but i cant select name i try with

    if ( query_sql( "SELECT `name`, `kill_point` FROM `pvp_ranking` JOIN `char` ON `pvp_ranking`.`char_id` = `char`.`char_id` WHERE `kill_point` ORDER BY `point` DESC LIMIT 10;", .@name$, .@kill_point ) )

    it's work but 

    if ( query_sql( "SELECT `name`, `kill_point`-`die_point` FROM `pvp_ranking` JOIN `char` ON `pvp_ranking`.`char_id` = `char`.`char_id` WHERE `kill_point`-`die_point` ORDER BY `kill_point`-`die_point` DESC LIMIT 10;", .@name$, .@point ) )

    it doesn't work i have this error

    (23:36:29) SQL: DB error - Column 'die_point' in field list is ambiguous
(23:36:29) Debug: at trunk\src\map\script.c:13703 - SELECT `name`,`kill_point`,`die_point` FROM `pvp_ranking` JOIN `char` ON `pvp_ranking`.`char_id` = `char`.`char_id` WHERE `kill_point`-`die_point` ORDER BY `kill_point`-`die_point` DESC LIMIT 10;
(23:36:29) Debug: Source (NPC): rankmaster at morocc (136,111)

    Free Picture Ragnarok Beautiful TH.

    in Arts & Writings

    Posted

    these pic it's not your own you must remove your credit because you not owner

    ภาพพวกนี้ไม่ใช่ของคุณ คุณต้องเอาเครดิตของคุณออก เพราะ คุณไ่ม่ใช่เจ้าของภาพ

    pic from http://kodama3.skr.jp/ credit to Kodama

    ภาพมาจาก http://kodama3.skr.jp/ เครดิตให้ Kodama

    and this https://www.facebook...narokonlinefans or http://ragnarokonline.gungho.jp/

    และนี่ด้วย https://www.facebook...narokonlinefans หรือ http://ragnarokonline.gungho.jp/

    if you want to share you should share a link to go these website

    ถ้าคุณต้องการจะแชร์ คุณควรแชร์ลิ้งไปยังเว็บไซต์พวกนี้

    Just so you know, Kodama is actually an artist comissioned by the Japanese RO to create artworks for their game, so technically they're just the artist but its property of Gravity, so we can use it as it is released to fans and such. But sharing the website is also helpful, as well as exactly what they cover, such as some artists primarily only do the card images and a little bit of character artworks. Kodama primarily does character works as well as some individual fan works which aren't used by the Japanese RO.

    yes i know, you mut see his post i don't understand why sunzrxz must insert his credit in his post why he say

    Please do not remove my credit.

    why he don't share a link to see original pic and why he must say

    I will update once a week - mounth.

    i think if he share link it better share pic and update every week

    hope you understand what i mean

    Free Picture Ragnarok Beautiful TH.

    in Arts & Writings

    Posted

    these pic it's not your own you must remove your credit because you not owner

    ภาพพวกนี้ไม่ใช่ของคุณ คุณต้องเอาเครดิตของคุณออก เพราะ คุณไ่ม่ใช่เจ้าของภาพ

    pic from http://kodama3.skr.jp/ credit to Kodama

    ภาพมาจาก http://kodama3.skr.jp/ เครดิตให้ Kodama

    and this https://www.facebook.com/ragnarokonlinefans or http://ragnarokonline.gungho.jp/

    และนี่ด้วย https://www.facebook.com/ragnarokonlinefans หรือ http://ragnarokonline.gungho.jp/

    if you want to share you should share a link to go these website

    ถ้าคุณต้องการจะแชร์ คุณควรแชร์ลิ้งไปยังเว็บไซต์พวกนี้

    • Upvote 1

    npc script getquestinfo

    in Source Requests

    Posted

    show information from quest db

    like this

    quest_db.txt

    // Quest ID,Time Limit,Target1,Val1,Target2,Val2,Target3,Val3,Quest Title
1,5400,1094,150,0,0,0,0,"Mission Level 1"

    getquestinfo

    mes "time limit "+getquestinfo(1)+"";
mes "^ff0000Killmonster^ff0000 : "+getquestinfo(2)+" amount  "+getquestinfo(3)+";

    must show when talk with npc like this

    time limit 1.30

    Killmonster : Ambernite amount 150

    • Upvote 1

    Buffer NPC with Delay

    in Script Requests

    Posted 

    prontera,100,100,4 script DelayBuff 100,{
if ( Delay_Heal > gettimetick(2) ) goto deley;
percentheal 100,100;
skilleffect 34,0; sc_start SC_BLESSING,1800000,10;
skilleffect 29,0; sc_start SC_INCREASEAGI,1800000,10;
percentheal 100,100;
set Delay_Heal,gettimetick(2)+10;
end;

deley:
dispbottom "Wait 10 mins";
end;
}

    rathena don't have cartcountitem script command?

    in Scripting Support

    Posted

    really? i think it's have in eathena, maybe i forgot it

    i find in script.c

    /*================================================
* Check how many items/cards in the list are
* in the user's cart [Zohan]
*------------------------------------------------*/
BUILDIN_FUNC(cartcountitem)
{
int nameid, i;
int count=0;

struct script_data *data;
TBL_PC* sd = script_rid2sd(st);
if (!sd) {
script_pushint(st,0);
return 0;
}

data = script_getdata(st,2);
get_val(st,data);
if( data_isstring(data) ) {
const char* name = conv_str(st,data);
struct item_data* item_data;
if((item_data = itemdb_searchname(name)) != NULL)
nameid = item_data->nameid;
else
nameid = 0;
} else
nameid = conv_num(st,data);

if (nameid < 500) {
ShowError("wrong item ID : countitem(%i)n", nameid);
script_reportsrc(st);
script_pushint(st,0);
return 1;
}
for(i = 0; i < MAX_CART; i++)
{

if(sd->status.cart[i].nameid == nameid)
{
count += sd->status.cart[i].amount;
}
}
script_pushint(st,count);
return 0;
}

    BUILDIN_DEF(cartcountitem,"i"),

    thx for answer

    About char_name_letters with space

    in General Support

    Posted

    i want to set

    // 2: Letters/symbols in 'char_name_letters' option are forbidden. All others are possibles.

    char_name_option: 2

    and

    char_name_letters: '"@#:;'space'

    but i put 'space' i can use space from spacebar and alt+0160

    i just want space from alt+0160 only how to put it ?

×
×
  • Create New...