Support Forums - All Posts - XOOPS Web Application System

71

changing e-mail on xoops

2005/11/30 16:06
JS
Just popping in
Posts: 87
Since: 2002/12/16

not sure if this is the right forum but I noticed that I have an old e-mail address registerd here and I would like to recived the notifications for my posts but I need to put my updated e-mail how would I go about doing this

Thanks!

[img align=left]http://www.theood.com/modules/roster/sig.php?name=Talric [/img]

72

Upgrade path from 2.0.13.1 to 2.2.x?

2005/11/30 16:03
JS
Just popping in
Posts: 87
Since: 2002/12/16

All

I am currently running 2.0.13.1 and was wondering if there was an upgrade path to 2.2.x and if not will there be one? Also I was looking around but couldn't find a good list of what the differances/ enhancements between 2.0x and 2.2. and if moduals that run in 2.0x are compatable with 2.2x seriese.

Thanks!

[img align=left]http://www.theood.com/modules/roster/sig.php?name=Talric [/img]

73

Re: Asset managment module?

2005/4/7 0:42
JS
Just popping in
Posts: 87
Since: 2002/12/16

ajuden haha I just looked at your ICON ... just wanted to say man that's funny hehe

74

Re: Asset managment module?

2005/4/4 19:50
JS
Just popping in
Posts: 87
Since: 2002/12/16

anyone have any information on this????

Thanks!

75

Re: Asset managment module?

2005/4/1 21:07
JS
Just popping in
Posts: 87
Since: 2002/12/16

Thanks for the information but I guess I am calling it the wrong thing.

Here is what I am looking for.

Basiclay was wondering if there is a module that I can use to track what hardware and software I have on my network. And it would be nice if it had functionality to say who has the hardware and what it is being used for. Also something that I can place the status of the hardware at for example

In summary I have 3 dell 1850 servers
and lets say 4 hp blades

also lets say they are running windows or linux or something so that I can put this information in and then I can see a report on what hardware I have what it current configuration is and who has it and what I have available if I am looking for something.

Does that explain a little better what it is I am looking for..

Thanks!

76

Asset managment module?

2005/4/1 20:05
JS
Just popping in
Posts: 87
Since: 2002/12/16

Has anyone ever seen or heard of development on an Asset management module for Xoops?

Thanks!

77

Help with some code please

2005/1/11 8:36
JS
Just popping in
Posts: 87
Since: 2002/12/16

hey all I am working on porting into XOOPS a guild roster for WoW. But I am having some issues. First of all the database tables are all in place and there is data in them. That was the easy part now the problem that I am having is the code I am using will not display the information from the database. Maybe someone who is better with php then me can look at the code and tell me if I am really hosed or what.


<?php

// let start including the header of xoops

include("../../mainfile.php"); // including top functions of xoops

include(XOOPS_ROOT_PATH."/header.php"); // including the rest ?>

<?php include "conf.php"; ?>



<center>

<table width="100%">

<tr><th><a class="title" href="?sort=name">Name</a></th>

<th><a class="title" href="?sort=race">Race</a></th>

<th><a class="title" href="?sort=class">Class</a></th>

<th><a class="title" href="?sort=level">Level</a></th>

<th><a class="title" href="?sort=guild_rank">Rank</a></th>

</tr>

<?php

$link = mysql_connect($db_host, $db_user, $db_passwd) or die("Could not connect");

mysql_select_db($db_name) or die("Could not select DB");



$query = "SELECT * FROM `guild_char`";

if( $guild_name != "" ){

    $query .= " WHERE guild_name = '$guild_name'";

}



if( $_REQUEST['sort'] == 'name' ) {

  $query .= " ORDER BY name";

} else if( $_REQUEST['sort'] == 'race' ) {

  $query .= " ORDER BY race";

} else if( $_REQUEST['sort'] == 'class' ) {

  $query .= " ORDER BY class";

} else if( $_REQUEST['sort'] == 'guild_rank' ) {

  $query .= " ORDER BY guild_rank"; 

} else {

  $query .= " ORDER BY level DESC";

}

print "<!-- $query -->";



$result = mysql_query($query) or die(mysql_error());





while ( $row = mysql_fetch_assoc( $result ) )

{

?>

 <tr>

<td><a class="charlink" 

href="char.php?name=<?php print $row['name']; ?>&server=<?php print $row['server']; ?>">

<?php print $row["name"]; ?></a></td>

<td><?php print $row["race"]; ?></td> 

<td><?php print $row["class"]; ?></td>

<td><?php print $row["level"]; ?></td>

<td><?php print $row["guild_rank"]; ?></td>

</tr>

<?php

}



?>

</table>

</center>





<?php

// including footer of xoops

include(XOOPS_ROOT_PATH."/footer.php");

// done

?>

