Another problem with the install kit 0.9.3

In the 0.9.3 release of Content.NET in 05/24/2006 we lost many Stored Procedures.

You can get errors if you update the portal info or you add a new page.

Now the install kit has this SPs, but if you do not want download this another time you can add this SPs executing this database scripts by QueryAnalizer or other ways.

   1: --

   2: -- MPT_UpdatePortal

   3: --

   4: CREATE PROCEDURE dbo.[MPT_UpdatePortal] 

   5: (

   6:     @PortalId    int,

   7:     @TabId        int

   8: )

   9: AS

  10: Set nocount off

  11: Update portals

  12: set MyPortalTabID = @TabId

  13: where portalid = @PortalId

  14: --

  15: -- AddTab

  16: --

  17: ALTER procedure dbo.AddTab

  18: (

  19: @PortalID           int,

  20: @TabName            nvarchar(50),

  21: @ShowMobile         bit,

  22: @MobileTabName      nvarchar(100),

  23: @AuthorizedRoles    nvarchar (256),

  24: @IsVisible          bit,

  25: @DisableLink        bit,

  26: @ParentId           int,

  27: @IconFile           nvarchar(100),

  28: @AdministratorRoles nvarchar (256),

  29: @TabSkinID          int,

  30: @URL                nvarchar(256),

  31: @TabID              int OUTPUT

  32: )

  33: as

  34: insert into Tabs (

  35:     PortalID,

  36:     TabName,

  37:     ShowMobile,

  38:     MobileTabName,

  39:     AuthorizedRoles,

  40:     IsVisible,

  41:     DisableLink,

  42:     ParentId,

  43:     IconFile,

  44:     AdministratorRoles,

  45:     TabSkinID,

  46:     [level],

  47:     TabOrder,

  48:     LastChange,

  49:     Deleted,

  50:     ShowInChildren,

  51:     URL,

  52:     ParentItemId,

  53:     LangId 

  54: )

  55: values 

  56: (

  57:     @PortalID,

  58:     @TabName,

  59:      0,

  60:      ' ',

  61:     @AuthorizedRoles,

  62:     @IsVisible,

  63:     @DisableLink,

  64:     @ParentId,

  65:     @IconFile,

  66:     @AdministratorRoles,

  67:     @TabSkinID,

  68:     1,

  69:     1,

  70:     getDate(),

  71:     0,

  72:     0,

  73:     @URL,

  74:     -1,

  75:     0

  76: )

  77: select @TabID = @@IDENTITY

  78: GO

  79: --

  80: -- UpdateTabOrder

  81: --

  82: create procedure dbo.[UpdateTabOrder]

  83: @TabID    int,

  84: @TabOrder int,

  85: @Level    int,

  86: @ParentId int

  87: as

  88: update Tabs

  89: set    TabOrder = @TabOrder,

  90:        Level = @Level,

  91:        ParentId = @ParentId

  92: where  TabID = @TabID

 

Etiquetas de Technorati: Content.NET