NukeSilo Community

It is currently 22 Nov 2024, 15:28

All times are UTC-06:00




Post new topic  Reply to topic  [ 13 posts ] 
Author Message
 Post subject: Mysql
PostPosted: 23 Feb 2006, 14:36 
Offline
NukeSilo | Regular
User avatar

Joined: 28 Dec 2005, 16:06
Posts: 559
Location: Cya.
Ok I said b4 me and my friends were gonna have a TSRP LAn Game i got the plugins everything working I Know alot about amxx and hlds since i used to run a cs server off my pc. Now im a newbie at mysql idk much about it Thats all i need to know to run this lan.

Any of u guys can help me.
Lan Game is on Saturday night!

i still got time!

_________________
Image


Top
 Post subject:
PostPosted: 23 Feb 2006, 15:32 
Offline
NukeSilo | This is my Home Page
User avatar

Joined: 09 Apr 2005, 22:33
Posts: 1621
Location: Someplace... Job: Retired Chief
google "mysql 4.1" and install

_________________
-Dest Romano

That's like going to a murder scene in which somebody has just died and jumping in front of the camera and saying "I DID! PAY ME MY MOTHA fu**' MONEY!" -Jared Damare

Dest was the best chief on our server ever. -Supernuker
Image


Top
 Post subject:
PostPosted: 23 Feb 2006, 15:55 
Offline
NukeSilo | Regular
User avatar

Joined: 31 Aug 2005, 03:02
Posts: 674
Location: Washington State
Why would you play TSRP on a lan?

_________________
Quote:
[18:05] Deebz: i voted jesse
Quote:
Madoif: I voted Jesse.
Deebz: me too
zdrok: so did I
Quote:
[18:08] Deebz: Jesse gave me hope
[18:08] Deebz: Praise Jesse


Top
 Post subject:
PostPosted: 23 Feb 2006, 16:15 
Offline
NukeSilo | Regular
User avatar

Joined: 28 Dec 2005, 16:06
Posts: 559
Location: Cya.
its on a media center 2 long to explain.. but i know mysql i've installed it,its just that idk whats it for? like i got the ooc chat etc working but the jobs etc dont work

_________________
Image


Top
 Post subject:
PostPosted: 23 Feb 2006, 18:55 
Offline
NukeSilo | Regular
User avatar

Joined: 31 Aug 2005, 03:02
Posts: 674
Location: Washington State
Economy mod isnt working you mean?

_________________
Quote:
[18:05] Deebz: i voted jesse
Quote:
Madoif: I voted Jesse.
Deebz: me too
zdrok: so did I
Quote:
[18:08] Deebz: Jesse gave me hope
[18:08] Deebz: Praise Jesse


Top
 Post subject:
PostPosted: 06 Mar 2006, 02:26 
Offline
NukeSilo | Light Poster
User avatar

Joined: 02 Jun 2005, 23:34
Posts: 276
Location: Pensacola, Florida
you need to make sure your using amxx 1.01 for TS and follow this guide

http://steve.finalseconds.com/harbutut/

_________________
Akhiv in the House~! Vote for Jesse
Image


Top
 Post subject:
PostPosted: 06 Mar 2006, 14:13 
Offline
NukeSilo | Regular
User avatar

Joined: 28 Dec 2005, 16:06
Posts: 559
Location: Cya.
i did use that guide but still nothing anyone wanna help me priv.

_________________
Image


Top
 Post subject:
PostPosted: 06 Mar 2006, 14:36 
Offline
NukeSilo | Regular

Joined: 01 Oct 2005, 20:16
Posts: 598
Exactly what is wrong?

security messing everything up? Well how long will it be up, if its LAN no hacker will get any good out of breaking in, so you dont really need a pass on your server. Also if it is up for a short time then there is no worries about security breaches.

Instance wont load? Mainly if security and passes are wrong you will find problems like this, there is another reason I cant remember, I think its the configs being messed up, so to fix, delete you SQL server and reinstall it, everything from scratch.

I dont know how to load the data base with the right s*it? Download the program SQLYog (dont worry, its completely free and easy to use). Now inside the .zip file with the files for harbus find "economy.sql" Make sure it is extracted and you can find it easy (like on the desktop, its temp where ever you leave it) and an option in there (not sure exactly where but it is a drop down menu, either at the top or right click inside where DBs are located) will be "Import from SQL dump." From there find your economy.sql and it will be uploaded to the server.

Harbu's mod wont connect correctly? Biggest and most common issue here. Make sure you firewall is not blocking the connections to SQL, do this by unblocking the that your SQL server is using (default 3306) and allow only IP's "localhost" or "127.0.0.1" (both mean the same comp its on, use that for harbu_rp_config.cfg as well; make sure you have SQL on the same comp or the lag will be some insane). Also make sure in "TS/addons/amxmodx/configs/harbu_rp_config.cfg" has the correct info for your server.

Harbu's wont load or work at all? This is quite common, for harbus mod to work you HAVE to get AMX mod X version 1.01 (not 1.6, 1.65 or 1.7!). And make the rest work or this wont!

Namely those, that is my quick 15 post fix on Harbu's. Post again if you still have problems


Top
 Post subject:
PostPosted: 06 Mar 2006, 15:59 
Offline
NukeSilo | Regular
User avatar

Joined: 28 Dec 2005, 16:06
Posts: 559
Location: Cya.
ok Thats helpfull thanks But pretty Much all I have is the ooc etc, Idk I cant get the jobs to work idk how to add them. I know it has summ to do with mysql. Do U have to add them trought mysql?

_________________
Image


Top
 Post subject:
PostPosted: 06 Mar 2006, 17:54 
Offline
NukeSilo | This is my Home Page
User avatar

Joined: 09 Apr 2005, 22:33
Posts: 1621
Location: Someplace... Job: Retired Chief
amx_help

amx_addjob

_________________
-Dest Romano

That's like going to a murder scene in which somebody has just died and jumping in front of the camera and saying "I DID! PAY ME MY MOTHA fu**' MONEY!" -Jared Damare

Dest was the best chief on our server ever. -Supernuker
Image


Top
 Post subject:
PostPosted: 07 Mar 2006, 13:59 
Offline
Banned
User avatar

Joined: 27 Dec 2005, 08:34
Posts: 634
Location: New York
I cant get my server to work at all.

_________________
Image


Top
   
 Post subject:
PostPosted: 07 Mar 2006, 14:06 
Offline
NukeSilo | Regular
User avatar

Joined: 28 Dec 2005, 16:06
Posts: 559
Location: Cya.
Another problem when i joined it says pub:Name so i type amx_regname USername and pass and i register but for some reason my name it still pub and it still tells me to register

_________________
Image


Top
 Post subject:
PostPosted: 07 Mar 2006, 15:22 
Offline
NukeSilo | Regular

Joined: 01 Oct 2005, 20:16
Posts: 598
That means your server is not currectly connected to the SQL server


Top
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 13 posts ] 

All times are UTC-06:00


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited