db vraagje phpbb3.0

[joeri]

Hallo,

ik heb easymod geinstalleerd en heb een mod geinstalleerd ook.
Dit ging me vrij vlot
Nu had ik al spam mail op mijn forum en wilde deze users van de spammails verwijderen.

Nu krijg ik foutmelding bij het registreren op mijn forum.
Als ik me wil registreren en druk op "ik ben ouder dan 13" dan krijg ik het bericht dat deze username al bestaat.
En als ik me wil uitloggen krijg ik een error. Als ik dan terug keer naar de vorige pagina en opnieuw probeer lukt het me wel.

Nu heb ik per ongeluk user id -1 verwijderd uit mijn database van phpbb3.0.
Ik weet wel nog dat deze anonymous heette maar weet de rest niet meer.
Kan iemand me een link geven waar ik deze kan terug vinden en deze kan terug plaatsen in mijn database.
Ik denk dat het komt omdat ik deze heb verwijderd.

Alvast bedankt voor de hulp

Mvg joeri

[joeri]

Geachte

Als er me iemand hulp kan bieden zou ik dit graag weten.
Ik vind het enkel wat jammer dat er niemand iets terug schrijft.

mvg joeri

[Stef]

Geachte Heer Joeri,

Het kan wel eens gebeuren dat er op een bericht niet binnen 7 uur geantwoord wordt. Dit betreuren wij dan ook ten stelligste. We proberen zo snel mogelijk een geschikte medewerker voor u probleem te vinden.

Een ogenblik geduld alstublieft.

Hoogachtend,

Stef
phpBB.nl

[joeri]

Hallo

Bedankt voor deze tip.
Zal dan alleen maar geduld uitoefenen en wachtten he.

mvg joeri

[joeri]

Hallo

Na 3 dagen wachten op antwoord geef ik jullie een nieuwe vraag.
Kan iemand me de gegevens doorsturen van die anonymous user in de tabel users?
Dan zal ik deze handmatig terug toevoegen


Mvg joeri

[nickdhnick]

alstu:

Code: Selecteer alles

INSERT INTO `phpbb3_users` (`user_id`, `user_type`, `group_id`, `user_permissions`, `user_perm_from`, `user_ip`, `user_regdate`, `username`, `username_clean`, `user_password`, `user_passchg`, `user_pass_convert`, `user_email`, `user_email_hash`, `user_birthday`, `user_lastvisit`, `user_lastmark`, `user_lastpost_time`, `user_lastpage`, `user_last_confirm_key`, `user_last_search`, `user_warnings`, `user_last_warning`, `user_login_attempts`, `user_inactive_reason`, `user_inactive_time`, `user_posts`, `user_lang`, `user_timezone`, `user_dst`, `user_dateformat`, `user_style`, `user_rank`, `user_colour`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_message_rules`, `user_full_folder`, `user_emailtime`, `user_topic_show_days`, `user_topic_sortby_type`, `user_topic_sortby_dir`, `user_post_show_days`, `user_post_sortby_type`, `user_post_sortby_dir`, `user_notify`, `user_notify_pm`, `user_notify_type`, `user_allow_pm`, `user_allow_viewonline`, `user_allow_viewemail`, `user_allow_massemail`, `user_options`, `user_avatar`, `user_avatar_type`, `user_avatar_width`, `user_avatar_height`, `user_sig`, `user_sig_bbcode_uid`, `user_sig_bbcode_bitfield`, `user_from`, `user_icq`, `user_aim`, `user_yim`, `user_msnm`, `user_jabber`, `user_website`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`, `user_points`) VALUES 
(1, 2, 1, 0x30303030303030303030336b30303036626b0a0a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a0a6931636a796f3030303030300a6931636a796f3030303030300a0a0a0a0a0a0a0a3030303030303030303030300a0a0a0a0a0a0a0a0a0a0a0a0a0a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a0a0a0a0a0a0a6931636a796f3030303030300a6931636a796f3030303030300a0a6931636a796f3030303030300a6931636a796f3030303030300a0a6931636a796f3030303030300a6931636a796f3030303030300a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a0a0a0a0a0a0a0a6931636a796f3030303030300a6931636a796f3030303030300a0a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a6931636a796f3030303030300a0a0a6931636a796f303030303030, 0, '', 1177796848, 0x416e6f6e796d6f7573, 0x616e6f6e796d6f7573, '', 0, 0, '', 0, '', 0, 0, 0, '', 0x4f574e5a564b53574b45, 1188276614, 0, 0, 0, 0, 0, 0, 0x6e6c, 0.00, 0, 0x64204d205920483a69, 1, 0, '', 0, 0, 0, 0, -3, 0, 0, 0x74, 0x64, 0, 0x74, 0x61, 0, 1, 0, 1, 1, 1, 0, 895, '', 0, 0, 0, 0x4469742062657269636874206973206765706c616174737420646f6f722065656e20476173742c20646965206e6f67206e696574206c69642069732076616e205265616c697479582e6e6c0a0a6b6c696b205b75726c3d687474703a2f2f7265616c697479782e646f746261732e6e65742f7563702e7068703f6d6f64653d72656769737465725d5b623a63643862655d686965725b5b2f623a63643862655d2f75726c5d206f6d20746520726567697374726572656e21, 0x6364386265, 0x51413d3d, '', '', '', '', '', '', '', '', '', '', '', 0),

