i need help about my ranshop when i buy item from item shop i cant redeem my item in item bank
Printable View
i need help about my ranshop when i buy item from item shop i cant redeem my item in item bank
make sure your glogic.rcc in your client or server is compatible
sir what are you talking about? it's about ran CP not in-game.Quote:
Originally Posted by philallstar
@TS on your database>RanShop>Tables>dbo.ShopPurchase
on your dbo.shoppurchase (please delete all content).
then change the purflag to 1 then try it again on your shop if you get the item.
if not change the purflag again to 0
that's it.
I also encounter this problem.
Resolve it in this step.:thumbup1:
purflag to 1 where i can change it in ShopPurflag?
Code:USE [RanShop]
GO
/****** Object: Table [dbo].[ShopItemMap] Script Date: 07/24/2011 18:41:25 ******/
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,
[ItemList] [smallint] NULL CONSTRAINT [DF_ShopItemMap_ItemList] DEFAULT ((1)),
[ItemMoney] [int] NOT NULL CONSTRAINT [Df_shopitemmap_ItemMoney] DEFAULT ((0)),
[ItemType] [int] NOT NULL CONSTRAINT [Df_shopitemmap_ItemType] DEFAULT ((0)),
[ItemComment] [varchar](300) NULL,
[Duration] [varchar](50) NULL,
[Category] [int] NULL,
[ItemStock] [int] NOT NULL CONSTRAINT [DF__ShopItemM__ItemS__5070F446] DEFAULT ((0)),
[ItemImage] [varchar](300) NULL,
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
Code:USE [RanShop]
GO
/****** Object: Table [dbo].[ShopPurchase] Script Date: 03/09/2011 16:30:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ShopPurchase](
[PurKey] [varchar](21) NULL,
[UserUID] [varchar](20) NOT NULL,
[ProductNum] [int] NOT NULL,
[PurPrice] [int] NOT NULL CONSTRAINT [DF_ShopPurchase_PurPrice] DEFAULT ((0)),
[PurFlag] [int] NOT NULL CONSTRAINT [DF_ShopPurchase_PurFlag] DEFAULT ((0)),
[PurDate] [datetime] NOT NULL CONSTRAINT [DF_ShopPurchase_PurDate] DEFAULT (getdate()),
[PurChgDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
Itachi the item is there but i cant redeem it in item bank when i click the item and relog the item is gone if i dont click the item in item bank it wont gone when relog but still its stuck in item bank
mine also wont show in item bank when i buy item in shop im using babyran blue CP
as i said in my 1st reply.Quote:
Originally Posted by AlphaStigma
open you SQL>database>RanShop>Tables>dbo.ShopPurchase>(right click and click Design)
dbo.ShopPurchase(will appear)
next
Look (or click PurFlag)
PurFlag Settings will appear)
@(General)
this will be appear
(Name) --> PurFlag
Allow Null --> No
Data Type --> int
Default Value or Biding--> ((0)) [Change this to 1]
sir try to follow the guide i reply. :thumbup: hope it's help.Quote:
Originally Posted by Genjou
man still not working :( im using babyran blue website idk whats wrong the sql setting or the website :(
My Problem in RanShop I can See the Items in Website but i can buy and i can use the Item when I buy in website only the Pictures of Items not appearing in website
okay let me know if you still have problems with your item shop. Because when im exploring and trying current database shared here and used on old website, there is problem with the purkey. even you execute those script (which is also provide here on ragezone) It wont work you have to make your own script for you to make compatible with your game client & Website(input) & Database. I would love to help you using teamviewer and make custom script.
for short theres problem on declaring purkey on your database logs.