2023 Jun 28 News

June Updates and Maintenance Core * Added Support for Cookie Consent. * Added support for forcing tags to be listed alphabetically. * Members can now request their PII Data via the Frontend. * Members can now request to be deleted via the Frontend. * Members can no longer react to content if they have unacknowledged warnings. * Adjusted the OAuth setup instructions to use the new "API" instead of "REST & OAuth" menu point. * Removed the none function default Giphy API key. * Improved the way how we send requests to IndexNow to skip it for items which are literally never visible to guests. * Fixed few instances, where we weren't removing the IP address from the database via the IP Address truncate task. * Fixed an issue where the similar content block may cause an error on some pages when using Elastic/Opensearch. * Fixed an issue with lightbox grouping in activity stream where Elastic/Opensearch is used. * Fixed an issue where push notifications may not be sent if a browser/device has been used to sign in to multiple accounts. * Fixed an issue in validating custom header/footer theme inputs. * Fixed an issue where moderating all links did not work correctly. * Fixed an issue where editing an item and setting a future publishing date did not work correctly. * Fixed an issue where viewing the members content on his profile may show an error while viewing some reviews. * Fixed an issue where chart labels containing a comma caused CSV downloads to be incorrectly formatted. * Fixed an issue where adding the 'group' parameter in the 'core/members' REST endpoint would result in the other parameters being overlooked. * Fixed an issue where Custom Fields of type Member did not function correctly. * Fixed an issue where bulk mail could not be filtered by a CheckboxSet profile field. * Fixed an issue where responses to reviews were not checked against word filters. * Fixed an issue where the related content widget added invalid hover parameters in some cases. * Fixed an issue where the memberregistrationcomplete` webhook was triggered too early. * Fixed an issue where clubs set to not show members still showed on the profile. * Fixed a missing live search keyword for admin control panel notifications. * Fixed an issue where ACP notifications may cause an error if the extension has been removed. * Fixed an issue where content can be missing in streams if the last comment is waiting approval. * Fixed an issue generating iOS startup images. * Fixed an issue where an administrator IP may show in the list of ban suggestions if they had changed the members display name. * Fixed an issue where a malformed search request could trigger an uncaught exception (and system log). * Improved the Cookie Consent system based on feedback from our community. * Fixed some missing language strings in Member History relating to PII / Account deletion requests. * Fixed some issues with the AdminCP notification for PII requests. * Fixed an issue where an administrator exporting PII for a member may not contain the members device data. * Fixed an issue with links in the PII request emails. * Improved the security of the Visual Language Editor. Forums * Added og:image tags for first 4 image attachments. * The topic summary was removed for future topics. * Fixed fatal error when upgrading from IP.Board 3.x. * Fixed an issue where publishing a scheduled topic did not properly update the last post information on the forums. * Fixed an issue where re-engagement emails would show replies from the topic author. Commerce * Added the table filter and sort options to the redirect target after deleting an invoice in the ACP. * Fixed an issue with PayPal when buying multiple quantities of a product in one order. * Fixed a bug where the expiry date can be calculated incorrectly when upgrading/downgrading between packages. * Fixed an issue where the wrong value was displayed on custom fields during checkout. * Corrected PayPal API endpoint to the newer version. Pages * Fixed an issue moving comments to forum if the article previously had a linked forum topic that no longer exists. * Fixed an issue where copying multiple topics to a database resulted in duplicated attachments. * Fixed an issue where display options in the ACP did not match the display of custom fields on the front-end. Platform * Fixed an issue where editing a video upload to Gallery may not transcode it to MP4. * Fixed an issue where email copies of Commerce actions may not be sent. * Fixed an issue with content item analytics. The above list is a copy/paste from IPS's Release Notes. Some of the above fixes may not apply to our installation of IPS. Deprecation Notices Due to various core elements of IPS4 being deprecated towards the application's end-of-life, the following have been disabled in this update: * Commerce Support Desk (Support Ticket system) * Physical Products (merch is handled by an external company) * Status Updates (previously disabled due to misuse, but now are completely removed) * Mod Tool Plugins (PM on Saved Action and PM Auto-Reply). Plugins are being removed entirely in IPS5.

