Do you find the admin side confusing or the user side? Regardless I’m going to make some tutorial videos this weekend. And I dont think the updates touch the pilots pay.
yeah on the admin side. the product, type and shop…
Well, just understand the flow basically follows this..
-A product has a type
-A shop has a type
-No shop can be created without a shop type
-No product can be created without a product type
But as I said a video will be released for both the install, usage and upcoming features of PilotShop by the end of this weekend. Hopefully that will help you out abit roder!
-Jacob Krustchinsky
I helped your karma jacob! LOL
I was just messing with this again and I must say, you made this way to confusing and complicated. I would deff..simplify this…
thats also the only thing i can say aboud it its wat to confusing.
the whol type,shop,product thing i am no coder but is woult be way easyer just to create 1 page where you can enter a type.example electronics,cars,suits
than just enter the part you want example cars:ford mustang,dodge charger,electronics:tv 100cm,tv120 cm,blueray player.something like this.
just my to cents
gr joeri
The purpose of separating the types was to allow for re-usage. By creating a Trophy Store shop type I can have multiple Trophy Stores that have multiple products of varying and maybe even the same type. I will look over how I can simplify it without losing the functionality.
Hi,
i have just installed the pilot shop on my test instance.
I can buy products but when i reload the shop and i cklick on pilothome, its says
No products have been bought!
The amount of the money was descreased foir the pilot who bought an item.
Any idea?
Hello
I have installed the Pilotshop on our Testinstance
Its in the Adminpanel and i can add Shop and Types and Product but when i go in the Main Page and will see the Result i become a Message
“no Shops have been added” but i have created a shop
here is the Link to the Site
Well this was sad!!
So I installed the Pilot shop, was a little confused but managed it ok and setup a few shops.
a new release of phpVMS beta was made available and I always run the beta stuff on my site, just logged in now to work on the shop again, and guess what! It gone 
Does phpVMS offer admin template skins like the site normally does? Or will I have to install the Admin section each time there is an upgrade.
By the way, really cool add on!!! but is it really necessary to be so complicated?
I have not gave this a try yet. I was wondering if it was going to be overwritten with updates and such is why I waited. I think it is really a great addon and am itching to give it a test try. Is it as simple as the link to it was overwritten maybe? Surely it don’t get installed by editing phpVMS core files does it?
hi jacob been trying to get hold of you i know you are busy with this pilotshop but please contact me
cheers
1 Like
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 21
STR: =================================================
SQL: The pilotshop table
=================================================
CREATE TABLE phpvms_pilotshop (
id INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
pid INT( 15 ) NULL ,
name VARCHAR( 100 ) NULL ,
shop_type INT( 15 ) NULL ,
product_type INT( 15 ) NULL ,
image_link TEXT NULL ,
description TEXT NULL ,
price FLOAT NULL )
The pilotshop_types table
=================================================
CREATE TABLE phpvms_pilotshop_types (
id INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
type INT( 1 ) NULL ,
name VARCHAR( 100 ) NULL ,
description TEXT NULL )
The pilotshop_bought table
=================================================
CREATE TABLE phpvms_pilotshop_bought (
id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
pilot_id INT( 11 ) NULL ,
product_id INT( 11 ) NULL )
SQL query:
The pilotshop table ================================================= CREATE TABLE phpvms_pilotshop ( id INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , pid INT( 15 ) NULL , name VARCHAR( 100 ) NULL , shop_type INT( 15 ) NULL , product_type INT( 15 ) NULL , image_link TEXT NULL , description TEXT NULL , price FLOAT NULL ) The pilotshop_types table ================================================= CREATE TABLE phpvms_pilotshop_types ( id INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , type INT( 1 ) NULL , name VARCHAR( 100 ) NULL , description TEXT NULL ) The pilotshop_bought table ================================================= CREATE TABLE phpvms_pilotshop_bought ( id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , pilot_id INT( 11 ) NULL , product_id INT( 11 ) NULL )
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'The pilotshop table
=================================================
CREATE TA’ at line 1
Any ideas anyone?
They’re missing engine types:
CREATE TABLE `phpvms_pilotshop_bought` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pilot_id` INT( 11 ) NULL ,
`product_id` INT( 11 ) NULL
) ENGINE = MYISAM;
CREATE TABLE `phpvms_pilotshop_types` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`type` INT( 1 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`description` TEXT NULL
) ENGINE = MYISAM;
CREATE TABLE `phpvms_pilotshop` (
`id` INT( 15 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`pid` INT( 15 ) NULL ,
`name` VARCHAR( 100 ) NULL ,
`shop_type` INT( 15 ) NULL ,
`product_type` INT( 15 ) NULL ,
`image_link` TEXT NULL ,
`description` TEXT NULL ,
`price` FLOAT NULL
) ENGINE = MYISAM;
Also, it seems like you were copying the installation text in also. Just copy the code above and try it
Hey
I´ve got a feature request: - Is it possible to add something to the pilot center or to a special page where you can see what a pilot already bought?
Its already done man Just go to PilotHome in the PilotShop and there it is !
dam…you´re right:-) but thanks anyway *hehe*
i keep getting this error when clicking on the shopadmin overview
Warning: Invalid argument supplied for foreach() in /home/atlasvi1/public_html/admin/templates/ShopAdmin/shops_overview.tpl on line 36
heres the offending line?
foreach($allshoptypes as $shoptype) {
and the same in page_pilothome.tpl
foreach ( $products as $product) { ?>
any clues
Could someone have a look at this as at the moment i cannot see what i have purchased?
I think Kritek has abandoned the project, I have not seen him around in some time.