Webmastersite.net
Register Log In

197 matching results for "gemini":

Sort by
Topic Title Author Comment Text Created Forum
upgrade.php doesn't work gemini sorry for the version confusion - I updated only the files that you changed (you mentioned them in the customers section). My current version shows 3.3.10 though.

This is happening since long-long time ago I haven't been able to use any upgrade.php since 3.16. I've done a lot of modifications, but I haven't moved config anywhere. Also, all the previous updates were done within your Installation guidelines, so all the files and folders were updated many times.
Mar 26, 2006 - 12:22 AM Paid Scripts Support
HTML code in a custom field gemini The field is not available on the suggest page. Members using the same edit page as I do, but the HTML field is available only for the Admin. Basically they edit other data, but the HTML text box is being somehow affected... all the < and > turn itno & l t ; and & g t ; Mar 24, 2006 - 10:58 PM Paid Scripts Support
upgrade.php doesn't work gemini I have an issue on my real estate directory site with upgrade.php file and long time ago I asked about it and kinda ended up on my own since I've done too much modification of my database.. but I've been using upgrade.php from ver.3.16 for all this time successfully.

Now I have a different site that I just installed 3.307 and was trying to upgrade it to 3.11 - the upgrade.php gives me blank page (just the same was as I have on my reale state directory site). I turned on debug function and still getting blank page.

Well, I copied the 3.16 upgrade.php over the new one and it went through. But here are the messages I get and there are whole bunch of syntax error


Load time so far: 0.19 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 2 for Resource id #47

Load time so far: 0.2 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, agents WRITE;

Load time so far: 0.2 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 #48

Load time so far: 0.2 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.22 seconds.
Performing query: ALTER TABLE agents ADD traderrating int default '0' NOT NULL;

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD id int default '0' NOT NULL auto_increment;

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD name text NOT NULL;

Duplicate column name 'id'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE wsnlinks_switches ADD value int default '0' NOT NULL;

Duplicate column name 'name'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'value'

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD topicid int default '0' NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD postid int default '0' NOT NULL;

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 'ADD topicid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD type varchar(255) NOT NULL;

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 'ADD postid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD nature varchar(255) NOT NULL;

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 'ADD type varchar(255) NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD reason text NOT NULL;

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 'ADD nature varchar(255) NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD moderatorid int default '0' NOT NULL;

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 'ADD reason text NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD source int default '0' NOT NULL;

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 'ADD moderatorid int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD destination int default '0' NOT NULL;

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 'ADD source int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD time int default '0' NOT NULL;

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 'ADD destination int default '0' NOT NULL' at line 1

Load time so far: 0.28 seconds.
Performing query: ALTER TABLE ADD catid int default '0' NOT NULL;

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 'ADD time int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD memberid int default '0' NOT NULL;

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 'ADD catid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD id int default '0' NOT NULL auto_increment;

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 'ADD memberid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD type varchar(255) NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD objectid int default '0' NOT NULL;

Duplicate column name 'type'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filename varchar(255) NOT NULL;

Duplicate column name 'objectid'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filetitle varchar(255) NOT NULL;

Duplicate column name 'filename'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD filesize int default '0' NOT NULL;

Duplicate column name 'filetitle'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD width int default '0' NOT NULL;

Duplicate column name 'filesize'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD height int default '0' NOT NULL;

Duplicate column name 'width'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD memberid int default '0' NOT NULL;

Duplicate column name 'height'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD time int default '0' NOT NULL;

Duplicate column name 'memberid'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD deleted int default '0' NOT NULL;

Duplicate column name 'time'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD field varchar(255) NOT NULL;

Duplicate column name 'deleted'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD downloads int default '0' NOT NULL;

Duplicate column name 'field'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_attachments ADD validated int default '0' NOT NULL;

Duplicate column name 'downloads'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'validated'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD name varchar(255) NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD numsubjects int default '0' NOT NULL;

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 'ADD name varchar(255) NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD priority int default '0' NOT NULL;

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 'ADD numsubjects int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD id int default '0' NOT NULL auto_increment;

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 'ADD priority int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD subject varchar(255) NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD helptext text NOT NULL;

Duplicate column name 'subject'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD priority int default '0' NOT NULL;

Duplicate column name 'helptext'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_helpitem ADD category int default '0' NOT NULL;

Duplicate column name 'priority'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'category'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD frequency int default '0' NOT NULL;

Duplicate column name 'id'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD nextrun int default '0' NOT NULL;

Duplicate column name 'frequency'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD filename varchar(255) NOT NULL;

Duplicate column name 'nextrun'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_crons ADD native int default '0' NOT NULL;

Duplicate column name 'filename'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD id int default '0' NOT NULL auto_increment;

Duplicate column name 'native'

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD toid int default '0' NOT NULL;

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 'ADD id int default '0' NOT NULL auto_increment' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD fromid int default '0' NOT NULL;

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 'ADD toid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD message text NOT NULL;

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 'ADD fromid int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD time int default '0' NOT NULL;

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 'ADD message text NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD isread int default '0' NOT NULL;

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 'ADD time int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD timeread int default '0' NOT NULL;

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 'ADD isread int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE ADD deleted int default '0' NOT NULL;

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 'ADD timeread int default '0' NOT NULL' at line 1

Load time so far: 0.29 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE rating rating float default '0';

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 'ADD deleted int default '0' NOT NULL' at line 1

Load time so far: 0.3 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE lastedit lastedit int default '0';

Load time so far: 0.31 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE `time` `time` int default '0';

Load time so far: 0.31 seconds.
Performing query: ALTER TABLE agents CHANGE failedattempts failedattempts int default '0';

Load time so far: 0.32 seconds.
Performing query: ALTER TABLE agents CHANGE `time` `time` int default '0';

Load time so far: 0.33 seconds.
Performing query: UPDATE agents SET time='0' WHERE time='{TIME}';

Load time so far: 0.33 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canemailmembers canemailmembers int default '0';

Load time so far: 0.34 seconds.
Performing query: ALTER TABLE wsnlinks_membergroups CHANGE canusehtml canusehtml int default '0';

Load time so far: 0.35 seconds.
Performing query: ALTER TABLE wsnlinks_links CHANGE funds funds FLOAT DEFAULT '0' NOT NULL;

Load time so far: 0.35 seconds.
Performing query: ALTER TABLE wsnlinks_ratings CHANGE `id` `id` INT( 11 ) DEFAULT '0' NOT NULL AUTO_INCREMENT;

Load time so far: 0.38 seconds.
Performing query: SELECT name FROM wsnlinks_switches WHERE id>0 ;

Number of rows is 57 for Resource id #67

Load time so far: 0.38 seconds.
Performing query: INSERT INTO wsnlinks_switches(id,name,value) VALUES('', 'trader', '1');

Load time so far: 0.38 seconds.
Performing query: UPDATE agents SET notifyoflinks='no' WHERE notifyoflinks = '';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET lastedit='0' WHERE lastedit='time';

Load time so far: 0.39 seconds.
Performing query: DELETE FROM wsnlinks_settings WHERE name='sitemap';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_categories SET permissions='' WHERE permissions NOT LIKE '%[GROUP]%';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET hitsinips='' WHERE hitsinips NOT LIKE '%[,]%';

Load time so far: 0.39 seconds.
Performing query: UPDATE wsnlinks_links SET hitsoutips='' WHERE hitsoutips NOT LIKE '%[,]%';

Load time so far: 0.39 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 parentids != '' ;

Number of rows is 0 for Resource id #68

Load time so far: 0.39 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 moderators != '' ;

Number of rows is 3 for Resource id #69

