tmav94

MANHOLE SC_BLOODYLUST SC_DIMENSIONDOOR Those skills could not be used on players...

I'm getting upset about it.. My servers lose many players (med 85~95 to 40) because abuse of skills like "Paint Trap", Frenesi Trap, etc...Skills that's can be used on other players outside the pvp arena. Have some way to block this?

This method is new for me... Look this other two: query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE `char`.online=1") and: if(isloggedin(getcharid(3))) They do the samething?

i have the ".@char_id". How can i apply this action (query_sql) with this var?

oh god... I have add a custom item to my server, but think how this can be amazing? A Shadow item to show a costume weapon sprite? Any of you know about any client thats support it?

What do you mean about "Don't have sprites".... I have these sprites working fine when the item is normal.

Why? When the item is normal, the show they skin, but when i change to shadow weapon, this doen't work

Ty two for trying to help...but, let me explain... Is possible produce a "monster", that spawn in "pay_fild04" (e.g), to kill others mobs in the area without attack a player when he sees him?

Do you know how can i produce a monster that do this thing? I mean... make a monster that attack other monster without attack players.

We have anything working? I'm talking about Hugins in oldGlastHeim...he enchanty and produce Temporal boots...

.@nb = Receive entries on DB like a INT type? .@item = is now a array? .@amount = is now array too? and if i want to show a String Var? the variable will be converted to String Var Array? you need to look at picklog table: type field mysql limit, you need to offset to show them all Not Tested Sample query last 20 items that you sent in storage sample set .@nb, query_logsql("SELECT nameid, amount FROM picklog WHERE type='R' AND amount<0 AND char_id=150000 ORDER BY time DESC LIMIT 20",.@item,.@amount); for(set .@i,0; .@i < .@nb; set .@i,.@i+1) mes .@item[.@i] +" "+ .@amount[.@i];

Hi, guys! How to show entire data where char_id = getcharid(0) in npc dialog? I believe that i'll need to use WHILE's, IF and some query_sql's...But, i dont know for where i can start... Can you help me? @OTHERWAY A player have "Z" entries on sql_db... When i use: query_sql( "SELECT `x` FROM `y` WHERE `char_id` = '"+escape_sql( getcharid(0) )+"'",.@status); can i show the values with this? while (i < entries_quantity) {mes "Args: "+.@status[i]+";} can you understand what i can say? @IFOUNDSOMETHING I found a ranking script that have what i want... Look: query_sql "SELECT `char_reg_num_db`.`value`,`char`.`name` FROM `char` INNER JOIN `char_reg_num_db` ON `char_reg_num_db`.`char_id`=`char`.`char_id` WHERE `char_reg_num_db`.`key`='overallkdr' ORDER BY `char_reg_num_db`.`value` DESC LIMIT 1",.@value,.@name$;for (.@i=0; .@i<getarraysize(.@value); .@i++){mes "^0000FFOverall KDR^000000: ^808000"+ .@name$[.@i] +"^000000 - ^CC6633"+ .@value[.@i] +":1^000000";} E.g: The player will send a "Apple" to database. The player will send a "Mace" to database. The player will send a "Ygg" to database. I want to show all items sent by the character in a npc dialogue.

Hi guys! I want to able in specific item the power of "Skill Uncondional"... I'm trying to do a item that can be usable for all class including the capacity of uses the class skills... Anyone know anyway?

Sorry for double posting, i think that my post will be merged with another one.

In this case the script will prevent the player to access the npc while another accounts are connected... Now, the script will unlock access when all other accounts on same ip are disconnected, is it?

Hey, wait... I dont...Ok, listen...can you explain me the things that ill list in bold? I never see this structure of query's... if (query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE login.last_ip=(SELECT last_ip FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1", .@account_id) > 1) { end script } else { run script }

I want to prevent that the same player to open a multiples instance of an NPC in different account, tracking by ip [eg]... I try many things to do this work, but whitout sucess. Let explain... When a player touch on specific npc, this send the IP to a MySql Table. if he try to access the same npc in another account, the npc will say that he dont have permission while the another account instance is open. How this npc will do that? He (npc) will get with query_sql the IP and Name of character that initialize the dialog with npc. Anyone know some easyway to do that? I unfortunately do not know.

Recovery 1% of HP and SP each 10 seconds.

How? I see that's possible but i forgot where...

What is? if i have trouble with auto windows close, whitch should i use?

Ok, but why i need to do a update? And how to implement for all MvP?

How to ?

are correct? The damage doesn't change when i use a Glorious Jamadhar and Simple Jamadhar against Eremes Guile...(e.g)

Im trying to use 2014 client but i got some packets erros... In some cases, i saw client + packet. What can i do with it?

Yes, i know. But if i do it, all my players will need to update the kro too.