Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Item shop of ep7 ^_^ 100% working

Divine Celestial
Joined
Nov 30, 2010
Messages
846
Reaction score
7
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
 

Attachments

You must be registered for see attachments list

FTD

Newbie Spellweaver
Joined
Feb 25, 2012
Messages
40
Reaction score
1
Yea ur GUID is GOOD keep it UP..:thumbup:
 
Divine Celestial
Joined
Nov 30, 2010
Messages
846
Reaction score
7
urbanmuzik-Nod nid SS for this if you do this you see working 100% heheh..

FTD-thnx Press LIKE ^_^ wahahah
 
Junior Spellweaver
Joined
Jan 23, 2009
Messages
117
Reaction score
1
cant see my items on itemshop i use ran extinction cp..
 
Joined
Apr 15, 2011
Messages
663
Reaction score
132
cant see my items on itemshop i use ran extinction cp..

Delete your dbo.shopitemmap in RanShop then execute this script :

PHP:
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
 
Junior Spellweaver
Joined
Jan 23, 2009
Messages
117
Reaction score
1
@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 !
 
Last edited:
Junior Spellweaver
Joined
Apr 7, 2013
Messages
137
Reaction score
8
Delete your dbo.shopitemmap in RanShop then execute this script :

PHP:
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..
 
Back
Top