Mr BrycE

oh so , ill uplaod it to my website and then the script will automatically run? then tadah? done deleting old accounts?

hi, can i ask how this Gettimetick really works because im confused because in rA wiki the 60 * 60 * 1 there are no explanation about that, im confused. if(gettimetick(2) - helped1 < (60 * 60 * 1)) {

is there any script or SQL query aside from this? it deletes old accounts..hmm

ohhhhhhh....ok thanks!

who is Baidu? i always see that user when i post a topic but when i try to search that name here, i cant find it.. is that a bot for rA or something?

<?php //Original Script created by Wouter2004 //Simple edits by martin (http://martint.net) //Change these variables! $mysqlserver = "----"; //IP of the mySQL server $db = "ragnarok"; //ragnarok database $user = "---"; //mySQL user $pass = "---"; //mySQL user password $date = "2012-06-30"; //Delete all account of users that hasnt logged in since.. //----------------------- //dont edit these things unless you know what your doing //----------------------- mysql_connect($mysqlserver,$user, $pass) or die(mysql_error()); mysql_select_db($db) or die(mysql_error()); $num = 0; $result = mysql_query("SELECT * FROM `login` WHERE lastlogin < '$date 00:00:00' ") or die(mysql_error()); echo("<h2>This script will now clean up your database!</h><br><br>"); while ($row = mysql_fetch_array($result)){ //then fetch all the login accounts in an array $result2 = mysql_query("SELECT * FROM `char` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); $num++; echo("<br>".$num."- Account: ".$row[account_id]."- Name: ".$row[userid].""); while ($row2 = mysql_fetch_array($result2)){ //then fetch all the char id's in an array mysql_query("DELETE FROM `global_reg_value` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `inventory` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `skill` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `cart_inventory` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `pet` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `friends` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `char` WHERE char_id = ".$row2[char_id]." ") or die(mysql_error()); } mysql_query("DELETE FROM `storage` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `global_reg_value` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); mysql_query("DELETE FROM `login` WHERE account_id = ".$row[account_id]." ") or die(mysql_error()); } ?>

thanks

FCP scroll? if how to have an Full Chemical Protection scroll?

Can anyone give/make me a script that: •Refines armor/weapons using enriched Elu/Ori. •Won't break armor/weapon when upgrading fails but reduces the refine level instead. •But if the armor/weapon is +8 or +9, there is a 50% chance of success and if it fails it will break.

V4P folder named "vote"... im waiting for rahul dev to fix it for me... i hope he can fix it... i post this because im hoping that i can fix this by asking help hehe..xD

bump.

ok i will test it thank you... Question: OnInit: disablenpc "Anne Curtis"; end; OnClock0600: OnClock1800: enablenpc "Anne Curtis"; end; } onInit, is automatic disablenpc right? and when those OnCLock Triggered: when will the Anne Curtis NPC will be back to Disable NPC?

line 8. i tried commenting out those lines, but... im having an error after that next line... can you give me another script..its not working at all hmm... bump // Reward ID / Amount Initiating ( Check db/Item_db.txt || db/Item_db2.txt ) //setarray .Reward[0], // 607,10, // Reward 1 + Amount // 608,5, // Reward 2 + Amount // 501,3, // etc...... // 512,1; // Last Reward 1 ( Max. ~64 Items ) //set .@npcname$,"^0000FF[ Brice ]^000000"; 1@ma_b,78,80,5 script Dead Bryce 849,{ if(gettimetick(2) - helped1 < (60 * 60 * 72)) { mes "^0000FF[ Bryce ]^000000"; mes "........"; mes "There's a Note in his arm!"; next; mes "[Note:]"; mes "You must wait"; mes "Until its 3 Days Rest is over!"; close; } mes "Legendary Bryce is lying on the floor."; mes "....."; next; mes "there was a Note in his chest."; mes "Here is the list to Revive this Legendary Man."; next; mes "^cc000050x Poison Bottle"; mes "150x Bravery Bagde "; mes "150x Valor Badge"; mes "3000x Special Exhange Ticket"; mes "and 1x Leak Card.^000000"; next; switch(select("-Cancel:-Yes, Lets Give it")) { case 1: close; break; case 2: if (countitem(678) < 50 || countitem(7828) < 150 || countitem(7829) < 150 || countitem(6153) < 3000 || countitem(4520) < 1){ mes "You don't have all the Items."; mes "Here is the list from the Note again."; next; mes "^cc000050x Poison Bottle"; mes "250x Bravery Bagde "; mes "250x Valor Badge"; mes "3000x Special Exhange Ticket"; mes "and 1x Leak Card.^000000"; close; } else { mes "^0000FF[ Bryce ]^000000"; mes "Ok thanks for the items."; delitem 678, 50; // Poison Bottle delitem 7828, 250; // Bravery Badge delitem 7829, 250; // Valor Badge delitem 6153, 3000 // Special Exhange Ticket delitem 4520, 1; // Leak Card next; mes "^0000FF[ Bryce ]^000000"; mes "....."; mes "Something is happening"; next; mes "....."; next; mes "^0000FF[ Bryce ]^000000"; mes "Who dares to disturb my Rest and awaken me!!."; setnpcdisplay("Dead Bryce",980); sleep2 5000; next; mes "^0000FF[ Bryce ]^000000"; mes "Arrrgggghhh.."; next; mes "My body is transforming into monster again.."; setnpcdisplay("Dead Bryce",999); mes "^0000FF[ Bryce ]^000000"; mes "You will die for this.."; close; killmonsterall "1@ma_b"; donpcevent "Room of Life::OnEnable"; end; } } } // Room of Life // ====================================== 1@ma_b,1,1,0 script Room of Life 66,{ OnEnable: enablenpc "Room of Life"; set .MyMobs,1; monster "1@ma_b",64,88,"Pugde the Butcher",3000,1,"Room of Life::OnMyMobDead"; end; OnDisable: killmonsterall "1@ma_b"; disablenpc "Room of Life"; end; OnMyMobDead: set .MyMobs,.MyMobs-1; if (.MyMobs < 1) { announce " "strcharinfo(0)+" has successfully in Exterminate the Horrible Butcher, Pudge.",bc_all; sleep2 3000; announce " "strcharinfo(0)+" Legendary Dead Bryce is Asleep for 3 Days.",bc_all; donpcevent "Room of Life::OnDisable"; set BaseExp,+160000; set JobExp,+100000; set helped1,gettimetick(2); setnpcdisplay("Dead Rodz",849); warp "dicastes01",193,173; for( set .@a,0; .@a < getarraysize( .Reward ); set .@a,.@a + 2 ){ getitem .Reward[.@a],.Reward[.@a+1], $@partymemberaid[.@i]; } dispbottom "Pudge Extermination Quest will be available again in 3 days after you kill Pudge"; warp "dicastes01",193,173; } end; } its working now, i just removed the rewards and set npc name, and added "break" on the cases... thanks

9/10 the minus points because of the background xD, i always encounter that background almost everywhere xD

wow, a Club on forums does it have requirements.?

there's an error somewhere in this line setarray .Reward[0], 607,10, // Reward 1 + Amount 608,5, // Reward 2 + Amount 501,3, // etc...... 512,1; // Last Reward 1 ( Max. ~64 Items )

can you explain this to me.. if(gettimetick(2) - helped1 < (60 * 60 * 20)) { i want it every 3 days xD

ok, i will test it 1st and see what happens..

I want to request an npc that.. After talking to him with some story line and with the required item(s) or/and zeny after 5 - 10 seconds A monster will be summoned... in the 1st five seconds that Monster will shout in that map like.. "RAWR, who dares to enter my sacred Dungeon!?" 2nd 5-10 seconds "Prepare to be Pulverize!?" and then the monster will be summon and after killing it... there's an announce bc all that tells "(Custom Monster Name) has been Exterminated!" and Those who are in that map will be warped back to town or somewhere else... thanks in advance

if im include my map to that tables, it will not turn right? ill try it

is it possible to disable moving camera/angle in a certain map?

- script Anne -1,{ OnInit: disablenpc "Anne Curtis"; end; OnClock0600: OnClock1800: enablenpc "Anne Curtis"; Hyrule,190,214,5 script Anne Curtis 465,{ if( pudge ) { warp "dewata",232,53; announce " "+strcharinfo(0)+": has been warped to Pain's Six Paths Dungeon!!",bc_all; end; } if( countitem(6048) >= 20 && countitem(7078) >= 5 && countitem(6153) >= 1000) { delitem 6048,20; delitem 7078,5; delitem 6153,1000; set pudge, 1; warp "dewata",232,53; announce " "+strcharinfo(0)+": has been warped to !!",bc_all; } else { warp "dicastes01",210,168; dispbottom "ee"; } end; } is that right? >.< bump bump... bump

oh i see..thanks

even spr only? its not possible?

how to make npc show up when its Night or Day mode?