Load time so far: 0.41 seconds.
Performing query: SELECT agent_id FROM agents WHERE username = 'max.chirkov' ;

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_categories SET moderators=', 8, ' WHERE id=5;

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_settings SET content='' WHERE name='excludedtoadmin';

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_categories SET type='regular' WHERE type='';

Load time so far: 0.41 seconds.
Performing query: UPDATE wsnlinks_comments SET type='regular' WHERE type='';

Load time so far: 0.41 seconds.
Performing query: UPDATE agents SET allowuseremail='yes' WHERE allowuseremail='';

Load time so far: 0.42 seconds.
Performing query: UPDATE agents SET allowemail='yes' WHERE allowemail='';

Load time so far: 0.43 seconds.
Performing query: SELECT hits,hitsin FROM wsnlinks_links WHERE hide=0 AND validated=1 ;

Number of rows is 8 for Resource id #71

Load time so far: 0.43 seconds.
Performing query: SELECT id FROM wsnlinks_comments WHERE validated=1 AND hide=0 ;

Number of rows is 0 for Resource id #72

Load time so far: 0.43 seconds.
Performing query: SELECT agent_id FROM agents WHERE validated=1 ;

Number of rows is 121 for Resource id #73

Load time so far: 0.43 seconds.
Performing query: SELECT lastedit FROM wsnlinks_links WHERE validated=1 AND hide=0 ORDER BY lastedit DESC LIMIT 0,1;

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='8' WHERE name='totallinks';

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalcomments';

Load time so far: 0.43 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalhitsin';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='0' WHERE name='totalhits';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='121' WHERE name='totalmembers';

Load time so far: 0.44 seconds.
Performing query: UPDATE wsnlinks_settings SET content='1142612375' WHERE name='lastupdate';

Load time so far: 0.44 seconds.
Performing query: SELECT stylesheet FROM agents WHERE level=3 ;

Load time so far: 0.44 seconds.
Performing query: SELECT numsub FROM wsnlinks_categories WHERE id>0 ORDER BY numsub DESC LIMIT 0,1;

Load time so far: 0.44 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 id>0 ;

Number of rows is 3 for Resource id #77

Load time so far: 0.45 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 AND deleted=0 ;

Number of rows is 0 for Resource id #78

Load time so far: 0.45 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=3;

Load time so far: 0.46 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0 ;

Number of rows is 0 for Resource id #79

Load time so far: 0.46 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=4;

Load time so far: 0.46 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE parent=5 AND validated=1 AND hide=0 AND deleted=0 ;

Number of rows is 0 for Resource id #80

Load time so far: 0.46 seconds.
Performing query: UPDATE wsnlinks_categories SET numsub='0' WHERE id=5;

Load time so far: 0.46 seconds.
Performing query: SELECT name,content FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC ;

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 2 for Resource id #86

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 0 for Resource id #87

Load time so far: 0.57 seconds.
Performing query: SELECT id,name,parentids,parentnames FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC ;

Number of rows is 0 for Resource id #88

Load time so far: 0.57 seconds.
Performing query: UPDATE wsnlinks_settings SET content='3,4' WHERE name='sitemaporder';

Load time so far: 0.57 seconds.
Performing query: UPDATE wsnlinks_settings SET content='<option value="3"> Vol 29 #13 - April</option><option value="4"> Vol 30 #01 - May</option>' WHERE name='categoryselector';


So, I'm confused now... does it has to do with my host that upgrade.php gives me blank page or with my custom fields added to the database? Or it's something wrong with the actual file?
Mar 22, 2006 - 9:59 AM Paid Scripts Support
RSS feed for the Forum? gemini I can not find an RSS feed for this forum. Is there one? Mar 21, 2006 - 10:10 PM Paid Scripts Support
Listing hidden after payment is received gemini Every time someone pays for sponsorship or whatever - their Hide link status changes to yes.

I don't mind changing them back, but it is a pain to find them after they disappear or actually know that they disappear until onwer writes you an angry email smiling face

