[Tutorial] How to use phpMyAdmin

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Anti-Spam Guide
indra
Registered User
Posts: 104
Joined: Fri Dec 31, 2010 8:20 am
Name: Indra Gunawan
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by indra »

thanks for the information..
its help full for me..
User avatar
mcjambi
Registered User
Posts: 38
Joined: Fri Dec 11, 2009 3:48 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by mcjambi »

phpmyadmin is so easy to use ! i think ! it's easier than Mysql query broser
muasamvui
Registered User
Posts: 4
Joined: Sun Apr 03, 2011 11:51 am
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by muasamvui »

eassy to use ! thanks !
i am Jam! thanks PHPBB and keep it free !
elecflip
Registered User
Posts: 6
Joined: Sat May 14, 2011 2:56 pm

Re: [Tutorial] How to use phpMyAdmin

Post by elecflip »

thanks
saintlantis
Registered User
Posts: 3
Joined: Thu Jun 30, 2011 3:48 am

Re: [Tutorial] How to use phpMyAdmin

Post by saintlantis »

Does anyone know how to remove a mod using phpmyadmin?

Thanks.
Mossy1337
Registered User
Posts: 9
Joined: Sun Aug 21, 2011 8:29 pm

Re: [Tutorial] How to use phpMyAdmin

Post by Mossy1337 »

Thank you so much for the tut! :)
Peter77sx
Registered User
Posts: 3260
Joined: Wed Nov 09, 2005 2:51 pm

Re: [Tutorial] How to use phpMyAdmin

Post by Peter77sx »

Is there a way to re enable forum using phpmyadmin? any info is apprecaited. :)

nvm, got it.
Jabhi
Registered User
Posts: 572
Joined: Mon Feb 27, 2012 6:12 am

Re: [Tutorial] How to use phpMyAdmin

Post by Jabhi »

I installed the mod with automod. Do I need to apply Sql query again ?
When I Run the below message is coming,
#1060 - Duplicate column name 'topic_first_post_show'
Go phpBB go... Respected : Developers, Supporters.
darksminky
Registered User
Posts: 132
Joined: Wed Jan 26, 2011 9:13 pm

Re: [Tutorial] How to use phpMyAdmin

Post by darksminky »

Jabhi wrote:I installed the mod with automod. Do I need to apply Sql query again ?
When I Run the below message is coming,
#1060 - Duplicate column name 'topic_first_post_show'
No, you're good.
err. . . what mod is it?
Jabhi
Registered User
Posts: 572
Joined: Mon Feb 27, 2012 6:12 am

Re: [Tutorial] How to use phpMyAdmin

Post by Jabhi »

^^
Thanks for taking interest. Problem was solved. I don't remember MOD name actually.Thanks.
Go phpBB go... Respected : Developers, Supporters.
sweet.ksh
Registered User
Posts: 101
Joined: Thu Sep 15, 2011 12:11 pm

Re: [Tutorial] How to use phpMyAdmin

Post by sweet.ksh »

plz tell me method of deleting this sql query i executed but now i want do remove it

query as following

Code: Select all

/* WARNING: do NOT execute the SQL commands on the phpbb_acl_options table more 
than once if you're upgrading or trying to repair a previous installation of the calendar mod.
Executing this command more than once will add duplicate entries to the table 
breaking your current permissions and causing the calendar to malfunction */

INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('a_calendar', 1, 0, 0),
('m_calendar_edit_other_users_events', 1, 0, 0),
('m_calendar_delete_other_users_events', 1, 0, 0),
('u_calendar_view_events', 1, 0, 0),
('u_calendar_edit_events', 1, 0, 0),
('u_calendar_delete_events', 1, 0, 0),
('u_calendar_create_public_events', 1, 0, 0),
('u_calendar_create_group_events', 1, 0, 0),
('u_calendar_create_private_events', 1, 0, 0),
('u_calendar_nonmember_groups', 1, 0, 0),
('u_calendar_track_rsvps', 1, 0, 0),
('u_calendar_allow_guests', 1, 0, 0),
('u_calendar_view_headcount', 1, 0, 0),
('u_calendar_view_detailed_rsvps', 1, 0, 0),
('u_calendar_create_recurring_events', 1, 0, 0),
('m_calendar_edit_other_users_rsvps', 1, 0, 0);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_config` (
  `config_name` varchar(255) NOT NULL,
  `config_value` varchar(255) NOT NULL
);

INSERT INTO `phpbb_calendar_config` (`config_name`, `config_value`) VALUES 
('first_day_of_week', '0'),
('index_display_week', '0'),
('index_display_next_events', '5'),
('hour_mode', '12'),
('display_truncated_name', '0'),
('prune_frequency', '0'),
('last_prune', '0'),
('prune_limit', '2592000'),
('display_hidden_groups', '0'),
('time_format','h:i a'),
('date_format','M d, Y'),
('date_time_format','M d, Y h:i a'),
('disp_events_only_on_start','0'),
('populate_frequency','86400'),
('last_populate','0'),
('populate_limit','2592000'),
('rsvp_color_yes', ''),
('rsvp_color_no', ''),
('rsvp_color_maybe', '');

CREATE TABLE IF NOT EXISTS `phpbb_calendar_event_types` (
  `etype_id` tinyint(3) unsigned NOT NULL auto_increment,
  `etype_index` tinyint(3) unsigned NOT NULL default '0',
  `etype_full_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `etype_display_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `etype_color` varchar(6) character set utf8 collate utf8_bin NOT NULL default '',
  `etype_image` varchar(255) NOT NULL,
  PRIMARY KEY  (`etype_id`)
);
INSERT INTO `phpbb_calendar_event_types` (`etype_id`,`etype_index`,`etype_full_name`,`etype_display_name`,`etype_color`,`etype_image`) VALUES 
 (1,1,'Generic Event','','','');

CREATE TABLE IF NOT EXISTS `phpbb_calendar_events` (
  `event_id` mediumint(8) unsigned NOT NULL auto_increment,
  `etype_id` tinyint(4) NOT NULL,
  `sort_timestamp` bigint(20) unsigned NOT NULL,
  `event_start_time` bigint(20) unsigned NOT NULL,
  `event_end_time` bigint(20) unsigned NOT NULL,
  `event_all_day` tinyint(2) NOT NULL default '0',
  `event_day` varchar(10) character set utf8 collate utf8_bin NOT NULL default '',
  `event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `event_body` longblob NOT NULL,
  `poster_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  `event_access_level` tinyint(1) NOT NULL default '0',
  `group_id` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
  `group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
  `enable_smilies` tinyint(1) unsigned NOT NULL default '1',
  `enable_magic_url` tinyint(1) unsigned NOT NULL default '1',
  `bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `track_rsvps` tinyint(1) unsigned NOT NULL default '0',
  `allow_guests` tinyint(1) unsigned NOT NULL default '0',
  `rsvp_yes` mediumint(8) unsigned NOT NULL default '0',
  `rsvp_no` mediumint(8) unsigned NOT NULL default '0',
  `rsvp_maybe` mediumint(8) unsigned NOT NULL default '0',
  `recurr_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`event_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_recurring_events` (
  `recurr_id` mediumint(8) unsigned NOT NULL auto_increment,
  `etype_id` tinyint(4) NOT NULL,
  `frequency` tinyint(4) NOT NULL default '1',
  `frequency_type` tinyint(4) NOT NULL default '0',
  `first_occ_time` bigint(20) unsigned NOT NULL,
  `final_occ_time` bigint(20) unsigned NOT NULL,
  `event_all_day` tinyint(2) NOT NULL default '0',
  `event_duration` bigint(20) unsigned NOT NULL,
  `week_index` tinyint(2) NOT NULL default '0',
  `first_day_of_week` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
  `last_calc_time` bigint(20) unsigned NOT NULL,
  `next_calc_time` bigint(20) unsigned NOT NULL,
  `event_subject` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `event_body` longblob NOT NULL,
  `poster_id` mediumint(8) unsigned NOT NULL default '0',
  `poster_timezone` decimal(5,2) NOT NULL default '0.00',
  `poster_dst` tinyint(1) unsigned NOT NULL default '0',
  `event_access_level` tinyint(1) NOT NULL default '0',
  `group_id` mediumint(8) unsigned NOT NULL default '0',
  `group_id_list` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default ',',
  `enable_bbcode` tinyint(1) unsigned NOT NULL default '1',
  `enable_smilies` tinyint(1) unsigned NOT NULL default '1',
  `enable_magic_url` tinyint(1) unsigned NOT NULL default '1',
  `bbcode_bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `bbcode_uid` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `track_rsvps` tinyint(1) unsigned NOT NULL default '0',
  `allow_guests` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`recurr_id`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_rsvps` (
  `rsvp_id` mediumint(8) unsigned NOT NULL auto_increment,
  `event_id` mediumint(8) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) unsigned NOT NULL default '0',
  `poster_name` varchar(255) collate utf8_bin NOT NULL default '',
  `poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
  `poster_ip` varchar(40) collate utf8_bin NOT NULL default '',
  `post_time` int(11) unsigned NOT NULL default '0',
  `rsvp_val` tinyint(1) unsigned NOT NULL default '0',
  `rsvp_count` smallint(4) unsigned NOT NULL default '1',
  `rsvp_detail` mediumtext collate utf8_bin NOT NULL,
  `bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `bbcode_uid` varchar(8) collate utf8_bin NOT NULL,
  `bbcode_options` tinyint(1) unsigned NOT NULL default '7',
  PRIMARY KEY (`rsvp_id`),
  KEY `event_id` (`event_id`),
  KEY `poster_id` (`poster_id`),
  KEY `eid_post_time` (`event_id`,`post_time`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_events_watch` (
  `event_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `notify_status` tinyint(1) unsigned NOT NULL default '0',
  `track_replies` tinyint(1) unsigned NOT NULL default '0',
  KEY `event_id` (`event_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_stat` (`notify_status`)
);

CREATE TABLE IF NOT EXISTS `phpbb_calendar_watch` (
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `notify_status` tinyint(1) unsigned NOT NULL default '0',
  KEY `user_id` (`user_id`),
  KEY `notify_stat` (`notify_status`)
);
Last edited by camm15h on Tue Sep 25, 2012 10:14 am, edited 1 time in total.
Reason: Code tags added.
Locked

Return to “[3.0.x] MODs in Development”