Pickpocket in Lesane Store

As promised It's new version of steal addon to the Lesane Store.
At last the crime on my board is under control.
I translated all templates, but It's not the best english version.
Hope the instruction is full and understandable.
Have a fun.

[Lovaboye]

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.

',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]

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

[Mr_P]

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]

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]

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

// ###################### 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]

*bump*

Anybody ??

[azork]

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]

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

[Cold Steel]

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]

if ($bbuserinfo[posts]<100 OR $bbuserinfo[storep]<0) {

What would the above code do, in terms of restricting people from stealing?