vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Spam Killer Hack v1.0 (includes Lesane's Store Hack Addon) (https://vborg.vbsupport.ru/showthread.php?t=40648)

Lovaboye 07-05-2002 12:45 AM

Can we talk on aim? I get this message whenever i try to save my work in the config panel:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: UPDATE storeadmin SET id='1',storename='Cool Store', pointname='Money', welcome='Welcome on the store', welcomed='Here you can buy different goodies for the forum', showimg='N', showrich='Y', showgoodie='Y',newthread=10, newreply=5, reply1=1, reply2=2, reply3=3, reply4=4, reply5=5, rpoint1=1, rpoint2=2, rpoint3=3, rpoint4=4, rpoint5=5, view1=1, view2=2, view3=3, view4=4, view5=5, vpoint1=1, vpoint2=2, vpoint3=3, vpoint4=4, vpoint5=5, spamenabled=1, characters='250', pdeduction='5', spambyadmin=1, spambymod=1, spamnewbie=1, =''
mysql error: You have an error in your SQL syntax near '=''' at line 1

mysql error number: 1064

Date: Thursday 04th of July 2002 09:34:54 PM
Script: http://www.mysite.com/forum/forum/admin/storeadmin.php
Referer: http://www.mysite.com/forum/admin/st...?action=config

g-force2k2 07-05-2002 01:25 AM

yeah whats your AIM?

g-force2k2

UPDATE storeadmin SET id='1',storename='Cool Store', pointname='Money', welcome='Welcome on the store', welcomed='Here you can buy different goodies for the forum', showimg='N', showrich='Y', showgoodie='Y',newthread=10, newreply=5, reply1=1, reply2=2, reply3=3, reply4=4, reply5=5, rpoint1=1, rpoint2=2, rpoint3=3, rpoint4=4, rpoint5=5, view1=1, view2=2, view3=3, view4=4, view5=5, vpoint1=1, vpoint2=2, vpoint3=3, vpoint4=4, vpoint5=5, spamenabled=1, characters='250', pdeduction='5', spambyadmin=1, spambymod=1, spamnewbie=1, =''

Take that coding and delete the ending. I believe thats the problem...

spamnewbie=1, =");

should be:

spamnewbie=1");

See if that fixes it ;)

g-force2k2

Velocd 07-05-2002 03:19 AM

I can't see the purpose of this...it basically is determining if someone is a spammer by how many characters are in their post? That is not very accurate. Putting a spam post count isn't likely to upset the spammer either, it'll probably provoke their sick minds to spam even more. I just cut the problem at the roots, and ban the spammer when they first show themself. :p

g-force2k2 07-05-2002 03:25 AM

well it personally makes the poster think before posting a little more... because you have two different kinds of posters... those that post... number counting threads (sad) and you have users that actually post huge posts... sure you can't discern from just characters...

Sure its definately easier to ban imo and i probably wont' use my own hack i just made it because someone requested it :)

g-force2k2

ZiRu$ 07-05-2002 04:09 PM

Quote:

Originally posted by Velocd
I can't see the purpose of this...it basically is determining if someone is a spammer by how many characters are in their post? That is not very accurate. Putting a spam post count isn't likely to upset the spammer either, it'll probably provoke their sick minds to spam even more. I just cut the problem at the roots, and ban the spammer when they first show themself. :p
banning is extreme......it will make peeps think twice because they wont wanna lose there hard earned money

g-force2k2 07-05-2002 09:19 PM

File has been updated thanks to lovaboye on helping me with a few things...

first off if you want just the two simple changes here they are ;)

open storeadmin.php

find:

PHP Code:

$DB_site->query("UPDATE storeadmin SET id='1',storename='".addslashes($storename)."', pointname='".addslashes($pointname)."', welcome='".addslashes($welcome)."', welcomed='".addslashes($welcomed)."', showimg='$showimg', showrich='$showrich', showgoodie='$showgoodie',newthread=$newthread, newreply=$newreply, reply1=$reply1, reply2=$reply2, reply3=$reply3, reply4=$reply4, reply5=$reply5, rpoint1=$rpoint1, rpoint2=$rpoint2, rpoint3=$rpoint3, rpoint4=$rpoint4, rpoint5=$rpoint5, view1=$view1, view2=$view2, view3=$view3, view4=$view4, view5=$view5, vpoint1=$vpoint1, vpoint2=$vpoint2, vpoint3=$vpoint3, vpoint4=$vpoint4, vpoint5=$vpoint5, spamenabled=$spamenabled, characters='$characters', pdeduction='$pdeduction', spambyadmin=$spambyadmin, spambymod=$spambymod, spamnewbie=$spamnewbie$spamkill='$spamkill'"); 

