Leaderboard

Translated iteminfo/cskroption.lub (Lua_Project: Revision 272) w/ additional item translations (2011~2012++ items) for 2012-04-18 RagexeRE Clients & up (Sakray) 2012-07-10 Ragexe Clients & up (Main) ■Updates -Initial Realease: Translated malangdo/ bio labs 4 & vellum weapons (rev1) -Update #1: Added translations for some armors/shield/footgears/garments (rev2) -Update #2: Added translations for more weapons/sealed cards and malangdo related stuffs (rev3) -Update #3: Major Cleanup; Added/Translated/Updated/Reworked usable items & more (rev4) -Update #4: Translated Uprade Items/Metal Weapons/Costume Items & etc (rev 5) -Update #5: Merged items up to 03/21/2013, Etc item revamp, Tanos Weapons, bunch of official non-kRO items & more (rev 6) Read the Changelog.txt for more info ■Downloads -cskroption beta 1.rar -cskroption beta 2.rar -cskroption rev 3.rar -cskroption rev4.rar -cskroption rev5.rar -cskroption rev6.rar ■Notes: -Translations for new items(kRO) which are not yet translated in English on any official RO are "Google Translated" which are reworked and rephrased by me (to the best of my knowledge). -This also applies on official non-kRO items from aRO,bRO,cRO,jRO,ruRO,twRO which are not present on any English Server -Also note that many official item descriptions were modified/reworked bec. of official grammatical errors (we all know that) ■Credits: -Lua Project Team members -& all ■Pls visit my post here if you have time... (maybe you can help me.) kindly spare a sec and give me a click if you find my work somewhat helpful or useful.

Hello i am Leinadz, Im expert about files programming using C++ and Pascal. READ THIS I can see other people having a problem in decrypting their GRF especially if you forgot to backup your GRF and accidentally encrypt it, then they can't find a way to Decrypt it. So i made my own program that has GRF Encryptor/Decryptor and Client Profile Configuration that only your client can read your Encrypted GRF. Im Developing it right now because i only started today making this program. The concept of this program is still weird and ugly because im only testing my GRF file to be encrypt. But if everything i finalize , then i will start designing my Program . ENCRYPTING GRF I will try to encrypt pal1.grf. This will be the result if GRF Extractor will view the Encrypted GRF. DECRYPTING GRF 1. Ok, ill try to Decrypt the Encrypted Pal1.grf What will i add to my program? GUI ( To put buttons , designs, and etc in my Program to make the program more easier to use ) Client Profile Configuration ( That only your client can be able to read your Encrypted GRF ) Speed Encryption Anti-crack Encrypt Patch files ( Such as Spr files , Act files , Lub files , and other files from Data folder) Then thats it PLS.. FEEDBACK

A quick mod [paste=4zf2yxj5yh7q] You didn't specify the base level to change Lord Knight or Rune Knight (non trans) > Rune Knight (trans) so it's still 99

http://paradox924x.com/eAthena/Chosen%20One/Skins/

http://rathena.org/wiki/Setcell

