Hi ...
Code: Alles auswählen
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('exp_lose', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_price', 50);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_price', 20);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_price', 20);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_price', 20);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('level_price', 500);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('power_price', 50);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('magicpower_price', 50);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('armor_price', 50);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('attack_price', 100);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('magicattack_price', 100);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('mp_price', 50);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_raise', 5);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_raise', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_raise', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_raise', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('power_raise', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('magicpower_raise', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('armor_raise', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('attack_raise', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('magicattack_raise', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('mp_raise', 2);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('level_raise', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('experience_min', 5);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('experience_max', 20);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('mp_min', 3);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('mp_max', 10);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('attack_reload', 10);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('magic_reload', 15);
CREATE TABLE phpbb_rabbitoshi_users (
owner_id int(8) NOT NULL default '0',
owner_last_visit int(11) NOT NULL default '0',
owner_creature_id smallint(2) NOT NULL default '0',
owner_creature_name varchar(255) NOT NULL default '',
creature_level int(8) NOT NULL default '1',
creature_power int(8) NOT NULL default '0',
creature_magicpower int(8) NOT NULL default '0',
creature_armor int(8) NOT NULL default '0',
creature_experience int(8) NOT NULL default '0',
creature_hunger int(8) NOT NULL default '0',
creature_hunger_max int(8) NOT NULL default '0',
creature_thirst int(8) NOT NULL default '0',
creature_thirst_max int(8) NOT NULL default '0',
creature_health int(8) NOT NULL default '0',
creature_health_max int(8) NOT NULL default '0',
creature_mp int(8) NOT NULL default '0',
creature_max_mp int(8) NOT NULL default '0',
creature_hygiene int(8) NOT NULL default '0',
creature_hygiene_max int(8) NOT NULL default '0',
creature_attack int(8) NOT NULL default '1',
creature_attack_max int(8) NOT NULL default '1',
creature_magicattack int(8) NOT NULL default '1',
creature_magicattack_max int(8) NOT NULL default '1',
creature_age int(11) NOT NULL default '0',
creature_hotel int(11) NOT NULL default '0',
owner_notification tinyint(1) NOT NULL default '0',
owner_hide tinyint(1) NOT NULL default '0',
owner_feed_full tinyint(1) NOT NULL default '1',
owner_drink_full tinyint(1) NOT NULL default '1',
owner_clean_full tinyint(1) NOT NULL default '1',
creature_statut int(8) NOT NULL default '0',
creature_avatar varchar(255) NOT NULL default 'default_avatar.gif',
creature_invoc int(8) NOT NULL default '0',
creature_experience_level int(8) NOT NULL default '0',
creature_experience_level_limit int(8) NOT NULL default '0',
PRIMARY KEY (owner_id)
) TYPE=MyISAM;
CREATE TABLE phpbb_rabbitoshi_config (
creature_id smallint(2) NOT NULL default '0',
creature_name varchar(255) NOT NULL default '',
creature_prize int(8) NOT NULL default '0',
creature_power int(8) NOT NULL default '0',
creature_magicpower int(8) NOT NULL default '0',
creature_armor int(8) NOT NULL default '0',
creature_max_hunger int(8) NOT NULL default '0',
creature_max_thirst int(8) NOT NULL default '0',
creature_max_health int(8) NOT NULL default '0',
creature_mp_max int(8) NOT NULL default '0',
creature_max_hygiene int(8) NOT NULL default '0',
creature_food_id smallint(2) NOT NULL default '0',
creature_buyable tinyint(1) NOT NULL default '1',
creature_evolution_of int(8) NOT NULL default '0',
creature_img varchar(255) NOT NULL default '',
creature_experience_max int(8) NOT NULL default '100',
PRIMARY KEY (creature_id)
) TYPE=MyISAM;
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_power, creature_magicpower, creature_armor, creature_max_hunger, creature_max_thirst, creature_max_health, creature_mp_max, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img, creature_experience_max) VALUES (1, 'Beaver', 300, 2, 3, 5, 20, 20, 30, 10, 15, 1, 1, 0, 'Beaver.gif', 500);
CREATE TABLE phpbb_rabbitoshi_shop (
item_id smallint(1) NOT NULL default '0',
item_name varchar(255) NOT NULL default '',
item_prize int(8) NOT NULL default '0',
item_desc varchar(255) NOT NULL default '',
item_type smallint(1) NOT NULL default '0',
item_power int(8) NOT NULL default '0',
item_img varchar(255) NOT NULL default '',
PRIMARY KEY (item_id)
) TYPE=MyISAM;
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (1, 'Seeds', 10, 'Rabbitoshi_items_seeds_desc', 1, 1, 'Seeds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (2, 'Carrots', 20, 'Rabbitoshi_items_carrots_desc', 1, 20, 'Carotts.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (3, 'Meat', 30, 'Rabbitoshi_items_meat_desc', 1, 3, 'Meat.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (4, 'Fish', 30, 'Rabbitoshi_items_fish_desc', 1, 3, 'Fish.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (5, 'Diamonds', 500, 'Rabbitoshi_items_diamonds_desc', 1, 10, 'Diamonds.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (6, 'Water', 2, 'Rabbitoshi_items_limpid_water_desc', 2, 4, 'Water.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (7, 'Cleaner', 500, 'Rabbitoshi_items_cleaner_desc', 3, 10, 'Cleaner.gif');
