Jump to content

Important Notice Regarding GUID


daredevil

Recommended Posts

  • Administrators

I strongly suggest to everyone, please remove 32 character of GUID from your profile and make it last 8 only. We have also told this before and here I am saying it again, please remove 32 characters of your GUID and keep last 8.

 

All we need is last 8 characters of your GUID for your admin level set up and to check your cheating history!

 

Thank you!

Link to comment
Share on other sites

@dare Make a small script to check each guid in user db using strlen and if its 32char use substr($guid, -8)

Hope that helps.

 

EDIT:

 

How about something like this..

 

<?php
include('config.php'); //assuming config.php contains SQL connection info

echo "Please wait..";
// note i've just guessed the user table name (ipb_users) and the column names like 'etguid' and 'userid' here.. Change them accordingly

$sql = mysql_query("SELECT * FROM `ipb_users`");
while ($row = mysql_fetch_array($sql)) {

$user = $row['userid'];
$etguid = $row['etguid'];
$cod4guid = $row['cod4guid'];
$bf2guid = $row['bf2guid'];

$etguid = substr($etguid, -8); // grabs the last 8 digits of the guid
$cod4guid = substr($cod4guid, -8);
$bf2guid = substr($bf2guid, -8);

// now update it with all the new sexy 8 figure GUIDs..

mysql_query("UPDATE `ipb_users` SET `etguid`= '".$etguid."' SET `cod4guid`= '".$cod4guid."' SET `bf2guid`= '".$bf2guid."' WHERE `userid`='".$user."'");
}

// Sorry if there's any errors - i didnt test it on anything.

echo "GUID's updated!";

?>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.