Forums / Cotonti / Support / SQL Error!

Well i did read it but i did not understand:



How do I install XsAFF?
Updated: Wednesday 09th of May 2007 08:16 PM Asked By: Xiode

Upload
__________________________________________________________
FOLDERSwww/plugins/xsaff/ => plugins/xsaff/
www/plugins/xsaff/lang/ => plugins/xsaff/lang/
www/plugins/xsaff/affimg/ => plugins/xsaff/affimg/
www/plugins/xsaff/inc/ => plugins/xsaff/inc/
www/plugins/xsaff/inc/fonts => plugins/xsaff/inc/fonts
___________________________________________________________
FILES
___________________________________________________________
www/plugins/xsaff/xsaff.php => plugins/xsaff/xsaff.php
www/plugins/xsaff/xsaff.setup.php => plugins/xsaff/xsaff.setup.php
www/plugins/xsaff/xsaff.tpl => plugins/xsaff/xsaff.tpl
www/plugins/xsaff/xsaff.copy.php => plugins/xsaff/xsaff.copy.php
www/plugins/xsaff/xsaff.header.php => plugins/xsaff/xsaff.header.php
www/plugins/xsaff/xsaff.admin.php => plugins/xsaff/xsaff.admin.php
www/plugins/xsaff/lang/xsmm.en.lang.php => plugins/xsaff/lang/xsaff.en.lang.php
www/plugins/xsaff/inc/xsaff.funtions.php => plugins/xsaff/inc/xsaff.funtions.php
www/plugins/xsaff/inc/xsaff.tb.php => plugins/xsaff/inc/xsaff.tb.php
www/plugins/xsaff/inc/php-captcha.inc.php => plugins/xsaff/inc/php-captcha.inc.php
www/plugins/xsaff/inc/captcha.php => plugins/xsaff/inc/captcha.php
www/plugins/xsaff/inc/fonts/Dekadens.ttf => plugins/xsaff/inc/fonts/Dekadens.ttf
www/plugins/xsaff/inc/fonts/SwatchIt.ttf => plugins/xsaff/inc/fonts/SwatchIt.ttf
www/plugins/xsaff/inc/fonts/VeraMoBd.ttf => plugins/xsaff/inc/fonts/VeraMoBd.ttf
__________________________________________________________________________________________


CHMOD
CHMOD the plugins/xsaff/affimg/ folder to 777

MYSQL
Open up your favorite mysql admin, and run this
____________________________________________________

SQLCREATE TABLE `sed_xsaff_aff` (
`aff_id` mediumint(8) unsigned NOT NULL auto_increment,
`aff_name` varchar(255) NOT NULL default '',
`aff_uname` varchar(255) NOT NULL default '',
`aff_uid` int(11) NOT NULL default '0',
`aff_desc` text NOT NULL,
`aff_img` varchar(255) NOT NULL default '',
`aff_url` varchar(255) NOT NULL default '',
`aff_hits` mediumint(8) unsigned default '0',
`aff_broke` int(11) NOT NULL default '0',
`aff_active` int(11) NOT NULL default '0',
PRIMARY KEY (`aff_id`)
) ENGINE=MyISAM;

CREATE TABLE `sed_xsaff_terms` (
`terms_text` text NOT NULL
) TYPE=MyISAM;



INSTALL
Go into the administration panel, then tab Plugins, click XsAffiliates, and at bottom of the plugin properties, select Install all. Once you have finished installing it get to configuring it.

CORE HACKS

OPEN www/datas/config.php


FIND ?>


BEFORE ADD$db_xsaff_aff = 'sed_xsaff_aff';
$db_xsaff_terms = 'sed_xsaff_terms';



CORE CONFIGURATION
Navigate to http://www.yourdomain.com/admin.php?m=config&n=edit&o=plug&p=xsaff. Here you will see 3 choices.
- How many should be listed before pagination occurs? This is a drop down where you can select the amount of affiliates to show per page.
- Pagination method (sedplus only if installed) If you have sedplus installed you can use it's pagination.
- Make them agree to your terms? This is where you can turn this feature on/off. If you don't wantto use it then just switch it to off.

SKIN INTEGRATION
If you want to integrate the xsaff.tpl into your own skin. All you have to do is rename the file to xsaff.standalone.tpl and place it in your skin's folder.

SKIN MODIFICATION
If you want to display the random affiliate then all you have to do is add {XSAFF} to your header.tpl where ever you want it to be displayed. {XSAFF} only outputs a div with the image centered. You will have to build the box around it. If you want it to display on the index or such just modify the hook and tag accordingly.