اذا كان الهاك يحتوي SQL،فكيف تضيفه ؟

[samphp]

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

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

:(
#
#-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `phpbb_profile_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;

#
#-----[ SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `phpbb_profile_config` VALUES ('user_email', '1');
INSERT INTO `phpbb_profile_config` VALUES ('user_icq', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_website', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_from', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_sig', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_aim', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_yim', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_msnm', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_occ', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_interests', '0');

#
#-----[ ???? ]------------------------------------------
#
language/lang_english/lang_admin.php

....

[dr.3]

?????

??? ??? ??????? ????? ??????? ?? ????? ???????? ???????? ???? ???? ?? ??? ????? ??????? ??? ??? SQL ???? ??? ???? ?? ???? ??? ????????? ??? ????? ???????? ????? ??????? ..


1- ???? phpMyAdmin ????? ??? ??? ????? ???????
2- ??????? ???? ??? SQL ???? ???? ????? ?????? ????
3- ?? ??????? ???? ?? ????? ??? ??? ??? SQL ???? ?????? ??????? ..

CREATE TABLE `phpbb_profile_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
INSERT INTO `phpbb_profile_config` VALUES ('user_email', '1');
INSERT INTO `phpbb_profile_config` VALUES ('user_icq', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_website', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_from', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_sig', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_aim', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_yim', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_msnm', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_occ', '0');
INSERT INTO `phpbb_profile_config` VALUES ('user_interests', '0');

• ?????? ???? .. ??? ???? ????? ?????? ???????? ??????? ?? ????? ??? SQL ????? ??? ?? ??? ?????? ?? phpbb ??? ???? ?? ?????? ?????? ??????? ??? ????? ???? ???? ?????? ???? ????? ???? ??? ???? ?????? ??????? ..
  
  phpbb_auth
  phpbb_users
  .. ???
  
  ??? ????? ?????? ?????? ???????? ??????? ???? ??? ???? ??? ??? ???? ???? ????? ????? ?????? ?? ????? ??? SQL ????? ??? ????????? ??? ?? ????? ?? ????? ???????

[samphp]

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

???? ???? ???

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

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

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

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

[dr.3]

?????


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

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

??? ??? ???

[babystar]

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





??? ??? ???

[dr.3]

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





??? ??? ???

??? babystar


????? ???? ?? ??? ????? ??? ??? ??? ?????? ???? ?? ????? phpMyAdmin ??? ??? ???? ????? ???? ?????? ??? ??? ???? ????? ??? ??? ??? ?????? ??? ???? ?? ??? ..

??? ????? ??? ??? ??????? ???? ????? ????? SQL ???? ????? ..

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

CREATE TABLE phpbb_board_message ( 
msg_id mediumint( NOT NULL auto_increment, 
title varchar(25) NOT NULL default '(empty)', 
message text NOT NULL, 
showpage smallint(5) NOT NULL default '0', 
auth tinyint(2) NOT NULL default '5', 
width smallint(3) NOT NULL default '75', 
starttime int(11) NOT NULL default '0', 
endtime int(11) NOT NULL default '0', 
startdate int(11) NOT NULL default '0', 
enddate int(11) NOT NULL default '0', 
users_timezone tinyint(1) NOT NULL default '0', 
bbcode_uid varchar(10) NOT NULL default '', 
days varchar(7) NOT NULL default '0000000', 
images varchar(100) default NULL, 
ordr smallint(3) NOT NULL default '0', 
PRIMARY KEY (msg_id) ); 

INSERT INTO phpbb_board_message (msg_id, title, message, showpage, auth, width, starttime, endtime, startdate, enddate, users_timezone, bbcode_uid, days, images, ordr) VALUES (1, 'All Pages', 'This message will be shown on all pages. It can be view by all visitors. The width of the table = 80%. It als display a gif file. Order 10', 9999, 0, 80, 946681200, 946681200, 988581600, 1293750000, 0, '', '1111111', '/images/default.gif', 10), 
(3, 'Index Only', 'The message will be showed only on the index. Only for registered people. On all days. Order 20', 0, 1, 50, 946681200, 946681200, 1009839600, 1293750000, 0, '', '1111111', '', 20);

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

http://www.phpbbsupport.co.uk/db_generator.php

?? ????? ?? SQL ???? ?? ?????? ?? ?????? ????? ??? Submit ???? ???? ??????? ???? ?? ?????? ??????? ????? ??? Download ???? ??? ?????? ??? ????? ? ?????? ????? ?????? ??????? ????? ??? ????? ?????? ( ????? ????? / db_update.php ) ??? ??? ??? ???? ?? ????? ??????? ??? ??????? ?????? ???? ?????

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

???? ????? ??????? ????? ??? db_update.php ??? ???? ?????? ??????? ????? ?? ???? ??? ??? ????? ..

????? ?????? / db_update.php

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

???? ????: ?? ???? ?? ?????? ?????? ??????? ??? ?? ???

[مهند قمرة]

???? ???? ??? ??? dr.3, ??? ???????? ???????:wink:

[dr.3]

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

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

[babystar]

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

[dr.3]

?????? ??? ????? babystar

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

[babystar]

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


???? ?????

[babystar]

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

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

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

board_msg_xl [??????] ????
??? ???? ????? ?????? ????? ????? ???? ??????? ?? ?? ???? ?????? ????????? ???? ?????? ?????? ????? ????? ???????? ???? ??? ??? ????? ?????

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

[dr.3]

????? babystar


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

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

[babystar]

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

[المساعيد]

?? ??? ???? ??????? ?????? ??? ??? ???
ALTER TABLE auth_access ADD auth_globalannounce TINYINT (1) AFTER auth_announce

ALTER TABLE forums ADD auth_globalannounce TINYINT (2) DEFAULT '3' NOT NULL AFTER auth_announce

???? ???? ??? ????? ???? ????? ?? ?? ??? ?? dr.3 ???? ?? ????? ?????:
MySQL ???:

#1146 - Table '19676.forums' doesn't exist

????? ??????:
MySQL ???:

#1146 - Table '19676.auth_access' doesn't exist