Wizard

Ah, this topic again.. too bad my friend, vets are no longer have their value as they used to. Good luck tho ;)

The plot for the episodes can be found down in spoiler! have fun

I would like to see :wiz: here are some suggestions:

What is your favorite part of being moderator ? PS: can you change my username to Maldesto?

"Asma3 oktol al bot!" lmfaoooooooooooooo

first

You know, deep down, you want me to be the next CBA! make it happen, make the chatbox great again, #Wizard2k16

kys anime lovers!

GraphicUtilities#drawModel(org.osbot.rs07.Bot bot, java.awt.Graphics2D g, int gridX, int gridY, int z, Model model)

\t(tab).. some people just want to watch the world burn

. . . . . . .

OK THIS IS NOT A TUTORIAL, THERE WILL BE NO EXPLINATION..! Ok start by creating a SQL table using this through myPHPAdmin: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; CREATE TABLE `scriptdata` ( `username` text NOT NULL, `xp` int(11) NOT NULL, `runtime` bigint(255) NOT NULL, `id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; ALTER TABLE `scriptdata` ADD PRIMARY KEY (`id`); ALTER TABLE `scriptdata` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; then make a php file call it what ever you want, I called mine validate.php. This file is responsible on validating the data, inserting and updating the database, it can only be accessed through custom useragent which is specified by the user (to prevent others from submitting fake details through browser)! <?php $useragent = "scriptX";//Change this to whatever you want, just make sure it matches w.e you put in javaside! $ua= $_SERVER["HTTP_USER_AGENT"]; if(!preg_match('/'.$useragent.'/', $ua)) { echo"GTFO out of here!"; } else { $database_name = ""; $servername = "localhost";//database host $username = "root";//database username $password = "";//database password $runtime=$gainedXp=$rsn=""; // Create connection $conn = new mysqli($servername, $username, $password, $database_name; // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } if ($_SERVER["REQUEST_METHOD"] == "GET") { $rsn = mysqli_real_escape_string($conn, $_GET["rsn"]); $gainedXp = mysqli_real_escape_string($conn, $_GET["gainedxp"]); $runtime = mysqli_real_escape_string($conn,$_GET["runtime"]); } $sql = "SELECT * FROM scriptdata WHERE `username`='".$rsn."'"; $result = $conn->query($sql); if($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $prevXp= $row["xp"]; $prevTime = $row["runtime"]; $prevXp+= $gainedXp; $prevTime+= $runtime; $sql = "UPDATE scriptdata SET xp=".$prevXp.", runtime=".$prevTime." WHERE `username`='".$rsn."'"; if($conn->query($sql) === TRUE){ echo "DATA WAS UPDATED"; } else { echo "ERROR UPDATING DATA! ". mysqli_error($conn); } } } else { $sql = "INSERT INTO scriptdata(`username`,`xp`,`runtime`) VALUES('".$rsn."',".$gainedXp.",".$runtime.")"; if($conn->query($sql) === TRUE){ echo "DATA INSERTED"; } else { echo "ERROR INSERTING DATA!<br>". mysqli_error($conn); } } } ?> After that, make another php file call it w.e you want, mine is called sig.php. This is the actual file which gonna retrieve the information from the database and display them on a picture! <?php function ftime($time) { $text = ""; $secs = (intval(intval($time) / 1000)); $hrs = $secs / 3600; $m = $secs / 60 % 60; $secs = $secs % 60; if($hrs < 10) { $text.="0".$hrs; } else { $text.=$hrs; } $text.=":"; if($m < 10) { $text.="0".$m; } else { $text.=$m; } $text.=":"; if($sec < 10) { $text.="0".$secs; } else { $text.=$secs; } return $text; } $database_name = ""; $servername = "localhost";//database host $username = "root";//database username $password = "";//database password $sig_file = "sig.png";//signature picture path $font_path = 'bboron.ttf';//font file path $rsn = ""; $conn = new mysqli($servername, $username, $password, $database_name); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } if ($_SERVER["REQUEST_METHOD"] == "GET") { $rsn = mysqli_real_escape_string($conn, $_GET["rsn"]); } $sql = "SELECT * FROM scriptdata WHERE username='".$rsn."'"; $result = $conn->query($sql); if($result->num_rows > 0) { while($row = $result->fetch_assoc()) { //Set the Content Type header('Content-type: image/jpeg'); $xp = $row["xp"]; $runtime = $row["runtime"]; $formated = ftime($runtime); // Create Image From Existing File $pngimage = imagecreatefrompng($sig_file); // Allocate A Color For The Text $black = imagecolorallocate($pngimage, 0, 0, 0); // Print Text On Image //imagettftext(imagefile, text size, ange, x, y, text color, font_file, text); imagettftext($pngimage, 16, 0, 115, 45, $black, $font_path, $rsn); imagettftext($pngimage, 16, 0, 115, 85, $black, $font_path, $xp); imagettftext($pngimage, 16, 0, 115, 124, $black, $font_path, $formated); // Send Image to Browser imagepng($pngimage); // Clear Memory imagedestroy($pngimage); } } else { echo "user does not exist!"; } ?> JUST MAKE SURE TO CHANGE THE INFO OF THE DB, FONT AND IMAGE TO MATCH YOURS! Now to send data from your script use this first declare two variables //Your url private static final String URL = "http://yourwebsite.com/validate.php?"; //put it the same as the one in PHP! private static final String USER_AGENT = "scriptX"; and use this function to send data public static void sendData(String rsn, int xp, long runtime) { String vars = URL + "rsn=" + rsn + "&gainedxp=" + xp + "&runtime=" + runtime; StringBuilder result = new StringBuilder(); URL url; try { url = new URL(vars); HttpURLConnection conn = (HttpURLConnection) url.openConnection(); conn.setRequestMethod("GET"); conn.addRequestProperty("User-Agent", USER_AGENT); BufferedReader rd = new BufferedReader(new InputStreamReader(conn.getInputStream())); String line; while ((line = rd.readLine()) != null) { result.append(line); } System.out.println(result.toString()); rd.close(); } catch (Exception e) { } } And thats all! Few notes, 1) The data only being sent are the username, xp gained and runtime.. you can add more but you have to edit all the files to match your changes. 2) dont judge my php i dont even know that language i just put some code i googled together! 3)Thanks for Xylate for helping me with php. you can see live example : http://scriptme.ga/sig.php?rsn=zezima (Remove if this is against the rules) Have fun!