112
ya it will not work during installation of a new module but if I change the "install\sql\mysql.structure.sql" then
it will work as per my requiermant. Actually I want to add an extra filed in "users" table which will store some information against each user.
it will work as per my requiermant. Actually I want to add an extra filed in "users" table which will store some information against each user.
113
I want to change the table structure of "users" table (want to add a column ) using a sql file (located at sql directory in my mudule directory) during installation of my module. When I try to install my module it's showing some errors that "users table is preserved" and it stop to install my module, but whenever I move the sql query ( which add an column in "users" table) then it's working perfectly, create tables as per my requierments.
Can anybody tell me how can I aviod this restriction.
Can anybody tell me how can I aviod this restriction.
115
I am trying to create a new module for my own purpose. I have creat a page to update some product name against product id. It's very simple task and I am able to do it using my function. But whenever I try to update using xoops's code I am unable to do it. The code is as follows:-
<?
include '../../mainfile.php';
// Include the page header
include(XOOPS_ROOT_PATH.'/header.php');
global $xoopsDB;
if ( $xoopsUser )
{
$i=1;
foreach ( $HTTP_GET_VARS as $k => $v )
{
$arr[$i]= $v;
$i++;
}
print $arr[1];
if(! $xoopsDB->query("UPDATE ".$xoopsDB->prefix('exchange')." SET pname='dfdfdf' where pid=".$arr[1] ))
{
echo "Could not update product";
}
else
{
redirect_header("offer.php",1,_XD_DBSUCCESS);
}
}
else
{
redirect_header("index.php",3,_NOPERM);
exit();
}
include(XOOPS_ROOT_PATH.'/footer.php');
?>
Table name exchange
Table structure is:
pid int(4)
pname= varchar(100)
Wating for reply.
<?
include '../../mainfile.php';
// Include the page header
include(XOOPS_ROOT_PATH.'/header.php');
global $xoopsDB;
if ( $xoopsUser )
{
$i=1;
foreach ( $HTTP_GET_VARS as $k => $v )
{
$arr[$i]= $v;
$i++;
}
print $arr[1];
if(! $xoopsDB->query("UPDATE ".$xoopsDB->prefix('exchange')." SET pname='dfdfdf' where pid=".$arr[1] ))
{
echo "Could not update product";
}
else
{
redirect_header("offer.php",1,_XD_DBSUCCESS);
}
}
else
{
redirect_header("index.php",3,_NOPERM);
exit();
}
include(XOOPS_ROOT_PATH.'/footer.php');
?>
Table name exchange
Table structure is:
pid int(4)
pname= varchar(100)
Wating for reply.
116
Hi:
I am working on a website (xoops enabled). I require help in changing one settings (may be .htaccess) so that I am able to run one converter script to update actuall IPB tables to new xoops_IPB tables without any interruption.
Our database have more than 5000 queries(170MB: 7000 Members), and its difficult to run this converter from present settings.
Because PhpMyAdmin has default time out is 300s, we can not run queries more than 5000. As we have install PhpMyAdmin for own use in dedicated server(Linux) with 512DDR RAM, we need to change that config to 3000s and then 'I think' it will work over 5000 queries.
Now my question is how to configure that settings
.htaccess ? if yes, how? what is the syntax to do that? is there any other configuration needed ?
I am working on a website (xoops enabled). I require help in changing one settings (may be .htaccess) so that I am able to run one converter script to update actuall IPB tables to new xoops_IPB tables without any interruption.
Our database have more than 5000 queries(170MB: 7000 Members), and its difficult to run this converter from present settings.
Because PhpMyAdmin has default time out is 300s, we can not run queries more than 5000. As we have install PhpMyAdmin for own use in dedicated server(Linux) with 512DDR RAM, we need to change that config to 3000s and then 'I think' it will work over 5000 queries.
Now my question is how to configure that settings
.htaccess ? if yes, how? what is the syntax to do that? is there any other configuration needed ?
117
Quote:
hmmm...yes, I am doing that. I already collected good amount of documentation for ready refernce. Target 1 month. Thanks again MithyT2 :) Will be in touch with you.
If you feel like writing HTML code in your .php document. Stop!. Make a SMARTY template for it instead (if it's an advantage). Write your code object oriented. Read the xoops_version.php of e.g. news module and use everything you want from that.
hmmm...yes, I am doing that. I already collected good amount of documentation for ready refernce. Target 1 month. Thanks again MithyT2 :) Will be in touch with you.
118
Quote:
Thats better, it hits the subject. I will be in touch with Catzwolf. Sorry for my poor english, it looks I am shouting..Its not that. I am worried about time, which is running. Moderator with 340+ post should know what a newbie with 34+ post expects.
The set of requirements is not done yet, and we'll also need to setup a group of module testers/reviewers for the certification - Catzwolf is the leader of the module development and can give more information as and when it is available (as well as correct me, where I made a blooper )
Thats better, it hits the subject. I will be in touch with Catzwolf. Sorry for my poor english, it looks I am shouting..Its not that. I am worried about time, which is running. Moderator with 340+ post should know what a newbie with 34+ post expects.
119
Quote:
Thats Okay but where and how? I want this module to pass all levels of certification and strictly follow the XOOPS core structure. Please guide me.
You will not need to register your module to get support from the XOOPS community. However, there are plans to "certify" modules that work well on a variety of platforms and utilize the XOOPS core functions.
Thats Okay but where and how? I want this module to pass all levels of certification and strictly follow the XOOPS core structure. Please guide me.
120
Thanks and any other suggestion will definitely help me in developing this module on time. btw, do I need to register this module to get official support from xoops? If yes how and where?
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | Apr 30 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|