Hello any pro scripter here, hope you can guide me whats wrong with this Guild Pack Info npc. I already execute the SQL "guildpack_guild" and "guildpack_members" and still the players with same IP will be able to obtain them. Following is the current script. // http://rathena.org/board/topic/78517-guild-pack-information-giver/ /*//========================================================== CREATE TABLE IF NOT EXISTS `guildpack_guilds` ( `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `guild_name` VARCHAR(24) NOT NULL DEFAULT '', `master_char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `master_name` VARCHAR(24) NOT NULL DEFAULT '', `redeem_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`guild_id`) ) ENGINE=MYISAM; CREATE TABLE IF NOT EXISTS `guildpack_members` ( `guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name` VARCHAR(30) NOT NULL DEFAULT '', `ip` VARCHAR(15) NOT NULL DEFAULT '', PRIMARY KEY (`guild_id`,`char_id`), KEY `guild_id` (`guild_id`) ) ENGINE=MYISAM; //==========================================================*/ prontera,155,188,0 script Guild Pack Info 910,{ switch(select( (countitem(21001)?"I have a GM's Approval Card":"") + ":Guild List")) { case 1: // exchanging a GM's Approval Card (21001) mes "[Guild Pack Info]"; if (!getcharid(2)) { mes "^FF0000You must be in a guild to receive a guild package.^000000"; close; } else if (getcharid(0) != getguildmasterid(getcharid(2))) { mes "Please tell your guild leader ^0000FF"+getguildmaster(getcharid(2))+"^000000 to come and see me personally."; close; } else if (countitem(21001) < 1) { mes "^FF0000You don't have a GM's Approval Card to exchange.^000000"; close; } // check if guild has 10 members query_sql "SELECT char_id,account_id,`name` FROM guild_member WHERE guild_id="+getcharid(2), .@char_id,.@account_id,.@name$; if (getarraysize(.@char_id) < .guild_size) { mes "You must have ^FF0000"+.guild_size+"^000000 guild members"; mes "(1 leader + "+(.guild_size-1)+" members)."; close; } // check if all guild members are online for (set .@i,0; .@i<.guild_size; set .@i,.@i+1) { if (!isloggedin(.@account_id[.@i], .@char_id[.@i])) { mes "^FF0000"+ .@name$[.@i] +"^000000 is offline."; mes "All "+.guild_size+" guild members must be online to receive the guild package."; close; } } // check if any guild members have ALREADY obtained a guild package if (query_sql("SELECT `name`,guild_name FROM guildpack_members " + "LEFT JOIN guildpack_guilds ON guildpack_members.guild_id=guildpack_guilds.guild_id " + "WHERE account_id IN (SELECT account_id FROM guild_member WHERE guild_id="+getcharid(2)+") LIMIT 1", .@name$,.@guild$) > 0) { mes "^0000FF"+.@name$+"^FF0000 already received a guild pack while in ^0000FF"+.@guild$+"^000000."; mes "Each account can only receive a guild pack once."; close; } mes "Exchange GM's Approval Card for Guild Pack?"; if (select("No:Yes, continue") == 1) close; // #SUCCESS - passed all checks delitem 21001,1; for (set .@i,0; .@i<.guild_size; set .@i,.@i+1) { if (.@account_id[.@i] == playerattached()) { getitem 21010,1; // leader } else { getitem 21011,1, .@account_id[.@i]; // each member } } announce "Guild Pack Info : the guild ["+ strcharinfo(2) +"] has obtain a guild package.", bc_all|bc_blue; // record guild query_sql "INSERT INTO guildpack_guilds (guild_id,guild_name,master_char_id,master_name,redeem_time) VALUES " + "("+getcharid(2)+",'"+escape_sql(strcharinfo(2))+"', "+getcharid(0)+",'"+escape_sql(strcharinfo(0))+"', NOW())"; // record all guild members query_sql "INSERT INTO guildpack_members(guild_id,account_id,char_id,`name`,ip) " + "SELECT guild_id,guild_member.account_id,char_id,`name`,last_ip FROM guild_member " + "LEFT JOIN login ON guild_member.account_id=login.account_id " + "WHERE guild_id="+getcharid(2); break; case 2: // Guild List // get list of guilds query_sql "SELECT guild_id,guild_name FROM guildpack_guilds ORDER BY guild_name ASC", .@guild_id,.@guild_name$; mes "[Guild Pack Info]"; if (getarraysize(.@guild_id) == 0) { mes "No guilds have received a guild pack."; close; } for (set .@i,0; .@i<getarraysize(.@guild_id); set .@i,.@i+1) set .@menu$, .@menu$ + .@guild_name$[.@i]+":"; // pick a guild set .@GID, .@guild_id[set(.@g,select(.@menu$)-1)]; // get info for that guild query_sql "SELECT guildpack_members.char_id, CONCAT(IF(ISNULL(guild_member.char_id),'^FF0000','^008000')," + "guildpack_members.`name`), ip FROM guildpack_members " + "LEFT JOIN guildpack_guilds ON guildpack_members.guild_id=guildpack_guilds.guild_id " + "LEFT JOIN guild_member ON guildpack_members.char_id=guild_member.char_id AND guildpack_members.guild_id=guild_member.guild_id " + "WHERE guildpack_members.guild_id="+.@GID+" " + "ORDER BY (guildpack_members.char_id=master_char_id) DESC", .@char_id, .@colored_name$, .@ip$; // display guild info mes "Guild : " + .@guild_name$[.@g]; mes "Status : " + (query_sql("SELECT 1 FROM guild WHERE guild_id="+.@GID,.@i) ? "^008000Active" : "^FF0000Disbanded") + "^000000"; mes "Leader : "+.@colored_name$[0]+"^000000 ("+.@ip$[0]+")"; mes "Members :"; for (set .@i,1; .@i<getarraysize(.@char_id); set .@i,.@i+1) mes " "+(.@i+1)+". "+.@colored_name$[.@i]+"^000000 ("+.@ip$[.@i]+")"; break; } close; OnInit: set .guild_size, 10; if (query_sql("SHOW TABLES LIKE 'guildpack_guilds'", .@t$) == 0) { debugmes "[Guild Pack Info]: SQL table `guildpack_guilds` not found! Disabling npc."; disablenpc strnpcinfo(3); } else if (query_sql("SHOW TABLES LIKE 'guildpack_members'", .@t$) == 0) { debugmes "[Guild Pack Info]: SQL table `guildpack_members` not found! Disabling npc."; disablenpc strnpcinfo(3); } end; } Help please, any~~ ><

