Custom Item DB error please HELP!

[Custom Item DB error please HELP!]

On 6/10/2022 at 6:52 PM, amii said:

can anyone help me how to fix this? 
 

: DB error - Unknown column 'grade' in 'field list' [Debug]: at D:\ro_offline_2021\01_emulator\hercules_pre\src\map\log.c:191 - INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `grade`, `card0`, `card1`, `card2`, `card3`, `opt_idx0`, `opt_val0`, `opt_idx1`, `opt_val1`, `opt_idx2`, `opt_val2`, `opt_idx3`, `opt_val3`, `opt_idx4`, `opt_val4`, `map`, `unique_id`) VALUES (NOW(), '150000', 'A', '36001', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'prontera', '644245094400010') when ever i tried to add custom items it always unknown/Apple 

: DB error - Unknown column 'grade' in 'field list'

	[Debug]: at D:\ro_offline_2021\01_emulator\hercules_pre\src\map\log.c:191 - INSERT DELAYED INTO `picklog` (`time`, `char_id`, `type`, `nameid`, `amount`, `refine`, `grade`, `card0`, `card1`, `card2`, `card3`, `opt_idx0`, `opt_val0`, `opt_idx1`, `opt_val1`, `opt_idx2`, `opt_val2`, `opt_idx3`, `opt_val3`, `opt_idx4`, `opt_val4`, `map`, `unique_id`) VALUES (NOW(), '150000', 'A', '36001', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'prontera', '644245094400010')

	

	when ever i tried to add custom items it always unknown/Apple 

i tried reading the guide on many sites but i still have the same issue 

Hi this guide will help you, its too long to explain thru comment here..

Here guide video... its easy as 123 ^_^ good luck!!!

[Naghahanap po ako ng makatulong mag install ng server, may VPS.]

baka maka tulong sa inyo eto mga lodi cakes! >>> HERE!

Good luck sa new Server nyo ^_^

[Error in Char-server after GIT Update 07/08/2020]

Sir @4144 do you know what is the alternative on adding drop rate increase in equip item?

[How to phpmyadmin with existing mariadb?]

4 hours ago, Vejova said:

Hello again everyone,

 

So now that I have a working server, client, and Browedit (yay), I'm trying to install phpmyadmin and then fluxcp. My problem is that all of the mpa installation guides I've found assume that I want to create a new db during install, and they say nothing about linking or using my existing server db. 

 

How do I go about installing phpmyadmin while linking it to my existing RO database?

 

Are there any steps that I need to change/modify during install, like the server directory that I install it to (e.g., /Hercules instead of ~) ?

 

NB:  i'm using VPS/Debian to install and not windows. I went through the fresh install once just to see how it works, and I did manage to connect to my VPS fine. But I couldn't figure out how to import what I wanted.

 

Thanks!

try my Guide maybe you can figure it out.. 

 

 

[PuTTY network error when entering server ip and port]

make a virtual VPS so you can use that putty... Use Virtual Box install Centos 7 or Debian 10...

 

[run-server.bat problem occured: map-server.exe,char-server.exe.inter-server.exe was not found]

 

If you are using windows. it is better to use Virtual Box... ^_^

 

[@autoattack]

5 hours ago, unrestricted said:

How exactly did you do it bro? it doesn't work on my end -_-

do you have any error or just you cant compile?

 

 

[@autoattack]

it work  but we hope they will update like goddameit make like this with teleport. its better to use plugins than patch ^_^ ROK! on this Project... LODI!!!

[[AtCommand] autoatk]

autoattack.c: In function ‘autoattack_motion’:
autoattack.c:55:7: error: ‘struct unit_interface’ has no member named ‘walktoxy’
   unit->walktoxy(&sd->bl,sd->bl.x+(rand()%2==0?-1:1)*(rand()%10),sd->bl.y+(rand()%2==0?-1:1)*(rand()%10),0);

this is the error

 

[@autoattack specific map]

No new update for this? i download it i got error 

autoattack.c: In function ‘autoattack_motion’:
autoattack.c:65:7: error: ‘struct unit_interface’ has no member named ‘walktoxy’
   unit->walktoxy(&sd->bl, sd->bl.x+(rand()%2==0?-1:1)*(rand()%10), sd->bl.y+(rand()%2==0?-1:1)*(rand()%10),0);

 

[Drop Rate Increase using Item Script]

On 5/23/2020 at 9:06 AM, Azhura said:

Is there a item script that can increase drop rate from all monster like bubblegum to a certain percentage?

 

Thanks for the help

unfortunately they remove this system >.< 

[HUmihingi ng Tulong]

On 7/2/2020 at 5:22 AM, skyflakes17 said:

baka meron pong pwedeng magturo paano gumawa ng sariling server natapos ko na ung Ragnarok Offline Newbie Pack 2020 ano po ba ang sunod kung gagawin

 

 

maraming salamat po!

Next step if you want to have a server na Online na, kuha ka na VPS+Webhost Unmanage (PRO) or Premade RO server (Newbies)... ^_^

[Connection accepted then refused]

packet version set in server didn't match to your client EXE packet version...

