[SQL Script Question]

Hi Scripting Pros,

 

is it possible to use this query on a script?

 

 

SELECT COUNT(account_id) AS OnlinePlayers FROM char WHERE online=1;
 

 

I will be using it for some script that checks the online player count

 

Thanks to those who will help.

[Safety Wall Error on 20120525]

Hi,

I am not quite sure why safety wall is causing errors on my client. can't find a fix but I am quite sure that safety wall is causing the error.

No Errors encountered with effects off and safety wall but when the effects are turned on and you die near a safety wall the client crashes.

[Weird Error on my CP]

Notice: Trying to get property of non-object in /usr/html/asd/vote/modules/main/preprocess.php on line 86 Fatal error: Call to a member function get() on a non-object in /usr/html/asd/vote/modules/main/preprocess.php on line 86

 

[Guild Error]

Encountered error on guild.

No Errors on Console.

 

when I try to create guild via /guild and alt+g it says guildname already exists. no guilds yet, just a configured this a while ago and I am the only one on the server no other accounts yet

 

fixed it found these on the packet_db

 

0x014d,2,guildcheckmaster,0
0x014e,6
0x014f,6,guildrequestinfo,2
0x0150,110
0x0151,6,guildrequestemblem,2
0x0152,-1
0x0153,-1,guildchangeemblem,2:4
0x0154,-1
0x0155,-1,guildchangememberposition,2:4
0x0156,-1
0x0157,6
0x0158,-1
0x0159,54,guildleave,2:6:10:14
0x015a,66
0x015b,54,guildexpulsion,2:6:10:14
0x015c,90
0x015d,42,guildbreak,2
0x015e,6
0x015f,42
0x0160,-1
0x0161,-1,guildchangepositioninfo,2:4
0x0162,-1
0x0163,-1
0x0164,-1
0x0165,30,createguild,2:6
0x0166,-1
0x0167,3
0x0168,14,guildinvite,2:6:10
0x0169,3
0x016a,30
0x016b,10,guildreplyinvite,2:6
0x016c,43
0x016d,14
0x016e,186,guildchangenotice,2:6:66
0x016f,182
0x0170,14,guildrequestalliance,2:6:10
0x0171,30
0x0172,10,guildreplyalliance,2:6
0x0173,3
0x0174,-1
0x0175,6
0x0176,106
0x0177,-1
 

added it to what i am using

 

[AsuraHosting Free 1 Week Trial]

could the current customers get the free too or not?

[Flux CP Help]

oh thanks mootie

[Flux CP Help]

Hi,

how do I remove this from account registration?

 

 

I tried some few stuff but didn't work.

[Looking for This Scripts]

Hi Everyone, I am looking for the following scripts. any leads that are related to them will be of help

be it paid scripts or not. thanks

 

 

- Malaya Port iRO Offical Full Quests Script
- WoE Update: Hall of the Abyss iRO Offical Full Quest Script & Systems
- Many new custom skills, premium skills and rebalance skills for Ninja, Gunslinger, Taekwon Kid & Taekwon Master.

[【 Emistry © 2015 】E-Scripts Collection]

Thanks I'll be trying it for later

[【 Emistry © 2015 】E-Scripts Collection]

should i change it here?

 

 

if( getgmlevel() < .LowGMLvl )
    for( set .@i,0; .@i < getarraysize( .Map$ ); set .@i,.@i + 2 )
        if( strcharinfo(3) == .Map$[.@i] )    RestrictJob( atoi( .Map$[.@i+1] ) );
 

 

[【 Emistry © 2015 】E-Scripts Collection]

im trying to make it instead of restricting job classes from entering a map, it restricts based on character base level, is that possible. not trying to do something against the rules though.

[【 Emistry © 2015 】E-Scripts Collection]

Hi Emistry,

 

I have been attempting to edit your class restriction into a level restriction, but apparently i haven't been successful, could you help me out? TIA.

[Need Help w/ My Script. ( SQL )]

yes, i managed to find the error on my own customization

[Need Help w/ My Script. ( SQL )]

i found what was causing it to malfunction although i haven't been able to post it soon as i can since rathena was down

[Need Help w/ My Script. ( SQL )]

Hi, I hope somebody could help me. I revamped the Promotional Code Script of Arzzae I managed to make it work but unfortunately it only accepts numerical codes, if you made an alphanumeric code the script will accept it but it won't give you the items and will lead you to the Promo Code Panel.

 

 

[SQL Script Support]

so far what i have is this. i am making a custom referal system though, its for harmony servers only.

 

 

 

query_sql("SELECT `last_mac` FROM `login` WHERE `account_id`="+getcharid(3), .@mac$);
set .@hours,1;
query_sql "insert into rfs values ( "+ getcharid(3) +", "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ escape_sql(  .@mac$ ) +"', "+ .@hours +" ) on duplicate key update hours = hours + "+ .@hours;
 

[SQL Script Support]

Hi Everybody,

 

I got another question on sql scripting.

 

I want to get a value from the login db, and add it to another db. so would this work?

 

