Jump to content
MakeWebGames

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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'

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...