koloridjo

Members
  • Content Count

    28
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

Community Reputation

0 Neutral

4 Followers

About koloridjo

  • Rank
    Drops

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

1,231 profile views
  1. thank you @sader1992 the script is working fine now
  2. hellow can someone fix this warper script, i can't fix infinity loop here script and SS from console warpersql.txt
  3. @skymia when i want join event with @joinevent error on console [Error]: buildin_callfunc: Function not found! [dispell]
  4. hello, @sader1992 can you add if VIP member get double point ?
  5. can someone update the new link, all links broken thanks
  6. hello, @Emistry can add the npc script will announce when the player takes the prize ?
  7. Yesterday I asked for a script to monitor mvp card, and cyro made one for me. Script can work, but this script can not display player which have mvp card in storage, cart, and can not search player through search card id, can i help me to show player that have mvp card through search card id.? thank you aldebaran,128,123,5 script cardcheck 637,{ mes "[MVP Card Monitoring]"; mes "Masukan Nickname Character yang ingin kalian cek"; next; select "search by input player name/ID", "search by card ID"; if ( @menu == 1 ) { switch ( select ( "Char Name", "Account ID", "Char ID" ) ) { case 1: input [email protected]$; if ( isloggedin( getcharid( 3, [email protected]$ ) ) ) { [email protected] = getcharid( 0, [email protected]$ ); [email protected] = getcharid( 3, [email protected]$ ); [email protected]$ = rid2name( getcharid( 3, [email protected]$ ) ); } else { if ( !query_sql( "select char_id, account_id, name from `char` where name = '"+ escape_sql( [email protected]$ ) +"'", [email protected], [email protected], [email protected]$ ) ) { mes "There is no such Character Name exist"; close; } } break; case 2: input [email protected]; if ( !( [email protected] = query_sql( "select char_id, name, char_num, account_id from `char` where account_id = "+ [email protected] +" order by char_num asc", [email protected], [email protected]$, [email protected], [email protected] ) ) ) { mes "There is no such Account ID"; close; } for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) { mes ( [email protected][[email protected]] +1 )+". "+ [email protected][[email protected]] +" "+ [email protected]$[[email protected]]; [email protected]$ = [email protected]$ +( [email protected][[email protected]] +1 )+". "+ [email protected][[email protected]]; } next; [email protected] = select( [email protected]$ ) -1; [email protected] = [email protected][[email protected]]; [email protected] = [email protected][[email protected]]; [email protected]$ = [email protected]$[[email protected]]; break; case 3: input [email protected]; if ( !query_sql( "select char_id, account_id, name from `char` where char_id = "+ [email protected], [email protected], [email protected], [email protected]$ ) ) { mes "There is no such Character ID exist"; close; } } mes "The player ^0000FF"+ [email protected]$ +"^000000 is "+( ( isloggedin([email protected]) )?"^00FF00Online":"^FF0000Offline" )+"^000000"; if ( isloggedin( [email protected], [email protected] ) ) { [email protected] = getcharid(3); attachrid [email protected]; getinventorylist; for ( [email protected] = 0; [email protected] < @inventorylist_count; [email protected]++ ) { if ( compare( .mvpcard_compare$, "#"+ @inventorylist_id[[email protected]] +"#" ) || compare( .mvpcard_compare$, "#"+ @inventorylist_card1[[email protected]] +"#" ) || compare( .mvpcard_compare$, "#"+ @inventorylist_card2[[email protected]] +"#" ) || compare( .mvpcard_compare$, "#"+ @inventorylist_card3[[email protected]] +"#" ) || compare( .mvpcard_compare$, "#"+ @inventorylist_card4[[email protected]] +"#" ) ) { [email protected][[email protected]] = @inventorylist_id[[email protected]]; [email protected][[email protected]] = @inventorylist_amount[[email protected]]; [email protected][[email protected]] = @inventorylist_identify[[email protected]]; [email protected][[email protected]] = @inventorylist_refine[[email protected]]; [email protected][[email protected]] = @inventorylist_attribute[[email protected]]; [email protected][[email protected]] = @inventorylist_card1[[email protected]]; [email protected][[email protected]] = @inventorylist_card2[[email protected]]; [email protected][[email protected]] = @inventorylist_card3[[email protected]]; [email protected][[email protected]] = @inventorylist_card4[[email protected]]; attachrid [email protected]; mes @itemname2_info$[0] + callfunc( "getitemname2", [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]] ) +":^000000 "+ [email protected][[email protected]] +" ea."; attachrid [email protected]; [email protected]++; } } attachrid [email protected]; } else { [email protected] = query_sql( "select nameid, amount, identify, refine, attribute, card0, card1, card2, card3 from inventory where "+ .query_sql$ +" and char_id = "+ [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected] ); for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) mes @itemname2_info$[0] + callfunc( "getitemname2", [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]], [email protected][[email protected]] )+":^000000 "+ [email protected][[email protected]] +" ea."; } } close; OnInit: query_sql "select dropcardid from mob_db where mexp != 0 and dropcardper = 1", .mvpcard; .mvpcard_size = getarraysize( .mvpcard ); .mvpcard_compare$ = "#"; for ( [email protected] = 1; [email protected] < .mvpcard_size; [email protected]++ ) { [email protected]$ = [email protected]$ +","+ .mvpcard[[email protected]]; [email protected]$ = [email protected]$ +","+ .mvpcard[[email protected]]; [email protected]$ = [email protected]$ +","+ .mvpcard[[email protected]]; [email protected]$ = [email protected]$ +","+ .mvpcard[[email protected]]; [email protected]$ = [email protected]$ +","+ .mvpcard[[email protected]]; .mvpcard_compare$ = .mvpcard_compare$ + .mvpcard[[email protected]] +"#"; } for ( [email protected] = 0; [email protected] < .mvpcard_size; [email protected]++ ) { } .query_sql$ = "( nameid in ("+ .mvpcard + [email protected]$ +") or card0 in ("+ .mvpcard + [email protected]$ +") or card1 in ("+ .mvpcard + [email protected]$ +") or card2 in ("+ .mvpcard + [email protected]$ +") or card3 in ("+ .mvpcard + [email protected]$ +") )"; end; }
  8. i am sorry cyro, this script can't search mvp card on storage and cart ? and i can't use search via Card ID
  9. you can use roullete ticket item 22869 and consume it
  10. Work Perfectly Thank you Cyro
  11. excuse me cyro, sorry took so long for test this script, i got problem here, when iam search player id i got this error on my console, and if i try search card id always close dialog
  12. thank you cyro i will check it letter
  13. Excuse me, can i request a npc that can see and monitor all the players that get mvp card, both in storage, inventory and in equip? With sql ?? thank you
  14. why not mapflag ?? while there mapname ??