kostantinosftw

maybe someone can show me how. :S

That suppose to add this skill to all NPC? or I should type them one by one?

I dont think I were clear enough. :/ I need a command which adds 1 skill to all mobs. btw this command UPDATE 'npcskills' SET skillid='23072'; it creates me an error (I mean it can't run)

which command should I type in mySQL?

1)einai diaforetika sta win7 2)and ginei unistall meso tou CD ola einai eukola meta 3)ri8mizw na kanei boot to CD alla dn ginete tpt

To 8ema einai oti dn exw ta win7 se CD kai ka8os vazw ta win2003 k prospa8w na kanw t kanw boot polly apla kanei start up xoris na ta fortonei akoma k an katisw na kanei boot to CD-DVD driver

..

bump

Merry Christmas!

GameServer: Could not store char base data: com.jdbc.mysqlDataTruncation: Data truncation: Out of range value for column 'maxHp' at row 1 otan bgenoun oi char apo to game dn sozei to lvl tous tin clan.. k.a.

bump

when a player log off it appears on GameServer Could not store char base data: com.jdbc.mysqlDataTruncation: Data truncation: Out of range value for column 'maxHp' at row 1 Ok, It doesnt work! even if I set the maxHp leght 16 or 20 or 255 it doesn't work... I still have the same error (btw if players stay IG till Server's restart it fully save them) :S

adding some staffs from old l2ia which doesnt exist and from l2 penetration, l2emp & l2 dreams doesnt make l2duke copy/paste of another l2 server. Subclasses r not going to added! (Watching an Orc with a bow or a HE Dwarf with a rod makes me feel sad...)

when a player log off it appears on GameServer Could not store char base data: com.jdbc.mysqlDataTruncation: Data truncation: Out of range value for column 'maxHp' at row 1 Ok, It doesnt work! even if I set the maxHp leght 16 or 20 or 255 it doesn't work... I still have the same error (btw if players stay IG till Server's restart it fully save them) :S

GameServer: Could not store char base data: com.jdbc.mysqlDataTruncation: Data truncation: Out of range value for column 'maxHp' at row 1 doesn't save the players location , clan , etc... after server rr how i can fix that? thanks in advance

*New dedicated (8GB RAM), WIPE 10/2/2012 17:40 +2 GMT XP Rates: x120 SP Rates: x100 Adena Rates: x350 Drop Rates: x1 Enchants Rates: Normal Enchant Rate: 65% Blessed Enchant Rate: 85% Crystal Enchant Rate: 100% Other Informations: Auto-Learn Skills. Auto Pick up. Free Quest managers. Free Subclass. --------- NPC Buffer: PP,SE,EE,WC,BD,SS. --------- GM Shop. Weapons/Armors/Jewels traders up to B grade with Adena. --------- Vote reward every 1 votes and it is 1 Star Vote. Custom title for newbies. --------- .online command. .deposit / .withdraw command. --------- PvP , PK colure system. Hero = 5000 PvPs. Clan system title. AOE skills boosted for BiG Trains. Hero Announce Login. All Level 80 characters are boosted. Custom Passive Skills. Party Duel. Auto Team VS Team. --------- Global and Newbie Gatekeepers: Raid Boss / Farm / EXP areas. Custom Farm Areas. Custom Raid Boss Areas. Special Raid Bosses Respawn Daily 24H. --------- NO Spawn protection. --------- Titanium Armor ONLY from RB. Special item to become noble. --------- Event Buffs. All Skills 99% working. Noblesse Skills 100% Working. Hero Skills 100% Working. Tattoo system 100% working. Castle Siege System 100% Working. --------- Balanced Classes. --------- Global chat. Dualbox allowed. .Unstuck Command 60 seconds. Auto sieges every saturday and sunday. --------- Augmentation System. Duel System. Hero System. --------- Walker DO NOT work. PHX protection. No Subclass bug! No warehouse or trade bug. No known bugs working at all. --------- Many more to see and explore!! http://l2horizzon.netau.net/ http://l2horizzon.pforum.biz/login

http://www.iagaming.net/ Online from 2005

Mporw me kapio tropw na dw ola ta items sunolika. px 1,000,000,000,000 adena 1,123,123,123 blue stone 213,542,342 crystals

1) 8a prepei na pas sto mySQL na vreis to table char_temp. k na kaneis edit to x y z (einai oi sidetagmenes opou 8a kanoun spawn oi char) 2)ta items p 8a emfanizode stous newbie... hmm char_temp. H' char_creat. bazeis to ID (class), to ID tou item, posa 8a emfanizode , k meta an 8a ta foraei (false/true)

How I can change icon to some items? eg "tattoo of might" to look like "might" buff thanks is advance!

