[How to fix error skill and How to change it]

For the last 2 items. I suggest you open an issue in the github repo so that it will be investigated and fixed. https://github.com/rathena/rathena/issues/new

[Add new 'if'.]

Well, before I do anything with your script, You should be aware that first of all, you will not be able to delete items of players that are online because items get saved when players logout.  Second,  you may make sure that you are using the right group id in your script. I guess setting it to < 99 Will be a better choice. Then try it again and let us know the results.

[Logging the trade on NPC]

input .@i $;

if (strtolower (.@i $ ) == "yes") {

          do this;

}

[Feint Bomb Question]

Please open a new issue in the github page: https://github.com/rathena/rathena/issues/new

so this will be investigated

[Resident Evil Script]

So it's something like, A player becomes a zombie, he kills someone and that someone becomes a zombie. Interesting.

[Logging the trade on NPC]

9 hours ago, skyroofficial said:

yes but you know.. there are alot.. lots of the list on the logs..

so thats why i tried to make a separate logs just to monitor those specified items in that specified npc that i made 

anyways , thanks for the reply tho 

You only need to learn how to use SQL and in my opinion it is fairly easy.

[Block unequip a equip vía function]

I think it is. Just a combination of logics between OnPCLoadMapEvent, OnPCStatCalcEvent and Strcharinfo. Or if you're into it, manually do it via database onequip script.

 

//edit

You can also create a mapflag and a new script event like OnPCEquipEvent via source modding

[Resident Evil Script]

@bdgro unless you provide more info about what this script is about, as much as we would like to help, we can't because we don't exactly know what you're looking for and what it does.

[Logging the trade on NPC]

I think all activities about items can be seen in itemlog sql table. You don't need to do something like this. Have checked it?

[(Fixed)Changing all refine of items of all accounts in phpmyadmin.]

Yes. For more info. Please look at some SQL basics cheatsheet. https://www.w3schools.com/sql/

[(Fixed)Changing all refine of items of all accounts in phpmyadmin.]

He means that you will be using item_db_pre instead of item_db_re and that you have to think about how to modify the sql command that I gave you to also update item refines which are located in other tables such as storage, cart_inventory, etc.

[(Fixed)Changing all refine of items of all accounts in phpmyadmin.]

UPDATE inventory 
INNER JOIN item_db_re ON inventory.nameid = item_db_re.id
SET inventory.refine={CHANGE THIS VALUE TO DESIRED REFINE}
WHERE item_db_re.type IN ({PUT ALL ITEM TYPES SEPARATED BY COMMAS});

https://github.com/rathena/rathena/wiki/Custom_Items

refer to the link on item types.

this method will only work if the person who owns the item is offline.

[Help with quest npc bloody branch]

I'm not really sure what's wrong with yours but it works on mine.

I used @Emistry's script as I missed the OnInit part.

[Creating Raid party system]

Yes, one idea is to create the "party registration" in such a way that it takes note of the party name instead of the names of the people who registered then create an instance assign it to 1 party then just party warp all the other remaining ones.

[Help with quest npc bloody branch]

it would help if you can provide us with in-game screenshots especially your inventory.

[Help with quest npc bloody branch]

NPC#1

prontera,157,171,4	script	Tratoa	489,{
if (quest_tratoa == 1) {
	mes "Que bueno terminaste la quest";
	mes "Yo tambien puedo enviarte a Tradoa";
	close;
}
mes "Esta es la ques que te llevara al mitico mapa Tratoa";
next;
mes "Tratoa esta alado de la carcel de mosntruos llamado Las Tinieblas";
next;
mes "Los mosntruos escaparon de las Tienieblas";
mes "Por lo cual constantemente mosntrus deviles y poderosos entran a tratoa diariamente";
next;
mes "Una ves completada esta Quest tendras acseso a Tratoa";
next;
mes "Primero que nada deves ablar con siertas personas dispersadas por todo Rune Midgar";
next; 
mes "Al final de todo deveras ablar con Gonsalo esta alado mio... quien es el que te enviara a Tratoa y con el deveras ablar para poder ir siempre a tratoa";
next;
mes "Ahora ve y abla con Stefan que esta en izlude";
set quest_tratoa, 1;
close;
}

 

NPC#2

nif_fild01,273,245,5	script	Skull Trader	910,{

mes "[ Skull Girl ]";
if (quest_tratoa == 1) {
mes "Hola soy el creador de las bloody branch";
mes "no le digas a nadie";
mes "Para hacer las bloody branch necesito lo siguiete";
next;
mes " "+.skull_required+" "+getitemname(.skull_id)+"";
mes " "+.skulla_required+" "+getitemname(.skulla_id)+"";
mes " "+.skulls_required+" "+getitemname(.skulls_id)+"";
mes .exchange_qty+"x "+getitemname(.exchange_id);
mes "How many ^FF0000Bloody Branch^000000 do you want to exchange?";
input .@input;
if(!.@input){
	next;
	mes "[ Skull Girl ]";
	mes "Come back again~";
	close;
}
//check if player has the needed amount of items
if(((.@input * .skull_required) < countitem(.skull_id)) || ((.@input * .skulla_required) < countitem(.skulla_id)) || ((.@input * .skulls_required) < countitem(.skulls_id))){
	next;
	mes "[ Skull Girl ]";
	mes "You don't have enough skulls to exchange that many.";
	close;
}
next;
delitem .skull_id,.skull_required * .@input;
delitem .skulla_id,.skulla_required * .@input;
delitem .skulls_id,.skulls_required * .@input;
getitem .exchange_id,.exchange_qty * .@input;
mes "[ Skull Girl ]";
mes "Oh em geeee";
mes "Yasss I hassss "+getitemname(.skull_id)+" "+getitemname(.skulla_id)+" "+getitemname(.skulls_id)+" nowwww!";
mes "Me so happy, here take these "+getitemname(.exchange_id)+"!";
close;
}

OnInit:
set.skull_required,20; //number of skulls
set.skulla_required,20; //number of skulls
set.skulls_required,20; //number of skulls
set.skull_id,604; //id # of skull
set.skulla_id,7203; //id # of skull
set.skulls_id,7347; //id # of skull
set.exchange_qty,1; //number of exchanged items
set.exchange_id,12103; //id # of exchanged item

end;    
}

 

Your script put an NPC inside another NPC which is a bad practice.

Also, your checking script was a nested if statement and it would be bypassed if someone has the correct amount of 1 type of skull.

Please try the scripts above

[Creating Raid party system]

Interesting. I think even without using any source you can get this working but it'll be great if we can have a function that can manage a group of parties.

[Practicing Creating Ragnarok]

https://github.com/rathena/rathena/wiki

[Compile warnings]

what I did to fix my compilation problem was to install the full gcc package. Hence,

yum install -y gcc*

 

[help sql V4P]

You are welcome. Cheers.

[help sql V4P]

2 hours ago, NakedWolf said:

and also on my console i get a Warning : incorrect use of "close: command!

This shows up when you did not do any prior "mes" commands before closing it.

What I would suggest is to put something like 

mes "You have successfully retrieved your Vote points!";

before "close"

[Help: Sell Everything for 1z?]

1 hour ago, Playtester said:

Actually buy price should be set to 2z so that the sell price is 1z.

If you are using text files, you can easily edit them with a spreadsheet editor (Excel or Open Office). If you are using a database, you can pretty much change all with a simple SQL command.

UPDATE item_db set `price_sell` = 1 where 1=1;
UPDATE item_db2 set `price_sell` = 1 where 1=1;
UPDATE item_db_re set `price_sell` = 1 where 1=1;
UPDATE item_db2_re set `price_sell` = 1 where 1=1;

 

[Random area appearance of an NPC]

it is because it is located in your OnInit part. You should put it after you've moved your NPC somewhere. I think NPC waiting rooms disappear when they are moved to another place unless you used WalkToXy.

[Help whosell]

can you please post a screenshot of the exact error?

[Is it possible to enable Sniper Card effect on all skills ?]

It is possible but you will have to create a new effect such as "Spell Vampirism" or something like that which needs source edits and db edits. I'm not sure where to point you to but at least I'd let you know that it is possible.