305 matching results for "david":
| Topic Title | Author | Comment Text | Created | Forum |
|---|---|---|---|---|
| Need a bit of help | david | Hey Paul, Let me jump in here, so I don't have to open a new post for this. links,type;time,10,ascending;descending,catid={CATID} OR parentids LIKE '%|{CATID}|%',,,0,0,0,0 That's what I have to display the links for all subcategories in a specific category. But I made the toplist multipage. When I click on the 2nd page, I get: Load time so far: 0.13 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ; Number of rows is 73 for Resource id #45 Load time so far: 0.15 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE; Load time so far: 0.15 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 #46 Load time so far: 0.15 seconds. Performing query: UNLOCK TABLES; Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_sessions WHERE id=1 ; Number of rows is 1 for Resource id #48 Load time so far: 0.16 seconds. Performing query: UPDATE wsnlinks_members SET inactive='1' WHERE time < 1092550271 AND lastvisit < 1092550271; Load time so far: 0.16 seconds. Performing query: UPDATE wsnlinks_members SET inactive='0' WHERE inactive = 1 AND (time > 1092550271 OR lastvisit < 1092550271); Load time so far: 0.69 seconds. Performing query: UPDATE wsnlinks_settings SET content='1124086272' WHERE name='staticexporttime'; Load time so far: 0.69 seconds. Performing query: UPDATE wsnlinks_categories SET views='104' WHERE id=41; Load time so far: 0.69 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE alias=41 ; Number of rows is 0 for Resource id #51 Setting cookie with name cathits, value 41 and duration 1124086332 Load time so far: 0.69 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE parent=41 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY numsub DESC LIMIT 0,300; Number of rows is 15 for Resource id #53 Load time so far: 0.87 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=41 AND hide=0 AND deleted=0 AND validated=1 ; Count is 0 Fatal error: Unsupported operand types in /home/anmlmdirectory.com/public_html/index.php on line 401 =================== Line 401 in index.php is: $start = ($page * $perpage) - $perpage; // have to adjust for starting the numbering at 1 $end = $start + $perpage - 1; Did I do something wrong here? Thanks David |
Aug 15, 2005 - 1:12 AM | Paid Scripts Support |
| Sorting SUBSUB | david | Hey Paul, It's one thing to setup the ordering for categories, but it seems that SUBSUB is ordered by the same order. I want a different ordering for the SUBSUB. I saw a couple of places in the index.php and templatefunctions.php in regards to the SUBSUB and something about ordering. I don't want to play with the wrong lines in those files, so can you tell me where I can modify the ordering for the SUBSUB?  Thanks David |
Aug 14, 2005 - 11:28 PM | Paid Scripts Support |
| blank screen after profile edit | david | interesting. it only does this for this new usergroup that I created. Weird. | Aug 14, 2005 - 9:23 PM | Paid Scripts Support |
| RSS variables | david | :P noted. thx. | Aug 14, 2005 - 7:41 PM | Paid Scripts Support |
| blank screen after profile edit | david | doing it as non-admin, allowed to edit profile. don't worry too much. i have only seen this on 1 usergroup that i created with 1 member in it. I will give it some more testing later on. | Aug 14, 2005 - 7:32 PM | Paid Scripts Support |
| RSS variables | david | Hmm... that ATOMDATE variable in the rss feed give me this when I try to validate it: line 17, column 26: pubDate must be an RFC-822 date-time (10 occurrences) [help] <pubDate>2005-08-12T22:42Z</pubDate> No idea what that means. Thanks David |
Aug 14, 2005 - 2:33 PM | Paid Scripts Support |
| How to change Static generation time? | david | Hmm... good point. Well I am looking forward to such a feature. You see, RSS is key nowadays, so anything that helps the automatic creation of easy to use rss urls is going to be a must. |
Aug 14, 2005 - 12:56 PM | Paid Scripts Support |
| Mistake in index.php TR handling? | david | That's cause I tweaked it. :P Sorry, but I am a tweak freak. |
Aug 14, 2005 - 12:27 PM | Paid Scripts Support |
| duplicate url check for admins | david | actually I have that at NO. don't worry too much. I got that other usergroup and doing submissions with that one. Thanks David |
Aug 14, 2005 - 12:26 PM | Paid Scripts Support |
| blank screen after profile edit | david | that's exactly the procedure I did. Hmm... | Aug 14, 2005 - 12:24 PM | Paid Scripts Support |
| duplicate url check for admins | david | don't worry about this. i just created a new usergroup for myself. |
Aug 13, 2005 - 1:50 AM | Paid Scripts Support |
| blank screen after profile edit | david | Hey Paul, I get a blank screen after somebody edits their profile. Here is the debug: Load time so far: 0.09 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1; Load time so far: 0.1 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ; Number of rows is 52 for Resource id #37 Load time so far: 0.1 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 #38 Load time so far: 0.11 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,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments FROM wsnlinks_membergroups WHERE id>0 ; Load time so far: 0.11 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,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel FROM wsnlinks_members WHERE id=9 AND validated=1 ; Load time so far: 0.12 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,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ; Number of rows is 71 for Resource id #45 Load time so far: 0.14 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE; Load time so far: 0.14 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 #46 Load time so far: 0.14 seconds. Performing query: UNLOCK TABLES; Load time so far: 0.14 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,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel FROM wsnlinks_members WHERE id=9 ; Load time so far: 0.14 seconds. Performing query: SELECT name,email FROM wsnlinks_members WHERE id != 9 ; Number of rows is 5 for Resource id #49 Load time so far: 0.14 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,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel FROM wsnlinks_members WHERE id=9 ; Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_members SET name='david' WHERE id=9; Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_members SET links='0' WHERE id=9; Load time so far: 0.15 seconds. Performing query: UPDATE wsnlinks_members SET comments='0' WHERE id=9; Any ideas? Thanks David |
Aug 13, 2005 - 1:49 AM | Paid Scripts Support |
| Really stupid question | david | Hey everybody, Probably the worst question of my life. I got a < option value="between" >is between< /option > on my search page. the field that it's searching is an integer. If I wanted to search between 100 and 120, what do you type into the text field?? '100 and 120' or '100 & 120' or ???? I mean, I have never used one of these fields before. (with all my technical knowledge that's really weird). Once somebody can tell, I will know for sure if I have just been missing this knowledge before, or I have been doing right and getting the errors I am getting for a reason. Thanks David |
Aug 12, 2005 - 9:34 PM | Paid Scripts Support |
| Mistake in index.php TR handling? | david | yep. that seems to have fixed it. | Aug 12, 2005 - 6:28 PM | Paid Scripts Support |
| duplicate url check for admins | david | Hey Paul, I got the duplicate url check on submission ON, and submitting links as admin from the site (not from the admin panel). But the url duplicate check doesn't seem to work in this case. Am I missing something here? Thanks David |
Aug 12, 2005 - 6:22 PM | Paid Scripts Support |