Leaderboard

Hi all. After reading about Ai4rei's little discovery I decided to try and make a client plugin. This plugin gives you a new config file, mapeffecttable.txt, which allows you to set weather effects and modify 3D renderer clear color ("sky color") for maps. Now you can add clouds and blue sky (like in Juno and Kunlun) to any map without modifying the client or having to replace the effect from an old map. I just made this today and haven't tested very much, so there will likely be bugs. Also I've only tested on Windows XP running as administrator user, so YMMV. This release only works for 2012-04-10 client, it will crash all other clients!! Update: Now available for 2013-08-07 in addition to 2012-04-10 Weather effect overview: [table] EffectDescription mapleFalling maple leaves nightNight mode pokjukFireworks sakuraFalling cherry tree petals skyCloud effects (many different) snowFalling snowflakes[/table] Example: to add snow weather to Prontera you simply add an entry in the config like this: prontera.rsw 0x00000000 snow 0 More interesting Yuno: To install, put rdll2.asi in your client folder and put mapeffecttable.txt in your data folder. Also note it will not work if you have sound disabled. Download

Someone recently requested this from me so I figure I'd share it with the community. Be very careful about randomly throwing this on your own real server please, and warn your players about it. - script PERMANENTDEATH -1,{ end; OnPCDieEvent: set .@deadplayer,getcharid(0); message strcharinfo(0),"Game Over"; atcommand "@kick "+strcharinfo(0); set .@j, getarraysize( .char_delete$ ); for (.@i = 0; .@i < .@j; .@i++) { query_sql("DELETE FROM `"+ .char_delete$[.@i] +"` WHERE `char_id` = '"+ .@deadplayer +"'"); } query_sql "DELETE FROM `party` WHERE `leader_char` = '"+.@deadplayer+"'"; end; OnInit: setarray .char_delete$[0],"bonus_script","char","cart_inventory","elemental","friends","global_reg_value","guild","guild_member","homunculus","hotkey","inventory","memo","mercenary","mercenary_owner","pet","quest","sc_data","skill","skillcooldown"; end; } I was thinking about adding an NPC that would set a character variable to select if they wanted to opt-in to "Hardcore" mode, and give them benefits for doing so, and having people without the character variable not be affected by it, but that should be easy to add. The only detail is I get a "[Error]: chrif_ack_login_req failed - player not online." but I believe it might be because I have other OnPCDieEvent labels that are attempting to run, didn't have time to confirm if this was the problem or not. But the deletion goes through just fine and the server doesn't seem to be affected by it at all. Enjoy! (Yay my first public release) Edit: Thanks to my friend Tokei for making me use better loops. Here's the version for the upgraded script engine: - script PERMANENTDEATH -1,{ end; OnPCDieEvent: set .@deadplayer,getcharid(0); message strcharinfo(0),"Game Over"; atcommand "@kick "+strcharinfo(0); set .@j, getarraysize( .char_delete$ ); for (.@i = 0; .@i < .@j; .@i++) { query_sql("DELETE FROM `"+ .char_delete$[.@i] +"` WHERE `char_id` = '"+ .@deadplayer +"'"); } query_sql "DELETE FROM `party` WHERE `leader_char` = '"+.@deadplayer+"'"; end; OnInit: setarray .char_delete$[0],"bonus_script","char","cart_inventory","elemental","friends","char_reg_str","char_reg_num","guild","guild_member","homunculus","hotkey","inventory","memo","mercenary","mercenary_owner","pet","quest","sc_data","skill","skillcooldown"; end; } Have not tested this one, but it should work fine :]

