I got SPORA and WAMP5 set up, but for some reason it doesnt work how it should.
Can you please goto http://zidwow.homeip.net/ and try to create an account, and help me with the error it shows.
Thanks in advance
Printable View
I got SPORA and WAMP5 set up, but for some reason it doesnt work how it should.
Can you please goto http://zidwow.homeip.net/ and try to create an account, and help me with the error it shows.
Thanks in advance
Information needed. Btw your page doesnt work.
For Ascent I got a good spora I used when I tested the DB's in RaGezone.
http://mucski.evonet.ro/stuff/ascentnobug/ascentwww.rar
Go to config.php ... everything is self explanatory. 100% runs. Well at least it did for me.
Sorry, try now... Firewall was blocking access.
If the DNS domain doesnt work, you can also get to the page by going to:
Ziddy's WoW Server is offline
++ Bump ++
"Ziddy's WoW Server is offline"
Did you downloaded the spora I used? Mine worked fine with no MYSQL errors.Code:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479
I listed the link up there....
If you trying to install that Spora for Mangos , than it wont work because the table differs from Ascent ....
Its one that has been modified for Ascent
And yea, i tried your version and got the same problem.
post your index PHP file here. ill take a lookQuote:
Originally Posted by ziddy1232
Quote:
Originally Posted by mucski
carefull darling.....
your Config file in your download link has your information, i suggest to remove it. for your own security
Here you go... (I edited out my PW, it isnt actually ****)
[php]
<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
[quote=ziddy1232;3091879]Here you go... (I edited out my PW, it isnt actually ****)
[php]
<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
When i goto the page i see it, and its fine. I can access it through localhost and external I.P.
I am behind a router, and i have forwarded port 80, and disabled my firewall, but i still get the same issue.
And im from the U.K. My ISP is BT Broadband and i use thier router, called the BT Home Hub.
hmm ...Quote:
Originally Posted by ziddy1232
tell you the truth
i never got my wamp working with my ISP (videotron)
so i simply pay 2.99$ / month to webhostfreaks.com to host my php file
Yea, i think i might have to do the same...
Thanks for trying anyway
btw, i have sent you a PM :)
Edited post:
Please ignore what I had just originally posted, I actually thoroughly read it..
This is indicating that your number of rows (in this case, I believe it is your columns) in your accounts table, is counting a different amount than what it should be.Code:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479
Take a screenshot of your accounts table, and post it here.
Here you go...
[img=http://img176.imageshack.us/img176/2503/34993286mq8.th.jpg]
++EDIT++
Heres a slightly better view:
http://img176.imageshack.us/img176/4...5933at2.th.jpg
Wow for me worked everytime ... mhmm ... it did always.
I apologize, I wasn't right. Your table is completely fine. However, if that is being called bad in your .php file, go check it out, see what it is reading in. Could be a typo by someone. :P
I have no idea what the problem could be... I posted my .php file, so why dont you check it for a typo xP
Sorry wasn't paying attention to that.
Maybe this line is your culprit?
Code:if($realm_db->query("INSERT INTO `accounts` (`login`,`password`,`email`,`lastip`,`gm`,`banned`,`flags`) VALUES ('$username','$passw','$email','$ip','0','0','$tbc')"))
Sorry im a real noob when it comes to php...
What do i change?
Sorry for being such an idiot, its probably really obvious too
Perhaps rr2739 would have better knowledge of this than I would... I'm not really too sure why I highlighted that.
Okay, i have got some free hosting from x10 Hosting, and i have uploaded the files but im still getting the same error...
rr2739, could you take a look through my .php file for me?
Also, could you suggest any other simple registration page? I dont want a huge Blizzlike one as it takes forever to upload and configure, and im pritty lazy xD lol
Would be of much help if we can see your PHP page.
How do I fix this up:
Error: Unable to connect to MySQL server. MySQL reported: Can't connect to MySQL server on '[my ip filled in here]' (4).
Well.. When I fill in localhost it gives me this:
Error: Unable to connect to MySQL server. MySQL reported: Access denied for user 'root'@'localhost' (using password: YES). So idk what to do lol. Site is hosted at:
Bloody WoW. A part of the BloodyScape Comunity is offline
Does anyone has a solution?
well i hope that 127.0.0.1 / locahost is not in your index file right?Quote:
Originally Posted by ziddy1232
cause when someone else access it , localhost/127.0.0.1 means nothing.
so change it to your dyndns address or external ip
also jsut a thought.
can you kinda show me a picture of an error , caus eicant seem to find it ion this thread.
and to be sure. So everyting woprks , except others cant access your page?
Everything is working fine, and other people can connect.
Also, it shows who is online, and when the server is online correctly, but when you try and create an account you get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479
[PHP]<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
Well.. What do I fill in where the database is located when it is located on my comp?
Please help!!
~yupdead
[quote=Paco44;3094108][php]<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
Thanks rr2739, im trying it now.
btw, did you get my PM? Any luck with that...
Ok, i have set it up on some free webhosting i have, and its not giving the error anymore, but now it says that creating the account was not possible.
Can you goto Raw Unleashed WoW Server - Provided by ziddy1232 is offline and check it
lol ok, i know that problem as well.. EXPERIENCE FTWQuote:
Originally Posted by ziddy1232
so this is what u do
open your SQ!lyog or Navicat..
click on USERS
and add another user with the following info:
where it says HOST: put %
where u see username: put same user name u use for your MYSQL
and same goes for password. Username and pass must match your root user name and password
in section where it ask for hostm u only should have %
so host: %
user: same as MYSQl
pass: Same as MYSQl
now it will work!
P>S make sure to grant all permissions for the user you created
Or not...Quote:
Originally Posted by rr2739
http://img170.imageshack.us/img170/4...9456xb6.th.jpg
Quote:
Originally Posted by ziddy1232
ok you doing something wrong
since you using SQlyog ill post a guide how to add % host
her eis how:
1. Click on TOOLS (on top of your screen in Sqlyog)
2. then scroll over USER MANAGER
3. Then Select ADD USER
you will see a little window pop up
a. you will see
username
host
password
retype password
so
username - same as your MYSQL root
host - %
password: same as u use for Mysql
then on the bottom you will see a button called SELECT ALL , click that
then press create
and you done.
I did that, got the same error...
I think its because i already have that user created, and it has all permissions.
BUT, i still cant create an account - get the same error as before.
New link: Raw Unleashed WoW Server - Provided by ziddy1232 is offline
which NCDB u using and do you have MUTED collumn in your accounts table?Quote:
Originally Posted by ziddy1232
btw, the site is hosted on an external web server now, NOT on my system using WAMP.
Im pritty sure "%" is for localhost
its actualy for external hosts.. so they can access ur dbQuote:
Originally Posted by ziddy1232
i want to find out if you using latest NCDB and do you have MUTED?
if so..i will reprogram something quick for ya. to see if it works
I do have the Muted collumn
And to be honest, im not sure which im using... How can i find out?
Quote:
Originally Posted by ziddy1232
ok since you using my website includes..
you should have a folder called INCLUDE. inside that folder there is a file called include.php
so here is my edited one that works with muted..
(delet eur original include file, and replace it with this one)
include.zip - 5.1 Kb
Nope, i replaced it and im still getting the same error...
Im pritty sure its something simple im doing wrong, but it doesnt seem to have a simple solution.
can you tell me the values of your account table plzQuote:
Originally Posted by ziddy1232
like maybe u can link your table. i need to see that variables in your table. i am now jinxed with this problem :)
example
muted int 30 NULL OR NOT
i am using the same php files as you have downloaded
http://www.cosanostragame.com
Heres a screenshot of my accounts table, as far as i know its fine...
http://img135.imageshack.us/img135/5...7408xe9.th.jpg
muHHAA sorryQuote:
Originally Posted by ziddy1232
i need to see what you have in YOUR OBJECTS TAB
so on the same screen as you ar enow, click 1 time on objects and link screenie
This is everything that was on the Objects tab:
PHP Code:/*Column Information For - character.accounts*/
-----------------------------------------------
Field Type Collation Null Key Default Extra Privileges Comment
------------- ------------------- --------------- ------ ------ ------------------- -------------- ------------------------------- -------
acct bigint(20) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references
login varchar(255) utf8_unicode_ci NO PRI select,insert,update,references
password varchar(28) utf8_unicode_ci NO select,insert,update,references
gm varchar(27) utf8_unicode_ci NO select,insert,update,references
banned int(1) unsigned (NULL) NO 0 select,insert,update,references
lastlogin timestamp (NULL) NO 0000-00-00 00:00:00 select,insert,update,references
lastip varchar(15) utf8_unicode_ci NO select,insert,update,references
email varchar(50) utf8_unicode_ci NO select,insert,update,references
flags int(11) unsigned (NULL) NO 0 select,insert,update,references
forceLanguage varchar(5) utf8_unicode_ci NO enGB select,insert,update,references
muted int(30) (NULL) NO 0 select,insert,update,references
/*Index Information For - character.accounts*/
----------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
-------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- -------------
accounts 0 PRIMARY 1 acct A (NULL) (NULL) (NULL) BTREE
accounts 0 PRIMARY 2 login A 1 (NULL) (NULL) BTREE
accounts 0 acct 1 acct A 1 (NULL) (NULL) BTREE
/*DDL Information For - character.accounts*/
--------------------------------------------
Table Create Table
-------- -------------------------------------------------------------------------------
accounts CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(28) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`gm` varchar(27) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`banned` int(1) unsigned NOT NULL DEFAULT '0',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`flags` int(11) unsigned NOT NULL DEFAULT '0',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enGB',
`muted` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
i have completely diff schematicsQuote:
Originally Posted by ziddy1232
try using my account table..
so delete yours and replace it with this one
accounts.zip - 0.7 Kb
argh!!!
Still getting the same error, even with your accounts table!
Quote:
Originally Posted by ziddy1232
GAH!! man i was hoping that would fix the problem.
ther eis somethign wrong with your account table i am sure of it.
can you please post a pic of variables in OBJECT again with my new table instaled?
This is the objects tab with your accounts table:
PHP Code:/*Column Information For - character.accounts*/
-----------------------------------------------
Field Type Collation Null Key Default Extra Privileges Comment
------------- ------------------- --------------- ------ ------ ------------------- -------------- ------------------------------- ----------------------
acct int(10) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references Unique ID
login varchar(32) utf8_unicode_ci NO UNI (NULL) select,insert,update,references Login username
password varchar(32) utf8_unicode_ci NO (NULL) select,insert,update,references Login password
gm varchar(32) utf8_unicode_ci NO select,insert,update,references Game permissions
banned tinyint(3) unsigned (NULL) NO 0 select,insert,update,references Account Standing
lastlogin timestamp (NULL) NO 0000-00-00 00:00:00 select,insert,update,references Last login timestamp
lastip varchar(16) utf8_unicode_ci NO select,insert,update,references Last remote address
email varchar(64) utf8_unicode_ci NO select,insert,update,references Contact e-mail address
flags tinyint(3) unsigned (NULL) NO 0 select,insert,update,references Client flags
forceLanguage varchar(5) utf8_unicode_ci NO enUS select,insert,update,references
muted int(30) (NULL) NO 0 select,insert,update,references
/*Index Information For - character.accounts*/
----------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
-------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- -------------
accounts 0 PRIMARY 1 acct A 0 (NULL) (NULL) BTREE
accounts 0 a 1 login A 0 (NULL) (NULL) BTREE
/*DDL Information For - character.accounts*/
--------------------------------------------
Table Create Table
-------- ------------------------------------------------------------------------------------------------------------------
accounts CREATE TABLE `accounts` (
`acct` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
`login` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login username',
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login password',
`gm` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Game permissions',
`banned` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Standing',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
`lastip` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Last remote address',
`email` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Contact e-mail address',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Client flags',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enUS',
`muted` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=672388 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'
Quote:
Originally Posted by ziddy1232
ok i know why it doesnt work now.
i ran few test and got the same error msg
you must remove ALLOW NULL from LOGIN and PASSWORD under DEFAULT COLLUMN ONLY! Dont change anything else. Only under DEFAULT COLLUMN
the only (NULL) you must have is on ACCount
How do i delete them? If i delete them they just keep coming back.
Sorry for being such a noob with this - The server im okay with, the site im crap with
no worries m8Quote:
Originally Posted by ziddy1232
her eis how:
OPne your SQlyog, click on little Plus next to Account Table on your left, it will bring up 3 folders ,
1. Collumn
2. Indexes
3. Trigers
You want to click on Columns
it will now bring a little list
click one time on 1st one , it should be Acct[int(10 0 somethign like that
right click with your mouse and select Manage Collumns
Now you will see a small lsit with alot of check marks everyhere lol
so all you interested in is 6th row from left to right called
"NOT NUL"
so now need to make sure that THERE IS a check mark in NOT NULL column on everything except Last one, where you see blank selection (if ther eis any)
That is already what was set there...
http://img152.imageshack.us/img152/9...5233tb8.th.jpg
try this Character/Logon structureQuote:
Originally Posted by ziddy1232
3461_character_structure.zip - 5.1 Kb
Nope, that one didnt work either.
I am using a different one now, it is a 2.3.3 enGB character database from here: [Ascent][NCDB] Daily Server Updates [03-02-08] - MMORPG Development Forums - RaGEZONE (sponsored by TFN.gr)
It has the correct things you told me to do (get rid of the NULL on login and pw), but it still isnt working.
Here is the objects table from it:
PHP Code:/*Column Information For - character.accounts*/
-----------------------------------------------
Field Type Collation Null Key Default Extra Privileges Comment
------------- ------------------- --------------- ------ ------ ------------------- -------------- ------------------------------- -------
acct bigint(20) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references
login varchar(255) utf8_unicode_ci NO PRI select,insert,update,references
password varchar(28) utf8_unicode_ci NO select,insert,update,references
gm varchar(27) utf8_unicode_ci NO select,insert,update,references
banned int(1) unsigned (NULL) NO 0 select,insert,update,references
lastlogin timestamp (NULL) NO 0000-00-00 00:00:00 select,insert,update,references
lastip varchar(15) utf8_unicode_ci NO select,insert,update,references
email varchar(50) utf8_unicode_ci NO select,insert,update,references
flags int(11) unsigned (NULL) NO 0 select,insert,update,references
forceLanguage varchar(5) utf8_unicode_ci NO enGB select,insert,update,references
muted int(30) (NULL) NO 0 select,insert,update,references
/*Index Information For - character.accounts*/
----------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
-------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- -------------
accounts 0 PRIMARY 1 acct A (NULL) (NULL) (NULL) BTREE
accounts 0 PRIMARY 2 login A 1 (NULL) (NULL) BTREE
accounts 0 acct 1 acct A 1 (NULL) (NULL) BTREE
/*DDL Information For - character.accounts*/
--------------------------------------------
Table Create Table
-------- -------------------------------------------------------------------------------
accounts CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(28) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`gm` varchar(27) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`banned` int(1) unsigned NOT NULL DEFAULT '0',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`flags` int(11) unsigned NOT NULL DEFAULT '0',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enGB',
`muted` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Quote:
Originally Posted by ziddy1232
you have Primary key on both acc and login
i am sure its a small problem that i am not seeing cause i mean i am not there with you. however. the table you jsut linked has both primary keys act and login
i really would sugest yousing 3461, and add muted after instaling 3461, after 3461 ther eis no updates anyway. so
Im going to try out your repack...
See if i can get it working with that one.
Okay, i thought i would Bump this instead of starting a new topic...
I got it working on WAMP, but now other people cant access my page o.O
Can you please goto http://zidwow.homeip.net/registration/index.php and see if it works for you
nope... can't see it.
I got this error to :( how did you make it work?
well . edited : i got same problem >_> .....
Creation of player
xxxx
was not possible!
I have a problem to
I get this error when i try to make a account on my DNS site even on my Local i have the same problem.
This is the error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 476
Please help me with this