MySQL How to create a GM/GOD in 3 simple steps

[Winnerandy]

@Winnerandy acces in PHPmyAdmin doesent exists! But i can change name and levels and stuff!

not access, the group_id (line 4 in the table)

REP+?

 

[nutte]

not access, the group_id (line 4 in the table)

REP+?

ACCUALLY i JUST saw it! Thanks anyway! i changed it to 6 and then my looktype changed to! Ill rep you when i find out how to do!

(never rep:ed somone xD)

 

[gizzzmo]

I need help adding something to the database. It says this once the server is fully running.


It says this; "mysql_real_query<>: SELECT * FROM z_ots_comunication WHERE 'type' = 'login'; - MYSQL ERROR: Table '*****.z_ots_comunication' doesn't exist' <1146>

I understand I have to add this table in the database, but I need help on it. If you can help I would appreciate it.

Thanks.

 

[Xazive]

Thanks Winner..

 

[Winnerandy]

Thanks Winner..

Np!

 

[M4t30]

lol just open players table and add group id 6.. and whola... much easier that is in 1 step...

 

[JoccE]

Why would any one do that with text when it so simple with the GUI..

Log into PHPMyadmin -> Your OT's database -> players -> search/goto YOURNAME -> press "show" -> change groupID to 6 for god, 5 for CM, 4 for GM, (Can see all ids in groups.xml /data/xml)

 

[Winnerandy]

Or another way to do it:

1GO TO YOUR DATABASE
2GO TO PLAYERS TABLE
3CHOOSE THE PLAYER YOU WANT TO MAKE GM/GOD AND EDIT IT BY CLICKING ON THE PEN AT THE LEFT SIDE OF THE CHARACTER NAME/ACC
4NOW, CHANGE THE ACCESS TO 2/3/4 OR 5

Why would any one do that with text when it so simple with the GUI..

Log into PHPMyadmin -> Your OT's database -> players -> search/goto YOURNAME -> press "show" -> change groupID to 6 for god, 5 for CM, 4 for GM, (Can see all ids in groups.xml /data/xml)

Already told xD

 

[JoccE]

Already told xD

Okey

Didn't read the whole thread

 

[HGL]

thx man,
it's helped me.

 

[krille09]

I made this now, it works in phpmyadmin, it exist... but when I try to login on tibia, it dosen't exist... also the characters I made by account manager dosen't exist either in the database :S why?

 

[maxxoer]

Really nice! thanks a lot! took me 3 h to make a god acc on my new 8.70 server rep +++

 

[IMac]

Really nice! thanks a lot! took me 3 h to make a god acc on my new 8.70 server rep +++

post hunter? <_<

 

[JoccE]

post hunter? <_<

Post hunter.

 

[egzon33]

Me to rambo i have the same problem

 

[Saul055]

SOMEONE KNOWS WHEN PPL TRY TO CONNECT IN MY SERVER,
AFTER THE ACCOUNT LIST DOWNLOADED THEY CHOOSE THEYR CHART BUT THEY UNABLE TO CONNECTING AT THE GAME WORLD??

 

[Royal Inferno]

Why not just: Create account and character, go to phpmyadmin, your database, players, and edit player of choice, and change the "group id"?

1. Player
2. Tutor
3. Senior Tutor
4. Gamemaster
5. Community Manager
6. GOD

Correct me if I am wrong

 

[Ello]

I use :
sqlitestudio-1.1.1.exe

better !

 

[Tonks]

I use :
sqlitestudio-1.1.1.exe

better !

Sqlitestudio isn't better than phpmyadmin.

 

[Polat Alemdar]

Sqlitestudio isn't better than phpmyadmin.

Yeah tonks have right phpmyadmin much better than sqlitestudio !

sqlitestudio suck!