عضوية ( زائر ) في منتدى الـ phpBB

[وليــــــــــد]

?????? ????? ????? ????

?????? ???? ??????? ?? ??? phpBB ??? ???? ???? ??? ??????? ? ??????? ???? ???????

???? ?????? ??? ????? ?? ???????? ?????? ???? ????? ?????? ?? ???? ????? ?????? phpBBarabia
?? ?????? ????? ??? ???? ?? ???? ???? ??????? ??? ??????? ...

?????? ???? ?????? ??????? (???? ??? ??? ????? ?????)

??? ????? ?????? ??? ???????? ??? ?????? ???? ????? ...

?? ???? ??? ???? ??? ???? ??? ?????? ?? ???

????? ?? ??????? ??????? ? ????? ??? ???? ?????? ? ?? ??? ????

?????? ???? ?? ???? ??? ???? ( ??? ??????? )

????? ???? ??? ????? ???? ??? ?????? ???? ?????? ?? ??? phpBB ?????? ???? ??? 2

??? ???? ??? ???? ?? ??? ? ... ??? ( ?????? )

????? ??? ???? ???? ??? ??? ???? ????? ???? ???? ??? ???? ???????

?????? ?? ??? ?????? ?????? ?????? ??????? ????? ??? ???? ?? ????? ???????? ... ?? ????

phpbb_users ??????

???? ??? ID ?????? ?? (-1) ??? (-2)

????? ??? ID ?????? ?? (2) ??? (1)

*******************************************

??? ???? ?????? ??? ???? ???? ??? ??????? ????? ?? ???

???? ????? ???????? ????? ?????? ????? ?????? ????? ( ?????? ) ??? ?????

??? ?? ???? MySQL ??? ??? ?????? ???? ????? ...

??? ??? ??? ?????? ??? ???? ?? ??? ??? ???? ??????? ??????? ?? ?? ????? ???? ????

????????

[Xx JustMe xX]

?????? ???? ??? ?? ?????? ???? ??? ??????

??? ???? ?????? ???? ??? ?? ????? ??????? ??? ???? ????? ?? ??? ???? ???? ???? ???

????? ????? ????? ????? ?? ??????? ??? ?????

??? ?? ??? ?????? ???? ???? ?????? ??? ??? ????? ????? ???? ?? ???? ??????? ?? ??? ????

???? ???? ??? ????? ??? ?? ???? phpBBHacks ?????? ??? ?????? ????? ??? ???? ??? ??????? 1 ?? ???? ????????? 8O

???? ??
http://www.phpbbhacks.com/forums/profil ... rofile&u=1

mode=viewprofile&u=1

??? ?? ????

???? ?? ????? ?????

?????? ??

[وليــــــــــد]

???? ??? ???? ?????? ...

?????? ????? ????????

?? ??? ?? ?????? ????? ???? ?? ???? ????? ??? ???? phpbb_users

????? ?? ????? ??? ????? ???????

??? ?????? ???? ????? ? ???????

????? ????????

????? ??

[ArabFriends]

???? ??? ??? ????? ?????

????? ??? ??? ??? ??????? ?????? ?
???? ??? ??? ???? ???? ?? ??????? ??? ???? ??? ??????
??? ???? ???? ???? ?? phpbbarabia
???? ?????? ?? ??? ???? ???? ????? :
http://www.phpbbarabia.com/board/profil ... e=register

???? ??? ???? ?? ??? ????? ?

??? ???? ??? ???? ????? ????? ??????? ??? ????? ?????? ??? ????? ??? ?? ???? ??? ???? phpbb_users ??? ?? ?????? ?? ????
???? ???? phpbb_users
?? ???? ??? ????? ?? phpmyadmin

كود: تحديد الكل

