Ir para conteúdo
  • Cadastre-se

RafaelxD~

Membro
  • Total de itens

    533
  • Registro em

  • Última visita

Sobre RafaelxD~

RafaelxD~'s Achievements

Aprendiz de Novato

Aprendiz de Novato (1/14)

2

Reputação

  1. 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! :)
  2. 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!
  3. Galera.. pra dedicado Windows 2008 64 bits precisa de navicat pra 64 bits? ou o normal server? vlw
  4. 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
  5. Hum.. mais tipow.. tem gente q joga em casa.. tem nd haver com a lan e ta com esse problema :x
  6. 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
  7. 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
  8. 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 :(
  9. Consegui, desculpa.. pode fechar :x
  10. Na verdade queria saber se é possivel em l2j .. :D vlws
  11. Consegui, quem quiser me manda MP podem fechar o tópico! Obrigado
  12. @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
  13. hum.. bem pensado.. vo dar uma olhada.. qualquer coisa posto aqui!! abraço
  14. 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
×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.