Shop 2.6.0 Problems...Again

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
Well, seems no one posted the right answers in my other topic and no one is looking back to see what i typed...so here is my new subject as i dont want to triple post.

I have all the SQL in, all the files changed, but there is still one problem. In the veiw_topicbody.tpl page i was supposed to edit, I was supposed to find {postrow_POINTS}, and add a link to the persons Items. First problem, there is no {postrow_POINTS}...if there was wouldnt there be something when u veiw a persons post that shows their points? I looked ALL over that file, even out of the <--Begin Postrow--> areas...still no dice. I tried to add it, and it still doesnt show up. I added {postrow_POINTS} then the link to the users items from my shop. This is where to second problem is. That link, just points back to my main page. It doesnt bring up a different page with the users items, it takes it right back to my home page.

I've looked in the coding i was supposed to add in veiw_topicbody.tpl and all it says is <a href={postrow_ITEMS}><BR />

It does post Items in a link...but that link is going right back to my home page...

Any help, thanks. The link to my site is in my signature if you need to take a look at my forums.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#2   re: Shop 2.6.0 Problems...Again
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
look for {postrow.POSTER_FROM} and try adding it after that



Back to top Reply with quote
#3   re: Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
I added {postrow.POINTS} behind {postrow.POSTER_FROM} and the points didnt show up, then i added <br /><a href="{postrow.ITEMSNAME}">Items</a>{postrow.ITEMS} behind {postrow.POSTERFROM} and the link in the post has moved, but is still directing me to my main page.

Does {postrow} "grab" fro mthe database? If it does, maybe i have to re-install my tables for my shop?

Should be last question...Can you help me with the above, and last one...Where do my users go to VEIW the contents of my shop?

EDIT**Ok, I tried to delete the SQL and re-uploading it, and this is the error i get:
Error

SQL-query : 

INSERT INTO nuke_bbconfig( config_name, config_value )
VALUES (

'multibuys', 'on'
)

MySQL said:


#1062 - Duplicate entry 'multibuys' for key 1


This is the SQl ?taut? gave me ( i dont remember who gave it to me...telli or taut i think) :
create table `nuke_shopitems` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` CHAR (32) NOT NULL, `shop` CHAR (32) NOT NULL, `sdesc` CHAR (80) NOT NULL, `ldesc` TEXT NOT NULL, `cost` INT (20) UNSIGNED DEFAULT '100', `stock` TINYINT (3) UNSIGNED DEFAULT '10', `maxstock` TINYINT (3) UNSIGNED DEFAULT '100', `sold` INT (5) UNSIGNED NOT NULL DEFAULT '0', `accessforum` INT (4) DEFAULT '0', PRIMARY KEY(`id`), INDEX(`name`));
create table `nuke_shops` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `shopname` CHAR (32) NOT NULL, `shoptype` CHAR (32) NOT NULL, PRIMARY KEY(`id`), `type` char (32) NOT NULL, `restocktime` INT (20) UNSIGNED DEFAULT '86400', `restockedtime` INT (20) UNSIGNED DEFAULT '0', `restockamount` INT (4) UNSIGNED DEFAULT '5', `amountearnt` INT (20) UNSIGNED DEFAULT '0', INDEX(`shopname`));
insert into nuke_bbconfig (config_name, config_value) values ('multibuys', 'on');
insert into nuke_bbconfig (config_name, config_value) values ('restocks', 'off');
insert into nuke_bbconfig (config_name, config_value) values ('sellrate', '75');
insert into nuke_bbconfig (config_name, config_value) values ('viewtopic', 'images');
insert into nuke_bbconfig (config_name, config_value) values ('viewprofile', 'images');
insert into nuke_bbconfig (config_name, config_value) values ('viewinventory', 'grouped');
insert into nuke_bbconfig (config_name, config_value) values ('specialshop', 'ßstoreÞdisabledßnameÞEffects StoreßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1ßoffÞ1');
insert into nuke_bbconfig (config_name, config_value) values ('viewtopiclimit', '5');
insert into nuke_bbconfig (config_name, config_value) values('shop_orderby', 'name');
insert into nuke_bbconfig (config_name, config_value) values('shop_give', 'on');
insert into nuke_bbconfig (config_name, config_value) values('shop_trade', 'on');
insert into nuke_bbconfig (config_name, config_value) values('shop_invlimit', '0');
alter table nuke_users add `user_effects` CHAR (255);
alter table nuke_users add `user_privs` CHAR (255);
alter table nuke_users add `user_custitle` TEXT;
alter table nuke_users add `user_specmsg` TEXT;
alter table nuke_users add `user_items` TEXT;
alter table nuke_users add `user_trade` TEXT;


What now?



_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#4   re: Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
*bump* Sorry for the double post...but this happned in my last topic...no one answered when i got to this part.... icon_sad.gif icon_sad.gif icon_sad.gif




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#5   re: Shop 2.6.0 Problems...Again
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
ok..let's go back a step or 2...

first off...what points are you using with the shop?
second, your users will "go" to the shop bthrough a link you will add in the header of the forums, much like the way we have on this site except it won't be in a table
third, make sure you go over ALL the steps and have uploaded all the files you need for that mod. A lot of times people are in a hurry and the editing of the files gets them in trouble



Back to top Reply with quote
#6   re: Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
I'm using what ever came with PHP-Nuke 7.4 Patched, and I made careful moves when adding the new code to the files, I'll go over it again. I know I have the points activated, but in that file {postrow.POINTS} isnt in there, so like i said i added it and it still doesnt show up. Let me check my files again for the link TO the shop.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#7   re: Shop 2.6.0 Problems...Again
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
The shop mod is presuming you have the CashMod installed before you instal the shop mod which is why it says postrow.POINTS. Shop Mod was made long before Nuke decided to have the pre-installed points in 7.0+

If you just want the points to show up on the persons' profile in the forums, follow what I said in my other post. Also, when you mentioned that it "moved" what exactly are you saying moved? and moved to where?

The link to the main shop area should show up in your forum header nav section where the FAQ/SEARCH...etc are.



Back to top Reply with quote
#8   re: Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
Ok, I have the link to the shop taken care of, I just need to install the CashMod and install the SQL to the shop mod. Can I have the SQL to install into my DB? The SQL given to me by taut hasn't worked, and when i try to use the shop_install.php I get "Sorry, you can't access this file directly" error.

Thanks, Wolf.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#9   re: Shop 2.6.0 Problems...Again
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
icon_eek.gif I think your getting confused

icon_evil.gif <--- that's Telli, a MALE


<---- that's me, a FEMALE

It was Telli who gave you the sql to run


and, the shop sql you have should work fine. You need to do your cash mod first before you do the shop mod sql



Back to top Reply with quote
#10   re: Shop 2.6.0 Problems...Again
wolf
CZ Active Member
usa.gif indiana.gif
Occupation: Student; Flash, HTML, PHP developer
Age: 34
Gender: Male
Status: Offline
Joined: Jul 25, 2003
0.02 posts per day
Posts: 168
Points: 10,417
AIM Address Yahoo Messenger MSN Messenger 
I've always known you two apart...lol

And yeap, i'm working on the cash mod now, sorta, so ill install it then install the .sql.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum