i need some help

[Solid Snake]

i need some help with doing mysql can anyone help

[spellbyte ®]

Re: i need some help

can you be more specific as per your needs

[Solid Snake]

Re: i need some help

 

can you be more specific as per your needs

 

I need my mods put into mysql but im not that good at placing them in the game and i think i might some errors fixed in my scripts

[spellbyte ®]

Re: i need some help

did the mods not come with instructions on how to install them

[Solid Snake]

Re: i need some help

 

did the mods not come with instructions on how to install them

i have uploaded them to the database but i dont know MySQL

[UCC]

Re: i need some help

anyone else as confused as I am?

[Decepti0n]

Re: i need some help

me me me

[spellbyte ®]

Re: i need some help

i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH

[Solid Snake]

Re: i need some help

 

i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH

 

no i know a bit about programming but i have never tried this sort of programming the only bit know is how to put them onto the database its just the quarries i dont get

[lem0n]

Re: i need some help

have you got the queries?

[Solid Snake]

Re: i need some help

 

have you got the queries?

 

Yes i got them

[Vorlen]

Re: i need some help

 

i think what we have here is yet another person who knows absolutely jack about programming or how to setup a DB, either that or he has got some bum mods without the SQL queries, or BOTH

 

no i know a bit about programming but i have never tried this sort of programming the only bit know is how to put them onto the database its just the quarries i dont get

 

I presume you mean you know how to upload the files, but not update the DATABASE (A database is the mySQL Database, not the file folder.)

Take the queries that you have, open phpmyadmin and find your database. Click on it. Click SQL and put the queries there. Hit GO. If there is an error, report it here.

 

Even then, you probably want to learn alot more about coding before actually opening a site. No, I'm not insulting you. I had to do the same when I started. :P

[Solid Snake]

Re: i need some help

i have tried mate

could anyone show me an example of creating one

[Solid Snake]

Re: i need some help

ok what have i done wrong here

 

Error

SQL query:

CREATE TABLE `adminlogs` (

```adID``` INT( 11 ) NOT NULL AUTO_INCREMENT ,

```adUSER``` INT( 11 ) NOT NULL DEFAULT 'default',

```adPOST``` LONGTEXT NOT NULL ,

```adGET``` LONGTEXT NOT NULL ,

```adTIME``` INT( 11 ) NOT NULL DEFAULT 'default'

) ENGINE = MYISAM

MySQL said: Documentation

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

[Solid Snake]

Re: i need some help

 

ok what have i done wrong here

 

Error

SQL query:

CREATE TABLE `adminlogs` (

```adID``` INT( 11 ) NOT NULL AUTO_INCREMENT ,

```adUSER``` INT( 11 ) NOT NULL DEFAULT 'default',

```adPOST``` LONGTEXT NOT NULL ,

```adGET``` LONGTEXT NOT NULL ,

```adTIME``` INT( 11 ) NOT NULL DEFAULT 'default'

) ENGINE = MYISAM

MySQL said: Documentation

#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

 

i need to know what i did wrong

[UCC]

Re: i need some help

In order to use auto_increment, the field must be defined as a primary key

[Solid Snake]

Re: i need some help

 

In order to use auto_increment, the field must be defined as a primary key

i figured that out a very long time ago, now im stuck on users

`gender` is the one im stuck on in the users SQL i cant seem to get the default bit right tell me how please

[Solid Snake]

Re: i need some help

i keep getting this message whats wrong

Unknown column 'userid' in 'field list'

[spellbyte ®]

Re: i need some help

well it would appear that you are missing the userid field from your table, post the entire table here and i'll tell u if ur missing anything else

[Solid Snake]

Re: i need some help

 

well it would appear that you are missing the userid field from your table, post the entire table here and i'll tell u if ur missing anything else

Field Type Collation Attributes Null Default Extra Action

`userid` int(11) No auto_increment

[Solid Snake]

Re: i need some help

new error

Warning: main(global_func.php) [function.main]: failed to open stream: No such file or directory in /home/maddogda/public_html/loggedin.php on line 22

Fatal error: main() [function.require]: Failed opening required 'global_func.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/maddogda/public_html/loggedin.php on line 22

but when i take out the _ from global_func the errors says uknown us_userid` on `on_clause`

whats that

[Solid Snake]

Re: i need some help

 

new error

Warning: main(global_func.php) [function.main]: failed to open stream: No such file or directory in /home/maddogda/public_html/loggedin.php on line 22

Fatal error: main() [function.require]: Failed opening required 'global_func.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/maddogda/public_html/loggedin.php on line 22

but when i take out the _ from global_func the errors says uknown us_userid` on `on_clause`

whats that

 

that error has gone the bit left is

Unknown column 'us.userid' in 'on clause'