SimpleClans

SimpleClans

467k Downloads

SimpleClans leaders and members no saving?

zSolitario opened this issue ยท 4 comments

commented

http://i.imgur.com/dxaf6FY.png

I have a problem with clans ... members no saving in list and lose clan

http://i.imgur.com/eIL9onv.png

commented

Still an issue?

commented

uuid is added to the table here:

query = "ALTER TABLE sc_players ADD uuid VARCHAR( 255 ) DEFAULT NULL;";

commented

That updateDatabase method wasn't running in offline mode, this was fixed recently. This can be closed.

commented

@marcelo-mason

String query = "INSERT INTO `sc_players` ( `uuid`, `name`, `leader`, `tag`, `friendly_fire`, `neutral_kills`, `rival_kills`, `civilian_kills`, `deaths`, `last_seen`, `join_date`, `packed_past_clans`, `flags`) ";

This line tries to insert player's uuid at the uuid column, but is there such column?
Should it not be created here:
String query = "CREATE TABLE IF NOT EXISTS `sc_players` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(16) NOT NULL, `leader` tinyint(1) default '0', `tag` varchar(25) NOT NULL, `friendly_fire` tinyint(1) default '0', `neutral_kills` int(11) default NULL, `rival_kills` int(11) default NULL, `civilian_kills` int(11) default NULL, `deaths` int(11) default NULL, `last_seen` bigint NOT NULL, `join_date` bigint NOT NULL, `trusted` tinyint(1) default '0', `flags` text NOT NULL, `packed_past_clans` text, PRIMARY KEY (`id`), UNIQUE KEY `uq_sc_players_1` (`name`));";
?

(I'm not on PC, can't test right now. Does this sound like the cause of @zSolitario's problem?)