-
Posts
550 -
Joined
-
Last visited
-
Days Won
1
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Erba
-
http://tinypic.com/r/2n6htzn/6 here's my Screen shot of my error sir and this is my script /* # Advance Breaker Room CREATE TABLE IF NOT EXISTS `E-Breakers` ( `no` mediumint(9) unsigned NOT NULL auto_increment, `char_id` int(11) unsigned NOT NULL default '0', `name` varchar(30) NOT NULL DEFAULT '', `time` bigint(11) NOT NULL default '0', `mob_id` mediumint(9) unsigned NOT NULL default '0', PRIMARY KEY ( `no` ) ) ENGINE=MyISAM; # Random Sample Data for viewing the Data in Games / SQL # ============================================================= INSERT INTO `E-Breakers` ( `char_id`,`name`,`time`,`mob_id` ) VALUES ( 10000'Amistry','12411',3000 ); INSERT INTO `E-Breakers` ( `char_id`,`name`,`time`,`mob_id` ) VALUES ( 20000,'Emistry1','28211',3000 ); INSERT INTO `E-Breakers` ( `char_id`,`name`,`time`,`mob_id` ) VALUES ( 10000,'Amistry','32511',1899 ); INSERT INTO `E-Breakers` ( `char_id`,`name`,`time`,`mob_id` ) VALUES ( 20000,'Emistry1','42161',1899 ); */ // ====== mob_db.txt / mob_db2.txt ======= // 3000,EMPELIUM,Emperium,Emperium,90,700,1,0,0,1,60,73,64,50,1,17,80,50,26,20,10,12,0,8,26,0x160,300,1288,288,384,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 // ====== mob_avail.txt ======= // 3000,1288 sec_in02,172,162,4 script Adv Breaker Room Manager 100,{ if( select( "Rent a Room","View Ladder" ) == 1 ){ if( !instance_id(1) ){ if( .Cost ){ mes "it cost ^0055FF"+.Cost+" Zeny^000000 to rent a Breaker Room for "+.Minute+" Minutes."; if( select("Confirm:Cancel") == 2 ) close; } if( !getcharid(1) || !instance_check_party( getcharid(1),1,90,150 ) ){ mes "Required a Party which have at least 1 Member that is level 255"; close; } set .@instance,instance_create( " Adv. Breaker Room ",getcharid(1)); if( .@instance < 0 ){ switch( .@instance ){ Case -2: mes "Invalid Party ID"; break; Case -3: mes "Max Instances Exceed."; break; Case -4: warpparty has_instance( "guild_vs1" ),49,92,getcharid(1); break; Case -1: default: mes "Failed to Create an Instances."; } }else{ set Zeny,Zeny - .Cost; instance_attachmap( "guild_vs1",.@instance ); instance_set_timeout ( .Minute * 60 ),( .Timeout * 60 ),.@instance; instance_init .@instance; instance_attach .@instance; warpparty has_instance( "guild_vs1" ),49,92,getcharid(1); donpcevent instance_npcname( "Helper#Breaker Room",instance_id() )+"::OnInstanceInit"; end; } }else{ warpparty has_instance( "guild_vs1" ),49,92,getcharid(1); } }else{ switch( select( "Own Ladder","Overall Top Breaker","^FF0000Remove Records^000000" ) ){ default: Case 1: .@query_size = query_sql( "SELECT `mob_id`,`time` FROM `E-Breakers` WHERE `char_id`='"+getcharid(0)+"' GROUP BY `mob_id` ORDER BY `time` ASC LIMIT "+.size,.@MobID,.@Time ); if( !.@query_size ){ mes "No Records found !"; }else{ mes "^0055FF[ "+strcharinfo(0)+"'s Record ]^000000"; for( .@i = 0; .@i < .@query_size; .@i++ ){ mes "^DDBB00"+getmonsterinfo( .@MobID[.@i],MOB_NAME )+" : ^FF0000"+( .@Time[.@i] / 1000 )+"."+( .@Time[.@i] % 1000 )+" sec^000000"; } } break; Case 2: for( .@i = 0; .@i < .size; .@i++ ) .@Menu$ = .@Menu$ + getmonsterinfo( .MonsterList[.@i],MOB_NAME )+":"; do{ .@mob = select( .@Menu$ ) - 1; do{ .@query_size = query_sql( "SELECT `name`,`time`,`mob_id` FROM `E-Breakers` WHERE `mob_id`='"+.MonsterList[.@mob]+"' GROUP BY `name` ORDER BY `time` ASC LIMIT 10 OFFSET "+.@Offset+" ",.@Name$,.@Time,.@MobID ); mes "Monster : ^FF0000"+getmonsterinfo( .MonsterList[.@mob],MOB_NAME )+"^000000"; if( !.@query_size ){ mes "No extra Records found !"; }else{ for( .@i = 0; .@i < .@query_size; .@i++ ) mes "^0055FF[ "+( .@Offset + .@i + 1 )+"th : "+.@Name$[.@i]+" ] : ^FF0000"+( .@Time[.@i] / 1000 )+"."+( .@Time[.@i] % 1000 )+"sec^000000"; .@Offset += 10; } next; }while( select( ( .@query_size )?"Next 10 Rank":"","Back" ) == 1 ); mes "Please choose your option..."; }while( select( "View Breaker Rank","Back" ) == 1 ); break; Case 3: mes "What Record you want to clear ?"; if( select( "Personal Record",( getgmlevel() < .GMLevel )?"":"[ GM ] All Record" ) == 1 ){ query_sql( "DELETE FROM `E-Breakers` WHERE `char_id`='"+getcharid(0)+"'" ); mes "^FF0000Removed All "+strcharinfo(0)+"'s Breaker Records.^000000"; }else{ query_sql( "TRUNCATE `E-Breakers`" ); mes "^FF0000Removed All Records.^000000"; } break; } } close; OnInit: // GM Level .GMLevel = 90; // Cost to Rent Room .Cost = 1000000; // Room Duration .Minute = 30; // Room Timeout .Timeout = 5; // Edit Monster Lists setarray .MonsterList[0],3000,1899,1900,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915; .size = getarraysize( .MonsterList ); end; } 1@room,32,30,4 script Helper#Breaker Room 100,{ if( !instance_id(1) ) end; .@mobcount = mobcount( "guild_vs1",instance_npcname( "Helper#Breaker Room",instance_id(1) )+"::OnMyMobDead" ); switch( select( "^0055FFHeal^000000", ( getcharid(0) != getpartyleader( getcharid(1),2 ) )? "":( .@mobcount )? "Remove Monster":"Summon Monster", "Go out", ( getcharid(0) == getpartyleader( getcharid(1),2 ) )?"^FF0000Terminate Room^000000":"" )){ default: Case 1: percentheal 100,100; skilleffect 28,MaxHP; specialeffect2 313; break; Case 2: if( .@mobcount ){ stopnpctimer; npctalk "All monster has been removed by Party Leader."; killmonsterall "guild_vs1"; close; }else{ mes "Please select a Monster..."; 'selected = getelementofarray( getvariableofnpc( .MonsterList, "Adv Breaker Room Manager" ),( select( 'Menu$ ) - 1 ) ); close2; monster "guild_vs1",-1,-1,"--ja--",'selected,1,instance_npcname("Helper#Breaker Room", instance_id())+"::OnMyMobDead"; initnpctimer; end; } break; Case 3: warp "SavePoint",0,0; dispbottom "You may enter this Room anytime as long as it's not terminated or timeout"; break; Case 4: mes "Are you sure ?"; mes "If you terminate this Room, you will never able to come in again."; if( select("Confirm:Cancel") == 1 ){ instance_destroy instance_id(1); } break; } close; OnInstanceInit: 'Menu$ = ""; for( .@i = 0; .@i < getvariableofnpc( .size,"Adv Breaker Room Manager" ); .@i++ ) 'Menu$ = 'Menu$ +getmonsterinfo( getelementofarray( getvariableofnpc( .MonsterList, "Adv Breaker Room Manager" ),.@i ),0 ) +":"; sleep 2000; npctalk "Please get yourself ready..."; instance_announce 0,"Welcome to Adv. Breaker Room",0; sleep 3000; npctalk "Select a monster ... and Break it into pieces...and Skills are Disabled."; end; OnMyMobDead: stopnpctimer; .@timer = getnpctimer(0); instance_announce 0,"========== [ "+getmonsterinfo( 'selected,MOB_NAME )+" ] ==========",0; instance_announce 0,"Average Damage Per Seconds : "+( getmonsterinfo( 'selected,MOB_MAXHP ) / ( .@timer / 1000 ) ),0; instance_announce 0,"Total Time Spent : "+( .@timer / 1000 )+"."+( .@timer % 1000 )+" seconds.",0; if( getmapusers( has_instance("1@room") ) == 1 ){ emotion e_heh; mes "Not bad, i would like to save / update your record into the Database."; query_sql(" SELECT `time` FROM `E-Breakers` WHERE `char_id`='"+getcharid(0)+"' AND `mob_id`='"+'selected+"' ORDER BY `time` ASC",.@Record ); mes "Best Record : ^0055FF"+( .@Record / 1000 )+"."+( .@Record % 1000 )+" seconds^000000"; mes " "; mes "Current Record : ^0055FF"+( .@timer / 1000 )+"."+( .@timer % 1000 )+" seconds^000000"; if( select("Record ^0055FF"+( .@timer / 1000 )+"."+( .@timer % 1000 )+" seconds^000000:Nope") == 1 ){ query_sql( "DELETE FROM `E-Breakers` WHERE `char_id`='"+getcharid(0)+"' AND `mob_id`='"+'selected+"' AND `time` > '"+.@timer+"'" ); query_sql( "INSERT INTO `E-Breakers` ( `char_id`,`name`,`time`,`mob_id` ) VALUES ( '"+getcharid(0)+"','"+strcharinfo(0)+"','"+.@timer+"','"+'selected+"' )" ); } close; }else{ emotion e_sry; npctalk "Not bad, but Record will not store for Grouped Team. Only for Solo Player will store the records."; } end; } // ==== MAP FLAGS ==== guild_vs1 mapflag nogo guild_vs1 mapflag nomemo guild_vs1 mapflag nosave guild_vs1 mapflag nobranch guild_vs1 mapflag nowarp guild_vs1 mapflag nobaseexp guild_vs1 mapflag nojobexp guild_vs1 mapflag nomobloot guild_vs1 mapflag nomvploot guild_vs1 mapflag nowarpto //guild_vs1 mapflag noskill
-
how did you fix it?
-
My script sir is in my no. #8 post i didnt change any name sir i just did change the location
-
i cant post an screen shot... but here is what was shown in the CMD [info]: [instance] Created: Adv. Breaker Room . [info]: [instance] Initialized Adv. Breaker Room . [error]: Script:getvariableofnpc: can't find npc Adv. Breaker Room Manager [debug]: Source (NPC): Helper#Breaker Room at 001guild_vs (49,50)
-
how to send it directly sir so that i can give many items?
-
how can i Modify the woe_controller so that it can give not just 1 item but 3-5 items like credits,edp potion,glist coat, and many more because it can only give 1item
-
can someone help me fix this? im using Emistrys'. im having an error it says WORLD ^&%*&^*$)(*% blahblah then after the error the client debugs Breaker Room 3.0.txt
-
what do you mean it cuts the attack speed? actually weapons can make the attack speed to decrease.. do not use any other View id you must use the exact view id of the bow.. view id is different than item id
-
Having Problem with MVP respawn like Kiel Lhz and other MVP's they are not spawning in time!
-
i am having an error with your script.. it says WORLD &*^*#(%_#(%_ i cant tell the exact error.. i guess it is a sprite error or something because after that error the client debugs
-
i did what you have said.. but still it shows Index of/ cgi-bin T_T
-
sir did i make it right? /<root>/home/www/cp the cp is where my flux is installed BUMP
-
i guess there is no spr act for shield... but you can do this as an alternative copy a shield script in the item_db > replace the item no. and name and scripts except for the view id
-
same grf? same accounts? maybe you are pointing Database importing?
-
can you give me the link.. because all i can find is for setting up the RO
-
how to make it in philippine time? im using asurahosting sir
-
i have a problem in installing FLUXCP.. it always shows: INDEX OF/ cgi-bin how to install my flux T_T
-
/data/sprite/Àΰ£Á·/ÇåÅÍ post your weapon sprite here ÇåÅÍ_<male/female>_<item sprite name>
-
how to modify this mam? i want give players points even if they are afk.. except vending [solved]
-
[ Prinz Dee GFX ] Free Request - Banner / Signature / Loading Screen ETC.
Erba replied to Dee's topic in Arts & Writings
can you please make a banner for me too? server name: SaiCan Ragnarok Online Max Level: 255/120 qoute: SaiCan Ragnarok Online where the battle of skills and talents starts Full of Balance Donates and Custom Items Fair and Approachable GM.. TYYYYYYYYYY!! -
can you explain to me what this do specifically?
-
Can i request for a script that whoever summon thanatos will be the only player who can kill thanatos.. to prevent kill stealing