Stupeflix

January 29, 2016

//= Be sure to disable the default agit controllers!//== npc\guild\agit_controller.txt//== npc\guild2\agit_start_se.txt//============================================================

SOLVE!! I forgot to disable this and works like a charm.

January 23, 2016

Hi guys I already search answers for this question but still I can't resolve my problem..

I have my pre-renewal server and I'm using Euphys woe controller

But my problem is everytime I set a schedule. It is not starting on the time sched.

How to resolve this?

Im using this script. Euphys Woe Controller

Hope someone will help me

January 16, 2016

For semi-latest kRO:

https://rathena.org/...pdate-10212015/

For latest data folder lubs:

https://github.com/R...ide/Translation

Sir is this compatible with 2013-08-07 client?

January 16, 2016

Can someone lend me some link for the latest DATA FOLDER for this server files

Btw, I'm using 2013-08-07 packet.

Please someone help me. because I'm having problems with the Official Headgears of the server,always have error SPRITE. But my Custom items is fine and works perfectly.

This the error i got. when i use elven ears i got this error

This is the link where i downloaded my server files.

https://github.com/rathena/rathena

January 13, 2016

ACT file of that headgear is missing.

Sir emistry where I can find the data folder for this? I'm using 08-07-2013 client. And this item is not a Custom Item.

I used this

Fluffle Puff's post

January 13, 2016

Just wondering why I encounter this error?

What did I miss here?

Hope someone will help me. Thanks!

November 3, 2015

;

BTW. Still my problem is #2 Guild name not showing, even if i use /showname

Another problem appear. I just recent add custom weapon, but after i build my grf file, that error appears. Even if I use my old GRF still it shows. Every time I use ALT+Q to view my equip that error will appear.

Just wondering. How to fix this ?

Bump !

Already fix the problem, the problem is in the Iteminfo.lub/lua that's why i make a new iteminfo to fix the error.

Also, Problem #2 I already fixed it. I just changed my LANGTYPE on my clientinfo.xml which value is 1 to 0

November 1, 2015

BTW. Still my problem is #2 Guild name not showing, even if i use /showname

Another problem appear. I just recent add custom weapon, but after i build my grf file, that error appears. Even if I use my old GRF still it shows. Every time I use ALT+Q to view my equip that error will appear.

Just wondering. How to fix this ?

Bump !

October 26, 2015

Check mo ng maigi yung configuration mo.

October 24, 2015

Rain408 and H4Mm3r, I have sent private message with information about Gepard Shield.

can you send me also sir functor for details about gepard shield

October 20, 2015

First of all, get your data files here: here.

Question #1:

Update your data, you're using wrong msgstringtable.txt.

Question #2:

If you used /showname and it doesn't change, you need to reDiff your Client properly, also enabling /showname.

Question #3:

About the pink circle, it's because the item was the newest added to your inventory.

About your Sprite Error:

Man, look at your own screens, your file names, you did put them on wrong folder...

Look:

¿© folder and ³² files!

1 QA: You didn't have the right msgstringtable.txt for your client (answered above)

2 QA: You didn't correctly patch the client that you are using, what client patcher did you use, try nemo patcher if you didn't use it get the latest one from github.

Additional QA: it's the mark that item is the newest or latest come to inventory something like that

its just my hunch, i think you need to rebuild your client files...

if you are using the latest kro, you didn't need the data v4.0 (CMIIW...) but you will lost some files (npc, item and other) that come from other official server (jRO, etc...), you can use folder data and system from translation github

lastly the luafiles it seem the cause is case sensivity or you put it on data folder and did you patch your client with read data folder first ?, post your current accessoryid.lua/lub and accname.lua/lub

If the /showname in game don't work try in Ragnarok Setup (with ghost icon or the open setup if you're using it).

Abou the item, I'm testing a place holder with same entry...
25123,Blade_of_Dragon,Blade of Dragon,4,0,0,0,,50,,1,0xFFFFFFFE,36,2,1,0,0,1,1371,{ bonus2 bAddRace,RC_DemiHuman,10; },{},{}
it worked for me using the same job (baby sorcerer)... Remember to reload your item database in game via @reloaditemdb

About your Sprite Error:

Man, look at your own screens, your file names, you did put them on wrong folder...

Look:

¿© folder and ³² files!

Rename the prefix ³² into ¿© and will work

Thank you very much Guys !!! it works already. sorry for late reply about this. But still problem #2 not solved. Stil Guild name and Party Name not showing.

Hi, Regarding to Q2:

