Patskie

Unload mo ung npc na nag trtrigger sa pm na yan. @_@

SQL : Execute this on your database : SELECT CONCAT(`char`.`name`, " has item ", `inventory`.`nameid`) "Character Name" FROM `inventory` JOIN `char` ON `inventory`.`char_id` = `char`.`char_id` WHERE `inventory`.`nameid` = '2301'; Change 2301 to whatever item id you wishes to look for. Note also that this is only for inventory. Storage, auction, mail etc. is a different story.

Maybe setup your server, client, website and database?

Automatically your FluxCP recognize who are the GM on your server base on your login table found in your database.

I think a mere script cannot do all of these

Mag add ka ng users sa database mo ( username : root, host : localhost ). Tapos grant privileges mo ung user na ginawa mo.

This is an incomplete sample of your link : prontera,150,150,0 script Sample 100,{ if ( getgmlevel() < .level ) end; mes .npc$; mes "What can i do for you?"; next; switch(select("Account Data:IP Tracker:Nothing")) { case 1: mes .npc$; mes "Input the name of character"; next; input @name$; query_sql "SELECT `group_id` FROM `login` JOIN `char` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`name` ='" +escape_sql(@name$)+ "'",@is_staff; if (@is_staff == 0) { mes .npc$; mes @name$+ " is not a staff on this server"; close; } query_sql "SELECT `login`.`account_id`, `userid` , `user_pass`, `sex` , `email` , `group_id` , `lastlogin` FROM `login` JOIN `char` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`name` ='" +escape_sql(@name$)+ "'",@aid,@u$,@up$,@s$,@e$,@gid,@ll$; mes .npc$; mes "The account information of " +@name$+ " are as follows : "; next; mes "Account ID : " +@aid; mes "Account Username : " +@u$; mes "Password : " +@up$; mes "Gender : " +@s$; mes "E-Mail : " +@e$; mes "Group ID : " +@gid; mes "Last Login : " +@ll$; break; case 2: mes .npc$; mes "Tracker Report :"; mes "=============================="; query_sql "SELECT `userid`, `lastlogin`, `last_ip` FROM `login` WHERE `group_id` != '0'", @user$, @login$, @lastIP$; for ( set .@i, 0; .@i < getarraysize(@user$); set .@i, .@i + 1 ) { mes "Login : " +@user$[.@i]; mes "Date/Time : " +@login$[.@i]; mes "IP Address : " +@lastIP$[.@i]; mes "=============================="; } break; case 3: mes .npc$; mes "Nice to meet you " +(Sex?"sir":"maam")+ "."; break; default: break; } end; OnInit: // NPC Name set .npc$, "[ " +strnpcinfo(1)+ " ]"; // Lowest GM level to access the npc set .level, 99; end; } This npc only consists account data and IP tracker of all staffs on your server. I am a bit lazy to code the whole npc because i have many things to do right now.

What vote script are you using?

Try the following : 1. Change : if( checkvending() == 0 || checkchatting() == 1 ){ to : if( checkvending() == 0 && checkchatting() == 1 ){ since you said that player must not be in vending mode and must be in chat for 30 minutes to gain 1 cashpoint. 2. Change : } else { if( checkvending() == 0 || checkchatting() == 0){ set @Minute,@Minute + 1; if( @Minute % 60 == 0 ){ set #CASHPOINTS, #CASHPOINTS + 2; // getitem 7227,1; dispbottom "You've Been AFK for 1 hour, +1 Cash point(s) in your Balance."; set @Hour,@Hour + 1; if( @Hour % 12 == 0 ){ set #CASHPOINTS, #CASHPOINTS + 10; // getitem 14232,10; // getitem 25138,10; dispbottom "You've Been AFK for 12 hours, +1 Cash point(s) in your Balance."; } } } } to : } else if ( !checkvending() && checkidle() ) { set @Minute,@Minute + 1; if( @Minute % 60 == 0 ) { set #CASHPOINTS, #CASHPOINTS + 2; dispbottom "You've Been AFK for 1 hour, +1 Cash point(s) in your Balance."; set @Hour,@Hour + 1; if( @Hour % 12 == 0 ){ set #CASHPOINTS, #CASHPOINTS + 10; dispbottom "You've Been AFK for 12 hours, +1 Cash point(s) in your Balance."; } } } end;

Set this to true and provide some screenshots so we can be able to assist you https://github.com/calciumkid/fluxcp-renewal/blob/master/config/error.php#L12

Try changing : monster .Map$,0,0,""+ getmonsterinfo(0) +"",1950,100,strnpcinfo(0)+"::OnKilled"; to : monster .Map$,0,0,""+ getmonsterinfo(1950, 0) +"",1950,100,strnpcinfo(0)+"::OnKilled";

I think this @ping command cannot be done through script however it can be done in src. Have a check : http://rathena.org/board/topic/70818-ping-command/

Did you have the 08.mp3 on your wav folder?

http://www.nickyzai.com/?p=kro sql-files/main.sql You need to diff a RagexeRE ( any client date ). Config your mmo.h and compile. For diffing a .exe ( use Shins Diff Patcher https://subversion.assembla.com/svn/weetools/trunk/ShinsDiffPatcher/ ) This might help also to both of you : http://rathena.org/board/topic/61407-popular-requested-links/

http://www.youtube.com/watch?v=Az0C1k9AU_o

// when done set #done, 1; // Remove # if you want it to be character based announce strcharinfo(0)+ " has completed the quest!",0; // <- add

sir i think this dice event only pick number 1?? can you please check if this script is really fix? Reference : rand command switch(rand(1,4)) { Case 1: mapannounce "quiz_01","The Winner is 1",0; areawarp "quiz_01",45,81,53,59,"prontera",247,323; areawarp "quiz_01",57,81,65,59,"prontera",247,323; areawarp "quiz_01",69,81,77,59,"prontera",247,323; areawarp "quiz_01",32,94,78,86,"prontera",247,323; areawarp "quiz_01",36,85,38,82,"prontera",247,323; areawarp "quiz_01",48,85,50,82,"prontera",247,323; areawarp "quiz_01",60,85,62,82,"prontera",247,323; areawarp "quiz_01",72,85,74,82,"prontera",247,323; goto OnWinner; end; break; Case 2: mapannounce "quiz_01","The Winner is 2",0; areawarp "quiz_01",33,81,41,59,"prontera",247,323; areawarp "quiz_01",57,81,65,59,"prontera",247,323; areawarp "quiz_01",69,81,77,59,"prontera",247,323; areawarp "quiz_01",32,94,78,86,"prontera",247,323; areawarp "quiz_01",36,85,38,82,"prontera",247,323; areawarp "quiz_01",48,85,50,82,"prontera",247,323; areawarp "quiz_01",60,85,62,82,"prontera",247,323; areawarp "quiz_01",72,85,74,82,"prontera",247,323; goto OnWinner; end; break; Case 3: mapannounce "quiz_01","The Winner is 3",0; areawarp "quiz_01",45,81,53,59,"prontera",247,323; areawarp "quiz_01",33,81,41,59,"prontera",247,323; areawarp "quiz_01",69,81,77,59,"prontera",247,323; areawarp "quiz_01",32,94,78,86,"prontera",247,323; areawarp "quiz_01",36,85,38,82,"prontera",247,323; areawarp "quiz_01",48,85,50,82,"prontera",247,323; areawarp "quiz_01",60,85,62,82,"prontera",247,323; areawarp "quiz_01",72,85,74,82,"prontera",247,323; goto OnWinner; end; break; Case 4: mapannounce "quiz_01","The Winner is 4",0; areawarp "quiz_01",45,81,53,59,"prontera",247,323; areawarp "quiz_01",33,81,41,59,"prontera",247,323; areawarp "quiz_01",57,81,65,59,"prontera",247,323; areawarp "quiz_01",32,94,78,86,"prontera",247,323; areawarp "quiz_01",36,85,38,82,"prontera",247,323; areawarp "quiz_01",48,85,50,82,"prontera",247,323; areawarp "quiz_01",60,85,62,82,"prontera",247,323; areawarp "quiz_01",72,85,74,82,"prontera",247,323; goto Onwinner; end; break; }

What you mean?

db/re/item_db.txt#L4

Awesome work @Olrox

Move to script request section

This might help http://rathena.org/wiki/Custom_skill

Elaborate and explain yourself

You mean NPC's? http://www.youtube.com/watch?v=Az0C1k9AU_o

Move to script request section Try : - script Sample -1,{ OnPCLoginEvent: if ( already ) end; set SkillPoint, 0; set already, 1; end; }