Jump to content

healthydude

Members
  • Content Count

    61
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

0 Neutral

About healthydude

  • Rank
    Santa Poring

Profile Information

  • Gender
    Male
  • Location
    South East Asia

Recent Profile Visitors

1,189 profile views
  1. Thank you so much sir! You are a friggin life saver! I already solved it but thanks for giving me another avenue for solutions like this!
  2. Great day to everyone here in rAthena forums, I've been trying all day on finding a workaround on how I can edit these two skills: 1. Suffragium 2. Bragi's Poem I want to modify it in a way that they reduce "Fixed Casting Time" instead of "Variable Cast Time". I would appreciate it if anyone can enlighten me on how to modify these skills. Regards, healthydude
  3. OVH 10/10 @MauiBoy It would help if you could provide a detailed explanation as to why you had an untoward experience with Pony.
  4. I removed this entire line of code from the main.sql and I got rid of the error, but I'm not sure what the outcome might be: -- -- Table structure for table `clan` -- CREATE TABLE IF NOT EXISTS `clan` ( `clan_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL DEFAULT '', `master` varchar(24) NOT NULL DEFAULT '', `mapname` varchar(24) NOT NULL DEFAULT '', `max_member` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM auto_increment=5; -- ---------------------------- -- Records of clan -- ---------------------------- INSERT INTO `clan` VALUES ('1', 'Swordman Clan', 'Raffam Oranpere', 'prontera', '500'); INSERT INTO `clan` VALUES ('2', 'Arcwand Clan', 'Devon Aire', 'geffen', '500'); INSERT INTO `clan` VALUES ('3', 'Golden Mace Clan', 'Berman Aire', 'prontera', '500'); INSERT INTO `clan` VALUES ('4', 'Crossbow Clan', 'Shaam Rumi', 'payon', '500'); -- ---------------------------- -- Table structure for `clan_alliance` -- ---------------------------- CREATE TABLE IF NOT EXISTS `clan_alliance` ( `clan_id` int(11) unsigned NOT NULL DEFAULT '0', `opposition` int(11) unsigned NOT NULL DEFAULT '0', `alliance_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT '', PRIMARY KEY (`clan_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; -- ---------------------------- -- Records of clan_alliance -- ---------------------------- INSERT INTO `clan_alliance` VALUES ('1', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '1', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '1', 'Swordman Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '2', 'Arcwand Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('4', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('4', '1', '2', 'Arcwand Clan'); -- -- Table structure for table `elemental` -- CREATE TABLE IF NOT EXISTS `elemental` ( `ele_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `mode` int(11) unsigned NOT NULL default '1', `hp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `max_sp` int(11) unsigned NOT NULL default '0', `atk1` MEDIUMINT(6) unsigned NOT NULL default '0', `atk2` MEDIUMINT(6) unsigned NOT NULL default '0', `matk` MEDIUMINT(6) unsigned NOT NULL default '0', `aspd` smallint(4) unsigned NOT NULL default '0', `def` smallint(4) unsigned NOT NULL default '0', `mdef` smallint(4) unsigned NOT NULL default '0', `flee` smallint(4) unsigned NOT NULL default '0', `hit` smallint(4) unsigned NOT NULL default '0', `life_time` int(11) NOT NULL default '0', PRIMARY KEY (`ele_id`) ) ENGINE=MyISAM;
  5. Hey first of all thanks for taking the time to even view this issue. So I've been following this guide: https://github.com/rathena/rathena/wiki/SQL_Installation and I'm stuck in this part: Well, the problem is, when I click the thunderbolt icon, it shows this error: Error says: 12:32:11 `clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NULL DEFAULT '', `master` varchar(24) NOT NULL DEFAULT '', `mapname` varchar(24) NOT NULL DEFAULT '', `max_member` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NUL' at line 1 0.000 sec My problem is this error, it doesn't create the necessary tables for the 'ragnarok' database. Here are the only tables that shows up: Attached is the copy of my downloaded main.sql from rAthena git: Download Here: main.sql I want to be honest here, I got really amateur experience when it comes to creating SQL databases and I would find it really helpful if someone get guide me towards the right direction here. Looking forward for any help! Regards, healthydude
  6. Thanks man you are so kind. I like the fact that you bothered to help me even if I'm a complete newbie. Why dont you go find a hosting company that do ragnarok online host? they will do everything for you and assist, i believe. Thanks for that suggestion Elsa Mist, I highly appreciate it. I'm familiar with hosting games (I've hosted an Unturned MMOFPS server 3 months ago ) and based on my experience, I can get better hosting if I go directly with the unbrokered hosting providers. Most of the hosting providers that I see being advertised with Ragnarok servers are brokered, meaning they are retailing an already retailed hosting provider. I'm trying to find a good VPS at the moment. It turns out there are VPS that can go for less than $200 per month and will still be able to run a decent server.
  7. Thanks man you are so kind. I like the fact that you bothered to help me even if I'm a complete newbie.
  8. Great day to all of you in this forum. I'm an old player of RO (since 2009) and I've been planning to make a server ever since. Now I have the money to actually build one, I was hoping if anyone can lend a helping hand for a guy like me who doesn't know much about coding and starting a private server. I know this is often asked in this forum and most of the time people like me will be told to "read the guides etc..." But I'm pretty sure someone out there is kind enough to mention here a detailed guide on how to make a Ragnarok Private Server. I can handle the rest. If you are kind enough to help me I would appreciate it if you can message me here and I would be more than happy to include you in my server's staff. And also, am I allowed to mention my Skype here just in case? My skype is: julius.mesina (add me up) Kind Regards, Healthy Dude
  9. In my server, when I use level 40 highness heal, it shows "32727" but it heals "92000" how am I gonna be able to change this? Thanks
  10. 2 GB RAM + 2GB BURST RAM 3,000 GB Bandwidth [ Q ] How many players can my VPS handle?
  11. I'm here again asking for the knowledge of our beloved awesome script pros. My question: Is it possible to make a map show ping mini-map using script? Is its possible please share it to me xD here's the example of the mini map ping I'm talking about (it's like part of a quest that guides players where to go)
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.