CyberDevil

I don't know this software because I use phpMyAdmin directly on a web server, but if you have an area where you can paste any queries, you can copy a few hundred lines at a time and run the query, thus dividing the data into more trances... for example I started the queries by copying 5000 items at a time, but remember to insert the first line "INSERT INTO `cp_itemdesc` (`itemid`, `itemdesc`) VALUES" (without quotes of course) to each query. Otherwise another method is to rename (for backup) or delete your "cp_itemdesc" table and recreate it by query, importing this other file which I attached below (it is the same sql file but with the addition of table creation and alteration queries). cp_itemdesc_with_table.zip

I think it's in pending approval, try later!

Update all descriptions to today's date... if you want to thank me you can give me a "LIKE"! ?

ok thank you @crazyarashi , I'll try to install the diff now... another thing, when you go to the bottom left of the map to kill the Wizard (ID: 3764 in map pay_d03_i,55,75), this just reborn immediately without a pause between his death and rebirth... Is it possible to insert a respawn timer of 1-2 minutes from his death and how can I do it? - script illusion_mob#moonlight -1,{ OnInit: monster "pay_d03_i",0,0,"Angry Nine Tail",3759,15,strnpcinfo(0)+"::OnSummonMVP"; monster "pay_d03_i",55,75,"Wizard of Truth",3764,1,strnpcinfo(0)+"::OnSummonWizard"; end; OnSummonMVP: monster "pay_d03_i",0,0,"Angry Nine Tail",3759,1,strnpcinfo(0)+"::OnSummonMVP"; $illusion_mvp += 1; if($illusion_mvp == 1000){ mapannounce "pay_d03_i","Angry Moonlight Flower : Who dares bully us again? They're in a lot of trouble.",bc_map; getmapxy(.@map$,.@x,.@y,BL_PC); monster "pay_d03_i",.@x,.@y,"Angry Moonlight Flower",3758,1; $illusion_mvp = 0; } end; OnSummonWizard: monster "pay_d03_i",55,75,"Wizard of Truth",3764,1,strnpcinfo(0)+"::OnSummonWizard"; end; }

at line 371 try to change 'sleep2' to 'sleep' like this: CHANGE THIS: //¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ // Dialogue Methods //________________________________ function script JitUnhideDelay { sleep2 1500; INTO THIS: //¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ // Dialogue Methods //________________________________ function script JitUnhideDelay { sleep 1500; @behemothcze I have not tested it but let me know if the error disappears which I also do the correction on my server.

@crazyarashi correct me if I am wrong, but I believe that it is simply missing this ";" at hte end of line 54, in this way: autoloot_setting (); it's correct? ...another thing, how can you empty the slots on the list? In other words, delete an item on the list and leave it empty! If there is no way, is it possible to implement this function?

@crazyarashi I found 2 problems but only 1 I solved it: 1) at line 1157, change: getmapxy(.@map$,.@x,.@y,UNITTYPE_PC); with: getmapxy(.@map$,.@x,.@y,BL_PC); ------------------------------------------------------------------------------- 2) I don't know how to solve this problem with the undeclared fuction "pcblockall"... any suggestions? edit: I need to make this patch posted by @joecalis ?

I think that you need PDO driver on MySQL... if you use a linux server you can try: install php5-mysql on a SSh console... if you use Windows I don't know the procedure to install it but you can search on google

Try: 'Hostname' => '127.0.0.1', or 'Hostname' => 'localhost',

I'm not 100% sure it's a bug but the NPC "KVM Logistic Officer" (script here) requires War Badge (ID 7773) to exchange them for "KVM Points" but I believe the correct badge for this exchange is KVM Badge (ID 6376) where even its description clearly says: Then I noticed that the War Badge (ID 7773) is instead used in the script "Poring War" (script here)... could it be right to correct the npc "KVM Logistic Officer" with KVM Badge (ID 6376) instead of War Badge (ID 7773)???

work well! ? Thank u @rongmauhong +1

