[Help] adding pages

Page 1 of 2 1 2
01/12/2010 04:41 Knight^Hawk#1
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.
01/12/2010 14:29 rexes13#2
Quote:
Originally Posted by Knight^Hawk View Post
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...
01/12/2010 23:28 Knight^Hawk#3
ive added items and they dont even appear in the mall. ive put em in the cq goods also
01/13/2010 00:36 hio77#4
Quote:
Originally Posted by Knight^Hawk View Post
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?
01/13/2010 00:46 Knight^Hawk#5
1207 lol
01/13/2010 01:06 hio77#6
Quote:
Originally Posted by Knight^Hawk View Post
1207 lol
well that should work .... you missed saying how you edit it .... hex, funhackers tool etc
01/13/2010 03:16 Knight^Hawk#7
funhackers tool ofc... cept i cant edit the fields so i gotta hex edit those which i usaully dont
01/13/2010 04:02 hio77#8
Quote:
Originally Posted by Knight^Hawk View Post
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!
01/13/2010 04:08 Knight^Hawk#9
yes....

is there a query where u dont need to hunt for an unique id?
01/13/2010 04:15 Eurion#10
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');
01/13/2010 04:21 Knight^Hawk#11
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
01/13/2010 04:33 Knight^Hawk#12
Quote:
Originally Posted by Eurion View Post
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
01/13/2010 05:06 hio77#13
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 View Post
that query makes the id 0 and cant be used again lol
that line should make the id go automatically ...
01/13/2010 05:30 Eurion#14
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.
01/13/2010 07:38 Knight^Hawk#15
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
Page 1 of 2 1 2