Problem with shop

I have that . . .

http://walex.fr/upload/lol.JPG

the problem on item_table1_FK1 same my problem and no one want help me PFFFFF !!!!

Do you have put all your items of the shop in dbo.Item?

its about a foreign key in the DB, I never could figure out where or how to fix these xD

fill in the dbo.Item table with the items in the shop, add the item id's

You have to add a small section to the Database, I can't remember what the tables were inside the Database. That's the problem.

Ugh only if i knew>:P

Quote:

---

Originally Posted by forean

Ugh only if i knew>:P

---

Not very helpful you. Your posting in all of em and nothing that makes sence. Quit it.

okay ill help. go to your C:\Appserv\www\Gunz\Mod_itemsho.php and look at line 597 and copy paste the line here so i can see it ._.

Quote:

---

Originally Posted by forean

okay ill help. go to your C:\Appserv\www\Gunz\Mod_itemsho.php and look at line 597 and copy paste the line here so i can see it ._.

---

Code:

---

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

---

I find the problem is that when I add an item to the shop, mark it as CashShop.do, and it does not Item.dbo I had to do so by hand.
How do I make when I add the item in the shop and it is written in item.dbo ? (I think this is the php site files (mod_additem.php or mod_itemshop.php]

Disable dbo.Item's key constraint.

Do you have execute al tables right?

No , do you have all table executable ?