History of SetupMSSQL
Version 4 | Current version | |
---|---|---|
UNDER DEVELOPMENT You should first read How to unstall Bitweaver under IIS 5 This guide assumes (and has been tested on):
Firstly, create a new database in Enterprise Manager (SQL Server) or another tool (MSDE does not ship with Enterprise Manager). A good, free one is DBA Manager 2k. It can be called anything you like, I called mine 'BitWeaver'. Create a new login in your database with the same name as the IIS anonymous user (default is 'servername\IUSR_servername'). Give that user the sysadmin server role and db_owner role on the database you just created. Some modifications were made to the following files to get BitWeaver working: in /util/phpsniff/phpSniff.class.php, change line 188 from: {CODE()}$UA = ( $pv0 > 3 && $pv1 > 0 ) ? $_SERVERHTTP_USER_AGENT>'HTTP_USER_AGENT' : $HTTP_SERVER_VARSHTTP_USER_AGENT>'HTTP_USER_AGENT';{CODE} to {CODE()}$UA = ( $pv0 > 3 && $pv1 > 0 ) ? $_SERVERHTTP_USER_AGENT>'HTTP_USER_AGENT' : $_SERVERHTTP_USER_AGENT>'HTTP_USER_AGENT';{CODE} added this below "case "mssql"" in "function convertQuery" (about line 552, /kernel/BitDb.php): {CODE()} $pQuery = preg_replace("/`/", "", $pQuery); $pQuery = str_replace("AS user,", "AS user_login,", $pQuery); $pQuery = str_replace("=? ASC", " ASC", $pQuery); $pQuery = str_replace("=? DESC", " DESC", $pQuery); break; {CODE} changed this function in /user/BitUser.php (about line 1003): {CODE()}function isPasswordDue() { $ret = FALSE; if( $this->isRegistered() ) { // get user_id to avoid NULL and zero confusion $query = "SELECT `user_id`, `pass_due` FROM `".BIT_DB_PREFIX."users_users` WHERE `pass_due` IS NOT NULL AND `login`=? "; $due = $this->GetAssoc( $query, array( (string) $this->mUserId ) ); if( !empty( $dueuser_id>'user_id' ) ) { $ret = $duepass_due>'pass_due' <= date("U"); } } return $ret; }{CODE} | You should first read How to install Bitweaver under IIS 5 (SetupIIS). This guide assumes (and has been tested on):
{CODE()}if ($len > 4000 ) { // NVARCHAR is max 4000 chars. Let's use NTEXT $decl .= "@P$i NTEXT"; } else { $decl .= "@P$i NVARCHAR($len)"; } $params .= "@P$i=N". (strncmp($v,"'",1)==0? $v : $this->qstr($v));{CODE} to: {CODE()}$decl .= "@P$i VARCHAR($len)"; $params .= "@P$i=". (strncmp($v,"'",1)==0? $v : $this->qstr($v));{CODE} Can this be adjusted from PHP.INI? - wolff_borg: ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. ;mssql.textsize = 4096 Outstanding issues:
|