Jump to content

nasagnilac

Members
  • Posts

    232
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by nasagnilac

  1. OnCheck: deletearray .@acc[0], getarraysize(.@acc); deletearray .@char[0], getarraysize(.@char); for(set .@i,0; .@i<=25; set .@i,.@i+1){ query_sql("SELECT account_id,char_id FROM `guild_member` WHERE guild_id = '"+.@guild+"'", .@acc, .@char); } for(set .@j,0; .@j<getarraysize(.@acc); set .@j,.@j+1){ if (isloggedin(.@acc[.@j],.@char[.@j])) { query_sql("SELECT last_ip FROM `guild_member` WHERE account_id = '"+.@acc[.@j]+"'",.@ip1); query_sql("SELECT last_ip FROM `guild_package` WHERE account_id = '"+.@acc[.@j]+"'",.@ip2); if(.@ip1 == .@ip2){ message rid2name(.@acc[.@j]),"Sorry but you can't cheat on this system."; } set .@members,.@members+1; } } sleep 2; return; here is the code.. I just want a limit on the query... the query must detect only 1 last_ip. Example: I got 2 players in one shop.. number 1 and number 2 both of them has a same last_ip and same guild..what I want is if number 1 is the first listed on the query then number 2 can not be listed to the query because number 1 is already listed.. I hope some will share..
  2. Hello guys I got an Idea but dont know how to start... well I got this kind of shop. My idea is example: player has already bought 1 item from that kind of shop and the price or the amount that you spend will become cashpoints. example pirate dagger worth 30 prestige gold coin... he/she will receive that item by pressing the buy button and he will also receive 30 cashpoints. please help..
  3. HI Im just having a problem with my script - script Donate -1,{ setarray .@DonateItems[0], 5518, 5518, 25000; setarray .@DonateAmount[0], 1, 1, 100; OnInit: bindatcmd "reward","Donate::OnDoDonate",100,100; end; OnDoDonate: input $@email$; query_sql "SELECT `userid` FROM `login` WHERE `email` = '$@email$'",$@userid$; if (!$@email$) {dispbottom "The email is invalid."; end;} for( set .@i, 0; .@i < getarraysize(.@DonateItems); set .@i, .@i + 1 ){ query_sql("INSERT INTO `rewardaccountnpc` ('account_id', 'reward_id' , 'reward_amount') VALUES ('$@userid$','.@DonateItems[.@i]','.@DonateAmount[.@i]')"); } } When Im going to put the email [email protected].. I got this kind of error... what is the problem?
  4. prontera,147,167,4 script Prophet 705,{ //-------------------------------------------- set .@mz, 2000000000; set .@n$, "[Prophet]"; //-------------------------------------------- //-------------------------------------------- if($Invade == 1){ mes .@n$; mes "MvP Invasion is now Activated."; mes "Get ready for the MvP Invasion and it will start at 12 midnight."; mes "You have only 1 day to eliminate them all."; close; } mes .@n$; mes "Balance : "+(.@mz - $donate)+"z"; mes "Donated : "+$donate+"z"; next; switch( select("Donate","What is MvP Invasion?","Nevermind") ) { case 1: input .@amt,0,.@mz; if ( .@amt == 0 ) { next; mes .@n$; mes "^FF0000Invalid input...^000000"; close; } if ( .@amt > Zeny ) { next; mes .@n$; mes "^FF0000You have insufficient amount of Zeny on hand.^000000"; close; } set Zeny, Zeny - .@amt; set $donate, $donate + .@amt; next; if($donate >= .@mz){ mes .@n$; mes "Donated : "+$donate+"z"; donpcevent "Invasion::OnInvasion"; set $donate,0; close; } mes .@n$; mes "Donated : "+$donate+"z"; close; case 2: mes .@n$; mes "MvP Invasion will be activated if the whole midgard reach the amount of donation needed. Announcement will be held at the same time that donation is completed. All MvP monster will be summoned in morroc town at 12mn and will last a day."; close; case 4: mes .@n$; mes "As you wish."; mes "See you later."; close; } } - script Invasion -1,{ OnInvasion: //-------------------------------------------- set $Invade,1; //-------------------------------------------- announce "Prophet: MvP Invasion is now Activated",0; sleep2 10000; announce "Prophet: Get ready for the MvP Invasion and it will start at 12 midnight.",0; sleep2 10000; announce "Prophet: You have only 1 day to eliminate them all.",0; end; OnClock0000: goto invade; invade: if($invade == 1){ set $invade,0; donpcevent "Invasion::OnStart"; announce "Citizen of Morroc: We are invaded by MvP Monsters Please help us!!",0; }else{ killmonsterall "morocc",1; } end; OnStart: monster "morocc",0,0,"Amon Ra",1511,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Assassin Cross Eremes",1647,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Atroce",1785,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"White Lady",1630,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Baphomet",1039,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Beelzebub",1873,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Boitata",2068,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Dark Lord",1272,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Detale",1719,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Doppelganger",1046,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Dracula",1389,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Drake",1112,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Eddga",1115,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Evil Snake Lord",1418,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Fallen Bishop Hibram",1871,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Garm",1252,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Gloom Under Night",1768,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Golden Thief Bug",1086,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Gopinich",1885,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"High Priest Magaleta",1649,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"High Wizard Katrinn",1651,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Ifrit",1832,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Incantation Samurai",1492,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Kiel D-01",1734,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Stormy Knight",1251,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Ktullanux",1779,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Lady Tanee",1688,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Lord Knight Seyren",1646,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Lord of Death",1373,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Maya",1147,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Mistress",1059,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Moonlight Flower",1150,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Nidhoggr's Shadow",2022,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Orc Hero",1087,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Orc Lord",1190,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Osiris",1038,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Pharaoh",1157,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Phreeoni",1159,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"RSX-0806",1623,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Sniper Cecil",1650,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Tao Gunka",1583,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Thanatos",1708,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Turtle General",1312,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Valkyrie Randgris",1751,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Vesper",1685,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Whitesmith Howard",1648,3,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Wounded Morroc",1917,1,"Invasion::OnMyMobDead"; monster "morocc",0,0,"Egnigem Cenia",1658,3,"Invasion::OnMyMobDead"; end; OnMyMobDead: announce "Citizen of Morroc: Thank you ["+strcharinfo(0)+"] for helping us!",0; end; } //-------------------------------------------- morocc mapflag monster_noteleport //-------------------------------------------- Hi guyss.. I need some edit on my script.. I want some changes first is when I complete the 2b zeny donation the invasion will start instead of waiting for 12nn and will end after 24 hours.. second is the set of monster will be on array type.. and 3rd is on OnMyMobDead: player name and monster name will be announced.. example: Citizen of Morroc: Thank you player for eliminating baphomet.. I hope someone is willing to share...
  5. hi euphy can you add mac address detector in you Euphy's WOE Controller....instead of using ip add why dont you add mac address for harmony user.. thanks in advance.. or can disable autotrade in getting the rewards
  6. Anyone can fix this? here is the link of the old post.. its very useful if its going to work good.... and what if it can also detect mac address if ever you have a harmony.. http://rathena.org/board/topic/83540-guild-package90-working-need-to-fix-and-enhance/
  7. thanks emistry its not working on me because of .@acc_id I just edit it and works fine... here... query_sql( "SELECT `accountid`, `reward_id`, `reward_amount` FROM `rewardaccountnpc` ",.@acc_id$,.@reward_id,.@reward_amount ); .@size = getarraysize( .@acc_id$ ); for( .@i = 0; .@i < .@size; .@i++ ) set .@menu$,.@menu$ +" "+getitemname( .@reward_id[.@i] ) + " x " + .@reward_amount[.@i] + ":"; .@i = select( .@menu$ ) - 1; getitem .@reward_id[.@i],.@reward_amount[.@i]; query_sql "DELETE FROM `rewardaccountnpc` WHERE `accountid`='"+.@acc_id$+"',`reward_amount`=`"+.@reward_id[.@i]+"`,`reward_id`=`"+.@reward_amount[.@i]+"`"; my problem now is... it doesn't delete the item in the sql.. here is the sql DROP TABLE IF EXISTS `ragnarok`.`rewardaccountnpc`; CREATE TABLE `ragnarok`.`rewardaccountnpc` ( `accountid` tinytext NOT NULL, `reward_id` int(11) NOT NULL, `reward_amount` int(11) NOT NULL, KEY `accountid` (`accountid`(32)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  8. query_sql "SELECT `accountid`, `reward_id`, `reward_amount` FROM `rewardaccountnpc`", .@show_name$, .@show_item, .@show_amount; for(set @i, 0; @i < getarraysize(.@show_name$); set @i, @i+1){ } getitem .@show_item[@i],.@show_amount[@i]; Hi.. anyone can help me arrange this script.. I just want to make a menu just like this .... The menu will show list of items from query and the query_sql will automaticaly delete the item on menu once it was gathered.
×
×
  • Create New...