By Nubs

Read more

2023 Jun 05 News

Forum Updates; Q2 23 Edition A great many things have changed during this recent maintenance of our forums. Forum Software Upgrade First and foremost, we have upgraded our forums to the latest version of IPS Community Suite. This brings with it a number of new features and improvements including an updated anti-spam service, a number of updates to the Editor, and a new way to embed content from other sites. We have also added a new feature that allows you to easily share content from our forums to your social media accounts. More Updates! Various 3rd-Party plugins have been updated to mitigate bugs and to ensure compatibility with the new version of the forums. If you notice any issues with the forums, please let us know in the Forum Issues sub-forum.. forum forum. Forum Themes The default IPS nasty white theme has been removed. The Dark theme is now the only option, for the benefit of your eyes, and so I don't have to update two themes when I change something. The forum upgrade has reverted some of our custom changes to the Dark theme, such as various layout template changes, links being removed, buttons being moved to somewhere else, etc. Some of them will return, while others will not. The link for Account Credit will return when Paypal has approved our application_id, which was another new change I wasn't prepared for (because some of us don't like to read changelogs before updating...). Username Logins A number of older features within IPS have been deprecated and will be removed at a future date. One of these is the ability to allow username logins. Let's face it, it's a security risk. On Thursday 8th June, we will be removing the ability to login with your username. This will destroy your forum cookies, ending your sessions, forcing you to re-login. You will need to use your email address and password to login to the forums again. Merch and Tickets IPS are changing the way the IP.Commerce system works. This will affect the way we handle donations and subscriptions. We will be working on this over the next few weeks and will let you know when we have a solution in place. The long-and short of it is that they are removing support for physical products and the forum support ticket system in a future version. rA Merch hasn't existed on the forums for about a year (the link in the navigation goes to our Tee-Spring store, which no one has ever purchased from) so that isn't an issue. The support tickets are often ignored as it's just a bunch of users trying to get help with their rA server, which is not what they were originally designed for. We Moved We actually migrated hosts. Still with OVH, but a shiny new VM with tonnes more resources, all for almost the same price as the old one. The Crowdfunding descriptions are now slightly wrong, as we don't have the same costs for the listed products/services, although the total amount each month is ~$3 less. I'm not decreasing them, however, as the IPS license renewal still comes out of my pocket at a hefty $120/6mo. Traffic is still filtered through CloudFlare. rA Gaming Guilds & Teams At the back-end of last year, I asked you guys in our Discord server what your thoughts were on an rA Guild in various MMOs and a team for some MOBAs via a brief survey. The results were mixed, but in-all there was some good feedback. We will be opening up a few new channels in Discord over the coming weeks with information on where to find our guilds in whichever games we decide to play. We will also be looking for some Guild Leaders to represent us in games that rA Staff don't play. Please wait for further announcements on this. I think that's all? Probably. Akky out~

By Nubs

Read more

2023 Apr 03 News

The Wiki. What Wiki? Exactly. Afternoon everyone! Many moons ago we migrated our wiki content to Github in an effort to alleviate resources on our VM, increase our data's stability and in-general, significantly reduce the number of things that could go wrong. That was the plan. The plan worked well enough on all three counts above, however, Github Wiki's have this wonderful knack of not doing what they're supposed to when you need them to be helpful. For example, users needing special permissions to push new content to it (until very recently this has been "maintainer" access only), which means everyone has to rely on rA Staff to update the Wiki, which we evidently haven't had much time for. Now there's a new kid on the block; User-Guides! Guides from the Wiki will slowly be migrated to our new User Guides site (which you can help with, if you want to), which is a HTML website hosted using Github Pages, automatically generated from Markdown files that are stored in a Github Repository. Neat, huh! View the site at https://rathena.github.io/user-guides/ Because this new guide platform is built on a git repo, it means that anyone can contribute to it by opening a Pull Request. I've written some guidance here: https://github.com/rathena/user-guides/blob/master/CONTRIBUTING.md "What about all those guides on the forums" I hear you ask. Let's face it, 20% of them don't make any sense, 30% of them are inaccurate, 90% of them are outdated, 100% of them are developed with either bias towards specific software tools or just badly written due to language barriers or laziness. Far too often are links to out-of-date guides re-posted on the forums and in Discord, and we can't keep them updated because they're forum posts so only Mods can edit them (which is not what they're here for). From now on, well-written guides are to be posted to the User Guides repo. Guides posted on these forums will result in a message being sent to the author stating why we're going to hide the thread and then give a link to this post. What can you NOT post to User Guides? rAthena is a software emulation project. As such, guides pertaining to 3rd Party Tools or software will not be approved. This includes "How-To's" regarding the client, which is not actually within the scope of the rAthena project. We don't want to be sued ?, thanks. We have a new channel in Discord called #user-guides for discussions related to this area of the project. We would be very happy to see you helping our effort to migrate and write good, informative guides for our community to use and keep updated for years to come! Next we'll be working on doing something very similar to our source's /doc/ directory! Akky~

By Nubs

Read more

2022 Jan 17 News

It's Time This Was Addressed; Resellers This is going to be a blunt post. For some time now the rAthena staff have been actively working to reduce the number of reseller advertisements that crop up on our forums, our Discord server, Facebook, websites, etc. We strongly advise that rAthena users do not engage with resellers. The code/content isn’t theirs to sell. You receive little to no support. You are at risk of being scammed. You are not supporting the developers of their respective projects or original content creators. You are lining the pockets of thieves and scammers who have no idea what they’re doing. The original project authors begin to feel demotivated - this can cause them to stop working on this and upcoming projects altogether. The number of reports from our users who have been scammed has increased significantly over the last year. If you wish to hire the services of a known and trusted developer, please use https://rathena.org/board/thirdpartyservices/ - this list of members of our forum has been vetted and approved. This is a list of members who are not going to scam you. If you decide to give your money to some random idiot that claims to have “full working premade x, y, z” then that’s on you. We can’t stop you, but you’re certainly adding fuel to the fire and these idiots will continue to take advantage of other members of our community. If you receive a DM from anyone trying to sell content on rAthena’s Discord or forum and the person is not listed on the Third Party Services page, we suggest taking evidence and report the users to a member of staff. So, what should you do instead? Setting up rAthena and a working client is easy. You don’t need someone else to do it for you - that is not how you learn. Using any of the multitude of tutorials and wiki pages will help you get your rAthena server up and running. If you don’t do it yourself, you will not learn where the configurations are. You won’t learn how to modify an item/mob. You won’t know how to enable an NPC. If you’re now thinking “well, I don’t have time, that’s why I pay someone” then maybe running a game server is not for you. Reseller = Bad. Learning and Self-Betterment = Good. I’m hoping this post gets our point across loud and clear.

By Nubs

Read more

2021 Nov 08 News

Forum Achievements and Badges Evening all! With the recent forum updates comes some new shiny features from IPS. The feature I'm most excited about is the new Achievements and Ranks. The old Badges & Awards plugin has been merged into the new Achievements system on the forums - I'm sure some of you have already begun to receive additional badges for posting content or uploading a file! The ancient Ranks system has been replaced with the new one and updated to use the names of familiar in-game mobs. The order is different to the old one and the number of points for each rank has changed slightly, but I can see that some of you are already quickly climbing the ladder! The following table details how many points gets you to which rank, and how to earn those desirable points. Posting a comment/reply: 5 points Following a content item: 2 points Following a member: 2 points Following a node (forum, album, category, etc): 2 points Posting a content item: 10 points Reacting to a user's post/content item: 1 point for both giver and receiver There are other methods, but to reduce forum spam I'm omitting them from this list. Remember; spamming the forum will result in Warning Points which may result in your account being suspended. Happy posting!

By Nubs

Read more

2025 Jan 07 Events

Virtuoso RO Join us on Virtuoso RO and experience a new, fresh and unique settings of high-rate server. Balanced classes (including Expanded classes), challenging World Boss with actual mechanics, Daily Mission, balanced items (including donate items), some features on ROM like Safe Refining, Equipment Upgrades, Daily Content and much more! All this features while still faithful to vanilla Pre-Renewal RO experience! Virtuoso RO | 255/120 | 2nd-Trans | Pre-Renewal | High-Rate (PK Server) Website: http://virtuosoro.com Full Client: https://www.mediafire.com/.../VirtuosoRO_(Full.../file Lite Client: https://www.mediafire.com/.../VirtuosoRO_(Lite.../file Facebook Page: https://www.facebook.com/virtuosoragnarokonline Discord: https://discord.gg/d4XYpBRvcB Frost Server Agi-Based Delay Clients: 3 maximum / PC only Exp: 20000x Drop: 5000x/1000x Max Attack Speed: 196 Max SP: 4000 Main City: Sky City Balanced All Classes (Including Expanded Classes) Balanced Donate Items Monthly Gacha Costumes Solo/Migration Guild Package Available (WOE Ready) Hourly and MVP Points Brand New Safe Refiner 4rTools Enabled Custom Soul Link effects Gepard Shield 3.0 (Coming soon!) World Boss Battles with Unique and Challenging Mechanics Field Elite Mobs Autoattack enabled (only in Gold Room) Endless Tower Clear Reward Daily Mission Anti-Spoonfeeding Broadcast Customized Card Effects

By Nubs

Read more

2024 Oct 24 Events

Divine Ragnarok READY FOR THE BEST PRE-RENEWAL EXPERIENCE OF 2024? Divine Ragnarok The most anticipated PRE-RENEW server opens Saturday, 26/10/2024 ! Don’t miss out! Informations : Level: 99/70 (Transclass Only) Rates: EXP 15x | JOB 15x | Drops 7x | Cards 3x | MVP 7x Auto-Loot: Yes for Mercenaries/Homunculi Random Options: ON Rare Drop Announcements: Team-wide for drops <0.5% Multi-Level Up: ON Zeny from Mobs: Yes, earn Zeny from kills! Episode: El-Dicastes JOIN THE EXCLUSIVE BATTLEGROUND FOR REWARDS! Happy Hour from 4 PM to 8 PM daily! Rewards increased by 20%. Kill count tracked for personal ranking! Check it out: Battlegrounds INSANE IN-GAME EVENTS AWAIT YOU! - Events - Nightmare Donjon - World Boss AND MUCH MORE! JOIN DIVINE-RO FOR A FUN-FILLED ADVENTURE THIS SATURDAY! Links: Wiki Discord Website Ragister Download

By Nubs

Read more

2024 Jul 22 Events

HikariRO Rates 40x 40x 30x / Nivel máximo 260/55 / Quest e instancias propias del servidor / Sistemas exclusivos / Episodio 18 / Pack de bienvenida / Eventos automáticos / Sistema de premios por conectarse a diario / Sistema VIP al alcance de todos / 4th jobs

By Nubs

Read more

2024 May 31 Events

MuhRO Introduction We are a guild that has come together to make our idea of a renewal server come true. For this we have spent the last half year creating a server based on KRO. KRO, but with our custom quality of life changes. And we're just at the beginning of this journey. Open Beta started on 08 September 2021, but you don't have to fear of any wipes. If you ever wanted to be part of the early days of a server and want to help forming it, this is your chance! Our friendly team is open to positive as well as negative feedback. Any suggestions / wishes will be listened to - of course some may be denied Have a look, maybe you hear a moo here and there. General Informations Registration Website Wiki Forum Discord Type: Renewal with all 4th/Expanded Jobs Episode 20 EXP Rates: Base 50x / Job 50x Drops: logarithmic 25x (this means the lower the usual drop chance is, the higher the bonus) Normal / Miniboss Cards: 0.20% MVP Cards: 0.04% Max Base Level: 260 Max Job Level: 70 (dependent upon Job) Max Aspd: 193 Server Location: EU (France) Server Time: UTC Staff's Languages: English, German Features Master Accounts Custom Commands EXP-Event-Investment System Set your personal EXP-Rates per character Automated Events Unified RoDex Game Launcher Updated Eden Vending Map Daily Rewards Main Office Login Settings Many more and lots to come ~ Hope to see you soon ~ Muh ~

By Nubs

Read more

2024 May 27 Events

mRO Explore the world of mRO Now it's time to return! Create your account, download the game and come and have fun with us. We have a prosperous and friendly community!

By Nubs

Read more

2025 Apr 18 Patch Notes

Login_interface Hello, everyone. I edited the .tga and the .bmp files inside "login_interface" cause i wanted to change how it looks. but when i replaced the files with my own, it doesn't show up. there was only 4 files there and i copied the name exactly, the .tga doesnt show neither does the .bmp. did i miss something or is there something else that i need to do?

By Nubs

Read more

2025 Apr 17 Patch Notes

H> User config & Char Config SQL hello i already import the sql file but it is error in the webserver

By Nubs

Read more

2025 Apr 16 Patch Notes

Need help with modifying this script anthell02,1,1,0 script AntHellInvasion -1,{ OnInit: while(1) { initnpctimer; end; OnTimer10800000: stopnpctimer; announce "I am Gluttony, a hunger that knows no end. I descend to your realm, not as a beast of fangs and claws, but as a subtle whisper in your ear.", bc_all; monster "anthell02",0,0,"Sin of Gluttony",20581,1,"AntHellInvasion::OnAntHellDead"; monster "anthell02",0,0,"Gluttonous Valkyrie",1765,50,"AntHellInvasion::OnInvasionAntHell"; monster "prontera",98,186,"Gluttonous Plant",1750,1,"AntHellInvasion::OnInvasionAntHellPlant"; end; OnInvasionAntHell: end; OnAntHellDead: killmonster "anthell02","AntHellInvasion::OnInvasionAntHell"; killmonster "prontera","AntHellInvasion::OnInvasionAntHell"; announce "["+ strcharinfo(0) +"] has slain "+ getmonsterinfo( killedrid, MOB_NAME ), bc_all; MVPKills = MVPKills+2; dispbottom "---------------------------------------------------"; dispbottom "You killed a total of "+MVPKills+" MVP"+((MVPKills == 1)?"":"s")+"."; #mvp_points += 2; dispbottom "You've gained two points! Your total is ["+#mvp_points+"] MvP point(s)."; dispbottom "---------------------------------------------------"; } } Im having a hard time getting this script to have a selection of its spawn time. Right now, it always spawn 3hours after server start and after kill. I want it to spawn randomly between 2.5 hours to 3hours. Tried adding switch(rand(2)){ and put 2 cases but the script only summons the boss on the lowest OnTimer. Also, if it is possible, make the Plant not killable during the event was on. This plant serves as indicator that the mvp had been summoned. Some times players logged in after the announcement of the mvps arrival

By Nubs

Read more

2025 Apr 15 Patch Notes

Popping Messages. Any idea why this keeps popping? Please Help. Thanks!

By Nubs

Read more

2025 Apr 15 Patch Notes

I need help [mvp ranking] // LOJA DE MVP POINTS - pointshop Shop_MVPPOINTS -1,#MVPPOINTS,501:10,502:10,503:10,504:10,505:10,506:10 //---- MvP Ladder Logic Script - script mvpladder -1,{ OnInit: // Configurações .map_killannounce = 0; // anunciar quando o MVP é morto no mapa onde o MVP foi morto: 0 - desativado, 1 - ativado .killannounce = 1; // anunciar quando o MVP é morto globalmente: 0 - desativado, 1 - ativado .gmnokill = 0; // GMs não devem matar MVPs. Um GM com nível <este número> ou superior não fará nada. Se definido como 60, GMs de nível 60 ou superior não receberão nada ao matar jogadores: 0 - desativado .min_gm_menu = 90; // nível mínimo do GM que pode usar o menu do GM no NPC da escada .showtotal = 10; // mostrar o comprimento da escada. .showpage = 10; // definir as visualizações por página. .showstatue = 3; // número de estátuas. Este número deve corresponder ao número de duplicatas no final do script. .fix_custom_sprite = true; // se o seu servidor tem sprites animados personalizados que se sobrepõem à animação da estátua repetidamente, ative isso // Config ends ------------------------------------------------------------------------------------------ //// to prevent bug happen // if (.gmnokill <= 0) .gmnokill = 100; // // sleep 1; OnTimer10000: // refresh statues every 1 minute. Note the `char` table is unrealiable, player still need to perform certain task to save the character -> see 'save_settings' in conf\map-server.conf .@query$ = "SELECT `char`.`char_id`, `char`.`name`, `char`.`guild_id`, `char`.`class`, " + "`char`.`sex`, `char`.`hair`, `char`.`hair_color`, `char`.`clothes_color`, " + "`char`.`body`, `char`.`head_top`, `char`.`head_mid`, `char`.`head_bottom`, `char`.`robe`, " + "SUM(`mvpladder`.`kills`) as `orderKills` " + "FROM `char` RIGHT JOIN `mvpladder` ON `char`.`char_id` = `mvpladder`.`char_id` GROUP BY `char`.`char_id` ORDER BY `orderKills` DESC LIMIT " + .showstatue; .@nb = query_sql(.@query$, .@cid, .@name$, .@guild_id, .@class, .@sex$, .@hair, .@hair_color, .@clothes_color, .@body, .@head_top, .@head_mid, .@head_bottom, .@robe, .@kills); if (.fix_custom_sprite) { for (.@i = 0; .@i < .@nb; ++.@i) { setunitdata .statue[.@i +1], UNPC_HEADTOP, 0; setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, 0; setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, 0; setunitdata .statue[.@i +1], UNPC_ROBE, 0; } } for (.@i = 0; .@i < .@nb; ++.@i) { setunitdata .statue[.@i +1], UNPC_CLASS, .@class[.@i]; setunitdata .statue[.@i +1], UNPC_SEX, (.@sex$[.@i] == "F")? SEX_FEMALE:SEX_MALE; setunitdata .statue[.@i +1], UNPC_HAIRSTYLE, .@hair[.@i]; setunitdata .statue[.@i +1], UNPC_HAIRCOLOR, .@hair_color[.@i]; setunitdata .statue[.@i +1], UNPC_CLOTHCOLOR, .@clothes_color[.@i]; setunitdata .statue[.@i +1], UNPC_BODY2, .@body[.@i]; setunitdata .statue[.@i +1], UNPC_HEADTOP, .@head_top[.@i]; setunitdata .statue[.@i +1], UNPC_HEADMIDDLE, .@head_mid[.@i]; setunitdata .statue[.@i +1], UNPC_HEADBOTTOM, .@head_bottom[.@i]; setunitdata .statue[.@i +1], UNPC_ROBE, .@robe[.@i]; setnpcdisplay "mvp_ladder_statue#"+(.@i +1), .@name$[.@i]; .statue_name$[.@i +1] = .@name$[.@i]; .statue_guild$[.@i +1] = getguildname(.@guild_id[.@i]); .statue_kills[.@i +1] = .@kills[.@i]; } for (.@i = .@nb; .@i < .showstatue; ++.@i) setunitdata .statue[.@i +1], UNPC_CLASS, HIDDEN_WARP_NPC; initnpctimer; end; OnNPCKillEvent: // Logic to detect when a MvP is killed if(getgmlevel() < 3) { if (getmonsterinfo(killedrid, MOB_MVPEXP) > 0) { announce "[ Ranking MVP ] : O jogador ["+ strcharinfo(0) +"] do grupo ["+ strcharinfo(1) +"] acaba de matar o MVP "+ getmonsterinfo( killedrid, MOB_NAME ) +" em "+ strcharinfo(3), bc_all; .@selectIfKillExistQuery$ = "SELECT char_id, mob_id, kills FROM mvpladder WHERE char_id = '" + getcharid(0) + "' AND mob_id = '" + killedrid + "';"; if (query_sql(.@selectIfKillExistQuery$) > 0) { // Exist a kill of that MVP so +1 to kill count .@updateLadderQuery$ = "UPDATE mvpladder SET kills = kills + 1 WHERE char_id = '" + getcharid(0) + "' AND mob_id = '" + killedrid + "'"; } else { // Create a new kill of specific MVP //.@updateLadderQuery$ = "INSERT INTO mvpladder (char_id, mob_id, kills) VALUES ('" + getcharid(0) + "','" + killedrid + "','1');"; .@updateLadderQuery$ = "INSERT INTO mvpladder (`char_id` , `mob_id` , `kills`) VALUES ('" + getcharid(0) + "','" + killedrid + "','1');"; } query_sql(.@updateLadderQuery$); } } end; } //Pontos MVP - script mvppoint01 -1,{ OnNPCKillEvent: setarray .@monsterID[0],1038,1039,1046,1059,1086,1087,1112,1115,1147,1150,1157,1159,1190,1251,1252,1272,1312,1373,1389,1418,1492,1511,1583,1623,1630,1658,1685,1688,1719,1785,1885,2068,1957; // ID Dos Boss for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1) if(killedrid == .@monsterID[@a]){ set #MVPPOINTS,#MVPPOINTS+1; message strcharinfo(0),"[RagnaUp]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs."; if (rand(1000) < 10){ getitem 45000,1; announce "O jogador "+strcharinfo(0)+" acaba de dropar Cash Eletrônico do MVP "+ getmonsterinfo( .@monsterID[@a], MOB_NAME ) +"!",0; } } } - script mvppoint03 -1,{ OnNPCKillEvent: setarray .@monsterID[0],1708,1734,1751,1768,1779,1832,1871,1917; // ID Dos Boss for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1) if(killedrid == .@monsterID[@a]){ set #MVPPOINTS,#MVPPOINTS+15; message strcharinfo(0),"[RagnaUp]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs."; if (rand(1000) < 50){ getitem 45000,1; announce "O jogador "+strcharinfo(0)+" acaba de dropar Cash Eletrônico do MVP "+ getmonsterinfo( .@monsterID[@a], MOB_NAME ) +"!",0; } } } - script mvppoint05 -1,{ OnNPCKillEvent: setarray .@monsterID[0],1646,1647,1648,1649,1650,1651,1874,1929,1956,2022; // ID Dos Boss for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1) if(killedrid == .@monsterID[@a]){ set #MVPPOINTS,#MVPPOINTS+30; message strcharinfo(0),"[RagnaUp]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs."; if (rand(1000) < 100){ getitem 45000,1; announce "O jogador "+strcharinfo(0)+" acaba de dropar Cash Eletrônico do MVP "+ getmonsterinfo( .@monsterID[@a], MOB_NAME ) +"!",0; } } } //---- Informações do NPC Lider MVP prontera,122,135,5 script Caçador de MVP 733,{ .@npcname$ = strnpcinfo(0); while (1) { mes "["+ .@npcname$ +"]"; mes "Olá ^A020F0"+ strcharinfo(0) +"^000000..."; mes "Você tem atualmente ^0000ff"+#MVPPOINTS+"^000000 Pontos MVP."; next; switch (select("^339966[»]^000000 Ranking MVP","^008aff[»]^000000 MVPs mais Caçados","^A020F0[»]^000000 Abrir a Loja")) { case 1: mes "^FF0000O ranking é resetado todo dia 01.^000000"; mes ""; .@queryKillerList$ = "SELECT t1.char_id, SUM(t1.kills) as `orderKills`, t2.name " + "FROM `mvpladder` t1 " + "INNER JOIN `char` t2 " + "ON t1.char_id = t2.char_id " + "GROUP BY t1.char_id " + "ORDER BY `orderKills` DESC " + "LIMIT " + getvariableofnpc(.showtotal, "mvpladder") + ";"; .@nb = query_sql(.@queryKillerList$, .@charid, .@kills, .@name$); if (!.@nb) { mes "O Ranking está vazio no momento."; next; } for (.@j = 0; .@j < .@nb; .@j += getvariableofnpc(.showpage,"mvpladder")) { for (.@i = .@j; .@i < (getvariableofnpc(.showpage,"mvpladder") + .@j) && .@i < .@nb; ++.@i) mes "^996600" + (.@i+1) + ": ^006699" + .@name$[.@i] + " - ^00AA00[" + .@kills[.@i] + "]^FF0000 MVPs Mortos^000000"; next; } break; case 2: .@queryKilledList$ = "SELECT char_id, mob_id, SUM(kills) as `orderKills` " + "FROM `mvpladder` " + "GROUP BY mob_id " + "ORDER BY `orderKills` DESC " + "LIMIT " + getvariableofnpc(.showtotal, "mvpladder") + ";"; .@nb = query_sql(.@queryKilledList$, .@charid, .@mobid, .@kills); if (!.@nb) { mes "O top está vazio no momento."; next; } for (.@j = 0; .@j < .@nb; .@j += getvariableofnpc(.showpage,"mvpladder")) { for (.@i = .@j; .@i < (getvariableofnpc(.showpage,"mvpladder") + .@j) && .@i < .@nb; ++.@i) { mes "^996600" + (.@i+1) + ": ^006699" + getmonsterinfo(.@mobid[.@i], 1) + " ^FF0000MVP ^00AA00[Morto ^FF0000" + .@kills[.@i] + " ^00AA00Vezes]^000000"; } next; } query_sql("SELECT SUM(kills) FROM mvpladder;", .@killCount); mes "^996600==> ^006699Total de MVPs Mortos [^00AA00" + .@killCount[0] + "^000000^006699]^FF0000"; break; case 3: dispbottom "Você tem "+#MVPPOINTS+" Pontos de MVP."; close2; callshop "Shop_MVPPOINTS"; end; } OnInit: initnpctimer; setunittitle(getnpcid(0), "[ Ranking e Loja ]"); end; OnTimer10000: showscript("Líder MVP"); setnpctimer 0; end; } close; } //---- MSG board NPCs - script mvp_ladder_statue -1,{ .@id = getelementofarray(getvariableofnpc(.npcgid, "mvpladder"), getnpcid(0)); mes "^996600[TOP MVP "+ .@id +"]"; mes "^006699Nome: "+ getelementofarray(getvariableofnpc(.statue_name$, "mvpladder"), .@id); .@guildname$ = getelementofarray(getvariableofnpc(.statue_guild$, "mvpladder"), .@id); mes "^00AAAAGuild: "+((.@guildname$ == "null")? "^AAAAAANone": .@guildname$); mes "^00AA00Matou: ["+ getelementofarray(getvariableofnpc(.statue_kills, "mvpladder"), .@id) +"]"; close; OnInit: .@id = strnpcinfo(2); set getvariableofnpc(.statue[.@id], "mvpladder"), getnpcid(0); set getvariableofnpc(.npcgid[getnpcid(0)], "mvpladder"), .@id; end; } prontera,127,138,4 duplicate(mvp_ladder_statue) mvp_ladder_statue#1 1_F_MARIA prontera,124,141,4 duplicate(mvp_ladder_statue) mvp_ladder_statue#2 1_F_MARIA prontera,130,141,4 duplicate(mvp_ladder_statue) mvp_ladder_statue#3 1_F_MARIA //== clone base prontera,127,138,2 script #2 844,{ end; OnInit: while(1) { specialeffect EF_MVP; sleep 10000; } } //prontera,172,204,2 script #npcuniquename PORTAL,{} //prontera,140,180,5 script #npcuniquename1 PORTAL,{} //prontera,138,182,2 script #npcuniquename2 PORTAL,{} //== msg top da cabeça prontera,127,138,4 script #top1 111,{ OnInit: initnpctimer; end; OnTimer1000: showscript("Top-1 MVP"); setnpctimer 0; end; } prontera,124,141,4 script #top2 111,{ OnInit: initnpctimer; end; OnTimer1000: showscript("Top-2 MVP"); setnpctimer 0; end; } prontera,130,141,4 script #top3 111,{ OnInit: initnpctimer; end; OnTimer1000: showscript("Top-3 MVP"); setnpctimer 0; end; } - script reset_ranking -1,{ OnClock0005: if(gettime(DT_DAYOFMONTH) == 1){ query_sql ("TRUNCATE `mvpladder`"); end; } OnInit: bindatcmd "resetrankingmvp", strnpcinfo(0) +"::OnReset"; end; OnReset: if (getgmlevel() > 98) { query_sql ("TRUNCATE `mvpladder`"); dispbottom "Ranking MVP resetado com sucesso!"; end; } else { dispbottom "Somente Administradores podem usar este comando"; end; } end; } I have a warning problem whenever a player defeats an MVP. Can someone help me with this problem? The error line is below: [Warning]: script:query_sql: Too many columns, discarding last 3 columns.

By Nubs

Read more