Eliminar card ingame

[Zikoziz]

Saludos,

Necesito ayuda,

1.- Necesito borrar las card MVP's que se encuentran ingame en los usuarios(storage-inventario)

2.- Si es posible que al borrar la card entregue una cierta cantidad de Cash.

 

PD: tengo un script que detecta las card MVPs en el servidor, detecta el usuario que tiene la carta y en donde inventario o storage. (por si sirve de algo)

 

Muchas Gracias.

[Omnipotent]

No sé si funcione. Buena suerte.

-    script    cards_deleter    -1,{

OnWhisperGlobal:
    set [email protected], 100;
    if ( getgmlevel ( ) > 98 )
    {
        // créditos AnnieRuru
        [email protected] = query_sql( "select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where mode & 32 and type = 6 and mexp != 0 group by item_db.id order by name_japanese limit 128", [email protected] );
        setarray [email protected]$[0], "auction", "cart_inventory", "guild_storage", "inventory", "mail", "storage";
        setarray [email protected]$[0], "seller_id", "char_id", "0", "char_id", "dest_id", "account_id";
        [email protected]$ = "|";
        for ( ; [email protected] < 6 ; [email protected]++ )
        {
            for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
            {
                if ( [email protected]$[[email protected]] != "0" )
                {
                    deletarray [email protected] ;
                    [email protected] = query_sql ( "SELECT `"+ [email protected]$[[email protected]] +"` FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'", [email protected] );
                    for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
                    {
                        deletearray [email protected] ;
                        if ( [email protected]$[[email protected]] != "account_id" )
                            query_sql ( "SELECT `account_id` FROM `char` WHERE `char_id` = '"+ [email protected][[email protected]] +"' LIMIT 1", [email protected] );
                        else
                            [email protected][0] = [email protected][[email protected]];
                        if ( ! compare ( [email protected]$, "|"+ [email protected] +"|" ) )
                        {
                                [email protected]$ = [email protected]$ +""+ [email protected][0] +"|";
                                query_sql "UPDATE `global_reg_value` SET `value` = `value` + '" [email protected] +"' WHERE `str` = '#CASHPOINTS' AND `account_id` = '" [email protected][0] +"'";
                        }
                    }
                }
                query_sql "DELETE FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'";
            }
        }
        dispbottom "Todo listo.";
    }
    
    
}

[Zikoziz]

Gracias!!! =D
Lo probare y te aviso  

[Xiao]

 

PD: tengo un script que detecta las card MVPs en el servidor, detecta el usuario que tiene la carta y en donde inventario o storage. (por si sirve de algo)

 

Muchas Gracias.

 

Oye no te gustaria compartir ese script? xD  

[Zikoziz]

 

No sé si funcione. Buena suerte.

-    script    cards_deleter    -1,{

OnWhisperGlobal:
    set [email protected], 100;
    if ( getgmlevel ( ) > 98 )
    {
        // créditos AnnieRuru
        [email protected] = query_sql( "select item_db.id from item_db right join mob_db on item_db.id = mob_db.dropcardid where mode & 32 and type = 6 and mexp != 0 group by item_db.id order by name_japanese limit 128", [email protected] );
        setarray [email protected]$[0], "auction", "cart_inventory", "guild_storage", "inventory", "mail", "storage";
        setarray [email protected]$[0], "seller_id", "char_id", "0", "char_id", "dest_id", "account_id";
        [email protected]$ = "|";
        for ( ; [email protected] < 6 ; [email protected]++ )
        {
            for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
            {
                if ( [email protected]$[[email protected]] != "0" )
                {
                    deletarray [email protected] ;
                    [email protected] = query_sql ( "SELECT `"+ [email protected]$[[email protected]] +"` FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'", [email protected] );
                    for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
                    {
                        deletearray [email protected] ;
                        if ( [email protected]$[[email protected]] != "account_id" )
                            query_sql ( "SELECT `account_id` FROM `char` WHERE `char_id` = '"+ [email protected][[email protected]] +"' LIMIT 1", [email protected] );
                        else
                            [email protected][0] = [email protected][[email protected]];
                        if ( ! compare ( [email protected]$, "|"+ [email protected] +"|" ) )
                        {
                                [email protected]$ = [email protected]$ +""+ [email protected][0] +"|";
                                query_sql "UPDATE `global_reg_value` SET `value` = `value` + '" [email protected] +"' WHERE `str` = '#CASHPOINTS' AND `account_id` = '" [email protected][0] +"'";
                        }
                    }
                }
                query_sql "DELETE FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'";
            }
        }
        dispbottom "Todo listo.";
    }
    
    
}

No funciona del todo

 

Mira este lo cree basado en lo anterior, el problema es que aun no funciona X.x

// créditos Pastilla Para Servidor eRO
OnInit:
	set [email protected], 10000;
	set $mingm,99;
	setarray .Cards[0],4121,4123,4128,4131,4132,4134,4135,4137,4142,4143,4144,4145,4146,4147,4148,4168,4236,4241,4263,4276,4302,4305,4318,4324,4330,4342,4357,4359,4361,4363,4365,4399,4403,4407;
	setarray [email protected]$[0], "auction", "cart_inventory", "guild_storage", "inventory", "mail", "storage";
	setarray [email protected]$[0], "seller_id", "char_id", "0", "char_id", "dest_id", "account_id";
que_moon,39,19,4	script	cards_deleter	726,{
	mes "¡Hola "+strcharinfo(0)+"! ¿Borramos las cartas MvP y Mini Boss?";
	if (getgmlevel() >= $mingm) {
	switch(select("-Demosle:- Close")) {
		case 1:
	[email protected]$ = "|";
	for ( ; [email protected] < 6 ; [email protected]++ )
	{
		for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
		{
			if ( [email protected]$[[email protected]] != "0" )
			{
			deletarray [email protected] ;
			[email protected] = query_sql ( "SELECT `"+ [email protected]$[[email protected]] +"` FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'", [email protected] );
			for ( [email protected] = 0 ; [email protected] < [email protected] ; [email protected]++ )
			{
				deletearray [email protected] ;
 				if ( [email protected]$[[email protected]] != "account_id" )
					query_sql ( "SELECT `account_id` FROM `char` WHERE `char_id` = '"+ [email protected][[email protected]] +"' LIMIT 1", [email protected] );
				else
				[email protected][0] = [email protected][[email protected]];
			if ( ! compare ( [email protected]$, "|"+ [email protected] +"|" ) )
			{
					[email protected]$ = [email protected]$ +""+ [email protected][0] +"|";
					query_sql "UPDATE `global_reg_value` SET `value` = `value` + '" [email protected] +"' WHERE `str` = '#CASHPOINTS' AND `account_id` = '" [email protected][0] +"'";
				}
			}
		}
			query_sql "DELETE FROM `"+ [email protected]$[[email protected]] +"` WHERE `nameid` = '"+ [email protected][[email protected]] +"'";
		}
	}
	dispbottom "Todo listo.";
		case 2:
mes "^616D7E¡Bueno!, si eso es lo que quieres. :(";
			close;
	}
	end;
}
}

[Zikoziz]

Solucionado