[GUIDE]Fixing The Auto GM

[Warmonger]

Here's a little fix to stop all players from being an admin when they create new characters.

USE `newproject_db`;
ALTER TABLE `t_characters` 
MODIFY COLUMN `a_admin` tinyint(4) NOT NULL DEFAULT 0 AFTER `a_deletedelay`;

Or

 

[hectormousa]

re: Fixing The Auto GM

how to use that code, do i have to use it in mysql ??

 

[Warmonger]

re: Fixing The Auto GM

Just paste it as a new query and execute it.

 

[Warmonger]

Re: Fixing The Auto GM

thx man it's working good

No problem.

@Mod
Why was this moved out of the release section? Its not a guide.

 

[Wizatek]

Re: Fixing The Auto GM

Its not a release also, but if i have to compare what its closest to then i would say its a guide since u are guiding in how to change the default value

 

[Mennis343]

Re: Fixing The Auto GM

Can you give me a little more details on how to add this please. Sorry I like an extreme noob at this but I am a quick learner thanks

 

[maxiguti]

Re: Fixing The Auto GM

I have put 4 in the table a_admin and it works, but when they create another Player it is 10.:S

 

[rzrgames]

Re: Fixing The Auto GM

umm i gotta error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE t_characters MODIFY COLUMN a_admin tinyint(4) NOT NULL DEFAULT 0 A' at line 2

What version of MYSQL should i be using ??

I'm using 5.5

 

[maxiguti]

Re: Fixing The Auto GM

I'm using SQL of NEW data Pack Warmonger

 

[hectormousa]

Re: Fixing The Auto GM

maxiguti

try edit manually

go to navicat ---> newproject_db -------> t_characters

right click on t_characters then choose design table . in a_admin change the default value from 10 to 0

 

[rzrgames]

Re: Fixing The Auto GM

ALTER TABLE `t_characters` CHANGE `a_admin` `a_admin` TINYINT( 4 ) NOT NULL DEFAULT '0'

that worked for me

 

[MentaL]

Re: Fixing The Auto GM

Warmonger said if he did not become moderator he would remove all his releases. He never got moderator therefore he deleted them but I've restored it, my apologies to his immaturity.

Regards.