change the value to yes in conf\battle\party.conf

// Display party name regardless if player is in a guild.

// Official servers do not display party name unless the user is in a guild. (Note 1)

display_party_name: yes

and use /showname

I hope it works for you

I already change it to YES but nothings happen. But do I need to re-compile if I change anything in CONF folder?

October 18, 2015

One more thing about thr Problem 1:

Your msgstringtable.txt (in data folder or your grf) isn't compatible with your client, some messages will be show wrong.

And this:

25123,Blade_of_Dragon,Blade of Dragon,4,0,0,0,,50,,1,0xFFFFFFFE,8,2,1,0,0,1,1371,{ bonus2 bAddRace,RC_DemiHuman,10; },{},{}
8  = 3rd Classes (excl. Trans-3rd classes and 3rd Baby classes)
Change into 63 and check if works

I already cchange it but still the same.

25123,Blade_of_Dragon,Blade of Dragon,4,0,0,0,,50,,1,0xFFFFFFFE,63,2,1,0,0,1,1371,{ bonus2 bAddRace,RC_DemiHuman,10; },{},{}

Problem #1 still my problem and #2

Here are the screenies on how I setup my custom items

File that I used:

>Latest SVN from GIT

>Client exe 2013-08-07aragexe

>Packet Ver 20130807

>Data folder v4.0 from here

For Problem #2

Still the same. I already type /showname 1 or 2. Nothings happen.

screenies of my data folder

but still I got some error sprites.

and additional question. what is the difference between this items. One item is having a color RED, while other item has no color red. Just wondering.

Thanks in advance. Hope to fix all my problems.

October 18, 2015

Problem #1:

This only occurs with this item? If so, post the Item Script, please.

Problem #2:

Use /showname.

Problem #3:

If your NPC is not casting errors on console, check on .conf files (scripts_custom.conf in example) if it's name is listed correctly to be load when the server starts.

Problem #1

here is the item script from import/item_db.txt

25123,Blade_of_Dragon,Blade of Dragon,4,0,0,0,,50,,1,0xFFFFFFFE,8,2,1,0,0,1,1371,{ bonus2 bAddRace,RC_DemiHuman,10; },{},{}

Problem #2

I will gonna try that.

Problem #3

Regarding this, thanks for the info. All items in Script_custom.conf have // thats why it doesn't appear.

October 17, 2015

Hi I'm just wondering why everytime I click or wear my custom item it always says the image below.

Problem #1

Problem #2

Why is the GUILD NAME doesn't appear in game? only the char name and the position title.

Problem #3

In this case. From where I'm standing. It must have an NPC called the Woe_Controller. But base on the image, the NPC doesn't appear.

woe_controller.txt

prontera,149,193,4   script   WOE Information   835,{
   doevent "WOE_CONTROL::OnMenu";
   end;
OnAgitStart:
   while(agitcheck()) {
       specialeffect EF_BEGINSPELL6;
       sleep 425;
   }
   end;
}

I'm using the latest SVN from GIT and I'm using also 20130807 client and Packet Ver. Also newprontera.grf also attached on my DATA.INI

I hope someone could help me about my problems. Thanks !

October 14, 2015

Yes, and configure it with your IP too.

char_athena.conf

// Login Server IP

// The character server connects to the login server using this IP address.

// NOTE: This is useful when you are running behind a firewall or are on

// a machine with multiple interfaces.

login_ip: 192.168.1.143

// The character server listens on the interface with this IP address.

// NOTE: This allows you to run multiple servers on multiple interfaces

// while using the same ports for each server.

bind_ip: 192.168.1.143

// Login Server Port

login_port: 6900

// Character Server IP

// The IP address which clients will use to connect.

// Set this to what your server's public IP address is.

char_ip: 125.60.156.162

// Character Server Port

char_port: 6121

map_athena.conf

// Character Server IP

// The map server connects to the character server using this IP address.

// NOTE: This is useful when you are running behind a firewall or are on

// a machine with multiple interfaces.

char_ip: 192.168.1.143

// The map server listens on the interface with this IP address.

// NOTE: This allows you to run multiple servers on multiple interfaces

// while using the same ports for each server.

bind_ip: 192.168.1.143

// Character Server Port

char_port: 6121

// Map Server IP

// The IP address which clients will use to connect.

// Set this to what your server's public IP address is.

map_ip: 125.60.156.162

// Map Server Port

map_port: 5121

Still the same sir.

October 14, 2015

