phpBB.nl

Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/

Rabbitoschi

https://www.phpbb.nl/forums/viewtopic.php?f=45&t=8794

Pagina 1 van 2

Rabbitoschi

Geplaatst: 13 apr 2004, 07:47
door koudekerk
Ik heb een probleem met de mod rabbitoschi hij zegt dit

phpBB

: Critical Error

Error Getting Rabbitoshi Users!

DEBUG MODE

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

HOe moet ik dei database aanmaken
_________________

Geplaatst: 13 apr 2004, 08:12
door Just Me
Wil jij is vertellen van waar jij die "rabbitoschi" modd hebt ?? :?
ps dat moet hier niet staan maar in de mods topics :evil:

Geplaatst: 13 apr 2004, 14:12
door Luuk
Zoek :evil: http://www.phpbbhacks.com/searchresults ... rch_type=1

maar even voor koudekerk,

heb je de database veranderingen ook gedaan? Heb je de prefix ook veranderd van je database veranderingen?

Geplaatst: 13 apr 2004, 15:03
door koudekerk
wat is dat en waar kan ik dat doen en hoe??

Geplaatst: 13 apr 2004, 15:27
door Luuk
lees dit eens (onderaan, NR 10) http://www.phpbb.nl/kb.php?mode=article&k=24

Geplaatst: 13 apr 2004, 15:32
door V!ncent
je moet ff de databese aan maken.

Geplaatst: 13 apr 2004, 16:07
door koudekerk
Nu zegt die dit weer: En nu??
Fout

SQL-query :

INSERT INTO phpbb_config( config_name, config_value )
VALUES (

'rabbitoshi_enable', '1'
)

MySQL retourneerde:


#1062 - Duplicate entry 'rabbitoshi_enable' for key 1

Geplaatst: 13 apr 2004, 16:13
door Luuk
je moet phpbb_config veranderen naar jouwprefix_config

Geplaatst: 13 apr 2004, 16:35
door koudekerk
hoe doe ik dat?

Geplaatst: 13 apr 2004, 16:40
door Luuk
ga naar je database
rechts zie je allemaal tabellen staan, XXX_auth_access etc.
Op de plaats waar XXX staat, staat de prefix. Zo kom je erachter wat je prefix is.

Nu ga je naar SQL en voer je dit in:

Code: Selecteer alles

INSERT INTO XXX_config( config_name, config_value ) 
VALUES ( 

'rabbitoshi_enable', '1' 
)
Op de plaats van XXX vul je de prefix in

Geplaatst: 13 apr 2004, 17:38
door koudekerk
mijn prefix is phpbb (kan dat?) maar dan doet die het nog niet

Geplaatst: 13 apr 2004, 17:44
door Podium4
phpbb is inderdaad de standaard prefix... let wel op het is phpbb_ dus vergeet de underscore niet als je zelf de prefix moet invullen...

Controleer gelijk ook even of je alle wijzigingen hebt uitgevoerd voor de mod... MET NAME die in de includes/constants.php

Geplaatst: 13 apr 2004, 17:58
door koudekerk
wie wil en kan het oplossen als ik ff het wachtwoord van mijn phpmijadmin geef?? en mijn forum is http://www.maltastart.com/~forumfun/

Geplaatst: 14 apr 2004, 06:54
door koudekerk
niemand?

Geplaatst: 14 apr 2004, 13:32
door Luuk
zet de code die je uit moest voeren hier eens neer, die in install.txt staat dus.

Geplaatst: 14 apr 2004, 15:20
door koudekerk
[/code]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;

Code: Selecteer alles

 

Kan iemand het oplossen als ik het wachtwoord geef??

Geplaatst: 15 apr 2004, 14:02
door koudekerk
niemand? :thumb:

Geplaatst: 15 apr 2004, 14:03
door Luuk
ik kan het wel, maar ik denk dat je het zelf ook wel kunt hoor :roll:

Geplaatst: 16 apr 2004, 16:53
door koudekerk
Nauw heb ik al wat gemaakt maar nauw geeft die deze fout weer:

Could not obtain items pets information

DEBUG MODE

SQL Error : 1146 Table 'forumfun2.RABBITOSHI_SHOP_USERS_TABLE' doesn't exist

SELECT item_amount FROM RABBITOSHI_SHOP_USERS_TABLE WHERE user_id = 2 AND item_id = 1

Line : 194
File : /home/forumfun/public_html/includes/functions_rabbitoshi.php

Geplaatst: 16 apr 2004, 17:33
door hotrid
Luuk schreef:ik kan het wel, maar ik denk dat je het zelf ook wel kunt hoor :roll:
Tss..zeg dan gewoon niets! Hier heeft niemand wat aan :roll:

maarja...er staat dat de volgende tabel in je database (mysql) niet bestaat :
forumfun2.RABBITOSHI_SHOP_USERS_TABLE


terwijl dit je database staat :
phpbb_rabbitoshi


er moet dus ergens forumfun2.RABBITOSHI staan terwijl er phpbb_rabbitoshi moet staan...

{ik hoop dat je hier wat aan hebt}
Alle tijden zijn UTC+01:00
Pagina 1 van 2
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/