SQL Script: Autolearn Skill [Freya]

http://www.megaupload.com/?d=OX7OXDNE

Remover Créditos Na Hora de Copilar

L2_GameServer/java/com/l2jserver/gameserver/network/ clientpackets/EnterWorld.java


Sairia assim:

activeChar.sendMessage(getText("VGhpcyBzZXJ2ZXIgdXNlcyBMMkosIGEgcHJvamVjdCBmb3VuZGVkIGJ5IEwyQ2hlZg==\ n"));

activeChar.sendMessage(getText("YW5kIGRldmVsb3BlZCBieSB0aGUgTDJKIERldiBUZWFtIGF0IGwyanNlcnZlci5jb20=\ n"));

activeChar.sendMessage(getText("This server uses L2J, a project founded by L2Chef"));
activeChar.sendMessage(getText("and developed by the L2J Dev Team at l2jserver.com"));



Linhas Original:


sendPacket(new SystemMessage(SystemMessageId.WELCOME_TO_LINEAGE));

activeChar.sendMessage(getText("VGhpcyBzZXJ2ZXIgdXNlcyBMMkosIGEgcHJvamVjdCBmb3VuZGVkIGJ5IEwyQ2hlZg==\n"));
activeChar.sendMessage(getText("YW5kIGRldmVsb3BlZCBieSB0aGUgTDJKIERldiBUZWFtIGF0IGwyanNlcnZlci5jb20=\n"));

if (Config.DISPLAY_SERVER_VERSION)
{
if (Config.SERVER_VERSION != null)
activeChar.sendMessage(getText("TDJKIFNlcnZlciBWZXJzaW9uOg==")+" "+Config.SERVER_VERSION);

if (Config.DATAPACK_VERSION != null)
activeChar.sendMessage(getText("TDJKIERhdGFwYWNrIFZlcnNpb246")+" "+Config.DATAPACK_VERSION);
}
activeChar.sendMessage(getText("Q29weXJpZ2h0IDIwMDQtMjAxMA==\n"));

SevenSigns.getInstance().sendCurrentPeriodMsg(activeChar);
Announcements.getInstance().showAnnouncements(activeChar);


Deixe elas assim ou apague ambas:

//activeChar.sendMessage(getText("VGhpcyBzZXJ2ZXIgdXNlcyBMMkosIGEgcHJvamVjdCBmb3VuZGVkIGJ5IEwyQ2hlZg==\n"));
//activeChar.sendMessage(getText("YW5kIGRldmVsb3BlZCBieSB0aGUgTDJKIERldiBUZWFtIGF0IGwyanNlcnZlci5jb20=\n"));

//if (Config.DISPLAY_SERVER_VERSION)
//{
// if (Config.SERVER_VERSION != null)
// activeChar.sendMessage(getText("TDJKIFNlcnZlciBWZXJzaW9uOg==")+" "+Config.SERVER_VERSION);

// if (Config.DATAPACK_VERSION != null)
// activeChar.sendMessage(getText("TDJKIERhdGFwYWNrIFZlcnNpb246")+" "+Config.DATAPACK_VERSION);
//}
//activeChar.sendMessage(getText("Q29weXJpZ2h0IDIwMDQtMjAxMA==\n"));

Antes de Copilar va no arquivo build.xml

Apague a linha :

               <exec dir="." executable="svnversion" outputproperty="l2j.revision" failifexecutionfails="false">

SQL Script: Char Nascer Top No-Grade

Credits: mathuza@gmail.com
All claims are reserved, please stay the credits!
Report the Leechers    
This table allows yoo to define what items
should players receive upon character creation,
depending on the class they choose.


http://www.megaupload.com/?d=81OANGCN

NPC: GM-Shop [Freya]

http://www.megaupload.com/?d=JPOI4ALP

Credits: mathuza@gmail.com 

NPC: Vip Teleports [Freya]

VIP Teleports

Download:
http://www.megaupload.com/?d=I178TOW7


English

1) Find the file, scripts.cfg inside your "gameserver\data ", open it with notepad and add this at the end of the file:  teleports/711_VIPTeleporters/__init__.py    after this save.
2) copy and paste all "data" folder, inside your gameserver.
3) Add the sql into your database.

En Español

