MaxWebPortal Version 1.350    Release date: June 18, 2004    Author: Max Yuan
 
Table of Contents
  1. Introduction
  2. Quick Installation
  3. New Installations
    1. Requirements
    2. Installing on MS Access 97, 2000, 2002 Server
    3. Installing on MS SQL Server
    4. Installing on MySQL Server
  4. Upgrade from Previous Versions
  5. Post-Install Tasks
  6. Frequently Asked Questions
  7. Contact Info
  8. Copyright and Disclaimer
  9. Conclusion
  10. Bonus Section
1. Introduction

MaxWebPortal is a web portal and online community system which includes advanced features such as web-based administration, poll, private/public events calendar, user customizable color themes, classifieds, user control panel, online pager, link, file, article, picture managers and much more. Easy-to-use and powerful user interface allows members to add news, content, write reviews and share information among other registered users.

To see a list of the new features included in this release, please visit our website at www.maxwebportal.com.

MaxWebPortal has been designed to be as easy to install as possible. Follow these instructions and you should have no problems. If you do encounter any problems installing MaxWebPortal, please feel free to contact us.

2. Quick Installation

If you are sure that your hosting service or server will run MaxWebPortal or have previously used MaxWebPortal, you can use these steps to quickly get started. For a more detailed explanation please go to the next section.

  1. Run MaxWebPortal installer to extract the files to a local directory on your computer.


  2. Modify config.asp as instructed in the file.


  3. Upload all files (except your database) to a web accessible directory on your server or hosting account.


  4. Upload the database (db2000.mdb for access 2000) to a directory that has read and write permission.


  5. Open your favorite browser and run site_setup.asp. example: http://www.yourwebsite.com/site_setup.asp
You have now finished setting up MaxWebPortal on your server. It is highly recommended that you read Post-Install Tasks section.
3. New Installations
3.i. Requirements
  • Operating System: Windows 95, Windows 98, Windows ME, Windows NT 4.x, Windows 2000, Windows XP Pro, Windows Server 2003, Linux
  • Database System: Access 97, Access 2000, Access 2002, Access 2003, SQL Server 6.5, SQL Server 7, SQL Server 2000, MySQL (not fully supported)
  • ASP Support: Internet Information Server 4, Internet Information Server 5, Internet Information Server 5.1, Information Server 6, Personal Web Server, Apache with ASP support
3.ii. Installing on MS Access 97, 2000, 2002 Server

Please read this section thoroughly before proceeding with installation.

  1. Run MaxWebPortal installer to extract the files to a local directory on your computer.

  2. Open config.asp in your favorite text editor. example: notepad
    Do not use Microsoft Word or Microsoft Frontpage to edit these files as each might corrupt the file.


  3. Change the strConnString variable with the correct path to where your database file (*.mdb) is going to be on the server. If you are unsure of which strConnString to use, please use the default one.

  4. example: C:\Inetpub\database\db2000.mdb

  5. Upload all files (except your database) to a web accessible directory on your server or hosting account.


  6. Choose the right database file. If you are using MS Access 2000, or 2002 use the database file included in the package (database/db2000.mdb). If you are using MS Access 97 please download the Access 97 compatible database from our website.


  7. Upload the database to a directory that has read and write permission. Make sure this directory is not accessible by anonymous visitors to prevent people from downloading your database.


  8. Open your favorite browser and run site_setup.asp. example: http://www.yourwebsite.com/site_setup.asp

You have now finished setting up MaxWebPortal on your server. Please read Post-Install Tasks section.

3.iii. Installing on MS SQL Server

Please read this section thoroughly before proceeding with installation.

  1. Run MaxWebPortal installer to extract the files to a local directory on your computer.


  2. Open config.asp in your favorite text editor. example: notepad
    Do not use Microsoft Word or Microsoft Frontpage to edit these files as each might corrupt the files.


  3. Comment out the strDBType = "access" line and uncomment the strDBType = "sqlserver" line.


  4. Comment out the access 2000 strConnString line and uncomment the SQL Server strConnString line. Complete the strConnString line with the correct values.

  5. example: strConnString = "driver={SQL Server};server=127.0.0.1;uid=username;pwd=password;database=dbsql"


  6. Upload all files to a web accessible directory on your server or hosting account.


  7. There are two ways to create a MS SQL database choose one that is the easiest to understand for you.


    • Open the access database file included in the package (database/db2000.mdb) with MS Access. Go to the Tools menu, select Database utilities then click Upsizing Wizard. Follow the wizard and enter in the information asked in each screen.
    • Do not use triggers. See detail in FAQ Forum.

    • Create a new database called db2000 (You may rename it later). Open Query Analyzer and select the database (db2000) you just created. Go to Files, Open query file, then execute the database creation script (Create_db.sql). Upon successful execution open the second script to populate the default data (Default_data.sql), and execute the script. The SQL scripts are not included in this package, you can download it from our websitee.

  8. Open your favorite browser and run site_setup.asp. example: http://www.yourwebsite.com/site_setup.asp

You have now finished setting up MaxWebPortal on your server. Please read Post-Install Tasks section.

3.iv. Installing on MySQL Server

MySQL Server is not fully supported by MaxWebPortal at this time. However some people have been able to convert the access database to MySQL successfully. For more information please visit our Support Forum.

4. Upgrade from Previous Versions

This section is only for intermediate users who know exactly what they are doing.
Backup all your files and database before proceeding with the installation.

Version 1.340 to Version 1.350
  • Replace the following files:
    topic.asp
    privatesend_info.asp
    privatedelete.asp
    pop_profile.asp
    pop_lock.asp
    pop_delete.asp
    pop_avatar_delete.asp
    pop_announce_delete.asp
    events_functions.asp
    register.asp
    post_info.asp
    pm_pop_privatesend_info.asp
    pop_send_to_friend.asp
    cp_config.asp
    custom_link.asp
    inc_functions.asp
    pm_pop_send.asp
    pm_view.asp
    admin_login.asp
    pop_memberlist.asp
    forum.asp

Version 1.330 to Version 1.340

  • Replace the following files:
    bookmark.asp
    inc_functions.asp (change cint to clng on line 1074 and line 1112)
    password.asp
    pop_profile.asp
    privateread.asp
    article_add_form.asp
    dl_add_form.asp
    classified_add_form.asp
    links_add_form.asp
    pic_add_form.asp

Version 1.320 to Version 1.330

  • Replace the following files:
    admin_announce_add.asp
    inc_mail.asp
    admin_config_email.asp
    pic_showall.asp
    classified_showall.asp
    article_showall.asp
    dl_showall.asp
    links_showall.asp
    pm_pop_privatesend_info.asp
    privatesend_info.asp
    archive.asp
    archive_display.asp
    search.asp
    inc_top_short.asp
    statisticsx.asp
    admin_article_approve.asp
    admin_article_deletearticle.asp
    admin_classified_deleteurl.asp
    admin_classified_errorreport.asp
    admin_dl_deleteurl.asp
    admin_dl_showbadlink.asp
    admin_down.asp
    admin_events.asp
    admin_links_approve.asp
    admin_links_deleteurl.asp
    admin_links_showbadlink.asp
    admin_pic_approve.asp
    admin_pic_deletepic.asp
    admin_pic_showbadlink.asp
    article_read.asp
    classified_error.asp
    dl_goto.asp
    pic_display.asp
    policy.asp
    pop_mail.asp
    pop_messengers.asp
    pop_profile.asp
    privatesend.asp
    down.asp
    inc_functions.asp
    pm_pop_send.asp
    register.asp
    topic.asp
    pic_show.asp
    inc_poll.asp
    inc_footer_short.asp
    forum.asp
    post.asp
    inc_nav_bar.asp
    inc_top.asp
    inc_theme.asp
    article_search.asp
    classified_search.asp
    links_search.asp
    dl_search.asp

Version 1.310 to Version 1.320

  • Add or replace the following files:
    inc_services.asp
    inc_functions.asp
    pop_profile.asp
    topic.asp

