Yet another itemshop problem...

[gign919191]

ok, I added an item to the shop and tried to buy it, it says item bought succesfully, but it gives an error on the background, and the item is not sent to my account.

Here is the error:

[MentaL]

[wesman2232]

umm...let me see your AccountItem.dbo table (in CREATE form) and line 590 in mod_itemshop.php

[gign919191]

Line 590:

            mssql_query("INSERT INTO AccountItem ([ItemShopID], [AID], [ItemID], [RentDate], [RentHourPeriod], [Cnt])VALUES('$itemid', '$aid', '$zitemid', GETDATE(), 60, 0)");

And AccountItem:

[wesman2232]

in create form. (Tasks > something > CREATE)

[gign919191]

you mean like this?

USE [GunzDB]
GO
/****** Object:  Table [dbo].[AccountItem]    Script Date: 03/21/2009 13:21:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AccountItem](
	[ItemShopID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[RentDate] [datetime] NULL CONSTRAINT [DF__AccountIt__RentD__116A8EFB]  DEFAULT (NULL),
	[RentHourPeriod] [smallint] NULL CONSTRAINT [DF__AccountIt__RentH__125EB334]  DEFAULT (NULL),
	[Cnt] [smallint] NULL CONSTRAINT [DF__AccountItem__Cnt__1352D76D]  DEFAULT (NULL),
 CONSTRAINT [Table1_PK] PRIMARY KEY CLUSTERED 
(
	[ItemShopID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AccountItem]  WITH CHECK ADD  CONSTRAINT [Account_Table1_FK1] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO
ALTER TABLE [dbo].[AccountItem] CHECK CONSTRAINT [Account_Table1_FK1]
GO
ALTER TABLE [dbo].[AccountItem]  WITH CHECK ADD  CONSTRAINT [Item_Table1_FK1] FOREIGN KEY([ItemID])
REFERENCES [dbo].[Item] ([ItemID])
GO
ALTER TABLE [dbo].[AccountItem] CHECK CONSTRAINT [Item_Table1_FK1]

[BRAZIL-PAULINHO]

Yeah My Problem its on this part

[wesman2232]

umm ok, im stumped, ill check it out myself.

[BRAZIL-PAULINHO]

YEAAHHHHHHHH I FIXED MINE ITEMS R GOING TO GAME NOW =))) THX A LOT WESMAN AND gign

FIX:

[wesman2232]

you sure that will fix? didnt say anything about ShopItemID D:
but oh well let gign try it and see if it fixes.

[BRAZIL-PAULINHO]

Yes




=))

[wesman2232]

ok it fixes it for me thanks :) mine gave me the error that says "column ShopItemID was not found"
though idk about gign's error.
thanks BRAZIL :D

[gign919191]

It's not fixed :S i don't get it D:

I tried to execute this query, still didn't work.

Select *
from dbo.AccountItem
SET IDENTITY_INSERT AccountItem ON

[wesman2232]

gign delete AccountItem.dbo and execute this :

USE [GunzDB]
GO
/****** Object:  Table [dbo].[AccountItem]    Script Date: 03/21/2009 12:04:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AccountItem](
	[AIID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[ItemID] [int] NOT NULL,
	[RentDate] [datetime] NULL CONSTRAINT [DF__AccountIt__RentD__116A8EFB]  DEFAULT (NULL),
	[RentHourPeriod] [smallint] NULL CONSTRAINT [DF__AccountIt__RentH__125EB334]  DEFAULT (NULL),
	[Cnt] [smallint] NULL CONSTRAINT [DF__AccountItem__Cnt__1352D76D]  DEFAULT (NULL),
	[ShopItemID] [int] NOT NULL,
 CONSTRAINT [Table1_PK] PRIMARY KEY CLUSTERED 
(
	[AIID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AccountItem]  WITH CHECK ADD  CONSTRAINT [Account_Table1_FK1] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO
ALTER TABLE [dbo].[AccountItem] CHECK CONSTRAINT [Account_Table1_FK1]
GO
ALTER TABLE [dbo].[AccountItem]  WITH CHECK ADD  CONSTRAINT [Item_Table1_FK1] FOREIGN KEY([ItemID])
REFERENCES [dbo].[Item] ([ItemID])
GO
ALTER TABLE [dbo].[AccountItem] CHECK CONSTRAINT [Item_Table1_FK1]

[gign919191]

Yay, I fixed it :D i remade the table, since the table wasn't allowing insert values.

[gign919191]

another problem appears... -.-

i buy the item, it appears on my items, but i go to the storage in-game and the item is not there.

iscashitem = "true" on zitem.xml.

Help on how to fix storage?

[BRAZIL-PAULINHO]

Need to Put Central Bank Tables

[gign919191]

can you post the table here?

[BRAZIL-PAULINHO]

Search For Menber Vicio Then Look at his thread

OFF:
Mine is working (storage)

[gign919191]

It gives me an error saying that the somethingAccountItem already exists.

[BRAZIL-PAULINHO]

Here its fixed all =)

[gign919191]

what do u mean, i am saying it is not fixed, I still can't see items in the central bank

[BRAZIL-PAULINHO]

Need To Remade DB
First Execute The Central Bank Fixes
Then Execute The MPOG tables
Then Execute ur DB
Then Edit tHe tables in AccountItem

[gign919191]

Oh, ok I am going to try that now