Database backup van phpbb

DonvanVliet · Bericht door **DonvanVliet** » 14 jul 2004, 09:20

Jongens kunnen jullie even naar de volgende jpeg kijken of de zaak goed aangevinkt is in phpMyAdmin (dit is standaard zo aangevinkt in MyAdmin het enige vinkje dat ik heb gezet is bij "verzenden") want ik wil namelijk mijn forum naar een andere host overbrengen.

http://www.donvanvlietontheweb.nl/upload/myadmin.jpg

In de Tutorial staat wel een voorbeeld maar ik heb de laatste MyAdmin dat ziet er toch anders uit en ik wil het ff zeker weten.

Alvast bedankt - Lex 8)

Igor Costa · Bericht door **Igor Costa** » 14 jul 2004, 09:38

Je moet daar bij exporteer alles selecteren.

DonvanVliet · Bericht door **DonvanVliet** » 15 jul 2004, 08:43

Mooi ik ga het uitvoeren.

Thanks 8)

DonvanVliet · Bericht door **DonvanVliet** » 18 jul 2004, 10:01

Nou de backup uitgevoerd met behulp van de Tutorial.
De complete Database in 1 keer overzetten ging niet dushet werdt knippen en plakken. Wat een kolerewerk zeg, 3 uur bezig geweest omdat teveel tekst niet gaat dus stukjes van ongeveer 2000 regels ging best.

Ik opende het forum wat prima ging is het een forum uit het verleden (ong.februari) met een paar leden en oude berichten.???????
Hoe kan dit nu weer?????

Is er soms een instelling niet goed met de backup van de database????????

DonvanVliet · Bericht door **DonvanVliet** » 19 jul 2004, 10:25

Kunnen jullie nog eens kijken of de vakjes die aangevinkt zijn wel aangevinkt moeten zijn. http://www.donvanvlietontheweb.nl/upload/myadmin.jpg

superman5000 · Bericht door **superman5000** » 19 jul 2004, 11:59

ik vink bij data ook altijd alles aan.
verder moet je als er al iets in de DB staat dit ook nog aanvinken.
'drop table' toevoegen
veel succes.

mosymuis · Bericht door **mosymuis** » 19 jul 2004, 13:24

"Drop table" is inderdad handig als je over een bestaande backup heenschrijft, de 3 opties bij "Data" zijn niet perse nodig. "Uitgebreide invoegingen" verkleint de backup wel enigzins, maar maakt het lastig de query op te delen in stukken (mocht dat nodig zijn), en vergt meer van de database server bij het importeren.

DonvanVliet · Bericht door **DonvanVliet** » 19 jul 2004, 18:09

phpbb_search_wordmatch Alles wat daar in staat kan ik dat niet weglaten want dat zijn ongeveer 58000 rijen.

mosymuis · Bericht door **mosymuis** » 19 jul 2004, 18:12

Ja, dat kan. Zie:
http://www.phpbb.nl/viewtopic.php?p=100050#100050

DonvanVliet · Bericht door **DonvanVliet** » 19 jul 2004, 19:34

Dus...........alleen deze tabellen runnen:

CREATE TABLE `phpbb_search_wordlist` (
`word_text` varchar(50) binary NOT NULL default '',
`word_id` mediumint(8) unsigned NOT NULL auto_increment,
`word_common` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`word_text`),
KEY `word_id` (`word_id`)
) TYPE=MyISAM AUTO_INCREMENT=13522 ;

en

CREATE TABLE `phpbb_search_wordmatch` (
`post_id` mediumint(8) unsigned NOT NULL default '0',
`word_id` mediumint(8) unsigned NOT NULL default '0',
`title_match` tinyint(1) NOT NULL default '0',
KEY `post_id` (`post_id`),
KEY `word_id` (`word_id`)
) TYPE=MyISAM;

En dan die mod draaien dan zou alles weer in orde moeten zijn.

mosymuis · Bericht door **mosymuis** » 19 jul 2004, 19:43

Die twee tabellen zijn de enigsten waarvan je alleen de structuur van nodig hebt, van alle andere heb je de structuur én data nodig.

DonvanVliet · Bericht door **DonvanVliet** » 19 jul 2004, 20:05

Wacht even wat bedoel je met de "structuur"? Als je die 2 runt in je database heb je toch de structuur?

mosymuis · Bericht door **mosymuis** » 19 jul 2004, 20:07

