-
Posts
63 -
Joined
-
Last visited
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by gleynn
-
How to display multiple rows of result from SQL query using NPC
gleynn replied to gleynn's question in Scripting Support
-
How to display multiple rows of result from SQL query using NPC
gleynn posted a question in Scripting Support
Hi, I have my sample npc script below with SQL query. In database, it has multiple rows of result. can you please show me how can i make the dispbottom to reflect the first 3 rows of result? izlude,117,110,6 script sample 952,{ input .@item_id; query_sql("SELECT char_id, nameid, amount FROM `inventory` HAVING nameid = "+.@item_id+" ORDER BY amount DESC",.@charid,.@nameid,.@amnt); dispbottom .@charid+" : "+getitemname(.@nameid)+" "+.@amnt+"pcs"; end; } -
Hi, anyone can help me where to check why the damage and emoticons in my client is displaying sometimes inverted?
-
Hi, By default, only the top 5 will be display if we use @whodrops. I want to increase this, to 30 or maybe just 20. then i tried to modify this command in atcommand.c and changed MAX_SEARCH to 30. /*========================================== * Show who drops the item. *------------------------------------------*/ ACMD_FUNC(whodrops) { //struct item_data *item_data, *item_array[MAX_SEARCH]; struct item_data *item_data, *item_array[30]; int i,j, count = 1; if (!message || !*message) { clif_displaymessage(fd, msg_txt(sd,1284)); // Please enter item name/ID (usage: @whodrops <item name/ID>). return -1; } if ((item_array[0] = itemdb_exists(strtoul(message, nullptr, 10))) == nullptr) //count = itemdb_searchname_array(item_array, MAX_SEARCH, message); count = itemdb_searchname_array(item_array, 30, message); if (!count) { clif_displaymessage(fd, msg_txt(sd,19)); // Invalid item ID or name. return -1; } //if (count == MAX_SEARCH) { if (count == 30) { //sprintf(atcmd_output, msg_txt(sd,269), MAX_SEARCH); // Displaying first %d matches sprintf(atcmd_output, msg_txt(sd,269), 30); // Displaying first %d matches clif_displaymessage(fd, atcmd_output); } for (i = 0; i < count; i++) { item_data = item_array[i]; sprintf(atcmd_output, msg_txt(sd,1285), item_data->ename.c_str(), item_data->slots, item_data->nameid); // Item: '%s'[%d] (ID:%u) clif_displaymessage(fd, atcmd_output); if (item_data->mob[0].chance == 0) { strcpy(atcmd_output, msg_txt(sd,1286)); // - Item is not dropped by mobs. clif_displaymessage(fd, atcmd_output); } else { //sprintf(atcmd_output, msg_txt(sd,1287), MAX_SEARCH); // - Common mobs with highest drop chance (only max %d are listed): sprintf(atcmd_output, msg_txt(sd,1287), 30); // - Common mobs with highest drop chance (only max %d are listed): clif_displaymessage(fd, atcmd_output); //for (j=0; j < MAX_SEARCH && item_data->mob[j].chance > 0; j++) for (j=0; j < 30 && item_data->mob[j].chance > 0; j++) { int dropchance = item_data->mob[j].chance; std::shared_ptr<s_mob_db> mob = mob_db.find(item_data->mob[j].id); if(!mob) continue; #ifdef RENEWAL_DROP if( battle_config.atcommand_mobinfo_type ) { dropchance = dropchance * pc_level_penalty_mod( sd, PENALTY_DROP, mob ) / 100; if (dropchance <= 0 && !battle_config.drop_rate0item) dropchance = 1; } #endif if (pc_isvip(sd)) // Display item rate increase for VIP dropchance += (dropchance * battle_config.vip_drop_increase) / 100; sprintf(atcmd_output, "- %s (%d): %02.02f%%", mob->jname.c_str(), item_data->mob[j].id, dropchance/100.); clif_displaymessage(fd, atcmd_output); } } } return 0; } however, after the changes above, it is still showing top 5. is there any other source code that i need to modify?
-
-
Client exe 20180621 | 2018-06-21aRagexeRE
gleynn replied to RafaelGomez23's question in Client-side Support
can you share the solution for this? -
Hi, I tried to diff the clients from: Tool: 2018-06-21aRagexeRE Client - Modified - Third Party Releases - rAthena and Where I can find 2018-06-21aRagexeRE? - Client Requests - rAthena provided by Haruka Mayumi using WARP - A Successor to NEMO - Client Releases - rAthena. However, i always received this failed translation error once I load the session from ROenglishRE/2018_Translation.yml at master · llchrisll/ROenglishRE · GitHub. and after applying the patches, I always receive Failed to Connect to Server after selecting service (before character selection screen) another thing that i notice, it seems that if i apply the patch for Customize ClientInfo file and change the default value to clientinfo.xml, it is still reading the sclientinfo.xml though i don't have any issue from the diffed client provided by my hosting service provider. but i wanted to learn how to diff my own client.
-
Hi, just wanted to ask if someone can give me a sample npc script that requires random item and amount in exchange for cashpoints?
-
stat seller NPC || with limit of stat points to buy
gleynn replied to AinsLord's question in Script Requests
ohh, apologies, it should be using comma ( , ) instead an equal sign, here i have updated the script stat seller with limitv2.txt -
There are tons of pvp ladder from our script releases and collection section, but you might want to try Ghost's PvP System
-
under OnPCKillEvent: add this line below if(strcharinfo(3) != "pvp_y_1-2") end; it will look like this: OnPCKillEvent: if(strcharinfo(3) != "pvp_y_1-2") end;
-
stat seller NPC || with limit of stat points to buy
gleynn replied to AinsLord's question in Script Requests
try this PS. Stats sold from this NPC will be lost once the player use stat reset. To prevent this, you might want to edit your /conf/exp.conf and look for use_statpoint_table: yes and set it to use_statpoint_table: no EDIT: attached the updated script stat seller with limitv2.txt -
How to increase skill points basic for skills?
gleynn replied to tathanngudong's question in Script Requests
Either increase the job level for a certain class or create an npc that sells skill points. -
How to increase skill points basic for skills?
gleynn replied to tathanngudong's question in Script Requests
Either increase the job level for a certain class or create an npc that sells skill points. -
I think it should be getpartymembers(getcharid(1),1); since you are using character id from the rest of the script. Thank you so much Anacondaqq! Problem Solved!
-
Thanks Anacondaqq and apologies for the confusion, im not clear with my request, but im looking for an npc that only talks to a party leader.
-
Hi, Can someone please show me a sample script that checks if all party members are in the same guild with the party leader. Thanks Edit: only party leader can talk to the npc, and it checks if all of his party members are in the same guild with his.
-
Pre-renewal: Range attack w/ neutral property on emp
gleynn replied to gleynn's topic in Tulong para sa Server
hmmm i see, thanks for the confirmation. balik po tayo sa tanong ko, baka po alam nyo kung panu gawin, or any work around will do -
Pre-renewal: Range attack w/ neutral property on emp
gleynn replied to gleynn's topic in Tulong para sa Server
Yes po. Alam nyo po ba kung panu? ganun po ba? may nakapag sabi po kasi sakin na di tumatama yung range attack sa pRO. Kung tama yun, gusto ko sana na ganun din sa emp ko. -
Can anyone confirm if this is an expected behavior, where range attacks are hitting on emperium? Arrow with neutral property were used in my testing. Can you help me fix this? Thanks
-
Help po. Tumatama po kasi yung range attack sa emp kapag naka neutral property po. Ex.sniper w/ arrow attacking emp. Panu po ifix? Pa help naman po
-
in terms of support, budget and other services? kanino po sulit na magpahost ng private server? try ko sana kasi mag open ulet ng private server. baka may mga mairerecommend po kayo. nakita ko sa paid services yung post nila PONY, WANhosting and trinity. baka may iba pa kayong alam? thanks
-
di ko po alam gawin to, pero suggest ko lang na alternative solution, pwede ka mag lagay ng 1click identify NPC atcommand "@identifyall";
-
need someone who can install ragnarok offline. magbayad ako
gleynn replied to raflors's topic in Tulong para sa Server
http://rathena.org/wiki/Installation_on_Windows meron din po si sir themon na compiled versions. http://rathena.org/board/topic/84621-latest-rathena-master-revision-compiled -
what revision is rathena master sir themon? sorry it's been a while since i visited this forum.