File Name: Pack Guild pt_BR File Submitter: Envolvents File Submitted: 03 Dec 2013 File Category: Utilities Content Author: Envolvents Hi, providing again one of my toys i've ever used, script language in portuguese brazil, translate for your language. configuration: // ======================================================// Mapa onde o NPC ficaráprontera,150,150,3 script Pack Guild 404,{// = Configuraçao:// = Titulo do NPC set .npc$,"^9EB449[ PACK GUILD ]^000000";// = Máximo de Peso para receber o Pack Guild set .@max,70;// = Itens dados separados por Vírgulas "," Ex: 607,608; setarray .@packitem[0],607,608,609,610,611,612,613,614,615,616,617,618,619,620; setarray .@qtd[0],1,1,1,1,1,1,1,1,1,1,1,1,1,1;// = Checando Guild query_sql "SELECT `char_id`,`guild_id` FROM `guild_pack_take` WHERE `char_id` = '"+getcharid(0)+"'",.@RID,.@GIDT; query_sql "SELECT `guild_id`,`name`,`master`,`permissao`,`qtd_itens` FROM `guild_pack` WHERE `guild_id` = '"+getcharid(2)+"'",.GIDC,.NAMEC$,.MASTERC$,.PERMC,.QTD2;// = Condições if(getgmlevel() > 90) goto L_GM; // Nível para GM/ADM if(agitcheck()) goto L_WOE; // Checando de a WOE no momento if(!getcharid(2)) goto NOGUILD; // Se sem guild if(!.PERMC) goto NO_PERM; // Se não permitido pelo adm if((.PERMC == 1) && (.MASTERC$ != strcharinfo(0))) goto NO_PERM2; // Se permitido pelo ADM if(.MASTERC$ == strcharinfo(0)) goto MENU_MASTER; // Se for o Dono da guild passa para o Menu Master// = Fim da Configuraçao, nao meixa na configuraçao abaixo!// ====================================================== Table SQL: CREATE TABLE IF NOT EXISTS `guild_pack`(`guild_id` int(11) NOT NULL DEFAULT '0',`name` VARCHAR(32) NOT NULL,`master` VARCHAR(32) NOT NULL,`qtd_membros` int(11) NOT NULL DEFAULT '0',`permissao` int(11) NOT NULL DEFAULT '0',`qtd_itens` int(11) NOT NULL DEFAULT '0')CREATE TABLE IF NOT EXISTS `guild_pack_take`(`guild_id` int(11) NOT NULL DEFAULT '0',`char_id` int(11) NOT NULL DEFAULT '0') enjoy babys. Click here to download this file