What do i need to add items in shopsystem?

[olaajnus]

i get this error when i trying to do it.

Fel
SQL-fråga:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` , `level` , `pid` )
VALUES (

NULL , 10, 0, 0, 0, 0, 'redskull', 'Remove Red Skull!', 'Remove Red Skull', 0, 0
), (
NULL , 10, 2160, 50, 0, 0, 'itemlogout', 'Crystal Coin', 'itemlogout', 0, 10
), (
NULL , 2, 0, 0, 0, 0, 'changename', 'Change Name', 'changename', 0, 0
)

MySQL sa:

#1054 - Unknown column 'level' in 'field list'

 

[Diazapam]

That means that the field level doesn't exist in the column z_shop_offer...

 

[olaajnus]

Can yo explain more how i can fix this? Thanks

 

[Diazapam]

Why don't you use shop admin to add items?

 

[olaajnus]

Dosen't work, already tried it..

 

[Cykotitan]

You could either use this query instead:

INSERT INTO `z_shop_offer` ( `id` , `points` , `itemid1` , `count1` , `itemid2` , `count2` , `offer_type` , `offer_description` , `offer_name` , `pid` )
VALUES (

NULL , 10, 0, 0, 0, 0, 'redskull', 'Remove Red Skull!', 'Remove Red Skull', 0),(
NULL , 10, 2160, 50, 0, 0, 'itemlogout', 'Crystal Coin', 'itemlogout', 10), (
NULL , 2, 0, 0, 0, 0, 'changename', 'Change Name', 'changename', 0
)

.. or execute this query first:

ALTER TABLE `z_shop_offer` ADD `level` INT( 11 ) NOT NULL DEFAULT '0';

 

[olaajnus]

Thanks dude, it worked

 

[olaajnus]

But one more problem, The server is on, but on the website it says "Offline" And i don't know why ;o