[Help] Cash Shop [Nolife_x] Don't work =S

[darkness95]

When I buy an item,I subtracted Coins RZ says successful purchase,
But it does not add the item to the trunk.. Review and I think something goes wrong here:

mod_rzitemshop.php

            mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$aid', '$zitemid', GETDATE(), 0)");
            mssql_query_logged("UPDATE Login SET RZCoins = '$updatecoins' WHERE AID = '$aid'");
            msgbox("Item comprado exitosamente, reviza tu Baul.","index.php?do=rzitemshop&sub=listallitems&expand=1&type=1"); 

MSSQL:


Where are "[ShopItemID]" it's for that?..

Sorry becase im noob.. and i cant speak english like a normal person xD...

u.u Help me guys!

[MentaL]

[pavan33]

it should..
1.make sure the item u have added in shop is present in item.dbo
2.execute the queries correctly....

[darkness95]

Yes, is added in the item.dbo =S..

[cheaterastic]

Me, Even I add Item properties in dbo.Item
When I buy in my RZ/EV Item Shop, after I buy item, the item will not be send in dbo.AccountItem

---------- Post added at 01:38 PM ---------- Previous post was at 01:33 PM ----------

We have same problem darkness95, I also understand that line - the "[ShopItemID]" and I keep editing EV ITEM SHOP and RZ ITEM SHOP, but still, I can't solve it...

Someone can help us?