Misc. questions

[skeedo]

How can I increase my order numbers? Currently my order numbers are less than 100, I would like to cheat and jack them up to atleast 10000+ so it looks like I've already had that many orders.

 

How can I cheat and jack up the number of requests on the front page?

 

Images uploaded for categories and products have some weird permission, and I am not able to access them for backing up or deleting. How can I change permissions so I can access them?

 

Has anyone yet made a mod to allow additional comments to be added in order status emails?

 

Anyone seen any cool looking OSC images I can steal (shopping cart, my account, etc.) ?

 

Thanks.

[wizardsandwars]

Your first 2 questions can be handled by some SQL. You do have phpmyadmin? If so, it will make this alot easier.

 

To change permissions on a file or directory, youwill need either an FTP agent (I use smart FTP, it's free), or telnet access. To change via FTP agent, just right click>> chmod >> enable read, write, exectue. To do this via telnet, type chmod 777 /<path>/<file>

 

I've edited this file to include comment, but I will need more time to find where I made the change.

 

Just look for public domain images on google. That's what I did, and found some great ones.

[skeedo]

Yea I have access to phpmyadmin.

[wizardsandwars]

Then you could run a simple query to change the procudt_id of your last order.

 

However, keep in mind that you would need to do this for ALL tables that include product_id.

 

Your query would look like this

 

UPDATE

<put table name here>

SET

product_id = 100000

WHERE

product_id = <your last order number>

 

You would need to do this for the following tables

products

products_attributes

products_attributes_download

products_description

products_notifications

products_options

products_options_values

products_options_values_to_products_options

products_to_categories

 

replacing the <put table name here> with the names of the above table one by one.

 

The other one is easy

 

UPDATE

counter

SET

COUNTER = 100000

 

That's it.

[skeedo]

I don't understand it...everyone says use phpmyadmin to do this then spits out straight SQL! Isn't phpmyadmin sort of a front end gui to mySQL? Can you explain how to update the product tables in GUI (point and click) terms? I managed to figure out the easy one, but I'm not able to locate my last product ID in what I'm editing.

 

Thanks!

[mattice]

I don't understand it...everyone says use phpmyadmin to do this then spits out straight SQL! Isn't phpmyadmin sort of a front end gui to mySQL? Can you explain how to update the product tables in GUI (point and click) terms? I managed to figure out the easy one, but I'm not able to locate my last product ID in what I'm editing.

 

Thanks!

 

SQL is the language used to query databases (most of em anyway).

For mySQL you have several commandline tools to do this but that is not

for everybody since you will need shell access to your server.

So there are many tools to interact with mySQL, phpMyAdmin being a GPL webbased PHP solution.

What it does is it visualizes your database and lets you perform any imaginable action on it.

To do so you will however need to understand some SQL.

 

They do have a query builder but it is quite useless for the tasks you want done.

 

I do not think there will ever be a point-click GUI for SQL tasks that gets any better then the query builder simply because you can not make a programming language 100% 'point-click' ... Like any Visual-Whatever software (Basic, Java C++ etc) you'll always need to know what you're writing.

 

HTH

Mattice

[wizardsandwars]

First of all, I misunderstood. You wish to change your "Order Numbers" not your "Product Numbers". As our Brittish friends would say, "No Worries, mate."

 

Open phpmyadmin. Select your catalog database (if you have more than one MySQL database set up).

 

Click on the "orders" table on the left. Click the "browse" button at the top of the page. Click on the "orders_id" column header to sort by this field. Click it again to sort in descending order. The order at the top is now the last order you've had. Make a note of this number.

 

Click the "SQL" button at the top of the page. Delect the "SELECT * FROM `orders` WHERE 1" and type this:

UPDATE
  orders
SET
  orders_id = 10000
WHERE
  orders_id = <the number you just noted>
[code]
 
You will need to do this for each of these tables
  orders
  orders_products
  orders_products_attributes
  orders_products_download
  orders_status
  orders_status_history
  orders_total
 
I hope this helps.

[Ajeh]

Wait! Stop! Hold on there! :onfire:

 

I would not recommend you do that in orders_status table ... that is just the definitions ... :shock:

 

Otherwise looks like a nice fix.

[wizardsandwars]

Opps. Yer right. Damn copy and paste jobs! :wink:

 

Although, there is not an 'orders_id' in the 'orders_status' table, so it wouldn't have hurt, it would have only returned in invalid colum error.

 

Thanks for keeping me in check, though.

[wizardsandwars]

:lol: :lol: :lol:

 

Just noticed that I got my code tags all screwed up in my post.

 

Just like a DB programmer, huh?

 

:lol: :lol: :lol:

[Ajeh]

Cheat next time ... type what you want in the code tag then highlight and hit Code ... puts them in nice and neat :D

 

'Course that silly preview button isn't half bad :shock:

[wizardsandwars]

Thanks for the tip re: highlighting.

 

Preview? Ad hoc programmers don't have time to preview anything!

 

:lol: :lol: :lol:

[skeedo]

All of this sounds way too risky...can't I just SSH into my database and issue some kind of global command to replace order_id in all tables?

 

How's it coming with that Order status update comment box?

 

 

First of all, I misunderstood. You wish to  

change your "Order Numbers" not your "Product Numbers". As our Brittish friends would say, "No Worries, mate."

 

Open phpmyadmin. Select your catalog database (if you have more than one MySQL database set up).  

 

Click on the "orders" table on the left. Click the "browse" button at the top of the page. Click on the "orders_id" column header to sort by this field. Click it again to sort in descending order. The order at the top is now the last order you've had. Make a note of this number.

 

Click the "SQL" button at the top of the page. Delect the "SELECT * FROM `orders` WHERE 1" and type this:

UPDATE
  orders
SET
  orders_id = 10000
WHERE
  orders_id = <the number you just noted>
[code]
 
You will need to do this for each of these tables
  orders
  orders_products
  orders_products_attributes
  orders_products_download
  orders_status
  orders_status_history
  orders_total
 
I hope this helps.