Help

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

Help

Post by Ejin » Wed Oct 17, 2007 10:25 pm

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

Post by Crush » Thu Oct 18, 2007 1:39 am

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: Wed Oct 17, 2007 7:54 pm

Post by Ejin » Thu Oct 18, 2007 1:49 am

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

Post by silene » Thu Oct 18, 2007 7:33 am

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: Wed Oct 17, 2007 7:54 pm

Post by Ejin » Thu Oct 18, 2007 4:44 pm

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: Thu Aug 25, 2005 5:08 pm
Location: Germany

Post by Crush » Thu Oct 18, 2007 4:49 pm

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: Wed Oct 17, 2007 7:54 pm

Post by Ejin » Thu Oct 18, 2007 5:26 pm

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: Thu Aug 25, 2005 5:08 pm
Location: Germany

Post by Crush » Thu Oct 18, 2007 5:30 pm

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: Wed Oct 17, 2007 7:54 pm

Post by Ejin » Thu Oct 18, 2007 6:02 pm

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

Post by Crush » Thu Oct 18, 2007 6:07 pm

*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: Sun Apr 09, 2006 7:15 am
Location: Washington
Contact:

Post by Dr Wahl » Thu Oct 18, 2007 6:15 pm

Wow!!!!

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

Post by Matt » Thu Oct 18, 2007 6:49 pm

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

Post by Ejin » Thu Oct 18, 2007 7:15 pm

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

Post by Blamoo » Thu Oct 18, 2007 7:45 pm

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: Thu Mar 10, 2005 4:05 pm
Location: Sweden
Contact:

Post by BadMrBox » Thu Oct 18, 2007 9:39 pm

This thread saved my evening :shock:
Image
Post Reply