-
Posts
63 -
Joined
-
Last visited
Profile Information
-
Gender
Male
-
Location
Manila,Philippines
Recent Profile Visitors
3132 profile views
gleynn's Achievements
-
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!