[Help] adding pages

Knight^Hawk · 01/12/2010, 04:41

i need to add pages to my shopping mall, how would i do that? also where would i go to edit the look off the mall. ive searched everywhere.

rexes13 · 01/12/2010, 14:29

Quote:

Originally Posted by Knight^Hawk

i need to add pages to my shopping mall, how would i do that? also where would i go to edit the look off the mall. ive searched everywhere.

This is sth that happens automatically...adding more items to mall will cause the mall to increase the pages of stuff...about the look of the mall u have to go to the folder which includes the .dds files that are responsible for the look of it...i think it is named sth like "stone"...forgive me if i am wrong but i have a lot of time to mess up with it...

Knight^Hawk · 01/12/2010, 23:28

ive added items and they dont even appear in the mall. ive put em in the cq goods also

hio77 · 01/13/2010, 00:36

Quote:

Originally Posted by Knight^Hawk

ive added items and they dont even appear in the mall. ive put em in the cq goods also

what tool do you use to do it .... it is all automatically

also what shop id are you putting it under?

Knight^Hawk · 01/13/2010, 00:46

1207 lol

hio77 · 01/13/2010, 01:06

Quote:

Originally Posted by Knight^Hawk

1207 lol

well that should work .... you missed saying how you edit it .... hex, funhackers tool etc

Knight^Hawk · 01/13/2010, 03:16

funhackers tool ofc... cept i cant edit the fields so i gotta hex edit those which i usaully dont

hio77 · 01/13/2010, 04:02

Quote:

Originally Posted by Knight^Hawk

funhackers tool ofc... cept i cant edit the fields so i gotta hex edit those which i usaully dont

are you saving it correctly lol!

Knight^Hawk · 01/13/2010, 04:08

yes....

is there a query where u dont need to hunt for an unique id?

Eurion · 01/13/2010, 04:15

The cq_goods id is an auto incrementing id. So you can use the following query and it should work.

Code:

INSERT INTO cq_goods (ownerid, itemtype) VALUES ('ShopIdExample1207', 'ItemtypeId');

Knight^Hawk · 01/13/2010, 04:21

i get an error when i add that

Code:

mysql> INSERT INTO cq_goods VALUES ('', '1207', '1234567');
1136 - Column count doesn't match value count at row 1

Knight^Hawk · 01/13/2010, 04:33

Quote:
Originally Posted by Eurion
The cq_goods id is an auto incrementing id. So you can use the following query and it should work.
Code:
INSERT INTO cq_goods (ownerid, itemtype) VALUES ('ShopIdExample1207', 'ItemtypeId');

that query makes the id 0 and cant be used again lol

hio77 · 01/13/2010, 05:06

ok lets get things straight .... you are trying to add items to the client side shop ... i could add 456465464645645654 lvl 3x gear and not add a single line to mysql ... basicly shop.dat is all that controls whats in your shop...

EDIT:

Quote:

Originally Posted by Knight^Hawk

that query makes the id 0 and cant be used again lol

that line should make the id go automatically ...

Eurion · 01/13/2010, 05:30

If my edited version of your query failed, then

A. Someones been messing with your tables and doesn't know what the hell their doing.

B. You failed to enter it correctly. Every database is basically the same in design.

**Edit**

After getting more info on the issue run this query.

Code:

INSERT INTO cq_goods ('UniqueID', 'OwnerId', 'ItemType', 'ItemName');

After your server has a maint you will beable to use the following code.

Code:

INSERT INTO cq_goods (ownerid, itemtype,name) VALUES ('ShopId', 'ItemType', 'ItemName');

As I said once your server has a maint to make sure the changes have taken effect the cq_goods table will auto increment as it should.

Knight^Hawk · 01/13/2010, 07:38

all the queries aside, ive put in items in the shop.dat and items that were there be for have disapeered. my last patch i added the dragon mounts as well as the tranquil and elvendance.. the romans, xmas suits, and pink romances disapeered. also added a 5th summon stone and thats only in the recomendation section and not in the actual list LOL