Rancp problem how can delete this row i want to make only one row for the item thank

[bhoszmuco14]

RANCP PROBLEM HOW CAN DELETE ALL OF THIS ROW

I WANT TO MAKE ONLY ONE ROW FOR THE ITEM SHOP
THANK





THANKS

and why every time i buy on itemshop i didn`t recieve the item that i buy

[MentaL]

[raffy0809]

the problem is in your ranshop.... and if you want to delete that row edit the corresponding php file..

[bhoszmuco14]

problem solved but how to fix because if i buy an item on itemshop .. i didn`t receive ..

[deedz12]

Here! the guide how to fix that kind of problem dude :)

[bhoszmuco14]

will try this liked

not working sir i already followed the ep7 shop.bak on that thread

[tearhear18]

check your itempurkey

[deedz12]

did you execute this ?

Quote:
USE [RanShop]
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurPrice]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurPrice]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurFlag]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurFlag]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ShopPurchase_PurDate]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[ShopPurchase] DROP CONSTRAINT [DF_ShopPurchase_PurDate]
END

GO

USE [RanShop]
GO

/****** Object: Table [dbo].[ShopPurchase] Script Date: 05/20/2010 19:17:31 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ShopPurchase]') AND type in (N'U'))
DROP TABLE [dbo].[ShopPurchase]
GO

USE [RanShop]
GO

/****** Object: Table [dbo].[ShopPurchase] Script Date: 05/20/2010 19:17:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ShopPurchase](
[PurKey] [varchar](21) NOT NULL,
[UserUID] [varchar](20) NOT NULL,
[ProductNum] [int] NOT NULL,
[PurPrice] [int] NOT NULL,
[PurFlag] [int] NOT NULL,
[PurDate] [datetime] NOT NULL,
[PurChgDate] [datetime] NULL,
CONSTRAINT [PK_ShopPurchase] PRIMARY KEY CLUSTERED
(
[PurKey] 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
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurPrice] DEFAULT ((0)) FOR [PurPrice]
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurFlag] DEFAULT ((0)) FOR [PurFlag]
GO

ALTER TABLE [dbo].[ShopPurchase] ADD CONSTRAINT [DF_ShopPurchase_PurDate] DEFAULT (getdate()) FOR [PurDate]
GO

[tearhear18]

try to check itempurchase if your username is inserted

[bhoszmuco14]

Master tearhear18 @ i checked but no purchase record here .

Deedz@ nope didn`t execute that sir how to execute do you have .. and file for that

[MicoJohn20]

Hello .. See Ran Cp Ep3 :)

Picture i easy haha ..

http://postimg.org/image/ul6u6pd69/