I think I need to add to feature list:
Sponsorship management list. To be able to montior all the exparations, payments etc.etc. Also ability to setup automated notices prior to exparation would be nice too. I'm sure I can create a custom page to monitor all payments, but I still think it need a whole section to itself.
Mar 21, 2006 - 9:47 PM Paid Scripts Support
HTML code in a custom field gemini I have a custom text field that contain an HTML code. The field in not available to the memberst to alter. Only admin can access this field.

Every time a member edits their listing and I approve it - the HTML code displaid on the page from that field is visible. To fix it - I just go to edit link, and save without any changes - turns back into what it was. What's up with that?
Mar 21, 2006 - 9:36 PM Paid Scripts Support
Page Rank feature dead gemini do you mean Google API key? Google never provided any ability to query PR with third party tools - all the tools available out there are results of reversed engineering and mine is not an exception. Mar 21, 2006 - 9:30 PM Paid Scripts Support
gemini I have three small requests, not sure if locals will find them necessary:

1. Ability to hook up custom plugins for developers (I think this is good for the software too)
2. Payment Instructions and Reply Optins - I have 3 different payment options for different services and would be nice to have a dropdown or checkbox list (I prefer checkbox list) option to send specific payment instruction with acceptance or pre-set rejection reason on the custom accept/reject pages. Would be even nicer if selected reason appeared in the email body and you are still able to add your custom message. Manually I created reasons in the Language section and retreave them on the accept/reject page - but everything being messed up after ever update when I have to copy admin folder over.
3. Stats for link detail page accessable from member's profile. Link detail page is poor redundant copy of a listing. Utilizing the space and adding more stuff to it makes a lot of sense. So I add custom content to that page (member's provide the content) and it actually ranks in search results and drives some targeted traffic. I used third party service to track visitors for a couple of such pages. Here is an example (scroll down and click View My Stats):
http://www.ibsteam.net/wsnlinks/links/detail/2008
http://www.ibsteam.net/wsnlinks/links/detail/328
Would be nice to have such stats available in-house for the members.
Mar 21, 2006 - 9:23 PM Paid Scripts Support
Page Rank feature dead gemini Paul I found it impossible to PM you... anyways I have a PHP source code (not mine but publically available) that I'm using to get PR. I save PR data in a database and run an updater (kinda like counter regenerator) every month of whenever PR update is goin on. It can be live, but I don't want to query Google hundred thousand times a day.

I can email it to you if you want to. I add a little button to check PR of the pending submissions and one on the edit page.

Let me know.
Mar 21, 2006 - 9:07 PM Paid Scripts Support
Messed up _email table gemini o-o, do I need to download a new update now?
Paul, how about creating a plugin module or something - I have to add all my custom functions manually every time I update the script. Then we could share our plugins too. Kinda like Wordpress does.
Mar 16, 2006 - 4:50 PM Paid Scripts Support
Messed up _email table gemini I'm just trying to send email from the admin panel to a specific member with specific email address. Mar 15, 2006 - 3:01 PM Paid Scripts Support
How many WSN Links installs do you run? gemini I have 2 licenses - 1 for 3 WSN Links installations and 1 for WSN Knoledgebase (not sure how many installations though). I haven't tried the knowledgebase yet.

Paul, take a look at Wordpress. I think your software could be as popular! Its just that you target very limited audience. What is hot today? What are the new trends? Blogging, iPods, Podcasting, Vodcasting, RSS, Web2.0(/tagging/pinging, GoogleBase, GoogleEarth, GoogleVideo) blah blah blah - that actually covers the widest online audience in the world today. Check this out http://mymomsblog.blogspot.com/ she is 80 years old and bogging, and vodcasting. Your products are great, flexible and easy to use. Its great for a newbie and for a developer. You have a couple of products running together that are easy to integrate together. Its really great for us who know at least something and can tweak it on their own, but not for the wide public. So, tune into the modern trends and I'm pretty sure people will start using your products. Make limited versions for free - can you imagine what will happen if bloggers will find it easy to integrate with their Wordpress/Blogger/Typepad/Drupal/WSNBlog/younameit... I think you'll be ahead of many developers out there because you already have number of products that are community directed and can be all merged and integrated together. Target the wider audience. Just imagine if boggers and podcasters start talking about your free (limited license) software and how easy to use and integrate with anything.

