305 matching results for "david":
Topic Title | Author | Comment Text | Created | Forum |
---|---|---|---|---|
toplist in linkbit not working | david | Simple. Real estate website. I want to have users who have the same information fields as the properties (links). As the admin, I would like to list all the properties in a table, and next to each property, I would like to show the users in the database who match the search query for that property (using the information in their profile). So for each link, the system will have to create a new toplist, running a whole lot of queries (as if submitting an advanced search). The idea is to see a list of users who are looking for a similar property than the current listing. Does this make sense? Or perhaps there is an easier way to automatically perform an advanced search amongst users for each link list in the Display Links page? Thanks David |
Jun 05, 2008 - 3:47 PM | Paid Scripts Support |
toplist in linkbit not working | david | Hi Paul, The {NUMBER} idea was good, but still doesn't show the results, just finds them...
|
May 30, 2008 - 3:52 PM | Paid Scripts Support |
toplist in linkbit not working | david | Hi Paul, Just started a new site, got the latest version of your very fine script. Small hiccup or my rusted memory on how to use certain things in WSN Links? The problem:
I put the above toplist, for testing purposes, into the 'Show Links in Category' and the 'Linkbit' template. Obviously the toplist numbers are different, and I changed the end of the sentence of what should show up in a toplist item from 'Show Links in Category' to 'Linkbit', so I can clearly see what I am testing. This is all fine. Oddly enough, the Linkbit toplist doesn't display the results, even though it does find them. In reality there is only one link to find, but that's besides the point. Here is the debug info:
So the Display Links template displays the link with the title='testlinktitle', while the Linkbit doesn't. Originally I had a single toplist in the Linkbit template, but when it didn't show up results for a while, I tried this approach, to see if this is a problem with my toplist, or with toplists in Linkbits. What do you think Paul? Is there a remedy? By the way, something is not right with posting a CODE here. I posted the toplist on top of this post, and the word 'ascending' turned into 'ascendArrayle'. At least, when I previewed my post.... let's see if the same happens when I submit... Thanks David |
May 29, 2008 - 3:14 PM | Paid Scripts Support |
Single link with mass user input | david | Hey Paul, Let me clarify, because you might have misunderstood. Linkowner creates a new link. Link has an attribute that stores a number value (dollar). New visitor comes to site. Registers. This member views the link, sees that the link is dollar value is 100. This member wants to contribute/make a pledge towards this link. Member inputs 10 dollars into a field and submits. We need to do/know the following about this 10 dollar: - if the pledging member logs into his account/views a new page on his profile, he sees that he pledged 10 dollars to link X, on date Y - he can see all other pledges he made, and a sum of all pledges - Linkowner and public can see all pledge amounts and usernames of those pledge submitters, when viewing that link. the results shown are cutoff as per explained below. - total of the pledges is also shown for that link, BUT only upto the amount of the original value (100 dollars). so if 10 people pledged 10 dollars and I view this link, I see that the link's value is 100 dollars, and below it I see 10 pledges at 10 dollars each, totaling 100 dollars. IF another person makes a pledge towards that link, their pledge gets submitted and stored, BUT is not displayed on the link view detail page. - admin needs the ability to disable submission of pledges after the value amount has been met, or let people still post pledges (but following the above process of hiding these additional pledges) - admin needs to be able to contact those people who have submitted pledges which are displayed (accepted) - admin needs to be able to contact those people who have submitted pledges, but aren't displayed (they are overflow) - admin needs to contact both types Accepted and Overflow pledges members for that link The idea is a site where people can post a link, put a value to it and other people making pledges towards that link. I need simple solution, so if for example cutting the number of pledges off when displaying them on the link details, is done by simple PHP math functions in the templates, and not by admin features or programming, then that's cool. This will be a beta site anyways, and I just need this pledging feature to be there for now. Later on, other features will have to be implemented, but not for another 6 months probably. Please look at this again Paul and let me know. Thanks David |
Feb 27, 2008 - 3:05 AM | Paid Scripts Support |
Single link with mass user input | david | Hey Paul and fellow WSN fans! I want to create a directory where each link has a PRICE attribute and registered users can make virtual donations towards that link. No payment needs to be processed, but each 'contribution' must be associated with that link, so if I want, I can list all the contributors and their pledges. I didn't want to use the comment system associated with a link, just for submission of dollar amount pledges for that link (would be a waste and I want the link commenting system intact). Ideally, a separate table should store information about the LINK, the CONTRIBUTOR MEMBER ID, the PLEDGE AMOUNT, and PLEDGE DATE. Then simply query/display all the pledges for that link when somebody views a link. A separate setting must also be in place for the admin, to manually disable pledge submissions for a link if needed. So can something like this be done in WSN right now? Or is it custom work? If so, can you send me a private quote please? Thanks David |
Feb 25, 2008 - 3:14 AM | Paid Scripts Support |
Between search type error | david | My apologies Paul, I didn't see the edit on the post. I see your point. Darn, I thought this was something simple. Oh well, no worries man, I'll just create a new individual field for each of the values I originally had. Thanks Paul, sorry to have bothered you with this. David |
Nov 10, 2007 - 6:20 PM | Paid Scripts Support |
Between search type error | david | Neg. It throws this back still: Load time so far: 0.08 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 87 Load time so far: 0.09 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`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.11 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.12 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 Query 8: INSERT INTO wsnlinks_searches(`value`,`memberid`,`catid`,`time`) VALUES('Divatmodell','1','','1194717463') Load time so far: 0.15 seconds. Query 9: 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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap`,`beljegy`,`timedeleted` FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194717463) AND (tevekenyseg 'Divatmodell')) ORDER BY hits DESC LIMIT 0,60 Load time so far: 0.15 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell')) ORDER BY hits DESC LIMIT 0,60' at line 1 Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194717463) AND (tevekenyseg 'Divatmodell')) Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 29 Count is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 26 Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell'))' at line 1 Load time so far: 0.2 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell'))' at line 1 I selected Divatmodell only from the checkboxes, and I have a link that has Divatmodell in its 'tevekenyseg' field value. Is there a way that you can test this yourself? A simple text link field, say 3 different checbox values to it, then try a search in that field? Thanks David |
Nov 10, 2007 - 12:00 PM | Paid Scripts Support |
Between search type error | david | Hmmm.... I think I did this type of search already a year ago in your script. I can't find that search template anymore though. This is what I don't understand. If I have a text field, that has values like , Divatmodell, Sminkmodell, Hajmodell, Fotómodell and I want to search this field, then why doesn't simply giving the search of that field a condition of 'like' works? Shouldn't that technically just look for words that match the selected checkbox values? It seems strange to me that you can do such things when editing this field in the LINK EDIT. Your script DOES match words (values) from that field, otherwise it wouldn't know which values have to be checked already. So the same concept should work in a search, shouldn't it?
What about if I change this to a multiselect dropdown, and what about if I put , in front of the individual values? I am surprised that it is possible to enter values into a field from checkboxes, then easily view and edit those values, but not search them. Paul, what can be done here? Thanks David |
Nov 10, 2007 - 3:39 AM | Paid Scripts Support |
Between search type error | david | ???
I had that in there. What do you mean: "haven't specified for any of those checkboxes." Thanks David |
Nov 08, 2007 - 11:56 AM | Paid Scripts Support |
Between search type error | david | Hi Paul, Interesting. The between is working fine now, even though I didn't touch anything. Weird. NEW problem. This is the same search form:
When I check off 'Divatmodell' for example, knowing that there is a link in the database that has at least that value in that field, it produces this: Load time so far: 0.08 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 87 Load time so far: 0.09 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`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.11 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.12 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 Query 8: INSERT INTO wsnlinks_searches(`value`,`memberid`,`catid`,`time`) VALUES('Divatmodell','1','','1194467444') Load time so far: 0.15 seconds. Query 9: 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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap`,`beljegy` FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194467444) AND (tevekenyseg 'Divatmodell')) ORDER BY hits DESC LIMIT 0,60 Load time so far: 0.15 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell')) ORDER BY hits DESC LIMIT 0,60' at line 1 Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194467444) AND (tevekenyseg 'Divatmodell')) Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 29 Count is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 26 Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell'))' at line 1 Load time so far: 0.2 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Divatmodell'))' at line 1 Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0 Count is 1 Load time so far: 0.2 seconds. Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0 Count is 3 Load time so far: 0.2 seconds. Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1 Count is 2 Load time so far: 0.2 seconds. Query 14: SELECT COUNT(id) FROM wsnlinks_sessions WHERE time > 1194466544 Count is 1 Load time so far: 0.2 seconds. Query 15: 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 > 1194466544 ORDER BY memberid desc,time desc LIMIT 0,300 Number of rows is 1 Load time so far: 0.3 seconds. Query 16: 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.3 seconds. Query 17: UPDATE wsnlinks_sessions SET starttime='1194461469', time='1194467444', location='http://www.apollomodel.net/search.php?action=filter&&whichtype=links', catid='', threadid='', areaname='Search Results', nopermission='0', inchat='0', ip='78.92.3.27' WHERE id=70 Since the database field is a text, and I had many values in it, they are divided with that , thingy. Is this causing the problem? How do you search a database field that had it's values set from a checbox form input? Thanks David |
Nov 07, 2007 - 2:32 PM | Paid Scripts Support |
LINKHIDE error | david | Hi Paul, I have an empty page without wrappers and only this:
The above list would work fine, but as soon as I want to call upon the HIDE status of a link, it gives off this: Load time so far: 0.08 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 87 Load time so far: 0.09 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`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0 Load time so far: 0.11 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.12 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.14 seconds. Query 8: 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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap`,`beljegy` FROM wsnlinks_links WHERE validated=1 AND deleted=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1194310175 AND alias=0 AND inalbum=0 ORDER BY time DESC LIMIT 0,200 Number of rows is 3 Load time so far: 0.17 seconds. Query 9: UPDATE wsnlinks_comments SET inhidden='1' WHERE linkid=36 Fatal error: Call to a member function updatenumlinks() on a non-object in /home/apollo/public_html/classes/onelink.php on line 864 What's interesting is that this feature was working WSN 3 versions before. Please let me know how I could fix this. Thanks David |
Nov 05, 2007 - 6:53 PM | Paid Scripts Support |
email verification error | david | Hi Paul, I got Guests submitting links, entering their email address at the submission. An email verification email is sent to them before the link shows up as something that the admin would have to approve. This works fine, except that when the email verification link is visited, it gives off an error, even though the verification completes just fine: Load time so far: 0.08 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 87 Load time so far: 0.09 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`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0 Query 4: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE Load time so far: 0.12 seconds. Query 5: 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 6: UNLOCK TABLES Load time so far: 0.14 seconds. Query 7: 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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap`,`beljegy` FROM wsnlinks_links WHERE id=34 Load time so far: 0.17 seconds. Query 8: 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.17 seconds. Query 9: UPDATE wsnlinks_links SET validatedemail='1' WHERE id=34 Load time so far: 0.17 seconds. Query 10: SELECT COUNT(id) FROM wsnlinks_links WHERE alias=34 AND validated=1 Count is 0 Warning: Invalid argument supplied for foreach() in /home/apollo/public_html/includes/objectfunctions.php on line 269 Warning: Variable passed to each() is not an array or object in /home/apollo/public_html/includes/objectfunctions.php on line 304 Load time so far: 0.23 seconds. Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0 Count is 1 Load time so far: 0.23 seconds. Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0 Count is 1 Load time so far: 0.23 seconds. Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1 Count is 0 Load time so far: 0.23 seconds. Query 14: SELECT COUNT(id) FROM wsnlinks_sessions WHERE time > 1194305929 Count is 2 Load time so far: 0.23 seconds. Query 15: 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 > 1194305929 ORDER BY memberid desc,time desc LIMIT 0,300 Number of rows is 2 Load time so far: 0.33 seconds. Query 16: 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 ip='78.92.0.48' AND memberid=0 Number of rows is 1 Load time so far: 0.33 seconds. Query 17: UPDATE wsnlinks_sessions SET starttime='1194306551', time='1194306830', location='http://www.xxxxxxxxxx.net/activate.php?linkid=34&activation=f8ea7a', catid='', threadid='34', areaname='activate.php?linkid=34&ac', nopermission='0', inchat='0', ip='78.92.0.48' WHERE id=45 Why is the query looking for a validated link after this verification link? I have to first validate the link as an admin before it can show up. Thanks David |
Nov 05, 2007 - 6:01 PM | Paid Scripts Support |
Between search type error | david | Hi Paul, I have a BETWEEN type search in my advanced search page. Looks like this:
When I leave the minimum value blank and enter a max value, I get a result fine. When I leave the maximum value blank and enter a min value, I get a result fine. When I enter a value for both, I get this: Load time so far: 0.08 seconds. Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0 Number of rows is 87 Load time so far: 0.09 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`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0 Query 4: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE Load time so far: 0.12 seconds. Query 5: 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 6: UNLOCK TABLES Query 7: INSERT INTO wsnlinks_searches(`value`,`memberid`,`catid`,`time`) VALUES('1 2','0','','1194224590') Load time so far: 0.14 seconds. Query 8: 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`,`timesrenewed`,`mellboseg`,`derekboseg`,`csipoboseg`,`cipo`,`suly`,`teljesnev`,`orszag`,`megye`,`telepules`,`magassag`,`konfekcio`,`gyakorlat`,`iranyitoszam`,`hajszin`,`szemszin`,`tevekenyseg`,`oltozet`,`magamrol`,`megjelenes`,`referencia`,`nyelvtudas`,`tiltott`,`telefon`,`eletkor`,`szulinap` FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194224590) AND (eletkor '1 2')) ORDER BY hits DESC LIMIT 0,60 Load time so far: 0.14 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1 2')) ORDER BY hits DESC LIMIT 0,60' at line 1 Query 9: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND ((effectivetime < 1194224590) AND (eletkor '1 2')) Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 29 Count is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/apollo/public_html/databases/mysql.php on line 26 Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1 2'))' at line 1 Load time so far: 0.2 seconds. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1 2'))' at line 1 Query 10: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0 Count is 1 Load time so far: 0.2 seconds. Query 11: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0 Count is 1 Load time so far: 0.2 seconds. Query 12: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1 Count is 0 Load time so far: 0.2 seconds. Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE time > 1194223690 Count is 2 Load time so far: 0.2 seconds. Query 14: 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 > 1194223690 ORDER BY memberid desc,time desc LIMIT 0,300 Number of rows is 2 Load time so far: 0.3 seconds. Query 15: 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 ip='78.92.0.55' AND memberid=0 Number of rows is 1 Load time so far: 0.3 seconds. Query 16: UPDATE wsnlinks_sessions SET starttime='1194217700', time='1194224590', location='http://www.apollomodel.net/search.php?action=filter&&whichtype=links', catid='', threadid='', areaname='Search Results', nopermission='0', inchat='0', ip='78.92.0.55' WHERE id=49 Any thoughts? Thanks David |
Nov 04, 2007 - 7:04 PM | Paid Scripts Support |
duplicate email at registration | david | Never mind. I forgot to select the email field as Required in the General settings. David |
Nov 04, 2007 - 5:48 PM | Paid Scripts Support |
duplicate email at registration | david | Hi Paul, I got Treat emails as usernames and Quick registration switched on. I ask for an email and password on the registration page. How I can I not allow people to register with the same email address? Thanks David |
Nov 04, 2007 - 5:46 PM | Paid Scripts Support |