replace it with:

PHP Code:

$DB_site->query("UPDATE storeadmin SET id='1',storename='".addslashes($storename)."', pointname='".addslashes($pointname)."', welcome='".addslashes($welcome)."', welcomed='".addslashes($welcomed)."', showimg='$showimg', showrich='$showrich', showgoodie='$showgoodie',newthread=$newthread, newreply=$newreply, reply1=$reply1, reply2=$reply2, reply3=$reply3, reply4=$reply4, reply5=$reply5, rpoint1=$rpoint1, rpoint2=$rpoint2, rpoint3=$rpoint3, rpoint4=$rpoint4, rpoint5=$rpoint5, view1=$view1, view2=$view2, view3=$view3, view4=$view4, view5=$view5, vpoint1=$vpoint1, vpoint2=$vpoint2, vpoint3=$vpoint3, vpoint4=$vpoint4, vpoint5=$vpoint5, spamenabled=$spamenabled, characters='$characters', pdeduction='$pdeduction', spambyadmin=$spambyadmin, spambymod=$spambymod, spamnewbie=$spamnewbie, spamkill='$spamkill'"); 

Second the postbit template

find:

<br>Spam Count: $posts[spamposts]

replace it with:

<br>Spam Count: $post[spamposts]

finito enjoy :)

g-force2k2

Larz 07-06-2002 01:31 AM

Quote:

Originally posted by Velocd
I can't see the purpose of this...it basically is determining if someone is a spammer by how many characters are in their post? That is not very accurate. Putting a spam post count isn't likely to upset the spammer either, it'll probably provoke their sick minds to spam even more. I just cut the problem at the roots, and ban the spammer when they first show themself. :p
Basically users have a tendency to post a lot of posts just to get the damn points - I call it post-running on my board, and it takes up about half my admin time, identifying the culprits and warning them to stop.

Any sort of option to detract "something" from those who post very short replys automatically - or just to add something to longer posts - is quite needed on my end.

That said, could you please verify the name of the hack for me - you say it includes Store Hack, but in this thread you call it an addon. Which is it? I'm not installing Store Hack again, I might look at an add-on for it.

g-force2k2 07-06-2002 01:59 AM

sorry larz for the confusion... but its actually two different' hacks... one compatible ( an addon, not a new release) for the Store hack and the other being a regular version... for those that have the store hack i'd suggested the Store Hack Add on :)

g-force2k2

TECK 07-06-2002 07:13 AM

g-force2k2, just by looking at the code, i can say that is not writen by you but pasted from other files. correct me if i'm wrong.
any coder knows what i'm talking about...

here it is an example:
Code:

find:

        if ($vpoint5 == '')
        {
                $vpoint5 = 0;
        }

after it add:

        if ($characters == '') {
          $characters="0";
        }
        if($pdeduction == '') {
          $pdeduction="0";
        }


g-force2k2 07-06-2002 01:20 PM

Quote:

Originally posted by Nakkid
g-force2k2, just by looking at the code, i can say that is not writen by you but pasted from other files. correct me if i'm wrong.
any coder knows what i'm talking about...

here it is an example:
Code:

find:

        if ($vpoint5 == '')
        {
                $vpoint5 = 0;
        }

after it add:

        if ($characters == '') {
          $characters="0";
        }
        if($pdeduction == '') {
          $pdeduction="0";
        }


Nakkid what are you talking about? Seriously man have you just come trying to bash on me or is this some kind of joke... what coding is ripped and so easily recognized? Can you please explain?

g-force2k2


All times are GMT. The time now is 10:40 AM.

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.01340 seconds
  • Memory Usage 1,769KB
  • 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
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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