
  CMSٷվ www.cnyjwl.com      ܹٷ̳ www.cnyjwl.com/Forum


                       Ϻ                               
  ַhttp://www.cnyjwl.com    http://yjwl.sh.cn                  
  ̳http://www.cnyjwl.com/Forum                                 
  绰021-33197852   021-33197280                                 
  QQ  306060847      105312359                                    
  E_MAIL:   cnyjwl@vip.qq.com  ʱվϵͳ CNYJWL CMS      
 ǰ汾YJCMS V6.0 20080618                                    
 Ȩ: ʱ( www.cnyjwl.com ) ϺƼ޹˾    
ǩ
 ܹ˾ģԱ  ϵQQ306060847    105312359     
 ܷ   һ   http://idc.cnyjwl.com          
ǩ
Ȩ                                                        
 ʱչٷȨɣý֮ӯӯԵҵ;     
 ʹ뱣ӡ                                 
 ΪӦʵʵļӦû߸Ľ书ܡܣԽбҪ޸ 
 ȥʱյİȨʶý޸ĺ汾κεҵΪ 
 ΪûѡǷʹãʹгκ 
 ʧ粻κΡ                                       

 

뽫CMSĿ¼ļϴWEBռ

ãΪṩõĳ      www.cnyjwl.com 
̨ϵͳȵ½վǰ̨ſԽ̨  admin  admin888    
װ˵
*************************************************************************
*  װ˵ 
* ݿַĬϵΪ: Data#Base#/YJCms_V6_0_Data.Mdb(Ѿɼݿ⡢IPݿ⡢༭ݿݿ)
* ̨½·: ַ/Admin/Admin_login.asp
* ĬϵĹԱû: cnyjwl 룺cnyjwl
* оʹñ̳ɾݵáԹ˵ٶ롣
* ϵͳԴ˵ַܼ󲿷ݶύߵID
* ע빦ܿ޷˵ַʱùηɣĬϿɳ3ΣԶIP
* ϴ»ʲôҪִWebServerClearCache.aspȫ档ʹɾ
* ˵:ʹCOOKIESʱվʹתĻΪվϵCOOKIESǻʾġһʧCOOKIESʱ޷ʾ
* ACCSQL뵼иĺɵ뱾޹ء
* 󣬺̨ϴеġԤЧ
*************************************************************************
 й̶λ 
*************************************************************************
̳¥棺(1¥)ForumViewLayer1
̳¥棺(2¥)ForumViewLayer2
̳¥棺(3¥)ForumViewLayer3
̳бβ棺ForumListEndAds
ŻлNewsView
»лArticleView
ϴʹùɡһҪزЧ.
λùԼӦӲģӦַʹJSɱǩ档
*************************************************************************
 SQL˵ 
*************************************************************************
SQLݿ˵
* YJCMS_Sql.sql ִϵͳݱ
* YJCms_Other.sql ִɲɼݿ⡢༭ݿ
1 "ҵ" -> "" -> "ݿ" Ҽ "ݿ"  
Զ磺"YJCMS"Ŀ԰Ĭֵӳɹ 
2 "ҵ" -> "" -> "ݿ" -> "YJCMS" (ݿ)  
ѡ˵ϵ "" -> "SQLѯ"ṩ YJCMS_Sql.sql ļ 
ѡ˵ϵ "ѯ" -> "ִ" ( "F5" Ҳ) ִгɹ 
3 "ҵ" -> "" -> "ȫ" -> "½" Ҽ "½½" 
д£ 
ƣ"sql_name" (ݿ½û) 
֤ѡ "SQL Server ֤" Ϊ"sql_pass" (ݿ½) 
ݿѡ"YJCMS" 
ɫѡBulk Insert Administrators 
ݿ "" ѡ"YJCMS"ݿɫѡ"public""db_owner" 
ȷٴһ룺"sql_pass" óɹ 
δ˵ SQL Server ĬֵҪĶ 
дԼҪ룬޸ĳɸһģ 
޸뽫Ŀ¼ Include/Conn.asp ļϢ޸һ.
SqlType=1 ʹSQL޸ĵĿ,ʾʹSQLݿ
SqlData = "YJCMS" ݿ,дӵݿ
Sqluid = "cnyjwl" ݿ½û,дӵû
Sqlpwd = "cnyjwl" ݿ½,дӵĵ½
4ݿ, YJCms_Sql.mdb еݵ뵽SQLݿ, DataBase/YJCms_V6_0_Data.mdb еݵ!
5Ҫɼݿ⡢IPݿ⡢༭ݿ⡱SQLУSQLṩ YJCms_Other.sql ļִɱ(Բʹֱӽһ)
6ڽ DataBase/YJCms_Collection.mdbDataBase/YJCms_Ip.mdb еݵ롣
*************************************************************************

