Administrators will still be able to see the board\r\nUse this as a master switch for your board. You can set options for individual user groups in the User Permissions area.','yesno','1');
INSERT INTO setting VALUES('2','1','Reason for turning board off','bbclosedreason','شكرا لزيارتكم\r\nنحن هنا\r\nhttp://www.nabazat.com/vb','The text that is presented when the BB is closed.
\r\nNote: you, as an administrator, will be able to see the forums as usual, even when you have turned them off to the public.','textarea','2');
INSERT INTO setting VALUES('3','2','URL','bburl','http://members.lycos.co.uk/nabazat/vb','URL (with no final \"/\") of the BB.','','3');
INSERT INTO setting VALUES('4','2','Board Title','bbtitle','نبضات دافئة','Title of board. Appears in the title of every page','','1');
INSERT INTO setting VALUES('5','2','Homepage Name','hometitle','موقع : شخص اخر','Name of your homepage. Appears at the bottom of every page.','','2');
INSERT INTO setting VALUES('6','2','URL of homepage','homeurl','www.nabazat.host.sk','URL of your home page. Appears at the bottom of every page.','','4');
INSERT INTO setting VALUES('7','2','Copyright Text','copyrighttext','','Copyright text to insert the footer of the page.','','5');
INSERT INTO setting VALUES('8','2','URL of Privacy Statement','privacyurl','','Enter the URL of your privacy statement, if one exists.','','6');
INSERT INTO setting VALUES('9','3','Contact Us Link','contactuslink','mailto:memos3000@hotmail.com','Link for contacting the site. Can just be mailto:webmaster@whereever.com or your own form. Appears at the bottom of every page.','','1');
INSERT INTO setting VALUES('10','3','Webmaster\'s email','webmasteremail','memos3000@hotmail.com','Email address of the webmaster.','','2');
INSERT INTO setting VALUES('11','3','Company Name','companyname','','The name of your company. Required for COPPA.','','6');
INSERT INTO setting VALUES('12','3','Address','address','','Address of your company. This is required for COPPA forms to be posted to.','','5');
INSERT INTO setting VALUES('13','3','Fax Number','faxnumber','','Enter the fax number for your company here. COPPA forms will be faxed to it.\r\n
\r\nYou may wish to check out http://www.efax.com/ ','','4');
INSERT INTO setting VALUES('14','4','Allow vB IMG code in signatures?','allowbbimagecode','1','','yesno','1');
INSERT INTO setting VALUES('15','4','Allow vB code in signatures?','allowbbcode','1','','yesno','2');
INSERT INTO setting VALUES('16','4','Allow smilies in signatures?','allowsmilies','1','','yesno','3');
INSERT INTO setting VALUES('17','4','Allow HTML in signatures?','allowhtml','1','','yesno','4');
INSERT INTO setting VALUES('18','4','Maximum images per post/signature','maximages','10','Maximum number of images to allow in posts / signatures. Set this to 0 to have no effect.','','5');
INSERT INTO setting VALUES('19','4','Clickable Smilies per Row','smcolumns','3','When a user has enabled the clickable vbcode/smilies how many smilies do you want to show per row?','','6');
INSERT INTO setting VALUES('20','4','Clickable Smilies Total','smtotal','15','When a user has enabled the clickable vbcode/smilies how many smilies do you want to display on the screen before the user is prompted to click for more.','','7');
INSERT INTO setting VALUES('21','4','Allow Dynamic URL for [img] tags?','allowdynimg','1','If this is set to \'no\', the [img] tag will not be displayed if the path to the image contains dynamic characters such as ? and &. This can prevent malicious use of the tag.','yesno','8');
INSERT INTO setting VALUES('22','4','Allow vBcode Buttons & Clickable Smilies?','allowvbcodebuttons','1','This global switch allows you to completely disable vBcode buttons and clickable smilies.','yesno','9');
INSERT INTO setting VALUES('23','5','Show Locked forums?','showlocks','0','Do you wish to have the new post indicators shown on the index page (on.gif and off.gif) be shown with locks to guests & other members who have no access to post?','yesno','6');
INSERT INTO setting VALUES('24','5','Depth of Forums','forumhomedepth','2','Depth to show forums on home page. Do not go too large on this value for performance reasons.','','7');
INSERT INTO setting VALUES('25','5','Hide private forum','hideprivateforums','1','Select \'yes\' here to hide private forums from users who are not allowed to access them. Users who do have permission to access them will have to log in before they can see these forums too. This option applies to the forum home page, and the Jump To... box.','yesno','5');
INSERT INTO setting VALUES('26','5','Display logged in users on home page','displayloggedin','1','Display logged in and active members on the home page? This option displays those users that have been active in the last {your cookie timeout} seconds on the home page.','yesno','4');
INSERT INTO setting VALUES('27','5','Show forum descriptions on the homepage.','showforumdescription','1','','yesno','0');
INSERT INTO setting VALUES('28','5','Show today\'s birthdays on the homepage?','showbirthdays','1','','yesno','1');
INSERT INTO setting VALUES('29','5','Highlight Admin','highlightadmin','1','Enabling this will show Admin names in Bold and Italics and Moderators\' names in Bold on the logged in users and Who\'s Online.','yesno','4');
INSERT INTO setting VALUES('30','6','Display email addresses','displayemails','0','Allow public viewing of email addresses.','yesno','1');
INSERT INTO setting VALUES('31','6','Use email form?','secureemail','1','If \"display email addresses\" is set to yes, then how should then email address be displayed? If this is set to yes, then an online form must be filled in to send a user an email, thus hiding the destination email address. If secureemail is set to no, then the user is just given the email address.','yesno','2');
INSERT INTO setting VALUES('32','6','Allow signatures','allowsignatures','1','Allow registered users to have signatures. Don\'t forget to update these templates: newtopic newreply editpost modifyprofile register','yesno','3');
INSERT INTO setting VALUES('33','6','Notify about new members','newuseremail','','Email address to receive email when a new user signs up. Leave blank for no email.','','4');
INSERT INTO setting VALUES('34','6','Require unique email addresses','requireuniqueemail','1','The default option is to require unique email addresses for each registered user. This means that no two users can have the same email address. You can disable this requirement by checking the \"Unique Email Not Required\" box.','yesno','5');
INSERT INTO setting VALUES('35','6','Illegal user names','illegalusernames','','Enter names in here that you do not want people to register. If any of the names here are included within the username, the user will told that there is an error. Separate names by spaces.','','6');
INSERT INTO setting VALUES('36','6','Allow new user registrations','allowregistration','1','If you would like to temporarily (or permanently) prevent anyone new from registering, you can do so. The REGISTER button will still be seen throughout the BB, but anyone attempting to register will be told that you are not accepting new registrations at this time.','yesno','7');
INSERT INTO setting VALUES('37','6','Allow multiple registrations per user','allowmultiregs','0','Normally, vBulletin will stop users signing up for multiple names by checking for a cookie on the user\'s machine. If one exists, then the user may not sign up for additional names. If you wish to allow your users to sign up for multiple names, then select yes for this option, and they will not be blocked from registering additional usernames.','yesno','8');
INSERT INTO setting VALUES('38','6','Verify Email address in registration','verifyemail','0','The password is emailed to the new member after they submit their registration to confirm their identity and email address. If account is not activated, they will remain in the \"users awaiting activation\" usergroup.','yesno','9');
INSERT INTO setting VALUES('39','6','Moderate New Members','moderatenewmembers','0','Allows you to validate new members before they are classified as registered members and are allowed to post.','yesno','10');
INSERT INTO setting VALUES('40','6','Use COPPA Registration system','usecoppa','1','Use the COPPA registration system. This complies with the COPPA laws and requires children under the age of 13 to get parental consent before they can post. For more info about this law, see here:http://www.ftc.gov/opa/1999/9910/childfinal.htm ','yesno','11');
INSERT INTO setting VALUES('41','6','Timeout for Cookie','cookietimeout','900','This is the time in seconds that a user must remain inactive before the unread posts are reset to read.','','12');
INSERT INTO setting VALUES('42','6','Allow Users To Change Styles','allowchangestyles','0','This allows users to set their preferred style set on registration or when editing their option. Setting this to \"no\" disables that option and will force them to use whatever style has been specified.','yesno','13');
INSERT INTO setting VALUES('43','6','Enable Access Masks?','enableaccess','0','Access masks are a simple way to manage forum permissions, however they add additional queries on most pages. If you don\'t use it, it is recommended that you disable it.','yesno','14');
INSERT INTO setting VALUES('44','6','Referrer','usereferrer','0','Enable the referrer system? If yes than a user that visits your forum through a link that contains \"referrerid=XXX\" will give referral credit to the owner of the referrerid when they register (where XXX is the userid of the referrer).','yesno','15');
INSERT INTO setting VALUES('45','6','Minimum Username Length','minuserlength','3','Enter the minimum length a user can register with.','','15');
INSERT INTO setting VALUES('46','6','Maximum Username Length','maxuserlength','15','Enter the maximum length a user can register with.','','16');
INSERT INTO setting VALUES('47','6','Allow Ignore Moderators','ignoremods','0','Allow users to add Moderators and admins to their ignore list?','yesno','17');
INSERT INTO setting VALUES('48','7','Enable members list','enablememberlist','1','Enable the member list addon? This allows users to view a list of registered users and (optionally) search through it. ','yesno','1');
INSERT INTO setting VALUES('49','7','Allow advanced searches','usememberlistadvsearch','1','Allow the use of the advanced search tool for the member list.','yesno','2');
INSERT INTO setting VALUES('50','7','Members per page','memberlistperpage','30','The number of records per page that will be shown by default in the members list.','','3');
INSERT INTO setting VALUES('51','7','Number of top posters to show','memberlisttopposters','10','On the \'Display top x posters\' , this option allows you to specify a value for x.','','4');
INSERT INTO setting VALUES('52','7','Restrict Listing','memberAllGood','1','Select Yes to hide members from appearing on the member\'s list who are Awaiting Confirmation, Awaiting Coppa, and in the Not Registered/Not Logged in usergroups.','yesno','5');
INSERT INTO setting VALUES('53','8','Order of posts within a thread','postorder','0','The standard (recommended) way to display threads is chronologically from original topic to the latest reply. You can reverse this, if you prefer, to have threads displayed in reverse, from latest post to oldest post.','Newest first
\r\nTo disable searching of all forums, delete the option from the searchintro template. ','yesno','1');
INSERT INTO setting VALUES('77','10','Number of posts per page','searchperpage','25','Number of successful search items to display per page.','','2');
INSERT INTO setting VALUES('78','10','Floodcheck - Minimum time between searches','searchfloodtime','0','The minimum time (in seconds) that must expire before the user can search again. Set this to 0 to disable it.','','3');
INSERT INTO setting VALUES('79','10','Minimum Word Length','minsearchlength','4','Enter the minimum word length that the search engine is to index. The smaller this number is, the larger your search index, and conversely your database is going to be.','','4');
INSERT INTO setting VALUES('80','10','Maximum Word Length','maxsearchlength','20','Enter the maximum word length that the search engine is to index. The larger this number is, the larger your search index, and conversely your database is going to be.','','5');
INSERT INTO setting VALUES('81','10','Allow Wild Cards?','allowwildcards','1','Allow users to use a star (*) in searches to match partial words?','yesno','6');
INSERT INTO setting VALUES('82','11','Enable Email features?','enableemail','1','Enable email sending features: send to friend and email notification for posters and moderators. Don\'t forget to remove those links from the forumdisplay, newreply, newtopic , & editpost templatesUser Permissions area .','yesno','1');
INSERT INTO setting VALUES('83','12','Time Zone Offset','timeoffset','+1','Time (in hours) that the server is offset from GMT. Please select the most appropriate option.','\r\n(GMT -12:00 hours) Eniwetok, Kwajalein \r\n(GMT -11:00 hours) Midway Island, Samoa \r\n(GMT -10:00 hours) Hawaii \r\n(GMT -9:00 hours) Alaska \r\n(GMT -8:00 hours) Pacific Time (US & Canada) \r\n(GMT -7:00 hours) Mountain Time (US & Canada) \r\n(GMT -6:00 hours) Central Time (US & Canada), Mexico City \r\n(GMT -5:00 hours) Eastern Time (US & Canada), Bogota, Lima, Quito \r\n(GMT -4:00 hours) Atlantic Time (Canada), Caracas, La Paz \r\n(GMT -3:30 hours) Newfoundland \r\n(GMT -3:00 hours) Brazil, Buenos Aires, Georgetown \r\n(GMT -2:00 hours) Mid-Atlantic \r\n(GMT -1:00 hours) Azores, Cape Verde Islands \r\n(GMT) Western Europe Time, London, Lisbon, Casablanca, Monrovia \r\n(GMT +1:00 hours) CET(Central Europe Time), Angola, Libya \r\n(GMT +2:00 hours) EET(Eastern Europe Time), Kaliningrad, South Africa \r\n(GMT +3:00 hours) Baghdad, Kuwait, Riyadh, Moscow, St. Petersburg, Volgograd, Nairobi \r\n(GMT +3:30 hours) Tehran \r\n(GMT +4:00 hours) Abu Dhabi, Muscat, Baku, Tbilisi \r\n(GMT +4:30 hours) Kabul \r\n(GMT +5:00 hours) Ekaterinburg, Islamabad, Karachi, Tashkent \r\n(GMT +5:30 hours) Bombay, Calcutta, Madras, New Delhi \r\n(GMT +6:00 hours) Almaty, Dhaka, Colombo \r\n(GMT +7:00 hours) Bangkok, Hanoi, Jakarta \r\n(GMT +8:00 hours) Beijing, Perth, Singapore, Hong Kong, Chongqing, Urumqi, Taipei \r\n(GMT +9:00 hours) Tokyo, Seoul, Osaka, Sapporo, Yakutsk \r\n(GMT +9:30 hours) Adelaide, Darwin \r\n(GMT +10:00 hours) EAST(East Australian Standard), Guam, Papua New Guinea, Vladivostok \r\n(GMT +11:00 hours) Magadan, Solomon Islands, New Caledonia \r\n(GMT +12:00 hours) Auckland, Wellington, Fiji, Kamchatka, Marshall Island \r\n ','1');
INSERT INTO setting VALUES('84','12','Format of dates','dateformat','m-d-Y','Format that the date is presented in on the pages.
\r\nSee: http://www.php.net/manual/function.date.php3
\r\nExamples:
\r\nSee: http://www.php.net/manual/function.date.php3
\r\nExamples:
\r\nSee: http://www.php.net/manual/function.date.php3 ','','5');
INSERT INTO setting VALUES('87','12','Birthday Format','calformat1','F j, Y','Format of date shown in profile when user gives their birthyear.','','6');
INSERT INTO setting VALUES('88','12','Birthday Format #2','calformat2','F j','Format of user\'s birthday shown on profile when the user does specify their birth year. DO NOT put in a code for the year.','','7');
INSERT INTO setting VALUES('89','13','Enable censor?','enablecensor','0','You may have certain words censored on your BB. Words you choose to censor will be replaced by asterisks. All subjects and messages will be affected. \r\n','yesno','1');
INSERT INTO setting VALUES('90','13','Words to censor','censorwords','','Type all words you want censored in the field below. Do not use commas to separate words, just use spaces. For example, type \"dog cat boy\", rather than \"dog, cat, boy.\" If you type \"dog\", all words containing the string \"dog\" would be censored (dogma, for instance, would appear as \"***ma\"). To censor more accurately, you can require that censors occur only for exact words. You can do this by placing a censor word in curly braces, as in {dog}. Signifying \"dog\" in the curly braces would mean that dogma would appear as dogma, but dog would appear as \"***\". Thus your censor list may appear as: cat {dog} {barn} barnmessage tracking section. (You may use HTML)','','13');
INSERT INTO setting VALUES('119','19','Delete \'cancelled\' messages?','pmcancelkill','0','When users \'cancel\' messages in the message tracking area, would you like to remove the message completely? WARNING: Selecting \'yes\' could confuse users who have been notified by email about the message.','yesno','17');
INSERT INTO setting VALUES('120','20','Add Standard headers','addheaders','0','This option does not work with some combinations of web server, so is off by default. However, some IIS setups may need it turned on.
\r\n\r\nIt will send the 200 OK HTTP headers if turned on.','yesno','1');
INSERT INTO setting VALUES('121','20','Add No-cache headers','nocacheheaders','0','Selecting yes will cause vBulletin to add no-cache HTTP headers. These are very effective, so adding them may cause server load to increase due to increase page requests.','yesno','2');
INSERT INTO setting VALUES('122','20','GZIP Output','gzipoutput','0','Selecting yes will enable vBulletin to gzip the output of pages, thus reducing bandwidth requirements. This will be only used on clients that support it, and are HTTP 1.1 compliant. There will be a performance overhead. This feature requires PHP 4.0.1 or greater, and the ZLIB library.','yesno','3');
INSERT INTO setting VALUES('123','20','GZIP compression level','gziplevel','1','Set the level of GZIP compression that will take place on the output. 0=none; 9=max.','','4');
INSERT INTO setting VALUES('124','20','Cookie Domain','cookiedomain','','The domain on which you want the cookie to have effect. If you want this to affect all of yourhost.com rather than just forums.yourhost.com, enter .yourhost.com here (note the 2 dots!!!). Can be left blank.','','5');
INSERT INTO setting VALUES('125','20','Path to save cookies','cookiepath','/','The path that the cookie is saved to. If you run more than one board on the same domain, it will be necessary to set this to the individual directories of the forums. Otherwise, just leave it as / .','','6');
INSERT INTO setting VALUES('126','21','Template version number','templateversion','2.2.2','Don\'t touch!','','0');
INSERT INTO setting VALUES('127','22','Spell Check Language','spellchecklang','en','The language used for the spell checking features, provided by Spellchecker.net . If you do not want to use these features, you should remove them from the template.','\r\nAmerican English \r\nBritish English \r\nFrench \r\nGerman \r\nItalian \r\nSpanish \r\nDanish \r\nBrazilian Portuguese \r\nDutch \r\nNorwegian \r\nPortuguese \r\nSwedish \r\nFinnish \r\n ','1');
INSERT INTO setting VALUES('128','23','Add template name in comments','addtemplatename','0','Add the template name at the beginning and end of every template rendered. This is useful for debugging and analyzing the HTML code, but turn it off to save bandwidth when running in a production environment.','yesno','1');
INSERT INTO setting VALUES('129','24','Simultaneous sessions limit','sessionlimit','0','Set this to the maximum number of simultaneous sessions that you want to be active at any one time. If this number is exceeded, new users are turned away until the server is less busy. Set this to 0 to disable this option.','','1');
INSERT INTO setting VALUES('130','24','*NIX Load Limit','loadlimit','0','vBulletin can read the overall load of the server on certain *nix setups (including Linux). This allows vBulletin to determine the load on the server and processor, and to turn away further users if the load becomes too high. If you do not want to use this option, set it to 0. A typical level would be 5.00 for a reasonable warning level.','','2');
INSERT INTO setting VALUES('131','25','Maximum Options','maxpolloptions','10','Maximum number of options a user can select for the poll. Set this to 0 to allow infinitely many options.','','1');
INSERT INTO setting VALUES('132','25','Update last post time','updatelastpost','1','Update the last post time for the thread (thus returning it to the top of a forum) when a vote is placed.','yesno','2');
INSERT INTO setting VALUES('133','26','Enable Avatars','avatarenabled','1','Use this option to enable/disable the overall use of avatars.\r\nSunday \r\nMonday \r\nTuesday \r\nWednesday \r\nThursday \r\nFriday \r\nSaturday \r\n ','9');
INSERT INTO setting VALUES('164','30','Upload In Safe Mode?','safeupload','0','If your server runs PHP with SAFE MODE Restrictions, set this to yes.','yesno','1');
INSERT INTO setting VALUES('165','30','Safe Mode Temp Directory','tmppath','/tmp','If your server is running in safe_mode, you\'ll need to specify a directory that is CHMOD to 777 that will act as a temporary directory for uploads. All files are removed from this directory after database insertion. Note: Do NOT include the trailing slash (\"/\") after the directory name.','','2');
INSERT INTO setting VALUES('166','30','Allow Image Size Checking Failure?','allowimgsizefailure','1','On some servers, calls to getimagesize() to check image dimensions may fail for currently unknown reasons. If you are affected by this, you will want to set this option to \"yes\", otherwise you will not be able to upload images (avatars or attachments). However, users may be able to get around your image dimension limits!','yesno','3');
INSERT INTO setting VALUES('167','31','Enable Who\'s Online','WOLenable','1','Selecting NO will disable Who\'s Online for everyone.','yesno','1');
INSERT INTO setting VALUES('168','31','Enable Guests','WOLguests','1','Display Guest activity on Who\'s Online?','yesno','2');
INSERT INTO setting VALUES('169','31','Resolve IPs','WOLresolve','0','Resolve IP addresses for those who have access to view them? This can slow down the Display of Who\'s Online.','yesno','3');
INSERT INTO setting VALUES('170','31','Refresh','WOLrefresh','60','Time period in seconds to refresh the Who\'s Online display. 0 disables refresh.','','4');
INSERT INTO setting VALUES('171','60','Number of images stored per member','sigimagesstored','2','The number of uploadable images that are to be stored for each member','','1');
INSERT INTO setting VALUES('172','60','Allow file serving?','sigfileserve','1','Allow external linking to signature images?','yesno','2');
INSERT INTO setting VALUES('173','60','Max Image Size','sigimagesize','60024','Max image size allowed to be uploaded','','3');
INSERT INTO setting VALUES('174','60','Base Directory','sigimagedir','images/pic','The base directory to store all signature images in','','4');
DROP TABLE IF EXISTS settinggroup;
CREATE TABLE settinggroup (
settinggroupid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL,
displayorder smallint(5) unsigned NOT NULL,
PRIMARY KEY (settinggroupid)
);
INSERT INTO settinggroup VALUES('1','Turn Your vBulletin on and off','1');
INSERT INTO settinggroup VALUES('2','General Settings','2');
INSERT INTO settinggroup VALUES('3','Contact Details','3');
INSERT INTO settinggroup VALUES('4','Posting Code allowances (vB code / HTML / etc)','4');
INSERT INTO settinggroup VALUES('5','Forums Home Page Options','5');
INSERT INTO settinggroup VALUES('6','User and registration options','6');
INSERT INTO settinggroup VALUES('7','Memberlist options','7');
INSERT INTO settinggroup VALUES('8','Thread display options','8');
INSERT INTO settinggroup VALUES('9','Forum Display Options','9');
INSERT INTO settinggroup VALUES('10','Search Options','10');
INSERT INTO settinggroup VALUES('11','Email Options','11');
INSERT INTO settinggroup VALUES('12','Date / Time options','12');
INSERT INTO settinggroup VALUES('14','Edit Options','14');
INSERT INTO settinggroup VALUES('15','IP Logging Options','15');
INSERT INTO settinggroup VALUES('16','Floodcheck Options','16');
INSERT INTO settinggroup VALUES('17','Banning Options','17');
INSERT INTO settinggroup VALUES('18','Language Options','18');
INSERT INTO settinggroup VALUES('19','Private Messaging Options','19');
INSERT INTO settinggroup VALUES('13','Censorship Options','13');
INSERT INTO settinggroup VALUES('20','HTTP Headers and output','20');
INSERT INTO settinggroup VALUES('21','Version Info','0');
INSERT INTO settinggroup VALUES('22','Spell Check','21');
INSERT INTO settinggroup VALUES('23','Templates','22');
INSERT INTO settinggroup VALUES('24','Load limiting options','24');
INSERT INTO settinggroup VALUES('25','Polls','25');
INSERT INTO settinggroup VALUES('26','Avatars','26');
INSERT INTO settinggroup VALUES('27','Attachments','27');
INSERT INTO settinggroup VALUES('28','Custom User Titles','28');
INSERT INTO settinggroup VALUES('29','Calendar','29');
INSERT INTO settinggroup VALUES('30','Upload Options','30');
INSERT INTO settinggroup VALUES('31','Who\'s Online','31');
INSERT INTO settinggroup VALUES('60','Signature Editor','60');
DROP TABLE IF EXISTS sigimage;
CREATE TABLE sigimage (
imageid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL,
extension char(3) NOT NULL,
PRIMARY KEY (imageid)
);
INSERT INTO sigimage VALUES('3','23','gif');
DROP TABLE IF EXISTS smilie;
CREATE TABLE smilie (
smilieid smallint(5) unsigned NOT NULL auto_increment,
title char(100) NOT NULL,
smilietext char(10) NOT NULL,
smiliepath char(100) NOT NULL,
PRIMARY KEY (smilieid)
);
INSERT INTO smilie VALUES('19','','','images/smilies/sunshine.gif');
INSERT INTO smilie VALUES('54','','','images/smilies/069.gif');
INSERT INTO smilie VALUES('24','','','images/smilies/022.gif');
INSERT INTO smilie VALUES('44','','','images/smilies/samurai.gif');
INSERT INTO smilie VALUES('17','','','images/smilies/027.gif');
INSERT INTO smilie VALUES('51','','','images/smilies/f.gif');
INSERT INTO smilie VALUES('21','','','images/smilies/wiggle2.gif');
INSERT INTO smilie VALUES('12','','','images/smilies/joker.gif');
INSERT INTO smilie VALUES('13','','','images/smilies/vb_icescream.gif');
INSERT INTO smilie VALUES('48','','','images/smilies/SLK.gif');
INSERT INTO smilie VALUES('15','','','images/smilies/0100.gif');
INSERT INTO smilie VALUES('16','','','images/smilies/03.gif');
INSERT INTO smilie VALUES('25','','','images/smilies/077.gif');
INSERT INTO smilie VALUES('26','','','images/smilies/a28.gif');
INSERT INTO smilie VALUES('27','','','images/smilies/cwm15.gif');
INSERT INTO smilie VALUES('28','','','images/smilies/kiss.gif');
INSERT INTO smilie VALUES('30','','','images/smilies/flash.gif');
INSERT INTO smilie VALUES('31','','','images/smilies/party.gif');
INSERT INTO smilie VALUES('32','','','images/smilies/q3aHappyMynx.gif');
INSERT INTO smilie VALUES('33','','','images/smilies/smoker.gif');
INSERT INTO smilie VALUES('35','','','images/smilies/a2.gif');
INSERT INTO smilie VALUES('36','','','images/smilies/split_spawn.gif');
INSERT INTO smilie VALUES('37','','','images/smilies/stop.gif');
INSERT INTO smilie VALUES('38','','','images/smilies/tasty.gif');
INSERT INTO smilie VALUES('39','','','images/smilies/vb_happymobutuseseseko.gif');
INSERT INTO smilie VALUES('53','','','images/smilies/m11.gif');
INSERT INTO smilie VALUES('42','','','images/smilies/no.gif');
INSERT INTO smilie VALUES('43','','','images/smilies/wah.gif');
INSERT INTO smilie VALUES('45','','','images/smilies/tomato.gif');
INSERT INTO smilie VALUES('46','','','images/smilies/tut.gif');
DROP TABLE IF EXISTS style;
CREATE TABLE style (
styleid smallint(5) unsigned NOT NULL auto_increment,
replacementsetid smallint(5) unsigned NOT NULL,
templatesetid smallint(5) unsigned NOT NULL,
title char(250) NOT NULL,
userselect smallint(5) unsigned NOT NULL,
PRIMARY KEY (styleid)
);
INSERT INTO style VALUES('1','1','1','Default','1');
DROP TABLE IF EXISTS subscribeforum;
CREATE TABLE subscribeforum (
subscribeforumid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL,
forumid smallint(5) unsigned NOT NULL,
emailupdate smallint(5) unsigned NOT NULL,
PRIMARY KEY (subscribeforumid),
KEY userid (userid)
);
INSERT INTO subscribeforum VALUES('1','8','5','0');
DROP TABLE IF EXISTS subscribethread;
CREATE TABLE subscribethread (
subscribethreadid int(10) unsigned NOT NULL auto_increment,
userid int(10) unsigned NOT NULL,
threadid int(10) unsigned NOT NULL,
emailupdate smallint(5) unsigned NOT NULL,
PRIMARY KEY (subscribethreadid),
KEY threadid (threadid)
);
INSERT INTO subscribethread VALUES('8','1','9','0');
INSERT INTO subscribethread VALUES('9','1','10','0');
INSERT INTO subscribethread VALUES('10','1','11','0');
INSERT INTO subscribethread VALUES('13','1','14','0');
INSERT INTO subscribethread VALUES('11','1','12','0');
INSERT INTO subscribethread VALUES('12','1','13','0');
INSERT INTO subscribethread VALUES('14','10','15','0');
INSERT INTO subscribethread VALUES('15','10','13','0');
INSERT INTO subscribethread VALUES('16','1','15','0');
INSERT INTO subscribethread VALUES('18','1','18','0');
INSERT INTO subscribethread VALUES('19','12','19','0');
INSERT INTO subscribethread VALUES('20','1','19','0');
INSERT INTO subscribethread VALUES('21','13','20','0');
INSERT INTO subscribethread VALUES('22','10','20','0');
INSERT INTO subscribethread VALUES('23','14','21','0');
INSERT INTO subscribethread VALUES('24','14','9','0');
INSERT INTO subscribethread VALUES('25','14','14','0');
INSERT INTO subscribethread VALUES('26','1','21','0');
INSERT INTO subscribethread VALUES('27','1','22','0');
INSERT INTO subscribethread VALUES('28','1','23','0');
INSERT INTO subscribethread VALUES('30','1','25','0');
INSERT INTO subscribethread VALUES('32','1','27','0');
INSERT INTO subscribethread VALUES('33','1','28','0');
INSERT INTO subscribethread VALUES('67','1','42','0');
INSERT INTO subscribethread VALUES('35','1','30','0');
INSERT INTO subscribethread VALUES('66','1','44','0');
INSERT INTO subscribethread VALUES('37','1','32','0');
INSERT INTO subscribethread VALUES('38','1','33','0');
INSERT INTO subscribethread VALUES('39','18','34','0');
INSERT INTO subscribethread VALUES('40','1','34','0');
INSERT INTO subscribethread VALUES('41','14','35','0');
INSERT INTO subscribethread VALUES('43','14','34','0');
INSERT INTO subscribethread VALUES('44','14','37','0');
INSERT INTO subscribethread VALUES('85','23','56','0');
INSERT INTO subscribethread VALUES('46','18','19','0');
INSERT INTO subscribethread VALUES('47','18','13','0');
INSERT INTO subscribethread VALUES('48','18','32','0');
INSERT INTO subscribethread VALUES('49','18','18','0');
INSERT INTO subscribethread VALUES('50','18','12','0');
INSERT INTO subscribethread VALUES('51','1','35','0');
INSERT INTO subscribethread VALUES('52','1','37','0');
INSERT INTO subscribethread VALUES('84','25','55','0');
INSERT INTO subscribethread VALUES('83','25','54','0');
INSERT INTO subscribethread VALUES('55','1','20','0');
INSERT INTO subscribethread VALUES('56','9','39','0');
INSERT INTO subscribethread VALUES('57','18','9','0');
INSERT INTO subscribethread VALUES('58','1','39','0');
INSERT INTO subscribethread VALUES('60','1','40','0');
INSERT INTO subscribethread VALUES('61','9','41','0');
INSERT INTO subscribethread VALUES('62','9','42','0');
INSERT INTO subscribethread VALUES('63','18','43','0');
INSERT INTO subscribethread VALUES('64','18','44','0');
INSERT INTO subscribethread VALUES('68','1','41','0');
INSERT INTO subscribethread VALUES('69','1','43','0');
INSERT INTO subscribethread VALUES('70','1','45','0');
INSERT INTO subscribethread VALUES('71','1','46','0');
INSERT INTO subscribethread VALUES('72','1','47','0');
INSERT INTO subscribethread VALUES('73','8','34','0');
INSERT INTO subscribethread VALUES('74','1','48','0');
INSERT INTO subscribethread VALUES('75','1','49','0');
INSERT INTO subscribethread VALUES('78','1','50','0');
INSERT INTO subscribethread VALUES('77','18','33','0');
INSERT INTO subscribethread VALUES('79','18','51','0');
INSERT INTO subscribethread VALUES('80','18','52','0');
INSERT INTO subscribethread VALUES('81','8','41','0');
INSERT INTO subscribethread VALUES('82','18','53','0');
INSERT INTO subscribethread VALUES('86','23','50','0');
INSERT INTO subscribethread VALUES('87','10','56','0');
INSERT INTO subscribethread VALUES('88','10','54','0');
INSERT INTO subscribethread VALUES('89','18','57','0');
INSERT INTO subscribethread VALUES('90','18','58','0');
INSERT INTO subscribethread VALUES('91','18','59','0');
INSERT INTO subscribethread VALUES('92','27','60','0');
INSERT INTO subscribethread VALUES('93','18','61','0');
INSERT INTO subscribethread VALUES('97','29','65','0');
INSERT INTO subscribethread VALUES('95','31','63','0');
INSERT INTO subscribethread VALUES('96','31','64','0');
INSERT INTO subscribethread VALUES('98','1','66','0');
INSERT INTO subscribethread VALUES('99','32','67','0');
INSERT INTO subscribethread VALUES('100','18','68','0');
INSERT INTO subscribethread VALUES('101','18','69','0');
INSERT INTO subscribethread VALUES('102','1','61','0');
INSERT INTO subscribethread VALUES('103','1','60','0');
INSERT INTO subscribethread VALUES('104','1','67','0');
INSERT INTO subscribethread VALUES('105','1','59','0');
INSERT INTO subscribethread VALUES('106','1','65','0');
INSERT INTO subscribethread VALUES('107','1','54','0');
INSERT INTO subscribethread VALUES('108','1','58','0');
INSERT INTO subscribethread VALUES('109','1','57','0');
INSERT INTO subscribethread VALUES('110','1','56','0');
INSERT INTO subscribethread VALUES('111','29','70','0');
INSERT INTO subscribethread VALUES('112','29','71','0');
INSERT INTO subscribethread VALUES('113','29','72','0');
INSERT INTO subscribethread VALUES('114','29','73','0');
INSERT INTO subscribethread VALUES('115','1','51','0');
INSERT INTO subscribethread VALUES('116','1','63','0');
INSERT INTO subscribethread VALUES('117','1','64','0');
INSERT INTO subscribethread VALUES('118','1','55','0');
INSERT INTO subscribethread VALUES('119','1','53','0');
INSERT INTO subscribethread VALUES('120','1','69','0');
INSERT INTO subscribethread VALUES('121','1','74','0');
INSERT INTO subscribethread VALUES('122','1','73','0');
INSERT INTO subscribethread VALUES('123','1','72','0');
INSERT INTO subscribethread VALUES('124','1','71','0');
INSERT INTO subscribethread VALUES('125','1','70','0');
DROP TABLE IF EXISTS template;
CREATE TABLE template (
templateid smallint(5) unsigned NOT NULL auto_increment,
templatesetid smallint(6) NOT NULL,
title varchar(100) NOT NULL,
template mediumtext NOT NULL,
PRIMARY KEY (templateid),
KEY title (title,templatesetid)
);
INSERT INTO template VALUES('1','-1','whosonline','{htmldoctype}\n\n
\n$metarefresh\n$bbtitle - المتواجدون الان \n$headinclude\n\n\n\n$header\n\n\n\n $bbtitle \n
\n\n\n\n\n المتواجدين في $bbtitle في تمام $currenttime - $numbervisible عضو و $numberguests زائر \n\n اسم العضـو الموقـع اخر زيارة \n$onlinebits\n
\n
\n\n$legendtable\n\n$bbtitle - تنشيط التسجيل \n$headinclude\n\n\n$header\n\n$bbtitle - powered by vBulletin \n $headinclude\n\n\n$header\n\n\n\n\n $bbtitle \n\n $welcometext \n
\n\n\n\n \n \n$unregwelcomemessage \n \n
\n\n\n \n \n عدد الأعضاء » $numbermembers
\n \n \n $newposts \n مرحبا بالعضو الجديد » $newusername \n
\n \n \n الساعة الآن » $timenow.
\n \n \n
\n\n\n\n\n\n\n المنتدى المشاركات المواضيع آخر مشاركة بإشراف \n$forumbits\n$loggedinusers\n$pminfo\n
\n
\n\n\n\n\n $timezone $logincode \n \n
\n\n\n\n\n \n مشاركات جديدة \n \n لا يوجد مشاركات جديدة \n \n منتدى مغلق \n \n \n
\n\n\n$footer\n\n');
INSERT INTO template VALUES('4','-1','forumhome_birthdaybit','\n $forum[title] $forum[description] ');
INSERT INTO template VALUES('6','-1','forumhome_forumbit_level1_post','\n \n \n \n $forum[replycount] $forum[threadcount] $forum[lastpostinfo] $forum[moderators] ');
INSERT INTO template VALUES('7','-1','forumhome_forumbit_level2_nopost','\n \n $forum[title] $forum[description] \n ');
INSERT INTO template VALUES('8','-1','forumhome_forumbit_level2_post','\n $forum[title] $forum[description] $forum[replycount] $forum[threadcount] $forum[lastpostinfo] $forum[moderators] \n');
INSERT INTO template VALUES('9','-1','forumhome_lastpostby',' ');
INSERT INTO template VALUES('10','-1','forumhome_loggedinuser','$username $invisibleuser');
INSERT INTO template VALUES('11','-1','forumhome_loggedinusers','\n المتواجدون الآن بالمنتدى » ( $totalonline) شخص \n\n \n يتواجد الآن ($numberregistered) عضو ($numberguest) زائر |\n أكثر عدد تواجد في لحظة واحدة ($recordusers) في $recorddate عند الساعة $recordtime. \n');
INSERT INTO template VALUES('12','-1','forumhome_logincode','اشر الى قراءة كافة الاقسام | المسؤولين عن المنتدى خروج | أشر الى قراءة كافة الاقسام | المسؤولين عن المنتدى $moderator[username] ');
INSERT INTO template VALUES('15','-1','forumhome_newposts','شاهد المشاركات الجديدة ');
INSERT INTO template VALUES('16','-1','forumhome_pmloggedin','\n الرسائل الخاصة \n\n \n $bbuserinfo[username] » لديك ($newpm[messages]) رسالة جديدة منذ آخر زيارة. ');
INSERT INTO template VALUES('17','-1','forumhome_todayposts','شاهد المواضيع الجديدة هذا اليوم ');
INSERT INTO template VALUES('18','-1','forumhome_unregmessage','\n $bbtitle ترحب بكم أجمل ترحيب . في حال كانت زيارتكم الأولى فنرجو زيارة الأسئلة والأجوبة \n أو ربما ترغبون في المشاركة ، لذلك ينبغي عليكم بالتسجيل \n قبل كتابة أي مشاركة عليك بالضغط على وصلة التسجيل ولمشاهدة المشاركات إختر أحد المنتديات الواضحة أدناه .. مع تمنياتنا لكم بالمتعة والفائدة .\n ');
INSERT INTO template VALUES('19','-1','forumhome_welcometext','اهلاً وسهلاً بعودتك يا $username ');
INSERT INTO template VALUES('20','-1','forumdisplay','{htmldoctype}\n\n\n$bbtitle - $foruminfo[title] \n$headinclude\n\n\n$header\n\n\n\n $navbar\n $moderatedby$onlineusers \n $newthreadlink \n
\n\n\n\n $forumjump \n \n \n \n \n
\n\n\n\n$timezone \n ( \n ( \n
\n\n\n\n\n قوانين القسم: $forumrules$adminoptions \n \n
\n\n\n$footer\n\n');
INSERT INTO template VALUES('21','-1','forumdisplaybit','\n $thread[icon] \n $thread[gotonew] $paperclip$thread[movedprefix]$thread[typeprefix]$thread[title] $thread[pagenav] $thread[postedby] $thread[replycount] $thread[views] \n \n \n ');
INSERT INTO template VALUES('22','-1','forumdisplaybit_threadrate','