Reply to thread

Message

<blockquote data-quote="brsy" data-source="post: 94214" data-attributes="member: 2912">SupaUpdate&nbsp;SupaUpdate is a quick and easy tool that can be used to set one value to a mass amount of data within a database, plus it's secure! Here is the code, put it into a PHP file and name it whatever you want so people can't find it. Afterwards, open the file using a PHP file editor, and edit lines 17-21. Save, then you're done! Code:[PHP]&lt;?php&nbsp;/*&nbsp;* Script Name: SupaUpdater&nbsp;* Script Description: Database alterations made easy.&nbsp;* Created by: ChrizPHP&nbsp;* Released on: N/A&nbsp;*&nbsp;* This script was created by ChrizPHP, on behalf of ***** -- an all-around&nbsp;* development group dedicated on providing top-quality products to the&nbsp;* internet.&nbsp;*/&nbsp;&nbsp;&nbsp;function filter($str) {&nbsp;&nbsp; &nbsp; mysql_real_escape_string(htmlentities($str));&nbsp;}&nbsp;&nbsp;&nbsp;$supa['dbDatabase'] = 'bullet'; // database that has your hotel's DB.&nbsp;$supa['dbUsername'] = 'root'; // username to connect to database (usually root)&nbsp;$supa['dbHostname'] = 'localhost'; // hostname for databases (usually localhost)&nbsp;$supa['dbPassword'] = 'abc123'; // password used to connect to database&nbsp;$supa['adminPassword'] = 'supaPassword'; // password used to sign into SupaUpdate&nbsp;&nbsp;&nbsp;$connect = mysql_pconnect($supa['dbHostname'], $supa['dbUsername'], $supa['dbPassword']);&nbsp;mysql_select_db($supa['dbDatabase'], $connect);&nbsp;&nbsp;&nbsp;if(isset($_POST['done'])) {&nbsp;&nbsp; &nbsp; $column = filter($_POST['column']);&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; $value = filter($_POST['value']);&nbsp;&nbsp; &nbsp; $table = filter($_POST['table']);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;UPDATE &quot;.$table.&quot; SET &quot;.$column.&quot; = '&quot;.$value.&quot;'&quot;);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; $error = mysql_error();&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; if(isset($error)) {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die($error. '&lt;br /&gt;&lt;b&gt;Refresh the page to try again.&lt;b&gt;');&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;}&nbsp;&nbsp;&nbsp;if(!isset($_SESSION['logged'])) { ?&gt;&nbsp;&lt;form action=&quot;&quot; method=&quot;POST&quot;&gt;&nbsp;&nbsp; &nbsp; &lt;label&gt;Administrative Password:&lt;/label&gt;&nbsp;&nbsp; &nbsp; &lt;input type=&quot;password&quot; name=&quot;password&quot; /&gt;&nbsp;&nbsp; &nbsp; &lt;input type=&quot;submit&quot; name=&quot;login&quot; /&gt;&nbsp;&lt;/form&gt;&nbsp;&nbsp; &nbsp; &lt;?php&nbsp;&nbsp; &nbsp; if(isset($_POST['login'])) {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; if($_POST['password'] != $supa['adminPassword']) {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die('The password you have entered does not match the password you have set for supaUpdate. If you have not yet created a password, please edit your SupaUpdate file.');&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; else {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['logged'] = true;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; }&nbsp;}&nbsp;if(isset($_SESSION['logged'])) {&nbsp;?&gt;&nbsp;&lt;center&gt;&nbsp;&nbsp; &nbsp; &lt;h3&gt;supaUpdater&lt;/h3&gt;&lt;hr /&gt;&nbsp;&nbsp; &nbsp; &lt;form method=&quot;POST&quot; action=&quot;&quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;Table Name:&lt;/label&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input style=&quot;width:175px;&quot; type=&quot;text&quot; name=&quot;table&quot; /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;Altered Column:&lt;/label&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input style=&quot;outline: #FFF000;margin-right:19px;width:175px;&quot; type=&quot;text&quot; name=&quot;column&quot; /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;New Value: &lt;/label&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input style=&quot;margin-left:6px;width:175px;&quot; type=&quot;text&quot; name=&quot;value&quot; /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; style=&quot;height:30px;width:270px;&quot; value=&quot;Make Changes!&quot; name=&quot;done&quot; /&gt;&nbsp;&nbsp; &nbsp; &lt;/form&gt;&nbsp;&lt;/center&gt;&nbsp;&lt;?php } ?&gt;[/PHP]</blockquote>

[QUOTE="brsy, post: 94214, member: 2912"] [SIZE=5][B]SupaUpdate[/B][/SIZE] [SIZE=3]SupaUpdate is a quick and easy tool that can be used to set one value to a mass amount of data within a database, plus it's secure! Here is the code, put it into a PHP file and name it whatever you want so people can't find it. Afterwards, open the file using a PHP file editor, and edit lines 17-21. Save, then you're done! [/SIZE] [SIZE=2][B][/B][/SIZE] [B][SIZE=3]Code:[/SIZE][/B] [PHP]<?php /* * Script Name: SupaUpdater * Script Description: Database alterations made easy. * Created by: ChrizPHP * Released on: N/A * * This script was created by ChrizPHP, on behalf of ***** -- an all-around * development group dedicated on providing top-quality products to the * internet. */ function filter($str) { mysql_real_escape_string(htmlentities($str)); } $supa['dbDatabase'] = 'bullet'; // database that has your hotel's DB. $supa['dbUsername'] = 'root'; // username to connect to database (usually root) $supa['dbHostname'] = 'localhost'; // hostname for databases (usually localhost) $supa['dbPassword'] = 'abc123'; // password used to connect to database $supa['adminPassword'] = 'supaPassword'; // password used to sign into SupaUpdate $connect = mysql_pconnect($supa['dbHostname'], $supa['dbUsername'], $supa['dbPassword']); mysql_select_db($supa['dbDatabase'], $connect); if(isset($_POST['done'])) { $column = filter($_POST['column']); $value = filter($_POST['value']); $table = filter($_POST['table']); mysql_query("UPDATE ".$table." SET ".$column." = '".$value."'"); $error = mysql_error(); if(isset($error)) { die($error. ' Refresh the page to try again.'); } } if(!isset($_SESSION['logged'])) { ?> <form action="" method="POST"> <label>Administrative Password:</label> <input type="password" name="password" /> <input type="submit" name="login" /> </form> <?php if(isset($_POST['login'])) { if($_POST['password'] != $supa['adminPassword']) { die('The password you have entered does not match the password you have set for supaUpdate. If you have not yet created a password, please edit your SupaUpdate file.'); } else { $_SESSION['logged'] = true; } } } if(isset($_SESSION['logged'])) { ?> <center> <h3>supaUpdater</h3><hr /> <form method="POST" action=""> <label>Table Name:</label> <input style="width:175px;" type="text" name="table" /> <label>Altered Column:</label> <input style="outline: #FFF000;margin-right:19px;width:175px;" type="text" name="column" /> <label>New Value: </label> <input style="margin-left:6px;width:175px;" type="text" name="value" /> <input type="submit" style="height:30px;width:270px;" value="Make Changes!" name="done" /> </form> </center> <?php } ?>[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members