[Need help on get array size]

^ it's a "for loop"

 

http://rathena.org/wiki/Loops

[need assistance please]

patching kRO doesnt mean that it will overwrite your main grf file. 

[Script load on login / logout]

^You want every players below group id  lvl 99 to have a temporary group of 99 upon login?

[An Unhandled win32 exception occured in JoshRO.exe(1212) Please help me]

crashing when you right click on items. I assume that you're missing their images (collection).

[The Purchase has failed because the NPC does not exist.]

you can revert back to the previous svn even without your backup. My backup are patches for my modified src only

[How do i get rid of this security code?]

You need the mouse freedom dll files. You may also check your setup.exe blueghost or the opensetup, there must be an option for the mouse cursor.

[The Purchase has failed because the NPC does not exist.]

True. Since i have my backup patch for my src edits and mods, i even tried removing them all to have a clean and unmodiffied src. But unfortunately still the same. Reverting back to the previous svn will temp fix it. 

[Script load on login / logout]

^ Would it also have the same effect if the player got disconnected instead of logging out?

 

Yes.

[Guild-Creating NPC]

strcharinfo(2)  http://rathena.org/wiki/Strcharinfo

and

countitem  http://rathena.org/wiki/Countitem

 

for guild name check if exist http://rathena.org/board/topic/78958-check-guild-if-already-exist/

[PVP Ladder]

Maybe he copied the exact "<tab>" word 

[Need Help with SuperPlayer NPC]

yes, better dont use the adjgroup command. because it will be reset upon using the Char Select.

[[Warning]: clif_parse: Received unsupported packet]

Are you using the cash shop feature?

[change to normal damage]

choose wether you want the pre-re emp or renewal. so find and replace them from mob_db or mob_db_re.

[Editor Release: Server Monitor]

oh yeah! linux compatible thanks!

[Adding Costume Garment, Costume Shield, Costume Shoes, Costume Accessory]

I think they're called EQP_SHADOW and already included in the src but currently disabled

 

"Shadow equip slots will be left disabled until client's supporting them are usable" - [Rytech]

[Where to modify the server's rates]

For Experience rates, modify this \trunk\conf\battle\exp.conf <global exp

 

for drop rates, \trunk\conf\battle\drops.conf <global drop

 

\trunk\db\mob_item_ratio.txt < if you want a more customized drop per item and mob

[reload on click]

and if the npc was unloaded, where can you possibly click to load it again?

 

edit: Oh, it's a reload. sorry 

 

or just @reloadnpc <path_to_npc>/npc.txt

 

will include every npc inside the script includiing the duplicates if the clicking option is client side only.

[Help with Freebies]

http://pastebin.com/KwmTHpTd

 

 

I just forgot to put back the setarray for your item list. 

[Help with Freebies]

yoona Yes, I've modified it again. I forgot and I've edited this part :

 query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip);
    query_sql("SELECT last_ip, account_id FROM `freebies`", .@freebiesip, .@accid);
 
    if (.@lastip == .@freebiesip) || (.@accid == getcharid(3))

You can try the above post again. 

[Help with Freebies]

please post your script.

 

or try this, because the above post is quite messy XD

prontera,168,184,3	script	Freebies	479,{
    mes .NPC$;
    mes "Wanna get the freebies " +strcharinfo(0)+ "?";
    next;
    if (select("Yes:No") - 1) close;
    mes .NPC$;
    mes "Let me check if you are really a new member";
    next;

    query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip);
    query_sql("SELECT last_ip, account_id FROM `freebies`", .@freebiesip, .@accid);

    if (.@lastip == .@freebiesip) || (.@accid == getcharid(3))
    {
            mes .NPC$;
            mes "You already got the freebies " +strcharinfo(0);
            end;
    }

mes .NPC$; mes "Okay, take these...";
next;

query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + escape_sql(getcharip()) + "')");

for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 )
     {
     getitem .freebie_item[.@x], .quantity[.@x];
     }
end; 

OnInit:
set .NPC$, "[ " +strnpcinfo(1)+ " ]";
setarray .freebie_item[0],30316,30315,30314,30027,30028,30029,30030,4302,4403,7227,30499,671,2629,2630,4140;
setarray .quantity[0],1,1,1,1,1,1,1,1,1,1000,1,1000,2,2,4; waitingroom "Freebies Here",0;
end;
} 

 

 

