Jump to content

Nero

Members
  • Posts

    194
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Nero

  1. Hello how can i properly remove a costume equipment via sql? example i want to properly remove the costume archangel wing ( 20500)

    Ive used

    DELETE FROM `inventory ` WHERE nameid='20500' AND equip='8192;

    But when i login i can see that the archangel wing(20500) is gone in the equip but the sprite view is still there.

    Is there anyway to remove also the sprite view upon deleting the item in sql?

    or is there any scripts that can be done via onlogin to automatically check and remove the player's costume garment sprite view before entering the game?

    Thanks in advance!

  2. On 3/2/2018 at 7:44 PM, Keitenai said:

    try this @Nero:

    
    -	script	guild_vs1s2	-1,{
    
    	OnAgitEnd:
    		callsub( L_reward,0, "guild_vs1" );
    		end;
    		
    	OnAgitEnd2:
    		callsub( L_reward,1, "guild_vs1" );
    		end;
    	
    	L_reward:
    		.@type = getarg( 0,0 );
    		.@map$ = getarg( 1,"" );
    		
    		if ( .@type == 0) {	// woe fe
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		else {	// woe se
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		.@item_master_size = getarraysize( .@item_master ) - 1;
    		.@item_member_size = getarraysize( .@item_member ) - 1;
    		
    		if ( .@map$ != "" ) {
    			.@gid = getcastledata( .@map$,1 );
    			if ( .@gid > 0 ) {
    				getguildmember .@gid,1;
    				getguildmember .@gid,2;
    				.@master_id = getcharid( 3, getguildmaster( .@gid ) );
    				while ( .@i < $@guildmembercount ) {
    					.@x = 0;
    					if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) {
    						if ( $@guildmemberaid[.@i] == .@master_id ) {
    							while ( .@x < .@item_master_size ) {
    								if(!checkvending(strcharinfo(0,$@guildmembercid[.@i])))
    									getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    							}
    						}
    						else {
    							while ( .@x < .@item_member_size ) {
    								if(!checkvending(strcharinfo(0,$@guildmembercid[.@i])))
    									getitem .@item_member[.@x],.@item_member[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    							}
    						}
    					}
    					.@i++;
    				}
    			}
    		}
    		return;
    }

     

     

    Im having error in this one 

    [Error]: script error in file 'npc/rage/koe.txt' line 158 column 39
        parse_callfunc: expected ')' to close argument list
       155:                                         if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) {
       156:                                                 if ( $@guildmemberaid[.@i] == .@master_id ) {
       157:                                                         while ( .@x < .@item_master_size ) {
    *  158:                                                                 if(!checkvending(strcharinfo(0,$@guildmembercid[.@i])))
            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^
       159:                                                                         getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i];
       160:                                                                 .@x += 2;
       161:                                                         }

     if(!checkvending(strcharinfo(0,$@guildmembercid

  3. 1 hour ago, hendra814 said:

    try like this

    
    while ( .@x < .@item_master_size ) {
    if ( CheckVending() ){
        end;
        }
    	getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i];
    			.@x += 2;
    }

     

    -	script	guild_vs1s2	-1,{
    
    	OnAgitEnd:
    		callsub( L_reward,0, "guild_vs1" );
    		end;
    		
    	OnAgitEnd2:
    		callsub( L_reward,1, "guild_vs1" );
    		end;
    	
    	L_reward:
    		.@type = getarg( 0,0 );
    		.@map$ = getarg( 1,"" );
    		
    		if ( .@type == 0) {	// woe fe
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		else {	// woe se
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		.@item_master_size = getarraysize( .@item_master ) - 1;
    		.@item_member_size = getarraysize( .@item_member ) - 1;
    		
    		if ( .@map$ != "" ) {
    			.@gid = getcastledata( .@map$,1 );
    			if ( .@gid > 0 ) {
    				getguildmember .@gid,1;
    				getguildmember .@gid,2;
    				.@master_id = getcharid( 3, getguildmaster( .@gid ) );
    				while ( .@i < $@guildmembercount ) {
    					.@x = 0;
    					if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) {
    						if ( $@guildmemberaid[.@i] == .@master_id ) {
    							while ( .@x < .@item_master_size ) {
    								getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    							}
    						}
    						else {
    							while ( .@x < .@item_member_size ) {
    								if ( CheckVending() ){
    									end;
    									}
    								getitem .@item_member[.@x],.@item_member[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    								
    							}
    						}
    					}
    					.@i++;
    				}
    			}
    		}
    		return;
    }

    Still not getting anything. 

  4. How can i restrict them from getting reward in this script:

    -	script	guild_vs1s2	-1,{
    
    	OnAgitEnd:
    		callsub( L_reward,0, "guild_vs1" );
    		end;
    		
    	OnAgitEnd2:
    		callsub( L_reward,1, "guild_vs1" );
    		end;
    	
    	L_reward:
    		.@type = getarg( 0,0 );
    		.@map$ = getarg( 1,"" );
    		
    		if ( .@type == 0) {	// woe fe
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		else {	// woe se
    			setarray .@item_master,
    				30206,2;
    			setarray .@item_member,
    				30206,1;
    		}
    		.@item_master_size = getarraysize( .@item_master ) - 1;
    		.@item_member_size = getarraysize( .@item_member ) - 1;
    		
    		if ( .@map$ != "" ) {
    			.@gid = getcastledata( .@map$,1 );
    			if ( .@gid > 0 ) {
    				getguildmember .@gid,1;
    				getguildmember .@gid,2;
    				.@master_id = getcharid( 3, getguildmaster( .@gid ) );
    				while ( .@i < $@guildmembercount ) {
    					.@x = 0;
    					if ( isloggedin( $@guildmemberaid[.@i],$@guildmembercid[.@i] ) ) {
    						if ( $@guildmemberaid[.@i] == .@master_id ) {
    							while ( .@x < .@item_master_size ) {
    								getitem .@item_master[.@x],.@item_master[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    							}
    						}
    						else {
    							while ( .@x < .@item_member_size ) {
    								getitem .@item_member[.@x],.@item_member[.@x+1],$@guildmemberaid[.@i];
    								.@x += 2;
    							}
    						}
    					}
    					.@i++;
    				}
    			}
    		}
    		return;
    }

    Where to put this one  if(    ( checkvending() == 2 && !.autotrade ) ?

     

  5. Hello

    I dont know if you are aware of this problem.

    Situation:

    Rudra bow = no arrow animation. Class num = 77

    upon checking

    only on weapontable.lub class num 73 to 76 will show the arrow animation from any bow sprites.

    so reverting 

    WEAPONTYPE_Hunter_Bow = 76,
    WEAPONTYPE_Bow_Of_Rudra = 77,

     [Weapon_IDs.WEAPONTYPE_Hunter_Bow] = "_1718", changed to 1720
     [Weapon_IDs.WEAPONTYPE_Bow_Of_Rudra] = "_1720", 

     

    then using class num 76 to rudra bow- Will now show the arrow animation/attack

    therefore sprite of rudra bow is not the reason.

    probably client is only accepting bow animation between 

     WEAPONTYPE_CrossBow = 73,
      WEAPONTYPE_Arbalest = 74,
      WEAPONTYPE_Kakkung = 75,
      WEAPONTYPE_Hunter_Bow = 76,

     

    any one here can tell me how may i fix the problem?

    Thank you in advance.

  6. Hello. Im using 20141020 client.

    I dont know if you are aware of this problem.

    Situation:

    Rudra bow = no arrow animation. Class num = 77

    upon checking

    only on weapontable.lub class num 73 to 76 will show the arrow animation from any bow sprites.

    so reverting 

    WEAPONTYPE_Hunter_Bow = 76,
    WEAPONTYPE_Bow_Of_Rudra = 77,

     [Weapon_IDs.WEAPONTYPE_Hunter_Bow] = "_1718", changed to 1720
     [Weapon_IDs.WEAPONTYPE_Bow_Of_Rudra] = "_1720", 

     

    then using class num 76 to rudra bow- Will now show the arrow animation/attack

    therefore sprite of rudra bow is not the reason.

    probably client is only accepting bow animation between 

     WEAPONTYPE_CrossBow = 73,
      WEAPONTYPE_Arbalest = 74,
      WEAPONTYPE_Kakkung = 75,
      WEAPONTYPE_Hunter_Bow = 76,

     

    any one here can tell me how may i fix the problem?

    Thank you in advance.

     

  7. This is the code 

    -	script	mvprewarders	-1,{
    OnNPCKillEvent:
    	if ( getmonsterinfo( killedrid, MOB_MVPEXP ) && rand(100) < 100 ) {
    		if ( getcharid(1) ) {
    			getpartymember getcharid(1), 1;
    			getpartymember getcharid(1), 2;
    			for ( .@i = 0; .@i < $@partymembercount; .@i++ ) {
    				if ( isloggedin( $@partymemberaid[.@i], $@partymembercid[.@i] ) ) { // what happens if someone in the party member is offline =/
    					.@partymemberaid[.@c] = $@partymemberaid[.@i];
    					.@c++;
    				}
    			}
    			getitem 30022, 1, .@partymemberaid[ rand( .@c ) ];
    			announce "Party ["+ strcharinfo(1) +"] has killed "+ getmonsterinfo( killedrid, MOB_NAME ) +" and a Random Party Member Got 1 MVP TOKEN at "+ strcharinfo(3),0,0x00FF00;
    		}
    		else {
    			getitem 30022, 1;
    			announce "Player ["+ strcharinfo(0) +"] has killed "+ getmonsterinfo( killedrid, MOB_NAME ) +" and Got 1 MVP TOKEN at "+ strcharinfo(3),0,0x00FF00;
    		}
    	}
    	end;
    }

    The problem is how can i make all party member to get the reward instead of random party member? Also only party member in the area will be valid to get the reward.

×
×
  • Create New...