*************************************************************************
 BTļ 
************************************************************************* 
iis--վ----httpͷ--mime--½--չ.torrent mimeͣapplication
*************************************************************************
 SQLṩʹãжִ 
ɾĳĳֶALTER TABLE DB_Ads DROP COLUMN IsTime

Alter Table DB_Down Add Server_Id integer Default (0) null
Alter Table DB_Movie Add Server_Id integer Default (0) null

Alter Table DB_Configs Add [SqlInword] ntext null
Alter Table DB_Configs Add [NoChkFiles] ntext null
Alter Table DB_Configs Add [AdsFilter] ntext null 

Alter Table DB_Down Add [NotDown] [bit] NULL
Update DB_Down Set NotDown='True'
alter table DB_Down alter column [NotDown] [bit] NOT NULL

Update DB_Cards Set c_pay='' Where c_name='HG2007082410'

Update DB_Configs Set Payment='||0|https://pay3.chinabank.com.cn/PayGate|/Shop/Pay_Return_Shop.asp||||https://www.alipay.com/cooperate/gateway.do?|trade_create_by_buyer|1'

Alter Table DB_Channel Add [BornClassRowNum] integer Default (0) null

Alter Table DB_Shop Add [StocksName] nvarchar (4) null
Update DB_Channel Set ChannelOption='Ʒ|Ԫ|YJ|л::ȱ|ͨ,0:ʼ,10:ؿ,20|ͨ,0:ʼ,10:ؿ,20|::::' where ChannelIDs=3
Update DB_Shop Set StocksName=''

Update DB_Menu Set MenuName='' where MenuID=126
Update DB_Menu Set MenuTit='' where MenuID=126

Update DB_ShopOrders Set ispay=1

Update DB_ShopOrders Set ispay=0 where ordernum=20080319171551

Alter Table DB_NotesEmoney Add e_payment nvarchar(20) null 

Alter Table DB_Down Add [UseServer] [bit] NULL
Update DB_Down Set UseServer='True'
alter table DB_Down alter column [UseServer] [bit] NOT NULL

Alter Table DB_Down Add [FileAddress] nvarchar(255) null

Alter Table DB_Server Add [IsDisabled] [bit] NULL
Update DB_Server IsDisabled='True'
alter table DB_Server alter column [IsDisabled] [bit] NOT NULL

Alter Table DB_Server Add [S_ReadMe] ntext null
Alter Table DB_Server Add [S_Union] integer Default (0) null
Alter Table DB_Server Add [S_UID] nvarchar(50) null

Alter Table DB_Shop Add [NotGoods] [bit] NULL
Update DB_Shop Set NotGoods='True'
alter table DB_Shop alter column [NotGoods] [bit] NOT NULL
Alter Table DB_Shop Add [OutStocks] nvarchar(8) null
Alter Table DB_Shop Add [Con_Expression] integer null
Alter Table DB_Shop Add [Con_Strength] integer null
Alter Table DB_ShopOrders Add [iscon] bit null
Update DB_ShopOrders Set iscon='True'
alter table DB_ShopOrders alter column [iscon] [bit] NOT NULL
Update DB_Shop Set OutStocks=0
Update DB_Shop Set Con_Expression=0
Update DB_Shop Set Con_Strength=0

Alter Table DB_Channel Add [ChannelReward] nvarchar (50) null
Alter Table DB_Channel Add [ChannelDates] nvarchar (50) null
Update DB_Channel Set ChannelReward='0@@@0@@@0@@@0'
Update DB_Channel Set ChannelDates='0@@@0@@@0@@@0'

Alter Table DB_Movie Add [Server_Id] [int] NULL DEFAULT (0)

Alter Table DB_Review Add [RGrade] [integer] DEFAULT (0) null
Update DB_Review Set RGrade=0

Update DB_UserData Set Tmp=''

alter table DB_Upload alter column [UpFileType] nvarchar(8) null

Alter Table DB_Ads Add [AdTime] datetime null

Alter Table DB_Ads Add [IsTime] bit Default (0) not null

alter table DB_Menu alter column [MenuID] integer IDENTITY (1,1) not null


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


                        Ϻ                          
                                                                
  ַhttp://www.cnyjwl.com    http://yjwl.sh.cn              
  ̳http://www.cnyjwl.com/Forum                             
  绰021-33197852   021-33197280                             
  QQ  306060847      105312359                                
  E_MAIL:   cnyjwl@vip.qq.com                                   