Version 1.300 to Version 1.310

  • Replace the following files:
    article_add_form.asp
    search.asp
    statistics.asp
    statisticsx.asp
    pic_new.asp
    article_new.asp
    dl_new.asp
    links_new.asp
    article_rate.asp
    dl_rate.asp
    dl_error.asp
    links_error.asp
    classified_error.asp
    pic_rate.asp
    links_rate.asp
    article_showall.asp
    dl_showall.asp
    links_showall.asp
    pic_showall.asp
    article_showsub.asp
    classified_showsub.asp
    dl_showsub.asp
    links_showsub.asp
    pic_showsub.asp
    dl_comments.asp
    dl_info.asp
    links_comments.asp
    pic_show.asp
    pic_display.asp
    pic_pop_share.asp
    bookmark.asp
    privateread.asp
    privatesent.asp
    pm_pop_delete.asp
    pm_pop_read.asp
    cp_config.asp
    pic_add.asp
    pop_announce_delete.asp
    pop_memberlist.asp
    pop_avatar_delete.asp
    pop_open.asp
    pop_lock.asp
    pop_event.asp
    classified_showall.asp
    admin_classified_browse.asp
    classified_new.asp
    admin_classified_main.asp
    admin_classified_step1update.asp
    classified_info.asp
    admin_classified_editurl.asp
    inc_top_short.asp
    inc_news.asp
    news.asp
    pop_delete.asp
    inc_lasttopics.asp
    pm_view.asp
    inc_top.asp
    active_users.asp
    dl_goto.asp
    admin_emaillist.asp
    inc_profile.asp
    privatesend.asp
    pm_pop_send.asp
    events_functions.asp
    article_read.asp
    admin_forums.asp
    post_info.asp
    pic_search.asp
    classified_search.asp
    article_search.asp
    dl_search.asp
    privatesend_info.asp
    password.asp
    register.asp
    links_search.asp
    topic.asp
    inc_footer.asp
    forum.asp
    post.asp

