Script Ranking WOE

[Script Ranking WOE]

Make sure you have the SQL tables in your database

[Can you help me with this script??]

Try removing the lines with bg_monster

[Server doesn't recognize items]

are you running your item_db with sql or .txt? 

 

Make sure that if you are running renewal/pre-renewal that you uploaded the correct item_db from the sql files

[Recommended Server Host?]

Linode

[[script cmd] cartcountitem]

Great plugin, I always used query sql to do it before, nice to see a command now

[How to duplicate map?]

Add it to your resnametable.txt, that is where you can put in the duplicate map. Add the map names to your map_index.txt and maps_athena.txt and then update it with weemapcache and upload it back to your server

[How to also block/check for items in cart?]

 

There's no current script command to retrieve the item list from a character's cart (or storage, or gstorage if ever needed), so you'd have to rethink and hope the player's cart has been saved previously to entering the WoE map and do a SQL query like this:

 

query_sql("SELECT `nameid` FROM `cart_inventory` WHERE `char_id` = " + getcharid(0), .@itemids);

 

You'll get all Item IDs the player has on this cart on the array .@itemids, so you have now to loop through it and check for every blacklisted item on each entry.

 

Great it works, thanks!!

 

Problem though that even when i empty my cart and relog, it still regocnized the item in the cart...

Is there any solution for that?

 

It is stuck in the RO memory itself and has not updated yet, hence sometimes when you close a server abruptly, people get duplicate items, lose their items etc.

[Recommended Server Host?]

Linode VPS does not have VNC but by far the best lag-free and stable host I have ever used to host my servers. 0 Downtime and it only costs $20.

 

I used to use Staminus, godaddy, frantech, jaguar hosting, ubiquity, these are all terrible and always have lag spikes.

[Asura Strike - Removing Delay, Cast, whatever..]

There is also a body relocation delay before you can asura which is source code related

[Increasing Attack beyond 65534]

Max ATK1/ATK2 is 65534 for monsters right now. I believe it is the same for player ATK as well.

 

Anybody know or can point me in the right direction on how to increase this cap?

 

For mobs if you are suggesting me to change the smallint6 for the structure of the field, I have already tried and set it above 65534, but it still caps in game.

 

If anyone can provide some light on this, that would be great, thanks.

[Extended Vending System UPDATED rev14395! by Lilith]

Does not work on SVN 13717

 

here is the stack dump

 

 

Program received signal SIGSEGV, Segmentation fault.0x00000000 in ?? ()(gdb) bt full#0  0x00000000 in ?? ()No symbol table info available.#1  0x081dd4d8 in skill_castend_nodamage_id (src=0x9acd4c8, bl=0x9acd4c8,    skill_id=41, skill_lv=10, tick=1506333589, flag=0) at skill.c:6313        sd = 0x9acd4c8        dstsd = 0x9acd4c8        md = 0x0        dstmd = 0x0        hd = 0x0        mer = 0x0        sstatus = 0x9acd788        tstatus = 0x9acd788        tsc = 0x9acd7d8        tsce = 0x0        element = 162321608        type = SC_NONE        scs = {SC_QUAGMIRE, SC_PROVOKE, SC_ROKISWEIL, SC_GRAVITATION,          SC_NJ_SUITON, SC_NOEQUIPWEAPON, SC_NOEQUIPSHIELD, SC_NOEQUIPARMOR,          SC_NOEQUIPHELM, SC_BLADESTOP}        spellarray = {14, 19, 20}        mask = {{0, -1}, {1, -1}, {1, 0}, {1, 1}, {0, 1}, {-1, 1}, {-1, 0}, {            -1, -1}}        per = {{20, 50}, {50, 60}, {25, 75}, {60, 64}, {34, 67}} 

 

 

The code that is causing the map crash server is here

 

+			{	+				if ( !pc->can_give_items(sd) ) //Prevent vending of GMs with unnecessary Level to trade/drop. [Skotlex]+					clif->skill_fail(sd,MC_VENDING,USESKILL_FAIL_LEVEL,0);+				else { // Extended Vending system [Lilith]+					if(battle_config.extended_vending){+						struct item_data *item;+						char output[1024];+						int c = 0, i, d = 0;+					+						sd->vend_lvl = (int)skill_lv;+						if(battle_config.item_zeny)+							d++;+						if(battle_config.item_cash)+							d++;+						for( c = d, i = 0; i < ARRAYLENGTH(item_vend); i ++ ) {+							if((item = itemdb->exists(item_vend[i].itemid)) != NULL && +								item->nameid != ITEMID_ZENY && item->nameid != ITEMID_CASH)+								c++;+						}+					+						if(c > 1){+							clif->vend(sd,sd->vend_lvl);+						}+						else { +							sd->state.prevend = 1;+							if(c) {+								item = itemdb->exists(battle_config.item_zeny?battle_config.item_zeny:battle_config.item_cash?battle_config.item_cash:item_vend[0].itemid);+								sd->vend_loot = item->nameid;+								sprintf(output,"Current Currency: %s",itemdb_jname(sd->vend_loot));+								clif->vendmessage(sd,output,VEND_COLOR);+								clif->openvendingreq(sd,2+sd->vend_lvl);+							} else {+								sd->vend_loot = 0;+								clif->openvendingreq(sd,2+sd->vend_lvl);+							}+						}+					} else {+						sd->vend_loot = 0;+						sd->state.prevend = 1;+						clif->openvendingreq(sd,2+skill_lv);+					}

 

[MAC IP Address]

 

MAC Ban NPC

 

Here is a Mac ban NPC. Credits to Goddameit for the original codes and the idea. I altered it to apply for Mac addresses instead. 

 

CREATE TABLE IF NOT EXISTS `mac_ban` (  `list` varchar(18) NOT NULL,  `ban_reason` varchar(255) NOT NULL default '',  `unban_reason` varchar(255) NOT NULL default '',  `status` tinyint(1) NOT NULL default '0',  `ban_id` int(11) unsigned NOT NULL default '0',  `unban_id` int(11) unsigned NOT NULL default '0',  KEY `list` (`list`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

Here is the script

 

http://pastebin.com/raw.php?i=rRsaK97t

so i need the diff and the script and the sql code for this?

 

Apply the diff, add the sql code to your database, and then use the npc script. It works great, tested and confirmed.

[awakening and concentration potion]

Try defining everything as a pre-renewal first to determine if its a source error

[ASsassin Cross Soul Link Modif.]

To help you out, start looking at battle.c and skill.c and search for the skill name as defined in skill_db.txt

 

It should be SL_ASSASSIN if i am not mistaken. You will see the original values that you can edit there.

 

Remember to recompile

[@ii , @mi , and @skillall command]

If Hercules SVN was imported correctly and you are a GM level 99, you should have those commands by default. If not, that is a serous installation problem or edit that was made. Read the atcommand.conf documentation on how it works, and look at how groups.conf works. You will see the correlation between those two documents and how they work with each other.

[setting up aura]

There should be a diff for aura above level 99 as well, cause 99 is default client aura.

[Um help? >.<]

Icabit item builder

[Boss_Monster Script command]

the usage of convex currently only works for permanent monster labels of boss_monster.

 

I like to use custom spawning methods such as random invasion events etc with event labels, It would be nice to see a way for convex mirror to detect script summoned boss_monsters as well.

[client crashing when using @refresh]

Make sure the custom items are not only in idnum files but the num2 files as welll. 

[Setting up a proxy server in Europe/Asia to reduce latency for US-based RO server.]

This sounds amazing, I just wonder why big name games like world of warcraft, still have separate servers for Europe/Asia/America instead one big server. I will ask around for you on this matter

[PokemonRO Project takeover]

closed thank you!

[PokemonRO Project takeover]

Yeah, while they are "forum mods" there is a reason why I posted on hercules, because hercules is a development forum people are interested in scripts/coding/server aspects. Hiring within requires teaching all of the requirements of running a server from the basics. I am looking for someone a little more experienced who knows how to handle a server, knows the costs of running one.

 

I see a lot of people opening new servers and servers dying all the time. I am not going to let the server die, I want it to be continued by others.

 

1. Website costed $650 USD

2. I have over 200+ Pokemon Sprites, invested over $700 to spriters

3. I have custom maps, custom scripts, loading screens, patchers,

 

 

These are all costs of starting a new server properly, and I understand that a lot of people can't afford it. This is a premium server and I want it to be in good hands

[PokemonRO Project takeover]

The host had to transfer my vps to a different IP, so I just corrected that. It should display correctly now. Not a critical error, just a simple IP change in the server.conf files for any server owner who knows the basics.

[PokemonRO Project takeover]

At the verge of graduation, I have found myself pursuing a career path and dedicating my time in a business opportunity. It has been an absolute pleasure building PokemonRO to where it is now, and I see so much potential for it in the future. I am looking for someone to takeover my project, I am handing the

reigns to someone who can spend the time that I have in the past.

 

1. Comes with a fully functional website done by YHMWHY

http://pokemon-ro.net

2. All Server files are intact and it is still running and operational

 

3. IPB forums

 

If an individual/team decides to take over, they will be responsible
for all the financials for the server, hosting, etc. for maintaing it.
This is not a sale of my server, I am handing over everything to a new
owner to continue the project.

 

If you are interested, please let me know here, or if you have more
questions, please PM me and I will be happy to answer anything. I will
be dedicating my part time providing paid services in my
spare time.

[@noks Ksprotection]

I would like to remove the check for PVP map on this command. It does not work on a pvp flagged map.

 

Any help would be appreciated, thank you!