[Help setting up pre-re client in 2020]

9 hours ago, Vejova said:

Hey, so I've tried 4+ different guides for how to set up a client, and none of them are working for me. I don't know enough about how all of this is supposed to work to know what I'm doing wrong, so I've got... a few questions...

 

1) What is the most up-to-date client creation/setup guide?

I've tried: One, Two, Three, Four, Five, Six, repeatedly over the last few days, and none of them have worked. Most of them fail at the GRF/clientinfo.xml stage. Like this.

 

2) I want to set up a pre-renewal server, as up-to-date as possible. What versions of kRO and RAGEXE work best, and what really matters? Can I use the newest KRO or do I need to hunt down one from a specific time period like 2017?

 

3) At this point, what all do I even need?

- KRO full - which one?

- RAGEXE - which one?

- NEMO - current?

- GRF EDITOR

- the translation project? Both, or just Pre-re?

- opensetup?

- an updated rsu-kro-rag-lite?

- template for clientinfo.xml?

- my sanity back?

 

Thanks in advance. If someone can actually help me get this working I will rewrite it into an updated guide that noobs like me can understand 😜

I use all latest 

exe for Pre-RE 2015-05-13aRagexe here is my project and some download links are here too I HOPE this help you A LOT (click Here) if not well its up to you dude ^_^

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

4 hours ago, kaiyongkai said:

Yeh, just freezes then dc.. I already matched the mmo.h to my ragexe.. I even used 1 from your tutorial `2018-06-20eRagexeRE` : `#define PACKETVER 20180620`.. And `#define ENABLE_PACKETVER_RE` un-commented.. 

~ What OS did you use to run your server?

~ Did you recompile after modified the mmo.h?

 

* If you are using Centos 7 - Disable the SELinux.

* If you use to run in windows - check your firewall or AV.

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

1 hour ago, kaiyongkai said:

@Chatterboy ok if I patch the "patched" client provided in this post, The "Custom Window Title" gives error "Failed at step 1".. any idea why is this?.  

I tried patching a fresh one my own (using this: http://nemo.herc.ws/downloads/2018-04-18bRagexeRE/, assuming its the exact same as one provided here). But it can't go through after server selection (after Smooth ServerName, right before character selection). Don't know what really the problem is. 

it gives you an error or its just freeze then disconnect? if that so you didn't change the settings in mmo.h in SRC, change it according to your ragexe

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

22 hours ago, kaiyongkai said:

Hi, can share NEMO patch profile used for PRE-RENEWAL?

no need profile just download it then click the recommended after that select any settings that suit your preferences or setup you want in your server. I did that too.. thats why nothing can download or search those. 

how to make? CLICK HERE GUIDE! I hope it will help you dude.

[HELP! RENT ITEM THAT CHANGES GROUP ID THEN TURNS BACK TO PREVIOUS GROUP ID WHEN EXPIRES]

setgroupid(<new group id>{, <account id>})

[Item move restrictions problem]

On 6/5/2020 at 9:03 AM, natefurytv said:

pa help na try ko na din hanapin ung item_trade.txt pero wla sa hercules emulator

Iba na systema ng Herc Sir.. Far different na sila.. Ano ba ang gamit mo sir Herc o rA? 

 

Kng Herc ang RO emulator mo naka attach na sa ITEM script yon.

[Updated Client]

client is always update if you do patching your KRO.. And on the server side if you cant see it there you can add..

[[Guide] Mapcache Generation 2018]

Finally annie ruru Rok! guide helps a lot

[New guide for adding custom map]

On 5/24/2018 at 1:09 AM, luizragna said:

 

@iubantot Follow this tutorial to create your mapcache: http://herc.ws/wiki/Building_HPM_Plugin_for_MSVC

Where he talk YourPlugin rename to mapcache

Centos 7 how? but i did in in windows mode. Thanks anyway and to annieruru guide ^_^ ROK!!

[About Thor Patcher self update]

that version of the patcher is a bug. I use much older than that and its working 100%

Your configuration is correct. Version 2.5.4.18

[Ragnarok Offline Newbie Pack 2022 | Make your RO server in less then 5 minutes]

5 hours ago, fuka said:

Right. I want the original korean version with nothing translated into Eng. Especially npc script

I thought it simply by not applying an Eng translation patch in the process, but it doesn't work..

In UI you can extract it from KRO but the script all here is translated in English because for the general benefits of RO enthusiasts want to make their own server. On your part you can translate all message of NPC's but not the codes because no other language understand the program except English codes, like here in Saudi Arabia you can see Arabic font but in the core program English ^_^

Your choice is if you want pure Korean NPC messages to get a person with you to translate all of it one by one.

[[Guide] Create your server & Client (2016/08)]

On 4/24/2020 at 4:24 AM, codes said:

Hi everyone! i am a newbie and got no idea about programming, kinda wanna learn how to make this. First question is, are you required to subscribe to those server things that he posted? if yes, why? anyone willing to help and guide a complete idiot?

If you don't understand completely how to run. Here watch and learn visually here and how, its a bit different but much easy to understand while watching it running from scratch to finish