[Small-Guide]Auto GMs/PMs Problem Fix

[_legitimate_]

sup men. i remember downloading a coemu source with gay sql settings. Every character that was made was a GM/PM, if you have this problem then right click your .sql and hit edit then look for "Characters":

-- ----------------------------
-- Table structure for `characters`
-- ----------------------------
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters` (
`CharID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(16) NOT NULL DEFAULT '',
`Account` varchar(16) NOT NULL DEFAULT '',
`Server` varchar(16) DEFAULT '',
`Spouse` varchar(16) DEFAULT 'None',
`Level` int(11) DEFAULT '1',
`Exp` bigint(255) unsigned DEFAULT '0',
`Str` int(11) DEFAULT '0',
`Dex` int(11) DEFAULT '0',
`Spi` int(11) DEFAULT '0',
`Vit` int(11) DEFAULT '0',
`HP` int(11) NOT NULL DEFAULT '1',
`MP` int(11) NOT NULL DEFAULT '0',
`PkPoints` int(11) DEFAULT '0',
`StatPoints` int(11) DEFAULT '0',
`Money` int(11) DEFAULT '1000000',
`CPoints` int(11) DEFAULT '200',
`VPoints` int(11) DEFAULT '0',
`WHMoney` int(11) NOT NULL DEFAULT '0',
`HairStyle` int(11) NOT NULL DEFAULT '0',
`Model` int(11) NOT NULL DEFAULT '0',
`Map` int(11) DEFAULT '1010',
`MapInstance` int(11) DEFAULT '0',
`xCord` int(11) DEFAULT '60',
`yCord` int(11) DEFAULT '110',
`Status` varchar(10) DEFAULT '0x00000000',
`GDonation` int(11) DEFAULT '0',
`Reborn` int(11) DEFAULT '0',
`isGM` int(11) DEFAULT '0',
`nobility` int(2) DEFAULT '0',
`Guild` int(11) DEFAULT '0',
`GRank` int(11) DEFAULT '50',
`Class` int(11) DEFAULT '0',
`Honor` int(11) DEFAULT '0',
`isPM` int(11) DEFAULT '0',
`FirstLog` int(2) DEFAULT '0',
`DbExpUsed` datetime DEFAULT '1923-12-12 12:12:12',
`ExpPotionTime` int(10) unsigned DEFAULT '10',
`ExpPotionRate` int(10) unsigned DEFAULT '10',
`PreviousMap` int(10) unsigned DEFAULT '1011',
PRIMARY KEY (`CharID`)
) ENGINE=MyISAM AUTO_INCREMENT=1000021 DEFAULT CHARSET=latin1;

-- ----------------------------

I highlighted what you have to change. Under GM/PM the default, change it to 0. To make every new player automaticly GM/PM change it to 1. Small guide but yea, some may have this problem

#update: also, you can edit the default level new characters as well as cps, stats and all that.

[MexicanoCoder]

#Edit

Nice release

[Kiyono]

Originally Posted by MexicanoCoder

Well tell us what CoEmu you downloaded and we can try to help >.<

He doesn't have a problem this is a release.

[MexicanoCoder]

Originally Posted by Kiyono

He doesn't have a problem this is a release.

Eh guess i miss read lol thanks for pointing that out

[pro4never]

Not quite sure how this can be considered even a mini-guide let alone a release... but if it helps people, all the more power to you.


Srsly though it's not the least bit difficult. Open navicat, open table you want to modify and then go file>design table. Then enter default value you want for any of the fields. You can also modify the other things such as allowing them to be null, auto incrementing them, allowing duplicate keys, changing data types, etc

[_legitimate_]

Originally Posted by MexicanoCoder

#Edit

Nice release

Originally Posted by pro4never

Not quite sure how this can be considered even a mini-guide let alone a release... but if it helps people, all the more power to you.


Srsly though it's not the least bit difficult. Open navicat, open table you want to modify and then go file>design table. Then enter default value you want for any of the fields. You can also modify the other things such as allowing them to be null, auto incrementing them, allowing duplicate keys, changing data types, etc

i guess that can work too. but I THINK for noops this MIGHT be simpler.

[#*=DarkAngeL=*#]

Those where you get PM/GM is just bad edited pvp sources

[_legitimate_]

Originally Posted by #*=DarkAngeL=*#

Those where you get PM/GM is just bad edited pvp sources

no its a bad edited .sql. but they did it on purpose to f*ck up noobs

[Zion~]

Originally Posted by _legitimate_

no its a bad edited .sql. but they did it on purpose to f*ck up noobs

Thanks for blowing things out of proportion.