[Minimum specs for a server?]

Thanks for answering everyone, much appreciated.

[Minimum specs for a server?]

Does anyone know what specs a desktop/laptop must have to support 10-50 players in a server without lag?

[What's a good bachelors program out there?]

Hey everyone,

 

Having just entered university, I'd like to know what you guys think are some of the most beneficial bachelor programs out there (that can get you can job that pays well). I'm having trouble deciding, lol. I'm doing engineering right now and was thinking about electrical engineering with a business minor or something, but I haven't' chosen a specific program yet. Any suggestions?

[Adding Custom Items to Client Side]

It doesn't seem to be working. Probably because there aren't closed brackets at the end of the items, and also the equip_jobs column seems to be written differently than in item_db.txt provided by the server side. Any other suggestions as to how I could tackle this?

[Duplicating items in My SQL]

Oh, I wanted to rename the rows in a column.

 

Say we had the column `id`:

 

id   ->   id

1    ->   1

3    ->   2

5    ->   3

2    ->   4

7    ->   5

 

I just used...

 

SET @cnt = 25000;
UPDATE `ragnarok`.`item_db2`
SET `id` = @cnt := (@cnt + 1)
WHERE `id`= 4;

 

 

and thanks!

[Adding Custom Items to Client Side]

So I've updated my item_db2 in MySQL with over 2000 customs items, and I'm wondering if there's a way to update the files on the client side without doing it all manually (typing it out). I found a tool in the downloads section that updates client side files based on item_db.txt, but the problem is that when I save the SQL table as a txt file, it uses indents rather than commas to separate the fields (I'm assuming it wouldn't work since they aren't commas). Suggestions appreciated, thanks!

[Duplicating items in My SQL]

I was wondering if there's a way to duplicate all weapons and armor in MySQL (workbench) (I can't seem to copy columns and rows together). I know there are commands, but I'm not familiar with them. Maybe someone could type the command out for me or give me a list to get me started.

 

I'm looking for something that.. copies all columns where item type = 4 or 5 in item_db to item_db2

and another that.. renames rows 1st#-nth# to mth#-sth# (n,m,s are just arbitrary numbers; n<m<s  and  sth# - mth# = nth# - 1st#)

 

Thanks

[Item that only works on specific maps.]

Is there a way to enable items ONLY on specific maps (eg: Yggdrasil Berry only usable in Prontera)? In other words, is there a way to do this other than disabling the item on all other maps? Because it doesn't seem very efficient; I would have to type out hundreds of maps.

[New mounts?]

I doubt it, they would have to have the sprites for attacking.

[Card drop rate won't increase?]

I changed the drop rate for normal and boss monsters, but it doesn't seem to work properly. 

 

 

// The rate at which cards are dropped

item_rate_card: 3333

item_rate_card_boss: 3333

item_drop_card_min: 1

item_drop_card_max: 10000

 

 

The card drop rate for any monster seems < 33.33% because when I kill 10 porings sometimes I don't even get a card. Anyone know what i'm missing/did wrong?

[Aspd item/skills not working?]

So I just set up the server, and I found that my attack speed is either capped at a certain value for each weapon, or attack speed raising item/skills won't work(I'm pretty sure it's the latter). I'm trying to use the pre-renewal settings. Anyone have an idea on what i didn't do/missing?

 

Edit: Problem Solved

 

I just had to comment out all the '#defines' in renewal.h to fix this. I thought by just commenting out '#define RENEWAL' all the mechanics would change back to pre-renewal but it didn't.