Store hack conflict...

Hi ...

I'm half way thru installing the store hack...

ive come across a conflict with the away user hack and the store...

The installation of the store hack tells me to do this in member.php :

Find(around LINE 410):

PHP Code:

$DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,","")."
          $dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'");
      } 


Change it to:

PHP Code:

 // Store hack by Lesane
      
      $storeadmin = $DB_site->query_first("SELECT * FROM storeadmin");
      $fool=$storeadmin[newreply];

          $DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,","")."
          $dotitle"."lastpost='".time()."',storep=storep+'$fool' WHERE userid='$bbuserinfo[userid]'");
      } 


The line i have in my member.php file is:

PHP Code:

$DB_site->query("UPDATE user SET
          ".iif ($foruminfo[countposts],"posts=posts+1,","")."
          $dotitle"."lastpost='".time()."',away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");
      } 


I urgently need help with this ... im half way thru and still have lots more to edit...

Thanks in Advance

[Dean C]

yep i added all of em with the advanced template editor.....

[Lesane]

Mist, use these query's below as the 5th query:

PHP Code:

**********************************
5th Query(u probably have to execute these query's apart):
**********************************

INSERT INTO store VALUES (1, 'username', 'Change Username', '500', '0', 'username.gif', 'With this action you can change your username', 'Y','0');
INSERT INTO store VALUES (2, 'customtitle', 'Change Custom Title', '300', '0', 'title.gif', 'With this action you can get a custom title and if you dont have one already then get one', 'Y','0');
INSERT INTO store VALUES (3, 'customavatar', 'Change Custom Avatar', '700', '0', 'avatar.gif', 'With this action you can get a custom avatar or if you already one you can change it...', 'Y','0');
INSERT INTO store VALUES (4, 'givetitle', 'Give an other user a custom title', '700', '0', 'givetitle.gif', 'With this action you can give an other user a custom title. The title that you give will be showed on every post of that user. <br><b>Tip:</b> Do it when that user dont have enough money to restore his custom title ;)', 'Y','0');
INSERT INTO store VALUES (5, 'donate', 'Donate money to an other user', '0', '0', 'donate.gif', 'With this "free" action you can donate money to other members.', 'Y','0');
INSERT INTO store VALUES (6, 'scrap', 'Scrap your yellow/red card', '700', '0', 'card.gif', 'With this action you can scrap your yellow/red card. Want to become a mod but have a yellow/red card? Do this action to begin with a new veb life ;)', 'Y','0');
INSERT INTO store VALUES (7, 'calendar', 'Add Calendar Event', '500', '0', 'calendar.gif', 'With this action you can add a public calendar event on the calendar', 'Y','0');
INSERT INTO store VALUES (8, 'glowusername', 'Add Glow To Username', '2000', '0', 'glow.gif', 'With this action you can add an attractive glowing color to your username wich you can define yourself. If you have already a glow then you can change it here aswell.', 'Y','0');

**********************************
END 5th Query
********************************** 


[Dean C]

i ran this query again to erase the 5th query ...

i tried running those queries you had there as the 5th queries... and it gave me this error:

PHP Code:

Database error in vBulletin Control Panel 2.2.3:

Invalid SQL: INSERT INTO store VALUES (8, 'glowusername', 'Add Glow To Username', '2000', '0', 'glow.gif', 'With this action you can add an attractive glowing color to your username wich you can define yourself. If you have already a glow then you can change it here aswell.', 'Y','0');
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Wednesday 05th of June 2002 03:20:27 PM
Script: [url]http://www.emceebattleraps.com/forums/forums/admin/query.php[/url]
Referer: 


The queries are running fine in the instructions you originally gave for this hack (in the txt file)

but when i do the things as shown in post#9 i get those errors...

im so confused as to what to do...

I did notice today though that when i get these erros when i try to perfom an action in the store that it actually does do them... but still gives that error...

NOTE: i still think that the forums/forums is the cause for this... but i dont kno how or why...

[Lesane]

Run this query first:

PHP Code:

ALTER TABLE store ADD quantity smallint(5) DEFAULT '0' 


And then the rest.

[Dean C]

HELL YEA !!! it works... i ran that query then tested that everything was working right ... and its working fine now !

Thankyou to everyone who has helped... i really appreciate it !!

- Mist