Search found 120 matches

by captquirk
Sun Jun 23, 2019 6:07 pm
Forum: Sphider Help
Topic: Sphider Backup Tips
Replies: 0
Views: 47

Sphider Backup Tips

Sphider comes with the ability to backup and restore your database. How well this works depends on not only the size of the database, but on your MySQL settings. The restore could restore a single record at a time, but this would be time consuming. It would be reliable, but for a larger database you...
by captquirk
Sun Jun 16, 2019 8:55 pm
Forum: Announcements
Topic: Sphider 3.2.0-MB released
Replies: 0
Views: 48

Sphider 3.2.0-MB released

Sphider 3.2.0-MB has been released. A fix was made to correct missing keyword-link relationships. New features are the ability to set a minimum score for search results and the ability to use a 5 star system to rank the relevancy of results. I-frame support has been added.
by captquirk
Thu Jun 13, 2019 1:45 am
Forum: Sphider Help
Topic: Embed Search Box and Results In Another Web Page
Replies: 1
Views: 75

Re: Embed Search Box and Results In Another Web Page

You can easily embed the query on any page, but the results will appear on the search.php page. Another approach is to customize the search.php page. Instead of embedding search.php on your page, you are embedding your content in search.php. You can still have query boxes on other pages, with result...
by captquirk
Mon May 27, 2019 9:08 pm
Forum: Sphider Help
Topic: HOW can I get the ER diagram of sphider?
Replies: 2
Views: 130

Re: HOW can I get the ER diagram of sphider?

A note concerning the prior post: MySQL Workbench has a reverse engineering toll which is SUPPOSED to build a more proper ER diagram, but it fails to draw the actual relationships. The reason MySQL Workbench is unable to draw the relationships is because the SQL instructions which build the tables d...
by captquirk
Sun May 26, 2019 7:41 pm
Forum: Sphider Help
Topic: HOW can I get the ER diagram of sphider?
Replies: 2
Views: 130

Re: HOW can I get the ER diagram of sphider?

erd.png This is no where near a proper ER, but it should give an idea of what's what. The settings table stands on its own and controls the workings of the admin, spidering, and search functionality. The sites table has the details of each site in the catalog. The site_id connects it to the images ...
by captquirk
Sat May 25, 2019 12:49 am
Forum: Sphider Help
Topic: Whatever happened to the Sphiders for SQLite and PostgreSQL?
Replies: 0
Views: 79

Whatever happened to the Sphiders for SQLite and PostgreSQL?

Sphider did have forks which supported SQLite and PostgreSQL in lieu of MySQL/MariaDB. These were forks of the PDO version of Sphider and have not been updated since version 2.1 in November of 2018. There are no plans to resume work on these because of very limited demand. While they are no longer p...
by captquirk
Thu May 16, 2019 6:06 pm
Forum: Sphider Help
Topic: Your demo not working
Replies: 1
Views: 152

Re: Your demo not working

Typo.
Fixed.
Thank you.
by captquirk
Thu May 16, 2019 12:33 am
Forum: Sphider Help
Topic: can't indexing a lot of sites
Replies: 3
Views: 203

Re: can't indexing a lot of sites

Sphider 3.1.1-MB eliminates the need for the troublesome removeAccents() function. Rather than trying to force the word to conform to an all too English "a to z" alphabet check, the word is now compared to a unicode alphabetical check. The function had outlived its original purpose, which was for si...
by captquirk
Wed May 15, 2019 6:22 pm
Forum: Sphider Help
Topic: can't indexing a lot of sites
Replies: 3
Views: 203

Re: can't indexing a lot of sites

Looking at it... Which version of Sphider are you using? UPDATE: If you are using Sphider 3.1.0, try this: In commonfuncs.php, replace lines 404-423 $table = array( 'Š'=>'S', 'š'=>'s', 'Ð'=>'Dj', 'đ'=>'dj', 'Ž'=>'Z', 'ž'=>'z', 'Ć'=>'C', 'ć'=>'c', 'Č'=>'C', 'č'=>'c', 'À'=>'A', 'Á'=>'A', 'Â'=>'A', 'Ã'...
by captquirk
Mon May 13, 2019 10:32 pm
Forum: Announcements
Topic: Sphider 3.1.0-MB and Sphider 2.4.2-PDO released
Replies: 0
Views: 132

Sphider 3.1.0-MB and Sphider 2.4.2-PDO released

Sphider 3.1.0-MB is multibyte capable, like 3.0.0-MB. However, 3.1.0-MB does NOT require the PHP mbstring extension. Mbstring is recommended, but not required. If it is available, it will be used. If not, Sphider will emulate the mulitbyte character string functions. Also, 3.1.0-MB continues the imp...