Although the script below works very well for me, I get this error in SSH console when a player tries to use it without having the amount of zeny needed to continue, but I can not solve it due to my lack of knowledge in C++ //===== rAthena Script ======================================= //= Reset NPC //===== Description: ========================================= //= Resets skills, stats, or both. //===== Additional Comments: ================================= //= 1.0 First Version //= 1.1 Optimized for the greater good. [Kisuka] //= 1.2 Cleaning [Euphy] //= 1.3 All statuses removed upon skill reset. [Euphy] //= 1.4 Compressed Script, Added limit use option [Stolao] //= Changed set -> setarray, Improved text with F_InsertPlural //= 1.5 Added sc_end_class to reset related status changes [sader1992] //============================================================ paramk,119,57,4 script Reset Girl 643,{ cutin "min01",2; // Skills, Stats, Both, Limit setarray .@Reset, 50000, 50000, 90000, 0; mes "[Reset Girl]"; if(.@Reset[3] && reset_limit > .@Reset[3]) { mes "Sorry you can only reset "+callfunc("F_InsertPlural",.@Reset[3],"time")+" in your life."; close2; cutin "",255; } mes "I am the Reset Girl."; mes "Reset Stats: "+ callfunc("F_InsertComma",.@Reset[1]) +"z"; mes "Reset Skills: "+ callfunc("F_InsertComma",.@Reset[0]) +"z"; mes "Reset Both: "+ callfunc("F_InsertComma",.@Reset[2]) +"z"; if(.@Reset[3]) mes "You may only reset "+callfunc("F_InsertPlural",.@Reset[3],"time")+", so use "+((.@Reset[3]>1)?"them":"it")+" wisely."; mes "Please select the service you want:"; next; set .@i,(select("^FF3355Reset Skills:Reset Stats:Reset Both^000000:Cancel")); if(.@i > 3) close2; cutin "",255; mes "[Reset Girl]"; if (Zeny < .@Reset[.@i-1]) { mes "Sorry, you don't have enough Zeny."; close2; cutin "",255; } if(.@Reset[3]){ mes "You can only reset "+callfunc("F_InsertPlural",.@Reset[3],"time")+" in your life, are you sure?"; if(select("Let me think:That's fine") == 1) close2; cutin "",255; } set Zeny, Zeny-.@Reset[.@i-1]; if(.@i&1){ sc_end_class; ResetSkill; } if(.@i&2) ResetStatus; mes "There you go!"; if(.@Reset[3]) set reset_limit,reset_limit + 1; close2; cutin "",255; }

@meyraw andRO work on a server with the packets obfuscation option?

I have used FastStone Photo Resizer to save space... I have halved the size of the images in pixels and converted them from 24bit to 8bit, in this way the images have become much lighter! ?

How can I set the amount of a given loot in the treasure chest? For example, I am now forced to set the ".loots_0" in this way to have 5 equal 7711 items: setarray .loots_0[0], 7711, 7711, 7711, 7711, 7711; ...and why the NPC in Prontera change sprite and size every reload script or restart server?

I have downgrade and recompile from GCC-8 to GCC-7 and the first warning is gone... I have only got this warning now: Do you think that by doing a downgrade from GCC-7 to GCC-6 I can solve or is it better to go directly to version 5?

Update with this screenshot ...and this other errors at the end of compiling:

...like this is correct? int do_init(int argc, char *argv[]) { discord_init(); runflag = MAPSERVER_ST_STARTING; #ifdef GCOLLECT GC_enable_incremental(); #endif INTER_CONF_NAME="conf/inter_athena.conf"; LOG_CONF_NAME="conf/log_athena.conf"; etc... etc... etc... EDIT: I have re-try to recompile with this corrction but I recive all time this errors:

Today I have made an update/upgrade of my server of all the libraries etc. but when I re-compiled rAthena, I see this warning that I do not know how to solve: make[1]: ingresso nella directory "/root/rAthena/src/char" MKDIR obj CXX char_clif.cpp char_clif.cpp: In function ‘int chclif_parse_pincode_setnew(int, char_session_data*)’: char_clif.cpp:293:11: warning: ‘char* strncpy(char*, const char*, size_t)’ specified bound depends on the length of the source argument [-Wstringop-overflow=] strncpy( sd->pincode, newpin, strlen( newpin ) ); ~~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CXX char_cnslif.cpp etc... etc.. etc... The rAthena version is updated a few days ago and the server runs with Debian 9... any suggestions?

ok now it's ok but but I have a doubt... in the map.cpp file where I have to put the line "discord_init();" /// Called when a terminate signal is received. void do_shutdown(void) { if( runflag != MAPSERVER_ST_SHUTDOWN ) { runflag = MAPSERVER_ST_SHUTDOWN; ShowStatus("Shutting down...\n"); { struct map_session_data* sd; struct s_mapiterator* iter = mapit_getallusers(); for( sd = (TBL_PC*)mapit_first(iter); mapit_exists(iter); sd = (TBL_PC*)mapit_next(iter) ) clif_GM_kick(NULL, sd); mapit_free(iter); flush_fifos(); } chrif_check_shutdown(); } } map.cpp

I have many failures to install these patches and then I tried to do it manually but the .diff files are not very detailed and I do not know where to add the code having many different files from the original rAthena files.

Grazie @AnnieRuru ;) in fact we do not do the maintenance every week, but it is already a lot of help so your script to start... in the meantime I activate it!

I apologize if this question of mine seems silly, but I have strong doubts and I can not find answers... The question is related to the event and quest of Satan Morroc. (iRO WIKI here) Currently I have an update renewal server and I do not know for what strange reason but in the first weeks of startup we had the city of Morroc destroyed with the ruins and all the active NPC related to the "Continental Guard Quest (Resurrection of Satan Morroc)". Currently we realized that we have the new city of Morroc without some NPC of the aforementioned quest/event as seen in the screenshot. Is it to be activated in some way or is it normal that this event has been deactivated in the most recent renewal version? If instead it is a problem of our server, how can we reactivate this event? Maybe all this is normal because we have not made large custom modifications on the updated version of rAthena... if you explain exactly how this event should work and give me some useful informations, I would be immensely grateful and a +1 to all those who will give me explanations to better understand the operation of this event.

Any help to leave this event active?

Thank you @AnnieRuru all work perfectly... and yes, we prefer that our players pay a higher price to identify multiple items at once and if they do not want to bring with them the Magnifiers!