I think you need to get some help to design everything in CSS, then you can have extensive libraty of templates like Wordpress, Blogger etc do. Honestly speaking, I feel more secure with less people using your product smiling face I feel like I've got something in a black bag and people have no clue what it is, they know it is my secret wheapon and they already scared of it smiling face

..don't miss the boat man!
Mar 14, 2006 - 2:06 PM Paid Scripts Support
Messed up _email table gemini I have a similar problem


Load time so far: 0.14 seconds.
Performing query: SELECT COUNT(*) FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ; Count is 1

Load time so far: 0.15 seconds.
Performing query: SELECT id,email FROM agents WHERE email = 'max@sc.rr.com' AND allowemail != 'no' AND validated=1 AND banned='' ORDER BY id ASC LIMIT 0,20000;


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/zaemxlth/public_html/ads/classes/database.php on line 108

Number of rows is for Unknown column 'id' in 'field list'

Sending e-mail titled to , From: c21ccp@sc.rr.com with replacements member for and mime setting 1. Contents: Use any member template variables in this message that you want to use to show info about the member. When linking to something on your site, be sure to use http://www.c21coastallifestyles.net/ads in front of the file name so that you'll have an absolute path. Now, replace this text with the actual message you want to send.

Load time so far: 0.2 seconds.
Performing query: INSERT INTO wsnlinks_email(id,`to`,subject,message,headers,timesent,ip,replacement,mime) VALUES('','','','Use any member template variables in this message that you want to use to show info about the member. When linking to something on your site, be sure to use http://www.c21coastallifestyles.net/ads in front of the file name so that you'll have an absolute path. Now, replace this text with the actual message you want to send. ','From: c21ccp@sc.rr.com','0','70.60.214.13','member for ','1');

Unknown column 'id' in 'field list'


but since I used integration my id filed is different and it is mentioned in the integration config file as newid. Looks like its not propagating correctly into the email script..
Mar 14, 2006 - 12:41 PM Paid Scripts Support
integration with custom application gemini Paul,

when I logged in these are the cookies that active:
wsnuser
wsnpass
returnto
testcookie
PHPSESSID

When I logout from my own backend these are the cookies that are still active:
returnto
testcookie

I tried deleting them, but my name is still showing as logged in. Here is what I do to watch it: I open my backend in one window and wsnlinks in another one. I login from my backend and open members page in wsnlinks. WSNLinks shows members pannel at the top right corner. When I logout from my backend, I go an refresh the members page at the WSNLinks - the pannel disappears, but my name stays. I can login under different names into my own backend and logout - all those people will be on the WSNLinks members page and currently logged in, but kinda not from current PC.. weird. I feel like I'm not clearing something right.

Thanks for all your help man! I know you have better things to do smiling face
Mar 07, 2006 - 8:28 AM Paid Scripts Support
integration with custom application gemini ..well, I didn't have one, so I thought if it creates this filed it should work. Anyways, trying to specify &newusergroup = 'usergroup'; didn't work either.. weird. I deleted the column and created a new one with name 'level' - then specified it in the config file and everything started working smiling face Thanks Paul!

As for logining out from my own application. I'm deleting wsnuser and wsnpass cookies, but even though I'm logged out and can not access things as logged user, my name is still appearing as currently logged. Should I clear something else too when login out?
Mar 03, 2006 - 7:49 AM Paid Scripts Support
Narrow results to results containing

Link to these search results