maybe someone can tell me where I have gone wrong.

78

Re: Migrating user information to a new site

2004/5/1 8:13
JS
Just popping in
Posts: 87
Since: 2002/12/16

I would like to say thanks for all your help! :) Based off of some of your suggestions I came up with a solution for my little dilema. Being that I don't have a vast knowledge of MySQL I really not sure if this is the best method but it worked for me and it really was easy to do. This is what I did

First of all I installed MySQL admin on my server. (I did have myphpadmin installed the web based one but I found the one that you install directly on the server is much easyer to use)
Next I created a backup of the tables that had the data I wanted to trasfer using the backup feature of MySQL admin
Then I opend the *.sql file with a text editor and modified the database name and the prefix name to the format that I needed for the new site.
I then stoped the MySQL server deleted the tables from the new site that I would be replaceing and started the MySQL server back up.
finnaly I reconnected the MySQL admin and did a restore using the modified *.sql files. This recreated the tables I deleted in the new sites database and inserted all of the data from the old site.

That's it!
This alowed me to move all the data I wanted from the old site to the new site even though the database nameing convention was different for each site. Though I did run into some trouble restoring the *_bb_post_text part it was like it failed to restore any datad that was the lates data for each forum set I had. it would error out even though it got 99% of that data over it literaly broke the first 5 topics in each forum that I had. A solution to that is basicaly to delet those topics and everything was fine. still not sure why it did that

could have something to do with the amount of data that was being restored or maybe some sort of coruption in the orriginal database that is causing that issue. but the majority of the data has been moved and that's what counts. 5 forum topics are nothing compared to the 2+K that did successfuly make it over

Again thanks for all your help! :)

79

Re: Migrating user information to a new site

2004/5/1 8:07
JS
Just popping in
Posts: 87
Since: 2002/12/16

I would like to say thanks for all your help! :) Based off of some of your suggestions I came up with a solution for my little dilema. Being that I don't have a vast knowledge of MySQL I really not sure if this is the best method but it worked for me and it really was easy to do. This is what I did

First of all I installed MySQL admin on my server. (I did have myphpadmin installed the web based one but I found the one that you install directly on the server is much easyer to use)
Next I created a backup of the tables that had the data I wanted to trasfer using the backup feature of MySQL admin
Then I opend the *.sql file with a text editor and modified the database name and the prefix name to the format that I needed for the new site.
I then stoped the MySQL server deleted the tables from the new site that I would be replaceing and started the MySQL server back up.
finnaly I reconnected the MySQL admin and did a restore using the modified *.sql files. This recreated the tables I deleted in the new sites database and inserted all of the data from the old site.

That's it!
This alowed me to move all the data I wanted from the old site to the new site even though the database nameing convention was different for each site. Though I did run into some trouble restoring the *_bb_post_text part it was like it failed to restore any datad that was the lates data for each forum set I had. it would error out even though it got 99% of that data over it literaly broke the first 5 topics in each forum that I had. A solution to that is basicaly to delet those topics and everything was fine. still not sure why it did that

could have something to do with the amount of data that was being restored or maybe some sort of coruption in the orriginal database that is causing that issue. but the majority of the data has been moved and that's what counts. 5 forum topics are nothing compared to the 2+K that did successfuly make it over

Again thanks for all your help! :)

80

Re: Migrating user information to a new site

2004/4/30 18:31
JS
Just popping in
Posts: 87
Since: 2002/12/16

good information just a couple questions. I'm a quick learn so I'm sure I could figur this out just don't want to damage what I have going on alread

first of all are you talking about moving the physical tables or just the data? if so I think the nameing convention is different. I do change the name of the prefix so that may cause me some pain

is there a way to go in and copy the database tables over then change the table name and prefix? would that work or will I just cause coruption? I run alot of different XOOPS site but this particular one is for my gaming site and my guild is now spanning many different games so in an effort to consolidate the few websites that I have up into one site I would like to import the users information. and the forums and stuff. Basicaly I will use the handy theam stuff that is in XOOPS and let the users choos the theam for the game they are playing so the site will look like the game they are playing

I figure this should free up some space on the server and reduce the amount of over all work the MySQL server has to do.

I believe on one of my sites I have installed the myphpadmin modual that someone released some time ago could I use that to make this whole thing work? I have toyed with it a bit but not sure if I fully understand all the inner working of it thats why I came here I know alot of good people are here that know alot about this stuff and was hoping that I could get some answeres to my questions as I dig into this

Thanks for your help

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

changing e-mail on xoops

Upgrade path from 2.0.13.1 to 2.2.x?

Re: Asset managment module?

Re: Asset managment module?

Re: Asset managment module?

Asset managment module?

Help with some code please

Re: Migrating user information to a new site

Re: Migrating user information to a new site

Re: Migrating user information to a new site

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}