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.

[Kevorkian]

Errore

query SQL :

ALTER TABLE user ADD `welcometext` mediumtext NOT NULL ,
ADD `linkcount` smallint( 6 ) DEFAULT0 NOT NULL

Messaggio di MySQL:

You have an error in your SQL syntax near 'DEFAULT0 NOT NULL ' at line 1

[trafix]

same again there, put a space between the word defult and the number

[Kevorkian]

CREATE TABLE `banneradmin` (
`event` smallint(5) unsigned NOT NULL auto_increment,
`storehack` SMALLINT(6) DEFAULT 0 NOT NULL,
`storecredit` smallint(5) DEFAULT 0 NOT NULL,
`serverpath` varchar(100) NOT NULL,
`guestsfromserver` smallint(5) DEFAULT 0 NOT NULL,
`guestsspecial` smallint(5) DEFAULT 0 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) DEFAULT 0 NOT NULL,
`membersfromserver` smallint(5) DEFAULT 1 NOT NULL,
`membersspecial` smallint(5) DEFAULT 1 NOT NULL,
`memberalttext` varchar(100) NOT NULL,
`membersclicks` smallint(5) DEFAULT 0 NOT NULL,
PRIMARY KEY (`event`))

where ???

[trafix]

this works,

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

whoever i might ask Lesane if he could do one of his doqury.php adding scripts for me....I am still learning, sorry

[Kevorkian]

sorry but the second and the third query don't work i can't install your hack

[trafix]

hmm i re-tested all of them on my server with no faults, I have asked Lesane for assistance. please hang in there

[Kevorkian]

Today at 12:43 PM trafix said this in Post #14
this works,

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

whoever i might ask Lesane if he could do one of his doqury.php adding scripts for me....I am still learning, sorry

no, don't work

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 ,
`bannerimg` varchar( 100 ) NOT NULL ,
`welcometext` mediumtext 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, database problem fixed....i have built and tested a php file to do the database changes for you.

[Dean C]

Wow this is awesome Excellent hack pal

- miSt

[trafix]

Thanks miSt,

Have you or are you intending to install it? cos i would realy love to see it on another site.