soilder12 1 Report post Posted July 23, 2016 i got this message when i try to open the website , im using xampp 1.0.7 and no-ip host anyone knows hot to fix it? i try and try but not working Quote Share this post Link to post Share on other sites
Totoka 152 Report post Posted July 23, 2016 You shall read the config file before do something. an example : // where suppose to be the database settings. why do you put an url at the 'host' key? // key @host probably means at where do you have your database( address, domain, ... ), $config['db']['game'] = array( 'host' => '127.0.0.1' 1 Quote Discord: andresc Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 thanks @Totoka i realize after i put this here i got it working btw, in my serverfiles i should put my ipv4 or my no-ip ? cuz i try setting my server files with the no-ip ip and its just give me hang, but when i put my ipv4 it opens normaly is that ok? or that means no one can login in server? sorry for the abd english hope you understand my point ^^ Quote Share this post Link to post Share on other sites
Wrexor 61 Report post Posted July 23, 2016 35 minutes ago, soilder12 said: thanks @Totoka i realize after i put this here i got it working btw, in my serverfiles i should put my ipv4 or my no-ip ? cuz i try setting my server files with the no-ip ip and its just give me hang, but when i put my ipv4 it opens normaly is that ok? or that means no one can login in server? sorry for the abd english hope you understand my point ^^ For server files use 127.0.0.1 everywhere except in GateServer.cfg in ToClient section, there use 0.0.0.0 1 Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted July 23, 2016 if you're using SQL 2k+ use in configurations your instance name 1 Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 2 hours ago, Wrexor said: For server files use 127.0.0.1 everywhere except in GateServer.cfg in ToClient section, there use 0.0.0.0 with this other people can login into my server? Quote Share this post Link to post Share on other sites
Totoka 152 Report post Posted July 23, 2016 6 minutes ago, soilder12 said: with this other people can login into my server? Yup, 0.0.0.0 binds to all your machine interfaces. And 127.0.0.1 into all other servers, *if they will be together at the same machine. Quote Discord: andresc Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 1 minute ago, Totoka said: Yup, 0.0.0.0 binds to all your machine interfaces. And 127.0.0.1 into all other servers, *if they will be together at the same machine. thanks ima test if it work, ill let you know if it show any issue ^^ thanks for the help @Totoka @Wrexor Quote Share this post Link to post Share on other sites
Vasil 71 Report post Posted July 23, 2016 10 minutes ago, soilder12 said: with this other people can login into my server? Yes , but you have to open your ports and use on their clients your External IP. Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 this is what happen when i try making a new account on website Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 (edited) 4 minutes ago, Dimitrov said: Yes , but you have to open your ports and use on their clients your External IP. ye i think my ports are closed that`s why cannot conect form another ip.. i already opened on router but not working idk why i checked on cmd> netstat -an, and cant see 1656 1973,1975,1976 ports so i guess they re still closed Edited July 23, 2016 by soilder12 Quote Share this post Link to post Share on other sites
Wrexor 61 Report post Posted July 23, 2016 7 minutes ago, soilder12 said: ye i think my ports are closed that`s why cannot conect form another ip.. i already opened on router but not working idk why i checked on cmd> netstat -an, and cant see 1656 1973,1975,1976 ports so i guess they re still closed You only have to open port 1973. The rest arent needed for other players to connect. Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 1 minute ago, Wrexor said: You only have to open port 1973. The rest arent needed for other players to connect. yes i can see that`s the top cliean port ill keep trying until i open it do u know how to fix it when making new account? Quote Share this post Link to post Share on other sites
Wrexor 61 Report post Posted July 23, 2016 Just now, soilder12 said: yes i can see that`s the top cliean port ill keep trying until i open it do u know how to fix it when making new account? Try to add column with name 'email' in account_login table. Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 3 minutes ago, Wrexor said: Try to add column with name 'email' in account_login table. can u tell me how to add it please? Quote Share this post Link to post Share on other sites
Totoka 152 Report post Posted July 23, 2016 ALTER TABLE account_login ADD email VARCHAR(255) NULL Quote Discord: andresc Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 23, 2016 13 minutes ago, Totoka said: ALTER TABLE account_login ADD email VARCHAR(255) NULL ALTER TABLE? can u be more expecific pls? @Totoka Quote Share this post Link to post Share on other sites
Juan 20 Report post Posted July 23, 2016 (edited) 5 hours ago, soilder12 said: ALTER TABLE? can u be more expecific pls? @Totoka Run on query analizer Edited July 23, 2016 by Juan Quote Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 24, 2016 5 hours ago, Juan said: Run on query analizer THANKS JUAN IM DONE WHIT EMAIL NULL! NOW I GET THIS u.u Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted July 24, 2016 @soilder12 Do SQL Query in MSSQL Management Studio / Query Analyzer USE [AccountServer] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[account_pending]( [acc_id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NOT NULL, [password] [varchar](50) NOT NULL, [squestion] [varchar](100) NOT NULL, [answer] [varchar](100) NOT NULL, [email] [varchar](100) NOT NULL, [gender] [int] NOT NULL, [credit] [int] NULL, [truename] [varchar](100) NOT NULL, [birthday] [datetime] NOT NULL, [contact] [varchar](50) NOT NULL, [country] [varchar](50) NOT NULL, [ipaddr] [varchar](50) NOT NULL, [ip2country] [varchar](50) NOT NULL, [actcode] [varchar](50) NULL, [invtcode] [varchar](50) NULL, [create_time] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[account_pending] ADD CONSTRAINT [DF_account_pending_gender] DEFAULT ((0)) FOR [gender] GO 1 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
soilder12 1 Report post Posted July 25, 2016 Thanks @V3ct0r Quote Share this post Link to post Share on other sites