Mijn prefix staat op phpbb3_ die moet je wel veranderen naar jou prefix, waarschijnlijk gewoon phpbb_
dus dan verander je INSERT INTO `phpbb3_users` in INSERT INTO `phpbb_users`

[joeri]

Hallo

Ik bedank u van harte.

Als u zelf met en probleem zit zal ik deze proberen op te lossen

Mvg joeri

[joeri]

Hallo

Kan het zijn dat er een foutje in deze code zit.
mysql retouneerde een fout op line 2 ' '

mvg joeri

[nickdhnick]

heb je de prefix in de code aangepast?

Of heb je misschien een modificatie toegepast bij je forum waardoor er iets veranderd is bij de users?


wanneer de eerste klopt en de laatste niet kan je miscchien een testforum installeren, en via de datbase de gegevens van de anonymous over te zetten naar je echte forum
kijken of het dan werkt

[joeri]

Hallo

Ik heb de preifx veranderd kan proberen met een testforum te installeren en zo die user terug te halen vind het wel raar dat dit niet werkt.

Is toch enkel knippen en plakken met de prefix te veranderen.

Anders heb ik enkel users verwijderd maar per ongeluk ook de anonymous dusja denk da er niks aan de table scheelt hoor.

mvg joeri

[joeri]

Hallo

Ik heb nog niet zoveel geregsitreerde gebruikers in mijn users tabel als ik deze nu zou kopieren, mijn database zou herstellen en deze terug zou plaatsen zou dit werken ?

Ik heb wel een mod geinstalleerd. blijft deze dan ook bruikbaar of moet ik deze opniuew installeren

mvg joeri

[nickdhnick]

je bedoeld:

-maak back-up van phpbb_users
-Verwijder de tabel phpbb_users
-voer het volgende uit in je sql:

