Item for days

[yougrean]

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



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 !!!

[MentaL]

[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

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

should be

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

[wesman2232]

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

[yougrean]

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

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

should be

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 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 !!




Where am I to Change it ???

[Phoenix]

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".

[yougrean]

Thank All
It"S work Thank For Answer