305 matching results for "david":
| Topic Title | Author | Comment Text | Created | Forum |
|---|---|---|---|---|
| RSS - mysql_num_rows error | david | Load time so far: 0.11 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.11 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.12 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.12 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.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 51 for Resource id #44 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 #45 Load time so far: 0.15 seconds. Performing query: UNLOCK TABLES; Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/rssfeed.php on line 22 Load time so far: 0.17 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,xwidth,yheight,lastposterid,lastpostername,sticky,ownername,deleted,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,filefield,tier,payoutamount,payouttype,payoutmore,investment,recurring,minpayout,payduration,paymethod,tracksoftware,availability,check,opened,rssfeed,businessphone,phone,skype,searchpayoutmore,meanpayoutamount,searchinvestment,searchminpayout,searchrecurring FROM wsnlinks_links WHERE validated=1 AND hide=0 AND alias=0 AND deleted=0 AND catid ! = 8 AND catid ! = 9 ORDER BY rating ASC LIMIT 0,100; Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/anmlmdirectory.com/public_html/classes/database.php on line 108 Number of rows is for You have an error in your SQL syntax near '! = 8 AND catid ! = 9 ORDER BY rating ASC LIMIT 0,100' at line 1 Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/end.php on line 143 http://www.anmlmdirectory.com An MLM Directory | Affiliate Business Directory | Opportunity List en-us Load time so far: 0.2 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1123612614 AND memberid > 0 ; You have an error in your SQL syntax near '! = 8 AND catid ! = 9 ORDER BY rating ASC LIMIT 0,100' at line 1 Number of rows is 0 for Resource id #53 Load time so far: 0.2 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1123612614; Load time so far: 0.2 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime=0, time=0 WHERE time < 1123615914; Load time so far: 0.2 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='24.64.73.161' AND memberid=0 ; Number of rows is 1 for Resource id #54 Load time so far: 0.2 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1123616214', location='http://anmlmdirectory.com/rssfeed.php?type=links&number=50&field=rating&ascdesc=ascending&thecondition=catid%20!%20=%208%20AND%20catid%20!%20=%209', catid='', threadid='', areaname='http://anmlmdirectory.com', nopermission = 0 WHERE ip='24.64.73.161'; closing database connection =================================== rssfeed.php?type=links&number=50&field=rating&ascdesc=ascending&thecondition=catid ! = 8 AND catid ! = 9 That's what happened when I put the spaces back Thanks David |
Aug 09, 2005 - 2:44 PM | Paid Scripts Support |
| RSS - mysql_num_rows error | david | 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.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 51 for Resource id #44 Load time so far: 0.13 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE; Load time so far: 0.13 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 #45 Load time so far: 0.13 seconds. Performing query: UNLOCK TABLES; Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/rssfeed.php on line 22 Load time so far: 0.15 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,xwidth,yheight,lastposterid,lastpostername,sticky,ownername,deleted,deletionreason,movedto,pollid,deletedby,posticon,timevalidated,filefield,tier,payoutamount,payouttype,payoutmore,investment,recurring,minpayout,payduration,paymethod,tracksoftware,availability,check,opened,rssfeed,businessphone,phone,skype,searchpayoutmore,meanpayoutamount,searchinvestment,searchminpayout,searchrecurring FROM wsnlinks_links WHERE validated=1 AND hide=0 AND alias=0 AND deleted=0 AND catid!=8ANDcatid!=9 ORDER BY rating ASC LIMIT 0,100; Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/anmlmdirectory.com/public_html/classes/database.php on line 108 Number of rows is for Unknown column '8ANDcatid' in 'where clause' Warning: Cannot modify header information - headers already sent by (output started at /home/anmlmdirectory.com/public_html/classes/database.php:276) in /home/anmlmdirectory.com/public_html/end.php on line 143 http://www.anmlmdirectory.com An MLM Directory | Affiliate Business Directory | Opportunity List en-us Load time so far: 0.2 seconds. Performing query: SELECT memberid,starttime,time FROM wsnlinks_sessions WHERE time < 1123602483 AND memberid > 0 ; Unknown column '8ANDcatid' in 'where clause' Number of rows is 0 for Resource id #53 Load time so far: 0.21 seconds. Performing query: DELETE FROM wsnlinks_sessions WHERE time < 1123602483; Load time so far: 0.21 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime=0, time=0 WHERE time < 1123605783; Load time so far: 0.21 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='24.64.73.161' AND memberid=0 ; Number of rows is 0 for Resource id #54 Load time so far: 0.21 seconds. Performing query: INSERT INTO wsnlinks_sessions(memberid,ip,location,time,starttime,browser,areaname,nopermission) VALUES('0','24.64.73.161','http://anmlmdirectory.com/rssfeed.php?type=links&number=50&field=rating&ascdesc=ascending&thecondition=catid!=8ANDcatid!=9','1123606083','1123606083','Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.6) Gecko/20050225 Firefox/1.0.1','http://anmlmdirectory.com','0'); closing database connection |
Aug 09, 2005 - 11:52 AM | Paid Scripts Support |
| RSS - mysql_num_rows error | david | Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in classes/database.php on line 108 I get that at anmlmdirectory.com/index.ph...?action=displaycat&catid=9 Try to see the right rss feed. This is what's around line 108 in database.php : function numrows($sqllump) { global $debug, $debuginfo, $mysqlloosetime; $b = microtime(); $num = mysql_num_rows($sqllump); $mysqlloosetime += microtime() - $b; if (($debug>0) && ($debug<4)) { if ($debug == 2)$debuginfo .= "<p>Number of rows is $num for $sqllump". mysql_error() ."</p>"; else echo "<p>Number of rows is $num for $sqllump". mysql_error() ."</p>"; } return $num; } This is the actual RSS link: www.anmlmdirectory.com/rssf...cending&thecondition=catid!=8ANDcatid!=9 Try to run that in http://www.feedvalidator.org . It says that there is a <br /> before the < ?xml version="1.0"? > in the feed. Where is that <br /> coming from? Thanks David |
Aug 08, 2005 - 11:51 PM | Paid Scripts Support |
| Upgrading to 3.23 | david | Got it.  upgraded jsut fine. |
Aug 08, 2005 - 11:13 PM | Paid Scripts Support |
| Repair / Optimize tables | david | Hey Paul, How long do these functions run? David |
Aug 08, 2005 - 10:55 PM | Paid Scripts Support |
| Upgrading to 3.23 | david | Quick addon question. I did a manual upgrade of the files from 3.20 to 3.23 because I had to modify a lot of the php files. Does upgrading supposed to create new tables and modify the database? Should I just simply run the upgrade.php (after following the instructions on what to upload) in that case? Thanks David |
Aug 08, 2005 - 9:47 PM | Paid Scripts Support |
| mistake in 3.23 zip file? | david | Hey Paul, Just doing a manual upgrade to 3.23 and noticed that in some files (especially templates, but some php), the reference to a category has been replaced by Forum and the Link by Topic. Example: <form action="makehtml.php?filled=1" method="post"> <span class="labels">Generate Pages Now:</span> <br><br>Create an HTML version in the directory <input type="text" name="directory" size="15" value="admin/htmloutput"> (use a relative path from the main WSN Links directory). <br>Use these custom templates (leave blank to use regular templates, but it's strongly suggested you use custom ones to avoid dead links): <br>Wrapper: <input type="text" name="customhead" value="{CUSTOMHEAD}"> <br>Main index: <input type="text" name="customindex" value="{CUSTOMINDEX}"> <br>Forums: <input type="text" name="customcat" value="{CUSTOMCAT}"> <br>Topic Details: <input type="text" name="customitem" value="{CUSTOMITEM}"> <br>Threads: <input type="text" name="customcomments" value="{CUSTOMCOMMENTS}"> <br><br>Do <input type="text" name="perpage" value="5" size="3"> of each type per cycle, starting at <input type="text" name="start" value="0" size="4">.<br> <br><input type="submit" value="Begin Generation" class="button"> </form> <br>This requires that none of your category names contain characters which are illegal in a directory name, and that PHP have CHMOD ability on your host. Note: If you select 'yes', you will want to name categories as index{PAGE}.html. <br>Absolute URL prefix (will prepend all links to cats, links, comments, index... needed if using subdirectories): <input type="text" name="htmlautogenerateabsurl" size="{STANDARDSIZE}" value="{HTMLAUTOGENERATEABSURL}"> <br>Directory to write autogenerated HTML to: <input type="text" name="htmlautogeneratedir" size="{STANDARDSIZE}" value="{HTMLAUTOGENERATEDIR}"> (relative to your base WSN Links directory) <br>Use these custom templates (make blank in order to use standard templates): <br>Wrapper: <input type="text" name="customhead" value="{CUSTOMHEAD}"> <br>Main index: <input type="text" name="customindex" value="{CUSTOMINDEX}"> <br>Forums: <input type="text" name="customcat" value="{CUSTOMCAT}"> <br>Topic Details: <input type="text" name="customitem" value="{CUSTOMITEM}"> <br>Threads: <input type="text" name="customcomments" value="{CUSTOMCOMMENTS}"> <br><b>Advanced:</b> <br>Name main index page as <input type="text" name="htmlautogenerateindex" size="20" value="{HTMLAUTOGENERATEINDEX}"> <br>Name categories as <input type="text" name="htmlautogeneratecat" size="20" value="{HTMLAUTOGENERATECAT}"> <br>Name link details as <input type="text" name="htmlautogeneratelin" size="20" value="{HTMLAUTOGENERATELIN}"> That's from the makehtml.tpl in the admin directory. I got a script comparing every file and doing a manual upgrade. I noticed this in a lot files and thought that maybe you did an upgrade on the WSNFORUM script as well and mixed up the files that were included in the zip file of the WSNLINKS. David |
Aug 08, 2005 - 9:03 PM | Paid Scripts Support |
| Another silly RSS question | david | tried a RewriteRule. didn't work either.  |
Aug 08, 2005 - 7:46 PM | Paid Scripts Support |
| Another silly RSS question | david | Alias /rssfeed.php?type=links&number=50&field=time&ascdesc=descending&thecondition=catid=8 /a.xml That didn't work. Any thoughts? I know I am missing something very simple here, but since I don't know too much about Apache, can't figure it out. Thx David |
Aug 08, 2005 - 7:12 PM | Paid Scripts Support |
| Another silly RSS question | david | if using an .htaccess line, how would I format that? Alias /rssfeed.php?type=links&number=50&field=time&ascdesc=descending&thecondition=catid=8/ /toplist.xml OR Alias /rssfeed.php?type=links&number=50&field=time&ascdesc=descending&thecondition=catid=8 /toplist.xml ??? Thx David |
Aug 08, 2005 - 4:27 PM | Paid Scripts Support |
| Another silly RSS question | david | I have rssfeed.php?type=links&number=50&field=rating&ascdesc=ascending&thecondition=catid !=8 AND catid !=9 in my HTML. But this isn't a valid xml/rss feed url. How can I make that something like mytoplist.xml ? Thanks David |
Aug 07, 2005 - 8:48 PM | Paid Scripts Support |
| Top list that DOESN'T include CATIDs | david | Thank You Boss! |
Aug 07, 2005 - 6:28 PM | Paid Scripts Support |
| multiple RSS with one script? Anybody? | david | Got it. Carp RSS is the way to go. |
Aug 07, 2005 - 3:41 PM | Paid Scripts Support |
| multiple RSS with one script? Anybody? | david | Hello everybody, Looking for a script that would allow me to display multiple RSS feeds on a page. I currently have one that allows me to do 1 at time, and each one has to have a copy of the script on the server. I need a script that I can place in the displaylinks template, with something like this: < IF { LINKRSSFEED }< a href="phprssscript.php?url=http://theurlofthelinksrssfeed&items_to_display=1 " > ~~~itemtitle~~~ | ~~~itemdate~~~ < /a > < /IF > So I would have a link field called RSSFEED. If the member fills this field out with the url of the feed, then when their link is displayed, it should use that php script to display the first item of the feed. It will have to display at least the title of the last item (date not that important). Anybody has found a solution for anything like this? Thanks David |
Aug 07, 2005 - 3:12 PM | Paid Scripts Support |
| Top list that DOESN'T include CATIDs | david | Hello, I see the manual saying catid=6 OR parentids LIKE '%, 6, %' for displaying only certain category and all it's subcategories. what is the option though, for NOT including certain categories. something like catid= NOT 6,5,3 . Or can I use <IF > conditionals in the CONFIG of the Top lists? Thanks David |
Aug 07, 2005 - 3:02 PM | Paid Scripts Support |