# --------------------------------------------------------
#
# Table structure for table 'phpbb_users'
#
CREATE TABLE phpbb_users (
   user_id mediumint(8) NOT NULL,
   user_active tinyint(1) DEFAULT '1',
   username varchar(25) NOT NULL,
   user_password varchar(32) NOT NULL,
   user_session_time int(11) DEFAULT '0' NOT NULL,
   user_session_page smallint(5) DEFAULT '0' NOT NULL,
   user_lastvisit int(11) DEFAULT '0' NOT NULL,
   user_regdate int(11) DEFAULT '0' NOT NULL,
   user_level tinyint(4) DEFAULT '0',
   user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
   user_timezone decimal(5,2) DEFAULT '0' NOT NULL,
   user_style tinyint(4),
   user_lang varchar(255),
   user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
   user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
   user_last_privmsg int(11) DEFAULT '0' NOT NULL,
   user_emailtime int(11),
   user_viewemail tinyint(1),
   user_attachsig tinyint(1),
   user_allowhtml tinyint(1) DEFAULT '1',
   user_allowbbcode tinyint(1) DEFAULT '1',
   user_allowsmile tinyint(1) DEFAULT '1',
   user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
   user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
   user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
   user_notify tinyint(1) DEFAULT '1' NOT NULL,
   user_notify_pm tinyint(1) DEFAULT '0' NOT NULL,
   user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
   user_rank int(11) DEFAULT '0',
   user_avatar varchar(100),
   user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
   user_email varchar(255),
   user_icq varchar(15),
   user_website varchar(100),
   user_from varchar(100),
   user_sig text,
   user_sig_bbcode_uid char(10),
   user_aim varchar(255),
   user_yim varchar(255),
   user_msnm varchar(255),
   user_occ varchar(100),
   user_interests varchar(255),
   user_actkey varchar(32),
   user_newpasswd varchar(32),
   PRIMARY KEY (user_id),
   KEY user_session_time (user_session_time)
);

# -- Users
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 1, 1, 0, 1, 1, NULL, '', '', 0, '', '', '', 0, 0);

# -- username: admin    password: admin (change this or remove it once everything is working!)
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);

????? ???? ?????
????? ??? ?????? ???? Anonymous ????? -1
?????? admin ????? ?? admin

??? ??? ??? ??????? ?????? ??? ???? ??? ?????? ?? ????? ???????? ??? ??????? ?????? ?
???? ??? ??? ??? ???
?????? ?? ???? ????? ???????? ?????? ??????? ?? ????

[Xx JustMe xX]

ArabFriends, ???? ???? ?

???? ?? ??? ???? ???? ?? ???? ???????

?? ????? .. ???? ?????? ?????? ??? ????? ??? ????? ???? ?? ????? ????? ?? ???? SQL ?? ???phpMyAdmin ?? ????? ?????? ??????? ??? ??

???? ?????? ???? ??????? ???? ?????? ????? ??????

?????? ??

[وليــــــــــد]

?????? ????? ????? ????

????? ??? ArabFriends ??? ???????? ?????? ... ??? ???? ?????? ????????

????? ??? ???? ?????? ... ????? ???? ??

??? ??? ???? phpbb_users

??? ??? ???? ????? ???? ID ????? ( ???? ) ?? ( -1 )

???? ID ????? ??????? ?? ( 2 )

??? ??? ?????? ??? ?? ???? ??? ID ?????? ??? ??? ( 1 )

?????? ( -1 ) ?? ????? ( 1 ) ... ??? ??? ????? ???? ??????? ??? ???? ????? ?? ????

??? ?? ???? ???????????

????? ?? ?????? ??? ????? ?????? ??? ??? ??? ???? ??????? ?????? ????????



- ????? ??? ??????????????

[ArabFriends]

????? ?? ?????? ??? ????? ??????

?? ??? ??????
??????? ???? ????????? ?? ??? ??????? ? ??? ????? ??????? ??????? ?? ??????? ?????? ?????
?????? ? ????? ?? ????? 2 ???? ?? ????? ????

[Xx JustMe xX]

???? ??? ?? ??? ????????

http://www.phpbbarabia.com/board/viewto ... 5898#75898

[ArabFriends]

???? ??? ???? ??????,
?? ???? ???? ?? ????????

???? ?? ??? ???? ???? ?? ???? ???????

?? ????? .. ???? ?????? ?????? ??? ????? ??? ????? ???? ?? ????? ????? ?? ???? SQL ?? ???phpMyAdmin ?? ????? ?????? ??????? ??? ??

?? ??????? ?? ???? ???????? ??? ?? ? ??? ?? ????? ???? ???? ???? ????? ?? ???? ?? ????? ( ??? ?? ???? ????? ??? ??????? )
??? ??? ???? ??? ????? ?????? ??? ?????? ??? ??? ???? ?? 1 ?? ???? -1 ?? -2 ??? ??????? 1
??? ?? ????? ??? ?? ????? ???? ? ??? ????????? ?????? ???? ??????? ?? ???? ?????? ??? ??? ????? ????? ???? ???? ??? ????? ??????? ???? ???????? ???? ??????? ???????
? ??? ?? ???? ?? ??????? ? ?? ???? ???? ???????? ? ??? ?????? ??? ??????? ????? ?? ???? ?? ?? ???? ????? ??? ???? ????

??????? ?????? ??????? ? ??? ????? ?? ?? ????? ???? ? ??? ????? ???????? ??? ?? ???? ????? ??? ??? ??? ???????

