проблема

[Skilz]

хотел сделать русские ники на сервере, сделал все за мануалом

Открываем Navicat -->ищем таблицу characters --> жмём по ней правой кномкой и выбираем Design table -->в открывшейся таблицы ищем title и нажимаем на него --> ниже таблицы в character set выбираем utf8, а в Collation выбираем utf8_general_ci.... терь сохранем .... вот и всё

Чтобы ники можно было делать русскими проделайте тоже самое только для char_name

Найдите в server.properties строчку: URL=jdbc:mysql://localhost/l2jdb
Красным я выделил название вашей базы mysql. Так вот, эту строчку вам нужно переделать под такую:
URL=jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8
После этого нужно еще разрешить использовать все символы в нике чара:
В том же файле конфига, найдите что-то подобное:
CnameTemplate=
ClanAllyNameTemplate=
И переделать нужно на это:
CnameTemplate=*
ClanAllyNameTemplate=*

На этом мы закончили с серверной частью.
Теперь нужно чтобы сам клиент отображал русские ники. Для этого нам нужно скачать патч для клиента.


при запуске сервера показало ошибку вот ошибка


как ее решить, и в чем проблема
Сборка l2jFrozen
# Parameters Databases - MYSQL
Driver = com.mysql.jdbc.Driver
URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=utf-8



# Define character name template
# Example to use only : CnameTemplate=[A-Z][a-z]{3,3}[A-Za-z0-9]*
# will allow names with first capital letter, next three small letters,
# and any (capital or not) letter or number, like ZbigN1eW
# Most rational to have CnameTemplate=[A-Z][a-z]*
# meaning names only of letters with first one capital, like Zbigniew
# Default .* - any namy of any symbols
CnameTemplate = .*
PetNameTemplate = .*
ClanNameTemplate = .*

[Archiel]

Имя базы посмотрите. Оно у вас два раза написано, поэтому и ошибка. "Unknown database: l2jdbl2jdb"

[Skilz]

Имя базы посмотрите. Оно у вас два раза написано, поэтому и ошибка. "Unknown database: l2jdbl2jdb"

да но, в гейм сервере все прописано нормально.
Где посмотреть точнее?

[Archiel]

да но, в гейм сервере все прописано нормально.
Где посмотреть точнее?

Ну вы же где-то базу прописывали? Я не знаю где это в вашей сборке.
У меня это config/network/server.ini в ГС и config/network/loginserver.ini в ЛС.

[Skilz]


# ===================================#
# 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 *.
# ----------------------------------------------------------------------------------------

# Enter here (ip) address of your game server, or use the symbol *
GameserverHostname = *
GameserverPort = 7777

# Configure your external ip
ExternalHostname =

# Configure your internal ip
InternalHostname =

# Bunch ID and game server. It is better not to change.
LoginPort = 9014
LoginHost = 127.0.0.1

# Database Pool Type
# Possible Values: c3p0 or BoneCP
# c3p0: more stable
# BoneCP: more performance
DatabasePoolType = c3p0

# Parameters Databases - MYSQL
Driver = com.mysql.jdbc.Driver
URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8

# Database name
GameserverDB = l2jdb
LoginserverDB = l2jdb

# Login - Mysql's user
Login = root
# Password - Mysql's Password
Password =
# Attention: lazy init connections disabled!
# Please, set only real values for your database
# Default: 100
MaximumDbConnections = 50

# Default: 0
MaximumDbIdleTime = 0

# The timeout before a new connection to the database (in ms)
# 0 - to remove restrictions
TimeOutConDb = 0

# The timeout before the single connection must be closed (in ms)
# if a connection life is more then this timeout, a Runtime Exception
# is rised up. Post the exception on forum (www.l2jfrozen.com) to solve
# it.
SingleConnectionTimeOutDb = 200000

# Sets number of partitions to use.- BoneCP
# In order to reduce lock contention and thus improve performance,
# each incoming connection request picks off a connection from a pool that has thread-affinity,
# i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case
# when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start
# to have a negative effect on performance (and only for the case when connections on a partition start running out).
PartitionCount = 3

# Setting emulation off the kernel (package SendStatus)
RemoteWhoLog = True
RemoteWhoSendTrash = True
RemoteWhoMaxOnline = 329
RemoteOnlineIncrement = 50
RemoteWhoForceInc = 50
RemotePrivStoreFactor = 12

# Datapack folder
# To exacute the server under debugger with eclipse use:
# DatapackRoot = ../L2jFrozen_DataPack
# or point the folder directly to your server.
DatapackRoot = .







#============================================================#
# Frozen Dev.Team #
#============================================================#
# This is the server configuration file. Here you can set up the connection for your server.
# Usually you have to change the ExternalHostname option to
# - 127.0.0.1 (if you want to play alone / testing purpose)
# - LAN IP* (if you want to play from another computer in the network)
# - WAN IP** (if you want to play with friends over internet)
# - Questions? => http://l2jfrozen.com
#
# * = If you want to get your LAN IP, simply choose "Start" => "Run..." then type "cmd" => "ipconfig"
# **= If you want to get you WAN IP, visit http://www.whatismyip.com
# ===================================================================================================

# ================================================================
# General server setting !!! REQUIRED to configure to everyone !!!
# ================================================================

# This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname
ExternalHostname =

# This is transmitted to the client from the same network, so it has to be a local IP or resolvable hostname
InternalHostname =

# Bind ip of the loginServer, use * to bind on all available IPs
LoginserverHostname = *
LoginserverPort = 2106

# How many times you can provide an invalid account/pass before the IP gets banned
LoginTryBeforeBan = 20

# Time you won't be able to login back again after LoginTryBeforeBan tries to login. Provide a value in seconds. Default 10min. (600)
LoginBlockAfterBan = 600
GMMinLevel = 100

# The address on which login will listen for GameServers, use * to bind on all available IPs
LoginHostname = 127.0.0.1

# The port on which login will listen for GameServers
LoginPort = 9014

# If set to True any GameServer can register on your login's free slots
AcceptNewGameServer = False

# If False, the licence (after the login) will not be shown
# It is highly recomended for Account Seciurity to leave this option as defalut (True)
ShowLicence = True

# Database Pool Type
# Possible Values: c3p0 or BoneCP
# c3p0: more stable
# BoneCP: more performance
DatabasePoolType = c3p0

# Database info
Driver = com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver

# Database Settings
URL = jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbcqlserver://localhost/database=l2jdb/user=sa/password=

# Parameters Databases - MYSQL
# Login - Mysql's user
Login = root
# Password - Mysql's Password
Password =
# maximum number of simultaneous connecting to the database
MaximumDbConnections = 50

# Default: 0
MaximumDbIdleTime = 0

# The timeout before a new connection to the database (in ms)
# default 0 disabled
TimeOutConDb = 0

# Sets number of partitions to use. - BoneCP
# In order to reduce lock contention and thus improve performance,
# each incoming connection request picks off a connection from a pool that has thread-affinity,
# i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case
# when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start
# to have a negative effect on performance (and only for the case when connections on a partition start running out).
PartitionCount = 3

# Limit fast connections (input username / password)
FastConnectionLimit = 15
# Time of the normal connection (in ms)
NormalConnectionTime = 700
# Time fast connection (in ms)
FastConnectionTime = 350
# Maximum connections with the 1st IP
MaxConnectionPerIP = 50

# The lifetime of the session with the login server.
SessionTTL = 25000
MaxSessions = 100

# Choose the option: "true", to create an account when logging in automatically
AutoCreateAccounts = True

# Time to renew the IP address of the server in minutes (for dynamic IP)
IpUpdateTime = 0

# The configuration of the local subnet
# Example : 192.168
# Ppimer : 10.1
NetworkList = 192.168.;10.0.

# ===============================================================
# Test server configuration, not to switch on the game server! =
# ===============================================================
# Use the GG client authentication
# Login server access let the client without GameGuard
ForceGGAuth = False

# Including protection from flood
# IMPORTANT: Put True for server security.
EnableFloodProtection = True

# Enable mode "debugging"
# With debug you will see more log on console and more messages in game.
Debug = False

# Switched on "development"
Developer = False

