How can I change player/tutor/gamemaster ID to 1/2/3 etc?

[Zackvor]

I'm sure it's a simple question but my brain won't work anymore as of today. Do anyone know where I can change the ID's of player, god, gamemaster, tutor, senior tutor.... whatever. Where and how? Premanently.

Thank you.

 

[Xplicit]

1 of two places.....

If you have a group file in xml folder. E.g. groups.xml. you'll find it in there...

Or its a manual job in phpmyadmin

 

[Zackvor]

1 of two places.....

If you have a group file in xml folder. E.g. groups.xml. you'll find it in there...

Or its a manual job in phpmyadmin

It is a MySQL database, so pma. I know I should find it in database > groups table, but I can't find it in there..

 

[Xplicit]

Hmm i don't know much about it in the database, but i have both with my server, yet there is an xml file in my xml folder called groups.xml. Just check if you have one, this will be alot easier.

In the event that its in the database, i can't really help without seeing, post your groups table? :3
Sorry

 

[Zackvor]

Hmm i don't know much about it in the database, but i have both with my server, yet there is an xml file in my xml folder called groups.xml. Just check if you have one, this will be alot easier.

In the event that its in the database, i can't really help without seeing, post your groups table? :3
Sorry

Nope, I do not have a groups.xml file... but this is a screeny of my groups table on mysql:
ImageShack? - Online Photo and Video Hosting

 

[Xplicit]

Yh, i see what your saying... There a table called access maybe?

Sorry for not giving much help :/

 

[Zackvor]

bumpppp

 

[Bogart]

go to the table "players" search for the player that you want to promote/demote select it, click on it, and change the group id.

 

[ahmed30]

localhost/phpmyadmin > sql
to select all players with group id XX

select * from `players` where `group_id` = 'XX'

to Select A Player

select * from `players` where `name` = 'PLAYER_NAME_HERE'

to Change Group_id of Player

UPDATE `players` SET `group_id` = 'XX' WHERE `name` = 'PLAYER_NAME_HERE'

 

[Zackvor]

go to the table "players" search for the player that you want to promote/demote select it, click on it, and change the group id.

The problem is that I can not create a character/account at all.

Error over AAC:

Fatal error: Uncaught exception 'ClassException'
Message: Player::Create() Group #1 does not exist. Check your database and config file.
Online help: More Info
File: player.php on line: 250
Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

Debug Backtrace:Disabled

Error over phpmyadmin SQL Query:

Error
SQL query: 

#---------------------------------------------------
INSERT INTO accounts(  `id` ,  `password` ,  `type` ,  `group_id` ) 
VALUES (

@acc , @pass , 5, (

SELECT  `id` 
FROM groups
WHERE  `name` =  'a god'
)
);

MySQL said: 

#1054 - Unknown column 'type' in 'field list'

 

[Zackvor]

And I am using Nicaw AAC with an MySQL database, anyone knows what I can do about it?

 

[Blitzd_OTs]

http://otland.net/f479/adding-new-group-id-needed-tfs0-3-a-15458/ <-for adding new groups, but if you hae none, use this...

What you mean can't create a character? Can't go in game and make one?

 

[Zackvor]

http://otland.net/f479/adding-new-group-id-needed-tfs0-3-a-15458/ <-for adding new groups, but if you hae none, use this...

What you mean can't create a character? Can't go in game and make one?

I started my project just a few days ago. Installing the following basics as I stated in my post before this one. But it seems I can not create an account or character at all, and those bugs will appear as usual.

 

[Zackvor]

bump

 

[Zackvor]

bump, still not solved.