..

nai kai ta ports einai sigoro oti einai anoixta! dokimasa kapia pragmata! Kai simperenw oti otan alla3w to 2106 dld tou log-in dn ginete sindesh! akoma k apo to pc p sikonei ton server me l2.ini (127.0.0.1) dn sindeete mipws prp na alla3w k tpt allo? nai!

Geia sas, epidi eixa balei tis port 7778,9014,2104 m ekana enan error k epefte to log-in mono (efoson eixa tis vasiki port gia to log-in htan eukola gia ton ka8ena na prokalesei kapoio error) Simara apofasisa na alla3w tis port se 7778,4561,2105 antistoixa. Ta port apo to 192.168.1.1 einai anoixta! Ta exw prostesei stis e3ereseis tou NOD. to firewall tou modem klisto. to firewall ton windows klisto. me diafora programmata t exw elen3ei k einai anoixta 100% tr sxetika me to log in... grafw user/pass k menei ekei (u r carently logging in) akoma k new acc dn mporw na kanw gt logika dn sindeete! Exw no-ip, Sto pc p einai o server exei sto l2.ini to 127.0.0.1 stou lan to l2.in 192.168.1.6 (tin ip dld tou pc p sikonei ton server) k gia tous upolipous tin no-ip. ps: me tis palies ri8miseis ola leitourgousan... ti mporeis na fteei? edw einai ena copy apo t gameserver # --------------------------------------------------------------------------- # Game Server Settings # --------------------------------------------------------------------------- # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # --------------------------------------------------------------------------- # Networking # --------------------------------------------------------------------------- # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname # Common settings... # 127.0.0.1 - If you are playing alone on a test server # 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect # x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server. # If this IP is resolvable by the Login Server, just leave *. # --------------------------------------------------------------------------- # Default: * ExternalHostname = myserver.no-ip.biz # --------------------------------------------------------------------------- # This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname. # This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x. # If this IP is resolvable by the Login Server, just leave *. # --------------------------------------------------------------------------- # Default: * InternalHostname = 192.168.1.6 # Where's the Login server this gameserver should connect to # Default: 127.0.0.1 LoginHost = 127.0.0.1 # TCP port the login server listen to for gameserver connection requests # Default: 9014 LoginPort = 4561 # Default: 127.0.0.1 GameserverHostname = * # Default: 7777 GameserverPort = 7778 # --------------------------------------------------------------------------- # Database # --------------------------------------------------------------------------- # Specify the appropriate driver and url for the database you're using. # Examples: # Driver = com.mysql.jdbc.Driver (default) # Driver = org.hsqldb.jdbcDriver # Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver Driver = com.mysql.jdbc.Driver # Database URL # URL = jdbc:mysql://localhost/l2jdb (default) # URL = jdbc:hsqldb:hsql://localhost/l2jdb # URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = URL = jdbc:mysql://localhost/l2jdb # Database user info (default is "root" but it's not recommended) Login = root # Database connection password Password = root # Default: 100 MaximumDbConnections = 100 # Default: 0 MaximumDbIdleTime = 0 # --------------------------------------------------------------------------- # Misc Server Settings # --------------------------------------------------------------------------- # This is the server ID that the Game Server will request. # Example: 1 = Bartz # Default: 1 RequestServerID = 1 # True = The Login Server will give an other ID to the server if the requested ID is already reserved. # Default: True AcceptAlternateID = True # Datapack root directory. # Defaults to current directory from which the server is started unless the below line is uncommented. #DatapackRoot = C:/Work/tmp/DataPack # Define how many players are allowed to play simultaneously on your server. # Default: 100 MaximumOnlineUsers = 100 # Minimum and maximum protocol revision that server allow to connect. # Warning: You must make sure that the minimum revision is always less than or equal to the maximum revision. # WARNING: <u><b><font color="red">Changing the protocol revision may result in incompatible communication and many errors in game!</font></b></u> # Default: 146 MinProtocolRevision = 146 # Minimum and maximum protocol revision that server allow to connect. # Warning: You must make sure that the minimum revision is always less than or equal to the maximum revision. # WARNING: <u><b><font color="red">Changing the protocol revision may result in incompatible communication and many errors in game!</font></b></u> # Default: 146 MaxProtocolRevision = 148 # --------------------------------------------------------------------------- # Misc Player Settings # --------------------------------------------------------------------------- # Character name template. # Examples: # CnameTemplate = [A-Z][a-z]{3,3}[A-Za-z0-9]* # The above setting will allow names with first capital letter, next three small letters, # and any letter (case insensitive) or number, like OmfgWTF1 # CnameTemplate = [A-Z][a-z]* # The above setting will allow names only of letters with first one capital, like Omfgwtf # Default .* (allows any symbol) CnameTemplate = .* # This setting restricts names players can give to their pets. # See CnameTemplate for details PetNameTemplate = .* # Maximum number of characters per account. # Default: 7 (client limit) CharMaxNumber = 7 tou login # --------------------------------------------------------------------------- # Login Server Settings # --------------------------------------------------------------------------- # This is the server configuration file. Here you can set up the connection information for your server. # This was written with the assumption that you are behind a router. # Dumbed Down Definitions... # LAN (LOCAL area network) - typically consists of computers connected to the same router as you. # WAN (WIDE area network) - typically consists of computers OUTSIDE of your router (ie. the internet). # x.x.x.x - Format of an IP address. Do not include the x'es into settings. Must be real numbers. # --------------------------------------------------------------------------- # Networking # --------------------------------------------------------------------------- # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname # Common settings... # 127.0.0.1 - If you are playing alone on a test server # 192.168.x.x - This is if you are on a 192.168.x.x type network (behind a standard consumer router) and want other computers from JUST the internal network to be able to connect # x.x.x.x - WAN IP obtained from http://www.whatismyip.com/. This is if you want people outside your internal network to be able to connect to your server. # --------------------------------------------------------------------------- # Default: 127.0.0.1 ExternalHostname = myserver.no-ip.biz # --------------------------------------------------------------------------- # This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname. # This can be the internal IP such as 127.0.0.1 or the computer's IP such as 192.168.x.x. # --------------------------------------------------------------------------- # Default: 127.0.0.1 InternalHostname = 192.168.1.6 # --------------------------------------------------------------------------- # If you are behind a router which using its own local IP for Port Forwarding then set this to the routers # local IP if you want people outside your internal network to be able to connect to your server. # --------------------------------------------------------------------------- # RouterHostname = # Bind ip of the LoginServer, use * to bind on all available IPs # Default: * LoginserverHostname = * # Default: 2106 LoginserverPort = 2105 # The address on which login will listen for GameServers, use * to bind on all available IPs # Default: * LoginHostname = * # The port on which login will listen for GameServers # Default: 9014 LoginPort = 4561 # The delay in minutes after which the login updates the gameservers IP's (usefull when their ip is dynamic) # Default: 15 IpUpdateTime = 5 # --------------------------------------------------------------------------- # Security # --------------------------------------------------------------------------- # Default: True LogLoginController = True # How many times you can provide an invalid account/pass before the IP gets banned. # Default: 10 LoginTryBeforeBan = 10 # Time you won't be able to login back again after LoginTryBeforeBan tries to login. # Default: 600 (10 minutes) LoginBlockAfterBan = 20 # If set to True any GameServer can register on your login's free slots # Default: False AcceptNewGameServer = True # Enforce GameGuard authorization from client? # If True, login server will kick client if the client bypassed GameGuard authentication. # Default: False ForceGGAuth = False # Flood Protection. All values are in MILISECONDS. # Default: True EnableFloodProtection = True # Default: 15 FastConnectionLimit = 15 # Default: 700 NormalConnectionTime = 700 # Default: 350 FastConnectionTime = 350 # Default: 50 MaxConnectionPerIP = 2 # --------------------------------------------------------------------------- # Database # --------------------------------------------------------------------------- # Specify the appropriate driver and url for the database you're using. # Examples: # Driver = com.mysql.jdbc.Driver (default) # Driver = org.hsqldb.jdbcDriver # Driver = com.microsoft.sqlserver.jdbc.SQLServerDriver Driver = com.mysql.jdbc.Driver # Database URL # URL = jdbc:mysql://localhost/l2jdb (default) # URL = jdbc:hsqldb:hsql://localhost/l2jdb # URL = jdbc:sqlserver://localhost/database = l2jdb/user = sa/password = URL = jdbc:mysql://localhost/l2jdb # Database user info (default is "root" but it's not recommended) Login = root # Database connection password Password = root # Default: 10 MaximumDbConnections = 100 # Default: 0 MaximumDbIdleTime = 0 # --------------------------------------------------------------------------- # Misc. # --------------------------------------------------------------------------- # If False, the license (after the login) will not be shown. # Default: True ShowLicence = True # Default: True AutoCreateAccounts = True # --------------------------------------------------------------------------- # Developer Settings # --------------------------------------------------------------------------- # Default: False Debug = False # Default: False Assert = False # Default: False Developer = False

gia na kaneis edit to system folder prepei na exei kateuasei ena apo to site edw gt me to system apo tin NCsoft einai mplokarismeno..... >.< http://www.maxcheaters.com/forum/index.php?topic=69451.0