1) Encuentra el archivo, scripts.cfg dentro de tu "gameserver\data ", abrelo con notepad. añade al final la siguiente linea:   teleports/711_VIPTeleporters/__init__.py       después salva el archivo.  
2) copia la carpeta "data" dentro de tu Gameserver.
3) Añade el Sql a tu base de datos.

Em Portugues

1) Encontre o arquivo, cript.cfg dentro da pasta "gameserver\data", abre ele com notepad. Adicione ao final a seguinte linha:  teleports/711_VIPTeleporters/__init__.py
Depois salve o arquivo.
2) Copia a pasta "data" para dentro da pasta Gameserver.
3) Adicione o Sql ao seu banco de dados.

 Credits: mathuza@gmail.com

 adaptation Freya: mathuza@gmail.com

 All claims are reserved, please stay the credits!

 Report the Leechers

SQL Script: Deletar Char Inativo

3 Meses

DELETE FROM characters WHERE lastAccess < 466560000;
DELETE FROM accounts WHERE lastactive < 466560000;

1 Mes

DELETE FROM characters WHERE lastAccess < 155520000;
DELETE FROM character_quests WHERE char_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM items WHERE owner_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_shortcuts WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_skills_save WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);
DELETE FROM character_subclasses WHERE char_obj_id=(SELECT obj_id FROM characters WHERE lastAccess < 155520000);

Pre-Configurado L2jS

ATENÇAO!!!  NAO POSTE ESSE PACK EM OUTRA COMUNIDADE!

Caracteristicas:

NPCs:

• GK Global
• GM Shop(Com mais de 2 mil Itens)
• NPC Augment
• NPC Nobless
• Scheme Buffer
• Rank [PvP/PK/Adena/Olympiad etc...]
• Special-Shop
• [VIP] Teleporter [Farm ZONE ESPECIAL]

FARM:

Drop de moeda especial para compra de itens no GM Shop

• 5 Zonas Farm
• 1 Peace Zone Farm
• 1 Zona Farm Com Teleport Especial

Atençao: Adicionar drops aos mobs da area Party Farm.

EVENTOS:

• Tvt, DM, Hitman, LM, Instance Event e Evento de Natal!

CUSTOM

• Cloak Castles
• Tatoos

MISC

• PvP Reward System
• PvP Color System
• Pvp/pk Announces

Pré-Configurado
http://www.4shared.com/file/UXAhsbeo/FreyaL2jSPre-Configurado_by_ma.html

Backup
http://www.4shared.com/file/gRjxa9Nj/backup.html

Patch
http://www.4shared.com/file/KXx-IWbc/patch.html


Screenshots

IDs:

Pre-Configurado by [mathuza]

========================================================
NPCs
========================================================

958 - GK
70028 - Scheme Buffer
10002 - GM Shop
45632 - Special Shop
32615 - Ishuma
303001 - Augment
999999 - Nobless
31049 - Symbol Maker
30086 - Taurin
711 - Special Teleporters
70027 - Rank

========================================================
ID Coins
========================================================

Gold - 5962
Silver - 5961
Bronze - 5963

========================================================
Apigas
========================================================

Event Apiga - 14720
Event Golden Apiga - 14721
#Golden Apiga - 9143
#Apiga - 9142

========================================================
Misc
========================================================

GOld Bar - 3470
Adena - 57
Bottle of Freya's Soul - 16027
Freya's Gift - 17138
O-Stick - 13248

========================================================
Cloaks
========================================================

64000, Cloak of Aden
64001, Cloak of Dion
64002, Cloak of Giran
64003, Cloak of Gludio
64004, Cloak of Goddard
64005, Cloak of Innadril
64006, Cloak of Oren
64007, Cloak of Rune
64008, Cloak of Schuttgart

========================================================
Tattoo
========================================================

45010, Tattoo of Resolve
45011, Tattoo of Power
45012, Tattoo of Fire
45013, Tattoo of Flame
45014, Tattoo of Bravery
45015, Tattoo of Barrier
45016, Tattoo of Blood
45017, Tattoo of Absolute
45018, Tattoo of Soul
45019, Tattoo of Avadon
45020, Tattoo of Doom
45021, Tattoo of Assassin
45022, Tattoo of Evasion - Accuracy
45023, Tattoo of Magic

Creditos:

L2jS
mathuza@hotmail.com

Rev: L2jS
NPCs: mathuza, MaxCheaters e L2jS
Pre-Configurado: Mathuza