305 matching results for "david":
| Topic Title | Author | Comment Text | Created | Forum |
|---|---|---|---|---|
| new fields are not working | david | Hi Paul, I have created new fields, but I cannot change the NULL information in them in the database. Here is the output when I open the standard link submission page, with the new TESTFIELD added to it: Load time so far: 0.13 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 85 Load time so far: 0.14 seconds. Query 3: 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`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.14 seconds. Query 4: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=1 AND validated=1 Query 5: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE Load time so far: 0.15 seconds. Query 6: 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 Query 7: UNLOCK TABLES Load time so far: 0.28 seconds. Query 8: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=0 AND memberid=1 AND ownerip='78.92.4.227' AND time>1191845759 ORDER BY time DESC ------------------------------------------------------------------------- This is the output when I submit a link Load time so far: 0.13 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 85 Load time so far: 0.14 seconds. Query 3: 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`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.14 seconds. Query 4: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=1 AND validated=1 Load time so far: 0.15 seconds. Query 5: 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`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=2 Query 6: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE Load time so far: 0.16 seconds. Query 7: 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 1 Load time so far: 0.16 seconds. Query 8: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=18 Number of rows is 1 Load time so far: 0.2 seconds. Query 9: UPDATE wsnlinks_email SET replacement='member for ' WHERE id=48 Load time so far: 0.2 seconds. Query 10: UPDATE wsnlinks_email SET timesent='1191866349' WHERE id=48 Query 11: UNLOCK TABLES Load time so far: 0.21 seconds. Query 12: SELECT `id` FROM wsnlinks_links WHERE recipurl='http://wsn/suggest.php?action=addlink' Number of rows is 0 Load time so far: 0.21 seconds. Query 13: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1191866349 ORDER BY id ASC LIMIT 0,1 Number of rows is 0 Load time so far: 0.22 seconds. Query 14: 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`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=2 Load time so far: 0.22 seconds. Query 15: 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`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,11 Number of rows is 0 Load time so far: 0.22 seconds. Query 16: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`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`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl` FROM wsnlinks_links WHERE catid=2 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1191866349 ORDER BY time DESC,title ASC LIMIT 0,20 Number of rows is 20 Setting cookie with name returnto, value index.php?action=displaycat&catid=2 and expiration time 2383733598 16 total queries This page was created in 0.37 seconds Memory used: 5016076 bytes Server Status: time since last reboot is 154 days, 11:43, 1 user, load average: 0.02, 0.03, 0.00 -------------------------------- Even though I entered a value for the new field, the value itself never makes it to the database. The database shows NULL . Please Paul, let me know what can be done about this. By the way, I noticed that Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in /home/test/public_html/databases/mysqli.php on line 17 line as well, but in other instances. All other things are working fine in the WSN, except when adding new fields, the list of fields under the forms, are never showing the updated list, even though the new fields are already in the database. It's as if the WSN wouldn't be aware of the new fields at all. It can create them, but that's it. Thanks David |
Oct 08, 2007 - 1:21 PM | Paid Scripts Support |
| URGENT - multiple image attachments | david | My bad. Figured it out. All working.  |
Oct 06, 2007 - 5:23 AM | Paid Scripts Support |
| URGENT - multiple image attachments | david | Hi Paul, I thought I ran into this before, but no idea how it was solved. I would like the following to be ALL on the same page (perhaps the link details page): <!-- BEGIN LINK ATTACHMENTS --> <a href="{ATTACHDOWNLOADURL}"><img src="thumbnail.php?id={ATTACHTHUMBURL}"></a> <!-- END LINK ATTACHMENTS --> <!-- BEGIN 1 LINK ATTACHMENTS --> <a href="{ATTACHDOWNLOADURL}"><img src="{ATTACHDOWNLOADURL}"></a> <!-- END LINK ATTACHMENTS --> <!-- BEGIN TOPLIST 8 --> <CONFIG>links,id,999,ascending,,,,0,0,0,0,0,0,</CONFIG> <!-- BEGIN 1 LINK ATTACHMENTS --> <a href="{LINKDETAILSURL}"><img src="thumbnail.php?id={LINKID}&attachid={ATTACHID}"></a> <!-- END 1 LINK ATTACHMENTS --> <!-- END TOPLIST 8 --> Yet only the first Attachments sections works. Not sure if it helps, but here are the queries: Load time so far: 0.13 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 85 Load time so far: 0.14 seconds. Query 3: 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`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.14 seconds. Query 4: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=1 AND validated=1 Load time so far: 0.15 seconds. Query 5: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`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`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl` FROM wsnlinks_links WHERE id=7 Load time so far: 0.16 seconds. Query 6: 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`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE id=2 Query 7: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE Load time so far: 0.16 seconds. Query 8: 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 Query 9: UNLOCK TABLES Load time so far: 0.17 seconds. Query 10: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=1 Number of rows is 1 Setting cookie with name returnto, value http://www.csi-productions.com/wsn/comments.php?id=7 and expiration time 0 Load time so far: 0.2 seconds. Query 11: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1 Count is 0 Load time so far: 0.2 seconds. Query 12: SELECT `time` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0 ORDER BY time ASC LIMIT 0,1 Load time so far: 0.2 seconds. Query 13: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=1 Count is 0 Load time so far: 0.2 seconds. Query 14: SELECT COUNT(id) FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 AND deleted=0 Count is 0 Load time so far: 0.2 seconds. Query 15: SELECT `deleted` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time DESC LIMIT 0,1 Load time so far: 0.2 seconds. Query 16: SELECT `id`,`linkid`,`postername`,`message`,`time`,`linkname`,`validated`,`ip`,`ownerid`,`lastedit`,`type`,`approved`,`votes`,`hide`,`typeorder`,`lasteditby`,`catid`,`editreason`,`preventedit`,`inhidden`,`deleted`,`deletionreason`,`usernoteon`,`modnote`,`filefield`,`title`,`deletedby`,`parentids`,`disablesmilies`,`disablesig`,`icon`,`disablewsn`,`disablehtml`,`originalmessage`,`flagged`,`wysihtml`,`unrevised`,`internalto`,`hasinternal`,`invisibleto`,`hostname` FROM wsnlinks_comments WHERE linkid=7 AND validated=1 AND hide=0 AND internalto=0 ORDER BY time ASC LIMIT 0,14 Number of rows is 0 Freeing result. Load time so far: 0.21 seconds. Query 17: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=7 ORDER BY time ASC Number of rows is 3 Load time so far: 0.23 seconds. Query 18: 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`,`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`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id=1 Number of rows is 1 Load time so far: 0.29 seconds. Query 19: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1191617034 AND (threadid=7 AND memberid>0) ORDER BY time DESC LIMIT 0,100 Number of rows is 1 Load time so far: 0.29 seconds. Query 20: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`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`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl` FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1191617934 AND alias=0 AND inalbum=0 ORDER BY id ASC LIMIT 0,999 Number of rows is 2 Load time so far: 0.3 seconds. Query 21: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=6 ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.31 seconds. Query 22: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid` FROM wsnlinks_attachments WHERE type='link' AND objectid=7 ORDER BY time ASC LIMIT 0,1 Number of rows is 1 Load time so far: 0.5 seconds. Query 23: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1 Number of rows is 1 Load time so far: 0.5 seconds. Query 24: UPDATE wsnlinks_sessions SET starttime='1191609159', time='1191617934', location='http://www.csi-productions.com/wsn/comments.php?id=7', catid='2', threadid='7', areaname='Comments on Girl 036', nopermission='0', inchat='0', ip='78.92.1.244' WHERE id=6 Thanks David |
Oct 05, 2007 - 4:03 PM | Paid Scripts Support |
| random link+attachment toplist | david | Hi Paul, I need a toplist that shows 1 random attachment of 1 random link (that has a rating of 5). I tried this: <!-- BEGIN TOPLIST 6 --> <CONFIG>links,rand(),1,ascending,rating=5,,0,0,0,0,0,0,0,</CONFIG> <!-- BEGIN 1 LINK ATTACHMENTS --> <img src="{ATTACHDOWNLOADURL}" alt="" /> <!-- END LINK ATTACHMENTS --> <!-- END TOPLIST 6 --> This obviously gets the random link, but would always show the first attachment of that link. How can I show a random attachment of the particular link? Thanks David |
Sep 22, 2007 - 5:03 PM | Paid Scripts Support |
| mass image upload | david | Hi Paul / WSN users! I would like to know if there is a way to upload a large number of images to a link in one shot, without creating a new field for each attachment? Any way to automate the attachment field creations, so that all I have to do is Browse for the files, select them, then Attach, and WSN uploads each image as an attachment for that link? Thanks David |
Sep 08, 2007 - 5:08 AM | Paid Scripts Support |
| Mysql could change header OR fetch | david | Hi Paul, Just did a fresh on install on a system running: PHP Version: 5.2.1 Zend Engine Version: 2.2.0 Loaded PHP Extensions: xmlwriter libxml dom xmlreader xml tokenizer session pcre SimpleXML SPL PDO sockets SQLite standard Reflection posix pdo_sqlite mysqli mysql mcrypt mbstring json iconv hash gd ftp filter exif date curl ctype calendar bcmath zlib apache Server Type: Apache/1.3.37 (Unix) PHP/5.2.1 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a --------------------- Everything looked ok, but when I tried to register a test member, the welcome email never came. The emails can be seen in the Admin Panel Email Log, but the email never went out. So I turned on the debug and saw that an almost every page, there is some kind of problem, related to the mysql.php (see below). It either cannot modify the header, or cannot fetch something. Any ideas? Thanks David T. ---------------------------- ERROR MESSAGE TOWARDS THE BOTTOM. This came up when I clicked on the Register link on the standard templates after a fresh install (that completed without errors). Query 2: SHOW COLUMNS FROM wsnlinks_links Getting field list for table wsnlinks_links: id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,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,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,validatedemail,unpaid,recipverified,effectivetime,sugcatid,pagerank,wysihtml,movedid,unrevised,feedurl,feedcache,feedcachetime,tagline,keywords Load time so far: 0.07 seconds. Query 3: SHOW COLUMNS FROM wsnlinks_categories Getting field list for table wsnlinks_categories: 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,subcatshtml,linksperpage,wysihtml,numonline Load time so far: 0.07 seconds. Query 4: SHOW COLUMNS FROM wsnlinks_members Getting field list for table wsnlinks_members: 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,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,topics,posts,chatcolor,traderrating,invitessent,validatedemail,calsub,macros Load time so far: 0.07 seconds. Query 5: SHOW COLUMNS FROM wsnlinks_membergroups Getting field list for table wsnlinks_membergroups: 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,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,numinv,allowugspec,validateemails,validatesponsorlinks Load time so far: 0.07 seconds. Query 6: SHOW COLUMNS FROM wsnlinks_sessions Getting field list for table wsnlinks_sessions: id,memberid,location,time,ip,browser,starttime,catid,threadid,areaname,lastsearch,nopermission,inchat,name,isrobot,lastchat,groupnamestyle,acceptims,visibility Load time so far: 0.07 seconds. Load time so far: 0.14 seconds. Query 7: SELECT `id` FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1 Number of rows is 0 Load time so far: 0.14 seconds. Query 8: UPDATE wsnlinks_settings SET content='0' WHERE name='highestcatindex' Load time so far: 0.14 seconds. Query 9: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 72 Query 10: SHOW COLUMNS FROM wsnlinks_email Getting field list for table wsnlinks_email: id,to,subject,message,headers,timesent,ip,replacement,mime Load time so far: 0.14 seconds. Query 11: SHOW COLUMNS FROM wsnlinks_ratings Getting field list for table wsnlinks_ratings: id,votevalue,time,memberid,ip,custom,linkid,type Load time so far: 0.14 seconds. Query 12: SHOW COLUMNS FROM wsnlinks_markup Getting field list for table wsnlinks_markup: id,type,original,replacement,description,originalclose,replacementclose,sortorder Load time so far: 0.14 seconds. Query 13: SHOW COLUMNS FROM wsnlinks_modlog Getting field list for table wsnlinks_modlog: id,topicid,postid,type,nature,reason,moderatorid,source,destination,time,catid,memberid Load time so far: 0.14 seconds. Query 14: SHOW COLUMNS FROM wsnlinks_crons Getting field list for table wsnlinks_crons: id,frequency,nextrun,filename,native Load time so far: 0.15 seconds. Query 15: SHOW COLUMNS FROM wsnlinks_calendar Getting field list for table wsnlinks_calendar: id,ownerid,title,description,joined,starttime,endtime,date,reminded,validated,time Load time so far: 0.15 seconds. Query 16: SHOW COLUMNS FROM wsnlinks_helpcategory Getting field list for table wsnlinks_helpcategory: id,name,numsubjects,priority Load time so far: 0.15 seconds. Query 17: SHOW COLUMNS FROM wsnlinks_helpitem Getting field list for table wsnlinks_helpitem: id,subject,helptext,priority,category Load time so far: 0.15 seconds. Query 18: SHOW COLUMNS FROM wsnlinks_im Getting field list for table wsnlinks_im: id,toid,fromid,message,time,isread,timeread,deleted Load time so far: 0.15 seconds. Query 19: SHOW COLUMNS FROM wsnlinks_searches Getting field list for table wsnlinks_searches: id,value,memberid,catid,time Load time so far: 0.15 seconds. Query 20: SHOW COLUMNS FROM wsnlinks_pm Getting field list for table wsnlinks_pm: id,toid,fromid,timeread,message,subject,time,icon,folderid,deleted,flag,filefield,important,replyto,replied,sentdeleted,wysihtml,cc Load time so far: 0.15 seconds. Load time so far: 0.15 seconds. Query 21: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder Number of rows is 23 Query 22: SHOW COLUMNS FROM wsnlinks_attachments Getting field list for table wsnlinks_attachments: id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated,ownerip,catid Load time so far: 0.16 seconds. Query 23: SHOW COLUMNS FROM wsnforum_members Getting field list for table wsnforum_members: id,name,time,usergroup,password,ip,totalhits,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,chatcolor,autosubscribepost,validatedemail,totalhitsin,traderrating,invitessent,newemail,calsub,macros,blogrss,blogcache,watched,links,comments,English Load time so far: 0.16 seconds. Query 24: SHOW COLUMNS FROM wsnforum_members Getting field list for table wsnforum_members: id,name,time,usergroup,password,ip,totalhits,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,chatcolor,autosubscribepost,validatedemail,totalhitsin,traderrating,invitessent,newemail,calsub,macros,blogrss,blogcache,watched,links,comments,English Load time so far: 0.17 seconds. Load time so far: 0.17 seconds. Query 25: 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`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.17 seconds. Query 26: SELECT `id`,`name`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`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`,`chatcolor`,`autosubscribepost`,`validatedemail`,`totalhitsin`,`traderrating`,`invitessent`,`newemail`,`calsub`,`macros`,`blogrss`,`blogcache`,`watched`,`links`,`comments`,`English` FROM wsnforum_members WHERE id=2 AND validated=1 Load time so far: 0.18 seconds. Query 27: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder Number of rows is 14 Query 28: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnforum_members WRITE Load time so far: 0.18 seconds. Query 29: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,50 Number of rows is 0 Query 30: UNLOCK TABLES Load time so far: 0.21 seconds. Query 31: SELECT `id`,`title` FROM wsnlinks_membergroups WHERE id>1 ORDER BY id ASC Number of rows is 3 Warning: Cannot modify header information - headers already sent by (output started at /home/filmcred/public_html/databases/mysqli.php:14) in /home/filmcred/public_html/end.php on line 146 Load time so far: 0.49 seconds. Query 32: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility` FROM wsnforum_sessions WHERE ip='89.132.104.226' AND memberid=0 Number of rows is 1 Load time so far: 0.49 seconds. Query 33: UPDATE wsnforum_sessions SET id='5', memberid='0', location='http://www.filmcredit.net/register.php', time='1182531871', ip='89.132.104.226', browser='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)', starttime='1182530496', catid='', threadid='', areaname='Registration', lastsearch='0', nopermission='0', inchat='0', name='', isrobot='0', lastchat='0', groupnamestyle='', acceptims='', visibility='' WHERE id=5 ----------------------------- |
Jun 22, 2007 - 12:10 PM | Paid Scripts Support |
| checkbox value separator | david | Hello Paul, Quick question. I have a text type database field. I have several checkboxes to enter values into it. I want to display the values on a page. By default, {LINKWHATEVERTHISFIELDIS} would display something like: value1, value2, value3, etc It puts a comma between the values. How can I change this to something else, like a line-break or something. Thank You David |
Nov 23, 2006 - 12:22 PM | Paid Scripts Support |
| Internet Explorer and WSN don't mix | david | Hey Paul, Got a new kind of problem. Look at this: <!-- BEGIN TOPLIST 21 --> <CONFIG>links,rand(),1,ascending,catid=32,,</CONFIG> {LINKADFLASHNEV} <!-- END TOPLIST 21 --> Nice and simple, right? Works fine in Firefox, gets parsed, displays the LINKADFLASHNEV value. But in IE, this is the end result: {LINKADFLASHNEV}<!-- END TOPLIST 21 --> I did a little quirk test, and I placed ONLY the above toplist on template and called it up with: usewrapper=no&custom=yes&TID=a . So there was nothing else on the page (obviously a little html and body tag and such). What could be causing this? Thanks David |
Jun 25, 2006 - 4:26 AM | Paid Scripts Support |
| What is , doing in a field value | david | Hey Paul, Most likely a stupid question, but it's causing problems. I created a member text field, nothing special about it, been doing this a while. I created checkboxes for the values. When the value for the field is created from the value of the checkbox, it adds , before the actual value, in the database. This is fine so far, since this has been working for all my link fields, meaning that when I want to display the value of such a link field, it displays just fine. BUT, this member field, now displays either nothing, OR the word YES, instead of the value of it, when I try to call it up on a webpage. If I remove the , from the field's value, then it displays just fine. For example: I have a member field called NEWTHING. I have 2 checkboxes for possible values for this field. Option A is 'super', option B is 'weak'. If I put a check to 'super', then save the changes, the value of that field in the database will read: , super That's fine. But when I try to call up { MEMBERNEWTHING } in a browser, it either display absolutely nothing, or the word 'yes' . If I manually remove the , before 'super' in the value of the field in the database, for that member, and then try to call up the value, then it displays the word 'super' just the way it should be. Any ideas? I can't see this working this way properly. I cannot set my database field to an integer or anything else. This should be a text type DB field. I am also fine with the , in front of the field values, but then why doesn't it strip that? I think it does that for the link fields, but I haven't tested it, all I know is that all my link fields are displaying fine, even though some of them have those , in their values. Thanks David |
May 07, 2006 - 6:09 PM | Paid Scripts Support |
| expiredays | david | Yep, but for some odd reason, after some time, it does change it. There hasn't been a way for me to deliberately reproduce this problem, but it has happened many times already. My guess, is the counter regeneration, or addition/deletion of link from a member's personal links (no idea how that would relate though). So for sure, there is something weird happening, just can't pinpoint the reason. Thanks David |
Apr 09, 2006 - 4:38 AM | Paid Scripts Support |
| expiredays | david | Hey guys! I was just about to post a topic on the same thing. I had my links disappear, because at the time of regenerating the counters, links that had a high number (definately over 120) of days to expire, went back to -0. Paul, could you release the appropriate php file with a fix in it for this? Much appreciated. Thanks David |
Apr 08, 2006 - 2:48 AM | Paid Scripts Support |
| end.php error when member is | david | Hey Paul, 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 58 for Resource id #37 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,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod 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,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,topics,posts,chatcolor,publicname,publiccompany,publicphone,publicaddress,publicemail,privatename,privatecompany,privateaddress,privatephone,publicdescription,traderrating FROM wsnlinks_members WHERE id=7 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,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ; Number of rows is 24 for Resource id #45 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 #46 Load time so far: 0.13 seconds. Performing query: UNLOCK TABLES; Load time so far: 0.13 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,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,topics,posts,chatcolor,publicname,publiccompany,publicphone,publicaddress,publicemail,privatename,privatecompany,privateaddress,privatephone,publicdescription,traderrating FROM wsnlinks_members WHERE id=7 ; Fatal error: Call to undefined function: replace() in /home/jfeedwav/public_html/end.php on line 136 I get that when entering a registration activation code wrong. It should be displaying the message that 'you entered the invalid activation code', but instead i get Fatal error: Call to undefined function: replace() in /home/jfeedwav/public_html/end.php on line 136 on a blank screen. ?? Thanks David |
Apr 04, 2006 - 10:18 AM | Paid Scripts Support |
| Accents in urls (filtering) | david | Well something is definately not right. Here is the scenario: - I have a category with links in it, some have 'Kiadó', some have 'Eladó' as their value for the field 'kiadoelado' - If I display the category in a normal fashion, all links are showing up fine. - If I add to the URL &linkfilteraction=add&filter=kiadoelado&filtervalue=Eladó it brings me back to the same page and says that there are 0 (zero) links in this category - AND the funkiest part, is that if I remove that extra filter from the url, so it simply should display the category (index.php?action=displaycat&catid=4), it still says that there are no links in the category. Even if I refresh the page. - IF I clear my cookies, and then refresh, it goes back to showing all the links in the category just fine. If I understand this: &linkfilteraction=add&filter=kiadoelado&filtervalue=Eladó it should refresh the page and show only links that have the word 'Eladó' as the value for their 'kiadoelado' field. David |
Mar 27, 2006 - 6:47 AM | Paid Scripts Support |
| URGENT problem after upgrade | david | Cheers. That was definately the problem. David |
Mar 27, 2006 - 6:41 AM | Paid Scripts Support |
| After Upgrade I see this | david | Nope. Looks good though now. I might have left it in debug mode, when generating the pages. | Mar 27, 2006 - 6:40 AM | Paid Scripts Support |