[Help with Freebies]

prontera,168,184,3<TAB>script<TAB>Freebies<TAB>479,{
mes .NPC$;
mes "Wanna get the freebies " +strcharinfo(0)+ "?";
next;
if (select("Yes:No") - 1) close;
mes .NPC$;
mes "Let me check if you are really a new member";
next;

query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip);
query_sql("SELECT last_ip, account_id FROM `freebies`", .@freebiesip, .@accid);

if (.@lastip == .@freebiesip) || (.@accid == getcharid(3))
{
mes .NPC$;
mes "You already got the freebies " +strcharinfo(0);
end;
}

mes .NPC$; mes "Okay, take these...";
next;

query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + escape_sql(getcharip()) + "')"); for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 )
{
getitem .freebie_item[.@x], .quantity[.@x];
}
end; 

OnInit:
set .NPC$, "[ " +strnpcinfo(1)+ " ]";
.freebie_item[0],30316,30315,30314,30027,30028,30029,30030,4302,4403,7227,30499,671,2629,2630,4140; setarray .quantity[0],1,1,1,1,1,1,1,1,1,1000,1,1000,2,2,4; waitingroom "Freebies Here",0;
end;
}

 

It duplicates because you dont have an account ID check. it wont really insert not unless you'll use "update".

 

I assume that your player have changed IP, so he/she was able to get another freebie item, unfortunately, his/her account_id was already registered. That's why it produced an error for duplicating  an existing row using the account id which is your freebie's primary key.

 

And also try this sql

 

CREATE TABLE IF NOT EXISTS `freebies` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL default '0',
  `name` varchar(23) NOT NULL default '',
  `last_ip` varchar(15) NOT NULL,
  PRIMARY KEY (`account_id`),
  KEY (`id`)
) ENGINE=MyISAM;

--------------------------------------------------------------------------------------------------------

 

And BTW, this:

query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lastip + "')"); 

will only save the first numbers before the period. Like for example "127.0.0.1", it will only save "127"

 

So I Suggest you to use this instead:

query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + escape_sql(getcharip()) + "')");

[+1 per Refiner 100% / and de-refiner]

You can use Sir Emistry's Refine Function Script +  from other working Derefiner script

 

http://pastebin.com/raw.php?i=g8W9yhSs

prontera,79,129,5    script    test    757,{
mes "Refiner and Refine Remover";
next;
switch (select("+1 Refiner","Refine Remover"))
       {
case 1:
            mes "Which equipment you want to refine ?";
            mes "make sure you have equipped the items and at least 1 Lotto Ball No.4.";
            next;
            callfunc( "RefineFunc",7364 ,1,63,0,10,1,0,100 );
            end;
case 2:
            setarray .@ItemID[0],7363,1;
            mes "Which equipment you want to reomove the refine?";
            mes "make sure you have equipped the items and at least 1 Lotto Ball No.3.";
            next;
            if( countitem( .@ItemID[0] ) >= .@ItemID[1] ){
                   for( set .@i,1; .@i <= 10; set .@i,.@i + 1 )
                    set .@Menu$,.@Menu$ + (( getequipid(.@i) > 0 && getequiprefinerycnt(.@i) )? getitemname(getequipid(.@i)):"" )+":";
                    set .@i,select(.@Menu$);
                    setarray .@GetData[0],getequipid(.@i),getequipcardid(.@i,0),getequipcardid(.@i,1),getequipcardid(.@i,2),getequipcardid(.@i,3);
                    failedrefitem .@i;
                    delitem .@ItemID[0],.@ItemID[1];
                    getitem2 .@GetData[0],1,1,0,0,.@GetData[1],.@GetData[2],.@GetData[3],.@GetData[4];
                    equip .@GetData[0];
                    mes "Done.";
                   }
           end;
        }
        }

[[ Load ] Pls Help!]

try 

 

warp "SavePoint",0,0;

[Command /w]

make sure you have enabled this when you diff your client.

Sir Emistry I think you've forgotten to include what he must include when diffing XD

[r17402 - rAthena Renewal battle support and major battle/skill system overhaul!]

Hey i have a problem when i am yousing svn update ist says skiping and that was it -.-

You have a modified source I assume. Please post it under Support Section.