Digos

Do you mean named items with slot? As far as I know, is not possible

This one works also with non-equipment items and for equipment type theres an option to set the element and the number of star crumbs. set .@item_id, 501; set .@item_info, getiteminfo(.@item_id, 2); set .@charid,getcharid(0); set .@card3, .@charid & 65535; set .@card4, .@charid >> 16; // If you're inscribing equipment, .@card1 must be 255. if ( .@item_info == 4 || .@item_info == 5 || .@item_info == 7 || .@item_info == 8 ) { set .@card1,255; // That's the number of star crumbs in a weapon. set .@sc,0; // That's the number of elemental property of the weapon. 1 - Ice, 2 - Earth 3 - Fire 4 - Wind. set .@ele,0; set .@card2,.@ele+((.@sc*5)<<8); } // If you're inscribing non-equipment, .@card1 must be 254. else { set .@card1,254; set .@card2,0; } //*getitem2 <item id>,<amount>,<identify>,<refine>,<attribute>,<card1>,<card2>,<card3>,<card4>{,<account ID>}; getitem2 .@item_id,1,1,10,0,.@card1,.@card2,.@card3,.@card4;

Try BaseClass == Job_Bard instead of Class == Job_Minstrel. If you want add to dancer, use BaseClass == Job_Bard || BaseClass == Job_Dancer

More info http://community.invisionpower.com/resources/documentation/index.html/_/documentation/administrator-control-panel/system-tab/tools-settings-log-in-management-r244

Change this block to: // SQL query $limit = ( isset($_GET['limit']) ? intval ($_GET['limit']) : 0 ); $strSQL = "SELECT * FROM itemizer ORDER BY id DESC LIMIT ".$limit.", 100"; So, you will limit the result to 100 entries and can paginate in the browser (query string) by adding limit=(number)Eg: http://localhost/itemizer.php?limit=10 will display 100 results after the 10 first.

Use else if instead of only if: 4002,Fabre_Card,Fabre Card,6,20,,10,,,,,,,,789,,,,,{ if (getequipisequiped(EQI_ARMOR)) { bonus bVit,5; } else if (getequipisequiped(EQI_GARMENT)) { bonus bAgi,5; } },{},{} Why you don't create two cards, one for each equipment slot? Eg: Headgear, Armor, Garment...

I think that you can do this with unittalk: But you'll need to get the monster GID. I don't know if this feature are currently coded in the src. If not, try add as described in: http://rathena.org/wiki/Get_monster_gid and recompile your src. So, after you've add that snippet into the src, is easy to control the monster: Pseudocode: set .@MobID, monster("map", x, y, name, class, 1); unittalk .@MobID, "I'm a monster :)";

I think that there's an option in conf/login_athena.conf // Required account group id to connect to server. // -1: disabled // 0 or more: group id group_id_to_connect: -1 // Minimum account group id required to connect to server. // Will not function if group_id_to_connect config is enabled. // -1: disabled // 0 or more: group id min_group_id_to_connect: -1

