[Ibrahim.E]

Great (:

[sam1929]

I can not download it please upload it some other place thank you

[-=TheShadow=-]

Quote:

Originally Posted by Aarab Can someone explain me about the DATABASE shit? I tried to import this but it gives me an error. Код: TABLE 'users' id online name bank ajailed Warrent AddInfo paydays dice age jobtime money reduce OnTime admin mats skin jail RB c4 faction rank job Gender gunslot1,ammoslot1 ... ... gunslot19,ammoslot19 ban ck ip rent rentpay pbook pager DetSkill DrugsSkill drugs speeding recklessdriving TABLE 'houses' owner(str,def=No) bank(int) id(int) price(int) x y z pid worldid rooms locked info TABLE `cellphones` number(int) ID(playerid) shownum TABLE `pager` Number(int) ID(playerid) TABLE `groups` leader TABLE `ranks` `1`,`2`,`3`,.....`20`,`300` TABLE `factions` (FIRST ONE IS the CIVILIANS) id type i x y z name salary diff TABLE `pddatabase` name (s) reporter (s) //string (s) reason(s) date(s (d.d.d)) time(s (d.d.d)) TABLE `interiors` id int x y z a TABLE `vehicles` id type x y z r color1 color2 plate armor vid windows gpsed lock locked price TABLE `objects` id fid mid oid state message x y z rx ry rz fast TABLE `teleports` id x y z i pid inhouse w x2 y2 z2 i2 inhouse2 w2 TABLE `admintems` id perm name TABLE `ranks` id TABLE `ATM` ID x Y Z TALBE `gpsarea` id r string `ranks`1 1=Last 2..9=NO 10=Oo 11=No 12...18=No 19=No 20=No TABLE `bugs` reporter bug TABLE `reports` id reporter reported hour min day month year report accepted endreport TABLE carlist id price TABLE `mayors` name votes TABLE `voted` name TABLE donated name

What do you mean by "tried to import it"?


*Added new links

[Alex Magaсa]

Quote:

Originally Posted by -=TheShadow=- What do you mean by "tried to import it"? *Added new links

He means he tried to import tables in MYSQL but (it wouldn't work)!

[-=TheShadow=-]

Quote:

Originally Posted by Alex Magaсa He means he tried to import tables in MYSQL but (it wouldn't work)!

1. you have to create a databse, that something that i did not implent in the query.
2. after you create the database, you should run whats in the "code" as a quary, that should work, tell me if it doesnt.
3. Also you have to create a file "mysql.txt", the file hsould be in the follow style: ((* NOTE : For it to work you HAVE to delete the file "myserver.txt" from scriptfiles foulder ))

Код:

ip=*the ip of the sql server*
username=*usename*
pass=*password*
db=*name of the database*

[michaelcosyns]

Lots of lines

[sam1929]

Quote:

Originally Posted by -=TheShadow=- What do you mean by "tried to import it"? *Added new links

ty bro and i think i was a member of this Samp Game Server a long long long long long time ago i can not bel it's here now Thank You TheShadow for giving it to us +Rep Bro

[Pottus]

This looks like is was scripted fairly decently good job on that.

[Ponii]

Not bad for 13k lines xd.
Got all basic stuff nice.

[-=TheShadow=-]

Thanks everyone, I added command list to the main topic (I bet i forgot some commands)

[Mr.Collins]

Anyone here knows how I make myself admin?

[nati5860]

Do I have to create the mysql tables myself by the format you posted in this thread? or I just put this format somewhere? Thanks.

[JoshuaMcCross]

Nice GM

[ProShooter22]

nice...

[edgargreat]

Other links please? I wanna try this script. I can't download on your links.

[Krisna]

hey bro
how to fix?
and how to create a sql table?

Quote:

[16:51:41] Connection to MySQL database: Successfull ! [16:51:41] Error in mysql_query: Table 'sgrp.donated' doesn't exist [16:51:41] Error in mysql_query: Table 'sgrp.users' doesn't exist [16:51:41] Error in mysql_query: Table 'sgrp.objects' doesn't exist [16:51:41] Error in mysql_query: Table 'sgrp.objects' doesn't exist [16:51:41] Error in mysql_store_result: Table 'sgrp.objects' doesn't exist

[CombatFire]

Thank you

[iHaze.]

Great, Keep going! (: