Links To Us Hack

This is my 3rd hack (second to be realeased) I hope you enjoy this great new website promotional tool.

This hack is designed to operate on its own or with Lesane's store hack If you have the store hack installed you can give points to members when people click the link on their website.

This hack makes it easy for everyone to put an image or text link from their site to yours. it produces the code for the user so all they have to do is copy and paste the html tag to their site.
There are 3 variations of banners and links that your guests or members can choose

1) Produces the code for a link with a remotely hosted image or banner.
2) Produces the code for an image link that is hosted on your server. (switchable for both guests and members)
3) Produces the code(s) for a set of special banner or image links that is hosted on your server. Basicly if you have other banners you can add them, and even restrict their use to members only.(switchable for both guests and members)

All the links that are produced by the code lead back to the linkstous.php and when clicked on from another website the surfer well be brought to a welcome page of your site,
If the link followed was from a non-member, the welcome page they come to is a generic page that you will create in your config,
however your members can develop a personalized their own welcome page for when somebody clicks the link on their site.

There is also a link counter so you can keep track of how many click-throughts you get from non-member links and also from each member individually, there is a "Top 10 Linkers" in the members area and a full stats page in the admin that has a top 50 member linkers list.
The system will not count or give points if the owner of the link clicks on it themselves!

DEMO: Pretend that the link below is a banner on my website

www.atmyparty.com banner

SCREENSHOT: Next posts

REQUIREMENTS:

1 X php file alteration
4 X database query
15 X new templates
1 X template modifications

INSTALATION TIME: aprox. 25 - 30 min

Tested on 2.2.8 but should work on all versions.

I appologise for the poor datadase info..I have just finished coding and testing a php file to do the quries for you.

updated zip with java bug fix

~ This hack is Copyright ~
Please note that I reserve the right to code and release this hack for VB3, I have not and will not grant permission for anyone else to code this hack for VB3.

[trafix]

general area

[trafix]

edit personal welcome page

[trafix]

next

[trafix]

admin config

[trafix]

admin modify / add banners

[trafix]

admin stats

[Kevorkian]

i receive an error with the second query Errore

query SQL :

CREATE TABLE `banneradmin` (

`event` smallint( 5 ) unsigned NOT NULL auto_increment,
`storehack` SMALLINT( 6 ) DEFAULT0 NOT NULL ,
`storecredit` smallint( 5 ) DEFAULT0 NOT NULL ,
`serverpath` varchar( 100 ) NOT NULL ,
`guestsfromserver` smallint( 5 ) DEFAULT0 NOT NULL ,
`guestsspecial` smallint( 5 ) DEFAULT0 NOT NULL ,
`alttext` varchar( 100 ) NOT NULL ,
`linktext` varchar( 100 ) NOT NULL NOT NULL ,
`bannerimg` varchar( 100 ) NOT NULL NOT NULL ,
`welcometext` mediumtext NOT NULL NOT NULL ,
`guestclicks` smallint( 6 ) DEFAULT0 NOT NULL ,
`membersfromserver` smallint( 5 ) DEFAULT1 NOT NULL ,
`membersspecial` smallint( 5 ) DEFAULT1 NOT NULL ,
`memberalttext` varchar( 100 ) NOT NULL ,
`membersclicks` smallint( 5 ) DEFAULT0 NOT NULL ,
PRIMARY KEY ( `event` )
)

Messaggio di MySQL:

You have an error in your SQL syntax near 'DEFAULT0 NOT NULL , `storecredit` smallint( 5 ) DEFAULT0 NOT NULL , `server' at line 1
Indietro

[trafix]

ok i did test it...

i will test again and re-post!

[trafix]

ok re-tested....

in the datadase_changes.txt file there is a space between DEFULT and X

above there is no spaces between the DEFULT and the number, give that a try.