Register for your free account! | Forgot your password?

You last visited: Today at 15:17

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help] adding pages

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
[Help] adding pages

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.



Knight^Hawk is offline  
Old   #2
 
elite*gold: 20
Join Date: Nov 2008
Posts: 1,408
Received Thanks: 400
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...


rexes13 is offline  
Old   #3
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
ive added items and they dont even appear in the mall. ive put em in the cq goods also
Knight^Hawk is offline  
Old   #4
 
elite*gold: 20
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 814
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?


hio77 is offline  
Old   #5
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
1207 lol
Knight^Hawk is offline  
Old   #6
 
elite*gold: 20
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 814
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
hio77 is offline  
Old   #7
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
funhackers tool ofc... cept i cant edit the fields so i gotta hex edit those which i usaully dont
Knight^Hawk is offline  
Old   #8
 
elite*gold: 20
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 814
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!
hio77 is offline  
Old   #9
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
yes....

is there a query where u dont need to hunt for an unique id?
Knight^Hawk is offline  
Old   #10
 
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 923
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');
Eurion is offline  
Old   #11
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
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 is offline  
Old   #12
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
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
Knight^Hawk is offline  
Old   #13
 
elite*gold: 20
Join Date: Jun 2006
Posts: 1,759
Received Thanks: 814
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 ...
hio77 is offline  
Old   #14
 
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 923
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.
Eurion is offline  
Old   #15
 
elite*gold: 0
Join Date: Dec 2009
Posts: 370
Received Thanks: 135
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


Knight^Hawk is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
get better reg pages
i luv eating vegemite
3 Replies - SRO PServer - Discussions / Questions
Bag Pages
Is there a way to make more space in your bag. Ex- instead of only holding 12 demons you can make it hold 16 or whatever number you want.
0 Replies - EO PServer Hosting
[Help] adding pages to the eudemon wharehouses
i wanna know how to add pages to the eud whs. my guess would be something in the cq_npc, but idk....
1 Replies - EO PServer Hosting
IPs,Pages
can some1 let me kno more pages for ips...other than this one Anonymous proxy test,socks5 list,anonymous proxy,Free proxy for game,- IP free of china...
2 Replies - SRO PServer - Discussions / Questions



All times are GMT +1. The time now is 15:17.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.