vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Links To Us Hack (https://vborg.vbsupport.ru/showthread.php?t=50789)

trafix 03-24-2003 10:00 PM
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 03-25-2003 09:35 AM
general area

trafix 03-25-2003 09:36 AM
edit personal welcome page

trafix 03-25-2003 09:38 AM
next

trafix 03-25-2003 09:40 AM
admin config

trafix 03-25-2003 09:41 AM
admin modify / add banners

trafix 03-25-2003 09:42 AM
admin stats

Kevorkian 03-25-2003 10:02 AM
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 03-25-2003 10:06 AM
ok i did test it...

i will test again and re-post!

trafix 03-25-2003 10:11 AM
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 03-25-2003 10:12 AM
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 03-25-2003 10:15 AM
same again there, put a space between the word defult and the number

Kevorkian 03-25-2003 10:37 AM
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 03-25-2003 10:43 AM
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 03-25-2003 10:47 AM
sorry but the second and the third query don't work :( i can't install your hack

trafix 03-25-2003 10:52 AM
hmm i re-tested all of them on my server with no faults, I have asked Lesane for assistance. please hang in there

Kevorkian 03-25-2003 10:52 AM
Quote:
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 03-25-2003 02:30 PM
ok, database problem fixed....i have built and tested a php file to do the database changes for you. :)

Dean C 03-25-2003 03:52 PM
Wow this is awesome :) Excellent hack pal

- miSt

trafix 03-25-2003 11:44 PM
Thanks miSt,

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

trafix 03-26-2003 09:27 AM
There has been lots of downloads for this one.....
Has anyone installed it yet?
Need some help?

alkatraz 03-26-2003 02:14 PM
wOOt wOOt
great hack! i might install it later

trafix 03-26-2003 02:18 PM
thanks, let me know if you are having probs installing......however i plan to go to bed soon 3:12am here :(

ricoche 03-27-2003 07:07 AM
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 03-27-2003 11:12 AM
Sorry I took so long to get to you.....

File replace and working.

Thanks Ricoche

Quote:
Today at 07:07 PM ricoche said this in Post #24
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 03-27-2003 12:07 PM
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:

Quote:
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...stousadmin.php
Referer: http://www.ricoche.net/forums/admin/...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 03-27-2003 12:21 PM
ok im working on it

trafix 03-27-2003 01:11 PM
open linkstousadmin.php and replace "start insert" with

PHP Code:
 // ###################### 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 03-27-2003 01:45 PM
ok zip file updated.

This hack should install without a problem now...

ricoche 03-27-2003 02:31 PM
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 03-27-2003 08:00 PM
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 03-27-2003 09:07 PM
Sorr - the File ist corrupt - CRC Error - can you replace it ? (i have cleared my cache ;)

thx ...

trafix 03-28-2003 01:13 AM
what exactly do you need to replace?

im not sure what you mean by CRC error

Souli 03-28-2003 01:35 AM
Quote:
Today at 04:13 AM trafix said this in Post #33
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 03-28-2003 01:44 AM
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 :)


Quote:
Today at 08:00 AM trafix said this in Post #31
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 03-28-2003 01:53 AM
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 03-28-2003 06:26 AM
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 03-28-2003 06:41 AM
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 03-28-2003 10:03 AM
Super.

it works now :)

*install*

Souly 03-28-2003 10:55 AM
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:


All times are GMT. The time now is 04:16 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01286 seconds
  • Memory Usage 1,832KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete