1 Attachment(s)
Item shop of ep7 ^_^ 100% working
elow guys
If you have a problem in your RanShop ty my RANSHOP.BAK
This is EP6 RanShop but its working on EP7 100% ^_^
Guide
- Extrack the Ranshop.rar in "C:"
- Open MSSQL Server Management Studio
- Login by the user sa and password ****
- Expand Database +++
- Expand RanShop Database
- Click RanShop
- RightClick>>Choose Tasks>>Restore>>Database
- They Popup Medium Box and Find "From Device" click the small rectangle.
- They Popup again Small Box Click "Add" and find the "RanShop.bak" Click it and Press OK.
- Check the Restore>>Option>>Check "Overwrite the existing database" Press OK..
That all ^_^
(Ok lang ba tong ginawang kong guide??) :*::*::*:
Like plsee
Re: Item shop of ep7 ^_^ 100% working
Yea ur GUID is GOOD keep it UP..:thumbup:
Re: Item shop of ep7 ^_^ 100% working
since this isa tutorial maybe u should include some SS. to make this more attractive to our newbie to rz ran section troops
Re: Item shop of ep7 ^_^ 100% working
urbanmuzik-Nod nid SS for this if you do this you see working 100% heheh..
FTD-thnx Press LIKE ^_^ wahahah
Re: Item shop of ep7 ^_^ 100% working
cant see my items on itemshop i use ran extinction cp..
Re: Item shop of ep7 ^_^ 100% working
Quote:
Originally Posted by
juzztin12
cant see my items on itemshop i use ran extinction cp..
Delete your dbo.shopitemmap in RanShop then execute this script :
PHP Code:
USE [RanShop]
GO
/****** Object: Table [dbo].[ShopItemMap] Script Date: 04/24/2012 11:52:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ShopItemMap](
[ProductNum] [int] IDENTITY(1,1) NOT NULL,
[ItemMain] [int] NULL,
[ItemSub] [int] NULL,
[ItemName] [varchar](100) NULL,
[ItemSec] [int] NULL,
[ItemPrice] [varchar](100) NULL,
[Itemstock] [varchar](100) NULL,
[ItemCtg] [int] NULL,
[Itemexp] [varchar](100) NULL,
[ItemIco] [varchar](100) NULL,
[ItemSS] [varchar](100) NULL,
[date] [datetime] NOT NULL CONSTRAINT [DF_ShopItemMap_date] DEFAULT (getdate()),
CONSTRAINT [PK_ShopItemMap] PRIMARY KEY CLUSTERED
(
[ProductNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Re: Item shop of ep7 ^_^ 100% working
@freedomrecords - iwill trythis now
--
it works but it show only in latest items but in category V items cant see also in category weapons ..
i add lava sword for testing , i put it in the category of weapons . but it cant show in my exact itemshop it only show in latest item .
--
it works thanks ,, i cant see my items on my server pc but in other pc i see my items on itemshop .
thanks for this script .. i will also click like for this !
Re: Item shop of ep7 ^_^ 100% working
@juzztin - your welcome .
Re: Item shop of ep7 ^_^ 100% working
Quote:
Originally Posted by
FreedomRecords
Delete your dbo.shopitemmap in RanShop then execute this script :
PHP Code:
USE [RanShop]
GO
/****** Object: Table [dbo].[ShopItemMap] Script Date: 04/24/2012 11:52:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ShopItemMap](
[ProductNum] [int] IDENTITY(1,1) NOT NULL,
[ItemMain] [int] NULL,
[ItemSub] [int] NULL,
[ItemName] [varchar](100) NULL,
[ItemSec] [int] NULL,
[ItemPrice] [varchar](100) NULL,
[Itemstock] [varchar](100) NULL,
[ItemCtg] [int] NULL,
[Itemexp] [varchar](100) NULL,
[ItemIco] [varchar](100) NULL,
[ItemSS] [varchar](100) NULL,
[date] [datetime] NOT NULL CONSTRAINT [DF_ShopItemMap_date] DEFAULT (getdate()),
CONSTRAINT [PK_ShopItemMap] PRIMARY KEY CLUSTERED
(
[ProductNum] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Sir,
why do we need to delete the shopitemmap from Ranshop in order to execute the script? I noticed all my Items recreated from Ran Manager 3.2 are all deleted, but luckily all my items inserted to my modified Control panel shared by, which solved the appearance of items inside my webshop, but I'd like to know if someone who can share the perfect RANMANAGER to be recreated the shopitemap fully functioning both "ItemShop appearance from Control panel and Ran manager recreation of shop item map..
who can share script that will function both ranmanager itemstrtable recreated that will perfectly shown up in itemshop control panel like "Dutch_X panel or Glacier CP..
Re: Item shop of ep7 ^_^ 100% working
nice sir, let me try :thumbup:
