Leaderboard


Popular Content

Showing content with the highest reputation since 03/20/2018 in all areas

  1. 16 points
    This morning started as any other day, I wake up, I check my personal emails, I eat breakfast, I check my business emails, I put my boots on then check rAthena emails. This is where this morning differed. Over the last fortnight an astonishing number of chargeback disputes have been filed with Paypal, and a particular dispute that was closed by Paypal this morning in favor of the buyer was the last straw. This particular dispute was for a file that cost $10. The fee for chargeback disputes to the seller when lost is now $20. rAthena is essentially being scammed out of more and more money each month because of these fees and dirty scumbags, and I can no longer justify spending my own money to cover them. And people wonder why it's taking a while for Withdrawals to be processed. Paypal has been removed as a payment method on rAthena. Users who have submitted chargeback disputes have been banned. What does this mean? It means that if you would like to pay for an invoice, you may use your credit/debit card which will be processed by Stripe. Your card details are not saved on our webserver. Since the Stripe module was enabled almost 2 weeks ago, there have been a number of attempted transactions that have been refused by Stripe due to their fraud rules. And we are loving it! If your rAthena account name, address and phone number don't match the cardholder's details, you'll be declined. If you don't put in your CVC (3 digits on the back), you'll be declined. If your rAthena account is less than 20 days old, your transaction will be authorised but placed on hold for manual review. If you're dumb, you'll be banned. How does this affect Withdrawals? Essentially, it doesn't. Your Withdrawal request will still be processed through Paypal via our automated script. To be quite honest, i'm very disappointed with a select area of our community.
  2. 4 points
    Salve salve comunidade BR do rATHENA aqui quem vós fala é o Zelos sou desenvolvedor e contribuo como posso para alguns fóruns de Ragnarok, já venho observando a tempos que o rATHENA se mantém o emulador mais atualizado e por isso estou com um projeto para traduzi-lo para português, porem sozinho é praticamente impossível porque demandaria muito tempo coisa que eu não tenho, e o brAthena mudou e está seguindo os padrões do Hercules pelo que me parece, então iremos traduzir tudo na mão, de uma forma que sempre que houver uma atualização iremos precisar traduzir apenas os novos NPCs, pretendo manter o projeto sempre atualizado, mas para isso preciso de uma equipe que me ajude e até incentive em continuar porque sozinho é desmotivador, caso alguém se interesse em participar da equipe iremos disponibilizar para toda comunidade BR isso ajudaria muito para futuros servidores de Ragnarok Brasileiros ou Portugueses, os requisitos mínimos são: Boa vontade e conhecimento em Inglês, Caso queiram participar da equipe favor me mandem uma mensagem aqui no fórum mesmo no privado para mantermos contato e trocarmos umas ideias, a tradução será toda dividida para que a equipe não fique sobrecarregada e demandará tempo ou seja pessoas que se interessarem no futuro em entrar para a equipe podem me procurar pois teremos uma rotação de pessoas. Lembrando que todos que participarem do projeto terão seus nomes citados como contribuintes para o projeto! PS: Mesmo que não possa ajudar no projeto se você gostou dessa iniciativa e quer nos apoiar deixe seu comentário ai da um Upvote no tópico! Desde já agradeço, Att; Zelos
  3. 4 points
    Introduction The objective of this guide is to create a full client that can run on every platform and where you have complete control over the source code of it, meaning you can add new windows, style every part of the game and adapt it to suit your server need. To do so we'll rely on a stack made of node-js with electron framework and express combined with RoBrowser from KeyWorld. Setup Text Editor Get a good text editor, my personal choice for this will be atom : https://atom.io/ RoBrowser Download RoBrowser from here : https://www.robrowser.com/ Follow the instructions present here to set it up : https://www.robrowser.com/getting-started You'll need a webserver for the first setup, if you're on Linux use Apache with PHP other wise you can get a nice wamp stack here : http://www.easyphp.org/ This is the basic result you should at least get to before continuing this tutorial : Electron Download NodeJS from here : https://nodejs.org/en/ Install it and restart your computer. Open a terminal / Windows Command Line and type the following : npm install -g electron-forge Creating a new project In the terminal, go to your working folder : cd c:\projects For the sake of this tutorial, we'll call our project "sakexe". Now you'll initialize your project : electron-forge init sakexe A new folder named after the project was created, we'll move into this folder : cd sakexe We'll now install express : npm install express --save Open your project with atom : Now we'll edit index.html to the following (replace ROConfig contents with whatever your configuration is) : <!DOCTYPE html> <html> <head> <title>SakExe : FullClient</title> <meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> <script type="text/javascript" src="./api.js"></script> <script type="text/javascript"> function initialize() { var ROConfig = { target: document.getElementById("robrowser"), type: ROBrowser.TYPE.FRAME, application: ROBrowser.APP.ONLINE, remoteClient: "http://127.0.0.1:5737/client/", development: false, servers: [{ display: "Demo Server", desc: "roBrowser's demo server", address: "5.135.190.4", port: 7000, version: 25, langtype: 12, packetver: 20131223, packetKeys: true, socketProxy: "ws://5.135.190.4:443/", adminList: [2000000] }], skipServerList: true, skipIntro: true, }; var RO = new ROBrowser(ROConfig); RO.start(); } window.addEventListener("load", initialize, false); </script> <style> html, body, iframe, #robrowser { height:100%; width:100%; margin:0; padding:0; overflow: hidden; min-width: 800px; min-height: 600px; } </style> </head> <body> <div id="robrowser">Initializing roBrowser...</div> </body> </html> Edit index.js to the following : import { app, BrowserWindow } from 'electron'; const express = require('express'); const server = express(); // Handle server requests to serve static files server.use('/', express.static((__dirname))); // Handle creating/removing shortcuts on Windows when installing/uninstalling. if (require('electron-squirrel-startup')) { // eslint-disable-line global-require app.quit(); } // Keep a global reference of the window object, if you don't, the window will // be closed automatically when the JavaScript object is garbage collected. let mainWindow; const createWindow = () => { // Start listening to port 5737 server.listen(5737, function() {}); // Create the browser window. mainWindow = new BrowserWindow({ width: 800, height: 600, }); // and load the index.html of the app. mainWindow.loadURL(`http://127.0.0.1:5737`); // Disabling the webtools mainWindow.webContents.on("devtools-opened", () => { mainWindow.webContents.closeDevTools(); }); // Disabling the mainmenu mainWindow.setMenu(null); // Emitted when the window is closed. mainWindow.on('closed', () => { // Dereference the window object, usually you would store windows // in an array if your app supports multi windows, this is the time // when you should delete the corresponding element. mainWindow = null; }); }; // This method will be called when Electron has finished // initialization and is ready to create browser windows. // Some APIs can only be used after this event occurs. app.on('ready', createWindow); // Quit when all windows are closed. app.on('window-all-closed', () => { // On OS X it is common for applications and their menu bar // to stay active until the user quits explicitly with Cmd + Q if (process.platform !== 'darwin') { app.quit(); } }); app.on('activate', () => { // On OS X it's common to re-create a window in the app when the // dock icon is clicked and there are no other windows open. if (mainWindow === null) { createWindow(); } }); // In this file you can include the rest of your app's specific main process // code. You can also put them in separate files and import them here. It's time to copy contents from your RoBrowser folder into your Sakexe folder so your file structure looks like this : Now you can try your project by typing the following : electron-forge start Here's the expected result : Compiling Your can now compile your project for your current platform by using : electron-forge make You can find more details about compilation and packaging at the following link : https://github.com/electron-userland/electron-forge Branding You can set an icon for your executable by following these instructions here : https://stackoverflow.com/questions/44122559/how-to-set-the-app-icon-using-electron-forge-package-on-mac Thanks for reading 😘 Changelog 2018-04-02 : Fixed a mistake in parameters sent to RoBrowser that'd try to load the client from RoBrowser repository instead of the local custom client. I plan to edit this guide later on to implement a websocket proxy directly into the electron framework to avoid having to set on up with RoBrowser.
  4. 3 points
    View File Soul Link Modification - Script-based Information This source allows you to "script" additional bonuses on soul link buffs like an item script. See db/soul_link.yml for example. Q: Why this and not OnPCStatCalcEvent? A: PCStatCalc is known to be buggy. Alternate diff link: https://github.com/secretdataz/rathena/commit/6b91c4d18cc537e25a64f371ee3faf468b9dcc99.diff THIS RELEASE IS SUBJECT TO GPLv3 LICENSE Copyright © - Secrets <[email protected]> 2018 - All Rights Reserved Take a look at my premade script list if you like my works or want one of my premade scripts. or Submitter Secrets Submitted 04/02/2018 Category Source Modifications Video Content Author Secret  
  5. 3 points

    Version 1.0.0

    30 downloads

    //===== rAthena Script ======================================= //= @hide //===== By: ================================================== //= Akkarin //===== Current Version: ===================================== //= 1.0 //===== Compatible With: ===================================== //= rAthena Project //===== Description: ========================================= //= Adds some sexy purple smoke to the @hide command. //= Default to @ and # commnd level 99. Feel free to change. //============================================================ //= This is based off an ancient src edit to the @hide command, but for the life of //= me i can't find it so it's now in a script, so src edits aren't required. //============================================================

    Free

  6. 3 points
    Honestly I don't get why donations even need a chargeback option. Donations are donations and not a purchase.
  7. 3 points
    View File Sprouting Set SPROUTING CUSTOM MONSTER + EXTRAS Greetings again, rAthena! I'm Haziel, you might know me from the work I've done for the past years, I'm back again with new releases every week. And, to begin with, I'm bringing back my old freebies which had their links broken for quite a while now. But, I couldn't do that without improving them and bringing them to the current level of skill I have nowadays. Sprouting is a Custom Monster, not much more than a simple Poring edit, however this is a good one. It can be used as a Custom Monster but also as a Custom Pet! All pet performances included! This very package also includes its own Item ACT which makes this monster compatible with the default Backpack. For the monster yet, its own Custom Card is also present on this package, along with the proper Custom Illustration to be used on the Pet Interface. And just like those old school advertisings, that's not all of it yet! A Custom Headgear, Sprouting-themed is also part of the bundle! I hope you enjoy the final product! If you're interested on my work, Contact me on hyering or through one of the channels below! By downloading this file, you agree with my Terms of Service: • YOU WILL NOT remove my signature from any of the included files. • YOU WILL NOT alter, edit, recolour any of my files unless for your personal use. • YOU WILL NOT repost, repass or mirror my work nor edited versions of it anywhere. • YOU WILL NOT sell, resell or in any manner, ask money or rewards using my work as exchange. • YOU WILL NOT claim my work as yours. Submitter Haziel Submitted 04/04/2018 Category Monster Sprites Video Content Author Haziel Graphics, Gravity Corp  
  8. 3 points
    You abandoned all who had bought the bg system, dropped without updates with a bugged emulator causing duplication of items. Welcome back....
  9. 3 points

    Version 1.0.0

    42 downloads

    Information This source allows you to "script" additional bonuses on soul link buffs like an item script. See db/soul_link.yml for example. Q: Why this and not OnPCStatCalcEvent? A: PCStatCalc is known to be buggy. Alternate diff link: https://github.com/secretdataz/rathena/commit/6b91c4d18cc537e25a64f371ee3faf468b9dcc99.diff THIS RELEASE IS SUBJECT TO GPLv3 LICENSE Copyright © - Secrets <[email protected]> 2018 - All Rights Reserved Take a look at my premade script list if you like my works or want one of my premade scripts. or

    Free

  10. 3 points
    ah ... found a bug I forgotten the loadevent can be use from another script if you install another script with loadevent mapflag will cause this script to warp out other players indiscriminately 1 more time http://upaste.me/06e6495427daded7f EDIT: Jesus ... I made mistake too many times, really lost touch with scripting yeah ... atm, not a godlike scripter yet XD btw, did you guys mentioned wrong person ?? I am @AnnieRuru not @Annie Ruru
  11. 3 points
    I’ll see what I can do with converting this file’s structure
  12. 3 points
    HI everyone! I want to share my script "Personal storage". This will allow each character on the account to have his own personal storage. This script supports 15 characters on the account. Free for use Script: prontera,159,193,4 script Personal storage#prt 113,{ mes "[Personal storage]"; mes "Here, let me open"; mes "your Storage for you."; mes "Thank you for using"; mes "the Kafra Service."; [email protected] = query_sql("SELECT char_num FROM `char` WHERE char_id = '"+getcharid(0)+"' AND account_id = '"+getcharid(3)+"'", [email protected]_num$); close2; if ([email protected]_num$ == "0") openstorage2 50,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "1") openstorage2 51,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "2") openstorage2 52,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "3") openstorage2 53,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "4") openstorage2 54,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "5") openstorage2 55,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "6") openstorage2 56,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "7") openstorage2 57,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "8") openstorage2 58,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "9") openstorage2 59,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "10") openstorage2 60,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "11") openstorage2 61,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "12") openstorage2 62,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "13") openstorage2 63,STOR_MODE_GET|STOR_MODE_PUT; else if ([email protected]_num$ == "14") openstorage2 64,STOR_MODE_GET|STOR_MODE_PUT; else mes "Can`t open storage. Unknown char_id."; end; } Configuration: add this lines to conf/inter_server.yml # Char 1-3 - ID: 50 Name: "Storage" Table: "storage_char_0" Max: 300 - ID: 51 Name: "Storage" Table: "storage_char_1" Max: 300 - ID: 52 Name: "Storage" Table: "storage_char_2" Max: 300 # Char 4-6 - ID: 53 Name: "Storage" Table: "storage_char_3" Max: 300 - ID: 54 Name: "Storage" Table: "storage_char_4" Max: 300 - ID: 55 Name: "Storage" Table: "storage_char_5" Max: 300 # Char 7-9 - ID: 56 Name: "Storage" Table: "storage_char_6" Max: 300 - ID: 57 Name: "Storage" Table: "storage_char_7" Max: 300 - ID: 58 Name: "Storage" Table: "storage_char_8" Max: 300 # Char 10-12 - ID: 59 Name: "Storage" Table: "storage_char_9" Max: 300 - ID: 60 Name: "Storage" Table: "storage_char_10" Max: 300 - ID: 61 Name: "Storage" Table: "storage_char_11" Max: 300 # Char 13-15 - ID: 62 Name: "Storage" Table: "storage_char_12" Max: 300 - ID: 63 Name: "Storage" Table: "storage_char_13" Max: 300 - ID: 64 Name: "Storage" Table: "storage_char_14" Max: 300 Add new sql tables: CREATE TABLE IF NOT EXISTS `storage_char_0` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_1` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_2` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_3` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_4` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_5` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_6` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_7` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_8` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_9` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_10` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_11` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_12` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_13` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `storage_char_14` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` smallint(11) unsigned NOT NULL DEFAULT '0', `equip` int(11) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val0` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm0` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val1` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm1` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val2` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm2` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm3` tinyint(3) unsigned NOT NULL DEFAULT '0', `option_id4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_val4` smallint(5) unsigned NOT NULL DEFAULT '0', `option_parm4` tinyint(3) unsigned NOT NULL DEFAULT '0', `expire_time` int(11) unsigned NOT NULL DEFAULT '0', `bound` tinyint(3) unsigned NOT NULL DEFAULT '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3169 DEFAULT CHARSET=utf8;
  13. 2 points
  14. 2 points
    @Holograma download the latest version.. I've incorporated your request in that version... @Haikenz As I re-checked my script. I already put no-branch mapflag on all maps listed.. Version 3.0 contains the ff changelogs: MVP Ladder points system MVP Ladder points shop See your rank standings Optimized and Re-worked
  15. 2 points
    tl;tr Download Package Folder and extract all archives inside each folder (mirrors for google drive, or dropbox at the end of page) Copy-paste pre-made clients files from /03_client_side_files/ folder to your kRO Ragnarok Online Client Go to /02_openserver/ and Run OpenServer (it will start mysql-server where already you have rathena_db, and rathena_logs databases) Go to 01_emulator/rathena/ and run "runserver.bat" if you wish RENEWAL mechanic and content, or "runserver_PRERE.bat" if you wish PRE-RE Run's RO game client (2015-11-04aRagexe.exe) from your kRO Ragnarok Online Client Enter to the game via login: admin, pass: 123456, and have fun (if you need to make your own account, scroll down to FAQ on this topic) For everything above you will need around 5 minutes or less. Very useful package for newbies, or people who wish Ragnarok Online online server to play offline or which wants to make their own server & client but don't know how to start or how to do it. Before you start My english is sucks, i know it, but please hold back your tears of blood until you finish reading. You will find this information very useful. What is it? This is package of everything that you need for a running server on your local Windows PC (emulator, mysql-server, game client, extra utilities). This pack oriented mostly for people without knowledge and time for education how everything works, but which wish to run Ragnarok Online server at their own PC, or which wish to try and learn something new, but never tried it, or confused with configuration part. Anyway, it can be used not only by such people. It will be very good boost for any newbie which stuck a lot with basic first step (server configuration) I remember when I was a newbie, and something like full pack which i have used as example was saved for me a lot of my time. Because everything is here, and here is fully working an example of everything that need to know, and you can skip boring configuration part and do funny things, or education with the emulator which in final result will again -> save a lot of time for you. When i say read, i mean: exe diffed, grf's packed, emulator compiled, mysql-server configured, .sql files imported, packet_db setted, configuration part done. Just run open-server, then run emulator exe (runserver.bat) and open game client = and boom, you are in game About What usually need to do to make rAthena works? you need a compiler for compiling emulator from source code to a ready application which you will run. you need mysql-server where will be stored database which will be used by rAthena emulator (need import sql files, and create mysql users, then set everything at rAthena) you need translated and up to date game client, which will support latest available RO features you need diffed .exe file to run game client which will load everything above. What will you get from this pack? pre-compiled and configured Emulator to .exe files (map, char, login servers) for both version of RENEWAL and PRE-RENEWAL version of rAthena (you don't need any compiler at all) pre-configured web-server stack (mysql-server + different important and useful tools for you), with already imported rAthena sql database inside packed for you LATEST and clean translated files for your game client, with actual and correct English translation (will work 2012+ game exe (but we using 2015-11-04)) already diffed 2015-11-04aRagexe game client which will work with everything above. Main Pack Idea Just download full pack folder, extract archives inside, copy from /03_clientside_files/ files to your kRO Game Client, then run OpenServer, then go to rAthena folder and run emulator. Then open game client and play. No actions from you required, no guides to read needed, everything will work out the box, even if you monkey How to Use Before you start, please download latest CLEAN kRO (Korean Ragnarok Online) game client. Here just example link (updated by me and actual): https://mega.nz/#F!RplhTAKB!dzCgiK7555XVUGxH5-sEzQ 0. Download it and install it somewhere, I suggest install it to C:\Games\ROCLIENT 1. Go to /01_emulator/ and extract rathena.zip Don't forget to read readme.txt inside the folder. This readme file explains everything that you need to know about rAthena. As you understand, this is pre-compiled and configured Ragnarok Online Emulator 2. Go to /02_openserver/ and extract OpenServer.zip This is pre-configured and cleaned web-server stack (mysql-server / etc) which you should start every time when you running the server (green flag) Don't forget to read "readme.txt" inside that folder, it will explain everything for you. 3. Go to /03_client_side_files/ and copy all files inside to your clean kRO folder (step #0) By default, you copy files which packed for RENEWAL mechanic with renewal descriptions / etc. If you wish, after copying files, you can overwrite different to RENEWAL translation from PRERE_VERSION folder Just open PRERE_VERSION folder and copy-paste everything from this folder to your kRO client. Don't forget to read "readme.txt" inside the folder, it will explain everything for you 4. 90% of work done, now need just understand main things: rAthena Emulator can't work without database server. So before running emulator, and then game client, you should run the server, then emulator, and only then the client. Your steps now (from server start to entering the game): a.) go to /02_openserver/OpenServer/ and run Open Server x64.exe (depends on your Windows Version) b.) you will see "Red Flag" at your tray bar (near clocks), click on it, then select "Run Server". if your antivirus not crazy, or firewall is ok -> server will be run normally and you will see that Red Flag changed to Green Color. if you experience any issues, go to official OpenServer website and ask for help: https://ospanel.io/forum/ c.) go to /01_emulator/rathena/ and depends on mechanic what you wish to have run: - or runserver.bat = RENEWAL mechanic (default (since 2010 up to now)) - or runserver_PRERE.bat = PRE_RE (classic mechanic (up to 2010 year)) It will open 3 console windows, where you should not see any "Error" messages if everything is ok. Here is screen from normal working server, which you can use for check if everything looks ok: https://i.imgur.com/YBS4rgk.png d.) now you can run the game client and connect to running rAthena Ragnarok Online server. Open C:\Games\ROCLIENT and find 2015-11-04aRagexe.exe and run it. By default, i made 3 accounts for you with _M _F (see readme.txt in emulator folder) * login: admin, admin2, user * pass for all above: 123456 e.) Easy, is not it? Have fun ^_~ Whats next? By default you will run 1x rate server without any features, so you will wish to customize it a little bit. Here is your next steps (you need read a lot of info and check a lot of settings / files) Start from this place in next order: /doc/atcommand.txt - read first, it will help you with basic stuff at your GM account. /conf/battle/ - here is many configurable options for different mechanic settings. Use @reloadbattleconf in game to reload on live server without restart the settings from this folder. /db/ - item_db.txt and mob_db.txt - will be useful for you too /npc/[pre-re or re]/scripts_main.conf, then scripts_athena.conf then do not forget to read files in /doc/ folder and ofcourse join to http://rathena.org and google answers for your questions at board. About Useful Tools I have added two must-have tools which will help you a lot to manage /db/ and client files easy as 1,2,3. Official board topics about genius tools below: - SDE (Server Database Editor): https://rathena.org/board/topic/98173-server-database-editor/ - GRF Editor: https://rathena.org/board/topic/77080-grf-grf-editor/ Credits (i do not say nicknames, because whole community deserve credits here, and there is not enough space) https://github.com/zackdreaver/ - translation project (this guy did really a lot) https://github.com/rathena/rathena/graphs/contributors - guys, without who you will not see Ragnarok Online [FAQ] Q: I'm confused, and can't understand what need to download, what need to run, etc. What do i need to download for playing RO offline? A: Download full folder from download links below (right click on folder -> download all). Except this package you need official kRO client. Q: Is it possible to use some files from this package at different projects, or independent? A: Yes, you can use GRF, or EXE, or Emulator + OpenServer indepeneded of each other with your own grfs / exe or emulator Q: Is it RENEWAL or PRE-RE offline pack? A: Both. But by default everything compiled for RENEWAL. If you wish classic PRE-RE mechanic / item and skill translation -> just run in "/rathena/runserver_PRERE.bat", and copy files from 03_client_side_files\PRERE_VERSION\ to your RO client folder Q: Builded on/for what game client version? A: This package builded around 2015-11-04aRagexe, because it's latest stable supported game client with large amount of features if compare to older one. But GRF can work with clients from 2012 up to 2015 year without any problem. 2015-11-04aRagexe NEMO Applied Patch List Q: What phpmyadmin or mysql login / password, how to enter to database? A: Just login "root", password is empty (not set) You can use these credentials at phpmyadmin / adminer / heidiSQL / console Q: How can i edit MYSQL database, or user privilegies (for example i wish to make administrator) A: Run your OpenServer -> Then click on Green Flag -> Advanced -> phpmyadmin. Then enter to login: "root", and leave password field empty -> then click enter. Then select database "rathena_db", find table called "login" open it, find your user, and change value in "group_id" field to your own (0 =normal user, 99 = super user with all privileges). For more information please see groups.conf too. If you have any problems, please try to fix your system first. Everything in this pack was tested. Bugs can happen, but mostly 99% of functions works fine. Google is your best friend. Please read readme.txt files inside each folder, it will save a lot of your and mine time, inside these files explained different details. [File Structure] Download Links MEGA Folder | or Google Drive Folder | or DropBox Folder You need download full folder, not only 1 element from it, to make it work you need download all folder together. All filehostings below support folder downloading. Use it. The files not in archive, because imagine situation, when you need just .exe to download. Exe size around 15MB, if i put everything to archive, that means you need download around 400MB of data just to get diffed and correct working 15MB exe, i think it's not okay. Ragnarok Online offline pack 2017 works together with kRO Client. If you don't have kRO client, download it. Total Pack Size is 413MB
  16. 2 points
    There is no config for this, but you can either add a timer to the actual @go command in /src/map/atcommand.cpp or you can override the entire command by replacing it with an @go bindatcmd. There are several custom versions of this floating around in the Script Request section.
  17. 2 points
    Hello guys and Dev Team especially. Short summary for the following suggestion/request. I recently tried myself at the Random Option for the Vicious Mind Weapons of the Sky Fortress Instance. The problem which I had to realize after a while is that you get around 10k lines at least just for one Group depending on properities. My first tests was adding the effects itself first on the 1st option slot, so I get a hang of it, which worked well. After that I tried to put the properities into the correct position by using 0 for the other groups, which didn't work, but thought that it won't tho anyway, which looked like this: RDMOPTG_ViciousMind_Weapon,1,0,0,0,0,0,0,RDMOPT_VAR_STRAMOUNT,1,0 So I came to the conclusion either do it or handle it with an custom enchanter. This was also mentioned in this post, you could say the result will the same what I'm trying to do. As for the Suggestion/Request itself: I would like to propose 2 changes to the Random Option System: 1. Defining an Option Slot What I mean by that is that instead of // <randopt_groupid>,<rate>,<randopt_id1>,<randopt_value1>,<randopt_param1>{,<randopt_id2>,<randopt_value2>,<randopt_param2>,<randopt_id3>,<randopt_value3>,<randopt_param3>,<randopt_id4>,<randopt_value4>,<randopt_param4>,<randopt_id5>,<randopt_value5>,<randopt_param5>} Let's define the option slot directly like this: // <randopt_groupid>,<rate>,<option slot>,<randopt_id>,<randopt_value>,<randopt_param> // Element Option in Slot 1 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_NOTHING,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_WATER,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_GROUND,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_FIRE,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_WIND,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_SAINT,0,0 RDMOPTG_ViciousMind_Weapon,1,1,RDMOPT_WEAPON_ATTR_DARKNESS,0,0 // Damage/Magic Damage to Demon Race +1~10% in Slot 2 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,1,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,2,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,3,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,4,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,5,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,6,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,7,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,8,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,9,0 RDMOPTG_ViciousMind_Weapon,1,2,RDMOPT_RACE_DAMAGE_DEVIL,10,0 // Magical Weapons - Cast Delay -10% in Slot 3 RDMOPTG_ViciousMind_MWeapon,1,3,RDMOPT_DEC_SPELL_DELAY_TIME,10,0 2. Allow the usage of rand() in randopt_value This would shorten the file by a lot already, like this: // Physical Weapons - ATK +4~47 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,4,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,5,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,6,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,7,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,8,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,9,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,10,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,11,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,12,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,13,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,14,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,15,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,16,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,17,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,18,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,19,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,20,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,21,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,22,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,23,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,24,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,25,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,26,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,27,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,28,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,29,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,30,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,31,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,32,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,33,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,34,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,35,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,36,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,37,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,38,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,39,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,40,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,41,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,42,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,43,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,44,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,45,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,46,0 RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,47,0 // With the usage of rand() the above lines would become this: RDMOPTG_ViciousMind_Weapon,1,RDMOPT_VAR_ATTPOWER,rand(4,47),0 I hope you get what I mean with my suggestion/request or however someone would call it! Best regards, Chris
  18. 2 points
    2.4c http://upaste.me/7c9c496344829d36f - fix this f*cking deny usage once again ...this time when submit a mission, the getarraysize calculation is made AFTER declare the datetime format - if the whole board is set to EVERYDAY, remove the player side deny usage variable completely on the next day @hendra814 @Radian EDIT for below: the bug has nothing to do with time limit, but only happens if the whole board set to EVERYDAY I couldn't reproduced the bug before because I have already set some quest in the board, until Radian told me to make another duplicate npc ... in a clean board ... duplicated npc where no mission has been set, then setup every quest to EVERYDAY, then I finally able to reproduce the bug
  19. 2 points
    I just modify existing paste then http://upaste.me/b10549617c6f2d960 curious ... do you want to randomize the item requirement too ? I don't really understand what you say I just do it with different aura then
  20. 2 points
    just tested the patch is broken, so have to update the script 1.3 http://upaste.me/1b3249619f23c7755 - fix this script no longer need my patch - add showdigit (along with the stupid bug) - add .maxplayer2join and .imbalance_team_prevent @Elysium @Radian
  21. 2 points
    Im not sure about this but you can try... prontera,150,150,4 script Pokeeeee 100,{ .name$ = "["+strnpcinfo(0)+"]"; mes .name$; mes "How can I help you today?"; next; if(select("Enter Room:Just Passing by...") == 2) close; if(!countitem(30820)){ mes .name$; mes "I'm sorry but you dont have "+getitemname(30820)+", please come back when you have it in your inventory."; close; } mes .name$; warp "poring_w01",97,97; end; } - script Mobs FAKE_NPC,{ OnInit: areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3178,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3179,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3180,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3181,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3182,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3183,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3184,1,strnpcinfo(3)+"::OnMobKilled"; areamonster "pvp_n_1-5",0,0,0,0,"Pokemon",3185,1,strnpcinfo(3)+"::OnMobKilled"; end; OnMobKilled: dispbottom "Ash Catchem : How dare you kill a Pokemon!!"; warp "invek",146,161; end; } poring_w01 mapflag nowarp poring_w01 mapflag nowarpto poring_w01 mapflag noteleport poring_w01 mapflag nosave poring_w01 mapflag nomemo poring_w01 mapflag nobranch poring_w01 mapflag noloot poring_w01 mapflag noskill poring_w01 mapflag nopenalty
  22. 2 points
    You can use changebase with a OnPCBaseLevelUpEvent to change a player sprite, hold it in a character variable and check for that on login. There is an aura mod in the downloads section, you can use the same level check script and apply the aura for specific levels.
  23. 2 points
    February Digest 2018 The following digest covers the month of February, 2018. Staff Changes Daegaladh is now a developer. Development Highlights CORE: Added support for 2018-01-24 client (8792960d) Fixed a bug with pincode on 2018-01-24 client (9d4fa62e) Added support for 2018-02-07bRagexeRE client (e1b9d243) Removed password output from atcommand accinfo (2746e0d3) Made mercenary db dynamic (132feeb6) Added new script command `clear` (ead017b3) Fixed compatibility with some newer MySQL client library derivatives (dfe279fb) Corrected renewal ASPD off-hand calculation (267fd3e6, b7d38283, 6411a1d4) Set max Zeny to 2,147,483,647 (eaf44078) Fixed item creation with full inventory (3c41d4ee) Changing DBMap into STL::Map in C++ for guild storage (fe575dda) Cleaned up atcommand accinfo leftovers (d4c1a57f) Fixed display of newly added pet eggs in storage (c16b7b17) Converted pet_data::petDB into a getter function (1e766a7b) Added support for 2018-02-13aRagexeRE client (f6e0a0a3) Added a new packet for the equipment swap system (71886193) Fixed unitwalkto calls in unit walk events (a0a55dad) Resolved renewal ASPD and two-handed weapons (31e2871d) DATABASE: Corrected True Seyren Windsor Card bonus (24a9e4c6) Corrected the party member ATK bonus of RK_FIGHTINGSPIRIT (82035609) Added new mob placeholders (eea76c8e) Corrected chance to craft 2 runes starts at Rune Mastery Lv5, not 6 (8258df64) Corrected Heat Barrel bonuses (75a8f520) More items correction (In general Equips) and added new item 1835 (41dbb30f) Fixed some autobonus scripts in item_db (cacf450d) Fixed AL_HOLYWATER behavior (2ecb30ab) Updated Cultivation plant spawn formula (a40b1da4) Updated Masquerade - Weakness behavior (d2c5ca99) Fixed Mystical Amplification and Chain Lightning (02983c4f) Corrected missing ATK / MATK bonus from Old Wind Whisper (77f75c05) Corrected the amount of slots of Spartacus (4fef4d04) Updated guild skill Guard Up (6e5de84a) Updated Tiger Fist stop duration (0e23f3fe) Removed unnecessary RC_PLAYER item bonuses (d3ea313b) Added items of Reactors from Charleston Instance (7bb35d28) Fixed STR/INT/VIT Biscuit Sticks item script (97c1e8b9) Cart Termination should be affected by % effects (5998cca3) Fixed Endow skills to match official behavior (1e2032cc) Corrected Disarm and Steal Coin formulas (5e354494) Updated Mob and NPC Identity (e9919620) Corrected Power Swing weapon requirement (fdb7aefd) Fixed Skin Tempering (BS_SKINTEMPER) fire resistance percentage (a40b69f3) Fixed Sheltering Bliss (CG_MOONLIT) max level (b989844f) SCRIPT: Cleaned up kafra functions (139f6f25) Workaround to solve issue with news cards in enchants NPCs (3bcb37bf) Updated card seller NPC (afab80fb) Initial release of Dimensional Travel Quest (6e0187bc) OTHERS: Updated CI tool configurations (2f358d8f) Fixed charban example in atcommands.txt (e43f03ad) Fixed athena-start newlines not set to unix type (7f9f185c) Added map_msg_mal.conf (38a00aa5) Statistics Excluding merges, 13 authors have pushed 66 commits to master and 87 commits to all branches. On master, 79 files have changed. There have been 2,825 additions and 764 deletions. There are 42 merged Pull Requests and 7 Proposed Pull Requests. There are 13 new Issues and 40 Closed Issues. List of Contributors @4144, @admkakaroto, @aleos89, @Artuvazro, @Atemo, @ArcherDs, @Badarosk0, @BrOgBr, @cydh, @Daegaladh, @ecdarreola, @Everade, @flamefury, @hendra814, @laziem, @Lemongrass3110, @inhyositsu, @mrjnumber1, @RadianFord, @raynra, @rye305, @sader1992, @sctnightcore, @secretdataz, @talesofragnarok, @Tokeiburu, @uddevil, @vstumpf Show your support to rAthena by submitting your Issue or Pull Requests! By providing enough useful info (Git Hash, Client Date, RE/Pre-RE, crashdump, how to reproduce, etc) you will help us to solve the issues faster
  24. 2 points
    You will need to setup an OnTimer15000: with that, check if the Event is active, if it hasn't already been guessed, end the event and restart it later OnClock####: etc
  25. 2 points

    Version 1.00.36

    16 downloads

    Overview This is a small and easy-to-use tool for converting Gravity’s Emblem files. It can decode ebm files to bmp and bmp files back to ebm format. This is the first tool of my long planned RO-Tool project. Orginally it was only a test-tool for testing my libebm. But after the work was done I’ve decided to release it as a simple standalone tool. I didn't update this for long time, but it's working fine. Features: Encode bmp files to Gravity’s ebm-format Decode ebm-files to bmp latest Changes: Fixed Bug in For-loops (first file in folder was skipped) now uses libebm 1.01 first release version Project page: http://15peaces.com/blog/index.php/ebm-converter/

    Free

  26. 2 points
    Compartilha ? Valeu !
  27. 2 points

    Version 1.0.0

    50 downloads

    Hello rAthena Community Free Forum's for the first 50 Download. After the 50 download this themes will be updated to Paid and Updated Design's. The Banner is easy to change just in the Public Folder so you can easy attouch your Logo on the Banner Area. and The menu link is easy to edit on you IPS Forum Edit Script. IPB VERSION IPB Version: 3.4.X and Higher. (Recommended Version 3.4.9)

    $2.00

  28. 2 points
    the reason why I do not immediately answer your question because you are asking a high level scripting question I experienced in the past when I misunderstood topic starter, and I posted a very complicated script, they just stop giving any feedback ... makes me feel my effort wasted what you need to learn is Fisher-Yates shuffle Haru and me perfected the script and it is currently inside Hercules here's an example poring_w01,100,100,5 script dfdsfsadfsdf 1_F_MARIA,{ // here we declare some array setarray [email protected], 123,234,345,456,567,678,789; [email protected] = getarraysize( [email protected] ); // just to output the original array [email protected]$ = [email protected][0] +""; for ( [email protected] = 1; [email protected] < [email protected]; [email protected] ) [email protected]$ += ","+ [email protected][[email protected]]; dispbottom "original = "+ [email protected]$; // randomize the array ~ callfunc "F_ShuffleNumbers", 0, [email protected] -1, [email protected]; for ( [email protected] = 0; [email protected] < [email protected]; [email protected] ) [email protected][[email protected]] = [email protected][ [email protected][[email protected]] ]; // output the result ~ [email protected]$ = [email protected][0] +""; for ( [email protected] = 1; [email protected] < [email protected]; [email protected] ) [email protected]$ += ","+ [email protected][[email protected]]; dispbottom "shuffle = "+ [email protected]$; end; } EDIT : PS: if you wanna learn sorting algorithm script I can always show off a little bit
  29. 2 points

    Version 1.0.0

    47 downloads

    This is my first battleground script being release for free. Hope you Enjoy it, You can edit this part: OnInit: // Registration time .RegistrationTime = 5; // Duration of the event [email protected] = 10; Then load it on your server! Enjoy! https://github.com/pajodex/ScriptCollections/blob/master/RagnaEvent.txt Note: I have a 2nd (Original) version of this which features the ff: 1. Added more flexible configurations such as: .RegistrationTime = 5; [email protected]_level = 80; [email protected] = 10; [email protected]_map$ = "prt_are01"; [email protected] = 407; [email protected] = 380; [email protected]_ID = 7773; setarray [email protected], 10, 5; // <WIN>, <LOSE> [email protected]_max = 10; // Max additional reward receive to players who killed many enemies. [email protected] = 10; // delay on resurrection (in seconds) setarray [email protected]_Spawn, 251, 149; setarray [email protected]_Spawn, 47, 149; 2. GM activation via "@startre" 3. Bonus rewards - calculated via enemy kill counts 4. Auto-change Team cloth color (Red) or (Blue) 5. Rune Spawn during match (Like DOTA2) - makes the game more fun and exciting! a. Invisibility Rune b. Haster Rune c. Double Damage Rune d. Illusion Rune e. Regenaration Rune I can also incorporate this to my BG Queue System. For those who are seriously interested with the v2, please do leave me a DM here of in Discord Thank you! By downloading this file, you agree with my Terms of Service: • You are not allowed remove my signature from any of the included files. • You are not allowed sell, resell or in any form for money or rewards using my work. • You are not allowed claim my work as yours. • I have the rights to change all the terms above without prior notice.

    Free

  30. 2 points
  31. 2 points
    data / texture / effect in data.grf (jRO) BG_Icon.zip
  32. 2 points
    same with me time really flies bro >.< Client Recommendation: - you can use anything bro even the latest supported unpacked client. (A great warm up for a comeback haha) Purchasing GePard: - pm Functor to avoid getting scammed Meteor Storm Bug: - Lol dude a hearsay will remain a hearsay unless you tried it. The spirit of rAthena really leaves your head. Philippine Hosting: - that's a f****** suicide dude.
  33. 2 points

    Version 1.0.0

    181 downloads

    A map that has a little bit of everything, I spent about a week making this and was gonna use it for my own private server but the project got abandoned. This map come with some beautiful hang out places, and features like: - Vendor area ( straight lines on the right of the map under the boxing ring a bit) - Boxing Ring - Quest area ( Top left corner ) - Mall area ( the spiral dirt road ) - Cool buildings with walkable tiles - Garden with walkable tree / fower - and many more ! I hope you guys will implement it in your own server. Here is some cool locations on the map: Turtle's back - 170 30 Hangout 1 - 135 60 Hangout 2 - 138 64 Hangout 3 - 149 63 Hangout 4 - 154 65 Second Building - 10 127 Crystal Valley - 19 173

    Free

  34. 2 points
    He is referring for job level not for a job. Change the conditional statement given by @sader1992 change the "class" into "Joblevel" == "Joblevel X"
  35. 2 points
    Hi, you can find achievment commands here. ============================ |15.- Achievement commands.| ============================ Add your custom achieves in db/re/achievement_db.yml or db/pre/achievement_db.yml like: - ID: 220060 Group: "AG_ADVENTURE" Name: "Complete my quest" Score: 10 and this to your script when quest complete. achievementcomplete(220060); *achievementcomplete(<achievement id>{,<char id>}) This function will complete an achievement for the attached player or the supplied <char id>. The objective requirements are ignored when using this function. Returns true on success and false on failure. don`t forget add your custom achievment to client: yourclient\System\achievement_list.lub [220060] = { UI_Type = 0, group = "ADVENTURE", major = 2, minor = 0, title = "Complete my quest", content = { summary = "Text", details = "Text" }, resource = { [1] = { text = "Text" } }, reward = {}, score = 10 }, I think this will work
  36. 2 points
    * There is currently no script command to retrieve the current target of the unit. * <target id> is the GID of the target.
  37. 2 points
  38. 2 points
    Hello all ! Thanks for your support, it means very much to me There's a new release with some important game features like dealing between players. Get it here http://aesir.perfontain.ru/forum/topic/26-builds/ Also i have to notice that info about new releases will no longer be published to this forum, so stay in touch at the project's forum. Thank you all.
  39. 2 points
    Need the latest kRO Install folder for your private server? Look no further! ----> Download <---- Latest: 2018-03-27 Installation: Official kRO Updated: 27/03/2018 Download Link: http://bit.ly/latestkro Package contains RSU RO Patcher Lite for kRO and kRO RE by [Ai4rei] This package is maintained by [Akkarin] This ZIP archive is 2.81GB in size and includes all BGMs plus the latest RSU ([2018-01-21] Release 2.4.18.769) Simply download, extract, play! A fan of this topic? Hit the rep button
  40. 2 points
    UPDATED, NOW HAVE 72 HEADS UPDATED, NOW HAVE 84 HEADS !!!!! Here a Compiliation of basic customs Hairs from Ragnarok Online, This include the 29 oficial heads. All of these heads aren't made be me, with exception of #68, #69, #70 and #71 male heads and female #70 and #71 heads, this pack cames from internet and a bit of search, the authors put the credit on Spr files... But who diferent on that pack? - Repeated Heads Removed; - Missaligned Heads Fixed; (like #48 and #61) - 6 Unique Heads. - Now this pack is mixed with smokim pack (from cronus) - No Female Heads in Male pack, with exception of classic #43 I'm Still Working On this Pack to change female heads into male heads (like #43, #55, #56 etc - Male Hairstyles), to make all heads in Oficial Collors (1~7 to work with them), To Increase this into 100 Hairstyles Pack. Preview: DOWNLOAD: 84 Heads.zip Mirror 4Shared Mirror MediaFire
  41. 2 points

    Version

    3,148 downloads

    Hello Everyone! This is a simple theme created by me very long time ago. It is compatible with FluxCP running on rAthena emulator. How to install? Just replace the files with themes folder of your FluxCP and enjoy! PSD file included to change logo RSS feed on index page to fetch your latest news from forum Easy to edit, just find eAdevconfig.php under themes/default/main/ Lastly, it cost nothing! Download it for free Please leave the credits if you are using the theme. Drop me an email on [email protected] for installation support. Enjoy!

    Free

  42. 2 points

    Version 2.0.0

    9,206 downloads

    Third Job Costumes The Correction With the advent of jRO releasing new Job Costumes, many of server owners wants to replace the vanilla sprites or even, implement the bodystyle system. But, there's a catch! jRO, with the freedom at hand on creating this content, made it completely off of the default pattern of paletting. In a classic example, you can notice the pattern of the RO palettes. What matters is the position of the colors, as an example, for all jobs, the white-ish tones will be always on the same row, so we can use it to create custom palettes. See how it works: But jRO didn't follow the classic pattern, making it incompatible with custom palettes (@KamiShi version included). So, I edited frame by frame of each job sprite, of each gender, mounted or not, correcting them, converting them in a way so any of the previously created palettes will work. This package includes: Alternate Royal Guard M/F + Gryffon Battlemount + Lion Mount Alternate Ranger M/F + Warg Battlemount + Ostrich Mount Alternate Minstrel/Wanderer + Ostrich Mount Alternate ArchBishop M/F + Alpaca Mount Alternate Warlock M/F + Fox Mount Alternate Mechanic M/F + Savage Mount Alternate Genetic M/F + Savage Mount Alternate Guillotine Cross M/F + Hyena Mount Alternate Shadow Chaser M/F + Hyena Mount Alternate Sorcerer M/F + Fox Mount Alternate Sura M/F + Alpaca Mount Alternate Rune Knight M/F + Dragon Battlemount + Lion Mount As requested by @Emistry, I also added an extra, making it more compatible to default palettes: Kagerou/Oboro + Frog Mount Following the another @Emistry's request, all files are now already on GRFs. The previous version had no Cashmount palette included, this one fixes the issue. Only the already released costumes are supported at this moment. The Rune Knight seems to be the last of them, it's over a year from the first release! As a final part of the package, I'm including Classic Palettes for all Alternative Costumes. Enjoy the final product!

    Free

  43. 1 point
    Achso. Ich habe verstanden das er die Daten Live trackt. Heißt wenn ein MVP in 2minuten und 29 Sekunden spawnt wird das genau ausgegeben. wäre doch bestimmt möglich eine API für ein Discord Bot in die rA source zu intergrieren. Das wäre mal interessant. Oder alternativ ein script auf dem webserver der als API schnittstelle zur aussenwelt fungiert. sowas ähnliches wie FluxCP halt aber für discord.
  44. 1 point
    < Alayne's Script Collection > After several asks, here's a link to my github Feel free to comment or add anything that might be usefull and that I won't think of I've decided to release my scripts here, it'll be easier to me so I can duplicate it on hercules and rathena rather than uploading twice. So sorry for multiple upload between there and download section Don't mind the name Nyliar in the git, that's me too ^^ < Instances > < Quests > < Event > < PvP Content > < Utilities > < Full Systems > < Dungeons > < Raid > < Battleground >
  45. 1 point
    If you didnt patch your client to read lua first then your client reads lub; Your accessory ids is located in your GRF; data/luafiles514/lua files/datainfo/
  46. 1 point
    All headgear official bRO iRO idRO jRO twRO Update January 2018 Download January 2018 Iclude list and miss headgear Last Headgear : RibbonMuff_Black = 1716, Love_Feeling = 1717, Enchanted_Dog = 1718, C_Baby_Leopard_Cat = 1719
  47. 1 point
    @Quesooo Thanks for the feedback, which source code do you need ? RoBrowser sources are available here : https://upload.robrowser.com/roBrowser.zip , the electron framework source code is generated by the command line : electron-forge init sakexe and the sources I did modify are listed in "Code brackets". Did I miss something ?
  48. 1 point
    What are your base and job exp rates?
  49. 1 point
    prontera,152,187,3 script npcname 444,{ if(!#freeItems){ if(class == 4010){ //high wizrd getitem 1002,1; } //add more classes here #freeItems == true; }else{ mes "you already got free items :P"; } close; } also if you want to make it when the player change his job make #freeItems to int and make the script as function than call it in every job changer you have in the server
  50. 1 point
    File Name: RandomOptionDealer File Submitter: keitenai File Submitted: 1 Dec 2016 File Category: Utilities Content Author: keitenai Random item option Dealer NPC Script Information: This NPC script will be dealing 'random option enchantment' to players for a price of Zeny/Cashpoint Features: Configurable NPC dealing currency to 'Zeny' or 'Cashpoints'. Configurable dealing price. Configurable to allow overwriting the already existing option enchantment or not. Configurable fail chance rate. Configurable Minimum & Maximum option enchant effect Values. Configurable Maximum item Option slots. Version 1.1 Implemented optional Item requirement. WARNING: This random enchantment NPC have a chance of failing, and breaking the player's Chosen equipment along with its compounded cards. You can set the Fail chance rate from 0% to 100% NPC will warn the player about the Fail chance rate (%). The NPC will ask the player if he wants to take the risk and proceed with the random enchantment. Upon selecting the option to proceed, the player's item will get a "Random" option enchantment. Compatible with: rAthena ac2ba09 Download V1.1: RandomOptionDealer V1.1.txt Download V1: RandomOptionDealer.txt Hope you find this useful