adding new tables: WSN Support

adding new tables
what whoud be the best way?

Version: WSN Forum 1.00 Beta 3

adding new tables

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 12/30/04 - 06:10 AM:	#1
I was adding new fields in the links table and it was pretty need to have their variables available to you right there without any manual changes. But than realized that I need a brand new table other way I won't be able to do what I actually need. I know that just by adding new table I won't be able to pull anything out of it - need to write some code first, but which file(s) should be used? Basically I just neet to pull out data from the table as is - nothing fancy, but I want to be able to use variables in the templates. Would be need to have it like an additional module that could be turned on/off in switches and you good to go. What's the easiest way on adding tables and working within WSNLinks theme?
Real Estate Business Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 12/30/04 - 08:47 AM:	#2
A new table would be an entirely new type of data and purpose not related to WSN Links and therefore you basically have to rewrite the script to match your purpose.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 02/22/05 - 09:43 AM:	#3
I desided to bump this topic up again since I think it might be related to the purpose of the directory at least from what I thik.. Anyways, here is what I was thinking - I would like to add fields like company name, address, contact information and everything that goes with it - basically extend merber's listing to make it more search effective. I though by adding more fields to the links table it will slow down things,and adding another table would make it easier. I don't khow this fur sure, just a guess. So, this is related to the directory purpose I think... what do you say? Thank you.
Real Estate Business Directory

mrowton
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2004
Location: Michigan
Total Topics: 59
Total Posts: 189

Last Blog:

Posted 02/22/05 - 03:02 PM:	#4
I don't think adding a bunch of custom fields will slow it down. I have a bunch of WSN Links sites, none of which is used for links. Each has a LOT of custom fields. Works great. WSN Links is the best Article Management, News CMS, BLOG, Personals, and classifieds script there is. There are so many features that it works for just about anything you can think of, and everything is customizable to fit. Add away without touching the PHP, you'll be fine.
http://www.packetsource.com/ Directory of Security Papers

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 02/22/05 - 04:19 PM:	#5
Tables are much slower to query than fields. Guides to mysql optimization commonly mention that it's good practice to try to merge tables where possible. I tried a cross-table query not long ago and found it hopelessly slow on a large database, so that it basically killed the site... I had to add the field I needed back into the original table so that the selection would only come out of one talbe.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 02/23/05 - 09:52 AM:	#6
Okay. Thanks for making it clear to me I love WSNLinks just trying to find ways to work it for all my needs, so far its the Greatest! I still want to find out how to get that mod_gzip working properly to speed it up. Thanks a lot!
Real Estate Business Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 02/24/05 - 08:55 PM:	#7
If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 03/09/05 - 11:31 AM:	#8
Paul wrote: If your apache is running mod_gzip, then you don't need to do anything -- leave the WSN gzip setting off, as it would simply interfere with apache's version That's the problem - my apache is not running mod_gzip. Edited by gemini on 03/09/05 - 11:33 AM
Real Estate Business Directory

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 03/09/05 - 09:47 PM:	#9
Well, did you check if you have the settings mentioned in the manual entry as causing it to fail?
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 03/10/05 - 06:26 AM:	#10
well, I'm getting a little confused, but here is what I have in my php.ini: ------------------------------------- Directive Local Value Master Value output_buffering no value no value output_handler ob_gzhandler no value ------------------------------------- ZLib Support enabled Compiled Version 1.1.4 Linked Version 1.1.4 ------------------------------------- Directive Local Value Master Value zlib.output_compression Off Off zlib.output_compression_level -1 -1 zlib.output_handler no value no value ------------------------------------- My host told me to add the following line to the .htaccess CODE: php_value output_handler ob_gzhandler it actually helped - I didn't have the blank page anymore, but some options just stoped working (as I mentioned before).
Real Estate Business Directory

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 03/10/05 - 06:59 AM:	#11
hmm.. I just checked my site with http://www.desilva.biz/gzip-test.php and it says it is compressed...
Real Estate Business Directory

gemini
Forum Regular

Usergroup: Customer
Joined: Oct 30, 2003
Total Topics: 54
Total Posts: 200

Posted 03/10/05 - 07:07 AM:	#12
Okay, I took that line out from .htaccess and the tool said that my pages are not gziped - I put it back it and it said I save 79%. I believe that resolves the problem. I need less havier graphics. Thank you Paul!
Real Estate Business Directory

You don't have permission to post.