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)
-   -   Pickpocket in Lesane Store (https://vborg.vbsupport.ru/showthread.php?t=38383)

Lovaboye 08-24-2002 08:09 PM

Quote:

INSERT INTO privatemessage (privatemessageid,userid,touserid,fromuserid,title ,message,dateline,showsignature,iconid,messageread ,folderid,receipt) VALUES (NULL,2,2,DMINID,'Crime','test!

Sorry, you were robed for the sum 70.


Quote:

It was very smart robbery! We didn\'t take them.
',1030222597,' Forums','',0,0,0)
mysql error: Unknown column 'DMINID' in 'field list'

mysql error number: 1054
I get this error after i rob some1, what is wrong?

critical 08-25-2002 10:24 AM

pls tell me wats the difference between +++++ and insurance?!? gladly appreciated.. my user keep pestering me

Mr_P 08-29-2002 02:08 PM

Quote:

Originally posted by Lovaboye
',1030222597,' Forums','',0,0,0)
mysql error: Unknown column 'DMINID' in 'field list'

mysql error number: 1054



I get this error after i rob some1, what is wrong?
[/QUOTE]

I got this but funny enough it went on its own.My problem is now this - the hack works perfect thiefs need to have 100 posts to steal but no money ??///


they can steal with nothing even though it is set for 200 points

Is there a fix to this as its crazy time at moment as everyone is at it.

Mr_P 09-03-2002 07:53 AM

Quote:

Originally posted by Mr_P





they can steal with nothing even though it is set for 200 points

Is there a fix to this as its crazy time at moment as everyone is at it.

anyone know how to make it charge for the thief as at moment it says its 200 but u can get it fro free somehow.

Obi-Wan 09-08-2002 08:29 AM

I did all there was to do for all I know but when I wanna insure/steal I get just this:

Quote:

// ###################### Start insurance ####################### if ($action=="insurance") { $contest = $DB_site->query_first("SELECT * FROM store WHERE action='insurance'"); $title=$contest[title]; $cost=$contest[costs]; $user++++ = $DB_site->query_first("SELECT userid,username,storep,usertitle FROM user WHERE userid=$bbuserinfo[userid]"); $points=$user++++[storep]; if ($cost>$points) { eval("standarderror(\"".gettemplate('store_error') ."\");"); } else { $DB_site->query("UPDATE user SET insurance='insurance',storep=storep-$cost WHERE userid='$bbuserinfo[userid]'"); $DB_site->query("UPDATE user SET storep=storep+$cost WHERE userid=78"); $changestorenow = $DB_site->query("UPDATE store SET sold=sold+1 WHERE action='insurance'"); $moneycheck = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]"); $money = $moneycheck[storep]; eval("dooutput(\"".gettemplate("store_insurance"). "\");"); } } // ###################### Start mafia ####################### if ($action=="mafia") { $contest = $DB_site->query_first("SELECT * FROM store WHERE action='mafia'"); $title=$contest[title]; $cost=$contest[costs]; $user++++ = $DB_site->query_first("SELECT userid,username,storep,usertitle FROM user WHERE userid=$bbuserinfo[userid]"); $points=$user++++[storep]; if ($cost>$points) { eval("standarderror(\"".gettemplate('store_error') ."\");"); } else { $DB_site->query("UPDATE user SET insurance='mafia',storep=storep-$cost WHERE userid='$bbuserinfo[userid]'"); $DB_site->query("UPDATE user SET storep=storep+$cost WHERE userid=79"); $changestorenow = $DB_site->query("UPDATE store SET sold=sold+1 WHERE action='mafia'"); $moneycheck = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]"); $money = $moneycheck[storep]; eval("dooutput(\"".gettemplate("store_mafia")."\") ;"); } } // ###################### Start steal Lookup ########### if ($action=="steal") { if ($bbuserinfo[posts]<100) { // victim should have more than $100 eval("standarderror(\"".gettemplate('store_steal_c annot')."\");"); } $contest = $DB_site->query_first("SELECT * FROM store WHERE action='steal'"); $storeid=$contest[id]; $title=$contest[title]; $cost=$contest[costs]; eval("dooutput(\"".gettemplate("store_steal_lookup ")."\");"); } // ###################### Start steal How Much? ####################### if ($action=="stealmoney") { if ($bbuserinfo[posts]<100) { // don't allow new users to steal -- they need to have more than $100! eval("standarderror(\"".gettemplate('store_steal_c annot')."\");"); } $getduser=$DB_site->query_first("SELECT userid,usertitle,username,storep,usergroupid FROM user WHERE username='".addslashes(htmlspecialchars($stealuser name))."'"); if ($getduser[storep]<100) { // victim should have more than $100 eval("standarderror(\"".gettemplate('store_steal_p oor')."\");"); } if $getduser[userid]==$bbuserinfo[userid] OR $getduser[userid]=="79" OR $getduser[userid]=="78") { eval("standarderror(\"".gettemplate('store_nosteal ')."\");"); } if (empty($getduser[username])) { eval("standarderror(\"".gettemplate('store_donate_ dontexist')."\");"); } else { $storeadmin = $DB_site->query_first("SELECT * FROM storeadmin"); $storename=$storeadmin[storename]; $pointname=$storeadmin[pointname]; $contest = $DB_site->query_first("SELECT * FROM store WHERE action='steal'"); eval("dooutput(\"".gettemplate("store_steal_money" )."\");"); } } // ###################### Start Verify Stealing ####################### if ($action=="stealverify") { $getduser=$DB_site->query_first("SELECT userid,usertitle,username,storep FROM user WHERE username='".addslashes(htmlspecialchars($stealuser name))."'"); $contest = $DB_site->query_first("SELECT * FROM store WHERE action='steal'"); $storeid=$contest[id]; if($stealmoney<0) { $stealmoney=-$stealmoney; } if (($getduser[storep]-$stealmoney)<20) { eval("standarderror(\"".gettemplate('store_steal_l imit')."\");"); } $need=$points + $stealmoney; $rest=$getduser[storep] - $stealmoney; if ($rest<0) { eval("standarderror(\"".gettemplate('store_steal_e rror')."\");"); } eval("dooutput(\"".gettemplate("store_steal_accept ")."\");"); } // ###################### Start steal Change ####################### if ($action=="stealchanged")
And this is just a part.
I've changed the query's, set the option that admin's can be robbed but insurance and godfather not.

Can anybody help me out with this please?

Obi-Wan 09-10-2002 08:49 AM

*bump*

Anybody ?? :D

azork 09-10-2002 01:01 PM

Very nice hack Gensec.

Now here are requests for little addons that would bring a lot of fun:
- Members can become Godfathers: they could buy it in the store if they have a lot of money
- Members can steal the store or the itemshop (from Vivi)

azork 09-11-2002 01:17 PM

Prison hack: a page where you can see all members with negative points.

Cold Steel 09-15-2002 07:14 PM

Great hack, GenSec. My members love it.

I have a couple questions/problems.
  • Some members get this when they try to steal. It only happens intermittently.

    Database error in vBulletin 2.2.6:

    Invalid SQL: UPDATE user SET storep=storep-$50 WHERE userid='1988'
    mysql error: Unknown column '$50' in 'field list'

    mysql error number: 1054

    Date: Sunday 15th of September 2002 01:52:26 PM
    Script: http://forums.asiansinc.com/store.php
    Referer: http://forums.asiansinc.com/store.php
  • I have members with negative balances that keep stealing. Is this normal?
  • If I want to change it so that thieves have to pay the Mafia the entire amount they tried to steal, or so that they have to pay MORE than they tried to steal, what should I change it to?
  • I have the quick-reply hack installed. Users who have negative balances can still post via this hack. Is there anyway to edit showthread.php around it?
  • Is there any way to change the way insurance pays out? I have people who are getting robbed for $200 (insurance paid them $602), $500 (insurance paid them $629), $500 (insurance paid them $581. Can you make it so they don't get back more than people tried to steal?

Thanks again for the great hack!

Cold Steel 09-17-2002 12:14 AM

Code:

if ($bbuserinfo[posts]<100 OR $bbuserinfo[storep]<0) {
What would the above code do, in terms of restricting people from stealing?


All times are GMT. The time now is 12:37 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.01210 seconds
  • Memory Usage 1,760KB
  • 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_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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