# =============================================================
# Anti Ddos protection.
# This system works with iptables
# =============================================================
# iptables -A INPUT -p tcp --dport 7777 -j DROP
# IMPORTANT: Put True for server security.
# IMPORTANT: Active only with LINUX OS.
EnableDdosProSystem = False
# String deny_comms
# IMPORTANT: If you don't know what is it, leave as default
Deny_noallow_ip_ddos = /sbin/iptables -I INPUT 13 -p tcp --dport 7777 -s $IP -j ACCEPT
# Active full log on Login Server console about Ddos protection
Fulllog_mode_print = False

# =============================================================
# Anti Bruteforce protection. (credits RT-Interlude)
# =============================================================
#Count of trying connection to server, after which will be made checking IP addres
#for a possible BrutForce
#Reducing this value will increase the likelihood of false positives
#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)
BrutLogonAttempts = 15
#The average time (in seconds) between attempts to connect to the server
#Reducing this value will increase the likelihood of false positives
#Increasing this value will reduce the effectiveness of security (more chance find passwords for large accounts)
BrutAvgTime = 30
#Number of second, for ban IP address, who time BrutAvgTime less specified
#900 second = 15 minute
BrutBanIpTime = 900
Assert = False
EnableAllExceptionsLog = False
DebugPackets = False




если это то, то тут все нормально

[smeli]

изза незнайия англиского языка автором проблема оформлена неправильно

[Skilz]

по точнее можно?

[meX]

Gameserver.properties
# Database name
GameserverDB = Поле должно быть пустое!
LoginserverDB = Поле должно быть пустое!
Данный конфиг, для 2 отдельных баз лс и гс


# ===================================#
# 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 *.
# ----------------------------------------------------------------------------------------

# Enter here (ip) address of your game server, or use the symbol *
GameserverHostname = *
GameserverPort = 7777

# Configure your external ip
ExternalHostname =

# Configure your internal ip
InternalHostname =

# Bunch ID and game server. It is better not to change.
LoginPort = 9014
LoginHost = 127.0.0.1

# Database Pool Type
# Possible Values: c3p0 or BoneCP
# c3p0: more stable
# BoneCP: more performance
DatabasePoolType = c3p0

# Parameters Databases - MYSQL
Driver = com.mysql.jdbc.Driver
URL = jdbc:mysql://localhost/l2jdb?useUnicode=true&characterEncoding=UTF-8

# Database name
GameserverDB =
LoginserverDB =

# Login - Mysql's user
Login = root
# Password - Mysql's Password
Password =
# Attention: lazy init connections disabled!
# Please, set only real values for your database
# Default: 100
MaximumDbConnections = 50

# Default: 0
MaximumDbIdleTime = 0

# The timeout before a new connection to the database (in ms)
# 0 - to remove restrictions
TimeOutConDb = 0

# The timeout before the single connection must be closed (in ms)
# if a connection life is more then this timeout, a Runtime Exception
# is rised up. Post the exception on forum (www.l2jfrozen.com) to solve
# it.
SingleConnectionTimeOutDb = 200000

# Sets number of partitions to use.- BoneCP
# In order to reduce lock contention and thus improve performance,
# each incoming connection request picks off a connection from a pool that has thread-affinity,
# i.e. pool[threadId % partition_count]. The higher this number, the better your performance will be for the case
# when you have plenty of short-lived threads. Beyond a certain threshold, maintenance of these pools will start
# to have a negative effect on performance (and only for the case when connections on a partition start running out).
PartitionCount = 3

# Setting emulation off the kernel (package SendStatus)
RemoteWhoLog = True
RemoteWhoSendTrash = True
RemoteWhoMaxOnline = 329
RemoteOnlineIncrement = 50
RemoteWhoForceInc = 50
RemotePrivStoreFactor = 12

# Datapack folder
# To exacute the server under debugger with eclipse use:
# DatapackRoot = ../L2jFrozen_DataPack
# or point the folder directly to your server.
DatapackRoot = .


[smeli]

по точнее можно?

можно

char_name = character name

переведите на русский язык
а есть англискосе слово nick или nickname

в л2 сервере птс есть функции по nickname
а в клиенте есть команда /nick
посмотрите что делают ети функции

просто василий пупкинович однаждый сделал неправильный перевод а те кому он явлыется носпаримым авторитетом
немогут переводить слова по другому