[Release] Tera-Shock Java-Server | Rev. 218413

[mor339k]

when ever i put password and username in neolauncher nothing happens when i click login, it just stays the same and doesnt launch the game and it doesnt say anything in the server bat, whats wrong?

[gda123123]

when ever i put password and username in neolauncher nothing happens when i click login, it just stays the same and doesnt launch the game and it doesnt say anything in the server bat, whats wrong?

website running properly?
those tips are for someone who could host the old version of tera

[mor339k]

how do i know if its running properly? lol, im using wamp server if its a problem.. i dont know if it matters, i can get in the site but if i try to register i get some errors cause the username is login and there is no account id columns and stuff like that, but does it matter at all? using tera-single.bat and .exe i can get in the game and see the servers but when i click a server it does nothing at all. any ideas? i did change the port in the web files to match the server

[snkdemon]

working perfectly



The htdocs I edited for new db and is working 100%

Attachment 151997Attachment 151996Attachment 151998

nice job will you relese your login,register. web filles?

[gda123123]

how do i know if its running properly? lol, im using wamp server if its a problem.. i dont know if it matters, i can get in the site but if i try to register i get some errors cause the username is login and there is no account id columns and stuff like that, but does it matter at all? using tera-single.bat and .exe i can get in the game and see the servers but when i click a server it does nothing at all. any ideas? i did change the port in the web files to match the server

if you can't register, means you didn't do it right.
also means you didn't follow those tips carefully

[KatKat]

Anyway it is possible to make oneself its registration page. I watched a little operation of the database, and I managed with some php scripts to do a ranking logically.

[nicolasn1]

https://mega.co.nz/#!xME0mJzb!1c22rs...JRNBsfY0b3J2D8

web site for new database

edit core/connect/database.php

------------------------------------------------
Fixed change-pw / profile

https://mega.co.nz/#!kcl2ybhZ!l5AYQd...AStaj_Qh1xePpc

[gda123123]

Anyway it is possible to make oneself its registration page. I watched a little operation of the database, and I managed with some php scripts to do a ranking logically.

you can easily fix all those website funtions by edit SQL query in php files
but if you just want register an account and enter the game,the original NeoLauncher with its database could easily get you in game without edit anything

[KatKat]

Indeed, at least thank you for NeoLauncher
Thank you very much nicolasn1.

[jonipin]

Just a litle Question has anybody been able to enter Sinnestral Manor?? Because in my server the Teleportal Just isn't there :/

[Skkont]

@nicolasn1

Hi! Thanks for sharing.

I have an error with the web :c

First, when i select the terax1 db. Appear this error.



And if i change the DB for the "tera-database-1725.sql" from the web. I have this error:



Help please :)

Also a getting an error with neolauncher :c

I execute once, I close that and when i trying to open again, this error appear :c I dont know why.



Thanks!

[nicolasn1]

@nicolasn1

Hi! Thanks for sharing.

I have an error with the web :c

First, when i select the terax1 db. Appear this error.



And if i change the DB for the "tera-database-1725.sql" from the web. I have this error:



Help please :)

Also a getting an error with neolauncher :c

I execute once, I close that and when i trying to open again, this error appear :c I dont know why.



Thanks!

Use Terax1.sql