This one should do the trick: $data="10000#Lorem ipsum dolor sit amet, ^AAaAaAconsectetur adipisicing elit, sed do^000000 eiusmod tempor incididunt ut labore.# 10001#Lorem ipsum dolor sit amet, ^AAbbCCconsectetur ^000000adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10002#Lorem ipsum dolor sit amet, consectetur ^0000FFBadipisicing ^000000 elit, sed do eiusmod tempor incididunt ut labore.# 10003#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10004#Lorem ipsum dolor sit amet, consectetur adipisicing elit, ^FF0000sed do eiusmod tempor incididunt ut labore.^000000# 10005#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor ^4323BCi^000000ncididunt ut labore.#"; function preg_callback($match = array()) { // inner text $string = $match[2]; // get the hex color preg_match("/\^([a-fA-F0-9]){6}/", $match[0], $matches); // remove the first ^ $color = ltrim($matches[0],"^"); // html format return "<span style=\"color: #".$color.";\">".$string."</span>"; } $data = preg_replace_callback("/\^([a-fA-F0-9]){6}(.*?)\^([a-fA-F0-9]){6}/s",'preg_callback', $data); echo "<pre>".print_r($data,1)."</pre>"; Output: 10000#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10001#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10002#Lorem ipsum dolor sit amet, consectetur Badipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10003#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10004#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.# 10005#Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.#

Can I go back to the login screen from the character selection screen with this hexed? It's stable enough to use as a server's main hexed?

With your server OFF, you can do this in 3 steps: 1: Run the query below and you will get the insert syntax for all the cards equipped. select concat(concat(concat('INSERT INTO `inventory` (`char_id`,`nameid`,`identify`,`amount`) VALUES (', cid),',',card),',1,1);') from ( select `char_id` cid,`card0` card from `inventory` where `card0` between 4000 and 4999 union all select `char_id` cid,`card1` card from `inventory` where `card1` between 4000 and 4999 union all select `char_id` cid,`card2` card from `inventory` where `card2` between 4000 and 4999 union all select `char_id` cid,`card3` card from `inventory` where `card3` between 4000 and 4999 ) cards; 2: The query above will produce a big result like: RUN ALL results returned by the query above as a new query to insert the cards to the respective owners. 3: Update all items and set card to 0 with the query below. update `inventory` set `card0` = 0 where `card0` between 4000 and 4999; update `inventory` set `card1` = 0 where `card1` between 4000 and 4999; update `inventory` set `card2` = 0 where `card2` between 4000 and 4999; update `inventory` set `card3` = 0 where `card3` between 4000 and 4999; WARNING: Maybe some character will get more than 100 item in their inventory. This is a problem because the items that exceed this limit will not be displayed. To show that characters, use the query below: select `char_id` from `inventory` group by `char_id` having count(`char_id`) > 100; NOTE: Always make backup before doing that kind of operation.

Use the query below to delete all members (except the leader) from guilds that have more than 70 members (you can change this number in the query). CHANGE THE 70 BELOW TO THE NEW MAX GUILD MEMBER!!! DELETE `guild_member` FROM `guild_member` LEFT JOIN `guild` ON `guild_member`.`char_id` = `guild`.`char_id` WHERE `guild`.`char_id` IS NULL AND `guild_member`.`guild_id` IN ( SELECT `guild_id` FROM ( SELECT COUNT(*) members, `guild_id` FROM `guild_member` GROUP BY `guild_id` HAVING members > 70 ) gids ); And this is to update the characters that are not in a guild.UPDATE `char` SET `guild_id` = 0 WHERE `char_id` NOT IN ( SELECT `char_id` FROM `guild_member` );

Maybe the user doesn't have privilege to be logged in from your IP. If you want allow all IPs to login, create the user as: The % above tells that all IP addresses can login If you want connections only from 192.168.0.1 or localhost put there. See Step 5 in http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html for more details.

You can adjust it in the langtype. For me langtype 18 does the trick.

I guess that you can install it on your pc and connect remotely to your db.

Recently i was facing an issue with newer clients that doesn't allow space in guild names. With ollydbg, I figure out how to allow space and I'm sharing: Open your hexed with a hex editor and search for this hex: Replace for: The 20 hex above is the space string (" ") , I changed it to "!" and If you want change to another just put the hex code in that position. Note: Tested in 2012-05-25-RagexeRE.

You have these alternatives: 1 - Use mysql client in the terminal 2 - Install PhpMyAdmin and use it from web 3 - Use some mysql gui client like SQLyog (the Community Edition is free http://code.google.com/p/sqlyog/) 1) In the CentOS terminal login the mysql mysql -u<username> -p<password> show databases; use <database name listed above>; update `login` set `userid` = 'newuseridhere', `user_pass` = 'newuserpasshere' where `userid` = 's1'; 2) PhpMyAdmin is a web tool to administrate mysql databases. See how to install and use here http://www.cyberciti.biz/faq/centos-fedora-redhat-linux-installing-phpmyadmin-webtool/ this is the most easily option. 3) You can use this option to connect directly to the mysql server running on your server. I use this one to connect to my mysql databases with a ssh tunnel. Some tips: When creating mysql users always define the host allowed to login. (Step 5 in this guide http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html) To allow login from all hosts use % instead of the ip address or hostname. Configure your linux to use ssh keys instead of text passwords (disable the last one) to login as root.

Visual access like VNC isn't needed. You'll use just a SSH client (Putty) and maybe a SFTP client. I use CentOS for about 6 years to host ragnarok servers and it always works fine. So I reccomend CentOS 6.x 64bit and follow this guide http://rathena.org/wiki/Installation_(CentOS) to setup your ragnarok server.

Can you explain how you solved this? I have a similar topic http://rathena.org/board/topic/79520-attacker-idle-sprite/ but I want to disable the animations to physical and magical attacks.

Any help? The idle sprite that I mean is the animation that shows the weapons.

To translate this kind of file follow these steps: 1- Recode Visit http://kanjidict.stc.cx/recode.php and paste the text. Select the encoding options as in the image bellow. (CP949 TO UTF-8) 2- Result Copy the result 3- Paste it in google translate and translate it from Korean to English http://translate.google.com/?hl=en#ko/en/

This one should work properly. prontera,150,150,5 script Sex Changer 99,{ mes "Would you like to change your Sex ( Female or Male )?"; mes "The Operation would cost 10 Gold Coin."; next; if ( select("Yes:No") == 2 ) close; if ( countitem(671) < 10 ) { mes "You need more Coins."; close; } delitem 671,10; mes "Great..."; mes "You will be disconnected."; close2; changesex; end; }

I don't know exactly. @mail can be used to exploit bad coded scripts. Details http://eathena.ws/forum/tracker/issue-5098-mail-potential-exploit/

I would like suggest to always put delitem before of getitem. So, the script execution will stop if player don't have the item. This will prevent exploits like sending mail with the item attached.

Change the langtype in clientinfo.xml. Details: http://rathena.org/wiki/Clientinfo.xml