Mysidia Adoptables Support Forum - Help: Admin.php File [Answered]

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - Help: Admin.php File [Answered] (http://www.mysidiaadoptables.com/forum/showthread.php?t=1312)

Help: Admin.php File [Answered]

Okay, I have been working to make a Cash/Money Mod for my adoptables site and now that I have it working, I want to make it so I can change it in the Admin CP instead of opening up the MySQL and changing the settings from there. I've gotten the needed code put into the file. So I the required form showing ( So I can see it and put input in it ) but when I press Submit it won't change.

Here is the changed code:

PHP Code:


		
			
// We are managing users...







if($do == "edit"){







    $user = $more;



    



    $query = "SELECT * FROM ".$prefix."users WHERE username = '".$user."'";



    $result = mysql_query($query);



    $num = mysql_numrows($result);







    if($num > 0){







    //The user actually exists, so allow us to edit them...



    $article_title = "User Editor - Editing ".$user."'s Account";



    $article_content = "Here you can edit the user's account using the form below.<br>";







    $i=0;



    while ($i < 1) {







    $email=@mysql_result($result,$i,"email");



    $usergroup=@mysql_result($result,$i,"usergroup");





    $i=0;



    while ($i < 1) {







    $email=@mysql_result($result,$i,"email");



    $usergroup=@mysql_result($result,$i,"usergroup");







    $i++;



    }



    $query = "SELECT * FROM ".$prefix."users WHERE username = '".$user."'";



    $result = mysql_query($query);



    $num = mysql_numrows($result);

    

    $i=0;



    while ($i < 1) {



    



    $money=@mysql_result($result,$i,"money");



    



    $i++;



    }











    //************************************************************************************************



    // BEGIN THE FORM



    //************************************************************************************************







    $article_content = $article_content."<form name='form1' method='post' action='admpost.php'>



  <p>



    <input name='delete' type='checkbox' id='delete' value='yes'> 



  <img src='templates/icons/delete.gif'> Delete This User. <strong>This cannot be undone!</strong></p>



  <p>Assign New Password: 



    <input name='pass1' type='password' id='pass1'>



</p>



  <p>Passwords may contain letters and numbers only. Leave the box blank to keep the current password.</p>



  <p>



    <input name='emailpwchange' type='checkbox' id='emailpwchange' value='yes'> 



    Email the user the new password (Only takes effect if setting a new password) </p>



  <p>Change Email Address: 



    <input name='email' type='text' id='email' value='".$email."'>



</p>



<p><u>".$user."'s Money:</u> ".$money."</p>



  <p>Change ".$user."'s Money To:<br> 



    <input name='money' type='text' id='money' value='".$money."'></p>





<p><u>".$user."'s Current Usergroup:</u> Group ".$usergroup."</p>



  <p>Change ".$user."'s Usergroup To:<br>



    <select name='level' id='level'>



      <option value='nochange' selected>Do not change</option><br><br>";



      



// We need to stop here and fetch our usergroups...







    $query = "SELECT * FROM ".$prefix."groups";



    $result = mysql_query($query);



    $num = mysql_numrows($result);







    //Loop out code



    $i=0;



    while ($i < $num) {







    $groupname=@mysql_result($result,$i,"groupname");



    $groupid=@mysql_result($result,$i,"gid");



    



    $article_content = $article_content."<option value='".$groupid."'>Group ".$groupid." :: ".$groupname."</option>";    







    $i++;



    }







$article_content = $article_content."</select>



  </p>







  <p>    <input name='page' type='hidden' id='page' value='users'>



    <input name='username' type='hidden' id='username' value='".$user."'>



  </p>



  <p>



    <input type='submit' name='Submit' value='Submit'>



</p>



</form>";

Any ideas on how I'm suppose to save it in the Database? ( If you want screen shots of the web page, tell me. )

Edit: Never mind, I found out how to do it. :D

RE: Help: Admin.php File [Answered]

a friend is working on something similar for me as well, but they are having the same problem ---- how did you manage to do it? ;)

RE: Help: Admin.php File [Answered]

Read ALL of this before you start making changes on your website. Also, it is not my fault if you mess your own website up, not me. I had to remake my website when I messed something up, so take great care when you work this out. ( I'm just trying to make it obvious it's not my fault if you ruin something. :P )

There is a file called admpost.php. Go to line 878 it should say "else if($page == "users"){" then go down a bit and you should see something like:

$username = $_POST["username"];

$username = secure($username);

Then copy and paste that and change it to:

$moneys = $_POST["moneys"];

$moneys = secure($moneys);

And put it after the list of the variables and posts and secures. ( 'moneys' should be whatever the 'input id/name' is on admin.php ) Then go down to line 931 and a little bit after that you should see:

$query = "UPDATE ".$prefix."users SET email='".$email."' WHERE username='".$username."'";

mysql_query($query);

Then copy that and paste it under that then change it to:

$query = "UPDATE ".$prefix."users SET money='".$moneys."' WHERE username='".$username."'";

mysql_query($query);

Then save it and try it on a 'test' account. Notes:
1. This is just if you have already created the cash/money column in the users table.
2. Make sure, on the input id/name is different from the variable. I made a mistake and put:

<input name='money' type='text' id='money' value='".$money."'>

instead of something different like:

<input name='moneys' type='text' id='moneys' value='".$money."'>

If you don't have the cash/money column then run a MySql query and put:

ALTER TABLE users
ADD money INT(11) NULL DEFAULT '0'

in it. Then change 'users' to what ever the table name is for the users. Mine is 'adopt_users' so I changed it to:

ALTER TABLE adopt_users
ADD money INT(11) NULL DEFAULT '0'

Then run the query.

Note: There may be some files that require changing to work correctly, like the "register.php" has:

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','','','','')");

( *cough* This is a copy from some other MySql/PHP stuff I'm doing, so there may be some extra ,'' things that are different from yours *cough* ) and you will need to add a ,'0' before the )" but after the ,'' ( lol ) so, just a warning that you probably need to fix those sorts of things.

If you have read everything closely, then you may begin making changes. :P ( I'll make a more detailed explanation some other day, you'll just have to remind me. :P )