Modifie your account

New Member Joined: Apr 02, 2017 Posts: 2

Hello everyone.

I'm on ravennuke Version 2.51.00 verry good

I want to know how to modify your account to make it work with this table?

sql Code:

CREATE TABLE `uni1_users` (


  `id` int(11) UNSIGNED NOT NULL,


  `username` varchar(32) NOT NULL DEFAULT '',


  `password` varchar(60) NOT NULL DEFAULT '',


  `email` varchar(64) NOT NULL DEFAULT '',


  `email_2` varchar(64) NOT NULL DEFAULT '',


  `lang` varchar(2) NOT NULL DEFAULT 'de',


  `authattack` tinyint(1) NOT NULL DEFAULT '0',


  `authlevel` tinyint(1) NOT NULL DEFAULT '0',


  `race` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `rights` text,


  `id_planet` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `universe` tinyint(3) UNSIGNED NOT NULL,


  `galaxy` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `system` smallint(5) UNSIGNED NOT NULL DEFAULT '0',


  `planet` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `darkmatter` bigint(20) NOT NULL DEFAULT '0',


  `antimatter` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `stardust` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `user_lastip` varchar(40) NOT NULL DEFAULT '',


  `ip_at_reg` varchar(40) NOT NULL DEFAULT '',


  `register_time` int(11) NOT NULL DEFAULT '0',


  `onlinetime` int(11) NOT NULL DEFAULT '0',


  `dpath` varchar(20) NOT NULL DEFAULT 'gow',


  `timezone` varchar(32) NOT NULL DEFAULT 'Europe/London',


  `planet_sort` tinyint(1) NOT NULL DEFAULT '0',


  `planet_sort_order` tinyint(1) NOT NULL DEFAULT '0',


  `spio_anz` int(10) UNSIGNED NOT NULL DEFAULT '1',


  `settings_fleetactions` tinyint(2) UNSIGNED NOT NULL DEFAULT '3',


  `settings_esp` tinyint(1) NOT NULL DEFAULT '1',


  `settings_wri` tinyint(1) NOT NULL DEFAULT '1',


  `settings_bud` tinyint(1) NOT NULL DEFAULT '1',


  `settings_mis` tinyint(1) NOT NULL DEFAULT '1',


  `settings_blockPM` tinyint(1) NOT NULL DEFAULT '0',


  `urlaubs_modus` tinyint(1) NOT NULL DEFAULT '0',


  `urlaubs_until` int(11) NOT NULL DEFAULT '0',


  `db_deaktjava` int(11) NOT NULL DEFAULT '0',


  `b_tech_planet` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `b_tech` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `b_tech_id` smallint(2) UNSIGNED NOT NULL DEFAULT '0',


  `b_tech_queue` text,


  `spy_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `computer_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `military_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `defence_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `shield_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `energy_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `hyperspace_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `combustion_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `impulse_motor_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `hyperspace_motor_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `laser_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `ionic_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `buster_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `intergalactic_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `expedition_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `brotherhood` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `metal_proc_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `crystal_proc_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `deuterium_proc_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `graviton_tech` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `ally_id` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `ally_register_time` int(11) NOT NULL DEFAULT '0',


  `ally_rank_id` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `rpg_geologue` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',


  `rpg_amiral` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_ingenieur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_technocrate` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_espion` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_constructeur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_scientifique` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_commandant` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_stockeur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_defenseur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_destructeur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_general` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_bunker` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_raideur` tinyint(2) NOT NULL DEFAULT '0',


  `rpg_empereur` tinyint(22) NOT NULL DEFAULT '0',


  `bana` tinyint(1) NOT NULL DEFAULT '0',


  `banaday` int(11) NOT NULL DEFAULT '0',


  `hof` tinyint(1) NOT NULL DEFAULT '1',


  `spyMessagesMode` tinyint(1) NOT NULL DEFAULT '1',


  `wons` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `loos` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `draws` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `kbmetal` double(50,0) UNSIGNED NOT NULL DEFAULT '0',


  `kbcrystal` double(50,0) UNSIGNED NOT NULL DEFAULT '0',


  `lostunits` double(50,0) UNSIGNED NOT NULL DEFAULT '0',


  `desunits` double(50,0) UNSIGNED NOT NULL DEFAULT '0',


  `uctime` int(11) NOT NULL DEFAULT '0',


  `setmail` int(11) NOT NULL DEFAULT '0',


  `dm_attack` int(11) NOT NULL DEFAULT '0',


  `dm_defensive` int(11) NOT NULL DEFAULT '0',


  `dm_buildtime` int(11) NOT NULL DEFAULT '0',


  `dm_researchtime` int(11) NOT NULL DEFAULT '0',


  `dm_resource` int(11) NOT NULL DEFAULT '0',


  `dm_energie` int(11) NOT NULL DEFAULT '0',


  `dm_fleettime` int(11) NOT NULL DEFAULT '0',


  `ref_id` int(11) NOT NULL DEFAULT '0',


  `ref_bonus` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',


  `inactive_mail` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',


  `lp_points` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_p` int(11) UNSIGNED NOT NULL DEFAULT '3',


  `experience_peace` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `bonus_timer` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `experience_peace_max` int(11) UNSIGNED NOT NULL DEFAULT '3600',


  `experience_peace_level` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `peace_reward_slots` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `peace_reward_fields` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `peace_reward_golf` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `experience_combat` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `experience_combat_max` int(11) UNSIGNED NOT NULL DEFAULT '10700',


  `combat_reward_deut` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `combat_reward_expe` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `combat_reward_bonus` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `combat_reward_collider` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `experience_combat_level` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_extraction` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_storing` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_speed` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_stage` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_bonus` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_moon` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_expedition` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_experience` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_bank` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_speed_button` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_expedition` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_speed_expiditeon` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_batle_leveling` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_prod_from_colly` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_moon_creat` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `prem_fuel_consumption` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `alliance_storage_deposit` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `alliance_storage_widraw` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_peace_level` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_combat_level` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_attack` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_hostal` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_expedition` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_level_attack` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_level_hostal` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_level_expe` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_metal` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_crystal` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_deuterium` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_light` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_medium` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_heavy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_university` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_moon` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_phalanx` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_build_terraformer` int(111) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_easy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_simple` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_average` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_high` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_heavy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_massive` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_defense_imperial` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_fighter` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_destructor` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `moon_destruction` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_moons` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `moon_creation` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_hostal` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `hostal_count` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_expe` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `expedition_count` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_seeker` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `found_dm` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_upgrades` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_misc_integrator` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_small` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_support` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_battle` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_destruction` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_seige` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_heavy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_fleets_imperial` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_spy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_hacker` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_invincible` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_expedition` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_graviton` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_power` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_energy` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_brotherhood` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_speed` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievements_tech_geologist` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1101` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1102` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1103` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1104` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1105` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1106` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1107` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1108` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1109` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1110` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1111` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1113` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1112` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1201` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1202` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1203` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1204` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1208` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1209` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1210` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1205` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1207` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1206` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1301` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1304` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1302` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1310` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1305` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1303` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1308` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1311` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1312` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1313` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1314` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1306` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1307` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `academy_1309` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `instant_fleet` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `instant_defense` bigint(20) UNSIGNED NOT NULL DEFAULT '0',


  `peacefull_last_update` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `multi_report` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `message_ban` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `message_trusted` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `v1` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `v2` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `v3` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `training` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `training_step` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `frisbee` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `alien` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `rocket` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `cosmonaute` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `facebook_liked` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `light_armor_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `average_armor_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `heavy_armor_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `light_shield_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `average_shield_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `heavy_shield_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `jet_engine_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `kick_motor_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `hyperspace_drive_upgrade` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade1_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade2_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade3_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade4_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade5_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade6_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade7_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade8_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade9_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT '100',


  `upgrade1_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade2_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade3_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade4_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade5_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade6_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade7_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade8_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `upgrade9_level` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `alarm_volume` float UNSIGNED NOT NULL DEFAULT '0',


  `planet_cloak` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `planet_cloak_countdown` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `immunity_until` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `next_immunity` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `sdays_b` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',


  `sdays_time` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `settings_planetmenu` int(11) NOT NULL DEFAULT '0',


  `PaySafe` int(11) NOT NULL DEFAULT '0',


  `FM_cooldown` int(11) NOT NULL DEFAULT '0',


  `harvest_delay` int(11) NOT NULL DEFAULT '5',


  `harvest_time` int(11) NOT NULL DEFAULT '0',


  `jackpot` int(11) NOT NULL DEFAULT '5',


  `vcount` int(11) NOT NULL DEFAULT '0',


  `premium_reward_extraction_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_storing_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_speed_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_stage_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_bonus_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_speed_button_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_expedition_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_expedition_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_speed_expiditeon_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_experience_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_batle_leveling_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `premium_reward_bank_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_prod_from_colly_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_moon_creat_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_fuel_consumption_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `multi_spotted` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `multi_spotted_aproval` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_advanced_battlesim` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `prem_advanced_battlesim_days` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `message_ban_time` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `kolvo` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `extra_palnet` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',


  `tot_ref` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `fblink` varchar(255) DEFAULT NULL,


  `firstname` varchar(255) DEFAULT NULL,


  `age` tinyint(3) DEFAULT NULL,


  `country` varchar(255) DEFAULT NULL,


  `playstyle` varchar(255) DEFAULT NULL,


  `city` varchar(255) DEFAULT NULL,


  `skype` varchar(255) DEFAULT NULL,


  `climate_change` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `climate_change_name` varchar(255) DEFAULT NULL,


  `achievement_fleet_1` double(50,0) UNSIGNED NOT NULL DEFAULT '200000',


  `achievement_fleet_2` double(50,0) UNSIGNED NOT NULL DEFAULT '200000',


  `achievement_fleet_3` double(50,0) UNSIGNED NOT NULL DEFAULT '200000',


  `achievement_fleet_4` double(50,0) UNSIGNED NOT NULL DEFAULT '4000',


  `achievement_fleet_5` double(50,0) UNSIGNED NOT NULL DEFAULT '20000',


  `achievement_fleet_6` double(50,0) UNSIGNED NOT NULL DEFAULT '100000',


  `achievement_fleet_7` double(50,0) UNSIGNED NOT NULL DEFAULT '5000',


  `achievement_fleet_8` double(50,0) UNSIGNED NOT NULL DEFAULT '1750',


  `achievement_fleet_9` double(50,0) UNSIGNED NOT NULL DEFAULT '750',


  `achievement_fleet_10` double(50,0) UNSIGNED NOT NULL DEFAULT '1000',


  `ach_points_total` int(11) UNSIGNED NOT NULL DEFAULT '0',


  `achievement_def_1` double(50,0) UNSIGNED NOT NULL DEFAULT '200000',


  `achievement_def_2` double(50,0) UNSIGNED NOT NULL DEFAULT '150000',


  `achievement_def_3` double(50,0) UNSIGNED NOT NULL DEFAULT '100000',


  `achievement_def_4` double(50,0) UNSIGNED NOT NULL DEFAULT '125000',


  `achievement_def_5` double(50,0) UNSIGNED NOT NULL DEFAULT '75000',


  `achievement_def_6` double(50,0) UNSIGNED NOT NULL DEFAULT '125000',


  `achievement_def_7` double(50,0) UNSIGNED NOT NULL DEFAULT '15000',


  `achievement_def_8` double(50,0) UNSIGNED NOT NULL DEFAULT '50000',


  `achievement_def_9` double(50,0) UNSIGNED NOT NULL DEFAULT '10000',


  `achievement_def_10` double(50,0) UNSIGNED NOT NULL DEFAULT '5000',


  `achievement_def_11` double(50,0) UNSIGNED NOT NULL DEFAULT '20000',


  `achievement_def_12` double(50,0) UNSIGNED NOT NULL DEFAULT '15000',


  `achievement_def_13` double(50,0) UNSIGNED NOT NULL DEFAULT '35000',


  `daily_produ` int(11) UNSIGNED NOT NULL DEFAULT '0'


) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I do not know what file and / or edit, can you help me please

Thank you in advance for your answers.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Hi Anthony,
There are so many impacts on something like this - not to mention security concerns - I would recommend you consider converting this to the standard nuke format and mapping the "custom" attributes (i.e. those that don't correspond to the standard RN user fields. Not something I'd want to do...

Posted: Fri May 12, 2017 9:38 am

Hello kguske

Thank you for your answer