Klopt inderdaad, de query die je hierboven postte bevat de structuur.

DonvanVliet · Bericht door **DonvanVliet** » 20 jul 2004, 09:06

Ja ok ben bezig nu, maar wat moet ik met onderstaande error nu ik de database aan het aanmaken ben?

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO `phpbb_hacks_list` VALUES (3, 0, 'Admin Account

DonvanVliet · Bericht door **DonvanVliet** » 20 jul 2004, 10:27

Nou mooi is dat, weer het hele spul overgehevelt en is het weer een forum van ongeveer 6 maanden geleden.
Ik weet het niet meer.

mosymuis · Bericht door **mosymuis** » 20 jul 2004, 14:22

DonvanVliet schreef:Ja ok ben bezig nu, maar wat moet ik met onderstaande error nu ik de database aan het aanmaken ben?

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO `phpbb_hacks_list` VALUES (3, 0, 'Admin Account

Wat is het volledige stukje SQL waar deze error over spreekt?

DonvanVliet · Bericht door **DonvanVliet** » 20 jul 2004, 14:54

Laat maar maat want er was een hele berg van deze errors en ik heb besloten de nieuwste plus versie te installeren. Misschien kan ik nog wat oude posts en users overbrengen.
Die users ook, het zijn er een stuk of 97 en in het forum dat is verplaats een stuk of 8. Als je de userlist dan wil bekijken krijg je dat de pagina niet is gevonden en ga zo maar door.

In ieder geval bedankt voor de moeite.

DonvanVliet · Bericht door **DonvanVliet** » 20 jul 2004, 14:58

Ok hier heb je het dan toch:

CREATE TABLE `phpbb_hacks_list` (
`hack_id` mediumint(8) unsigned NOT NULL auto_increment,
`hack_add_date` int(10) unsigned NOT NULL default '0',
`hack_name` varchar(255) NOT NULL default '',
`hack_desc` varchar(255) NOT NULL default '',
`hack_author` varchar(255) NOT NULL default '',
`hack_author_email` varchar(255) NOT NULL default '',
`hack_author_website` tinytext NOT NULL,
`hack_version` varchar(32) NOT NULL default '',
`hack_hide` enum('Yes','No') NOT NULL default 'No',
`hack_download_url` text NOT NULL,
`hack_file` varchar(255) NOT NULL default '',
`hack_file_mtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`hack_id`),
UNIQUE KEY `hack_name` (`hack_name`),
KEY `hack_hide` (`hack_hide`),
KEY `hack_file` (`hack_file`)
) TYPE=MyISAM AUTO_INCREMENT=169 ;

#
# Gegevens worden uitgevoerd voor tabel `phpbb_hacks_list`
#

INSERT INTO `phpbb_hacks_list` VALUES (28, 0, 'Gender Mod', 'This mod will add a Gender field into users\' profile, and display "Gender: |image|" in posts too', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.2.6', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (3, 0, 'Admin Account Actions', 'Displays all users which expect an account activation on an extra site inside the admin panel (admin activation and user activation). You can activate or delete them.', 'Acid', '', '', '1.2.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (6, 0, 'Supercharged Album Pack 1', 'A series of modification for Album version 2 by Smartor ( http://smartor.is-root.com )', 'Volodymyr (CLowN) Skoryk', '', '', '1.5.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (7, 0, 'Photo Album Addon v2 for phpBB2', 'This is a phpBB-based photo album/gallery management system.', 'Smartor', 'smartor_xp@hotmail.com', 'http://smartor.is-root.com', '', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (8, 0, 'Align text BBcode Mod', 'Adds a text alignment bbcode tag to your forum', 'davidls', 'davidls14@yahoo.com.au', 'http://www27.brinkster.com/bb2c', '2.0.6', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (9, 0, 'Anti Robotic Register Flood', 'This will add a Random-graphical-text Vadiation field in Registration form to protect your phpBB from being flooded of robotic-member-registration (like many free webhost signup form...)', 'Smartor', 'smartor_xp@hotmail.com', 'http://smartor.is-root.com', '1.1.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (12, 0, 'File Attachment Mod v2', 'This Mod adds the ability to attach files in phpBB2.', 'Acyd Burn', '', 'http://www.opentools.de', '2.3.9', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (13, 0, 'BBCode Buttons Organizer', 'Allows for neater display of additional quick BBCode buttons.', 'Nuttzy', 'nospam@blizzhackers.com', 'http://www.blizzhackers.com', '1.2.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (14, 0, 'Birthday Mod', 'This mod will add a birthday field into your user\'s profile and make users age viewable to others when viewing posts.', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.5.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (15, 0, 'Birthday ADD-ON Chinese zodiac\'s in viewtopic', 'if the user have filled a birthday date, a chinese zodiac image will be displayed in the viewtopic. this is a ADD-ON and will require Birthday mod to be installed before it will work', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (16, 0, 'Birthday ADD-ON Chinese zodiac', 'if the user have filled a birthday date, a chinese zodiac image will be displayed in the users profile. this is a ADD-ON and will require Birthday mod to be installed before it will work', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (17, 0, 'Birthday ADD-ON zodiac\'s', 'if the user have filled a birthday date, a zodiac image will be displayed in the users profile/beside users posts. this is a ADD-ON and will require Birthday mod to be installed before it will work', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.0.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (18, 0, 'Bookmarks Mod', 'Keeps an internal list of bookmarks set by the user', 'PhilippK', 'phpBB2004@kordowich.net', 'http://phpbb.kordowich.net/', '1.1.1a', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (19, 0, 'Slash News Mod', 'Allows you to assign a news category to any new topic. The topic can then be displayed as news with a category graphic like Slashdot', 'CodeMonkeyX', 'nickyoungso@yahoo.com', 'http://www.codemonkeyx.net', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (20, 0, 'Color Groups Mod', 'This mod will replace the current name colorization with a group system. You may define your group name, group color, and group members', 'Nivisec', 'support@nivisec.com', 'http://www.nivisec.com', '1.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (21, 0, 'Complete banner Mod', 'This mod makes it posible to add banners to your phpbb2 pages, by default banners are placed in top/botton but you may place the tags, inside any template file', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.3.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (22, 0, 'Country Flags', 'This mod allows your registered board members to select the flag of their country. Their flag will then display thoughout the phpBB system', 'Nuttzy99', 'pktoolkit@blizzhackers.com', 'http://www.blizzhackers.com', '2.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (23, 0, 'ezPortal Admin for phpBB2', 'This mod will add a small administration menu for the ezPortal from Smartor', 'Marcus Thiel', 'thundercat@die-pretorianer.de', 'http://www.die-pretorianer.de', '1.0.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (24, 0, 'ezPortal', 'This Mod explains you how to create a portal for phpBB2 as simple as possible. This MOD is not exactly a full functional portal system (content management system) but it looks like a portal. You should customize/modify/improve it to fit your fantasy

It', 'Smartor', 'smartor_xp@hotmail.com', 'http://smartor.is-root.com', '2.1.8', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (30, 0, 'Glow and Shadow effects BBcode Mod', 'adds a glow and shadow bbcode tags to your forum', 'davidls', 'davidls14@yahoo.com.au', 'http://www27.brinkster.com/bb2c', '2.0.6', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (32, 0, 'Junior Admin Mod', 'This will allow you to define any and all users you\'d like to have access to whatever admin modules you\'d like', 'Nivisec', 'support@nivisec.com', 'http://www.nivisec.com', '2.0.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (33, 0, 'Last visit Mod', 'This mod will register when the user last logged in, allong with the info about how many users have visited the board', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.2.8', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (34, 0, 'Announces Suite', 'This mod allows you to display the announces from the forum on the index page, and above the forum pages for the announce coming from forums of the same categories. It adds also a duration to each announcement, and global announcement', 'Ptirhiik', 'admin@rpgnet-fr.com', 'http://rpgnet.clanmckeen.com', '3.0.2', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (35, 0, 'Categories hierarchy Mod', 'This mod allows to attach a categorie to a higher level categorie, keeping all the forum visible on the index page (vBulletin-like view), or have a sub-forum view.', 'Ptirhiik', 'ptirhiik@clanmckeen.com', 'http://rpgnet.clanmckeen.com', '2.0.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (36, 0, 'Post Icons Mod', 'This mod will allow to add an icon in front of each topic title. This part is common to all board setup.', 'Ptirhiik', 'ptirhiik@clanmckeen.com', 'http://rpgnet.clanmckeen.com', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (38, 0, 'Ranks summarize', 'This mod displays all the ranks available on your board', 'Ptirhiik', 'admin@rpgnet-fr.com', 'http://www.rpgnet-fr.com', '1.0.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (40, 0, 'Split topic type', 'This mod splits the topic per type in the viewform display', 'Ptirhiik', 'admin@rpgnet-fr.com', 'http://rpgnet.clanmckeen.com', '2.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (41, 0, 'Topic calendar Mod', 'This mod adds a calendar to your board, working with natural phpBB auth.', 'Ptirhiik', 'ptirhiik@clanmckeen.com', 'http://rpgnet.clanmckeen.com', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (42, 0, 'Multiple BBCode MOD', 'Allows you to install BBCode MODs that add quick BBCode buttons in post edits. Without this MOD, there is no standard way of installing BBCode MODs.\r\n', 'Nuttzy99', 'nospam@blizzhackers.com', 'http://www.blizzhackers.com', '1.2.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (43, 0, 'Online/Offline Indicator', 'This MOD outputs graphically a user\'s online status in Topics and the Memberlist', 'romans1423', 'romans1423@hotmail.com', 'http://www.beckman-ministries.com', '1.3.2', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (44, 0, 'Download Mod pafiledb with MX Addon', 'Integration of pafiledb (Database download manager) with phpbb. pafiledb use header, footer, session, template, and database system of phpbb', 'mohd + mx-system', 'mohdalbasri@yahoo.com', 'http://mohd.vraag-en-antwoord.nl/main/', '0.0.9d', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (46, 0, 'Printtopic Mod', 'Generates printable Versions of Topics', 'Unknown', '', '', '', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (48, 0, 'Advanced Quick Reply Mod', 'Adds a Quick Reply Box to the Topic View', 'Unknown', '', '', '', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (49, 0, 'Fully integrated shoutbox', 'A fully phpBB2 enabled shoutbox witch support: database abstration layer, timezones, languages, templates, smilies, BBcode and censored words', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.1.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (50, 0, 'Smartor Album Add-On: Random or Recent Photo', 'Display a random or recent photo on your forum main page or chosen from a category only.', 'SeekIdeas', 'cfsilent@yahoo.com', 'http://www.seekideas.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (52, 0, 'Smilie Creator Mod', 'This Mod adds a BBCode [schild=1]text[/schild] to your phpBB2 whick allows Users to post Smilies with own Text in their postings', 'esperitox', 'bockelmann@powerforum.de', 'http://www.powerforum.de', '1.0.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (54, 0, 'Staff Site Mod', 'An external site to display who is Mod or Admin on your board. Some additional infos. (see optional part to add other columns)', 'Acid', '', '', '2.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (56, 0, 'Tell a Friend Mod', 'Adds a function to sent Topics as EMail to Friends', 'Unknown', '', '', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (58, 0, 'Today At/Yesterday At Mod', 'Will show Today At if the post was posted today, Will show Yesterday At if the post was posted yesterday', 'akzhaiyk', 'phpbb2xp@myrunet.com', 'http://phpbb2xp.myrunet.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (59, 0, 'Who viewed a topic Mod', 'This MOD will add the ability to logged users to see who has already viewed the topic they\'re watching. A small image is added to the viewtopic page for this', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.0.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (62, 0, 'Recent Topics (third version)', 'Shows recent topics on an extra site (last 24 hour, last week,yesterday, last x days, today)', 'Acid', '', '', '1.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (66, 0, 'FI SubSilver Template', 'Template FI Subsilver Shadow 2.1.1 - Wonderful Template done by Darren Burnhill from http://www.forumimages.com', 'Darren Burnhill', '', 'http://www.forumimages.com', '2.1.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (68, 0, 'FI Navslices', 'Adds Navslices to the Viewtopic View with several Actions like EMail to Friend, Printtopic etc..', 'Darren Burnhill', '', 'http://www.forumimages.com', '', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (69, 0, 'Private Message Info in Browser Status Bar', 'This MODification adds PM info (you have no new messages, etc..) to the browser status bar.', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (71, 0, 'FI SubSilver CodeExpand', 'This MODification changes the Code formatting in posts to use resizable DIVs as well as making it so that the code is automatically selected', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.1.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (76, 0, 'BBCode Fade Mod', 'This takes the text between the tags and makes it fade away! Starts off normal then as the line continues until it just disappears', 'Brewjah', 'blackhash@rogers.com', 'http://forums.gotdns.com', '1.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (78, 0, 'BBCode Scroll aka Marquee Mod', 'Displays scrolling text using the marquee tag', 'Nuttzy99', 'pktoolkit@blizzhackers.com', 'http://www.blizzhackers.com', '1.2.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (81, 0, 'BBcode Highlight Mod', 'Adds a highlight bbcode tag to your forum', 'David Smith', 'davidls14@yahoo.com.au', 'http://www27.brinkster.com/bb2c', '1.2.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (83, 0, 'Macromedia Flash Player BBcode MOD', 'This mod adds a flash tag to your forum, this version removes the need to use the loop param, and if you want you can remove the width and height params as well', 'davidls', 'davidls14@yahoo.com.au', 'http://www27.brinkster.com/bb2c', '2.0.6', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (87, 0, 'BBCode FlipV / FlipH Mod', '[flipv]some text[/flipv] and [fliph]some text[/fliph]', 'Brewjah', 'blackhash@rogers.com', '', '1.6.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (88, 0, 'Streaming audio BBcode Mod', 'adds a stream bbcode tag to your forum for the windows media player plugin', 'David Smith', 'davidls14@yahoo.com.au', 'http://www27.brinkster.com/bb2c', '2.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (91, 0, 'Left and Right IMG tags', 'Adds BBCode to let you align your Pics left and right', 'Nuttzy', 'pktoolkit@blizzhackers.com', 'http://www.blizzhackers.com', '1.6.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (94, 0, 'PHP Syntax Highlighter BBCode', 'Highlights PHP specific code when used', 'Fubonis', 'php_fubonis@yahoo.com', 'http://www.fubonis.com', '3.0.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (97, 0, 'Board Statistics Mod', 'The Statistics Mod is a complete statistics core for your phpBB 2 board', 'Acyd Burn, Nivisec', 'acyd.burn@gmx.de', 'http://www.opentools.de/board', '2.1.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (98, 0, 'Admin Hacks List', 'Adds a list of Hacks/Mods to your phpBB2', 'Nivisec', 'support@nivisec.com', 'http://www.nivisec.com', '1.20', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (101, 0, 'Advanced Links Mod', 'Display links (with logo) on the forum index page', 'stefan2k1, CRLin', '', 'http://www.phpbb2.de', '1.2.2b', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (104, 0, 'Full Database Backup Mod', 'Now you can use the Backup Function in phpBB2 Admin Panel to Backup ALL Tables, even those from your MODs, you make a FULL backup now', 'Unknown', '', '', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (110, 0, 'Topic View Page Bottom Link', 'This MODification adds a link that takes you to the bottom of the topic view pages', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (113, 0, 'Smartors Photo Album Addon 2.x View Topic Link', 'This MODification adds a link to the members personal photo gallery for Smartors Photo Album Addon version 2.x on the View Topic pages', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (114, 0, 'Smartors Photo Album Addon 2.x Member List Link', 'This MODification adds a link to the members personal photo gallery for Smartors Photo Album Addon version 2.x on the Member List pages', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (115, 0, 'Smartors Photo Album Addon 2.x View Profile Link', 'This MODification replaces the link to the members personal photo gallery for Smartors Photo Album Addon version 2.x on the View Profile pages', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (118, 0, 'Google Search BBCode', 'Allows you put make strings in your post be searched for in Google. (string to search for)', 'wGEric', 'eric@egcnetwork.com', 'http://eric.best-1.biz ', '1.1.2', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (121, 0, 'Yellow Card Mod', 'Also known as "card system" This mod will make 4 colored buttons beside users post (red,yellow,green and blue)', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.4.11', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (122, 0, 'Protect user account', 'This mod will prevent hacking on users password, and give the admin the posibilty to specify witch types of passwords are accepted', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.2.9', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (125, 0, 'BBCode Line-through Mod', 'Adds BBCode with Line-Through words ', 'Acid', '', '', '1.0.2', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (128, 0, 'Topic Description Mod', 'This MOD allow you to add a little description of the topic that you have posted', 'Morpheus2matrix', 'morpheus2matrix@caramail.com', 'http://morpheus.2037.biz', '1.0.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (129, 0, 'Prune users Mod', 'Admin plug-in that makes it posible to delete users who are inactive/haven\'t posted or like.', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '1.4.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (133, 0, 'Admin Add Users Mod', 'Admin can now create a new user, using admin panel user management.', 'Niels', 'ncr@db9.dk', 'http://mods.db9.dk', '0.10.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (140, 0, 'Count posts Mod', 'Allows you to select if posts in forum are counted upon creation', 'Antony Bailey', '', '', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (142, 0, 'Topic in Who is online', 'This mod will make it possible to view exactly witch topic a user is looking at. The information is applyed in the Who-is-online list', 'Niels', '', 'http://mods.db9.dk', '1.2.9', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (145, 0, 'Admin Userlist', 'This MOD will add an userlist into your AdminCP', 'Smartor', 'smartor_xp@hotmail.com', 'http://smartor.is-root.com', '1.1.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (146, 0, 'Admin Email List', 'This mod will list all email addresses from your phpbb database, within the admin cp', 'Jamer', '', 'http://www.jamer.co.uk/scripts/phpbb2', '1.0.2', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (147, 0, 'Bottom aligned signature', 'This mod will align signatures at the bottom of posts', '-=ET=-', 'space_et@tiscali.fr', 'http://www.golfexpert.net/phpbb', '1.0.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (150, 0, 'Kontakt Mod', 'Adds a contact Form to your Forum', 'Carsten Schaefer', '', '', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (151, 0, 'Mini Cal', 'Provides a mini calendar on your forum index page', 'netclectic', 'phpbb@netclectic.com', 'http://www.netclectic.com', '2.0.4', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (152, 0, 'Moved Folder Mod', 'Adds a Moved Folder Image to your Forum', 'Darren Burnhill', '', 'http://www.forumimages.com', '1.0.0', 'No', 'http://www.forumimages.com/info/mods/moved_folder.php', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (155, 0, 'Acronym Mod', 'Provides automatic acroymn additions to posts', 'CodeMonkeyX', 'nickyoungso@yahoo.com', 'http://www.codemonkeyx.net', '0.9.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (156, 0, 'Disable Board Message', 'Customize disable board message', 'Sko22', 'webmaste@quellicheilpc.com', 'http://www.quellicheilpc.com', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (159, 0, 'Signature Editor/Preview Deluxe', 'This mod adds a really cool Signature Editor to your Board, included Preview & Save & BBCodes', 'Ego2000', '', '', '1.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (162, 0, 'Absent User Mod', 'If an user is on holidays, ill or simply not on the board for a longer time, he/she can set to be absent with this mod', 'Oxpus', 'webmaster@oxpus.de', 'http://www.oxpus.de', '1.1.6', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (163, 0, 'Album Hierarchy Mod', 'This mod allows to create multiple sub categories of each (sub) categories in the Photo Album Addon', 'IdleVoid', 'idlevoid@slater.dk', '', '1.0.5', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (164, 0, 'Portal Polls Upgrade', 'Alters the display and behavior of the Poll Block', 'vgan', 'transflux@msn.com', '', '2.0.0', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (165, 0, 'Modcp Extension', 'Extend the moderators control panel to include Sticky / Announce / Normal of topics', 'netclectic', 'adrian@netclectic.com', 'http://www.netclectic.com', '1.1.3', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (166, 0, 'Simply Merge Threads', 'This mod allows to merge two topics', 'Ptirhiik', 'admin@rpgnet-fr.com', 'http://www.rpgnet-fr.com', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (167, 0, 'Dates for Humans Mod', 'Allows users to select their date format from a pre-defined selection of examples', 'Lars Janssen', 'lars.dfh@ukmix.net', 'http://www.ukmix.org/', '1.0.1', 'No', '', '', 0);
INSERT INTO `phpbb_hacks_list` VALUES (168, 0, 'Google Visit Counter', 'Adds a google bot visit counter on index', 'Dr DLP', '', 'http://www.web-lapin.levillage.org/forum/', '1.0.0', 'No', '', '', 0);

Rico · Bericht door **Rico** » 20 jul 2004, 14:59

Leuk die smiley er in

mosymuis · Bericht door **mosymuis** » 20 jul 2004, 15:04

Rico schreef:Leuk die smiley er in

Spammen doe je maar ergens anders.

@DonvanVliet: dit is de query waar hij over struikelt, maar ik zie er zo geen fouten in, helaas.

Code: Selecteer alles

INSERT INTO `phpbb_hacks_list` VALUES (3, 0, 'Admin Account Actions', 'Displays all users which expect an account activation on an extra site inside the admin panel (admin activation and user activation). You can activate or delete them.', 'Acid', '', '', '1.2.1', 'No', '', '', 0);