-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
Create TABLE `accounts` (
`AccountId` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(32) NOT NULL DEFAULT '',
`password` varchar(256) CHARACTER SET latin1 DEFAULT '',
`email` varchar(45) CHARACTER SET latin1 DEFAULT 'null@null',
`access_level` smallint(6) NOT NULL DEFAULT '0',
`end_pay` bigint(15) NOT NULL DEFAULT '0',
`end_block` bigint(15) NOT NULL DEFAULT '0',
`last_ip` varchar(15) NOT NULL DEFAULT '',
`allow_ips` varchar(255) NOT NULL DEFAULT '*',
`comments` varchar(255) NOT NULL DEFAULT '',
`LastOnlineUtc` bigint(64) NOT NULL DEFAULT '0',
`EmailVerify` varchar(256) NOT NULL,
`PasswordRecovery` varchar(128) NOT NULL,
`Coins` int(11) NOT NULL DEFAULT '0',
`Ip` varchar(64) NOT NULL,
`Membership` int(1) NOT NULL DEFAULT '0',
`isGM` int(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`AccountId`),
KEY `access_level` (`access_level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


execute on query

- - - Updated - - -

=d

[Skkont]

@nicolasn1

Thanks!

Are you use the NeoLauncher? I have errors with it.

First, this doesnt login in if I use you web, but if I use the old web I can login, the problem is that erro appear.



In the web, I can register, login, players online, etc.

In the neolauncher config I have put correct links to Web.

But, like i said, the problem is with the launcher.

There is another way to enter to server? Not localhost, in a other computer.

Thanks!

[shinchan62]

if you're looking for the easiest way to enter the server
just simply use NeoLauncher
https://mega.co.nz/#!Q0s03RKI!AKGxsW...fKJN1X-noNvehc
no need to edit or modify any SQL query in php for new database
just import the old db and host httpd server with web document both from NeoLauncher archive
and remember to modify the port in server/serverlist to match with the new gameserver(default port of new gameserver is 14752)
it will run properly, just use the register page from website for new account
don't ask me why it could run without fit it into new database
because if you know the architecture of Tera-Server, you wont ask me why,
but if you don't,then don't bother yourself with this question
just like I said "the same old way"

In case someone couldn't get it,here's some tips

1.restore DB "terax1" with the terax1.sql which inside terax1 archive
2.edit "config/DataBase.xml" to match with your Mysql setting
3.run gameserver

it's for gameserver part
now we are gonna host web api for login-auth and serverlist

4.restore db named "tera" with "tera-database-1725.sql" which inside NeoLauncher archive
5.host your apache server and put web files from Neolauncher archive into htdocs
6.open "core\connect\database.php" to match with your Mysql setting
7.open "server" there's 3 serverlist files inside it, you can just edit all of them to make sure you didi it right, change the ip to your gameserver ip, and change port to 14752
8.open your browser and enter the website (ex:http://127.0.0.1/)
9.register a new account
10.put "NeoLauncher.exe" and "neolauncher" directory into tera
11.edit "neolauncher\neolauncher.ini" , change WebServerUrl to your website( ex:http://127.0.0.1/)
12.double click NeoLauncher.exe, choose language, login, enjoy

@gda123123


"1.restore DB "terax1" with the terax1.sql which inside terax1 archive
2.edit "config/DataBase.xml" to match with your Mysql setting
3.run gameserver"

it's for gameserver part
now we are gonna host web api for login-auth and serverlist

"4.restore db named "tera" with "tera-database-1725.sql" which inside NeoLauncher archive
5.host your apache server and put web files from Neolauncher archive into htdocs"

so im going to use to different types of database? "terax1.sql is used for the new gameserver. and tera-database-1725.sql will be use for the apache server." thanks

[gda123123]

@gda123123


"1.restore DB "terax1" with the terax1.sql which inside terax1 archive
2.edit "config/DataBase.xml" to match with your Mysql setting
3.run gameserver"

it's for gameserver part
now we are gonna host web api for login-auth and serverlist

"4.restore db named "tera" with "tera-database-1725.sql" which inside NeoLauncher archive
5.host your apache server and put web files from Neolauncher archive into htdocs"

so im going to use to different types of database? "terax1.sql is used for the new gameserver. and tera-database-1725.sql will be use for the apache server." thanks

yes,the easiest way to make it run without change database structure or edit sql query is to create 2 databases
"terax" for gameserver, "tera" for website and login-auth

By the way
if you want to make all website funtions funtional,you should only modify the web-documents
never change the "terax" structure without recode the gameserver