Code: Selecteer alles

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) unsigned NOT NULL auto_increment,
  `user_type` tinyint(2) NOT NULL default '0',
  `group_id` mediumint(8) unsigned NOT NULL default '3',
  `user_permissions` mediumtext collate utf8_bin NOT NULL,
  `user_perm_from` mediumint(8) unsigned NOT NULL default '0',
  `user_ip` varchar(40) collate utf8_bin NOT NULL default '',
  `user_regdate` int(11) unsigned NOT NULL default '0',
  `username` varchar(255) collate utf8_bin NOT NULL default '',
  `username_clean` varchar(255) collate utf8_bin NOT NULL default '',
  `user_password` varchar(40) collate utf8_bin NOT NULL default '',
  `user_passchg` int(11) unsigned NOT NULL default '0',
  `user_pass_convert` tinyint(1) unsigned NOT NULL default '0',
  `user_email` varchar(100) collate utf8_bin NOT NULL default '',
  `user_email_hash` bigint(20) NOT NULL default '0',
  `user_birthday` varchar(10) collate utf8_bin NOT NULL default '',
  `user_lastvisit` int(11) unsigned NOT NULL default '0',
  `user_lastmark` int(11) unsigned NOT NULL default '0',
  `user_lastpost_time` int(11) unsigned NOT NULL default '0',
  `user_lastpage` varchar(200) collate utf8_bin NOT NULL default '',
  `user_last_confirm_key` varchar(10) collate utf8_bin NOT NULL default '',
  `user_last_search` int(11) unsigned NOT NULL default '0',
  `user_warnings` tinyint(4) NOT NULL default '0',
  `user_last_warning` int(11) unsigned NOT NULL default '0',
  `user_login_attempts` tinyint(4) NOT NULL default '0',
  `user_inactive_reason` tinyint(2) NOT NULL default '0',
  `user_inactive_time` int(11) unsigned NOT NULL default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_lang` varchar(30) collate utf8_bin NOT NULL default '',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_dst` tinyint(1) unsigned NOT NULL default '0',
  `user_dateformat` varchar(30) collate utf8_bin NOT NULL default 'd M Y H:i',
  `user_style` smallint(4) unsigned NOT NULL default '0',
  `user_rank` mediumint(8) unsigned NOT NULL default '0',
  `user_colour` varchar(6) collate utf8_bin NOT NULL default '',
  `user_new_privmsg` tinyint(4) NOT NULL default '0',
  `user_unread_privmsg` tinyint(4) NOT NULL default '0',
  `user_last_privmsg` int(11) unsigned NOT NULL default '0',
  `user_message_rules` tinyint(1) unsigned NOT NULL default '0',
  `user_full_folder` int(11) NOT NULL default '-3',
  `user_emailtime` int(11) unsigned NOT NULL default '0',
  `user_topic_show_days` smallint(4) unsigned NOT NULL default '0',
  `user_topic_sortby_type` varchar(1) collate utf8_bin NOT NULL default 't',
  `user_topic_sortby_dir` varchar(1) collate utf8_bin NOT NULL default 'd',
  `user_post_show_days` smallint(4) unsigned NOT NULL default '0',
  `user_post_sortby_type` varchar(1) collate utf8_bin NOT NULL default 't',
  `user_post_sortby_dir` varchar(1) collate utf8_bin NOT NULL default 'a',
  `user_notify` tinyint(1) unsigned NOT NULL default '0',
  `user_notify_pm` tinyint(1) unsigned NOT NULL default '1',
  `user_notify_type` tinyint(4) NOT NULL default '0',
  `user_allow_pm` tinyint(1) unsigned NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) unsigned NOT NULL default '1',
  `user_allow_viewemail` tinyint(1) unsigned NOT NULL default '1',
  `user_allow_massemail` tinyint(1) unsigned NOT NULL default '1',
  `user_options` int(11) unsigned NOT NULL default '895',
  `user_avatar` varchar(255) collate utf8_bin NOT NULL default '',
  `user_avatar_type` tinyint(2) NOT NULL default '0',
  `user_avatar_width` smallint(4) unsigned NOT NULL default '0',
  `user_avatar_height` smallint(4) unsigned NOT NULL default '0',
  `user_sig` mediumtext collate utf8_bin NOT NULL,
  `user_sig_bbcode_uid` varchar(5) collate utf8_bin NOT NULL default '',
  `user_sig_bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `user_from` varchar(100) collate utf8_bin NOT NULL default '',
  `user_icq` varchar(15) collate utf8_bin NOT NULL default '',
  `user_aim` varchar(255) collate utf8_bin NOT NULL default '',
  `user_yim` varchar(255) collate utf8_bin NOT NULL default '',
  `user_msnm` varchar(255) collate utf8_bin NOT NULL default '',
  `user_jabber` varchar(255) collate utf8_bin NOT NULL default '',
  `user_website` varchar(200) collate utf8_bin NOT NULL default '',
  `user_occ` text collate utf8_bin NOT NULL,
  `user_interests` text collate utf8_bin NOT NULL,
  `user_actkey` varchar(32) collate utf8_bin NOT NULL default '',
  `user_newpasswd` varchar(32) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`user_id`),
  UNIQUE KEY `username_clean` (`username_clean`),
  KEY `user_birthday` (`user_birthday`),
  KEY `user_email_hash` (`user_email_hash`),
  KEY `user_type` (`user_type`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=53 ;

INSERT INTO `phpbb_users` (`user_id`, `user_type`, `group_id`, `user_permissions`, `user_perm_from`, `user_ip`, `user_regdate`, `username`, `username_clean`, `user_password`, `user_passchg`, `user_pass_convert`, `user_email`, `user_email_hash`, `user_birthday`, `user_lastvisit`, `user_lastmark`, `user_lastpost_time`, `user_lastpage`, `user_last_confirm_key`, `user_last_search`, `user_warnings`, `user_last_warning`, `user_login_attempts`, `user_inactive_reason`, `user_inactive_time`, `user_posts`, `user_lang`, `user_timezone`, `user_dst`, `user_dateformat`, `user_style`, `user_rank`, `user_colour`, `user_new_privmsg`, `user_unread_privmsg`, `user_last_privmsg`, `user_message_rules`, `user_full_folder`, `user_emailtime`, `user_topic_show_days`, `user_topic_sortby_type`, `user_topic_sortby_dir`, `user_post_show_days`, `user_post_sortby_type`, `user_post_sortby_dir`, `user_notify`, `user_notify_pm`, `user_notify_type`, `user_allow_pm`, `user_allow_viewonline`, `user_allow_viewemail`, `user_allow_massemail`, `user_options`, `user_avatar`, `user_avatar_type`, `user_avatar_width`, `user_avatar_height`, `user_sig`, `user_sig_bbcode_uid`, `user_sig_bbcode_bitfield`, `user_from`, `user_icq`, `user_aim`, `user_yim`, `user_msnm`, `user_jabber`, `user_website`, `user_occ`, `user_interests`, `user_actkey`, `user_newpasswd`) VALUES 
(1, 2, 1, '', 0, '', 1188577393, 0x416e6f6e796d6f7573, 0x616e6f6e796d6f7573, '', 0, 0, '', 0, '', 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0x656e, 0.00, 0, 0x64204d205920483a69, 1, 0, '', 0, 0, 0, 0, -3, 0, 0, 0x74, 0x64, 0, 0x74, 0x61, 0, 1, 0, 1, 1, 1, 0, 895, '', 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', ''),

-Voer nu de sql van je modificatie uit als die iets veranderd in de tabel van phpbb_users Anders is het niet nodig.

-Voer nu de back-up van de phpbb_users tabel in. Het gedeelte "CREATE TABLE" mag je overslaan. het enige wat je hoeft in te voeren is vanaf "INSERT INTO `phpbb_users`"

Maak eerst wel een back-up van je gehele database!!!

btw, je mod blijft gewoon werken, behalve als het iets veranderd in de phpbb_users tabel. maar dan is het simpelweg opnieuw de sql van de mod uitvoeren en dan werkt t weer