Pagina 1 van 1

Rabbitoshi error

Geplaatst: 29 apr 2004, 16:18
door deborah
ik heb de Rabbitoshi mod geinstaleerd,maar hij blijft zeggen dat de tabellen niet bestaan, ik heb de rabbitoshi_db_update.php gebruikt, wil ik m nog een keer gebruiken, en dan geeft ie errors aan,
ik weet niet wie deze mod gemaakt heeft maar er klopt niets van :roll:

Geplaatst: 29 apr 2004, 16:23
door WebSiteNet
Je kan zo oom met de hand invoeren in phpmyadmin

Code: Selecteer alles

#
#--------------[ SQL ]-------------
#
# Upload , run then delete the file rabbitoshi_db_update.php - Don't forget you have to first modify your files !
# Or run the following SQL requests :
#
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_name', 'Rabbistoshi');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_enable_cron', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_time', '86400');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('rabbitoshi_cron_last_time', '0');

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_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_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 '',
  PRIMARY KEY  (creature_id)
) TYPE=MyISAM;

INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (10, 'Eagle', 500, 150, 60, 150, 60, 3, 1, 0, 'Eagle.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (9, 'Tiger', 5000, 60, 400, 60, 400, 5, 1, 0, 'Tiger.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (8, 'Beaver', 30, 20, 20, 20, 50, 1, 1, 0, 'Beaver.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (7, 'Hiloterium', 50, 200, 200, 200, 1500, 5, 1, 0, 'Hiloterium.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (6, 'Dragon', 20000, 300, 1000, 5000, 250, 6, 1, 0, 'Dragon.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (11, 'Polar Bear', 700, 500, 500, 500, 500, 4, 1, 0, 'Polar_Bear.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (12, 'Rabbit', 20, 20, 20, 20, 50, 2, 1, 0, 'Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (13, 'Chaos Rabbit', 8000, 1500, 1500, 1500, 100, 2, 1, 12, 'Chaos_Rabbit.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (4, 'Lion', 240, 80, 70, 400, 120, 5, 1, 0, 'Lion.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (3, 'Cat', 40, 20, 20, 90, 20, 4, 1, 0, 'Cat.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (2, 'Dog', 40, 50, 50, 60, 100, 3, 1, 0, 'Dog.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (1, 'Chinchilla', 120, 100, 100, 15, 100, 1, 1, 0, 'Chinchilla.gif');
INSERT INTO phpbb_rabbitoshi_config (creature_id, creature_name, creature_prize, creature_max_hunger, creature_max_thirst, creature_max_health, creature_max_hygiene, creature_food_id, creature_buyable, creature_evolution_of, creature_img) VALUES (5, 'Penguin', 500, 120, 60, 75, 50, 4, 1, 0, 'Penguin.gif');

CREATE TABLE phpbb_rabbitoshi_general (
  config_name varchar(255) NOT NULL default '0',
  config_value int(15) NOT NULL default '0',
  PRIMARY KEY  (config_name)
) TYPE=MyISAM;

INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('thirst_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_time', 600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hunger_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_time', 3600);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hygiene_value', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_time', 86400);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('health_value', 5);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('rebirth_price', 50000);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('vet_price', 300);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('hotel_cost', 500);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_enable', 1);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_cost', 100);
INSERT INTO phpbb_rabbitoshi_general (config_name, config_value) VALUES ('evolution_time', 25);

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, 'Rabbitoshi_items_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, 'Rabbitoshi_items_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, 'Rabbitoshi_items_meat', 30, 'Rabbitoshi_items_meat_desc', 1, 3, 'Fresh_meat.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (4, 'Rabbitoshi_items_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, 'Rabbitoshi_items_gazelle', 100, 'Rabbitoshi_items_gazelle_desc', 1, 8, 'Gazelle.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (6, 'Rabbitoshi_items_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 (7, 'Rabbitoshi_items_limpid_water', 2, 'Rabbitoshi_items_limpid_water_desc', 2, 4, 'Limpid_water.gif');
INSERT INTO phpbb_rabbitoshi_shop (item_id, item_name, item_prize, item_desc, item_type, item_power, item_img) VALUES (8, 'Rabbitoshi_items_cleaner', 500, 'Rabbitoshi_items_cleaner_desc', 3, 10, 'Cleaner.gif');


CREATE TABLE phpbb_rabbitoshi_shop_users (
  item_id mediumint(8) NOT NULL default '0',
  user_id mediumint(8) NOT NULL default '0',
  item_amount mediumint(8) NOT NULL default '0',
  KEY item_id (item_id),
  KEY user_id (user_id)
) TYPE=MyISAM;

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_hunger int(8) NOT NULL default '0',
  creature_thirst int(8) NOT NULL default '0',
  creature_health int(8) NOT NULL default '0',
  creature_hygiene int(8) NOT NULL default '0',
  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',
  PRIMARY KEY  (owner_id)
) TYPE=MyISAM;

Geplaatst: 29 apr 2004, 16:25
door Luuk
code schreef:#
#--------------[ SQL ]-------------
#
# Upload , run then delete the file rabbitoshi_db_update.php - Don't forget you have to first modify your files !
# Or run the following SQL requests :
#
--bestand--
daarom gaat het denk ik mis, je hebt denk ik eerst het bestand uitgevoerd en daarna veranderd, het moet dus andersom.

Geplaatst: 29 apr 2004, 16:25
door deborah
k heb een db generator die maakt er een bestand van die dat allemaal automatisch doet,, dat had ik al geprobeerd, maar dan geeft ie ook errors aan:S

Geplaatst: 29 apr 2004, 16:27
door deborah
is er een iets waarmee ik die tabellen kan verijderen?
dan doe k t ff opnieuw :wink:

Geplaatst: 29 apr 2004, 16:28
door WebSiteNet
Als ze er al in staan is er geen probleem (Je kan ze wel we halen met phpmyadmin).

maar hij blijft zeggen dat de tabellen niet bestaan
Wat is de error dan?

Geplaatst: 29 apr 2004, 16:32
door deborah
ik ken niet in php admin komen,
ik zit op een database die niet van mij is namelijk, dus zoek een bestand waarmee ik die tabellen kan weghalen

als ik naar mn forum ga en die link aanklik staat er dit
phpBB : Critical Error

Error Getting Rabbitoshi Users!

DEBUG MODE

SQL Error : 1146 Table 'nature.RABBITOSHI_USERS_TABLE' doesn't exist

Geplaatst: 29 apr 2004, 16:37
door WebSiteNet
1. Je kan phpmyadmin ook zelf instaleren.

2. Heb je includes/constants.php goed gemod en upgeload?

Geplaatst: 29 apr 2004, 16:41
door deborah
ja alles is goed gemod en geupload :roll:

Geplaatst: 29 apr 2004, 16:45
door deborah
ik denk dat ik m maar beter kan verwijderen, en kan laten zitten, er valt niets meer aan te repareren :roll: