Jump to content

XenaNyx

Members
  • Posts

    131
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by XenaNyx

  1. Already know, just edit some src because server not support for cashshop
  2. not like this, your script it's call buy window but i want call sell window. thanks for answer i think can modify like buy window call itemid from sql. good to know thanks a lot, i will try other way
  3. thanks for help vhan48. i want to do something after sell item with OnSellItem: command but i stack at selling list window, hope someone understand my problem
  4. 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
  5. i have items in my inventory list 501 502 503 and i want to use npc script to show only 502 and 503 in sell list with callshop npc command possible to write like this?
  6. 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?
  7. i add die_point already but i don't know why i have error you code it's work thanks a lot
  8. same error SQL: DB error - Column 'die_point' in field list is ambiguous i think too but i want to know how to write this script
  9. 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)
  10. classnum support already
  11. 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 why he don't share a link to see original pic and why he must say i think if he share link it better share pic and update every week hope you understand what i mean
  12. 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 ถ้าคุณต้องการจะแชร์ คุณควรแชร์ลิ้งไปยังเว็บไซต์พวกนี้
  13. 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
  14. ahh, sorry i don't use english in my npc , i forgot a little bit
  15. 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; }
  16. 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
  17. i use old npc for eathena to check item in player cart but i can't use this npc with rathena how to check item in cart like eathena? hope this feature add to rathena server
  18. you can download last version lua files from http://svn6.assembla.com/svn/ClientSide/Lua_Project/lua%20files/
  19. lua files/skillinfoz/skillinfolist.lua must support with exe
  20. i want to use Meteor storm level 1 but don't have button to change skill level
  21. wow it's work , i don't know before haha thanks for helping
×
×
  • Create New...