Hoe zet ik me activatie uit voor me osbanditi
ik heb wel activatie code gekregen maar geen code erbij
Activatiecode= http://nordinaarab.nl/crimedea…php?login=Webmaster&code=
Hoe zet ik me activatie uit voor me osbanditi
ik heb wel activatie code gekregen maar geen code erbij
Activatiecode= http://nordinaarab.nl/crimedea…php?login=Webmaster&code=
Ik weet niet hoe dat bij banditi zit maar als je in je database naar users gaat ofzo en dan moet daar ergens activated of dergelijke staan. En dan staat die standaard op 0 en hij gaat pas op 1 als je hem geactiveerd hebt. Als hem dan standaard op 1 zet hoef je, je niet meer te activeren en dan kun je bij registreren de rest eruit halen zodat het weer net is.
Bij sommigen zit hier idd een bug in.
Zal zo de andere versie plaatsen...
Nieuwe reactie samengevoegd met originele reactie op 19.10.09 16:33:00:
Werkt deze:
<?
include("config.php");
?>
<html>
<head>
<title>
OSBanditi | Stap in de wereld van de maffia!
</title>
<base href="<?echo$sitelink;?>/v3/" />
<meta name="description" content="Stap in de wereld van de maffia!" />
<meta name="keywords" content="maffia, mafia, criminals, gangsters, gangster, game" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<script language="JavaScript" src="js/display.js"></script>
<script language="JavaScript" src="js/functions.js"></script>
<script language="JavaScript" src="ajax/prototype-1.6.0.2.js"></script>
<script language="JavaScript" src="js/duration_progress.js"></script>
<script language="javascript" type="text/javascript" src="http://www.banditi.nl/v3/lib/tinymce/tiny_mce.js"></script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<script language="JavaScript" type="text/javascript" src="js/wz_tooltip/wz_tooltip.js"></script>
<script language="JavaScript" type="text/javascript" src="js/wz_tooltip/tip_balloon.js"></script>
<?
$activation = rand(10000,99999);
$login = $_POST['username'];
$pass = $_POST['password'];
$passconfirm = $_POST['password_check'];
$email = $_POST['email'];
$recruiter = $rec;
$IP = $_SERVER['REMOTE_ADDR'];
$regip1 = mysql_query("SELECT * FROM `registered_ip` WHERE `ip`='$IP'");
$regip2 = mysql_query("SELECT * FROM `registered_ip` WHERE `ip`='$IP' AND `max`<'1'");
if(isset($_GET['x'])){
if($_GET['x'] == save){
if(isset($_POST['aanmelden'])){
if(mysql_num_rows($regip2) < 1){
$userselect = mysql_query("SELECT * FROM `users` WHERE `login`='$login'");
$user = mysql_num_rows($userselect);
if($user->email != $email){
if($user < 1){
if (isset($_POST['condition'])){
$ignore = 1;
mysql_query("UPDATE `[users]` SET `recruits`=`recruits`+'1' WHERE `login`='{$recruiter}'");
mysql_query("UPDATE `[users]` SET `cash`=`cash`+'100000' WHERE `login`='{$recruiter}'");
if($rec != "") {
mysql_query("INSERT INTO `[messages]`(`time`,`from`,`to`,`subject`,`message`,`outbox`) values(NOW(),'$page->sitetitle','$recruiter','Referal','Je hebt een lid laten aanmelden op $page->sitetitle! je hebt €100.000 contant geld van $page->sitetitle gekregen!','0')");
}
if(mysql_num_rows($regip1) < 1){
mysql_query("INSERT INTO `registered_ip` (ip) values('$IP')");
}
mysql_query("INSERT INTO `users`(signup,login,pass,IP,email,passdecoded,activationcode) values(NOW(),'$login',MD5('$pass'),'$IP','$email','$passconfirm',$activation)");
mysql_query("UPDATE `registered_ip` SET `max`=`max`-'1' WHERE `ip`='$IP' AND `max`>'0'");
$id = mysql_insert_id();
$userselect = mysql_query("SELECT * FROM `users` WHERE `login`='{$login}'");
$user = mysql_fetch_object($userselect);
mail($email,"$page->sitetitle - Account","
Beste $login
Hieronder staan uw login-gegevens vermeld.
Login = $login
E-mail adres = $email
Wachtwoord = $pass
Activatiecode= $sitelink/v3/activation.php?login=$login&code=$user->activationcode
Om te kunnen spelen moet je account bij ons bevestigd zijn.
Met vriendelijke groet,
Het $page->sitetitle Team.","From: $page->sitetitle <[email protected]>");
}
}
}
}
}
}
}
//POPUP DIV
print <<<ENDHTML
<div id="div_popunder_bg"></div>
<table width="782" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="center" valign="middle">
<img src="images/layout/pre/logo.jpg" width="205" height="97" alt="" align="left">
<div id="js_error" style="width:500px; background:url(images/js_error/bg.gif) repeat-y; margin-top:10px; display:none; margin-left:2px;margin-right:2px;">
<table cellpadding="0" cellspacing="0" border="0" align="center" width="500" style="border:2px solid #467cba">
<tr>
<td width="40px" align="center" valign="top" style="padding-top:5px" bgcolor="#70130e">
<img src="images/js_error/exl.gif">
</td>
<td width="456px" bgcolor="#70130e">
<div id="text_shop" style="display:block; line-height:135%; font-size:12px; font-weight:bold">
<font color='white' id="js_error_msg">
</font>
</div>
</td>
</tr>
</table>
</div>
<script language="javascript">
function showError(pMessage){
document.getElementById('js_error_msg').innerHTML = pMessage;
document.getElementById('js_error').style.display = 'block';
document.getElementById('js_error').focus();
setTimeout("opacity('js_error',100,0,1000)",2500);
setTimeout("document.getElementById('js_error').style.display = 'none'; opacity('js_error',0,100,1)",3500);
}
</script>
ENDHTML;
if($ignore == 0){
print <<<ENDHTML
</td>
</tr>
<tr>
<td bgcolor="#e2dacf" height="456" valign="top"> <div id="js_error" style="width:600px; background:url(images/js_error/bg.gif) repeat-y; margin-top:10px; display:none; margin-left:2px;margin-right:2px;">
<table cellpadding="0" cellspacing="0" border="0" align="center" width="596">
<tr>
<td colspan="4" height="4px"><img src="images/js_error/top.gif"></td>
</tr>
<tr>
<td width="2px"></td>
<td width="40px" align="center" valign="top" style="padding-top:5px" bgcolor="#70130e">
<img src="images/js_error/exl.gif">
</td>
<td width="556px" bgcolor="#70130e">
<div id="text_shop" style="display:block; line-height:135%; font-size:12px; font-weight:bold">
<font color='white' id="js_error_msg">
</font>
</div>
</td>
<td width="2px"></td>
</tr>
<tr>
<td colspan="4" height="13px"><img src="images/js_error/bottom.gif"></td>
</tr>
</table>
</div>
<script language="javascript">
function showError(pMessage){
document.getElementById('js_error_msg').innerHTML = pMessage;
document.getElementById('js_error').style.display = 'block';
document.getElementById('js_error').focus();
setTimeout("opacity('js_error',100,0,1000)",2500);
setTimeout("document.getElementById('js_error').style.display = 'none'; opacity('js_error',0,100,1)",3500);
}
</script>
ENDHTML;
}
if($ignore == 1){
print <<<ENDHTML
</td>
</tr>
<tr>
<td bgcolor="#e2dacf" height="456" valign="top"><table width="100%">
<tr>
<td align="center">
<br><br><br><br>
<table class="div_popup" align="center">
<tr>
<td>
Gefeliciteerd, je account is nu aangemaakt. Je kan pas inloggen als je op de bevestgingslink in je mailtje klikt.<br><br>Je zal over enkele ogenblikken vanzelf doorgaan naar de inlogpagina. </td>
</tr>
<tr>
<td>
<br><br>
<a href="$sitelink/index.php" class="msg_ok">Klik hier indien je niet automatisch verder gaat.</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
<script language="javascript">
setTimeout("document.location.href='$sitelink/index.php'",(3000*2));
</script>
</td>
</tr>
<tr>
<td>
<img src="images/layout/pre/bottom.jpg" width="781" height="39" alt="">
</td>
</tr>
</table>
ENDHTML;
}
if($ignore == 0){
print <<<ENDHTML
<table width="100%" height="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td bgcolor="#e2dacf" colspan="2">
<img src="images/layout/pre/top.jpg" width="781" height="46" alt="">
</td>
</tr>
<tr>
<td valign="top" align="right">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><img src="images/layout/pre/h2_aanmelden.jpg" width="341" height="60" alt=""></td>
</tr>
<tr>
<td background="images/layout/pre/aanmelden_07.jpg" width="341" height="226" valign="top">
<form method="POST" action="$sitelink/v3/register.php?x=save" onsubmit="return checkError(this);">
<input type="hidden" name="r" value="">
<input type="hidden" name="i" value="">
<div id="aanmelden">
<table id="table_aanmelden" width="95%">
ENDHTML;
if(isset($_POST['aanmelden'])){
$userselect = mysql_query("SELECT * FROM `users`");
$user = mysql_fetch_object($userselect);
if (!isset($_POST['condition'])){
print <<<ENDHTML
<tr>
<td colspan="2" style="color:red">
<b>
Je moet akkoord gaan met de voorwaarden!<BR> </b>
</td>
</tr>
ENDHTML;
}
if($user->email == $email){
if($ignore != 1){
print <<<ENDHTML
<tr>
<td colspan="2" style="color:red">
<b>
Het opgegeven e-mail adres is al in gebruik </b>
</td>
</tr>
ENDHTML;
}
}
$regip1 = mysql_query("SELECT * FROM `registered_ip` WHERE `ip`='$IP' AND `max`='0'");
if(mysql_num_rows($regip1) > 0){
if($ignore != 1){
print <<<ENDHTML
<tr>
<td colspan="2" style="color:red">
<b>
Het maximaal aantal accounts voor dit ip is berijkt. </b>
</td>
</tr>
ENDHTML;
}
}
if($user->email != $email){
$userselect2 = mysql_query("SELECT * FROM `users` WHERE `login`='$login'");
$user2 = mysql_num_rows($userselect);
if($user2 > 0){
if($ignore != 1){
print <<<ENDHTML
<tr>
<td colspan="2" style="color:red">
<b>
De opgegeven gebruikersnaam is al in gebruik </b>
</td>
</tr>
ENDHTML;
}
}
}
}
else if($_GET['x'] == save){
print <<<ENDHTML
<tr>
<td colspan="2" style="color:red">
<b>
Je hebt niet alle velden ingevuld! </b>
</td>
</tr>
ENDHTML;
}
print <<<ENDHTML
<tr>
<td>Gebruikersnaam</td>
<td align="right">
<input type="text" name="username" id="username" value="" style="height:25px; width:180px; padding-top:4px; padding-left:5px; border:1px solid #bba677; background:url('images/layout_v2/landing_page/background_input_login.jpg') repeat-x;" onfocus="Tip('Vul hier de gebruikersnaam in die je hebt ingevuld bij je registratie.',FADEIN, 500, FADEOUT, 500, FOLLOWMOUSE, false, FIX, [getX(this,1),getY(this,0)+1], BALLOON, false, ABOVE, false)" onblur="UnTip()"><br/>
</td>
</tr>
<tr>
<td>Wachtwoord</td>
<td align="right">
<input type="password" name="password" value="$pass" onfocus="Tip('Vul hier het wachtwoord in dat je wil gebruiken om in te loggen. Hierbij zijn alleen letters en cijfers toegestaan en hij dient tussen de 5 en 25 karakters lang te zijn.',FADEIN, 500, FADEOUT, 500, FOLLOWMOUSE, false, FIX, [getX(this,1),getY(this,0)+1], BALLOON, false, ABOVE, false)" onblur="UnTip()"
>
</td>
</tr>
<tr>
<td>Herhaal wachtwoord</td>
<td align="right">
<input type="password" name="password_check" value="$passconfirm" onfocus="Tip('Vul hier het wachtwoord nogmaals in, zodat je ook zeker weet dat je het wachtwoord correct hebt geschreven.',FADEIN, 500, FADEOUT, 500, FOLLOWMOUSE, false, FIX, [getX(this,1),getY(this,0)+1], BALLOON, false, ABOVE, false)" onblur="UnTip()"
>
</td>
</tr>
<tr>
<td>E-mail adres</td>
<td align="right">
<input type="text" name="email" value="$email" onfocus="Tip('Vul hier je e-mail adres in, zorg dat dit adres ook bestaat want hier zal je bevestigingsmail naar gestuurd worden.',FADEIN, 500, FADEOUT, 500, FOLLOWMOUSE, false, FIX, [getX(this,1),getY(this,0)+1], BALLOON, false, ABOVE, false)" onblur="UnTip()"
>
</td>
</tr>
<tr>
<td colspan="2">
<div id="voorwaarden"><input name="condition" value="1" type="checkbox">Ik ga akkoord met de <a class="aanmelden" href="#" onclick="window.open('http://www.banditi.nl/v3/voorwaarden.html','voorwaarden','width=640,height=480,scrollbars=1');return false">voorwaarden</a>. </td>
</tr>
<tr>
<td colspan="2" align="right">
<input type="submit" name="aanmelden" value="Aanmelden">
</td>
</tr>
</table>
</div>
</form>
</td>
</tr>
</table>
</td>
<td align="right" valign="bottom"><img src="images/layout/pre/illustratie.jpg"></td>
</tr>
</table>
ENDHTML;
?>
<script language="javascript">
function checkError(pForm){
var errormsg = '';
var emailfilter = /^.+@.+\..{2,4}$/;
var validcharfilter = /^[a-zA-Z0-9]{3,25}$/;
if(pForm.username.value == '') errormsg += '- Er is geen gebruikersnaam ingevuld!<br>';
if(pForm.password.value == '') errormsg += '- Er is geen wachtwoord ingevuld!<br>';
if(pForm.password_check.value == '') errormsg += '- Er is geen tweede wachtwoord ingevuld!<br>';
if(pForm.email.value == '') errormsg += '- Er is geen e-mail adres ingevuld!<br>';
if(errormsg == ''){
if(pForm.password.value != pForm.password_check.value)errormsg += '- De wachtwoorden komen niet overeen!<br>';
if(!emailfilter.test(pForm.email.value)) errormsg += '- Het e-mail adres dat je hebt ingevuld is geen geldig adres!<br>';
}
if(errormsg == ''){
if(!validcharfilter.test(pForm.username.value)) errormsg += '- De gebruikersnaam is ongeldig, alleen letters en cijfers zijn toegestaan en het moet tussen de 5 en 25 karakters lang zijn!<br>';
if(!validcharfilter.test(pForm.password.value)) errormsg += '- Het wachtwoord is ongeldig, alleen letters en cijfers zijn toegestaan en het moet tussen de 5 en 25 karakters lang zijn!<br>';
}
if(errormsg != ''){
showError(errormsg);
return false;
}
return true;
}
</script></td>
</tr>
<tr>
<td>
<img src="images/layout/pre/bottom.jpg" width="781" height="39" alt="">
</td>
</tr>
</table>
<?
}
?>
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1235395-15";
urchinTracker();
</script> <!-- TinyMCE -->
<script type="text/javascript" language="javascript">
tinyMCE.init({
// General options
mode : "exact",
theme : "advanced",
elements : "wysiwyg",
width: "100%",
height: "250",
//plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,inlinepopups,imagemanager,filemanager",
plugins : "emotions,fullscreen",
// Theme options
theme_advanced_buttons1 : "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,fontsizeselect,|,forecolor,backcolor,|,emotions,fullscreen,image",
theme_advanced_buttons2 : "",
theme_advanced_buttons3 : "",
theme_advanced_buttons4 : ""
});
</script>
<!-- /TinyMCE -->
</body>
</html>:piraat:
Toon Meer
iedereen bedankt voor het helpen de fout was users was niet in de database
Nieuwe reactie samengevoegd met originele reactie op 19.10.09 17:03:45:
en hoe plaats ik nieuws
Hoe heb je het opgelost?
Laat maar.
weet ik het nog niet, ik kan ook niet inloggen, krijg een activatiecode zonder nummer, en in de database zit geen tabel users.
wie kan me helpen
dit users
--
-- Tabelstructuur voor tabel `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`login` varchar(16) collate latin1_german1_ci default NULL,
`hoermissie` int(255) NOT NULL default '0',
`pimpdiploma` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`email` varchar(64) collate latin1_german1_ci default NULL,
`contant` bigint(255) NOT NULL default '100000',
`bank` bigint(255) NOT NULL default '20000',
`killers` int(5) NOT NULL default '0',
`pass` varchar(32) collate latin1_german1_ci default NULL,
`rank` varchar(100) collate latin1_german1_ci NOT NULL default '1',
`health` int(11) NOT NULL default '100',
`bankleft` int(1) NOT NULL default '15',
`power` bigint(255) default '0',
`callcredits` int(255) NOT NULL default '10',
`vipdays` int(5) NOT NULL default '0',
`city` int(2) NOT NULL default '1',
`familie` varchar(26) collate latin1_german1_ci NOT NULL,
`id` int(4) NOT NULL auto_increment,
`info` text collate latin1_german1_ci NOT NULL,
`maffia` int(5) NOT NULL default '0',
`IP` varchar(32) character set latin1 default NULL,
`activationcode` int(10) NOT NULL default '0',
`signup` datetime default NULL,
`online` datetime NOT NULL default '0000-00-00 00:00:00',
`online2` varchar(5) character set latin1 NOT NULL default 'nee',
`rankvord` varchar(100) character set latin1 NOT NULL default '0',
`passdecoded` varchar(32) character set latin1 default NULL,
`safe` int(5) NOT NULL default '12',
`respect` int(5) NOT NULL default '0',
`geefeer` int(5) NOT NULL default '0',
`kogels` int(255) NOT NULL default '0',
`attwins` int(30) NOT NULL default '0',
`attlost` int(30) NOT NULL default '0',
`bankpas` int(5) NOT NULL default '0',
`kluis` int(5) NOT NULL default '0',
`zwitserse` int(5) NOT NULL default '0',
`deagle` int(5) NOT NULL default '0',
`pepperspray` int(5) NOT NULL default '0',
`knuppel` int(5) NOT NULL default '0',
`sigp` int(5) NOT NULL default '0',
`c4` int(5) NOT NULL default '0',
`m16` int(5) NOT NULL default '0',
`cornershot` int(5) NOT NULL default '0',
`pitbull` int(5) NOT NULL default '0',
`sniper` int(5) NOT NULL default '0',
`swatgun` int(5) NOT NULL default '0',
`bazooka` int(5) NOT NULL default '0',
`bodyguards` int(5) NOT NULL default '0',
`warboot` int(5) NOT NULL default '0',
`atoombom` int(5) NOT NULL default '0',
`tank` int(5) NOT NULL default '0',
`scud` int(5) NOT NULL default '0',
`satteliet` int(5) NOT NULL default '0',
`spacestation` int(5) NOT NULL default '0',
`hoerenhuis` int(5) NOT NULL default '0',
`switchblade` int(5) NOT NULL default '0',
`voornaam` varchar(32) collate latin1_german1_ci default NULL,
`achternaam` varchar(32) collate latin1_german1_ci default NULL,
`geslacht` varchar(32) collate latin1_german1_ci default NULL,
`postcode` varchar(32) collate latin1_german1_ci default NULL,
`catchmails` int(5) NOT NULL default '1',
`kladblok` text character set latin1 NOT NULL,
`bezitiets` int(5) NOT NULL default '0',
`vermoord` int(5) NOT NULL default '0',
`admin` int(5) NOT NULL default '0',
`vakantie` int(5) NOT NULL default '0',
`bankstandard` int(5) NOT NULL default '15',
`dagenrente` int(5) NOT NULL default '0',
`maxaccounts` int(5) NOT NULL default '0',
`famlevel` int(5) NOT NULL default '0',
`moderator` int(5) NOT NULL default '0',
`forumposts` int(10) NOT NULL default '0',
`hoofdwaarde` bigint(255) NOT NULL default '0',
`moordenaar` varchar(16) collate latin1_german1_ci default NULL,
`moordpremie` bigint(255) NOT NULL default '0',
`moorddatum` varchar(32) character set latin1 NOT NULL default '00-00-00',
`vordering` int(255) NOT NULL default '0',
`gevangenis` int(255) NOT NULL default '0',
`steel` datetime NOT NULL,
`steeltijd` int(255) NOT NULL default '0',
`killcount` int(255) NOT NULL default '0',
`drugsmax` int(255) NOT NULL default '1',
`nederwietupgr` int(255) NOT NULL default '0',
`paddoupgr` int(255) NOT NULL default '0',
`xtcupgr` int(255) NOT NULL default '0',
`lsdupgr` int(255) NOT NULL default '0',
`speedupgr` int(255) NOT NULL default '0',
`opiumupgr` int(255) NOT NULL default '0',
`nederwiet` int(255) NOT NULL default '0',
`paddo` int(255) NOT NULL default '0',
`xtc` int(255) NOT NULL default '0',
`lsd` int(255) NOT NULL default '0',
`speed` int(255) NOT NULL default '0',
`opium` int(255) NOT NULL default '0',
`autojatten` int(10) NOT NULL default '600',
`autojattijd` datetime NOT NULL default '0000-00-00 00:00:00',
`werktijd` int(10) NOT NULL default '180',
`werken` datetime NOT NULL default '0000-00-00 00:00:00',
`baktijd` datetime NOT NULL default '0000-00-00 00:00:00',
`kluisgeld` bigint(255) NOT NULL default '0',
`zwitsersegeld` bigint(255) NOT NULL default '0',
`zwitsersehalen` bigint(255) NOT NULL default '50000000',
`zwitsersestorten` bigint(255) NOT NULL default '5000000',
`aankomst` varchar(20) character set latin1 default NULL,
`aankomststad` int(5) NOT NULL default '0',
`vliegen` datetime NOT NULL default '0000-00-00 00:00:00',
`puntenblackjack` int(5) NOT NULL default '0',
`puntencomp` int(5) NOT NULL default '0',
`kaarten` text character set latin1,
`kaartencomp` text character set latin1,
`draaitijd` datetime NOT NULL default '0000-00-00 00:00:00',
`draaien` int(40) NOT NULL default '10800',
`loten` int(4) NOT NULL default '0',
`hlronde` int(5) NOT NULL default '0',
`hlgetal` int(5) NOT NULL default '0',
`hl` int(50) NOT NULL default '300',
`hltijd` datetime NOT NULL default '0000-00-00 00:00:00',
`roulette` int(4) NOT NULL default '0',
`aangevallen` int(10) NOT NULL default '0',
`aanval` int(5) NOT NULL default '15',
`aanvaltijd` datetime NOT NULL default '0000-00-00 00:00:00',
`missionsfixed` text character set latin1,
`inzet` int(10) NOT NULL default '0',
`fbibom` int(10) NOT NULL default '0',
`stationkaarten` int(40) NOT NULL default '0',
`vliegveldkaarten` varchar(40) collate latin1_german1_ci NOT NULL default '0',
`chatlog` text character set latin1,
`chatlog_hulp` text character set latin1,
`kicked` int(5) NOT NULL default '0',
`oc` int(40) NOT NULL default '0',
`octijd` datetime NOT NULL default '0000-00-00 00:00:00',
`woning` varchar(5) collate latin1_german1_ci NOT NULL default 'Geen',
`woningtekst` text collate latin1_german1_ci NOT NULL,
`woonplaats` varchar(255) collate latin1_german1_ci NOT NULL,
`huisnaam` text collate latin1_german1_ci NOT NULL,
`strafpunten` int(5) NOT NULL,
`winkel` datetime NOT NULL,
`getawaytijd` int(15) NOT NULL,
`winkeltijd` int(15) NOT NULL,
`famvordering` int(255) NOT NULL default '0',
`steel2` datetime NOT NULL,
`steeltijd2` int(255) NOT NULL default '0',
`riptijd` int(15) NOT NULL,
`ripdeal` datetime NOT NULL,
`drank` int(15) NOT NULL,
`zak` int(15) NOT NULL,
`drankt` datetime NOT NULL,
`xp` int(15) NOT NULL default '10',
`scooterjatten` int(10) NOT NULL default '600',
`scooterjattijd` datetime NOT NULL default '0000-00-00 00:00:00',
`opgehaald` int(1) NOT NULL,
`code` int(10) NOT NULL default '918273645',
`opgehaald2` int(10) NOT NULL default '0',
`partner_trow` varchar(10) collate latin1_german1_ci NOT NULL default '',
`grup` varchar(10) collate latin1_german1_ci NOT NULL default '',
`mislukt` int(5) NOT NULL default '0',
`winst` int(255) NOT NULL default '0',
`fraudetijd` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`gelukt` int(5) NOT NULL default '0',
`type` int(1) NOT NULL default '0',
`ramen` int(255) NOT NULL default '0',
`hoeren` int(255) NOT NULL default '0',
`hoerenwerkend` int(255) NOT NULL default '0',
`hoerpimped` int(255) NOT NULL default '0',
`tabakmax` int(255) NOT NULL default '1',
`vannelleupgr` int(255) NOT NULL default '0',
`drumupgr` int(255) NOT NULL default '0',
`lmupgr` int(255) NOT NULL default '0',
`kentupgr` int(255) NOT NULL default '0',
`panterupgr` int(255) NOT NULL default '0',
`vannelle` int(255) NOT NULL default '0',
`drum` int(255) NOT NULL default '0',
`lm` int(255) NOT NULL default '0',
`kent` int(255) NOT NULL default '0',
`panter` int(255) NOT NULL default '0',
`pruimtabak` int(255) NOT NULL default '0',
`pruimtabakupgr` int(255) NOT NULL default '0',
`ban` varchar(255) collate latin1_german1_ci NOT NULL default '0',
`ban2` text collate latin1_german1_ci NOT NULL,
`ban3` varchar(50) collate latin1_german1_ci NOT NULL default '0000-00-00',
PRIMARY KEY (`id`),
FULLTEXT KEY `moordenaar` (`moordenaar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=75 ;
-- --------------------------------------------------------
Toon Meer
Heb je nog geen account? Registreer je nu en word deel van onze community!