First of all, the IPs of your .conf files does not match...
Secondly, uncomment the bind-ip and configure them.
Thirdly, are you trying to run it in a VPS or on your own PC?

If it's on your own PC, an offline server, try to change the IP to the one in ipconfig.

Yes sir, I'm trying with an offline server for testing and modification.

192.168.1.143 was my local IP address.I got it in ipconfig.

so in this case. I will remove // on bind_ip?

October 14, 2015

Hello. Could someone help me. I already searches all the info about this kind of error here in rathena, even in hercules i already went there. But still I can't connect to my server.

My References for this error:

I already did what Asura's answer to Xiaofu's post

Hi xiaofu,

Please go to this site; http://whatismyip.com

Then use this IP to replace all the 'login_ip', 'char_ip', and 'map_ip' values. After this is done; make sure that you have the port correctly forwarded for your home computer. If you have not done this yet, you may go to this following site to find out how to do this for your router; http://portforward.com/

but this what happen when I did that solution.

char_athena.conf

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 125.60.156.162

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 125.60.156.162

// Character Server Port
char_port: 6121

map_athena.conf

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 125.60.156.162

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 125.60.156.162

// Map Server Port
map_port: 5121

Here some screenshots

.

I use 20120410 ragexe from JUDAS

I use data folder Fluffle Puff's Post

Here is my clientxml

<clientinfo>
<servicetype>korea</servicetype>
<servertype>sakray</servertype>
<connection>
<display>InnodreamsRO</display>
<balloon>the balloon</balloon>
<desc>description</desc>
<address>192.168.1.143</address>
<port>6900</port>
<version>45</version>
<langtype>0</langtype>
<registrationweb>flux.domain.com</registrationweb>
<aid>
                    <admin>2000000</admin>
            <admin>2000001</admin>
            <admin>2000002</admin>
            <admin>2000003</admin>
            <admin>2000004</admin>
            <admin>2000005</admin>
            <admin>2000006</admin>
            <admin>2000007</admin>
</aid>
<loading>
<image>loadingscreen01.jpg</image>
            <image>loadingscreen02.jpg</image>
            <image>loadingscreen03.jpg</image>
            <image>loadingscreen04.jpg</image>
            <image>loadingscreen05.jpg</image>
            <image>loadingscreen06.jpg</image>
            <image>loadingscreen07.jpg</image>
            <image>loadingscreen08.jpg</image>
            <image>loadingscreen09.jpg</image>
</loading>
</connection>
</clientinfo>

here is my mmo.h

#ifndef PACKETVER
    #define PACKETVER 20130807
    //#define PACKETVER 20120410
#endif

Here is my packet_db.txt

packet_db_ver: 45
packet_keys_use: default

here is my char_athena.conf

// Login Server IP
// The character server connects to the login server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
login_ip: 192.168.1.143

// The character server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Login Server Port
login_port: 6900

// Character Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
char_ip: 125.60.156.162

// Character Server Port
char_port: 6121

here is my map_athena.conf

// Character Server IP
// The map server connects to the character server using this IP address.
// NOTE: This is useful when you are running behind a firewall or are on
// a machine with multiple interfaces.
char_ip: 125.60.156.162

// The map server listens on the interface with this IP address.
// NOTE: This allows you to run multiple servers on multiple interfaces
// while using the same ports for each server.
//bind_ip: 127.0.0.1

// Character Server Port
char_port: 6121

// Map Server IP
// The IP address which clients will use to connect.
// Set this to what your server's public IP address is.
map_ip: 125.60.156.162

// Map Server Port
map_port: 5121

I already did the portforwading guide, here is the screenshot

and LAST i'm using the latest GIT from rathena

https://github.com/rathena/rathena

But ALL OF IT STILL NOT CONNECTING TO THE SERVER.. I do a lot of searches but i still can't fix my problem.

October 13, 2015

I think removing the quest_function file from "lua files\quest" solved the issue for me in the past.

sir. i already fix that problem. but still i can't connect with my server.

here some screenshots

I use 20120410 ragexe from JUDAS

I use data folder Fluffle Puff's Post

