Item for days

Hello EveryOne!!!

I"am sorry but you Help Me plz

in zitem I get to
rent_period="7"/>

in MicroSoft Sql Server 2005
dbo.cashshop I Give data it

http://img600.imageshack.us/f/19286913.jpg/

after @_@ I am
Use ijji Full site in Ragezone change in ijji_itemshop on folder Gunz

I am Change
before
mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 0)");

After
mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 48)");

with like . . . . . . . . from somewhere.

but but it doesn't work
is not show days

http://img13.imageshack.us/img13/5794/dwwd.jpg

what i do something wrong ? or i forgot to do something ? who's know please help me.

I Use Gunz CLient Server 2008 Part3

Help Me plz !!!

Problem: That code is only used to send permanment items only cause the column RentHourPeriod is missing

Info: Might have to change this code abit to your document forms

Code:

---

mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 48)");

---

should be

Code:

---

mssql_query_logged("INSERT INTO AccountItem ([AID],[ItemID],[RentDate],[RentHourPeriod],[cnt]) VALUES ('".$_SESSION['AID']."','".$itemid."','".date('Y-m-d H:i:s')."','".$Rentperiod."',1)");

---

or go through your zitem.xml and change iscashitem from true to false.

Quote:

---

Originally Posted by xTruongx

Problem: That code is only used to send permanment items only cause the column RentHourPeriod is missing

Info: Might have to change this code abit to your document forms

Code:

---

mssql_query_logged("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [Cnt])VALUES('$itemid', '$UserAID', '$zitemid', GETDATE(), 48)");

---

should be

Code:

---

mssql_query_logged("INSERT INTO AccountItem ([AID],[ItemID],[RentDate],[RentHourPeriod],[cnt]) VALUES ('".$_SESSION['AID']."','".$itemid."','".date('Y-m-d H:i:s')."','".$Rentperiod."',1)");

---

---

Thank You !!

But :O: This Error
I change to test
mssql_query_logged("INSERT INTO AccountItem ([AID],[ItemID],[RentDate],[RentHourPeriod],[cnt]) VALUES ('".$_SESSION['AID']."','".$itemid."','".date('Y-m-d H:i:s')."','".$Rentperiod."',1)");

change $Rentperiod."',1-1000)");

error !!

http://img411.imageshack.us/img411/7953/21975243.jpg


Where am I to Change it ???

Code:

---

mssql_query_logged("INSERT INTO AccountItem ([AID], [ItemID], [RentDate], [Cnt], [RentHourPeriod])VALUES('$UserAID', '$itemid', GETDATE(), 0, 48)");

---

Should be the query in your item shop script. Make sure that your website uses the variable "$UserAID".

Thank All
It"S work Thank For Answer