Dont want to display Database-login and pass..???

[Jeff Lewis]

I still think it's petty but I included a fix for you...try it out.  It's quick and could use more refining but that should work fine.

[Pebbels]

one of these days, i'll write mod for it...

hello
thx for help
nice hear it  

Pebbels

[Pebbels]

I still think it's petty but I included a fix for you...try it out.  It's quick and could use more refining but that should work fine.

Hello
thanks i will test it !

Mfg Pebbels

[Pebbels]

I still think it's petty but I included a fix for you...try it out.  It's quick and could use more refining but that should work fine.

hello
yes it works ,but its not what i want, i have delete databaseinfo from the settings.php its now in the file database_connect.php , but it would shows at adminpanel the infos again.  
 i think its same way  to read out database option from different file.

mfg Pebbels

[Jeff Lewis]

Yeah sorry, there is one other thing to change, will send it after my hockey game tonight...

[Pebbels]

hello
thx , and good luck for ur game  

Mfg Pebbels

[Razgo]

I'm not sure if I read everything correctly but you did say you only had one data base.

so why not just change the prefex?

I have 2 yaBB SE on the one data base.

now I understand that they will still see the username and password to the data base,

but you can also create another data base user name and password for that username only. and that way they won't see your personal data base username and password.

did this make any sense? it does work as long as your server allows for more than one username for your one data base.

[Jeff Lewis]

Lines 880-894 in Admin.php contain this code:

Code Select Expand

<td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse5]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_server" value="$db_server"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse6]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_user" value="$db_user"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse7]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_passwd" value="$db_passwd"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse8]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_name" value="$db_name"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse54]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_prefix" value="$db_prefix"></td>
  </tr><tr>

change it to:

Code Select Expand

<td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse5]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_server" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse6]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_user" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse7]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_passwd" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse8]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_name" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse54]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_prefix" value="bypassed"></td>
  </tr><tr>
Like I said it's a quick fix and could probably be made better elsewhere but for now that should work for you.

[Pebbels]

I'm not sure if I read everything correctly but you did say you only had one data base.

so why not just change the prefex?

I have 2 yaBB SE on the one data base.

now I understand that they will still see the username and password to the data base,

but you can also create another data base user name and password for that username only. and that way they won't see your personal data base username and password.

did this make any sense? it does work as long as your server allows for more than one username for your one data base.

hmm...yes its right, but i dont have an own server, ive  rent webspace only.

Mfg Pebbels

[Pebbels]

hello jeff
there is somthing wrong

that all my changes :
index.php :
include_once ("QueryString.php");
include_once ("Settings.php");
include_once ("database_connect.php");
include_once ($language);
include_once ("$sourcedir/Subs.php");
include_once ("$sourcedir/Load.php");
include_once ("$sourcedir/Security.php");

new file database_connect.php :
<?php
########## Database Info ##########
$db_name = "xxxx ";
$db_user = "xxxxx ";
$db_passwd = "xxxx ";
$db_server = "xxxx";
$db_prefix = "yabbse_";
?>

and thats last at Admin.php :

<td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse5]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_server" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse6]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_user" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse7]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_passwd" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse8]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_name" value="bypassed"></td>
  </tr><tr>
    <td class="windowbg2" bgcolor="$color[windowbg2]" width="400"><font size="2">$txt[yse54]</font></td>
    <td class="windowbg2" bgcolor="$color[windowbg2]"><input type="text" name="db_prefix" value="bypassed"></td>
  </tr><tr>

and now it shows  the new changes at my adminpanel :
bypassed. thats ok , but if i save settings at my adminpanel, look this error :
An Error Has Occurred!

2: Supplied argument is not a valid MySQL result resource
(/is/htdocs/xxxx/www.domain.de/ghn/yabbse/Sources/Load.php ln 120)
 
Mfg Pebbels

[Jeff Lewis]

Hmm, it should work as the values of the second include should overwrite the bypassed

I will look again shortly...

[Matt Siegman]

I'll do this tomorrow -- write a mod for the whole shebang... I just spent 12 hours writing a new Package Manager, and I kinda want to sleep....

Anyway, I got 1 fix to do b4 yours... IM me about this so I remember please

[Pebbels]

@Jeff
@Matt
 thanks for ya great support!  
@Matt im waiting for this fix , i hope it wont be so long .  

Mfg Pebbels

[Matt Siegman]

I just finished adding the last few features into the New Package Manager.  I am now gonna start on your mod and that other guy's mod

[Matt Siegman]

Done, its crude, but it works...

http://www.mattsiegman.com/YaBBSE/Packages/No_Show_MySQL_info.mod.yp

OR download with your package manager:
http://www.mattsiegman.com/YaBBSE/Packages
My package serv