Version 1.230 to Version 1.300

  • Add new table CLASSIFIED
    • Add new column CLASSIFIED_ID (Field type: Autonumber)
    • Add new column TITLE (Field type: Text, Field Size:100)
    • Add new column POSTER (Field type: Text, Field Size:200)
    • Add new column EMAIL (Field type: Text, Field Size:100)
    • Add new column ADDRESS (Field type: Text, Field Size:100)
    • Add new column CITY (Field type: Text, Field Size:100)
    • Add new column STATE (Field type: Text, Field Size:100)
    • Add new column ZIPCODE (Field type: Text, Field Size:50)
    • Add new column DESCRIPTION (Field type: Memo)
    • Add new column PRICE (Field type: Text, Field Size:100)
    • Add new column KEYWORD (Field type: Text, Field Size:255)
    • Add new column LINK (Field type: Text, Field Size:255)
    • Add new column IMAGELINK (Field type: Text, Field Size:255)
    • Add new column POST_DATE (Field type: Text, Field Size:50)
    • Add new column END_DATE (Field type: Text, Field Size:50)
    • Add new column HITS (Field type: Long Integer, Field Size:0)
    • Add new column CATEGORY (Field type: Long Integer)
    • Add new column PARENT_ID (Field type: Long Integer)
    • Add new column SHOW (Field type: Long Integer)
    • Add new column BADLINK (Field type: Long Integer)

  • Add new table CLASSIFIED_CATEGORIES
    • Add new column CAT_ID (Field type: Autonumber)
    • Add new column CAT_NAME (Field type: Text, Field Size:100)
    • Add new column DESCRIPTION (Field type: Memo)

  • Add new table CLASSIFIED_SUBCATEGORIES
    • Add new column SUBCAT_ID (Field type: Autonumber)
    • Add new column SUBCAT_NAME (Field type: Text, Field Size:100)
    • Add new column CAT_ID (Field type: Long Integer)

  • Add new table PORTAL_POLLS
    • Add new column POLL_ID (Field type: Autonumber)
    • Add new column POLL_TYPE (Field type: Text, Field Size:100)
    • Add new column POLL_ALLOW (Field type: Long Integer)
    • Add new column POLL_QUESTION (Field type: Text, Field Size:50)
    • Add new column ANSWER1 (Field type: Text, Field Size:50)
    • Add new column ANSWER2 (Field type: Text, Field Size:50)
    • Add new column ANSWER3 (Field type: Text, Field Size:50)
    • Add new column ANSWER4 (Field type: Text, Field Size:50)
    • Add new column ANSWER5 (Field type: Text, Field Size:50)
    • Add new column ANSWER6 (Field type: Text, Field Size:50)
    • Add new column ANSWER7 (Field type: Text, Field Size:50)
    • Add new column ANSWER8 (Field type: Text, Field Size:50)
    • Add new column ANSWER9 (Field type: Text, Field Size:50)
    • Add new column ANSWER10 (Field type: Text, Field Size:50)
    • Add new column ANSWER11 (Field type: Text, Field Size:50)
    • Add new column ANSWER12 (Field type: Text, Field Size:50)
    • Add new column RESULT1 (Field type: Long Integer)
    • Add new column RESULT2 (Field type: Long Integer)
    • Add new column RESULT3 (Field type: Long Integer)
    • Add new column RESULT4 (Field type: Long Integer)
    • Add new column RESULT5 (Field type: Long Integer)
    • Add new column RESULT6 (Field type: Long Integer)
    • Add new column RESULT7 (Field type: Long Integer)
    • Add new column RESULT8 (Field type: Long Integer)
    • Add new column RESULT9 (Field type: Long Integer)
    • Add new column RESULT10 (Field type: Long Integer)
    • Add new column RESULT11 (Field type: Long Integer)
    • Add new column RESULT12 (Field type: Long Integer)
    • Add new column POST_DATE (Field type: Text, Field Size:50)
    • Add new column END_DATE (Field type: Text, Field Size:50)
    • Add new column POLL_AUTHOR (Field type: Long Integer)

  • Add new table PORTAL_POLL_ANS
    • Add new column ANS_ID (Field type: Autonumber)
    • Add new column POLL_ID (Field type: Long Integer)
    • Add new column ANS_VALUE (Field type: Text, Field Size:255)
    • Add new column MEMBER_ID(Field type: Long Integer)
    • Add new column ANS_DATE (Field type: Text, Field Size:50)
    • Add new column IP (Field type: Text, Field Size:50)

  • Add new column C_STRNEWREG into the PORTAL_CONFIG table. (Field Size: Integer, Default Value: 1)
  • Add new column C_POLLCREATE into the PORTAL_CONFIG table. (Field Size: Integer, Default Value: 0)
  • Add new column C_FEATUREDPOLL into the PORTAL_CONFIG table. (Field Size: Integer, Default Value: 0)
  • Add new column C_STRQUICKREPLY into the PORTAL_CONFIG table. (Field Size: Integer, Default Value: 0)
  • Add new column PENDING into the PORTAL_EVENTS table. (Field Size: Long Integer)
  • Add new column T_SIG into the PORTAL_TOPICS table. (Field Size: Long Integer, Default Value: 1)
  • Add new column T_POLL into the PORTAL_TOPICS table. (Field Size: Long Integer, Default Value: 0)
  • Add new column R_SIG into the PORTAL_REPLY table. (Field Size: Long Integer, Default Value: 1)
  • Rename C_STRFORUMTITLE to C_STRSITETITLE in PORTAL_CONFIG
  • Rename PORTAL_COLOURS table to PORTAL_COLORS
  • Change PORTAL_MEMBERS.M_PASSWORD field size to 100
  • Change PORTAL_MEMBERS_PENDING.M_PASSWORD field size to 100
  • Remove old POLL fields from PORTAL_TOPICS *this is not mandatory

Use the default values if not specified.
All asp files must be replaced.

  • Save encryption.asp to your MaxWebPortal folder and run it. You can download it from our website.

Version 1.x to Version 1.230

  • Add new column C_STREMAILVAL into the FORUM_CONFIG table. (Field Size: Integer, Default Value: 0)


  • Add new column M_KEY into the FORUM_MEMBERS table. (Field Size: 20, Allow Zero Length: Yes)


  • Add new column M_NEWEMAIL into the FORUM_MEMBERS table. (Field Size: 50)


  • Copy the FORUM_MEMBERS table and paste as FORUM_MEMBERS_PENDING. (Paste option: Structure Only)


  • Open your database and change all table names that begin with FORUM_ to PORTAL_.
