[RC1] The wGEric Store MOD vRC1 (15 November 2007)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [BETA] The wGEric Store MOD v0.2.3 (21 May 2007)

Post by Brf »

sixers33 wrote: Column count doesn't match value count
You were supposed to make two edits to that line in usercp_register, but you only made one.
sixers33
Registered User
Posts: 152
Joined: Sun Jan 21, 2007 2:53 am

Re: [BETA] The wGEric Store MOD v0.2.3 (21 May 2007)

Post by sixers33 »

okie dokie
Rizzn.
Registered User
Posts: 264
Joined: Wed Dec 28, 2005 9:53 am
Contact:

[RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Rizzn. »

|| Download RC1 ||
|| Demo Site ||
Name: test Pass: tester
(Demo site is not yet updated)

RC1 Changes
- Added store logs
- Added store ratings
- Added strict max amounts per item
- Added strict max amounts per item category
- Added item sell-back
- Added item cat images
- Updated user item create page
- Fixed search display for index styles
- Fixed minor expiry notice bug
- Fixed infinite stock for user stores
- Fixed display of 'infinite' items in stores with 0 items
- Fixed move items to store id
[Alpha] Store MOD (phpBB3)
- Support site forthcoming -
--------------------------------------
[RC1] wGEric Store MOD (phpBB2)
Additional Usable Items and Store MOD Support Forums (separate site)
xorakjoken
Registered User
Posts: 30
Joined: Sat Jun 30, 2007 6:09 pm

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by xorakjoken »

Wooh two errors at once.
I am so not lucky.

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't have a category Shop', 1195426859)' at line 1

INSERT INTO phpbb_store_log (log_level, log_content, log_time) VALUES (1, 'Admin Xora added Chinese Lois Blow-Up Doll to store Stuff that doesn't have a category Shop', 1195426859)

Line : 1001
File : functions_store.php

AND

if I try to go to the "my profile" link...

Parse error: syntax error, unexpected T_IF in /home/.mitzi/xorakjoken/forum.xorajoken.com/includes/usercp_register.php on line 67

Thanks in advance :)
The Joken Design Forum: http://www.forum.xorajoken.com
Like Programming? Like Role Playing? Join Today.
xorakjoken
Registered User
Posts: 30
Joined: Sat Jun 30, 2007 6:09 pm

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by xorakjoken »

Ok now the entire board went down.
http://www.forum.xorajoken.com
The Joken Design Forum: http://www.forum.xorajoken.com
Like Programming? Like Role Playing? Join Today.
Prizem
Registered User
Posts: 249
Joined: Sun Sep 07, 2003 9:14 am
Contact:

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Prizem »

The first deals with the single quotation mark in "doesn't" for your shop name. Try this change:
includes/functions_store.php
find

Code: Select all

function log_action($content, $level = 0)
{
	global $db;

	$current_time = time();
	$sql = "INSERT INTO " . STORE_LOG . " (log_level, log_content, log_time) VALUES ($level, '" . str_replace("\'", "''", $content) . "', $current_time)";
	if ( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, "error inputting log entry", "", __LINE__, __FILE__, $sql);
	}

} // log_action();
replace with

Code: Select all

function log_action($content, $level = 0)
{
	global $db;

	$current_time = time();
	$content = str_replace("\'", "''", str_replace("\'", "''", addslashes($content)));
	$sql = "INSERT INTO " . STORE_LOG . " (log_level, log_content, log_time) VALUES ($level, '$content', $current_time)";
	if ( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, "error inputting log entry", "", __LINE__, __FILE__, $sql);
	}

} // log_action();
The second, review the changes you made to includes/usercp_register.php according to the install file and make sure you followed the instructions exactly. That will most likely be your problem.

For your site not being available, that's unrelated to our mod. You should contact your server admin for support.
xorakjoken
Registered User
Posts: 30
Joined: Sat Jun 30, 2007 6:09 pm

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by xorakjoken »

The intrstuctions were followed completely, but I still get the errror:

Code: Select all

Parse error: syntax error, unexpected T_IF in /home/.mitzi/xorakjoken/forum.xorajoken.com/includes/usercp_register.php on line 67
I double checked...
The Joken Design Forum: http://www.forum.xorajoken.com
Like Programming? Like Role Playing? Join Today.
Prizem
Registered User
Posts: 249
Joined: Sun Sep 07, 2003 9:14 am
Contact:

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Prizem »

ok, usercp_register.php lines 50-71 should look something like this:

Code: Select all

function show_coppa()
{
	global $userdata, $template, $lang, $phpbb_root_path, $phpEx;

	$template->set_filenames(array(
		'body' => 'agreement.tpl')
	);

	$template->assign_vars(array(
		'REGISTRATION' => $lang['Registration'],
		'AGREEMENT' => $lang['Reg_agreement'],
		"AGREE_OVER_13" => $lang['Agree_over_13'],
		"AGREE_UNDER_13" => $lang['Agree_under_13'],
		'DO_NOT_AGREE' => $lang['Agree_not'],

		"U_AGREE_OVER13" => append_sid("profile.$phpEx?mode=register&agreed=true"),
		"U_AGREE_UNDER13" => append_sid("profile.$phpEx?mode=register&agreed=true&coppa=true"))
	);

	$template->pparse('body');

}
which we dont touch, so initially, it doesnt look like it pertains to our mod

if after reviewing that you still dont know what's wrong, please post what you have around line 67
xorakjoken
Registered User
Posts: 30
Joined: Sat Jun 30, 2007 6:09 pm

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by xorakjoken »

When I looked I could find a difference so I just took what you said it should be and changed it to that.

Tada it worked.

Thanks man :)
You are amazing.
The Joken Design Forum: http://www.forum.xorajoken.com
Like Programming? Like Role Playing? Join Today.
sixers33
Registered User
Posts: 152
Joined: Sun Jan 21, 2007 2:53 am

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by sixers33 »

I have this error:

DEBUG MODE

Code: Select all

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' user_pm_purchase = 1, user_pm_purchase = 1, user_timezone = 0, user_dateformat ' at line 2

UPDATE phpbb_users SET user_email = '[email protected]', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = 'I AM AMERICA (And So Can YOU!)d', user_sig_bbcode_uid = '035af4d326', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm, user_pm_purchase = 1, user_pm_purchase = 1, user_timezone = 0, user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 6

Line : 531
File : usercp_register.php 
I was told that this is supposed to be the problem, however it tells me to have this in the manual...

Code: Select all

user_pm_purchase = 1, user_pm_purchase = 1,
Help?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Brf »

Having pm_purchase in there twice is wrong, however, that is not what is causing your problem.

Code: Select all

user_popup_pm, user_pm_purchase = 1, user_pm_purchase = 1, 
You have no value for popup_pm in there.
sixers33
Registered User
Posts: 152
Joined: Sun Jan 21, 2007 2:53 am

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by sixers33 »

so what do i do?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Brf »

Put back the value for popup_pm.
You apparently removed it when you edited usercp_register.
SushiP
Registered User
Posts: 6
Joined: Sat Dec 08, 2007 12:05 am

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by SushiP »

This mod is pretty amazing but is there any way to get items to actually do something? Also, is there any way to let members buy name/signature effects and extra smilies?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53400
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [RC1] The wGEric Store MOD vRC1 (15 November 2007)

Post by Brf »

Yes.
You can attach a php script to an object.
I have such an object on my forum that allows a user to change their name's style in viewtopic -- color, size, font, etc.
Post Reply

Return to “[2.0.x] MODs in Development”