set @nb, query_sql("select last_mac from `login` , @last_mac$);

[Street Mall Shops ( All in One NPC )]

did anybody of you change the script? and how is it not working? 

[Item Decompose and 2 types Guarantee refine ticket system]

See. I told you you'd get positive comments. Great Job icabit

[Item Decompose and 2 types Guarantee refine ticket system]

interesting. keep it up icabit

[1 vs 1 WoE]

hmm can this be used with euphy's woe controller?

[✰ Euphy's Scripts ✰]

@Euphy can i request something about the mission_huntings quest?

[Rikimaru's Cargo Quest Help]

how do i make this script that the player(questor) will talk to all the cargo/mimics before he finishes the quest? as of now you only need to talk to one then it is finished and you have to wait for 24hrs before you can do it aagain.

//		//=====//	 /==/	 /==/		  /==/	  
//	   //	 //	 /==/	 /==/  /=/	 /==/		
//	  //=====//			  /==/  /=/			 /==============/	 /========/   /==//===/	/==/	 /==/
//	 //=//////	/==/	  /==//=/	   /==/	/==/==/==/==/==/	 /	 /  /   /==/		 /==/	 /==/
//	// ==		/==/	  /==//=/	   /==/	/==/  /==/  /==/	 ======/  /   /==/		 /==/	 /==/
//   //   ==	  /==/	  /==/  /=/	 /==/	/==/  /==/  /==/	 / /===/  /   /==/		 /==/	 /==/
//  //	 ==	/==/	  /==/   /=/	/==/	/==/  /==/  /==/	 / /===/  /   /==/		 /==/=====/==/
// //	   ==  /==/	  /==/	/=/   /==/	/==/  /==/  /==/	 /========/   /==/		 /==///////==/
// ================ rAthena Script ==================================================
// ============== Information =======================================================
// = iRO Daily Quest : Alberta Cargo
// = Made by :
// = Rikimaru
//===== Current Version: ===============================================
//= 1.1
//===== Compatible With: ===============================================
//= any rAthena SVN
//===== Description: ===================================================
//= The iRO Daily Quest : Alberta Cargo
//= Usefull for having fun in a Server with a Mini Quest
//= Has a counter of 24 Hours until the Players can do the Quest agian.
//===== Additional Comments: ===========================================
//= 1.0 Finished Scripting the Quest [Rikimaru]
//= 1.1 Fixed a little Bug [Rikimaru]
//======================================================================
//============== DO NOT REMOVE MY CREDITS AND CLAIM MY WORK AS YOURS ===
alberta,105,52,3	script	[Quest] Port Manager	855,{
set .@npcname$,"^0000FF[ [Quest] Port Manager ]^000000";
if(gettimetick(2) - carfingor < (60 * 60 * 24)) {
mes .@npcname$;
mes "I'm sorry but you have to wait";
mes "24 Hours until you can do the Quest again!";
close;
}
if(qcargo6==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
getitem 502,5;
getitem 503,10;
getitem 504,10;
getitem 505,10;
getitem 608,1;
set BaseExp,+1046821;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo6,0;
close;
}
if(qcargo5==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
getitem 502,5;
getitem 503,10;
getitem 504,10;
getitem 505,10;
set BaseExp,+565471;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo5,0;
close;
}
if(qcargo4==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
getitem 502,5;
getitem 503,10;
getitem 504,10;
set BaseExp,+178601;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo4,0;
close;
}
if(qcargo3==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
getitem 502,5;
getitem 503,10;
set BaseExp,+18293;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo3,0;
close;
}
if(qcargo2==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
getitem 502,5;
set BaseExp,+1642;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo2,0;
close;
}
if(qcargo1==1) {
mes .@npcname$;
mes "Congrats!";
getitem 501,20;
set BaseExp,+142;
set cquest,0;
set carfingor,gettimetick(2);
set qcargo1,0;
close;
}
if(BaseLevel >= 98) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [6]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [6] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
if(BaseLevel >= 81 && BaseLevel <=97) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [5]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [5] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
if(BaseLevel >= 61 && BaseLevel <=80) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [4]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [4] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
if(BaseLevel >= 41 && BaseLevel <=60) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [3]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [3] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
if(BaseLevel >= 21 && BaseLevel <=40) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [2]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [2] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
if(BaseLevel >= 1 && BaseLevel <=20) {
mes .@npcname$;
mes "Hello "+strcharinfo(0)+",";
mes "do you want to accept the Job?";
next;
switch(select("Yes,sure:No,sorry:Cancel")) {
case 1:
mes .@npcname$;
mes "Awesome,find the Deadly Cargo [1]";
mes "and bring it to me,and you'll";
mes "get a reward.";
next;
mes .@npcname$;
mes "The Deadly Cargo [1] is somewhere";
set cquest,1;
mes "here in Alberta!";
close;
case 2:
mes .@npcname$;
mes "Okay goodbye!";
close;
case 3:
close;
}
}
mes .@npcname$;
mes "........";
close;
}
// ========================= End of the first NPC =================================================
alberta,186,174,3	script	Deadly Cargo [1]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [1] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo1,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
alberta,232,103,3	script	Deadly Cargo [2]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [2] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo2,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
alberta,247,90,3	script	Deadly Cargo [3]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [3] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo3,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
alberta,247,67,3	script	Deadly Cargo [4]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [4] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo4,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
alberta,245,43,3	script	Deadly Cargo [5]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [5] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo5,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
alberta,123,227,3	script	Deadly Cargo [6]	1191,{
set .@npcname$,"^FF0000[ Deadly Cargo [6] ]^000000";
if(cquest==1) {
mes .@npcname$;
mes "Go back to the Port Manager!";
set qcargo6,1;
close;
}
mes .@npcname$;
mes "........";
close;
}
// =============================== End of all the NPC's =========================================
// ====================== Have fun with this Script. Yours ~ Rikimaru ===========================

[Scripting Question]

Hi, I don't know if this has been asked before, but is there anyway that we could get the mob level via script?

will this be possible

strmobinfo(3,killedrid)

Sorry, Solved this by using

( getmonsterinfo( killedrid,1 )

[SQL Script support]

Thanks Annie. this will help alot, im currently improving my know how on sql scripts.