Help

Content and general development discussion, including maps, quests, and server code from the development team.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Help

Post by Ejin » 17 Oct 2007, 22:25

How can I make a GM account on my server?
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Post by Crush » 18 Oct 2007, 01:39

eAthena or TMWServ?
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Post by Ejin » 18 Oct 2007, 01:49

Crush wrote:eAthena or TMWServ?
TMWServer
silene
Peon
Peon
Posts: 36
Joined: 12 Aug 2005, 20:19

Post by silene » 18 Oct 2007, 07:33

Code: Select all

sqlite3 tmw.db
update tmw_accounts set level=99 where username='Ejin';
99 is for administrative rights (e.g. reloading modified databases on the fly). Reduce to 50 for GM rights only.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Post by Ejin » 18 Oct 2007, 16:44

silene wrote:

Code: Select all

sqlite3 tmw.db
update tmw_accounts set level=99 where username='Ejin';
99 is for administrative rights (e.g. reloading modified databases on the fly). Reduce to 50 for GM rights only.
Sorry, but where can I put this??
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Post by Crush » 18 Oct 2007, 16:49

tmw.db is the SQLite database in which all the account information is stored.

sqlite3 is a program for administrating SQLite databases. http://www.sqlite.org/download.html

"update tmw_accounts set level=99 where username='Ejin';" is the SQL command you have to enter in sqlite3 to set the userlevel of the account "Eijin" to 99.
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Post by Ejin » 18 Oct 2007, 17:26

ok, I make the download and extract the file sqlite3-3.5.1.bin, but where I need to modify?
Sorry for my terrible english because I am Brazilian
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Post by Crush » 18 Oct 2007, 17:30

What operating system are you using?
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Post by Ejin » 18 Oct 2007, 18:02

eAthena
Sorry for my terrible english because I am Brazilian
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Post by Crush » 18 Oct 2007, 18:07

*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Dr Wahl
Novice
Novice
Posts: 317
Joined: 09 Apr 2006, 07:15
Location: Washington
Contact:

Post by Dr Wahl » 18 Oct 2007, 18:15

Wow!!!!

This is mind numbing....
Image
Matt
Knight
Knight
Posts: 1747
Joined: 07 Aug 2004, 11:47
Location: Germany->Bavaria

Post by Matt » 18 Oct 2007, 18:49

Haha great.
Ejin
Peon
Peon
Posts: 7
Joined: 17 Oct 2007, 19:54

Post by Ejin » 18 Oct 2007, 19:15

what I need to write on sqlite3.exe?
Sorry for my terrible english because I am Brazilian
Blamoo
Peon
Peon
Posts: 98
Joined: 03 Feb 2006, 23:07

Post by Blamoo » 18 Oct 2007, 19:45

Crush wrote:*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall*
*bashes head against the wall[2]*
*bashes head against the wall[2]*
*bashes head against the wall[2]*
*bashes head against the wall[2]*
*bashes head against the wall[2]*
*bashes head against the wall[2]*
*bashes head against the wall[2]*

*wait 35 seconds*
Ejin wrote:what I need to write on sqlite3.exe?
nothing.
you dont need sqlite.
you are not using tmwserv.
you are using eAthena.

uh... do this:


-open trunk\save\account.txt
-find the char u want to set gm level
-copy the id number (2000000 user password - S 0 0 a@a.com - 0... blah blah blah)
-close account.txt and open trunk\conf\gm_account
-add this line:

Code: Select all

// <account> <level>
2000000 99
(your id)<space>(gm level)
[/size]

(font size: 24 ¬¬)
Ejin wrote:Sorry for my terrible english because I am Brazilian
me too.

bah... Brazilians... ¬¬
User avatar
BadMrBox
Novice
Novice
Posts: 281
Joined: 10 Mar 2005, 16:05
Location: Sweden
Contact:

Post by BadMrBox » 18 Oct 2007, 21:39

This thread saved my evening :shock:
Image
Post Reply