<clientinfo>
<servicetype>korea</servicetype>
<servertype>sakray</servertype>
   <connection>
      <display>InnodreamsRO</display>
      <balloon>the balloon</balloon>
      <desc>description</desc>
      <address>127.0.0.1</address>
      <port>6900</port>
      <version>30</version>
      <langtype>1</langtype>
      <registrationweb>flux.domain.com</registrationweb>
        <aid>
					<admin>2000000</admin>
        			<admin>2000001</admin>
        			<admin>2000002</admin>
        			<admin>2000003</admin>
        			<admin>2000004</admin>
        			<admin>2000005</admin>
        			<admin>2000006</admin>
        			<admin>2000007</admin>
        </aid>
        <loading>
            <image>loadingscreen01.jpg</image>
			<image>loadingscreen02.jpg</image>
			<image>loadingscreen03.jpg</image>
			<image>loadingscreen04.jpg</image>
			<image>loadingscreen05.jpg</image>
			<image>loadingscreen06.jpg</image>
			<image>loadingscreen07.jpg</image>
			<image>loadingscreen08.jpg</image>
			<image>loadingscreen09.jpg</image>
        </loading>
   </connection>
</clientinfo>

here is my clientxml

#ifndef PACKETVER
	//#define PACKETVER 20130618
	#define PACKETVER 20120410
#endif

here is my mmo.h

packet_db_ver: 30
packet_keys_use: default

Here is my packet_db.txt

and LAST i'm using the latest GIT from rathena

https://github.com/rathena/rathena

But ALL OF IT STILL NOT CONNECTING TO THE SERVER.. I do a lot of searches but i still can't fix my problem.

October 12, 2015

~~Hi does anyone know how to fix this error?~~

im using 2012-04-10aRagexe

~~I hope some could help me. Thanks !~~

Addition to this.

I already solve the first issue but there's a next error popping out

Help me please.

October 8, 2015

its working now sir. I just removed this code.

-- ----------------------------
-- Records of db_roulette
-- ----------------------------
-- Info: http://ro.gnjoy.com/news/update/View.asp?seq=157&curpage=1

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 0, 1, 675, 1, 1 ); -- Silver_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 1, 1, 671, 1, 0 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 2, 1, 678, 1, 0 ); -- Poison_Bottle
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 3, 1, 604, 1, 0 ); -- Branch_Of_Dead_Tree
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 4, 1, 522, 1, 0 ); -- Fruit_Of_Mastela
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 5, 1, 671, 1, 0 ); -- Old_Ore_Box
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 6, 1, 12523, 1, 0 ); -- E_Inc_Agi_10_Scroll
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 7, 1, 985, 1, 0 ); -- Elunium
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 8, 1, 984, 1, 0 ); -- Oridecon

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 9, 2, 675, 1, 1 ); -- Silver_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 10, 2, 671, 1, 0 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 11, 2, 603, 1, 0 ); -- Old_Blue_Box
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 12, 2, 608, 1, 0 ); -- Seed_Of_Yggdrasil
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 13, 2, 607, 1, 0 ); -- Yggdrasilberry
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 14, 2, 12522, 1, 0 ); -- E_Blessing_10_Scroll
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 15, 2, 6223, 1, 0 ); -- Carnium
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 16, 2, 6224, 1, 0 ); -- Bradium

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 17, 3, 675, 1, 1 ); -- Silver_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 18, 3, 671, 1, 0 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 19, 3, 12108, 1, 0 ); -- Bundle_Of_Magic_Scroll
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 20, 3, 617, 1, 0 ); -- Old_Violet_Box
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 21, 3, 12514, 1, 0 ); -- E_Abrasive
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 22, 3, 7444, 1, 0 ); -- Treasure_Box
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 23, 3, 969, 1, 0 ); -- Gold

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 24, 4, 675, 1, 1 ); -- Silver_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 25, 4, 671, 1, 0 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 26, 4, 616, 1, 0 ); -- Old_Card_Album
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 27, 4, 12516, 1, 0 ); -- E_Small_Life_Potion
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 28, 4, 22777, 1, 0 ); -- Gift_Buff_Set
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 29, 4, 6231, 1, 0 ); -- Guarantee_Weapon_6Up

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 30, 5, 671, 1, 1 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 31, 5, 12246, 1, 0 ); -- Magic_Card_Album
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 32, 5, 12263, 1, 0 ); -- Comp_Battle_Manual
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 33, 5, 671, 1, 0 ); -- Potion_Box
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 34, 5, 6235, 1, 0 ); -- Guarantee_Armor_6Up

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 35, 6, 671, 1, 1 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 36, 6, 12766, 1, 0 ); -- Reward_Job_BM25
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 37, 6, 6234, 1, 0 ); -- Guarantee_Armor_7Up
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 38, 6, 6233, 1, 0 ); -- Guarantee_Armor_8Up

INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 39, 7, 671, 1, 1 ); -- Gold_Coin
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 40, 7, 6233, 1, 0 ); -- Guarantee_Armor_8Up
INSERT INTO `db_roulette`(`index`, `level`, `item_id`, `amount`, `flag` ) VALUES ( 41, 7, 6233, 1, 0 ); -- Guarantee_Armor_8Up	// KRO lists this twice

Thanks !

October 7, 2015

Hi I will just ask how to fix this? I downloaded the server files here in rathena but I cannot start my server because of TABLE STORAGE does not exist. Is there a problem in "main.sql" ? I hope someone will help me. thanks !

--
-- Table structure for table `storage`
--

CREATE TABLE IF NOT EXISTS `storage` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `account_id` int(11) unsigned NOT NULL default '0',
  `nameid` int(11) unsigned NOT NULL default '0',
  `amount` smallint(11) unsigned NOT NULL default '0',
  `equip` mediumint(8) 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(11) NOT NULL default '0',
  `card1` smallint(11) NOT NULL default '0',
  `card2` smallint(11) NOT NULL default '0',
  `card3` smallint(11) NOT NULL default '0',
  `expire_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`)
) ENGINE=MyISAM;

--
-- Table structure for table `interreg`
--

CREATE TABLE IF NOT EXISTS `interreg` (
  `varname` varchar(11) NOT NULL,
  `value` varchar(20) NOT NULL,
   PRIMARY KEY (`varname`)
) ENGINE=InnoDB;

--
-- Table structure for table `bonus_script`
--

CREATE TABLE IF NOT EXISTS `bonus_script` (
  `char_id` INT(11) UNSIGNED NOT NULL,
  `script` TEXT NOT NULL,
  `tick` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `icon` SMALLINT(3) NOT NULL DEFAULT '-1'
) ENGINE=InnoDB;

--
-- Table structure for table `vending_items`
--

CREATE TABLE IF NOT EXISTS `vending_items` (
  `vending_id` int(10) unsigned NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  `cartinventory_id` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `price` int(10) unsigned NOT NULL
) ENGINE=MyISAM;

--
-- Table structure for table `vendings`
--