??? ?????? ?? ????? ??? ????? ????? ????

[Xx JustMe xX]

??? ?????? ?? ???? ????? ???? ???? ???? ????? ??? 18 ?? 3 ?3 ??? 18

???? ?????? ????? ????? ???????? ???????? ???? ??????? ?

???? ???? ????? ?????? ??? ????? ????? ???????

?????? ??? ???? ???? ??????? ?? ??????? ???????? ?????? ?????? ???????

??? ????? ????

[ArabFriends]

??? ?????? ?? ???? ????? ???? ???? ???? ????? ??? 18 ?? 3 ?3 ??? 18

???? ?????? ????? ????? ???????? ???????? ???? ??????? ?

??? ?????? ????? ????? ???????
??????? ????? 18 ????? ???? ????? 3 ?????? ????? 3

???? ???? ????? ?????? ??? ????? ????? ???????

?????? ?? ??? ??

[Xx JustMe xX]

?????? ?? ??? ??

????? ???? ????

?????? ??? ?????? ??????? ????????

[ArabFriends]

????? ??? ?????? ??????? ??? ??? ????? ??????? ???
?? ??? unix timestamp

[Xx JustMe xX]

????? ??? ?????? ??????? ??? ??? ????? ??????? ???
?? ??? unix timestamp

????? ?? ???? ???? ???

??? ?????? ??? ??? ???? ?? phpBB Group ???? ????? ????? ????? ??????? ?????? ???????

???? ?? ???????

كود: تحديد الكل

UPDATE `phpbb_users` SET `user_regdate` = '1116374400'

???? ?????? ????? ??????? ????? ??????? ???? ???? ?? ?????? ???? ??? ??? ????
????? ????? 1116374400 ????? ??????? ???? ??????? 18th May 2005

??? ?????? ??? ????? ????? ??? ??????? ???? ??????? ?? ????

????? ??????? ???????

كود: تحديد الكل

UPDATE `phpbb_users` SET `user_regdate` = '1116374400' 
WHERE `user_id` > 2 LIMIT 2502;

??? ?????? ????? ??????? ??????? ???????? ??? ????? ??? 2 ?? ????? ??? 3 ???? 2502 ??? ???? ???????? ??????? ?? ??????? ??? ?????? ???? ???????

???????

كود: تحديد الكل

UPDATE `phpbb_users` SET `user_regdate` = '1116374400' 
WHERE `user_id` > 2 
AND `user_id` < 2502; 

???? ??? ????? ??????? ??????? ?? ????? ??? 3 ???? ????? ??? 2501

???? ??? ????? ????? ????? ??????? ???? ??????? ???????? ??? ???? ?????

?????????????

=============================

???? ??? ?????? ??? ??? ??????? ??? ??????? ????? ????????

??? ???? ?????? ???? ??????? 3 ?18

??????? ??????? ?? ???? phpbb_posts ???????? ???? poster_id

????? ???? phpbb_topics ????????? ???? topic_poster

كود: تحديد الكل

UPDATE `phpbb_posts` SET `poster_id` = '18' 
WHERE `poster_id` = 3

?? ???? ??? ????? ??

??? ???? ??? ??? ?? ?????? ????? ???? ????

=======================

???? ?? ???? ???? ??? ???

?????? ??

[ArabFriends]

????? ?? ???? ???? ???

?????? ???

????? ????? 1116374400 ????? ??????? ???? ??????? 18th May 2005

???? ??? ????? ????? ????? ??????? ???? ??????? ???????? ??? ???? ?????

???? ?? ??? ??????? ??????? ? ???? ??? :
http://www.wmasterz.com/unixtime.php

???? ??? ?????? ??? ??? ??????? ??? ??????? ????? ????????

??? ???? ?????? ???? ??????? 3 ?18

??????? ??????? ?? ???? phpbb_posts ???????? ???? poster_id

????? ???? phpbb_topics ????????? ???? topic_poster

UPDATE `phpbb_posts` SET `poster_id` = '18'
WHERE `poster_id` = 3

??? ????? ????? ?????? ????? 18 ??? ????????? ?????? 3
?? ??? ???? ?????

??? ?? ??????

UPDATE `phpbb_posts` SET `poster_id` = 3
WHERE `poster_id` = 18

??? ???? ????? ????? ??? ??? ????? ??????? ????? ? ????? ??? ????? ?? ?? ????? ???? ????? ????? ?????? ????? ? ????? ?? ????? ???????? ???? ???? ???? ??? ?? ???????
?? ???? ???????? ???? ????? ??????? ? ??? ???? ? ??? ???????? ??? ??????? ???????? ????