Page 67 of 70

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

Posted: Sun Nov 04, 2007 11:57 am
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.

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

Posted: Sun Nov 04, 2007 8:57 pm
by sixers33
okie dokie

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

Posted: Fri Nov 16, 2007 2:26 am
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

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

Posted: Sun Nov 18, 2007 11:51 pm
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 :)

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

Posted: Mon Nov 19, 2007 5:39 am
by xorakjoken
Ok now the entire board went down.
http://www.forum.xorajoken.com

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

Posted: Mon Nov 19, 2007 7:49 am
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.

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

Posted: Mon Nov 19, 2007 7:01 pm
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...

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

Posted: Mon Nov 19, 2007 8:16 pm
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

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

Posted: Mon Nov 19, 2007 9:04 pm
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.

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

Posted: Sun Nov 25, 2007 8:33 am
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 = 'adelaidesixers@gmail.com', 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?

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

Posted: Sun Nov 25, 2007 12:26 pm
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.

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

Posted: Tue Nov 27, 2007 8:07 am
by sixers33
so what do i do?

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

Posted: Tue Nov 27, 2007 12:03 pm
by Brf
Put back the value for popup_pm.
You apparently removed it when you edited usercp_register.

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

Posted: Sun Dec 09, 2007 2:51 pm
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?

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

Posted: Sun Dec 09, 2007 2:53 pm
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.