Sadly, you can't do it just simply by copying files. You need to transfer your database (or you can not touch it too). How I see how you can move all your data. First, your data stored at MySQL server in databases: rathena_PRERE_db, rathena_PRERE_log (for pre-renewal mechanic (classic) or rathena_RENEWAL_db, rathena_RENEWAL_log. First, what needs to do is making a backup of all your databases so even if you will do any mistakes, you will always have the ability to restore from backup. How to do backup: Simply, copy all files what you have now somewhere else (open-server), or make an archive of your OpenServer folder (to save your disk space). Then, you need to back up your databases above. For that you need Run OpenServer -> GreenFlag -> Advanced -> Phpmyadmin (login root, pass empty) (optionally you can always set a password for root if you wish (google how to do that for phpmyadmin, or in settings of phpmyadmin you can always set it) Now, select database what you want to export, and click on export menu, export method -> quick, and hit "Go" button. And you will download a .sql file of your database Do it for your databases what you have (prere or for renewal (listed above)). Save these files somewhere, you will need them (as a backup) What changed in the 2019 package if compare to 2018 in database? emulator upgraded to latest version, (all NPCs, all source modifications, all changes, etc up to 12 Feb 2019) (you need this) also, developers changed some structures of some tables (you need to apply these patches to your current database if you want to just upgrade your database (this is what you're asking) client files (all of them) like exe, grfs, textures, etc upgraded too (you need this too) minor many fixes Files what you need to import to rathena_PRERE_db, or rathena_RENEWAL_db is next: upgrade_20180830.sql, upgrade_20181010.sql, upgrade_20181220.sql, upgrade_20181224.sql Files that need to import to rathena_PRERE_log, or rathena_RENEWAL_log: upgrade_20180729_logs.sql theory over, now practice, a complete guide on how to upgrade your 2018 package to 2019 with saving all your characters what you have on 2018 package. Step by step guide how to upgrade your 2018 pack to 2019 with saving your characters 1. download the next files: Extract them somewhere to a new folder, do not overwrite your old files! It's completely different files. OpenServer you do not need to download, because there are no changes iOpenServerer (except databases) you already have openserver which is exactly the same like in 2018 package (with only one difference, that all rathena databases upgraded). 2. Extract 01_emulator.rar for example to D:\2019\01_emulator 3. Extract 02_clientside.rar for example to D:\2019\02_clientside 4. Now download client kRO client (or if you have already it, you do not need this step) 5. What mechanic do you want to use? Renewal or PRERE? Ask yourself (renewal = new modern content what you see on official servers (dorams, kagero, oboro, sura, and so on), while PRERE it's classical 13.2 episodes (lord knights, high priest, high wizard, clown, etc). For example, I want pre-re. So my steps are next 6. I copy-paste all files from D:\2019\02_clientfiles\FOR_PRERE_EMULATOR\ to my clean kRO client folder. 7. Now, I start my OpenServer what I had earlier from 2018 package. Green Flag. Clicking on it -> Advanced -> PHPMyAdmin -> root, empty pass, enter. Now I'm in phpmyadmin. 8. Now, I select at left: "rathena_PRERE_db", and clicking on it. 9. Now, I click on "import" tab, and I see Import Importing into the database "rathena_PRERE_db", and I see a button "File Import" and button to import sql files, it's looks like next: 10. Now I need import .sql patches to my database from rathena developers 1 by 1 in the same order next files whih stored at D:\2019\01_emulator\rathena_PRERE\sql\upgrades\ I need the next files only (yellow highlighted): All of these files I 1 by 1 import to my rathena_PRERE_db database with phpmyadmin. When I have done importing all of these files, now I need to import another one but for rathena_PRERE_log database. 11. I click at phpmyadmin left panel on rathena_RENEWAL_log database, now I click on "Import" tab again, again I see import tab, but now I plan to import only 1 file but to logs database. I see Import Importing into the database "rathena_PRERE_log" in front of me on display. And I see File Import Menu, and now I click on "Choose File". Now again, I need to select ONLY upgrade_20180729_logs.sql and import it to rathena_PRERE_log I finished the import (this happens in a split second) and now my database is completely updated and I can freely use the updated emulator with the updated client files as well. As you see it's simple, but require some time. Now I can safely run: D:\2019\01_emulator\rathena_PRE\runserver.bat And my server will work without any errors or problems. And I will launch a game client which I copy-pasted earlier to clean kRO folder. ============================== If someone who read the guide use RENEWAL, replace everywhere where you see "PRERE" to RENEWAL and do the same.