CREATE TABLE IF NOT EXISTS `vendings` (
  `id` int(10) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(10) unsigned NOT NULL,
  `sex` enum('F','M') NOT NULL DEFAULT 'M',
  `map` varchar(20) NOT NULL,
  `x` smallint(5) unsigned NOT NULL,
  `y` smallint(5) unsigned NOT NULL,
  `title` varchar(80) NOT NULL,
  `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
  `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
  `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
  `autotrade` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Table structure for table `buyingstore_items`
--

CREATE TABLE IF NOT EXISTS `buyingstore_items` (
  `buyingstore_id` int(10) unsigned NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `price` int(10) unsigned NOT NULL
) ENGINE=MyISAM;

--
-- Table structure for table `buyingstores`
--

CREATE TABLE IF NOT EXISTS `buyingstores` (
  `id` int(10) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(10) unsigned NOT NULL,
  `sex` enum('F','M') NOT NULL DEFAULT 'M',
  `map` varchar(20) NOT NULL,
  `x` smallint(5) unsigned NOT NULL,
  `y` smallint(5) unsigned NOT NULL,
  `title` varchar(80) NOT NULL,
  `limit` int(10) unsigned NOT NULL,
  `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
  `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
  `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
  `autotrade` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Table `market` for market shop persistency
--

CREATE TABLE IF NOT EXISTS `market` (
  `name` varchar(32) NOT NULL DEFAULT '',
  `nameid` SMALLINT(5) UNSIGNED NOT NULL,
  `price` INT(11) UNSIGNED NOT NULL,
  `amount` SMALLINT(5) UNSIGNED NOT NULL,
  `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`name`,`nameid`)
) ENGINE = MyISAM;

is there a bug here? or missing ; ? because when i add this code..

--
-- Table structure for table `interreg`
--

CREATE TABLE IF NOT EXISTS `interreg` (
  `varname` varchar(11) NOT NULL,
  `value` varchar(20) NOT NULL,
   PRIMARY KEY (`varname`)
) ENGINE=InnoDB;

--
-- Table structure for table `bonus_script`
--

CREATE TABLE IF NOT EXISTS `bonus_script` (
  `char_id` INT(11) UNSIGNED NOT NULL,
  `script` TEXT NOT NULL,
  `tick` INT(11) UNSIGNED NOT NULL DEFAULT '0',
  `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  `icon` SMALLINT(3) NOT NULL DEFAULT '-1'
) ENGINE=InnoDB;

--
-- Table structure for table `vending_items`
--

CREATE TABLE IF NOT EXISTS `vending_items` (
  `vending_id` int(10) unsigned NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  `cartinventory_id` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `price` int(10) unsigned NOT NULL
) ENGINE=MyISAM;

--
-- Table structure for table `vendings`
--

CREATE TABLE IF NOT EXISTS `vendings` (
  `id` int(10) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(10) unsigned NOT NULL,
  `sex` enum('F','M') NOT NULL DEFAULT 'M',
  `map` varchar(20) NOT NULL,
  `x` smallint(5) unsigned NOT NULL,
  `y` smallint(5) unsigned NOT NULL,
  `title` varchar(80) NOT NULL,
  `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
  `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
  `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
  `autotrade` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Table structure for table `buyingstore_items`
--

CREATE TABLE IF NOT EXISTS `buyingstore_items` (
  `buyingstore_id` int(10) unsigned NOT NULL,
  `index` smallint(5) unsigned NOT NULL,
  `item_id` int(10) unsigned NOT NULL,
  `amount` smallint(5) unsigned NOT NULL,
  `price` int(10) unsigned NOT NULL
) ENGINE=MyISAM;

--
-- Table structure for table `buyingstores`
--

CREATE TABLE IF NOT EXISTS `buyingstores` (
  `id` int(10) unsigned NOT NULL,
  `account_id` int(11) unsigned NOT NULL,
  `char_id` int(10) unsigned NOT NULL,
  `sex` enum('F','M') NOT NULL DEFAULT 'M',
  `map` varchar(20) NOT NULL,
  `x` smallint(5) unsigned NOT NULL,
  `y` smallint(5) unsigned NOT NULL,
  `title` varchar(80) NOT NULL,
  `limit` int(10) unsigned NOT NULL,
  `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
  `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
  `sit` CHAR( 1 ) NOT NULL DEFAULT '1',
  `autotrade` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Table `market` for market shop persistency
--

CREATE TABLE IF NOT EXISTS `market` (
  `name` varchar(32) NOT NULL DEFAULT '',
  `nameid` SMALLINT(5) UNSIGNED NOT NULL,
  `price` INT(11) UNSIGNED NOT NULL,
  `amount` SMALLINT(5) UNSIGNED NOT NULL,
  `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY  (`name`,`nameid`)
) ENGINE = MyISAM;

TABLE `storage` will not exist. please help thanks !

September 27, 2014

Anyone?

September 26, 2014

Hi can i request complete set of files of sharingan rinnegan and byakugan. I saw that files in SpriteRepository but now. only Rinnegan left. Both sharingan and byakugan lost.

If you havee can you share it to me. Thanks in advance! Cheers!

March 4, 2014

Bigyan mo naman ako sample ng screenshot na sinasabi mong "Walang lumalabas na item sa screen"

Ito sir yung screenshots:

Old SVN ko po to 16797 po ata yung version

tapos po lahat ng items dyan visible pa sa inventory.

Kapag ang nirun ko naman na server yung SVN 17703 eto po yung nangyayari in-game

As in wlang lumalabas na items sa inventory tska pag gumamit ng command na @item compare dun sa isang pic

and may lumalabas na error po dun sa server.

Ito sir yung error

So ang ginawa ko po, inupdate ko yung clientinfo.xml yung version 26 ginwa ko pong version 45. kasi yun po sabi sa server.

then nung ginawa ko na yung GRF with updated clientinfo.xml..

pag nag-lologin po ako ingame.. laging

Failed to Connect Server po.

March 3, 2014

pwede mo ba ko bigyan ng screenshot dito sa tanong mo?

Quote

Ayaw mag @item, kahit hindi custom item hindi visible. As in lahat po ng gamit hindi makita.

Sir gumagana naman po yung @item na command. pero wla pong lumalabas na item sa screen. SVN 17703 po gamit kong server dito. dba po pag gumamit ng @item may lalabas na icon sa upper screen. sken po wla. pero pag gamit ko po na server is yung SVN 16797 po ata un. Dun nakikita ko yung item pag gumamit po ako ng @item command

ngayon naman po nagdownload ako ng bagong Data Files

https://github.com/ROClientSide/Translation eto po yung link. pero hindi ko pa po natatry.

ito po yung laman nung folder

Question: Wala po ba talagang Clientinfo.xml ito?

Ito naman po yung luma kong Data Folder

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by Stupeflix