Reply to thread

Message

<blockquote data-quote="Divide" data-source="post: 214845" data-attributes="member: 35464">[CODE]function randomstring($length = 10){&nbsp;&nbsp; $characters = ’0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ’;&nbsp;&nbsp; $randstring = '';&nbsp;&nbsp; for ($i = 0; $i &lt; $length; $i++)&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; $randstring = $characters[rand(0, strlen($characters))];&nbsp;&nbsp; }&nbsp;&nbsp; return $randstring;}&nbsp;function indatabase($string){&nbsp;&nbsp; global $con;&nbsp;&nbsp; $q = &quot;SELECT * FROM identities WHERE identity = '{$string}'&quot;;&nbsp;&nbsp; if(!$result = $con-&gt;query($q))&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; die(&quot;Could not execute query.&quot;);&nbsp;&nbsp; }&nbsp;&nbsp; $count = $result-&gt;num_rows;&nbsp;&nbsp; if($count &gt; 0)&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; return true;&nbsp;&nbsp; }&nbsp;&nbsp; else&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; return false;&nbsp;&nbsp; }}&nbsp;&nbsp;public function createIdentity(){&nbsp;&nbsp; $found = false;&nbsp;&nbsp; $checkstring = &quot;&quot;;&nbsp;&nbsp; $finalstring = &quot;&quot;;&nbsp;&nbsp; $times = 0;&nbsp;&nbsp; while(!$found)&nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; if($times &gt; 20)&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $found = true;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; die(&quot;Attempted to find a key too many times!&quot;);&nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; $times++;&nbsp; &nbsp; &nbsp; $checkstring = randomstring();&nbsp; &nbsp; &nbsp; if(!indatabase($checkstring))&nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $found = true;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $finalstring = $checkstring;&nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; }&nbsp;&nbsp; $return $finalstring;}[/CODE]&nbsp;Will return a string which isn't already in the database, and will only check 20 times.&nbsp;Took about 20 mins of my life to code. Will come in useful for me too <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="Divide, post: 214845, member: 35464"] [CODE] function randomstring($length = 10) { $characters = ’0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ’; $randstring = ''; for ($i = 0; $i < $length; $i++) { $randstring = $characters[rand(0, strlen($characters))]; } return $randstring; } function indatabase($string) { global $con; $q = "SELECT * FROM identities WHERE identity = '{$string}'"; if(!$result = $con->query($q)) { die("Could not execute query."); } $count = $result->num_rows; if($count > 0) { return true; } else { return false; } } public function createIdentity() { $found = false; $checkstring = ""; $finalstring = ""; $times = 0; while(!$found) { if($times > 20) { $found = true; die("Attempted to find a key too many times!"); } $times++; $checkstring = randomstring(); if(!indatabase($checkstring)) { $found = true; $finalstring = $checkstring; } } $return $finalstring; } [/CODE] Will return a string which isn't already in the database, and will only check 20 times. Took about 20 mins of my life to code. Will come in useful for me too :) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members