bakacagiz işte çeşitli pazarlama stratejileri degerlendirecegiz bu konuda :P

mesela install.php oluşturmayi anlattim. tek başına 33 dakika sürmüş

Örnek Kod

<?php
include('mainLib/core.php');

if( isTableExist($mainConfig["dbPrefix"]."broke") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."broke (  id int(11) NOT NULL auto_increment,  fldctime int(11) default NULL,  fldprogram int(11) default NULL,  PRIMARY KEY  (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."cat") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."cat (  id int(11) NOT NULL auto_increment,  fldname varchar(200) default NULL,  PRIMARY KEY  (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."comment") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."comment (  id int(11) NOT NULL auto_increment,  fldctime int(11) default NULL,  fldstatus enum('0','1') default '0',  fldprogram int(11) default NULL,  fldcomment text,  PRIMARY KEY  (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."contact") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."contact (  id int(11) NOT NULL auto_increment,  fldctime int(11) default NULL,  fldipaddress varchar(20) default NULL,  fldname varchar(200) default NULL,  fldmail varchar(200) default NULL,  fldsubject varchar(200) default NULL,  fldmsg text,  PRIMARY KEY  (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."news") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."news (  id int(11) NOT NULL auto_increment,  fldctime int(11) default NULL,  fldhead varchar(200) default NULL,  fldinfo text,  fldcontent text,  PRIMARY KEY  (id)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."program") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."program (  id int(11) NOT NULL auto_increment,  fldctime int(11) default NULL,  fldutime int(11) default NULL,  fldstatus enum('0','1') default '1',  fldsubcat int(11) default NULL,  fldname varchar(200) default NULL,  fldinfo text,  fldhit int(11) default NULL,  fldshit int(11) default NULL,  fldversion varchar(20) default NULL,  fldpicture varchar(200) default NULL,  fldurl varchar(200) default NULL,  fldfirm varchar(200) default NULL,  fldfirmweb varchar(200) default NULL,  fldsize int(11) default NULL,  fldlang enum('tr','en') default 'en',  fldvotenum int(11) default NULL,  fldvote int(11) default NULL,  flded enum('0','1') default '0',  PRIMARY KEY  (id),  KEY fldsubcat (fldsubcat)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}
if( isTableExist($mainConfig["dbPrefix"]."setting") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."setting (  fldmaxpicw int(11) default '500',  fldmaxpich int(11) default '500',  fldthumbpicw int(11) default '150',  fldthumbpich int(11) default '150',  fldcommentstatus enum('0','1') default '0',  fldlastprog int(11) default '10',  fldhitprog int(11) default '10',  fldsitekeyword text,  fldsitedescription text,  fldsitetitle varchar(200) default NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8;");        
    mysql_query("INSERT INTO dw_setting VALUES('500', '500', '150', '150', '0', '10', '10', NULL, NULL, NULL);");
}
if( isTableExist($mainConfig["dbPrefix"]."subcat") == false){
    mysql_query("CREATE TABLE ".$mainConfig["dbPrefix"]."subcat (  id int(11) NOT NULL auto_increment,  fldcat int(11) default NULL, fldname varchar(200) default NULL,  PRIMARY KEY  (id),  KEY fldcat (fldcat)) ENGINE=MyISAM DEFAULT CHARSET=utf8;");
}

// Alan ekleme işlemleri

if( isFieldExist( $mainConfig["dbPrefix"]."cat" , 'fldseourl') == false ){
    mysql_query("ALTER TABLE `".$mainConfig["dbPrefix"]."cat` ADD `fldseourl` VARCHAR(200) ");
}
if( isFieldExist( $mainConfig["dbPrefix"]."subcat" , 'fldseourl') == false ){
    mysql_query("ALTER TABLE `".$mainConfig["dbPrefix"]."subcat` ADD `fldseourl` VARCHAR(200) ");
}
if( isFieldExist( $mainConfig["dbPrefix"]."program" , 'fldseourl') == false ){
    mysql_query("ALTER TABLE `".$mainConfig["dbPrefix"]."program` ADD `fldseourl` VARCHAR(200)  AFTER `fldname`");
}
?>