Use the default values if not specified.
All asp files must be replaced.
5. Post-Install Tasks

Once you have successfully installed MaxWebPortal log in as admin, click the Admin Options link located on left menu. Log in again, to access the admin control panel.

Username: admin
Password: admin

Remember to change the default admin password by clicking on the Profile link in your Control Panel. For additional security, it is recommended to move your access database file to a private folder and rename the file. example: neptune.mdb
Please take your time and go through every option in the admin control panel

6. Frequently Asked Questions

Q: I got this error message "Operation Must Use An Updatable Query" on the bottom of every page, how do I fix it?
A: This error is typically encountered when Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permission on the database. Give read and write permission to the directory where the database file is stored.

Q: How do I find the physical path of my database?
A: Run the path locator script. It will tell you the physical path of where the script is on the server.

Q: Where can I download Mods/Hacks for MaxWebPortal?
A: You can download them from this page.

Q: I'm running MaxWebPortal on a Non-US English server, the events calendar is not displayed properly. How can I fix it?
A: Open config.asp in your favorite text editor.  Change Session.LCID = 1033 to Session.LCID = 1036 (French). To find the LCID of your country please visit this site.

Q: The graphical table borders is not displayed properly on my browser. What should I do?
A: Replace inc_theme.asp with inc_theme_old.asp (html based table borders)

Q: How can I make a donation to your organization?
A: You can send your donation to this PayPal account webmaster@maxwebportal.com or click this button.

For more frequently asked questions please visit our FAQ Forum.

7. Contact Info

Website: www.maxwebportal.com
Support Forum: www.maxwebportal.com/forum.asp
Email: webmaster@maxwebportal.com
Private Message: Send Private Message
ICQ: 148111300 note this is not the secret word ;-) keep looking
Please post your support questions in one of the forums as we cannot provide individual support by email or private message.

8. Copyright and Disclaimer

This package and its contents are Copyright 2001 - 2004 MaxWebPortal.com All Rights Reserved. By downloading this program, you are agreeing to the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or any later version. All copyright notices regarding MaxWebPortal must remain intact in the scripts and in the outputted HTML. The "powered by" text/logo with a link back to http://www.maxwebportal.com in the footer of the pages MUST remain visible when the pages are viewed on the internet or intranet. This program contains a modified version of Snitz Forums 2000. The "powered by" text/logo with a link back to http://forum.snitz.com/ MUST also remain visible when the pages are viewed on the internet or intranet. MaxWebPortal and Snitz Forums 2000 are both open source programs distributed under GNU General Public License.

9. Conclusion
Thanks for using MaxWebPortal we hope you find it useful. If you have any problems with the installation process or have suggestions for us, feel free to join the discussions in our Forums.
President:
Max Yuan (Droiyan)

Project Director:
Max Yuan (Droiyan)

Community Management:
Max Yuan (Droiyan), theharmonyguy, Balrog, J.W. Breeden (LiveTiger951)

Graphical Design:
Jamie

Special Thanks to:
Balrog,
D.S. Angell (Darkangel),  Darklord, Don Newman (Ghostdev), Joey A. Tyson (theharmonyguy), Jamie, JediKnight, Iacopo Dondarini (Idonda), Hawk, Ironhead, J.W. Breeden (LiveTiger951), Jason R. Connor (LanPartyz), Oakridgecommunity, PCAKen, Pedro Boleo (Pboleo), Pierre, TAW, SkyDogg, Timhunold, Snitz Forums 2000 and ALL FANS OF MAXWEBPORTAL...

10. Bonus Section

There's a NEW! secret word hidden somewhere in this page. The first person who finds it will receive a BIG prize. If you think you found it, send a private message to secret with the word in your message and explain how you found it. (Registered MaxWebPortal.com members Only.)


MaxWebPortal Setup Instructions | 06/18/2004 9:46:21 PM | Latest Version 2001- 2004 Max Yuan and MaxWebPortal.com All Rights Reserved