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
Printable View
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