And you can see that it looks very nice but it does not have features, as
1. Link sponsorship. Integrate with PayPal or 2checkout to allow link owners to purchase priority positioning in their category. Optionally switch this to deducting per unique click instead of per day (a simple PPC option). Use multiple levels of sponsorship if desired.
2. Member sponsorship. Allow members to pay for promotion to a more privileged usergroup, or require paid membership.
Now what I want to do is make a site, where you can find advertisments with links, and if I understand this feature list correctly, you can make usergroup for people who are allowed to have a bit bigger Link, for example
Free: Plain text 100 Chars
Paid: Images / 250 Chars
Also can i make it look like MosSets tree, is the template system easy configurable?
Also is the php source readable and editable? Is it not encrypted with Zend for example.
Woops almost forgot we intend to inegrate it with PHPAuction which will be modified, but how is the database structure for the categories set up, since we intend to use the same categories as PHP Auction which currently looks like:
you can make usergroup for people who are allowed to have a bit bigger Link
Usergroup and link sponsorship are separate, so that's not how it works. People sponsor indivdual links to get them promoted to a new link type, for which you could choose to show more or less text.
Promoting people to a new usergroup is member sponsorship. 3.20 will have an option to auto-promote all links by a sponsoring member, but that's not currently available (except as an experimental beta).
Also can i make it look like MosSets tree, is the template system easy configurable?
It can look like anything in theory, I couldn't give you a useful answer on how easy it is since naturally it's easy for me.
Also is the php source readable and editable? Is it not encrypted with Zend for example.
The Basic Edition source is obscurified, you're not supposed to edit it (though it's not encrypted). The paid version source is easily editable.
Would it be easy to make use of this table
If there's an exceptionally large number of categories, you can always use phpmyadmin to make a copy and then change all the field names to the WSN equivilants, export data without extructure (and without extended/complete inserts) and then import.
Is this script ment for large amounts of categories, I have imported +-3000 categories, but now everytime the script stops because the maximum execution time is reached... 30 seconds.
But it does not workit still says 56 categories, and it takes incredibly long to show them..
Are there any other fields required for the subcategory's
In the admin it says i have the sub cats however:
The directory was last updated March , 2005. Links: with outgoing clicks and incoming Categories: 56 (2886 counting subcategories) Comments: Members: 1
pixelsoul wrote: Is this script ment for large amounts of categories, I have imported +-3000 categories, but now everytime the script stops because the maximum execution time is reached... 30 seconds.
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
If i read that link it should be fixed in the new version: WSN Links 3.15, anywho ill try to make the changes anyway, and see if i can get the support account for this forum since i am not the one who purchased this script, just making the changes.
/Edit
Ok i can post there now, so you move it since its not the basic edition, but the paid one am trying out the experimental version now.
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
Ok i have done what it says with this pages but it does not seem to mattr only thing that is missing the description is: Note: For the level limit to take effect, you'll need to regenerate the sitemap (admin panel->misc->regenerate) or wait until an item is added or edited.
It simply does not exists in the admin there is a generate html in miscellanous, but it seems to generate some html pages
Also the changing these settings is slooooooooooooooooooooooooooooowwwwwww... I dont think it should be this slow, since in the admin ther is not a list of the entire categories ?
The sub categories are working however.. its just that it has become so slow the whenever the script is called the cpu flies to 100%
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
Here is the sql (good thing there is a build in debugger ):
It looks to me ;ike here the sh*t hits the fan..
"Performing query: SELECT id FROM wsnl_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2886 for Resource id #17 "
Its selecting all categories :|
here are all the queries..
This page was created in 15.516088008881 seconds
Performing query: SELECT id FROM wsnl_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Performing query: SELECT name,value FROM wsnl_switches WHERE id>0 ;
Number of rows is 23 for Resource id #14
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnl_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #15
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnl_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #16
Performing query: SELECT id FROM wsnl_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2886 for Resource id #17
Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnl_membergroups WHERE id>0 ;
Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned FROM wsnl_members WHERE id=1 AND validated=1 ;
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnl_categories WHERE id=1 ;
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnl_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #23
Performing query: UNLOCK TABLES;
Performing query: UPDATE wsnl_members SET lastvisit=1117195158 WHERE id=1;
Performing query: UPDATE wsnl_categories SET views='8' WHERE id=1;
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnl_categories WHERE alias=1 ;
Number of rows is 0 for Resource id #24
Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnl_categories WHERE parent=1 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,300;
Number of rows is 36 for Resource id #26
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #27
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND validated=1 AND hide=0 AND type='regular' ;
Number of rows is 0 for Resource id #28
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND validated=1 AND hide=0 AND type='recip' ;
Number of rows is 0 for Resource id #29
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #30
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #31
Performing query: SELECT id FROM wsnl_links WHERE catid=1 AND validated=0 ;
Number of rows is 0 for Resource id #32
Performing query: SELECT id FROM wsnl_comments WHERE catid=1 AND validated=0 ;
Number of rows is 0 for Resource id #33
Performing query: UPDATE wsnl_sessions SET starttime='0' WHERE time < 15;
Performing query: UPDATE wsnl_sessions SET time='0' WHERE time < 15;
Performing query: SELECT starttime FROM wsnl_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #34
Performing query: UPDATE wsnl_sessions SET time='1117195165', location='http://icta-dev/links/index.php?action=displaycat&catid=1', catid='1', threadid='', areaname='Antiek en kunst' WHERE memberid=1;
Performing query: SELECT COUNT(*) FROM wsnl_sessions WHERE 1=1 AND (catid=1 AND memberid>0) ;
Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnl_sessions WHERE 1=1 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100;
Number of rows is 1 for Resource id #36 closing database connection
Yes I know but i have set that an regenerated all counters.. btw perhaps change that in the faq 'Note: For the level limit to take effect, you'll need to regenerate the sitemap (admin panel->misc->regenerate) or wait until an item is added or edited.'
But it still behaves that way there was one setting that could not be set, because it kept on loading.. cant acces it now will look on it tuesday, but even the admin is superslow, while no categories are showed there, on the frontend also not anymore so it seems strange to me that even the admin is really slow
Although the main categories query only executes when the total categories are less than 100 or the 'show subcategories on main page' switch is on, it seems there's another query there which determines how many total categories there are (so that it can be used in that later comparison) which could be slow. I've uploaded a new basic edition version (3.16B), try that. If nothing else, it'll show the execution time at each step (that bit of enhanced debugging was added in 3.14) to show where the problem is.
Hmm im testing the new version but the regenerate counter page now wont load at all, in the new version?
Edit* Nevermind its the gzip compression which is buggy, when turned on you cant view any of the pages.
Paul wrote: Although the main categories query only executes when the total categories are less than 100 or the 'show subcategories on main page' switch is on, it seems there's another query there which determines how many total categories there are (so that it can be used in that later comparison) which could be slow. I've uploaded a new basic edition version (3.16B), try that. If nothing else, it'll show the execution time at each step (that bit of enhanced debugging was added in 3.14) to show where the problem is.
Ok I have set all the settings, with the new version and only 29 categories imported otherwise it crashes my pc
But where does it get the result for this query i think this is also is causing problems:
Load time so far: 0.68 seconds. Performing query: UPDATE wsnlinks_settings SET content='547' WHERE name='totalsubcats';
, and yes i have set the settings as described, and it does not generate a list of all categories, or subcategories
And it is still very very slow, what kind of shocked me that it even in the admin it performs all kinds of unnecessary queries:
Load time so far: 0.41 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Load time so far: 0.48 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.49 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #33
Load time so far: 0.5 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #34
Load time so far: 0.5 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;
Load time so far: 0.52 seconds. Performing query: UPDATE wsnlinks_settings SET content='29' WHERE name='totalsubcats';
Load time so far: 0.53 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.54 seconds. Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.59 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 29 for Resource id #41
Load time so far: 0.63 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.63 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #42
Load time so far: 0.63 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.65 seconds. Performing query: UPDATE wsnlinks_categories SET views='7' WHERE id=1;
Load time so far: 0.65 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnlinks_categories WHERE alias=1 ;
Number of rows is 0 for Resource id #44
Load time so far: 0.66 seconds. Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,100;
Number of rows is 28 for Resource id #46
Load time so far: 1.18 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #47
Load time so far: 1.18 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND type='regular' ;
Number of rows is 0 for Resource id #48
Load time so far: 1.19 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND validated=1 AND hide=0 AND type='recip' ;
Number of rows is 0 for Resource id #49
Load time so far: 1.19 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #50
Load time so far: 1.2 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND hide=0 AND validated=1 ;
Number of rows is 0 for Resource id #51
Load time so far: 1.2 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=1 AND validated=0 ;
Number of rows is 0 for Resource id #52
Load time so far: 1.21 seconds. Performing query: SELECT id FROM wsnlinks_comments WHERE catid=1 AND validated=0 ;
Number of rows is 0 for Resource id #53
Load time so far: 1.27 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1117524673;
Load time so far: 1.28 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 15;
Load time so far: 1.29 seconds. Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 15;
Load time so far: 1.29 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE memberid=1 ;
Number of rows is 1 for Resource id #55
Load time so far: 1.29 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1117525573', location='http://localhost/wsnlinks3/index.php?action=displaycat&catid=1', catid='1', threadid='', areaname='Antiek en kunst' WHERE memberid=1;
Load time so far: 1.9 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_sessions WHERE 1=1 AND (catid=1 AND memberid>0) ;
Load time so far: 1.9 seconds. Performing query: SELECT id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname FROM wsnlinks_sessions WHERE 1=1 AND (catid=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100;
And in the admin:
Load time so far: 0.56 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Load time so far: 0.63 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.67 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 4 for Resource id #33
Load time so far: 0.67 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 14 for Resource id #34
Load time so far: 0.67 seconds. Performing query: SELECT COUNT(*) FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;
Load time so far: 0.68 seconds. Performing query: UPDATE wsnlinks_settings SET content='29' WHERE name='totalsubcats';
Load time so far: 0.69 seconds. Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem FROM wsnlinks_membergroups WHERE id>0 ;
Load time so far: 0.7 seconds. Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned FROM wsnlinks_members WHERE id=1 AND validated=1 ;
Load time so far: 0.91 seconds. Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;
Number of rows is 251 for Resource id #44
Load time so far: 1.06 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND parent=0 AND hide=0 ;
Number of rows is 1 for Resource id #51
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Few Questions about WSN Links
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
I have won a version of MoSetsTree: http://demo.mosets.com/tree/
And you can see that it looks very nice but it does not have features, as
1. Link sponsorship. Integrate with PayPal or 2checkout to allow link owners to purchase priority positioning in their category. Optionally switch this to deducting per unique click instead of per day (a simple PPC option). Use multiple levels of sponsorship if desired.
2. Member sponsorship. Allow members to pay for promotion to a more privileged usergroup, or require paid membership.
Now what I want to do is make a site, where you can find advertisments with links, and if I understand this feature list correctly, you can make usergroup for people who are allowed to have a bit bigger Link, for example
Free: Plain text 100 Chars
Paid: Images / 250 Chars
Also can i make it look like MosSets tree, is the template system easy configurable?
Also is the php source readable and editable? Is it not encrypted with Zend for example.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Table:PHPAUCTION_categories_plain
Columns:
|cat_id|parent_id|cat_name|deleted|sub_counter|
Would it be easy to make use of this table, or is their a batch function to import the categories at once?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
you can make usergroup for people who are allowed to have a bit bigger Link
Usergroup and link sponsorship are separate, so that's not how it works. People sponsor indivdual links to get them promoted to a new link type, for which you could choose to show more or less text.
Promoting people to a new usergroup is member sponsorship. 3.20 will have an option to auto-promote all links by a sponsoring member, but that's not currently available (except as an experimental beta).
Also can i make it look like MosSets tree, is the template system easy configurable?
It can look like anything in theory, I couldn't give you a useful answer on how easy it is since naturally it's easy for me.
Also is the php source readable and editable? Is it not encrypted with Zend for example.
The Basic Edition source is obscurified, you're not supposed to edit it (though it's not encrypted). The paid version source is easily editable.
Would it be easy to make use of this table
If there's an exceptionally large number of categories, you can always use phpmyadmin to make a copy and then change all the field names to the WSN equivilants, export data without extructure (and without extended/complete inserts) and then import.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
parentnames
parentids
permissions
Are these required, and what are the first 2 columns are being used for?
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Ok I wrote a small conversion scripts which also adds the data like:
[parentnames][parentids|]
[, Parent, ][1]
[, Parent, ][1]
[, Parent, ][1]
etc...
But it does not work
Are there any other fields required for the subcategory's
In the admin it says i have the sub cats however:
The directory was last updated March , 2005.
Links: with outgoing clicks and incoming
Categories: 56 (2886 counting subcategories)
Comments:
Members: 1
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
This means you haven't read/obeyed scripts.webmastersite.net/w...nks/wsnmanual/articles/189
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Yes I have validated them and named them, the ones i wrote the script for where the columns that did not exists in the other script so I have now:
id|name|parent|validated|parentnames|parentids|type|regular
If i read that link it should be fixed in the new version: WSN Links 3.15, anywho ill try to make the changes anyway, and see if i can get the support account for this forum since i am not the one who purchased this script, just making the changes.
/Edit
Ok i can post there now, so you move it since its not the basic edition, but the paid one am trying out the experimental version now.
This means you haven't read/obeyed scripts.webmastersite.net/w...nks/wsnmanual/articles/189
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
It simply does not exists in the admin there is a generate html in miscellanous, but it seems to generate some html pages
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Also the changing these settings is slooooooooooooooooooooooooooooowwwwwww... I dont think it should be this slow, since in the admin ther is not a list of the entire categories ?
The sub categories are working however.. its just that it has become so slow the whenever the script is called the cpu flies to 100%
This means you haven't read/obeyed scripts.webmastersite.net/w...nks/wsnmanual/articles/189
Are there any other fields required for the subcategory's
Well, if I read what you wrote correctly (though I don't really follow it at all) you don't even have a name being imported so they'd all be nameless categories... and you're probably importing them all as unvalidated as well (needs validated=1), so that you have 3000 categories pending validation in the admin panel.
Here is the sql (good thing there is a build in debugger
It looks to me ;ike here the sh*t hits the fan..
"Performing query: SELECT id FROM wsnl_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2886 for Resource id #17 "
Its selecting all categories :|
here are all the queries..
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It looks to me ;ike here the sh*t hits the fan..
"Performing query: SELECT id FROM wsnl_categories WHERE validated=1 AND hide=0 ;
Number of rows is 2886 for Resource id #17 "
Its selecting all categories :|
Again, you need to set the switches (and levels) as the manual instructs.
Also, as explained at the bottom of scripts.webmastersite.net/w...nks/wsnmanual/articles/126 , whenever you import data directly to the database not using the script you need to regenerate counters or it can be slow.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Again, you need to set the switches (and levels) as the manual instructs.
Also, as explained at the bottom of scripts.webmastersite.net/w...nks/wsnmanual/articles/126 , whenever you import data directly to the database not using the script you need to regenerate counters or it can be slow.
Yes I know but i have set that an regenerated all counters.. btw perhaps change that in the faq
But it still behaves that way there was one setting that could not be set, because it kept on loading.. cant acces it now will look on it tuesday, but even the admin is superslow, while no categories are showed there, on the frontend also not anymore so it seems strange to me that even the admin is really slow
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Although the main categories query only executes when the total categories are less than 100 or the 'show subcategories on main page' switch is on, it seems there's another query there which determines how many total categories there are (so that it can be used in that later comparison) which could be slow. I've uploaded a new basic edition version (3.16B), try that. If nothing else, it'll show the execution time at each step (that bit of enhanced debugging was added in 3.14) to show where the problem is.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Hmm im testing the new version but the regenerate counter page now wont load at all, in the new version?
Edit* Nevermind its the gzip compression which is buggy, when turned on you cant view any of the pages.
Although the main categories query only executes when the total categories are less than 100 or the 'show subcategories on main page' switch is on, it seems there's another query there which determines how many total categories there are (so that it can be used in that later comparison) which could be slow. I've uploaded a new basic edition version (3.16B), try that. If nothing else, it'll show the execution time at each step (that bit of enhanced debugging was added in 3.14) to show where the problem is.
Member
Usergroup: Customer
Joined: May 24, 2005
Total Topics: 1
Total Comments: 16
Ok I have set all the settings, with the new version and only 29 categories imported otherwise it crashes my pc
But where does it get the result for this query i think this is also is causing problems:
Load time so far: 0.68 seconds.
Performing query: UPDATE wsnlinks_settings SET content='547' WHERE name='totalsubcats';
, and yes i have set the settings as described, and it does not generate a list of all categories, or subcategories
And it is still very very slow, what kind of shocked me that it even in the admin it performs all kinds of unnecessary queries:
And in the admin: