Links To Us Hack

[trafix]

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 (http://www.atmyparty.com/network/linkstous.php?action=linkfrommember&siteid=2)

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.

[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 (https://vborg.vbsupport.ru/showthread.php?postid=372957#post372957)
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.

[trafix]

There has been lots of downloads for this one.....
Has anyone installed it yet?
Need some help?

[alkatraz]

wOOt wOOt
great hack! i might install it later

[trafix]

thanks, let me know if you are having probs installing......however i plan to go to bed soon 3:12am here :(

[ricoche]

Hello there,

I downloaded the zipped file but it was corrupt so I had to do a fix. However, the linkstous.php inside is either not working properly or I'm missing some files. <LOL>

Very nice hack and I look forward to giving it a shot. Please advise on what I might be doing wrong here to get started.

Thanks,

Ricoche

[trafix]

Sorry I took so long to get to you.....

File replace and working.

Thanks Ricoche

Today at 07:07 PM ricoche said this in Post #24 (https://vborg.vbsupport.ru/showthread.php?postid=373938#post373938)
Hello there,

I downloaded the zipped file but it was corrupt so I had to do a fix. However, the linkstous.php inside is either not working properly or I'm missing some files. <LOL>

Very nice hack and I look forward to giving it a shot. Please advise on what I might be doing wrong here to get started.

Thanks,

Ricoche

[ricoche]

Hello,

First thanks for the file update.

I think I installed everything according to instructions, however I'm getting a slight error with my database when adding a banner from the admin panel. The error is as follows:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO banners (bannerid,banneratl,comment,bannerurl) VALUES (NULL,'Please visit Ricoche.net',''',http://www.ricoche.net/forums/banners/Ricochesm.gif')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 27th of March 2003 07:56:14 AM
Script: http://www.ricoche.net/forums/forums/admin/linkstousadmin.php
Referer: http://www.ricoche.net/forums/admin/linkstousadmin.php?action=add

Everything else works extremely well. I'm now trying to create some different banner types, but any info about this error above would sure be appreciated. I noticed there is a double "forums" in the admin URL above there also. Maybe this is the reason, but I'm not sure how to fix that.

Thanks again for a super hack here.

Ricoche

[trafix]

ok im working on it

[trafix]

open linkstousadmin.php and replace "start insert" with

// ###################### Start insert #######################
if ($action=="insert") {
$DB_site->query("INSERT INTO banners (bannerid,banneratl,bannerurl,comment) VALUES (NULL,'".addslashes($banneratl)."','".addslashes(htmlspecialchars($bannerurl))."','".addslashes($comment)."')");
echo "<p>Record added</p>";
$action="modify";


}


save and upload......i will update zip to V 1.4 soon

my pc is about to crash and i have to reboot :(

[trafix]

ok zip file updated.

This hack should install without a problem now...

[ricoche]

Thanks so much for this hack. Yes, the added lines fixed my problem perfectly. Now I'm able to add the additional custom banners and add comments etc.

I'm really impressed with this addon. I think it's a very nice addition to vbulletin and in my case vbportal as well.

Ricoche :)

[trafix]

Found a problem!

at the moment do not alter the registration.php file as instructed, if you have already altered it please restore the file for the moment.

I is causing errors when people go to confirm membership during registration. i will get back to you with the new code soon

[Souli]

Sorr - the File ist corrupt - CRC Error - can you replace it ? (i have cleared my cache ;)

thx ...

[trafix]

what exactly do you need to replace?

im not sure what you mean by CRC error

[Souli]

Today at 04:13 AM trafix said this in Post #33 (https://vborg.vbsupport.ru/showthread.php?postid=374337#post374337)
what exactly do you need to replace?

im not sure what you mean by CRC error

Sorry 4 my bad english :D

I try to download the Hackfile (linkstous_v1.2.zip), but after download it has only a size from 10239 Bytes and all of my Programmes (winace, winrar, winzip says the File is not OK :(

[trafix]

OK this coding is fine, i just fully tested it again by signing up to my board with and without referals....I got no errors

the reason for the warming post is due to one of my members experienced script error...i since found out it was due to something else i had installed.

you can continue to use the register.php alteration :)


Today at 08:00 AM trafix said this in Post #31 (https://vborg.vbsupport.ru/showthread.php?postid=374196#post374196)
Found a problem!

at the moment do not alter the registration.php file as instructed, if you have already altered it please restore the file for the moment.

I is causing errors when people go to confirm membership during registration. i will get back to you with the new code soon

[trafix]

interesting...i just downloaded it twice saved and unpacked without a problem

however i did have a similar problem yesterday, this is how i fixed

press ctrl - alt - delete at same time

check the list of operating software and "end task" on each winzip

yesterday i was getting currupt files....even though according to the tool bar at the bottom i did not have a copy of winzip open....there was one in the ctrl - alt - delete list.....caused by software crash

[PurpleCow]

the download file in the first post is not a valid zip archive.

can you help me here.

I'd want to install the hack.

Cheers

[trafix]

ok i have re-attached a new zip file i have also downloaded it unpacked it and works...

please tell me if you are still having problems....better still tell me if it worked :)

[Souly]

Super.

it works now :)

*install*

[Souly]

OK. i am back :)

Works very fine without any problems .... but .....

.. in the Welcomepage , all members can use html code and vbcode isn?t possible? - can you change it?

I think it is a security hole when users can use own html code on the board :confused:

[trafix]

hmmm i havent tried VBcode, i just thought that it would work..

i would have to think on that one...unless anyone else wants to have a stab at it :)

[NuclioN]

I think there is a problem with the custom text added by members who have a banner placed on their site. When they behave as a non member, so delete cookies and temp files and log out of the forum and click the link on their website, the custom welcome text does not show up and the referal in their getinfo is not upated. Also, the stats in the admin cp are not updated as well.

[PurpleCow]

Hello trafix :

I still have error in ZIp structure.
Does anyone have the same problem ???

Thanks again...Kindly look into it.

[trafix]

Try now i have replaced the zip and tested it

[PurpleCow]

I still get error in ZIP structure, don't know why ??

Looks like, I am quite unfortunate ... :(

Could you attach individual files, so that i can download them ??

Thanks for your time.

[trafix]

Ok i have changed it again with a new file name...if it dosnt work for you this time PM me your email address and i will send it that way..

there is about 28 files so posting each one individually is not about to happen :)

[NuclioN]

Any solution for the custom member text trafix? No matter what they do, the standard admin cp text remains as welcome text.

[trafix]

Today at 04:54 PM HostBubble said this in Post #43 (https://vborg.vbsupport.ru/showthread.php?postid=375368#post375368)
Hello trafix :

I still have error in ZIp structure.
Does anyone have the same problem ???

Thanks again...Kindly look into it.


pm me a link to your custom welcome page..i will take a look

[PurpleCow]

trafix :

the problem is not with the installation, but actually with the ZIP itself.

I tried unpacking it in 3 different windows applications :

winzip
power archiver and winrar

all 3 of them give me error with the ZIP archive, while i can comfortable unpack other zipped packages downloaded from vb>org here !

thanks again and kindly help me with this zip archive as i need to install the hack.

Cheers

[Kars10]

Works good. But you forget to add the Javascript-Link for the Top10.

I addet this:

<script language="Javascript">
function showwin() { window.open
("linkstous.php?action=top10",
"top10", "toolbar=no,scrollbars=yes,resizable=yes,width=400, height=300"); }
</script>

bevor:

<body>

in banner2 - Template and it works great!!

* Kars10 klicks install!

Kars :)

[trafix]

Today at 04:15 AM Kars10 said this in Post #50 (https://vborg.vbsupport.ru/showthread.php?postid=375547#post375547)
Works good. But you forget to add the Javascript-Link for the Top10.

I addet this:

<script language="Javascript">
function showwin() { window.open
("linkstous.php?action=top10",
"top10", "toolbar=no,scrollbars=yes,resizable=yes,width=400, height=300"); }
</script>

bevor:

<body>

in banner2 - Template and it works great!!

* Kars10 klicks install!

Kars :)

Thanks Kars :)

I will add the java code to the template and update...again.

Did you download after HostBubble's last post stating that the file was corupt? If so the problem he is having would be at his end not the zip file...just clarifying.

Glad you like it.

[Kars10]

@ Trafix, yes ive downloadet after his Post without any Problems. The zip is ok.

Thanks
Kars :)

[PurpleCow]

Hmm, whats wrong then with me here...

The problem still persists here for me .. :(

[Etcher]

I followed the instructions to the letter, as far as I know, and have gone over it twice...

Everything seems to be there and OK, but when I go to the Admin panel, there is a bar that says Links To US, and nothing under it...

I am assuming that there should be a link to Config or something to that affect...

So I have it installed, and can't configure it...

[trafix]

Etcher.

there is a bar that says Links To US

is this in the admin side navigation area?????

if so double check the text that you added to the admin/index.php

[Etcher]

That was it... Typo on my part... Thanks bud...

[trafix]

No problem etcher, hope you enjoy the hack!

[Koutaru]

Just a quick question: If I installed it with the store addon would there be a limit on how many times a user can click a link. As in once per day?

Sorry if this was already answered

:) thanks

[trafix]

Today at 09:34 PM Koutaru said this in Post #58 (https://vborg.vbsupport.ru/showthread.php?postid=387315#post387315)
Just a quick question: If I installed it with the store addon would there be a limit on how many times a user can click a link. As in once per day?

Sorry if this was already answered

:) thanks


Hmmm, no limit applies.

This hack allows members to add a banner to their own website linking to your site/forum the store addon just gives the member X amount of credits when sombody clicks the link on their site :)

NOTE the hack will not credit or update linking details if that if the member clicks on their own link

If you realy want to limit the amount of ppl clicking on the link in a members website i spose something could be added, but i cant see y u would want to ..... more clicks the better 4 u

[kaotic]

This is a great hack, I just finished installing it too. But I'm worried that the member can just add the HTML to his/her site, and then click on the link over and over to gain more credits each time. Is there any way to prevent that?

[trafix]

Its already inbuilt! The system will not register click throughs or add credit if the member clicks on his own link :)

[kaotic]

Oh, well then this hack is greater than I imagined. :p Thanks, again.