Hi i needed some help
with this i dont know how to create GlParam
i got this Source code from Expertzz formuz
here it is http://www.expertzzz.com/forumz/?action=goto&cat_id=1#action=goto&topic_id=5735
it was post it by : Expertx
Edit this file : join.php
//Look for this line :
function showFinishPage( $iMemID, $sStatus ) {
//Add the lines Below :
$aRecipientInfo = db_arr("select ID,NickName,Email,Password from Profiles where ID=$iMemID");
$message_text = getParam("t_ComposeWelcome"); // how can i create this? create this in GlParam just copy t_Compose
$subject = getParam('t_ComposeWelcome_subject'); // how can i create this? create this in GlParam just copy t_Compose_subject
$adminID = 1; // a regular profile that act as admin on your site
$subject = str_replace( "<SiteName>", $site['title'], $subject );
$message_text = str_replace( "<SiteName>", $site['title'], $message_text );
$message_text = str_replace( "<Domain>", $site['url'], $message_text );
$message_text = str_replace( "<recipientID>", $aRecipientInfo['ID'], $message_text );
$message_text = str_replace( "<RealName>", $aRecipientInfo['NickName'], $message_text );
$message_text = str_replace( "<NickName>", $aRecipientInfo['NickName'], $message_text );
$message_text = str_replace( "<Email>", $aRecipientInfo['Email'], $message_text );
$message_text = str_replace( "<Password>", $aRecipientInfo['Password'], $message_text );
$result = db_res( "INSERT INTO `Messages` ( `Date`, `Sender`, `Recipient`, `Text`, `Subject`, `New` ) VALUES ( NOW(),
{$adminID}, {$aRecipientInfo['ID']}, '$message_text', '$message_subject', '1' )" );
i hope anyone can help me thanks for you alls time(:
|
Hi i needed some help
with this i dont know how to create GlParam
i got this Source code from Expertzz formuz
here it is http://www.expertzzz.com/forumz/?action=goto&cat_id=1#action=goto&topic_id=5735
it was post it by : Expertx
Edit this file : join.php
//Look for this line :
function showFinishPage( $iMemID, $sStatus ) {
//Add the lines Below :
$aRecipientInfo = db_arr("select ID,NickName,Email,Password from Profiles where ID=$iMemID");
$message_text = getParam("t_ComposeWelcome"); // how can i create this? create this in GlParam just copy t_Compose
$subject = getParam('t_ComposeWelcome_subject'); // how can i create this? create this in GlParam just copy t_Compose_subject
$adminID = 1; // a regular profile that act as admin on your site
$subject = str_replace( "<SiteName>", $site['title'], $subject );
$message_text = str_replace( "<SiteName>", $site['title'], $message_text );
$message_text = str_replace( "<Domain>", $site['url'], $message_text );
$message_text = str_replace( "<recipientID>", $aRecipientInfo['ID'], $message_text );
$message_text = str_replace( "<RealName>", $aRecipientInfo['NickName'], $message_text );
$message_text = str_replace( "<NickName>", $aRecipientInfo['NickName'], $message_text );
$message_text = str_replace( "<Email>", $aRecipientInfo['Email'], $message_text );
$message_text = str_replace( "<Password>", $aRecipientInfo['Password'], $message_text );
$result = db_res( "INSERT INTO `Messages` ( `Date`, `Sender`, `Recipient`, `Text`, `Subject`, `New` ) VALUES ( NOW(),
{$adminID}, {$aRecipientInfo['ID']}, '$message_text', '$message_subject', '1' )" );
i hope anyone can help me thanks for you alls time(:
can anyone help me out on this
i would gladly appriciated thanks
|
GIParam is a database table.
What the instructions mean is to copy the row named t_Compose and t_Compose_subject.
If you have PHPMyAdmin then that can be done by simply editing the existing row with that name but instead of saving, you select insert as new row after changing the name.
You can also use these 2 sql queries i whipped up to do it.
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('t_ComposeWelcome', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>You have received a message from <ProfileReference>!</p>\r\n\r\n<p>To check this message login to your account here: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>---</p>\r\nBest regards, <SiteName> \r\n<p style="font: bold 10px Verdana; color:red">!!!Auto-generated e-mail, please, do not reply!!!</p></body></html>', 4, 'Email template for notification about new messages in the inbox.', 'text', '', '', NULL);
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('t_ComposeWelcome_subject', 'Notification about new messages in the inbox', 4, '', 'text', '', '', NULL)
https://www.deanbassett.com |
GIParam is a database table.
What the instructions mean is to copy the row named t_Compose and t_Compose_subject.
If you have PHPMyAdmin then that can be done by simply editing the existing row with that name but instead of saving, you select insert as new row after changing the name.
You can also use these 2 sql queries i whipped up to do it.
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('t_ComposeWelcome', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n<p><b>Hello <RealName></b>,</p>\r\n\r\n<p>You have received a message from <ProfileReference>!</p>\r\n\r\n<p>To check this message login to your account here: <a href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>---</p>\r\nBest regards, <SiteName> \r\n<p style="font: bold 10px Verdana; color:red">!!!Auto-generated e-mail, please, do not reply!!!</p></body></html>', 4, 'Email template for notification about new messages in the inbox.', 'text', '', '', NULL);
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('t_ComposeWelcome_subject', 'Notification about new messages in the inbox', 4, '', 'text', '', '', NULL)
Hi, Sorry, im having some trouble, do i copy and paste the 2 sql queries on my notepad and make it a sql file
and import it on phpmyadmin or how do i do it?
or im wrong please help me im sorry
thanks for your help(:
|
Navigate to GIPeram on the left, select SQL and erase whats there and paste the code you want to execute and click the go button.
Here is a screen shot to help you locate it.
 https://www.deanbassett.com |
Navigate to GIPeram on the left, select SQL and erase whats there and paste the code you want to execute and click the go button.
Here is a screen shot to help you locate it.
i get this error
Error
SQL query:
INSERT INTO `GlParams` ( `Name` , `VALUE` , `kateg` , `desc` , `Type` , `check` , `err_text` , `order_in_kateg` )
VALUES (
't_ComposeWelcome', '<html><head></head><body
style="font: 12px Verdana;
color:#000000">\r\n<p><b>Hello
<RealName></b>,</p>\r\n\r\n<p>You have received
a message from <ProfileReference>!</p>\r\n\r\n<p>To
check this message login to your account here: <a
href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>---</p>\r\nBest
regards, <SiteName> \r\n<p style="font: bold 10px Verdana;
color:red">!!!Auto-generated e-mail, please, do not
reply!!!</p></body></html>', 4, 'Email template for notification about new messages in the inbox.', 'text', '', '', NULL
);
MySQL said: 
#1062 - Duplicate entry 't_ComposeWelcome' for key 1
|
I just tested it, and it worked fine. The error your getting means its already there.
Look through the list of GIPerams you have and see if it's there.
Did you already try to do this eairler?
https://www.deanbassett.com |
I just tested it, and it worked fine. The error your getting means its already there.
Look through the list of GIPerams you have and see if it's there.
Did you already try to do this eairler?
well yes i tried it earlier but i placed the 2 sql queries on my notepad and saved it
as t_compose.sql and imported to
my phpmyadmin but i got the same error
this is what im doing i edit the join.php
and place this and then i place the 2 sql you did and
i get the error ah, the subject on the new welcome email dosen't appear
i dont know what do do im very lost
i followed exactly what you tell me and i get the error?
i checked if i have it there and it dosent appear
i create the language strings for t_compose welcome
and the t_composesubjec does that affect it?
|
Well i am at a loss now too.
Now sure where to go from here. That should work.
But i did not write the mod. Perhaps you should track down who did and ask them.
https://www.deanbassett.com |
Well i am at a loss now too.
Now sure where to go from here. That should work.
But i did not write the mod. Perhaps you should track down who did and ask them.
oh alright thanks im sorry if i confused you
my bad
well, now i dont get the error it says Your SQL query has been executed successfully
i just renamed the one in red and also the join.php to t_composeW
and it worked succesfully
but still it dosent appear the subject do
you know what can i do next?
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`,
`check`, `err_text`, `order_in_kateg`) VALUES ('t_ComposeW',
'<html><head></head><body style="font: 12px
Verdana; color:#000000">\r\n<p><b>Hello
<RealName></b>,</p>\r\n\r\n<p>You have received
a message from <ProfileReference>!</p>\r\n\r\n<p>To
check this message login to your account here: <a
href="<Domain>member.php"><Domain>member.php</a></p>\r\n\r\n<p>---</p>\r\nBest
regards, <SiteName> \r\n<p style="font: bold 10px Verdana;
color:red">!!!Auto-generated e-mail, please, do not
reply!!!</p></body></html>', 4, 'Email template for
notification about new messages in the inbox.', 'text', '', '', NULL);
|
