Hello,
Ok first of all ill explain what it is im trying to do.
Im making a module that will work with PHPNuke. Its a 50/50 draw module.
You pick a number from 1 - 100, each number may only be used once. One number will be drawn and whoever has choosen that number wins.
Sounds simple ... I thought lol
So what I have done is created the table 5050 with rows username, email and number.
My script is "supposed to" check to be sure the number hasn't been choosen, send out a confimation email and upon confermation insert the data.
However im getting an error which im sure is over some small thing I am overlooking, so a fresh set of eyes would be very welcomed at this point.
'<?php
if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
die ("You can't access this file directly...");
}
require_once("mainfile.php");
$module_name = basename(dirname(FILE));
get_lang($module_name);
function userCheck($number) {
global $stop, $db;
if ($db->sql_numrows($db->sql_query("SELECT number FROM 5050 WHERE number='$number'")) > 0) $stop = "<center>"._NUMBERTAKEN."</center><br>";
return($stop);
}
function confirmNewUser($number) {
global $stop, $sitename, $module_name;
include("header.php");
include("config.php");
filter_text($username);
$username = $EditedMessage;
userCheck($number);
if (!$stop) {
title("".NUMBERTAKEN."");
OpenTable();
echo "<center><b>".SRYNUMTAKEN."</b><br><br>"
.""._GOBACK."</center>";
CloseTable();
include("footer.php");
die();
}
title("$sitename: "._ENTERDRAW."");
echo "<center><b>"._ENTRDRAW."</b><br><br>$number, "._USERCHECKDATA."</center><br><br>"
."<table align='center' border='0'>"
."<tr><td><b>"._UUSERNAME.":</b> $username<br></td></tr>"
."<tr><td><b>"._EMAIL.":</b> $email</td></tr>"
."<tr><td><b>"._NUMBER.":</b> $number<br></td></tr></table><br><br>"
."<center><b>"._NOTE."</b> "._YOUWILLRECEIVE."";
echo "<form action=\"modules.php?name=$module_name\" method=\"post\">"
."<input type=\"hidden\" name=\"username\" value=\"$username\">"
."<input type=\"hidden\" name=\"email\" value=\"$email\">"
."<input type=\"hidden\" name=\"number\" value=\"$number\">"
."<input type=\"hidden\" name=\"op\" value=\"finish\"><br><br>"
."<input type=\"submit\" value=\""._FINISH."\"> "._GOBACK."</form></center>";
CloseTable();
include("footer.php");
function finishNewUser($username, $email, $number) {
global $stop, $EditedMessage, $adminmail, $sitename, $Default_Theme, $user_prefix, $db, $storyhome, $module_name, $nukeurl;
include("header.php");
include("config.php");
userCheck($number);
if (!isset($stop)) {
Header("Location: modules.php?name=$module_name");
die();
}
$finishlink = "$nukeurl/modules.php?name=$module_name&op=activate&number=$number";
$db->sql_query("INSERT INTO 5050 (username, email, number) VALUES (NULL, '$username', '$email', '$number')");
if(!$result) {
echo "".ERROR."<br>";
} else {
$message = "".WELCOMETO." $sitename!\n\n ".TOFINISHUSER." \n\n $finishlink\n\n ".FOLLOWINGMEM." \n\n ".UUSERNAME." $username\n ".NUMBER." $number";
$subject = "".ACTIVATIONSUB."";
$from = "$adminmail";
mail($email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
title("$sitename: ".SUCCESS."");
OpenTable();
echo "<center><b>".CONFIRMED."</b><br><br>";
echo "".YOUAREREGISTERED.""
."<br><br>"
.""._THANKSUSER." $sitename!</center>";
CloseTable();
include("footer.php");
}
function activate($number) {
global $db, $user_prefix, $module_name, $language;
$db->sql_query("INSERT INTO 5050 (username, email, number) VALUES (NULL, '$row[username]', '$row[email]', '$row[number]')");
include("header.php");
title("".ACTIVATIONYES."");
OpenTable();
echo "<center><b>$row[username]:</b> ".ACTMSG."</center>";
CloseTable();
include("footer.php");
die();
}
function new_user() {
global $module_name, $db;
include("header.php");
OpenTable();
echo "<form action=\"modules.php?name=$module_name\" method=\"post\">\n"
."<b>".ENTER."</b> (".ALLREQUIRED.")<br><br>\n"
."<table cellpadding=\"0\" cellspacing=\"10\" border=\"0\">\n"
."<tr><td>".NICKNAME.":</td><td><input type=\"text\" name=\"username\" size=\"30\" maxlength=\"25\"></td></tr>\n"
."<tr><td>".EMAIL.":</td><td><input type=\"text\" name=\"email\" size=\"30\" maxlength=\"255\"></td></tr>\n"
."<tr><td>".NUMBER.":</td><td><input type=\"text\" name=\"number\" size=\"11\" maxlength=\"40\"></td></tr>\n";
echo "<tr><td colspan='2'>\n"
."<input type=\"submit\" value=\"".SUBMIT."\">\n"
."</td></tr></table>\n"
."</form>\n"
."<br>\n"
."".YOUWILLRECEIVE."<br><br>\n"
."".RULES."<br>\n"
."<ul>\n";
CloseTable();
include("footer.php");
}
?>'
Help please 🙁
