RafaelxD~
Membro-
Total de itens
533 -
Registro em
-
Última visita
Sobre RafaelxD~
RafaelxD~'s Achievements
Aprendiz de Novato (1/14)
2
Reputação
-
SET @dt = 40; DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) > @dt; DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters); DELETE FROM account_data WHERE account_name NOT IN (SELECT login FROM accounts); DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts); DELETE FROM character_friends WHERE char_id NOT IN (SELECT charId FROM characters); DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM character_quests WHERE char_id NOT IN (SELECT charId FROM characters); DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT charId FROM characters); DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId FROM characters); DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT charId FROM characters)); DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data); DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT charId FROM characters); DELETE FROM augmentations WHERE item_id NOT IN (SELECT item_id FROM items); UPDATE characters SET clanid=0,title="",clan_privs=0 where clanid NOT IN (SELECT clan_id FROM clan_data); UPDATE clanhall SET ownerID=0,paidUntil=0 where ownerID NOT IN (SELECT clan_id FROM clan_data); DE NADA! :)
-
Galera.. Estava sofrendo ataques.. mais o firewall conseguil barrar.. só q depois dos ataques fiquem com um problemão Ligo o login server e aparece isso, segue a foto: Como resolvo isso?? to quebrando a cabeça aqui e não vai. Só consigo parar esse erro.. se eu colocar ele pra rodar com 7gb.. menos q isso ele da esse error.. e mesmo eu colocando 7gb.. qndo eu vo no game.. clico em logar.. demora um ano pra logar Obs: meio sem logica o login server trabalhar com 7gb.. Ajuda ae.. vlws!
-
Galera.. pra dedicado Windows 2008 64 bits precisa de navicat pra 64 bits? ou o normal server? vlw
-
L2jTeon- Interlude Pessoal.. Estou com um problemão.. Quando a pessoa fica parado muito tempo ela toma disconect.. alguem tem ideia do q pode ser? Vlwsss
-
Hum.. mais tipow.. tem gente q joga em casa.. tem nd haver com a lan e ta com esse problema :x
-
Mais cara.. Tem gente q desde que eu estreiei o server, não levo nenhum disconect mais tem gente q leva de 10 em 10 min (as vezes menos) Estranho :x
-
Então.. a msgem q aparece no game server e q foram desconectados olha a print: A questão da memória do gameserver.. eu almente.. tava baixa antes.. creio q n seja isso e o limite de players tbm n.. pq tanto com 70 player acontece isso como tbm com 130 ON e tipo.. uma galera ta levando disconect outras não Troquei a system, almentei a memória.. n sei mais oq fazer :x Obrigadoo
-
L2jTeon - Interlude Pessoal.. to com um problemão.. coloquei meu server ON.. mais todo mundo ta levando disconect.. loga.. fica uns 10 ~ 20 min e toma disconect.. o q pode ser? Dedicado: * Intel Core2Quad Q9300 * 8gb DDR3 * Windows 2008 Standard R2 (64 bit) * 500GB SATA2 * Uplink Port Speed 100mbps * IP Addresses 8 IPs Configuração do game server: @echo off title L2JTeon: Game Server Console :start echo Starting L2JTeon Game Server. echo Visit L2JTeon.servergame.com for updates. echo. REM ------------------------------------------------------------------------ REM #======================================================================# REM # You need to set here your JDK/JRE params in case of x64 bits System. # REM # Remove the "REM" after set PATH variable # REM # If you're not a x64 system user just leave # REM #======================================================================# REM set PATH="type here your path to java jdk/jre (including bin folder)" REM ------------------------------------------------------------------------ REM ------------------------------------- REM Default parameters for a basic server. java -Dfile.encoding=UTF-8 -Xmx7168m -cp bsf.jar;bsh-engine.jar;bsh-2.0b5.jar;mmocore.jar;javolution.jar;c3p0-0.9.1.2.jar;mysql-connector-java-5.1.6-bin.jar;l2jteon.jar;jython.jar;jython-engine.jar;commons-logging-1.1.jar;java-engine.jar net.sf.l2j.gameserver.GameServer REM REM If you have a big server and lots of memory, you could experiment for example with REM java -server -Xmx7168m -Xms5120m -Xmn3072m -XX:PermSize=256m -XX:SurvivorRatio=8 -Xnoclassgc -XX:+AggressiveOpts REM ------------------------------------- if ERRORLEVEL 2 goto restart if ERRORLEVEL 1 goto error goto end :restart echo. echo Administrator Restarted ... echo. goto start :error echo. echo GameServer Terminated Abnormaly, Please Verify Your Files. echo. :end echo. echo GameServer Terminated. echo. pause Login server: @echo off title L2JTeon: Login Server Console :start echo Starting L2JTeon Login Server. echo. java -Dfile.encoding=UTF-8 -Xmx4072m -cp javolution.jar;mmocore.jar;c3p0-0.9.1.2.jar;mysql-connector-java-5.1.6-bin.jar;l2jteon.jar net.sf.l2j.loginserver.L2LoginServer if ERRORLEVEL 2 goto restart if ERRORLEVEL 1 goto error goto end :restart echo. echo Admin Restarted ... echo. goto start :error echo. echo LoginServer terminated abnormaly echo. :end echo. echo LoginServer terminated echo. pause Thread # ================================================================= # Threads configuration - Take care changing this # ================================================================= #Default 10, 13 ThreadPoolSizeEffects = 10 ThreadPoolSizeGeneral = 13 #Default 2 UrgentPacketThreadCoreSize = 4 #Default 4 GeneralPacketThreadCoreSize = 8 #Default 4 GeneralThreadCoreSize = 8 #Default 6 AiMaxThread = 12 Ajuda ae plz :(
-
Consegui, desculpa.. pode fechar :x
-
Na verdade queria saber se é possivel em l2j .. :D vlws
-
É possivel ? Obrigado
-
Consegui, quem quiser me manda MP podem fechar o tópico! Obrigado
-
@lovepako aqui esta: itemname-e 9945 AIO Blade * AIO Blade Special Dualsword for AIO Buffers, Increase casting speed by 60%, Double healing spells effectiveness, Increase MP regen by 10000%, Decrease reuse delay by 1000%, Increase Max MP by 1125%, Increase attack speed by 55%. -1 0 0 0 weapongrp 0 9945 1 1 6 1 0 LineageWeapons.sirr_blade_m00_wp LineageWeaponsTex.sirr_blade_t00_wp LineageWeaponsTex.sirr_blade_t00_wp LineageWeaponsTex.sirr_blade_t00_wp icon.weapon_sirr_blade_i00 icon.weapon_sirr_blade_i00 icon.weapon_sirr_blade_i00 -1 1300 47 0 0 14 3 2 LineageWeapons.sirr_blade_m00_wp LineageWeapons.sirr_blade_m00_wp 2 LineageWeaponsTex.sirr_blade_t00_wp LineageWeaponsTex.sirr_blade_t00_wp 4 ItemSound.public_sword_shing_8 ItemSound.sword_great_4 ItemSound.sword_mid_2 ItemSound.public_sword_shing_4 ItemSound.itemequip_dualsword 10 361 137 8 5 8 0 0 0 0 325 0 1 1 1000 0 1 0 LineageEffect.w_vari_b4_004_a LineageEffect.w_vari_b4_004_a 5.000000 0.000000 0.000000 5.000000 0.000000 0.000000 1.000000 1.000000 1.000000 1.000000 LineageWeapons.rangesample LineageWeapons.rangesample 2.100000 1.400000 1.400000 2.100000 1.400000 1.400000 9.500000 -0.500000 0.000000 9.500000 -0.500000 0.000000 -1 -1 -1 -1 Env [EnvSetup] IsClock=true StartTime=12 TimeRatio=6 SKYBOX=SkybackgroundColor ;HazeRingÀÇ °¹¼ö¸¦ Á¤ÇÒ¼ö ÀÖÀ½ ;NumHazeringColor=°¹¼ö ;Hazering1=ÅؽºÃÄÀ̸§ ;-> HAZERING=HazeRing_Final ;CloudÀÇ °¹¼ö¸¦ Á¤ÇÒ¼ö ÀÖÀ½ ;NumCloudColor=°¹¼ö ;Cloud1=ÅؽºÃÄÀ̸§ ;Cloud2=ÅؽºÃÄÀ̸§.... ;-> NumCloudColor=3 CLOUD1=Cloud_Final Cloud2=StarField_Final01 Cloud3=StarField_Final02 ShadowTick=0.1 StaticLightingAdjust=4 SlopeSunAngle=30 SubLightNum=0 TimeEnvFileNum=4 TimeEnvFileName0=TimeEnv0.INT TimeEnvFileName1=TimeEnv1.INT TimeEnvFileName2=TimeEnv2.INT TimeEnvFileName3=TimeEnv3.INT [TerrainShadowMap] Num=8 AutoTimeGeneration=true [ActorStaticLight] Num=8 [bSPSunLight] Num=8 [WIND] DefaultWind=true Area=(X1=0,Y1=0,X2=0,Y2=0) Direction=(X=0,Y=1) Speed=48 Accel=4 [FOG] ;1.0=2000unit StartRange1=1.0 StartRange2=1.5 StartRange3=2.0 StartRange4=2.5 StartRange5=4.0 EndRange1=4.0 EndRange2=5.0 EndRange3=6.0 EndRange4=7.0 EndRange5=10.0 FogSpeed=1 [WaterVolume] WaterVolumeFogColor=(R=39,G=87,B=126) WaterVolumeFogStart=200 WaterVolumeFogEnd=3000 WaterVolumeCellophaneColor=(a=128,R=45,G=121,B=117) ;WaterVolumeCellophaneColor=(a=100,R=64,G=136,B=147) [EnchantEffect] CubeTexName=LineageEffectsTextures.Etc.Enchant_Aura001_Shader01 HeroWeaponTex=LineageEffectsTextures.Hero.Hero_Aura001_Shader01 HeroAuraTex=LineageEffectsTextures.Hero.Hero_Aura000_Shader00 HeroAuraMesh=LineageWeapons.rangesample EnchantMeshShow=4 EnchantEffectShow=5 Enchant0=(R1=0,G1=10,B1=20,R2=0,G2=0,B2=30,Opacity=0.1,Num=0.1) Enchant1=(R1=0,G1=50,B1=180,R2=0,G2=44,B2=155,Opacity=1.2,Num=0.9) Enchant2=(R1=0,G1=40,B1=200,R2=0,G2=43,B2=170,Opacity=1.3,Num=1) Enchant3=(R1=0,G1=30,B1=220,R2=0,G2=42,B2=185,Opacity=1.4,Num=1) Enchant4=(R1=0,G1=30,B1=130,R2=0,G2=41,B2=100,Opacity=0.2,Num=0.1) Enchant5=(R1=0,G1=30,B1=140,R2=0,G2=40,B2=135,Opacity=0.2,Num=0.5) Enchant6=(R1=80,G1=20,B1=20,R2=60,G2=10,B2=0,Opacity=0.4,Num=0.6) Enchant7=(R1=90,G1=10,B1=10,R2=70,G2=0,B2=0,Opacity=0.5,Num=0.7) Enchant8=(R1=100,G1=0,B1=0,R2=90,G2=0,B2=0,Opacity=0.6,Num=0.8) Enchant9=(R1=110,G1=0,B1=0,R2=100,G2=0,B2=0,Opacity=0.7,Num=0.9) Enchant10=(R1=120,G1=0,B1=0,R2=110,G2=0,B2=0,Opacity=0.7,Num=1) Enchant11=(R1=100,G1=80,B1=5,R2=80,G2=70,B2=10,Opacity=0.5,Num=1) Enchant12=(R1=120,G1=90,B1=1,R2=110,G2=80,B2=10,Opacity=0.5,Num=1) Enchant13=(R1=140,G1=100,B1=10,R2=120,G2=90,B2=20,Opacity=0.6,Num=1) Enchant14=(R1=160,G1=110,B1=20,R2=130,G2=100,B2=30,Opacity=0.6,Num=1.1) Enchant15=(R1=180,G1=120,B1=30,R2=140,G2=110,B2=40,Opacity=0.7,Num=1.2) Enchant16=(R1=120,G1=70,B1=85,R2=120,G2=80,B2=95,Opacity=0.7,Num=1) Enchant17=(R1=120,G1=70,B1=110,R2=140,G2=80,B2=120,Opacity=0.8,Num=1) Enchant18=(R1=125,G1=60,B1=130,R2=145,G2=70,B2=140,Opacity=0.9,Num=1) Enchant19=(R1=100,G1=50,B1=145,R2=120,G2=50,B2=165,Opacity=1,Num=2) Enchant20=(R1=100,G1=30,B1=155,R2=140,G2=140,B2=140,Opacity=1.1,Num=2) Enchant21=(R1=150,G1=150,B1=150,R2=100,G2=100,B2=100,Opacity=1.2,Num=3) Enchant22=(R1=155,G1=155,B1=155,R2=10,G2=20,B2=155,Opacity=1.2,Num=3) Enchant23=(R1=155,G1=155,B1=155,R2=10,G2=155,B2=50,Opacity=1.2,Num=3) Enchant24=(R1=155,G1=155,B1=155,R2=155,G2=155,B2=70,Opacity=1.2,Num=3) Enchant25=(R1=155,G1=155,B1=155,R2=155,G2=45,B2=140,Opacity=1.2,Num=3) Enchant100=(R1=225,G1=90,B1=230,R2=220,G2=80,B2=255,Opacity=1,Num=1) Enchant=(R1=140,G1=30,B1=30,R2=40,G2=110,B2=110,Opacity=1.3,Num=3) [Variation] Enchant0=(R1=10,G1=15,B1=25,R2=20,G2=25,B2=35,Opacity=1,Num=1) Enchant1=(R1=10,G1=15,B1=25,R2=20,G2=25,B2=35,Opacity=1,Num=1) Enchant2=(R1=10,G1=15,B1=25,R2=20,G2=25,B2=35,Opacity=1,Num=1) Enchant3=(R1=10,G1=15,B1=25,R2=20,G2=25,B2=35,Opacity=1,Num=1) Enchant4=(R1=0,G1=10,B1=100,R2=0,G2=21,B2=80,Opacity=1,Num=1) Enchant5=(R1=0,G1=10,B1=130,R2=0,G2=21,B2=110,Opacity=1,Num=1) Enchant6=(R1=70,G1=65,B1=60,R2=105,G2=70,B2=55,Opacity=1,Num=1) Enchant7=(R1=75,G1=50,B1=45,R2=99,G2=60,B2=45,Opacity=1,Num=1) Enchant8=(R1=80,G1=40,B1=35,R2=99,G2=50,B2=35,Opacity=1,Num=1) Enchant9=(R1=85,G1=30,B1=23,R2=99,G2=45,B2=25,Opacity=1,Num=1) Enchant10=(R1=90,G1=25,B1=20,R2=104,G2=39,B2=22,Opacity=1,Num=1) Enchant11=(R1=90,G1=75,B1=5,R2=70,G2=60,B2=6,Opacity=1.1,Num=1.1) Enchant12=(R1=95,G1=70,B1=7,R2=75,G2=55,B2=8,Opacity=1.1,Num=1.1) Enchant13=(R1=110,G1=79,B1=10,R2=90,G2=67,B2=10,Opacity=1.1,Num=1.2) Enchant14=(R1=120,G1=89,B1=20,R2=100,G2=77,B2=20,Opacity=1.1,Num=1.2) Enchant15=(R1=130,G1=99,B1=30,R2=110,G2=87,B2=30,Opacity=1.1,Num=1.2) Enchant16=(R1=85,G1=55,B1=70,R2=94,G2=65,B2=80,Opacity=1.2,Num=1.3) Enchant17=(R1=90,G1=50,B1=80,R2=97,G2=65,B2=90,Opacity=1.2,Num=1.4) Enchant18=(R1=95,G1=45,B1=90,R2=100,G2=55,B2=85,Opacity=1.2,Num=1.5) Enchant19=(R1=87,G1=40,B1=115,R2=80,G2=40,B2=100,Opacity=1.2,Num=1.6) Enchant20=(R1=84,G1=40,B1=120,R2=90,G2=90,B2=90,Opacity=1.2,Num=1.7) Enchant21=(R1=90,G1=90,B1=90,R2=115,G2=115,B2=115,Opacity=1.3,Num=1.8) Enchant22=(R1=90,G1=90,B1=90,R2=5,G2=15,B2=95,Opacity=1.3,Num=1.9) Enchant23=(R1=90,G1=90,B1=90,R2=5,G2=95,B2=15,Opacity=1.3,Num=1.9) Enchant24=(R1=90,G1=90,B1=90,R2=115,G2=115,B2=15,Opacity=1.3,Num=1.9) Enchant25=(R1=90,G1=90,B1=90,R2=115,G2=20,B2=115,Opacity=1.3,Num=1.9) Enchant=(R1=130,G1=30,B1=30,R2=20,G2=80,B2=80,Opacity=1,Num=1) ;[s0] means postprocessing off ; Shader0: glow A [s1] ; GLOW Glow=true Glowtype=2 Luminance=0 MiddleGray=0 WhiteCutoff=0 Threshold=0 RGBCutoff=0.993 BloomScale=4 FinalBlendOpacity=64 FinalBlendBlurType=2 ; HDR Hdr=false Gray=0.6 FinalCoef=3.5 ExpBase=0.98 ExpCoef=30 ClampMin=0.25 ClampMax=0.75 ; Shader1: glow B [s2] ; GLOW Glow=true Glowtype=2 Luminance=0 MiddleGray=0 WhiteCutoff=0 Threshold=0 RGBCutoff=0.993 BloomScale=6 FinalBlendOpacity=96 FinalBlendBlurType=2 ; HDR Hdr=false Gray=0.68 FinalCoef=3.2 ExpBase=0.96 ExpCoef=30 ClampMin=0.2 ClampMax=0.8 ; Shader2: HDR A [s3] ; GLOW Glow=true Glowtype=2 Luminance=0 MiddleGray=0 WhiteCutoff=0 Threshold=0 RGBCutoff=0.995 BloomScale=5 FinalBlendOpacity=32 FinalBlendBlurType=2 ; HDR Hdr=true Gray=0.68 FinalCoef=3.2 ExpBase=0.96 ExpCoef=30 ClampMin=0.2 ClampMax=0.8 ; Shader3: HDR B [s4] ; GLOW Glow=true Glowtype=2 Luminance=0 MiddleGray=0 WhiteCutoff=0 Threshold=0 RGBCutoff=0.994 BloomScale=5 FinalBlendOpacity=48 FinalBlendBlurType=2 ; HDR Hdr=true Gray=0.65 FinalCoef=3.7 ExpBase=0.96 ExpCoef=30 ClampMin=0.20 ClampMax=0.8 ; Shader4: HDR C [s5] ; GLOW Glow=true Glowtype=2 Luminance=0 MiddleGray=0 WhiteCutoff=0 Threshold=0 RGBCutoff=0.993 BloomScale=5 FinalBlendOpacity=64 FinalBlendBlurType=2 ; HDR Hdr=true Gray=0.65 FinalCoef=4 ExpBase=0.96 ExpCoef=30 ClampMin=0.18 ClampMax=0.8
-
hum.. bem pensado.. vo dar uma olhada.. qualquer coisa posto aqui!! abraço
-
Pessoal, Como fazer para deixar a dual brilhando mesmo estando +0? Desse jeito: Obs: quero o brilho +0 só nessa dual, não em todas as armas +0 Obrigado
-
Atualizações Recentes de Status
-
Por favor, compartilhe a fonte da versão revisada do Orion. Obrigado.· 0 respostas
please...
-
The Event - Team vs Team· 0 respostas
The Event - Team vs Team
The event cannot be terminated when participating in the event.
The event does not end.
The event starts and does not end after teleporting.
Please tell me how. Please.
Even if the event is held for 2 minutes, it will not end.
I don't know how to proceed...