Forum 3.1.4 w trybie DEV
Otwarcie strony dodawania użytkownika 9 zapytań
Dodanie 49 zapytań, jednak sporo takich które pewnie będą używane w celu sprawdzenia czy istnieje użytkownik a INSERT idą takie:
INSERT INTO ipb_members (`name`,`members_display_name`,`email`,`member_group_id`,`joined`,`ip_address`,`time_offset`,`coppa_user`,`allow_admin_mails`,`members_l_username`,`members_created_remote`,`member_login_key`,`member_login_key_expire`,`view_sigs`,`view_img`,`view_avs`,`bday_day`,`bday_month`,`bday_year`,`restrict_post`,`msg_count_total`,`msg_count_new`,`msg_show_notification`,`auto_track`,`last_visit`,`last_activity`,`language`,`members_editor_choice`,`members_pass_salt`,`members_pass_hash`,`members_l_display_name`,`fb_uid`,`fb_emailhash`,`members_seo_name`,`members_bitoptions`) VALUES('test','test','
[email protected]',3,1315356497,'127.0.0.1',0,0,1,'test',0,'a87c30f4aab0bb78d0095c58bc52e64a',1315961297,1,1,1,0,0,0,0,0,0,1,0,1315356497,1315356497,1,'std','M7|}!','7a1811f4c2ecf89e77ab3ad7558eab43','test',0,'','test',0)
INSERT INTO ipb_profile_portal (`pp_member_id`,`pp_setting_count_friends`,`pp_setting_count_comments`,`pp_customization`,`pp_last_visitors`,`pp_about_me`,`notes`,`signature`,`fb_photo`,`fb_photo_thumb`,`pconversation_filters`,`avatar_location`,`avatar_type`,`avatar_size`) VALUES(4,1,1,'a:0:{}','','','','','','','','','','')
INSERT INTO ipb_pfields_content (`field_1`,`field_2`,`field_3`,`field_4`,`field_8`,`field_9`,`field_10`,`field_5`,`field_6`,`field_7`,`field_11`,`member_id`) VALUES('','','','','','','','u','','','',4)
Pozostałe inserty idą do cache oraz jeden do logów, oto i zapytanie z logów:
INSERT INTO ipb_admin_logs (`appcomponent`,`module`,`section`,`do`,`member_id`,`ctime`,`note`,`ip_address`) VALUES('members','members','members','doadd',1,1315356497,'Created new member account for \'test\'','127.0.0.1')
Pytanie tylko po co ci one?