Seu desejo é uma ordem! /////////////////////////////////////////////////////// // ___________ _____.__ // \__ ___/__.__.________/ ____\__| ____ ____ // | | < | |\_ __ \ __\| |/ \ / ___\ // | | \___ | | | \/| | | | | \/ /_/ > // |____| / ____| |__| |__| |__|___| /\___ / // \/ Scripts \//_____/ // //===================================================== // Name: Poring Reporter // // Description: // A poring reporter will spread the news about your // server walking randomly throughout Prontera. // // Instructions: // Toggle walking by whispering to NPC! // (To whisper the NPC, simply send a private message // in Ragnarok to "npc:Poring Reporter") // Say "walk" and it'll start walking. // Anything else and it'll stop as soon as possible. //===================================================== /////////////////////////////////////////////////////// prontera,147,190,5 script Poring Reporter 909,{ set .@gm_level, 99; // Necessary GM Level set .@npc_name$, "Poring Reporter"; function NewsList; Begin: if (getgmlevel() < .@gm_level) end; npcstop; if (.walking != 0) npctalk "Stopped walking. Tell me to \"walk\".", "", bc_self; set .walking, 0; clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; mes "Hello, master! What are the news today?"; menu "Show news",ShowNews, "Remove news",RemoveNews, "Register news",RegisterNews; ShowNews: clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; if (getarraysize(.news$) > 0) { mes "These are the news:"; NewsList; } else { mes "There are no news."; } next; goto Begin; RemoveNews: clear; NewsList; mes "Enter the number of the new you want to remove:"; input .@remove; clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; mes "Do you want to remove \"" + .news$[.@remove-1] + "\"?"; if (select("Yes:No") == 1) { .@arrsize = getarraysize(.news$); for (.@i = .@remove-1; .@i < .@arrsize; .@i++) { set .news$[.@i], .news$[.@i+1]; } set .news$[.@arrsize], ""; } goto Begin; RegisterNews: clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; mes "What should I spread throughout Prontera?"; input .@new$; clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; mes "\"" + .@new$ + "\""; mes "Is that right?"; if (select("Yes:No") == 2) goto RegisterNews; set .news$[getarraysize(.news$)], .@new$; clear; mes "[ ^f442a7"+ .@npc_name$ +"^000000 ]"; mes "Okay!~"; next; goto Begin; function NewsList { for (.@i = 0; .@i < getarraysize(.news$); .@i++) { if (.news$[.@i] != "") mes (.@i+1) + ". \""+ .news$[.@i] +"\""; } } OnWhisperGlobal: if (getgmlevel() < .@gm_level) end; if (@whispervar0$ == "walk") { set .walking, 1; } else { set .walking, 0; } while (.walking == 1) { set .@posxmin, 142; set .@posxmax, 192; set .@posymin, 189; set .@posymax, 217; npcwalkto rand(.@posxmin, .@posxmax), rand(.@posymin, .@posymax); npctalk .news$[rand(getarraysize(.news$))]; sleep 5000; } end; } Para que o poring ande pelo mapa, é necessário ativá-lo enviando uma mensagem para o npc. Para fazer isso, no lugar onde você coloca o nome dos jogadores com quem deseja ter uma conversa privada, coloque o seguinte: "npc:Poring Reporter". Se você mandar a mensagem "walk", ele vai começar a andar ao redor da parte central de Prontera. Você pode alterar as coordenadas mínimas e máximas.

Finally found the solution. The problem was that in the HTML document was written before the head <! DOCTYPE html PUBLIC "- / / W3C / / DTD XHTML 1.0 Transitional / / EN" "http://www.w3.org/TR...ransitional.dtd"> Delete it and the edge disappeared LoL! Translate by Google.

I had this problem in the past. It's not related to the patcher ! It's a IE problem (yeah IE sux lol). You can fix it with a CSS rule, but I don't remember the code lol. Try to do : body, html { margin: 0; padding: 0; border: none; }