Can't add items to website shop!!!

[daniel131605]

i can't add donator items to the item shop on my website can someone help please? im using the b2o website and when i put all the correct info in it says added correctly but under it it has a bunch of errors

[MentaL]

[Ronny786]

Some columns are missing in your Database table...

I think u formatted ur dbo.item columns.

Read errors carefully :

Invalid Column name CSSID : It means your table doesnt contain 'CSSID' column.

Solution:

Go to GunzDB> Right Click 'dbo.item' table > press 'Modify' > and then add missing columns(at bottom of columns).

Do this to all missing columns . " Name, Description,ResLevel, etc etc "

Good Luck!

[daniel131605]

Some columns are missing in your Database table...

I think u formatted ur dbo.item columns.

Read errors carefully :

Invalid Column name CSSID : It means your table doesnt contain 'CSSID' column.

Solution:

Go to GunzDB> Right Click 'dbo.item' table > press 'Modify' > and then add missing columns(at bottom of columns).

Do this to all missing columns . " Name, Description,ResLevel, etc etc "

Good Luck!

thanks! when i add them what thing do i set them as? tinynt or whatever?

[Ronny786]

Did my post helped? :P

[BG-Nero]

thanks! when i add them what thing do i set them as? tinynt or whatever?

Reslevel , Damage , Delay the important things of the weapon

[daniel131605]

i fixed it by myself lol i figured it out, but i have another question

            }
            mssql_query("INSERT INTO AccountItem ([ShopItemID], [AID], [ItemID], [RentDate], [RentHourPeriod], 

[Cnt],[Quantity])VALUES('$itemid', '$aid', '$itemid', GETDATE(), 168, 0,1)");
            mssql_query("UPDATE CashShop SET Selled = Selled + 1 WHERE CSID = $itemid");
            mssql_query("UPDATE Login SET euCoins = '$updatecoins' WHERE AID = '$aid'");
            msgbox("Item purchased correctly, you will be introduced in Storage","index.php?

do=itemshop&sub=listallitems&expand=1&type=3");
       }
       ?>

what is in red is what i need, i need a code to put the right item id into that spot, it keeps putting 0 in it and not the right item id so when you go to dbo.accountitem the item id is 0 and i need it to be 20010 (the donation item) im not sure what code to put there to make it find the right number that i need, so i buy the item from the donation shop, and it puts the info into the database, but it says that there is no name for the weapon unless i go into the database and go to dbo.accountitem and change the id from 0 to 20010, so i need a $ code do put there to find the right itemID for this item and not just put 0, thanks

[Vusion]

What's the value of $itemid? Try searching for something such as "$itemid ="
Posted via Mobile Device

[iDelta]

Didn't you have to execute some SQL's to your database?

[daniel131605]

What's the value of $itemid? Try searching for something such as "$itemid ="
Posted via Mobile Device

if(!function_exists("ShowItemsDetails")){
function ShowItemsDetails(){
if($_GET['id'] == ""){
re_dir("index.php");
}
$itemid = antisql($_GET['id']);
$res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'");
$item = mssql_fetch_assoc($res);
if($item['ForSale'] > 0){
msgbox("You cant buy this","index.php?do=itemshop&sub=listallitems&expand=1&type=3");
die("You cant buy this");
}



//And another one.
$res2 = mssql_query("SELECT euCoins FROM Login WHERE AID = '" . antisql($_SESSION['AID']) . "'");
$acc = mssql_fetch_assoc($res2);
if(isset($_POST['submit'])){
$itemid = antisql($_POST['ItemID']);
$res = mssql_query("SELECT * FROM CashShop WHERE CSID = '$itemid'");
$item = mssql_fetch_assoc($res);
if($item['ForSale'] > 0){
msgbox("You cant buy this","index.php?do=itemshop&sub=listallitems&expand=1&type=3");
die("You cant buy this");
}


those are the 2 i have in there dealing with that, but im pretty sure i looked at that stuff before looking to make it look for the itemid that i put in when i create the weapon with the Add Item to Shop button

Didn't you have to execute some SQL's to your database?

yeah i already did that when i first started working on the site, and the sql i used didn't work all the way so ive been editing the stuff where i get erros...

if(!function_exists("ShowItemsDetails")){
function ShowItemsDetails(){
if($_GET['id'] == ""){
re_dir("index.php");
}
$itemid1 = antisql($_GET['id']);
$res = mssql_query("SELECT * FROM CashShop WHERE CSSID = '$itemid1'");
$item1 = mssql_fetch_assoc($res);
if($item['ForSale'] > 0){
msgbox("You cant buy this","index.php?do=itemshop&sub=listallitems&expand=1&type=3");
die("You cant buy this");
}


will this work? add this to my php script then changed the 2 $itemid to having 1 $itemid and the other one that keeps messing up to be $itemid1 (because its looking for CSSID which should be the correct number )

[Drkidvictor]

What web are you using? Seems like it has Errors o.o

[daniel131605]

well yeah... it wasn't finished all the way, its b2o and i tried what i said at the end and it didn't work